Americas - Pacific Northwest - ID, OR, WA

 View Only

 Beginning Balances at Start of Prior Month

  •   E10
Gary Browning's profile image
Gary Browning posted 09-09-2022 09:40 AM

Does anyone know of a good way to determine the beginning inventory balances at the start of the prior month?  I have not found where this would be stored in the tables, if at all.

I have a request for data showing what the inventory balances were on day 1 of the prior month. (i.e. from today, it would be August 1st), to be run on any given day.  

We are using Epicor 10.2.500.13.


#E10
Glenn Owers's profile image
Glenn Owers posted 09-09-2022 10:25 AM

Gary,

I have a BAQ that extracts the value and quantity of our inventory to a CSV file.  This extract runs on the 1st calendar day of each month, prior to our manufacturing team starting their shift, so it runs at 6:00am.  I have not been able to find this data within Epicor, so I pull the CSV files into Excel and run other BAQ’s to capture the receipts and manufacturing issues for the month.  Combining these data points provides the inventory usage.

Let me know if this answers your question or if I can assist further.

Related Content