Inventory Valuation Report

[Former Member]

Hi,

I have a client using a periodic stock system. They occasionally have stock items that do go into negative quantities.

When I run an inventory valuation report I get an information message at the bottom that says..."Negative balance found, stock has been recalculated" The lines are displayed in green on the report.

None of the items have a negative quanity, so I am confused as to exactly what this means?

Regards

[Former Member]

Hi Peter,

The Audit report can only be used in a continuous inventory system. When using periodic inventory the valuation report is the only one available.

[Former Member]

Hi Grant

Try using the Stock Audit Report as the Valuation Report is only to view what the stock would be valued at using a different valuation method or specific price list.

Kind regards

Peter Juby

[Former Member]

Hi,

I am on PL47 2007A

Thanks

[jitin_chawla]

Hi,

Please update us with the version and the patch level.

Also check Note no. : 970753 regarding the issue.

Regards,

Jitin

SAP Business One Forum Team

[Former Member]

What is your B1 version and PL?

If they have multiple warehouses, check if they have any warehouses got negative quantities although the item on hand is >0.

Thanks,

Gordon