Dynamics Community Forum Thread Details

Negative Adjustment - Net Invoiced Quantity

Good Afternoon,

We are running our Inventory Valuation Report and and it is bringing up a number of negative values. These appear to be items that have been receipted in to our warehouse to appear on the inventory, but that have not yet been invoiced by the vendor. This all makes sense.

We are however experiencing a problem with some negative figures in the report that do not fit the scenario above. The screen snip shows that we have none of one particular item in stock but -67 in the net invoiced quantity. This is the case in that we have none in stock as we had to write off 67 last week. This is a genuine action as they were not present at the stock take, but does anyone know please if there is a way / function we need to be taking, to avoid there being a negative in the net invoiced quantity? Is there another way we should be doing stock write off's that would eliminate this happening.

Thanks in advance,

Amy

Hi Amy,

Thank you for posting on the Microsoft Dynamics 365 Business Central Forum.

Typically, when 0 Quantity in total exists but negative Invoiced Quantity is reflected on the Item Card, there is an open Purchase Order with Received Quantity that has not been Invoiced or a Production Order that is open but not Finished with Adjust Cost Item Entries processing to adjust the cost and move the Cost Amount (Expected) to Cost Amount (Actual) status and updated Invoiced Quantity on the Value Entries and linked Item Ledger Entries. There may be Sales Orders Shipped and Invoiced against the Received-only Inventory, so the Outbound Entry has been Invoiced but the Inbound - Purchase Received quantity has not been invoiced, so you have negative Invoiced Quantity in total. The only way to get to 0 Invoiced in total would be to Invoice the Item Ledger Entries that have yet to be invoiced. I hope this helps.

Have a great weekend.

Best Regards,

Tom

Quick Links

Leaderboard