Issue/Symptom/Question

Comparing the Account Balance, WIP Subledger Report, and Workbench MC Summary, why doesn't the MC Summary Amounts match the other two?

Applies To

PENTA Workbench > SM: Service Management Reporting Center

Workbench Sprint 39

Resolution/Fix/Answer

The Maintenance Contract (MC) Summary Report includes Work Order (WO) Amounts for Billings, Revenue, etc., if the WO is linked to the MC, by default.  The Work-in-Process (WIP) Subledger-Revenue report will show the MC Billing Schedule Amounts, but not the WOs linked to the MC Billing Amounts.  This will create a disconnect if the two reports are compared and has potential to lead to a conclusion that something is wrong.  Apples and Oranges are being compared, so an additional step is needed to compare Apples to Apples (see last paragraph).

If separate GL Accounts are used for the Service Types linked to the WOs and the MCs, the General Ledger Balances will not match up with the MC Summary Report on the Workbench either.  This is because the Billing Amounts will be split between different GL Accounts, so the various GL Accounts need to be summarized to tie to the MC Summary Report.  Again, the comparison is not the same and could lead to an incorrect conclusion.

Penta has added the ability to exclude the WO Billings from MC Amounts, when desired, to allow the MC Summary Report to substantiate (tie out to) a single GL balance.  This only works if PENTA is setup with separate Accounts for MC vs WO and separate Service Types are used.  The new ability to Exclude WO Amounts from MC Summary Report is a new checkbox in the Parameters for the SM: Service Management Reporting Center.  Again, the default is to Include WO amounts, in the MC Summary Report.