E905 Sales Gross Margin reporting 100% GM erroneously

Yahoo Archive
1
Recently I needed to investigate cost issues in the SGM report. I found this help entry for the "Use Adjusted Cost" checkbox on the SGM form helpful
Use Adjusted Cost
Select this check box to designate that the unit cost stored in the AR Invoice detail line should be updated when a job is closed. This enables the Sales Gross Margin Report to use the Job Closing fields for more accurate unit costs on the report. Clear this check box to designate that the unit cost stored in the AR Invoice detail line should not be updated when a job is closed.
When you select this check box, it designates that the Labor, Burden, Material, Subcontract, Material Burden and Total Cost fields should be updated from the Job Closing Unit Cost fields (for Labor, Burden, so forth) instead of the corresponding standard invoice cost fields.
  • Epicor ERP updates the Job Closing Unit Cost fields (InvcDtl.JCSubUnitCost, InvcDtl.JCMtlUnitCost, InvcDtl.JCMtlBurUnitCost, InvcDtl.JCLbrUnitCost, and InvcDtl.JCBurUnitCost) in the Invoice Detail (InvcDtl) table when a job is closed; they are a recalculation of the costs for all of the parts shipped from a job. This is the final audited cost for the job, and it could vary considerably from the cost at the time of shipment because jobs are usually reviewed by both production and accounting for accuracy at that time.
  • As a result, this check box is valuable when you want the reported costs to more accurately represent the invoiced costs of the parts if a job has many partial shipments during the life of the job, or if late costs have been applied after invoices were created. This provides costs that are easier to reconcile to jobs, but may not reconcile to the General Ledger, because some of the costs picked up by the GL could be variance costs or costs captured for partial shipments in different fiscal periods.
  • The lines on the report that use the Job Adjusted cost fields are marked with an asterisk backslash (*\) that appears before the applicable cost fields.
Note: Epicor ERP still uses the standard invoice cost fields for invoiced items for jobs that are still open, and for parts that have been shipped from inventory rather than from a job.

We have discovered a quirk with this. Make direct jobs that were closed before they were shipped will not have the Job Adjusted cost fields populated but the SGM treats uses these fields instead of the standard cost fields when "Use Adjusted Cost" is checked. This results in the SGM reporting zero for all the job costs. If you uncheck "Use Adjusted Cost" and run SGM again it will use the standard cost fields and report the correct costs.

 
2

SGM shows no cost for some transactions even when we can see costs through other analysis tools. Some of them are drop shipment orders with 1 release and slip shipments by the vendor. Has anyone else seen this behavior?

Thanks.