Issue/Symptom/Question

Why doesn't the Combined Gross Margin limited to One OU not match that OU's Financial Statement Gross Margin?

Applies To

Workbench - AC: Combined GM Panel 

Resolution/Fix/Answer

There are a few reasons the GM amount might be different:

1) Confirm Rev Rec has completed for the period being reviewed.  Combined Gross Margin data table is populated with the Rev Rec process.

2) The WO OU ID might have been transferred, but the transactions were not transferred

  -  The Panel selects the items to include in AC: Combined Gross Margin based on the OU ID on the WO.  If the transactions were not transferred, then the amounts will be in the Old OU subledger and thus the financials of the Old OU.

3) Standard Charging might be used, and the mapping of Accounts used in that process might be included in the Financial Statement Gross Margin calculation

  -  In other words, the AC: Combined Gross Margin uses the Standard Cost while the Financials have been adjusted to use Actual Cost for the GM calculation

Steps to address:

For #1, use the transfer process to get the OUs to be as expected.

1. Transfer back to original OU, leave the “Create Transfer Entries” box unchecked

2. Process the transfer in the bottom right

3. Transfer to new OU again, check the box to "Create Transfer Entries"

4. If the month is closed from the original transactions, the transfer can occur in the current month

For #2, change the mapping of the Accounts so the Actual Cost is not part of the Gross Margin calculation on the Financials, if you want the reports to match.