The list below shows the reports that are currently available in Sage 200 2011 and above. To view more information about a report, select the report area then select the report from the list.
In addition to the standard reports, don't forget you can also use the Report Library, read more.
This article has been prepared and issued to you as a goodwill gesture only and Sage accepts no liability or responsibility for its use. For further support please refer to your Business Partner.
| Report name | Sales Ledger Day Book Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is sorted by posted date, account number and unique reference | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger List of Accounts View report | |
|---|---|---|
| Sage 200 Version | 2011 and Above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is sorted by account number | |
| Report values | For each account the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Account Details View report | |
|---|---|---|
| Sage 200 Version | 2011 and Above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each account the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Transaction Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number and sorted by transaction date | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Transaction Report (by Period) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by customer account nominal period | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Transaction Report (Historical) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger VAT Transactions Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each transaction the report shows -
| |
| Filter | The report has a filter to only include invoices and credit notes | |
| Report name | Sales Ledger Trading Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each customer the report shows (values in base currency) -
Note: The period criteria informs the report of which period values should be shown in the 1st column with the next 6 periods before that in the next columns. | |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Trading Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger RCSL (Detailed) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each customer the report shows -
| |
| Filter | The report is filtered to only include reverse charge sales for customers who have a VAT registration number and a country code of GB | |
| Report name | Sales Ledger RCSL (Summary) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each customer the report shows -
| |
| Filter | The report is filtered to only include reverse charge sales for customers who have a VAT registration number and a country code of GB | |
| Report name | Sales Ledger Aged Debtors Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Aged Debtors Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Aged Debtors Report (Summary) Unalloc View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Due Date Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Ledger Due Date Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Time Taken To Pay Sales Invoices View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Ledger > Credit Control | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | There is a report filter to only include transactions that have been paid | |
| Report name | Purchase Ledger Day Book Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is sorted by posted date, account number and unique reference | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger List of Accounts View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Account Details Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Transactions Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number and sorted by transaction date and unique reference number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Transactions Report (by Period) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by accounting period ID and sorted by transaction date and account number | |
| Report values | For each accounting period the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Transactions Report (Historical) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number and sorted by unique reference number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Unauthorised Transactions Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number and sorted by unique reference number | |
| Report values | For each supplier the report shows -
| |
| Filter | The report is filtered to show unauthorised transactions only | |
| Report name | Purchase Ledger VAT Transactions Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number and sorted by transaction date | |
| Report values | For each supplier the report shows -
| |
| Filter | The report is filtered to include invoice or credit notes | |
| Report name | Purchase Ledger Trading Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Account Analysis | |
| Groups / sorts | The report is grouped by supplier account number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Trading Report (Summary) View report | ||
|---|---|---|---|
| Sage 200 Version | 2011 and above | ||
| Location | Purchase Ledger > Account Analysis | ||
| Groups / sorts | The report is grouped by supplier account number | ||
| Report values | For each supplier the report shows -
| ||
| Filter | There is no filter on the report | ||
| Report name | Purchase Ledger Aged Creditors Report (Detailed) View report | ||
|---|---|---|---|
| Sage 200 Version | 2011 and above | ||
| Location | Purchase Ledger > Payments Control | ||
| Groups / sorts | The report is grouped by supplier account number and sorted by transaction date | ||
| Report values | For each supplier the report shows -
| ||
| Filter | There is no filter on the report | ||
| Report name | Purchase Ledger Aged Creditors Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Payments Control | |
| Groups / sorts | The report is grouped by supplier account number and sorted by transaction date | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Due Date Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Payments Control | |
| Groups / sorts | The report is grouped by supplier account number and sorted by due date | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Due Date Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Payments Control | |
| Groups / sorts | The report is grouped by supplier account number | |
| Report values | For each supplier the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Purchase Ledger Valid Supplier Discounts Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Payments Control | |
| Groups / sorts | The report is grouped by supplier account number, unique reference and sorted by transaction date | |
| Report values | For each supplier the report shows -
| |
| Filter | The report is filtered to only show if there is a valid discount amount | |
| Report name | Time Taken to Pay Purchase Invoice View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Ledger > Payments Control | |
| Groups / sorts | The report is grouped by supplier account number and sorted by transaction date | |
| Report values | For each supplier the report shows -
| |
| Filter | The report is filtered to only show if there is a agreed settlement date | |
| Report name | Nominal Ledger Day Book Report View report | ||
|---|---|---|---|
| Sage 200 Version | 2011 and above | ||
| Location | Nominal > Account Analysis | ||
| Groups / sorts | The report is sorted by posted date, nominal account number and unique reference number | ||
| Report values | For each transaction the report shows -
| ||
| Filter | There is no filter on the report | ||
| Report name | Nominal Ledger List of Accounts View report | ||
|---|---|---|---|
| Sage 200 Version | 2011 and above | ||
| Location | Nominal > Account Analysis | ||
| Groups / sorts | The report is grouped by nominal account number | ||
| Report values | For each nominal the report shows -
| ||
| Filter | There is no filter on the report | ||
| Report name | Nominal Ledger Account Analysis (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number, grouping level 1 to 7, department and cost centre | |
| Report values | For each nominal the report shows -
| |
| Filter | The report filters out account types "M" and “P” and will not show a line if the year to date value is blank | |
| Report name | Nominal Ledger Account Analysis (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number, grouping level 1 to 7, department and cost centre | |
| Report values | For each nominal the report shows -
| |
| Filter | The report filters out account types “M” and “P” and will not show a line if the year to date is blank | |
| Report name | Nominal Ledger Account Analysis (Posting Accounts) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number, grouping level 1 to 7, department and cost centre | |
| Report values | For each nominal the report shows -
| |
| Filter | The report is filtered to show if there is a value in the year to date column | |
| Report name | Nominal Ledger Account Analysis (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 | |
| Report values | For each nominal the report shows -
| |
| Filter | The report is filtered to show posted transactions only and if there is a value in the year to date column it also has pre-set criteria for group by account number only | |
| Report name | Nominal Ledger Account Analysis (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 | |
| Report values | For each nominal the report shows -
| |
| Filter | The report is filtered to show posted transactions only and if there is a value in the year to date column it also has pre-set criteria for group by account number only | |
| Report name | Nominal Ledger Transactions Listing View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by nominal account number, department and cost centre | |
| Report values | For each nominal the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Transactions Listing (Historical) View report | ||
|---|---|---|---|
| Sage 200 Version | 2011 and above | ||
| Location | Nominal > Account Analysis | ||
| Groups / sorts | The report is grouped by nominal account number, department and cost centre | ||
| Report values | For each nominal the report shows -
| ||
| Filter | There is no filter on the report | ||
| Report name | Non-trading Vatable Transactions View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by the system transaction type ID and will show totals for each calendar month within the current financial year | |
| Report values | For each transaction type the report shows -
| |
| Filter | The report is filtered to only show sales and purchase tax journals | |
| Report name | Nominal Ledger URN Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by the user, unique reference number and sorted by account number | |
| Report values | For each unique reference number the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger URN Report (Historical) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by the user, unique reference number and sorted by account number | |
| Report values | For each unique reference number the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Waiting Postings Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by the user number, unique reference number and sorted by date | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Waiting Postings Report (Deferred) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by the user, unique reference number and sorted by date | |
| Report values | For each transaction the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Departmental Analysis (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by analysis code, account number and department | |
| Report values | For each department the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Departmental Analysis (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by analysis code, account number and department | |
| Report values | For each department the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Departmental Analysis View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by analysis code, account number and department | |
| Report values | For each nominal account the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Nominal Ledger Previous Year Journal Listing View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by account number, account department and cost centre | |
| Report values | For each account department the report shows -
| |
| Filter | The report is filtered to only show transactions from the previous tax year | |
| Report name | Nominal Ledger Manual Journal Listing View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Account Analysis | |
| Groups / sorts | The report is grouped by account number, account department and cost centre | |
| Report values | For each account department the report shows -
| |
| Filter | The report is filtered to only show transactions that have been entered manually | |
| Report name | Nominal Ledger Trial Balance (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7, department and cost centre | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to only show a line if there is a value in the year to date column | |
| Report name | Nominal Ledger Trial Balance (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7 showing the group nominals, department and cost centre | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a value in the year to date column | |
| Report name | Nominal Ledger Trial Balance (Posting Accounts) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by department and cost centre | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a year to date value | |
| Report name | Nominal Ledger Trial Balance by Number (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7 showing the individual nominals and totals | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a year to date value | |
| Report name | Nominal Ledger Trial Balance by Number (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7 showing the individual nominals and totals | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a year to date value | |
| Report name | Nominal Ledger Trial Balance Prior Year (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7 showing the individual nominals and totals | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a year to date value | |
| Report name | Nominal Ledger Trial Balance Prior Year (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is grouped by grouping level 1 to 7 showing the grouped nominals | |
| Report values | For each nominal code the report shows -
| |
| Filter | The report is filtered to show if there is a year to date value | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | Based on your financial statement settings, the report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement and is also grouped by cost centre | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement and is also grouped by cost centre | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement and is also grouped by cost centre | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | Tthe report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Balance Sheet Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | Based on your financial statement settings, the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Balance Sheet Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement and is also grouped by cost centre | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Balance Sheet Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Balance Sheet Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement and grouped by cost centre | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Balance Sheet Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Profit and Loss Memo Accounts View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | The report is filtered to only show memo accounts from the profit and loss financial statement | |
| Report name | Balance Sheet Memo Accounts View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | The report is filtered to only show memo accounts from the balance sheet financial statement | |
| Report name | Cash Flow Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Financial Statements | |
| Groups / sorts | The report is controlled by your financial statement | |
| Report values | The report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Detailed Budgets View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 showing individual nominals | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report name | Detailed Budgets by Number View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 showing individual nominals | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report name | Summary Budgets View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 showing grouped nominals | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report name | Summary Budgets by Number View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number and grouping level 1 to 7 showing grouped nominals | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report name | Individual Budgets View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number, cost centre and department | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report name | Detailed Budgets (Previous Year) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Nominal > Budget Comparisons | |
| Groups / sorts | The report is grouped by nominal account number, department and cost centre | |
| Report values | By nominal code the report will show -
| |
| Filter | The report is filtered to only show if there is a budget | |
| Report Name | Fixed Asset Details View report | |
|---|---|---|
| Sage 200 Version | 2015 | |
| Location | Nominal Ledger > Fixed Asset | |
| Groups / sorts | The report is grouped by asset number | |
| Report values | For each asset the report shows -
| |
| Filter | There is no filter on the report | |
| Report Name | Fixed Asset Valuation View report | |
|---|---|---|
| Sage 200 Version | 2015 | |
| Location | Nominal Ledger > Fixed Asset | |
| Groups / sorts | The report is grouped by asset number | |
| Report values | For each asset the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Cash Book Account Details Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by cash book account number | |
| Report values | For each account the report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Cash Book Transactions Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each transaction the report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Cash Book Transactions (Period) Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by accounting period and account number | |
| Report values | For each account the report will show -
| |
| Filter | There is no filter on the report | |
| Report name | Unpresented Cheques (Receipts) Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each account code the report will show -
| |
| Filter | The report is filtered to only to show unpresented cheque receipts | |
| Report name | Unpresented Cheques (Payments) Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each account the report will show -
| |
| Filter | The report is filtered to only show unpresented payment cheques | |
| Report name | Unpresented Cheques (Both) Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Cash Book > Reports | |
| Groups / sorts | The report is grouped by account number | |
| Report values | For each account the report will show -
| |
| Filter | The report is filtered to only show unpresented cheques for either payments or receipts | |
| Report name | Stock Levels View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by product group code and warehouse name | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered to not include phantom built item types (linked to BOM items) and that it is a stock item | |
| Report name | Stock Sales Order Shortfalls View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item, product group code and warehouse name | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered to show items which are not fully despatched and that are not trade counter orders | |
| Report name | Stock Expected In/Out View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by product group code and warehouse name | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM), to show only stock items that are on a purchase or sales order | |
| Report name | Negative Stock Levels View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item, bin name, product group name and warehouse name | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered to show negative stock and not to include phantom built items (linked to BOM) | |
| Report name | Stock Levels Buying Price Breakdown View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by source area reference, product group code, bin name and warehouse name | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered not to include phantom built items (linked to BOM) | |
| Report name | Stock Valuation View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item code and product group code | |
| Report values | For each product group code the report shows -
| |
| Filter | The report is filtered not to include phantom built items (linked to BOM) and to only show stock items with a value | |
| Report name | Stock Allocations View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by recipient reference, source area type name, stock item code, product group code, bin name and warehouse name | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered not to include phantom built items (linked to BOM) | |
| Report name | Stock Re-Order Levels with Alternatives View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item code, product group code and warehouse name | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered to not include show phantom built items (linked to BOM) and to show if there is an alternative item in stock | |
| Report name | Stock Re-Order Levels with Suppliers View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by supplier account number, stock item code, product group code and warehouse name | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to show if the warehouse re-order level is greater than zero | |
| Report name | Stock Items Inactivity Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item code, product group code and warehouse name | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) | |
| Report name | Stock Period Profitability Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item code, product group code and balance period | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and the quantity sold within the period is greater than zero | |
| Report name | Stock Profit Report by Customer View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by stock item code and customer account ID | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | |
| Report name | Stock Profit Report by Customer (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by customer account ID | |
| Report values | For each customer the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | |
| Report name | Stock Profit Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by source area reference, transaction type name, transaction group name, bin name, warehouse name, stock item code and product group ID | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | |
| Report name | Stock Profit Report (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Status | |
| Groups / sorts | The report is grouped by source area reference, transaction type name, transaction group name, bin name, warehouse name, stock item code and product group ID | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | |
| Report name | Stock Items Detailed View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Catalogue | |
| Groups / sorts | The report is grouped by product group ID | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) | |
| Report name | Stock Items with Supplier View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Catalogue | |
| Groups / sorts | The report is grouped by supplier account number and stock item | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include phantom built items (linked to BOM) | |
| Report name | Stock Items with Search Values View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Catalogue | |
| Groups / sorts | The report is grouped by stock item and product group | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to not include show phantom built items (linked to BOM) | |
| Report name | Product Groups View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Catalogue | |
| Groups / sorts | The report is sorted by product group | |
| Report values | For each product group the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Product Groups with Search Categories and Values View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Catalogue | |
| Groups / sorts | The report is grouped by product group | |
| Report values | For each product group the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Batch/Serial Locations and Quantities View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by product group | |
| Report values | For each product group the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Batch/Serial Item Status Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by item code, product group and item status ID | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered not to include pre-receipt transactions and the goods in per bin do not match the goods out | |
| Report name | Batch/Serial Allocation Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by recipient reference, area type name, item code, product group, bin name and warehouse name | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to show traceable items only and the allocated quantity does not equal zero | |
| Report name | Batch/Serial Item Status Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by item code, product group and item status ID | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered to not include pre-receipt transactions and the goods in per bin does not match the goods out | |
| Report name | Item Sell by Dates Report (by Warehouse) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by traceable type, stock item ID sell by date and warehouse name ID | |
| Report values | For each sell by date report shows -
| |
| Filter | The report is filtered to show items which have a sell by date and the quantity in and out does not equal zero | |
| Report name | Item Sell by Dates Report (by Stock Item) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by traceable type, sell by date and stock item ID | |
| Report values | For each stock items the report shows -
| |
| Filter | The report is filtered to show items which have a sell by date and the quantity in and out does not equal zero | |
| Report name | Item Use by Dates Report (by Warehouse) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by traceable type, stock item ID and use by date | |
| Report values | For each use by date the report shows -
| |
| Filter | The report is filtered to show items with a use by date | |
| Report name | Item Use by Dates Report (by Stock Item) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by traceable type, use by date and stock item ID | |
| Report values | For each stock item the report shows -
| |
| Filter | The report is filtered to show items with a use by date | |
| Report name | Item Settings for Batch/Serial View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by product group | |
| Report values | For each product group the report shows -
| |
| Filter | The report is filtered to show traceable items only | |
| Report name | Stock Transactions for Batch/Serial Numbers View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name and item code | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to show traceable items only | |
| Report name | Stock Transactions (Archived) for Batch/Serial View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Batch/Serial Items | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name and item code | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to show traceable items only | |
| Report name | Stock Transactions History View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name and item code | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not show obsolete items (linked to BOM) | |
| Report name | Stock Transactions History (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, product group, bin name, warehouse name and item code | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not show obsolete items (linked to BOM) | |
| Report name | Sales Stock Transactions History View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name, item code and sorted by transaction date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not include obsolete items (linked to BOM) and only show sales orders and returns | |
| Report name | Sales Stock Transactions History (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name, item code and sorted by transaction date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not include obsolete items (linked to BOM) and only show sales orders and returns | |
| Report name | Simple Stock Transactions History View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, transaction group, bin name, warehouse name, item code and sorted by transaction date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not include obsolete items (linked to BOM) and internal or customer allocations | |
| Report name | Simple Stock Transactions History (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by source area, transaction type, product group, bin name, warehouse name, item code and sorted by transaction date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to not include obsolete items (linked to BOM) and internal or customer allocations | |
| Report name | Stock Average Cost History View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by item code and sorted by changed date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered not to include obsolete items (linked to BOM) | |
| Report name | Stock Standard Cost History View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Transactions | |
| Groups / sorts | The report is grouped by item code and sorted by changed date | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered not to include obsolete items (linked to BOM) | |
| Report name | Stocktake Required View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Stocktake | |
| Groups / sorts | The report is grouped by item code, product group and warehouse | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered not to include obsolete items (linked to BOM) | |
| Report name | Stocktake Status View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Stocktake | |
| Groups / sorts | The report is grouped by warehouse and stocktake status | |
| Report values | For each stocktake the report shows -
| |
| Filter | The report is filtered not to include warehouses linked to returns and direct delivery | |
| Report name | Stock Items Without Stocktake View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Stocktake | |
| Groups / sorts | The report is grouped by stock item, product group and warehouse | |
| Report values | For each warehouse the report shows -
| |
| Filter | The report is filtered not to include obsolete items (linked to BOM) and where the last count is blank | |
| Report name | Stock Locations View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Set Up | |
| Groups / sorts | The report is grouped by bin name and warehouse | |
| Report values | For each warehouse the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Stock Search Categories View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Stock Control > Set Up | |
| Groups / sorts | The report is grouped by search category ID and search category name | |
| Report values | For each search category the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Orders Status View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | |
| Report name | Sales Orders Not Fully Allocated View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show all items that are not fully allocated | |
| Report name | Sales Orders Fully Allocated Not Fully Despatched View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show all items that are fully allocated but not fully despatched | |
| Report name | Sales Orders Fully Despatched Not Fully Invoiced View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show items that are fully despatched but not fully invoiced | |
| Report name | Sales Orders Not Acknowledged View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Orders | |
| Groups / sorts | The report is sorted by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered only to include orders that are not fully acknowledged | |
| Report name | Sales Orders Allocation Required View report | |
|---|---|---|
| Sage 200 version | 2011 and above | |
| Location | Sales Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by document number and sorted by print sequence number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items where the amount remaining to be despatched does not match the amount allocated | |
| Report name | Sales Orders Allocation Not Despatched View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to include items have been despatched but not invoiced | |
| Report name | Sales Orders Despatches Not Invoiced View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by document number and sorted by print sequence number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to not include previously invoiced goods | |
| Report name | Sales Returns Status View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | |
| Report name | Sales Returns Not Fully Received View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show that are not fully returned | |
| Report name | Sales Returns Fully Received Not Fully Credited View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show items fully received but not fully credited | |
| Report name | Sales Returns Receipts Pending View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Return Lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show available amounts to despatch | |
| Report name | Sales Returns Receipts Not Credited View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Return Lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and items returned but not credited | |
| Report name | Payment Method Totals Summary View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Processing > Payment Methods | |
| Groups / sorts | The report is grouped by payment method name and return ID | |
| Report values | For each return the report shows -
| |
| Filter | The report is filtered not to include records where the payment method name is blank | |
| Report name | Sales Orders View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number, priority, document status return type and customer account number | |
| Report values | For each document the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Sales Orders(Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by customer account number | |
| Report values | For each order the report shows -
| |
| Filter | There is no filter on this report | |
| Report name | Sales Orders Book Report (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number, priority, document status, return type and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to only show amounts that have not been invoiced | |
| Report name | Sales Orders Allocations View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by customer account number and warehouse | |
| Report values | For each customer account number the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Orders Despatches Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Returns Receipts Report View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Order Cancelled Lines View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by item code and customer account number | |
| Report values | For each item code the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Stock Items Allocation Required View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by item code and sorted by document number and print sequence | |
| Report values | For each item code the report shows -
| |
| Filter | The report is filtered to only show if the quantity is greater than the quantity already allocated | |
| Report name | Sales Orders and Returns with Unposted Invoices and Credit Notes View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number and document type | |
| Report values | For each document number the report shows -
| |
| Filter | The report is not filtered | |
| Report name | SOP Canceled Invoices View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is not grouped or sorted | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to only show cancelled invoices | |
| Report name | Overpaid Sales Orders | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Status | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to only show if the payment values is greater than the order value | |
| Report name | Sales Order Profitability (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by print sequence number, document number and customer account ID | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to only show sales orders | |
| Report name | Sales Order Profitability (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | The report is filtered to only show sales orders | |
| Report name | SOP Pro Forma Profitability (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account ID | |
| Report values | For each item document number the report shows -
| |
| Filter | The report is filtered to only show Pro formas | |
| Report name | SOP Pro Forma Profitability (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to only show Pro formas | |
| Report name | SOP Quotation Profitability (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account ID | |
| Report values | For each item document number the report shows -
| |
| Filter | The report is filtered to only show Quotation | |
| Report name | SOP Quotation Profitability (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to only show Quotations | |
| Report name | Invoice Profitability (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account ID | |
| Report values | For each item document number the report shows -
| |
| Filter | The report is filtered to only show Invoices | |
| Report name | Invoice Profitability (Summary) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Profitability | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to only show Invoices | |
| Report name | Batch Serial SOP Allocations | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Batch/Serial Items | |
| Groups / sorts | The report is grouped by recipient reference,area type name,product group, bin name and warehouse name | |
| Report values | For each stock code the report shows -
| |
| Filter | The report is filtered to only traceable items | |
| Report name | SOP Despatches and Receipts with Batch/Serial Numbers | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Batch/Serial Items | |
| Groups / sorts | The report is grouped by document number, despatch reciept type ID and account number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to only show traceable items | |
| Report name | Invoices for Batch/Serial items View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to only show traceable items | |
| Report name | Sales Order and Returns (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each document the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Order and Returns (Archived) Summary View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by return ID and customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Invoices and Credit Notes (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by document number and customer account number | |
| Report values | For each customer the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Invoices and Credit Notes (Archived) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by document number, invoice/credit ID and customer account number | |
| Report values | For each document the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Canceled Lines (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Archived | |
| Groups / sorts | The report is grouped by cancelled lines item code and customer account number | |
| Report values | For each line the report shows -
| |
| Filter | The report is not filtered | |
| Report name | SOP Additional Charges | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Maintenance | |
| Groups / sorts | The report is sorted by the additional charges code | |
| Report values | For each additional charge the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Repeat Sales Order Templates | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Maintenance | |
| Groups / sorts | The report is grouped by customer account number and sorted by repeat order type | |
| Report values | For each customer the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Sales Order Items | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Maintenance | |
| Groups / sorts | The report is grouped by product group code and sorted by stock item code | |
| Report values | For each stock item code the report shows -
| |
| Filter | The report is filtered to only show if the item is part of the product group code | |
| Report name | SOP Customer Delivery Addresses | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Sales Order Processing > Maintenance | |
| Groups / sorts | The report is grouped by delivery address ID and customer account number | |
| Report values | For each delivery address the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Orders Status View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | |
| Report name | Purchase Orders Not Fully Received View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to include not fully received items | |
| Report name | Purchase Orders Fully Received Not Fully Invoiced View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Orders | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered to include items fully received that have either not been invoiced or have been part invoiced. | |
| Report name | Purchase Orders Not Printed | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Orders | |
| Groups / sorts | The report is sorted by document number | |
| Report values | For each document number the report shows -
| |
| Filter | The report is filtered on print ID to only show if the order has not been printed | |
| Report name | POP Items Requiring Ordering View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by warehouse name and sorted by re-order item code | |
| Report values | For each item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | POP Back to Back Orders Required | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by customer name re-order item code and warehouse description | |
| Report values | For each item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchaser Order Receipts Pending View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by print sequence number and document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to include items if there is a quantity outstandiing | |
| Report name | Purchaser Order Invoices Pending View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Order lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to include items if there is a quantity to be invoiced | |
| Report name | Purchase Return Status View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | |
| Report name | Purchase Return Not Fully Despatched View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to show items if there is a return required | |
| Report name | Purchase Returns Fully Despatched Not Fully Credited View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Returns | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to include items that are fully returned but not fully credited | |
| Report name | Purchase Return Not Despatched View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Return lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to include items where there is an oustanding quantity to return | |
| Report name | Purchase Return Credit Note Pending View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Processing > Return lines | |
| Groups / sorts | The report is grouped by document number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered to include items where the return quantity is greater than the quantity invoiced | |
| Report name | Purchase Orders and Returns (Detailed) View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by document number, document status ID and supplier account number | |
| Report values | For each document line the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Orders and Returns Summary View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by document number and supplier account number | |
| Report values | For each document the report shows -
| |
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | |
| Report name | Purchase Invoice and Credit Notes View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by invoice/credit number, invoice/credit type and supplier account number | |
| Report values | For each invoice/credit item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Receipts and Despatches View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by document number, return type and supplier account number | |
| Report values | For each document item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Disputed Invoices and Credits View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by disputed ID, document number, invoice/credit number and supplier account number | |
| Report values | For each invoice/credit item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Order Cancelled Lines | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by item code and supplier account number | |
| Report values | For each cancelled item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Order Deliveries View report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by item code and order return numbers | |
| Report values | For each item the report shows -
| |
| Filter | The report is filtered to include only deliveries | |
| Report name | POP Items for Negotiation | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by item code | |
| Report values | For each item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | POP Receipts and Dispatches with Batch/Serial Items | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Batch/Serial Items | |
| Groups / sorts | The report is grouped by document number and by return type ID | |
| Report values | For each item the report shows -
| |
| Filter | The report is filtered not to include untraceable items | |
| Report name | Purchase Orders and Returns (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Archived | |
| Groups / sorts | The report is grouped by document number, document status ID, document type ID and supplier account number | |
| Report values | For each item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Orders and Returns (Archived) Summary | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Archived | |
| Groups / sorts | The report is grouped by order return ID, document status ID, document type ID and by supplier account number | |
| Report values | For each document the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Invoice and Credit Notes (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Archived | |
| Groups / sorts | The report is grouped by invoice/credit number, invoice credit type and supplier account number | |
| Report values | For each invoice/credit the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Purchase Order Cancelled Lines | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Status | |
| Groups / sorts | The report is grouped by item code and supplier account number | |
| Report values | For each cancelled item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | POP Additional Charges | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Purchase Order Processing > Maitenance | |
| Groups / sorts | The report is sorted by additional charge code | |
| Report values | For each additional item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | BOM SOP Items to be Made | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by SOP order returns document number, SOP order returns priority, SOP order returns status, SOP order return type and customer account number | |
| Report values | For each customer account the report shows -
| |
| Filter | The report is filtered to include items from sales orders that are part of BOM and still need to be completed | |
| Report name | BOM Costing History | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is sorted by BOM reference and the date and time of costing | |
| Report values | For each BOM costing the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | BOM Costing History (With Breakdown) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by BOM cost session ID, date/time costed and reference | |
| Report values | For each BOM session ID the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | BOM Traceable Built Items Report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by traceable product ID number | |
| Report values | For each traceable ID the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | BOM Traceable Components Report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by traceable components ID number | |
| Report values | For each traceable ID the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Where Used - Compoenent | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by stock item, product group and sorted by BOM record and Sage 200 Version | |
| Report values | For each product group the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Where Used - Drawing | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by drawing reference and sorted by BOM record and Sage 200 Version | |
| Report values | For each drawing reference the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Where Used - Operation | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by operations reference and sorted by BOM record, Sage 200 Version and sequence number | |
| Report values | For each operations reference the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Where Used - Labour Resource | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by labour resource reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each labour resource the report shows -
| |
| Filter | The report is filtered to show labour resource types only | |
| Report name | Where Used - Labour Resource Group | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by labour resource group reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each labour resource group the report shows -
| |
| Filter | The report is filtered to show labour resource group types only | |
| Report name | Where Used - Machine Resource | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by machine resource reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each machine resource the report shows -
| |
| Filter | The report is filtered to show machine resource types only | |
| Report name | Where Used - Machine Resource Group | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by machine resource group reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each machine resource group the report shows -
| |
| Filter | The report is filtered to show machine resource group types only | |
| Report name | Where Used - Tool Resource | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by tooling resource reference and is sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each tooling resource the report shows -
| |
| Filter | The report is filtered to show tooling resource types only | |
| Report name | Where Used - Tool Resource Group | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by tooling resource group reference and is sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference | |
| Report values | For each tooling resource group the report shows -
| |
| Filter | The report is filtered to show tooling resource group types only | |
| Report name | Bill of Material Audit Trail Log | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by BOM History reference, BOM History family identifier, BOM records reference and sorted by BOM history Sage 200 Version and BOM history date/time created | |
| Report values | For each BOM record reference the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Construction Report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by BOM Sage 200 Version, reference and sorted by component sequence and stock code | |
| Report values | For each BOM Sage 200 Version the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Allocation Report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by wop number, component, stock code, allocation balances and sorted by warehouse and bin | |
| Report values | For each wop number the report shows -
| |
| Filter | The report is filtered include component and sub-assembly items which have a quantity allocated greater than zero | |
| Report name | Allocation Report with Unassigned Batch/Serial Number | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by allocation balances, wop component stock code, wop number and sorted by warehouse and bin | |
| Report values | For each wop number the report shows -
| |
| Filter | The report is filtered to include component and sub-assembly items which have a quantity allocated greater than zero | |
| Report name | BOM Build Report | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Bill of Materials > Reports | |
| Groups / sorts | The report is grouped by wop component traceable component ID, wop traceable product ID, wop component ID and wop build number | |
| Report values | For each wop build number the report shows -
| |
| Filter | There is no filter on the report | |
| Report name | Cost Analysis (By Group) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and sorted by project ID | |
| Report values | For each key area the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Cost Analysis (by Structure) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by Project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Profitability Breakdown (by Group) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and sorted by project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Profitability Breakdown (by Structure) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Revenue Analysis (by Group) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and sorted by project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Revenue Analysis (by Structure) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered to not include archived projects that are not part of a template | |
| Report name | Cancelled Invoices | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Billing | |
| Groups / sorts | There are no groups or sorts on the report | |
| Report values | For each cancelled invoice the report shows -
| |
| Filter | The report is filtered to include cancelled invoice only | |
| Report name | Cost Transactions | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each cost transaction the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
| Report name | Nominal Transactions | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each nominal transaction the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
| Report name | Revenue Transactions | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each revenue transaction the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
| Report name | Timesheet Summary (by Resource) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by resource ID and project item | |
| Report values | For each resource item the report shows -
| |
| Filter | The report is filtered not to include archived projects | |
| Report name | Timesheet Summary (by Resource) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by resource ID, last name and project item | |
| Report values | For each resource ID item the report shows -
| |
| Filter | The report is filtered not to include archived projects | |
| Report name | Timesheet Transaction (by Resource) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by resource ID and project item | |
| Report values | For each project item ID the report shows -
| |
| Filter | The report is filtered not to include archived projects | |
| Report name | Timesheet Transaction (by Project) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by record ID and project item ID | |
| Report values | For each project item ID item the report shows -
| |
| Filter | The report is filtered not to include archived projects | |
| Report name | Timesheet Transaction (Charges and Costs) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by human resource ID and project item ID | |
| Report values | For each project item ID item the report shows -
| |
| Filter | The report is filtered not to include archived projects | |
| Report name | Expense Transaction (by Resource) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by human resource ID and claim number | |
| Report values | For each claim number the report shows -
| |
| Filter | The report is filtered not to include archived projects and where a quantity is greater than zero | |
| Report name | Payroll Report (by Resource) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Timesheets & Expense Claims | |
| Groups / sorts | The report is grouped by human resource ID, last name, payment frequency and company name | |
| Report values | For each resource ID the report shows -
| |
| Filter | The report is filtered not to include archived projects or by resource ID | |
| Report name | Project List | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by customer ID, account ID and project item ID | |
| Report values | For each customer ID the report shows -
| |
| Filter | The report is filtered on project item type and not to include archived projects | |
| Report name | Project List (by Customer) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by customer ID and project item ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered on project item type and to not include archived projects | |
| Report name | Project List (by Status) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by customer ID, project item ID and project status | |
| Report values | For each customer ID the report shows -
| |
| Filter | The report is filtered on project item type and to not include archived projects | |
| Report name | Project List (Setup) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by cost item type ID | |
| Report values | For each cost item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Project Item List (by Project) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by project item ID | |
| Report values | For each project item code the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Project List (Integration) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by cost item type ID | |
| Report values | For each cost item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Project Item Type List | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is not grouped or sorted | |
| Report values | For each cost item the report shows -
| |
| Filter | The report is not filtered | |
| Report name | Additional Information List | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by analysis field name | |
| Report values | For each additional field the report shows -
| |
| Filter | The report is filtered to only show if the additional fields are used | |
| Report name | Cost Analysis (by Structure) (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by Project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered not to include archived projects and those that are not part of a template | |
| Report name | Profitability Breakdown (by Structure) (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by project ID | |
| Report values | For each project id the report shows -
| |
| Filter | The report is filtered not to include archived projects and those that are not part of a template | |
| Report name | Revenue Analysis (by Structure) (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Analysis | |
| Groups / sorts | The report is sorted by project ID | |
| Report values | For each project ID the report shows -
| |
| Filter | The report is filtered not to include archived projects or those that are not part of a template | |
| Report name | Cost Transactions (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each cost transaction the report shows -
| |
| Filter | The report is filtered not to include show archived projects and zero values or zero quantities | |
| Report name | Nominal Transaction (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each nominal transaction the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
| Report name | Revenue Transactions (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Transactions | |
| Groups / sorts | The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date | |
| Report values | For each revenue transaction the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
| Report name | Project List (Archived) | |
|---|---|---|
| Sage 200 Version | 2011 and above | |
| Location | Project Accounting > Setup | |
| Groups / sorts | The report is grouped by customer ID, Account ID and project item ID | |
| Report values | For each customer ID the report shows -
| |
| Filter | The report is filtered not to include archived projects and zero values or zero quantities | |
If you're unable to find the help you require from our online resources, log a new case with us without having to use phone or email. Simply select 'Manage your cases' from the dashboard or visit my.sage.co.uk/cases