Need Total Inventory Quantity and Value for 1/1/25 for Tax Purposes

The historical reports all seem to be built by financial period, rather than specific dates, probably to tie into GL period reporting.

I’ve never had a lot of faith in any system’s historical reports, although Acumatica’s do seem to be accurate.  I think the Historical Inventory Balance and Historical Inventory Valuation reports are what you need:

• Historical Inventory Balance takes a starting and ending period, and provides a beginning and ending quantity in that period range.  I’d probably use period 12-2024 and the ending balance, but you could use 1-2025 and use the beginning balance.
• Historical Inventory Valuation does the same, except (like you found) it doesn’t do anything with quantities, only total value.  So you would need both reports.

Assuming these reports are accurate, someone could make some nice side money (or some really good friends) by retrofitting the queries in these reports into a GI so we could get cleaner exports.

I appreciate the insight. That’s one of our biggest frustrations with Acumatica - finding easy-to-use data for things that don’t seem to be out of the norm for most businesses. Hopefully someone will pop in here with a bright idea, but in the meantime I may have to manipulate both of those reports.

Hi ​@nicolestanton 

I found this post hope it can help you.

Best Regards,

NNT

Hi ​@nicolestanton 

The best way to get a true snapshot of quantity and valuation as of a specific date (like 1/1/25) is by using the Inventory Valuation Report with a financial period that includes your target date and making sure your valuation method supports historical tracking (like FIFO or Average).

If you need it down to the specific day (not just the period), you’ll need to run a custom report or Generic Inquiry using INCostStatus or INItemSiteHist joined with INItemCostHist — that’ll let you back into the valuation and quantities as of a point in time. It’s not out-of-the-box simple like QuickBooks, unfortunately, but totally doable with the right DACs.

Alternatively, some people just run the Inventory Valuation report at end of day 12/31/24, save the output, and use that for their 1/1/25 numbers.