At month end, you may want to make sure that the WIP accounts in Service Management balance with the WIP accounts in the general ledger (GL). You can run reports that show you which service transactions have and have not been posted through to the GL - and which transactions have been posted in the GL, but not to Service Management.
...
Extended Amount = WIP Debit - WIP Credit + COGS Debit - COGS Credit
Step 2: Run the Reconciliation Detail report.
If summary report totals do not balance, you can view transaction-level detail for the period. This may help identify discrepancies.
Step 3: Run the Trailing Cost and Trailing PPV Cost reports.
If you cannot identify the issue, it may be due to a trailing cost or purchase price variance (PPV). This report checks for trailing costs and PPV costs in any account that is set up as a Cost Account or Progress Billing account in Invoice or Maintenance Account Setup. Cost of sales and sales accounts are not checked.
...
A PPV occurs when the amount that is relieved from WIP when posting a service invoice is different than the amount that was debited to WIP. This may occur if there is a trailing invoice; when there is no actual cost at the time of invoice posting, the Service WIP accounts are relieved based on committed cost remaining, and the amounts may not agree. The impact of a PPV does not appear on the service call but may be identified with this report.
Step 4: Run the Exception reports.
If you still cannot pinpoint the issue, these reports identify transactions that were posted to your Service WIP accounts but not to the GL, and vice versa. All accounts that have been set up as WIP or Cost service invoice or maintenance accounts, as well as any account that has been posted to for a service call, will be checked.
The report identifies journal entries along with the type of transaction and the user who posted it. For example, the issue may be a payable that debited WIP without the service call filled in, or a journal entry that was made directly to the GL instead of through Service. The report helps you identify the transaction and assess user training needs.
Step 5: Make any adjustments to GL or Service accounts.
You can adjust cost amounts in the Signature Transaction entry or Service Invoice windows. If you have trailing costs, you may choose to create an administrative service call to transfer the cost into the subledger via a clearing account.
...