diff in stocck G/L account and Inventory reports

[Former Member]

Hi All...,

I want some help...,

My problem is my, inventory valuation method is FIFO basis.

The amount in Rawmaterial Account is (ex:5000)

But inventory Status report system is showing (Ex:5400). I am taking Status Report based on Last Purchase Price,Last Evaluated Price) than also my staus report and Audit report is not matching.

My inventory audit report system is showing (Ex:8000).Inventory audit report is based on Quantity*Item cost(Last Eavluated Price).

All inventory reports in SAP B1 are not matching to my G/L balance.

How can i take Inventory closing Report.(Inventory report Total has Excatly match to my G/L amount)

[former_member187989]

hi,

Go for inventory audit report,select option summarize by accounts.

Have they did any direct JE using inventory account ?

If yes,then it will effect stock value.

Jeyakanthan

[Former Member]

Hai!

Whtz ur GL Accounting system?

Whtz ur Inventory,Allocation,PriceDifference,revenue,sales return,sales credit,Increase,Decrease Acc's?

The difference may be because of ur GL Acc setup.

Regards,

Thanga Raj.K

[Former Member]

Hi Thq for ur reply....

My G/L account is

Raw Material Account,I had taken set G/L ac by Item group wise. I assign the rawmaterial in Inventory account row.

Is there any report. Say My Rawmaterail G/L balance is 2000

I want to know Item(Product) wise balance.

[Former Member]

venila..

G/L Acc balance of RawMaterial Acc may not equal to the closing balance value showing in Audit report.

This is because of Account settings you have done in your Item Group.

Example:

My Item Group Setup is like this:

Inventory Acc - Raw Material Acc

Allocation Acc - GRNI Acc

Price Diff Acc - Raw Material Acc

1. I raised a GRPO for 2 qty * INR 100 unit Price

2. G/L Balance of Raw Material - INR 200

3. I raised Inventory Transfer of those quantity to some other warehouse

4. I raised A/P invoice for the same GRPO changing Price to INR 110

5.Now,G/L Balance of Raw Material - INR 220

6. But, Audit report will show only closing value as INR 200

The G/L Acc of Raw Material doesnot match with Inventory Audit report in this case.

Try to find, if such transactions had gone.

Regards,

Thanga Raj.K