Discrepancies between the Total Input and Output Quantity based on the Stock Ledger report and the total of the Quantities shown on the Inventory Valuation Detail Report was due to the Inventory Cost Revaluations created for the Item.
1. On the Stock Ledger Report, click the Customize button.
2. Click the Filters subtab.
3. On the Filters subtab, expand the Stock Ledger folder. Then expand the Transaction Type folder.
4. Click the Long Name field. Change the filter into not equal to Inventory Cost Revaluation.
5. Edit the Report Name.
6. Click Save.
Note: The limitation of the Filter is that the Inventory Value for Inputs and Outputs would be inaccurate since changes made by the Inventory Cost revaluation on inventory cost were not considered in the Report.