Views:

Applies to Product - Dynamics 365 Business Central
 

What’s happening?
Negative quantity is displayed in the Inventory Valuation report despite normal inventory transactions being conducted without allowing negative quantities.
 

Reason:
This appears to be related to value entries for specific items in the inventory system. It may be caused by missing or incorrect entries in the Value Entry table, particularly if the invoiced quantity is not filled correctly.
 

Resolution:
NOTE: It is recommended to test these changes in a sandbox environment before applying them to the production database to understand the impact and duration of the process.

  1. Check the value entries for the affected item to ensure they are accurate and complete.
  2. Before generating the Inventory Valuation report, run the "Adjust Cost Item Entries" process to ensure that all cost adjustments are applied correctly.
  3. Verify the settings in the Inventory Setup:
    1. Ensure that the "Average Cost Calc. Type" is set to "Item & Location & Variant."
    2. Confirm that the "Average Cost Period" is set appropriately.
  4. Determine if any fiscal years are closed. If there are closed years, consider reopening them to adjust the necessary entries.
  5. If applicable, use the Configuration Package to change the settings for "Average Cost Calc. Type" and "Average Cost Period" to ensure they align with the required configurations.