We have several jobs that are showing zero costs on the Sales Gross Margin report. When I run the Production Detail report, I can see all the costs and when I look at the Inventory WIP Reconciliation report the exact same costs show up and are posted to the cost of sales accounts. These are shipped from jobs. I found out that we have only been running the capture at the end of the month due to new personnel not being trained correctly. I believe before we were running it every Tuesday including everything from the previous Friday. Hoping that will make an improvement.
According to the Data Dictionary, those fields “If shipped from job it is calculated during the Calculate WIP/COS period end process” so shouldn’t they have been updated when they ran the capture at the end of the month?
Will this affect anything other than the gross margin report since they appear to be correct on the job and posted to the GL?