Inverntory Report for SAP B1

[Former Member]

Hi,

We are aabout to do a invntory check across our whole warehouse, i have used the stock audit report to pull a list of items and their value off SAP, is this the correct report to use and should this therefore match the appount sat in stock on my chart of accounts?

Thanks

[Former Member · Accepted solution]

HI,

Yes it is.

Use it by G/L Accounts (posting date as selection) , and check the G/L accounts by FI for all warehouses (if cost price by wh is not marked).

IF not fit, you shoud send the database for IVI /IVC

for fast check you can use the following query:

select sum(transvalue) from OINM
-- fiiting with 
select sum(debit-credit) from JDT1 where Account IN (select stockAct from oINM group by stockAct)

If not fit, please check SBO 2007 landing page -> Inventory Valuation CheckUp.

until B12007pl49 there are some issues.....

Regards,

J.