Inventory - Quantity Discrepancy

[#1]

Why do I show the correct quantity at the item master level but incorrect qty/value at the inventory valuation/audit report level?

We have just taken physical inventory - we entered our results into inventory tracking then posted using inventory posting.

When I check quantity of items using Item Master Data - "Inventory Data" Tab displays correct quantities in all warehouses.

My problem is when I run the "inventory valuation" or "Inventory Audit" Report - the results show quantities and values for items that we do not physically have - we posted "0u201D qty during our inventory posting and the system reports think we have "1".

The values appear to have been brought over during our initial migration as a u201Cgoods receiptu201D but I would assume that posting the current and correct quantities during physical inventory would correct the valuation reports.

Please help!

Andrew

SAPB1 2007A (8.00.177) SP 00 PL 41

[jitin_chawla · Accepted solution]

Hi,

Please run the below query and see if there is any result :

select t1.*,t2.onhand from

(select itemcode,warehouse,sum(inqty-outqty) as 'sum' from

oinm group by itemcode,warehouse) as t1

inner join oitw t2 on t1.itemcode=t2.itemcode and t1.warehouse=t2.whscode

where t1.sum!=t2.onhand

Kind Regards,

Jitin

SAP Business One Forum Team

[andrewbleier · Accepted solution]

Thank you for this query - this produced a list of 517 items whicih demonstrate the same issues we are seeing.

Item Master Data / Items Status = correct values

Inventory Audit/Valuation Report = incorrect values

VERY HELPFUL QUERY - the question now is, what next?

Is this caused by the bug which was fixed in 2007A? I have read about the "Inventory Valuation Check-up" which i have requested our VAR look into....The VAR is currently trying to determine if our data was upgraded from 2005 or loaded directly into 2007.

Any info you can point me to is most appreciated!

Thank you!

[Former Member · Accepted solution]

Andrew,

I have had at-least 2 customer of mine who had similar issues and the determination was that it was an issue in the older versions of SBO which got transferred to 2007

Suda

[andrewbleier · Accepted solution]

And am i correct that the fix included updating to the most current patch level and uploading the production DB to SAP for an IVC service report/repair? If yes, do you know approximtely how long it took to have the DB repaired?

Thank you again for your help with my simple querry - it worked perfectly!

Andrew

[Former Member · Accepted solution]

Andrew,

In my case, I have to give all credit to SAP specialist support resources who helped through the process and recommended corrective steps. This whole process should not take more than a few days

Suda

[jitin_chawla · Accepted solution]

Hi,

It seems to be database inconsistency. You need to log in a support ticket to get the issue investigated regarding the reported issue.

Kind Regards,

Jitin

SAP Business One Forum Team

[Former Member]

Andrew,

It would be better if you could post the screen shot link for your inventory audit report related to your issue.

Thanks,

Gordon