SSRS Report Directory: Accounting Reports

You open these reports by going to Menu > Reports - SSRS > SSRS Report Viewer > Standard Reports > AMS SSRS Report Library > Accounting. Reports are listed in the order they appear in the menu.

Run the reports

Open the report from the Accounting list.
Complete the fields in the Options Panel.
Select Run Report.

Report fields

Where available, you can select the report name to see a sample of the report open in a new window.

Report Name	Description	Fields
Account Analysis	This report provides a listing of the debits and credits for orders exported to Accounting.	Group By Account/Structure Date Range Unit Number Unit Type Shop Order Number Order Type Order Subtype Sort By Currency
Account Disbursement Analysis	This report will give you a list of all disbursement rules and sub-rules. The report displays the rules by order type and includes Order Subtype, Transaction Type, Line Type, Account Number, Charge Category, Vendor Line, Account Description, Reason Group and Account Structure. If a rule does not have any disbursement details, it will not be present on the report.	Order Type Subtype Line Type Charge Category Reason Group Code Vendor Charge
Accounting Export Batch Detail	The report is designed to be run for a specific exported date range and Microsoft Dynamics GP batch number and provides a listing of the debits and credits for orders that have been exported to an accounting package. Note: If a batch number is not created by the accounting package export, everything will appear under a blank batch number. The report can be grouped by batch, shop or order type.	Order Type Subtype Line Type Charge Category Reason Group Code Vendor Charge
Current Book Value By Inventory Account	This report is designed to be run at the end of the month to give the book value of inventory. For each Inventory Asset Account, the system takes the current value of inventory on hand (this will match the Part Inventory Listing), subtract the total for any part lines on POs that are in received status but not closed, and add the total for any part lines on Repair Orders, Indirect Charges, and Direct Sales Invoices that have not been closed. The report will give the book value for each account by shop, and then a summary at the end will give the grand total book value for each account.	Shop Currency

Report Name

Description

Fields

Account Analysis

This report provides a listing of the debits and credits for orders exported to Accounting.

Group By
Account/Structure
Date Range
Unit Number
Unit Type
Shop
Order Number
Order Type
Order Subtype
Sort By
Currency

Account Disbursement Analysis

This report will give you a list of all disbursement rules and sub-rules. The report displays the rules by order type and includes Order Subtype, Transaction Type, Line Type, Account Number, Charge Category, Vendor Line, Account Description, Reason Group and Account Structure.

If a rule does not have any disbursement details, it will not be present on the report.

Order Type
Subtype
Line Type
Charge Category
Reason Group Code
Vendor Charge

Accounting Export Batch Detail

The report is designed to be run for a specific exported date range and Microsoft Dynamics GP batch number and provides a listing of the debits and credits for orders that have been exported to an accounting package.

Note: If a batch number is not created by the accounting package export, everything will appear under a blank batch number. The report can be grouped by batch, shop or order type.

Order Type
Subtype
Line Type
Charge Category
Reason Group Code
Vendor Charge

Current Book Value By Inventory Account

This report is designed to be run at the end of the month to give the book value of inventory. For each Inventory Asset Account, the system takes the current value of inventory on hand (this will match the Part Inventory Listing), subtract the total for any part lines on POs that are in received status but not closed, and add the total for any part lines on Repair Orders, Indirect Charges, and Direct Sales Invoices that have not been closed. The report will give the book value for each account by shop, and then a summary at the end will give the grand total book value for each account.

Shop
Currency