Has anyone recreated the Inventory/WIP Reconciliation report? Or know what tables to use?
You might be better off customizing the current report. The Inv Wip Recon report is going to be tough to reproduce, you can look at the report data definition for the list of tables included.
This report does utilize the Wip Capture process to calculate the dataset and makes changes to data in epicor without posting to the GL.
