I'm looking for a report(/saved search?) to show me all items we had in stock as of 12/31/2020. Does this exist natively?
a
Automatech
02/01/2021, 5:29 PM
Reports > Inventory/Items > Inventory Valuation Summary.
You can set the "as of" date.
It is sourced by summarizing transaction history. You'll see this if you dive down into the detail. Alternatively, one of the other native inventory reports might also work for you (e.g., Stock Ledger, etc.).
e
ericbirdsall
02/01/2021, 5:32 PM
Perfect- thanks
k
KevinJ of Kansas
02/01/2021, 9:51 PM
It should be noted - any backdated transactions could goof the accuracy of it, and make it inaccurate from what was physically in stock - or what was in the system as of the as of date.
KevinJ of Kansas
02/01/2021, 9:52 PM
My favorite are Date/Period mismatches on Inventory Transactions. Followed super closely by date/period mismatches on cash impacting transactions.