I have been asked to create a dashboard for MFG-VAR transactions to determine what we are doing wrong to have all of these to address. This is a FIFO Avg environment.
Reasons for MFG-VAR
Materials issued to jobs with no prod qty left
Labor charged to a job with no prod qty or is closed
Jobs closed with prod qty remaining
Am I missing any?
Is there a way to find out why the MFG-VAR transaction happened besides trying to look at each individual job over the last 6 months? The problem is trying to analyze a thousand jobs in a timely manner.
Probably a dashboard which includes those scenarios would be helpful but you need to know what went wrong first. So it kind of beats the purpose. Looking at each job would be the way to go I think. Maybe once you spot an issue, you could do quick SQL queries or BAQs to check if other jobs have the same issue.
Later, you can look at customizations/BPMs to prevent those scenarios from happening (like BPM to prevent issuing materials if remaining prod qty is 0)
What I ended up doing is building a query using TranGLC filtered by the WIP account(s). Then I linked to labordtl and parttran to get the job and sort by the system date and time to see the various ins and outs of cost to the job. This reveals what happened pretty well.