G/L Account wise Inventory Report

[Former Member]

Hi All....

I know the transaction S_P00_07000139.In this I am not getting G/L Acct.

I want inventory report G/L Account wise

i.e Opening qty,Opening Value,Receipt Qty,Receipt Value,Issue Qty,Issue Value & Closing Qty,Closing Value.with G/L Account wise.

Please help me.

Thanks in Advance.

Regards,

Atul

[Former Member]

Did you check MB5L or RM07MMFI. this may help.

[Former Member]

Hi,

You have to develop a customized report with the following info

SAP Field Name System Field Name Table Location DDA Translation

SAPAsset Number ANLN1 ANLA SAP Asset Number

Original Asset AIBN1 ANLA DDA Asset Number

Cost Center KOSTL ANLZ Department

Account Deter KTOGR ANLA GL Account Number

Asset Class ANLKL ANLA Asset Class

Asset Description TXT50 ANLA Description

Acquisition Value ANSWL ANLC Cost

Net Book Value LFD_BCHWRT RA03W Net Book Value

Ordinary Deprec NAFAG ANLC Accum Reserve

Capitalized On Date AKTIV ANLA Depr Start Date

Location STORT ANLZ Location Code

Supplier LIEFE ANLA Vendor Name

License Plate # KFZKZ ANLZ Invoice Number

Type Name TYPBZ ANLA Purchase Order Number

Tax Office FIAMT ANLA Requester/Resp. Person

Assignment Note EHWNR ANLA Project Number

Control Number

TBD - SAP PO Number SAP PO Number

Thanks,

Vasanthan

[Former Member]

Hi

Try with KSB1

It will not show opening, closing. But u can find the cost over a period.

Regards,

Raman

[Former Member]

Hi,

As per my understanding there is no report to see the inventory G/L Account wise with Opening qty,Opening Value,Receipt Qty,Receipt Value,Issue Qty,Issue Value & Closing Qty,Closing Value

[labindia123]

I also want the same report in SAP B1