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.
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.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.