Hi good afternoon!!
We need to know the dates on which the COST / WIP has been posted in the company, does anyone know if Epicor leaves a log or a report that tells us on which dates the process ran?
Thank you!!
Regards
1 Like
Pretty sure you can use Inventory / WIP Reconciliation Report.
Check the option “Both” in the G/L Posting Detail.
@TobyLai perfect!!!
I’m going to try to run that report to see what results it gives me and I put the feedback with the result I get.
Thank you very much!!!
That won’t show the date that Capture WIP/COS was run.
Best that Inv/WIP Recon will give you is either the date the parttran transaction happened on, or the apply date. Neither are the date the parttran created the GL transaction.
Your best bet would be to look at the GLJrnl tables to see if there’s datetime field.
@CTapia - The date the specific transactions that were posted by the Capture COS/WIP process can be found in GLJrnlDtl.PostedDate
You can then eyeball the Posted dates to see when specific entries were posted to the GL.
Note that the PostedDate field was only a date in some versions prior to 10.2.300. It changed from a date to a date time sometime between 10.1.400 and 10.2.300.
edit
In my test, the date portion of the PostedDate never differed from the CreatedDate field. I’m not sure, but they might differ if a transaction ended up in the review journal. With one being when Capture COS/WIP was run, and the other when it actually posted in the review Journal.
1 Like
It’s correct, in this report I can’t see the date the COST / WIP was posted. In the table that you mention if I was able to track the costing movements, it is a bit confusing because of the fields that the table has but if it helped me a lot, the table has valuable information.
Thank you very much!