GL Transaction Amounts Not Matching in Service

This report allows you to identify discrepancies between journal entry amounts in the General Ledger and in Service when you are posting to the GL in summary. You cannot compare amounts at the transaction level when you are posting one GL journal per batch; instead, you can use this report to compare the sum of all transactions in the batch from Service to the GL journal entry amount. Refer to the user manual for more information on using WIP reports at month's end. This report can be printed from its location in the Report Manager, or from Microsoft Dynamics GP by opening the Administration page and locating this report on the Custom Reports list. You can filter the report by account number or view all accounts for the specified date range.

GL Transactions Not in Service

This report shows a breakdown of the transactions that have been posted to the GL but were not posted to your Service accounts. Transactions are grouped by account number, and debits and credits are listed for each transaction as well as totaled for each account. The GL Transactions Not in Service report can be run as part of the month end closing process, to help identify the costs that have been posted to the GL but have not been posted in Service Management. Refer to the user manual for more information on using WIP reports at month's end. To print, choose Reports > Service Management > Service > WIP Reports. On the Service WIP Reports window, mark the Exception Reports radio button, then mark the GL Costs Not in Service radio button. You can filter this report by account number if there is a specific account you want to look at.

Service Call Cost Reconciliation

This report allows you to review the debits, credits, and extended costs in your WIP and COGS accounts, along with a summary of the debits and credits in the accounts for each contract. The Service Reconciliation report can be run as part of the month end closing process, to reconcile the amounts posted to your Progress Billings accounts and Service WIP accounts. Refer to the user manual for more information on using WIP reports at month's end.

To print, choose Reports > Service Management > Service > WIP Reports.
On the Service WIP Reports window, mark the Reconcile Report radio button, and choose whether you want to print the report in summary or in detail.

You can filter account and contract totals by division, customer, and location; you can also select a specific account and/or division to view.

Service Call Cost Reconciliation

Service Call Cost Reconciliation by Account

Service Invoice Trailing Costs

This report prints trailing costs by division and service call. For each service call, you can view actual and committed costs at invoice time, the trailing cost after invoicing, and the committed cost remaining, along with division totals and totals for the whole report. The detailed invoice shows additional service call and transaction details. The Service Invoice Trailing Costs report can be run as part of the month end closing process, to help identify the committed costs that remain unposted after a service invoice is posted for a closed service call. Refer to the user manual for more information on using WIP reports at month's end.

To print, choose Reports > Service Management > Service > WIP Reports.
On the Service WIP Reports window, mark the Trailing Cost and PPV radio button to print this report (along with the Service Invoice Trailing PPV Costs report), then choose whether you want to print the summary or detailed version of this report.

You can filter this report by division and account number.

Summary

Detail

Service Invoice Trailing PPV Costs

This report lists trailing PPV costs by service call and identifies the transaction number, GL posting date, and cost code of each trailing PPV cost. Service calls are arranged by division, allowing you to view both service call and division totals, as well as trailing PPV cost totals for the entire report. The Service Invoice Trailing PPV Costs report can be run as part of the month end closing process to help identify the trailing costs that remain due to a purchase price variance (PPV) that appeared on a receipt. Refer to the user manual for more information on using WIP reports at month's end.

To print, choose Reports > Service Management > Service > WIP Reports.
On the Service WIP Reports window, mark the Trailing Cost and PPV radio button to print this report (along with the summary or detailed Service Invoice Trailing Costs report).

You can filter this report by division and account number.

Service Transactions Not in GL

This report shows transactions that have been posted to your Service accounts but were not posted to the GL. Transactions are grouped by customer and location, with the debit and credit account and extended cost listed for each transaction. Report totals are included, along with totals for each customer and location. The Service Transactions Not in GL report can be run as part of the month end closing process, to help identify the costs that have been posted in Service Management but have not been posted to the GL. Refer to the user manual for more information on using WIP reports at month's end. To print, choose Reports > Service Management > Service > WIP Reports. On the Service WIP Reports window, mark the Exception Reports radio button, then mark the Service Costs Not in GL radio button. This report can be filtered by division, customer, location, and/or account number.

Service WIP

This report prints service WIP account totals, allowing you to view unbilled service work and open maintenance calls. Service call billing amounts and costs are grouped by contract, then totaled by category for each contract. These contract totals are grouped by division, allowing you to review the service division account totals, as well as category totals for the entire report. The Service WIP report can be run as part of the month end closing process, to help ensure that your Service WIP accounts balance with the General Ledger WIP accounts. Refer to the user manual for more information on using WIP reports at month's end.

To print, choose Reports > Service Management > Service > WIP Reports.
On the Service WIP Reports window, mark the WIP Report radio button, and choose whether you want to print the report in summary or in detail.

You can filter this report by division, customer, location, account number, and contract.

Summary

Detail