Is anyone aware of a document that outlines the structure of the database. Particularly the summary fields. An example would be the actual costs in the job assembly table. I want to understand what detail records ‘flow’ into these summary fields.
The Job Costing Technical Reference Guide will have a reasonable description of the scenario you describe, and the MRP Technical Reference discusses how certain costs flow using the MRP Process. In some cases, the on-line help (Help > Field Help) for a particular field gives some clues, and there are half a dozen or so Hierarchy documents that describe where Epicor looks to see which GL path to follow for a given type of transaction.