One of the problems with As of Date in the stock status – it uses the last cost as of the date you run it –
It can back calculate the quantity on hand but, not the cost.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, September 04, 2015 9:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Last Cost and Stock Status Report
Yes, I can see where my inventory was re-evaluated to my "new" last cost. This is my concern/confusion: using my original example, if I ran a Stock Status Report on 7/31/2015, it would show 32 Widgets at $8.91 each. But, if I looked at any Material Transactions between 7/31/2015 and 9/2/2015, it would cost my widgets at $10.97.
Maybe the problem is the Epicor report is just wrong since it doesn't accurately show my Material Stock Status at a given point in time. It would seem that it should be able to use the "correct" price at that time since it is kept in PartTran.
It makes it very difficult on our Accounting Department to close the previous month if values are adjusting while they are trying to close.
~ Charlie Payne