Hi Laura,

The only 'stored' quantity on hand for any location is the quantity right now, and not for any time in the past. These historical counts that can be printed on back-dated reports are based on calculations, so if all of the historical transactions are not correct for a particular item, then indeed you won't be able to get the Oct 31st count. Nor will the Oct 31 count be correct if the stored qty on hand for today is incorrect.

If you know the actual differences between what quantity is stored in Adagio Inventory (as of Nov 30) and the actual physical count (as of Nov 30), you could enter these differences either as an Adjustment or via a Physical Inventory process, dated as of Nov 30. That would update the backdated reports. You may want to try this on a copy of your data (rather than live data) and only for a couple of items to start with, to ensure that it is doing what you expect it to.

The fastest way to do a physical inventory adjustment is to use the Import/Export process. You can export the stored quantities for each item (from the computer) to an Excel spreadsheet.

Ensure that you choose the 'Qty on Hand' field as one of the fields to export (and later import) if you want to import differences in stock qty, not actual figures. Should you want to import actual stock counts, leave out the 'Qty on Hand' field from the export/re-import process.

In the Excel spreadsheet, the 'Qty on Hand' represents what is in the computer, and the 'Stock counted' represents the physical stock quantity on hand.

If you choose to do this, I can't recommend strongly enough that you do a backup of your Inventory data before posting the imported inventory reconciliation.