I am using the PartDtl table to create a manufacturing multi part time phase dashboard. There are a few issues that arise. I am using the RequirementFlag in PartDtl to determine the Demand and Supply of a parts (equivalent to sum(pending requirements) and sum(pending receipts). An issue is that a job and quantity can be marked as both a receipt and a requirement in PartDtl. For example, in time phase this part has a SO with a requirement of 6 and a job that is making 295 to stock leaving the projected balance at 487.
In my BAQ it is counting both the SO and Job in Demand (RequirementFlag = 1) and then the Job again in Supply (RequirementFlag = 0). This gives a Demand of 301 which instead should be 6. The Supply is right at 295. This then affects further calculations.
I made a simpler BAQ to find this result.
How is it possible that this job is being counted as both a Requirement and Receipt in PartDtl and how can I work around this?