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. TIP: In addition to the standard reports, don't forget you can also use the Report Library, read more. NOTE: 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. Sales Ledger Day Book 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 - - Posted date
- Account number
- Transaction date
- Unique reference number
- Transaction reference
- Net, VAT and gross amounts
- Original exchange rate
| Filter | There is no filter on the report | List of Accounts 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 - - Account number
- Short name
- Currency
- Country
- Balance
- Date last amended
- Date of last transaction
- On hold status
- Finance rate
- Analysis 1,2 and 3
| Filter | There is no filter on the report | Account Details 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 - - Account number, short name, account name and address
- Contact name
- Phone number
- Fax number
- Payment terms
- VAT details
- Currency
- Default nominal account
- Cost centre
- Department
- Trading terms
- Credit reference
- Credit bureau
- Credit position
- Average time to pay
- Last transaction date
- Date account last amended
- Accounting type
- Finance charges
- Terms agreed
- Current balance
- Credit limit
- Turnover MTD
- Discount %
- Discount days
- Line discount %
- Invoice discount %
- Account opened date
- Last credit review date
- Next credit review date
- Application date
- Date received
| Filter | There is no filter on the report | Transaction Listing (Current) 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 - - Unique reference number
- Transaction type
- Reference
- Transaction date
- Due date
- Query code
- Settled immediately
- Net, VAT, discount and VAT discount totals
- Allocated amount
- Outstanding amount (in foreign currency)
- Outstanding amount (in base currency)
| Filter | There is no filter on the report | Transaction Listing (by Period) 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 - - Unique reference number
- Transaction type
- Reference
- Transaction date
- Due date
- Query code
- Settled immediately
- Net, VAT, discount and VAT discount totals
- Allocated amount
- Outstanding amount (in foreign currency)
- Outstanding amount (in base currency)
| Filter | There is no filter on the report | Transaction Listing (Historical) 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 - - Unique reference number
- Transaction type
- Reference
- Transaction date
- Net value
- VAT value
- Discount value
| Filter | There is no filter on the report | Vatable Transactions 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 - - Transaction type
- Reference
- Transaction date
- Net, VAT, gross value (in base currency)
- Net, VAT, gross value (in foreign currency)
| Filter | The report has a filter to only include invoices and credit notes | Trading Report (Detailed) 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) - - Account number
- Name
- Spend this YTD
- Spend last year
- Spend future
- Spend for 7 periods (1 column per period)
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 | Trading Report (Summary) 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 - - Account number
- Name
- Turnover MTD
- Turnover YTD
- Turnover last year
- Current balance
- Date of last transaction
| Filter | There is no filter on the report | RCSL Report (Detailed) 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 - - Account number
- Name
- VAT registration number
- Transaction unique reference number
- Transaction type
- Tax point date
- Goods value
- Notional tax value
| 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 | RCSL Report (Summary) 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 - - Account number
- Name
- VAT registration number
- Goods value
- Notional tax value
| 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 | Aged Debtors (Detailed) 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 - - Account number
- Account name
- Date of last transaction
- Unique reference number
- Transaction type
- Query code
- Reference
- Transaction date
- Due date
- Amounts for 5 periods (1 column per period)
- Total amount outstanding (in base currency)
- Total amount outstanding (in foreign currency if applicable)
- Payment term days
- Account contact name
- Account telephone number
| Filter | There is no filter on the report | Aged Debtors (Summary) 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 - - Account number
- Account name
- Amounts for 5 periods (1 column per period)
- Total amount outstanding (in base currency)
- Account contact name
- Account telephone number
| Filter | There is no filter on the report | Aged Debtors (Summary) with Unallocated 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 - - Account number
- Account name
- Date of last transaction
- Amounts for 5 periods (1 column per period)
- Total amount outstanding (in base currency)
- Unallocated amount (in base currency)
- Account contact name
- Account telephone number
| Filter | There is no filter on the report | Due Date (Detailed) 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 - - Account number
- Account name
- Contact name
- Payment terms
- Account contact telephone number
- Transaction type
- Reference
- Second reference
- Transaction Date
- Due date
- Amount outstanding (in base currency)
- Amount outstanding (in foreign currency)
- Age of debt
| Filter | There is no filter on the report | Due Date (Summary) 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 - - Account number
- Account name
- Contact name
- Payment terms
- Account contact telephone number
- Amount outstanding (in base currency) for 5 periods (1 column per period)
- Total amount outstanding (in base currency)
- A note if the account exceeds its credit limit
| Filter | There is no filter on the report | Nominal Ledger Day Books 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 - - Posting date
- Account
- Cost centre
- Department
- Transaction date
- Unique reference number
- Reference number
- Amount
| Filter | There is no filter on the report | | List of Accounts 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 - - Account reference
- Cost centre
- Department
- Account name
- Account type
- Category code
- Category name
| Filter | There is no filter on the report | | Account Analysis (Detailed) 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 - - Account reference
- Cost centre
- Department
- This month's debit, credit and balance
- Year to date debit, credit and balance
| Filter | The report filters out account types "M" and āPā and will not show a line if the year to date value is blank | Account Analysis (Summary) 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 - - Account reference
- Cost centre
- Department
- This monthās debit, credit and balance
- Year to date debit, credit and balance
| Filter | The report filters out account types āMā and āPā and will not show a line if the year to date is blank | Account Analysis (Posting Accounts) 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 - - Account reference
- Cost centre
- Department
- This monthās debit, credit and balance
- Year to date debit, credit and balance
| Filter | The report is filtered to show if there is a value in the year to date column | Account Analysis by Number (Detailed) 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 - - Account reference
- Cost centre
- Department
- This monthās debit, credit and balance
- Year to date debit, credit and balance
| 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 | Account Analysis by Number (Summary) 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 - - Account reference
- Cost centre
- Department
- This monthās debit, credit and balance
- Year to date debit, credit and balance
| 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 | Transaction Listing (Current) 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 - - Account reference
- Cost centre
- Department
- Account name
- Brought forward balance
- Unique reference number
- Transaction date
- Period
- Reference
- Narrative
- Debit
- Credit
- Analysis code
| Filter | There is no filter on the report | Transaction Listing (Historical) 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 - - Account reference
- Cost centre
- Department
- Account name
- Brought forward balance
- Unique reference number
- Transaction date
- Period
- Reference
- Narrative
- Debit
- Credit
- Analysis code
| Filter | There is no filter on the report | | Non-trading Vatable Transactions 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 - - Transaction type
- Reference
- Transaction date
- Net, VAT and gross total
| Filter | The report is filtered to only show sales and purchase tax journals | Unique Reference Report (Current) 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 - - User number
- Source name
- Unique reference number
- Transaction date
- VAT month
- Account number
- Cost centre
- Department
- Account name
- Reference
- Narrative
- Transaction analysis code
- Debit
- Credit
| Filter | There is no filter on the report | Unique Reference Report (Historical) 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 - - User number
- Source name
- Unique reference number
- Transaction date
- VAT month
- Account number
- Cost centre
- Department
- Account name
- Reference
- Narrative
- Transaction analysis code
- Debit
- Credit
| Filter | There is no filter on the report | View Waiting Postings 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 - - Unique reference number
- Transaction date
- Posting date
- Cost centre
- Department
- Account name
- Reference
- Narrative
- Transaction analysis code
- Debit
- Credit
| Filter | There is no filter on the report | View Waiting Postings Report (Deferred) 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 - - Unique reference number
- Transaction date
- Posting date
- Cost centre
- Department
- Account name
- Reference
- Narrative
- Transaction analysis code
- Debit
- Credit
| Filter | There is no filter on the report | Departmental Analysis (Detailed) 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 - - Department number and name
- Supplier account number
- Cost centre
- Department
- Account name
- Analysis code
- Print sequence
- Unique reference number
- Transaction date
- Period
- Reference
- Narrative
- Debit
- Credit
- Balance
| Filter | There is no filter on the report | Departmental Analysis (Summary) 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 - - Department
- Debit
- Credit
- Balance
| Filter | There is no filter on the report | Departmental Analysis 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 - - Nominal account
- Department
- Cost centre
- Account name
- Debit
- Credit
- Balance
| Filter | There is no filter on the report | Previous Year Journal Listing 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 - - Account number
- Cost centre
- Department
- Account name
- Brought forward balance
- Unique reference number
- Transaction date
- Period
- Reference
- Narrative
- Debit
- Credit
- Analysis code
| Filter | The report is filtered to only show transactions from the previous tax year | Manual Journal Listing 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 - - Account number
- Cost centre
- Department
- Account name
- Brought forward
- Print sequence
- Unique reference number
- Transaction date
- Period
- Reference
- Narrative
- Debit
- Credit
- Analysis code
| Filter | The report is filtered to only show transactions that have been entered manually | Trial Balance (Detailed) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to only show a line if there is a value in the year to date column | Trial Balance (Summary) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a value in the year to date column | Trial Balance (Posting Accounts) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a year to date value | Trial Balance by Number (Detailed) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a year to date value | Trial Balance by Number (Summary) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a year to date value | Trial Balance by Prior Year (Detailed) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a year to date value | Trial Balance Prior Year (Summary) 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 - - Account name
- Account reference
- Cost centre
- Department
- Net debit, credit and balance for this period
- Net debit, credit and balance year to date
| Filter | The report is filtered to show if there is a year to date value | Profit and Loss (Detailed) 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 - - Account name
- Current year and prior year
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD) 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 - - Account name
- Selected year period and YTD and previous year period and year to close
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD) by cost centre 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 - - Account name
- Selected year period and YTD
- Previous year period and year to close
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD-Budgets) 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 - - Account name
- Period budget and actual
- Year to date budget and actual
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD-Budgets) by cost centre 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 - - Account name
- Period budget and actual
- Year to date budget and actual
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD-Percentages) 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 - - Account name
- Period and year to date %
| Filter | There is no filter on the report | Profit and Loss (MTD-YTD-Percentages) by cost centre 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 - - Account name
- Period and year to date %
| Filter | There is no filter on the report | Profit and Loss Report Prior Year 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 - - Account name
- Previous month and previous year to date values
| Filter | There is no filter on the report | Balance Sheet (MTD-YTD) 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 - - Account name
- This period and year to date values
- Previous year period and year to date values
| Filter | There is no filter on the report | Balance Sheet (MTD-YTD) by Cost Centre 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 - - Account name
- This period and year to date values
- Previous year period and year to date values
| Filter | There is no filter on the report | Balance Sheet (YTD) 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 - - Account name
- Selected year and previous year values
| Filter | There is no filter on the report | Balance Sheet (YTD) by Cost Centre 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 - - Account name
- Selected year and previous year values
| Filter | There is no filter on the report | Balance Sheet Report Prior Year 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 - - Account name
- Prior month and prior year to date values
| Filter | There is no filter on the report | Profit and Loss Memo Accounts 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 - - Account reference
- Cost centre
- Department
- Account name
- Debit and credit YTD values
| Filter | The report is filtered to only show memo accounts from the profit and loss financial statement | Balance Sheet Memo Accounts 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 - - Account reference
- Cost centre
- Department
- Account name
- Debit and credit YTD values
| Filter | The report is filtered to only show memo accounts from the balance sheet financial statement | Cash Flow Report 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 - - The financial statement title
- Cash flow for 20 periods
| Filter | There is no filter on the report | Detailed Budgets 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for 13 months (1 column per period)
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Detailed Budgets by Number 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for 13 months (1 column per period)
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Summary Budgets 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for 13 months
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Summary Budgets by Number 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for 13 months
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Individual Budgets 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for 13 months
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Detailed Budgets (Previous Year) 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 - - Account number and name
- Cost centre
- Department
- Budget, actual, difference and % for the previous 13 months
- Remaining budget
| Filter | The report is filtered to only show if there is a budget | Fixed Assets Fixed Asset Details 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 - - Asset number and description
- Depreciation method
- Initial value
- Depreciation percent
- Net book value
- Balance sheet and profit and loss nominal codes
- Residual value
- Total depreciation
- Asset lifespan
- Total disposal
| Filter | There is no filter on the report | Fixed Asset Valuation 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 - - Asset number and description
- Depreciation method
- Initial value
- Depreciation date
- Total depreciation
- Disposal date
- Total disposal
- Net book value
| Filter | There is no filter on the report | Cash Book Account Details 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 - - Account number
- Description
- Bank name and address
- Sort code
- Contact name and number
- Account number and name
- Account type
- Current balance
- Nominal bank account
- Bank charges
- Exchange differences
| Filter | There is no filter on the report | Transaction Listing 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 - - Unique reference number
- Transaction type
- Account number
- Cost centre
- Department
- Transaction date
- Statement date
- Reference
- Second reference
- Narrative
- Debit
- Credit
| Filter | There is no filter on the report | Transaction Listing (Period) 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 - - Account code
- Account number
- Account code
- Account type
- Account description
- Account name
- Current balance
- Unique reference number
- Transaction type
- Account number
- Cost centre
- Department
- Transaction date
- Statement date
- Reference
- Second reference
- Narrative
- Debit
- Credit
| Filter | There is no filter on the report | Unpresented Cheques (Receipts) 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 - - Bank account code and description
- Currency
- Statement balance as at last statement date
- Transaction type
- Transaction date
- Reference
- Second reference
- Receipt
- Statement amount
- Discrepancy
| Filter | The report is filtered to only to show unpresented cheque receipts | Unpresented Cheques (Payments) 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 - - Bank account code and description
- Currency
- Statement balance as at last statement date
- Transaction type
- Transaction date
- Reference
- Second reference
- Payment
- Statement Amount
- Discrepancy
| Filter | The report is filtered to only show unpresented payment cheques | Unpresented Cheques (Both) 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 - - Bank account code and description
- Currency
- Statement balance as at last statement date
- Transaction type
- Transaction date
- Reference
- Second reference
- Payment
- Receipt
- Statement Amount
- Discrepancy
| Filter | The report is filtered to only show unpresented cheques for either payments or receipts | Stock Control Stock Levels 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 - - Product group code and description
- Stock item code and name
- Stock level
- Quantity allocated
- Free stock
- Unit name
- Inactive status
| Filter | The report is filtered to not include phantom built item types (linked to BOM items) and that it is a stock item | Stock Sales Order Shortfalls 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 - - Product group code
- Stock item code and description
- BOM flag
- Free quantity
- Re-order level
- Required
- Needs re-order flag
| Filter | The report is filtered to show items which are not fully despatched and that are not trade counter orders | Stock Expected In/Out 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 - - Warehouse name
- Product group code and description
- Item code and name
- Stock levels
- Quantity on order
- Due in stock
- Quantity allocated
- Due to be left
| 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 | Negative Stock Levels 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 - - Warehouse name
- Stock item code
- Bin name
- Quantity
- Stock unit name
- Movement date
- Source area reference
- Area type name
| Filter | The report is filtered to show negative stock and not to include phantom built items (linked to BOM) | Stock Levels Buying Price Breakdown 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 - - Stock item code and name
- Stock unit name
- Movement date
- Cost price
- Movement quantity
- Movement value
- Movement type
- Movement reference
- Scourer area reference
| Filter | The report is filtered not to include phantom built items (linked to BOM) | Stock Valuation 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 - - Product group code
- Valuation method
- Item code and name
- Quantity including unconfirmed items
- Quantity
- Unit name
- Valuation price
- Value including unconfirmed
- Value
| Filter | The report is filtered not to include phantom built items (linked to BOM) and to only show stock items with a value | Allocation Outstanding 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 - - Warehouse name
- Stock item code and name
- Stock unit name
- Allocation rule
- Allocation recipient reference
- Bin name
- Allocation date
- Allocation reference
- Quantity allocated
| Filter | The report is filtered not to include phantom built items (linked to BOM) | Below Re-Order Levels with Alternatives 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 - - Warehouse name
- Product group code
- Stock item code and name
- Stock unit name
- Re-order level
- Current stock level
- Free stock quantity
- Alternative item code and name
- Quantity in stock
- Free stock
| 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 | Below Re-Order Levels with Suppliers 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 - - Warehouse name
- Product group
- Stock item code and name
- Stock item name
- Stock unit name
- Re-order level
- Current stock level
- Free stock quantity
- Supplier account number and name
- Preferred supplier flag
- Lead time
| 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 | Date of Last Sale 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 - - Stock item code and name
- Quantity in stock
- Date of last sale
| Filter | The report is filtered to not include phantom built items (linked to BOM) | Period Profitability 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 - - Stock item code
- Quantity purchased
- Value purchased
- Quantity sold
- Value sold
- Cost value of sales
- Profit
| 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 | Profit by Customer 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 - - Stock item code and name
- Stock unit name
- Transaction date
- Transaction name
- Quantity
- Reference
- 2nd reference
- Sales price
- Cost
- Profit
- Profit % Sales
- Profit % Cost
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | Profit by Customer (Summary) 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 - - Customer account number and name
- Sale price
- Cost price
- Profit
- Profit % Sales
- Profit % Cost
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | Profit by Stock Item 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 - - Stock item code and name
- Stock unit name
- Transaction date
- Transaction name
- Quantity
- Sales value
- Cost
- Profit
- Profit % Sales
- Profit % Cost
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | Profit by Stock Item (Summary) 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 - - Stock item code and name
- Stock unit name
- Quantity
- Sales value
- Cost
- Profit
- Profit % Sales
- Profit % Cost
| Filter | The report is filtered to not include phantom built items (linked to BOM) and to look at sales orders and sales returns only | Stock Items 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 - - Product group code
- Stock item type name
- Costing method name
- Group batch/serial type
- Item code, name and description
- Standard cost
- Item status
- Item batch/serial type
- Stocktake cycle
- Stock unit name
- Manufacturer
- Part number
| Filter | The report is filtered to not include phantom built items (linked to BOM) | Items with Supplier 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 - - Item code and name
- Stock unit name
- Item status
- Supplier account reference and name
- Supplier stock code
- Lead time
- Usual order quantity
- Minimum order quantity
- Date of last order
- Last buying price
| Filter | The report is filtered to not include phantom built items (linked to BOM) | Items with Search Values 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 - - Item code and name
- Search category and value
| Filter | The report is filtered to not include show phantom built items (linked to BOM) | Product Groups Report 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 - - Product group code and description
- Stock item type
- Costing method
- Batch/Serial type
| Filter | There is no filter on the report | Product Groups Search Categories 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 - - Product group code and description
- Stock item type
- Search category name and value
| Filter | There is no filter on the report | Batch/Serial Locations and Quantities 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 - - Product group code and description
- Stock item type
- Search category name and value
| Filter | There is no filter on the report | Batch/Serial Items Status 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 - - Product group code and description
- Batch/Serial number
- Item code and name
- Quantity
- Batch serial type name
| Filter | The report is filtered not to include pre-receipt transactions and the goods in per bin do not match the goods out | Batch/Serial Allocations 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 - - Item code and name
- Stock unit name
- Batch/Serial number
- Allocation recipient reference
- Bin name
- Allocation date
- Reference
- Quantity Allocated
- Batch/Serial type
| Filter | The report is filtered to show traceable items only and the allocated quantity does not equal zero | Batch/Serial Items Status 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 - - Product group code and description
- Batch/Serial number
- Item code and name
- Quantity
- Batch serial type name
| Filter | The report is filtered to not include pre-receipt transactions and the goods in per bin does not match the goods out | Item Sell by Dates Report (by Warehouse) 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 - - Batch/Serial type name and number
- Item code and name
- Warehouse name
- Quantity
- Free stock
- Stock unit name
| Filter | The report is filtered to show items which have a sell by date and the quantity in and out does not equal zero | Item Sell by Dates Report (by Stock Item) 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 - - Item code and name
- Stock unit name
- Sell by date
- Batch/Serial type name
- Traceable ID number
- Warehouse name
- Bin name
- Quantity
- Free stock
| Filter | The report is filtered to show items which have a sell by date and the quantity in and out does not equal zero | Item Use by Dates Report (by Warehouse) 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 - - Use by date
- Batch/Serial name and number
- Item code and name
- Bin name
- Quantity
- Free stock
- Stock unit name
| Filter | The report is filtered to show items with a use by date | Item Use by Dates Report (by Stock Item) 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 - - Item code and name
- Stock unit name
- Use by date
- Batch/Serial name and number
- Warehouse name
- Bin name
- Quantity
- Free stock
| Filter | The report is filtered to show items with a use by date | Item Settings for Batch/Serial 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 - - Item code and name
- Batch/Serial type
- Permit duplicate serial/batch number flag
- Fulfil sales from single batch flag
- Alternative reference used flag
- Allow sell by date flag
- Allow use by date flag
- Received goods without confirmed numbers flag
- Basis for shelf life
- Auto generated numbers flag
- Prefix
- Next number
| Filter | The report is filtered to show traceable items only | Stock Transactions Batch/Serial Numbers 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 - - Item code and name
- Unit name
- Batch/Serial type
- Warehouse name
- Batch/Serial number
- Transaction date
- Type
- Quantity
- Source area type reference and name
- Reference
- Bin name
| Filter | The report is filtered to show traceable items only | Stock Transactions (Archived) for Batch/Serial 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 - - Item code and name
- Unit name
- Batch/Serial number
- Date
- Type
- Quantity
- Area reference
- Source area type reference and name
- Reference
- Warehouse name
- Bin name
| Filter | The report is filtered to show traceable items only | Transaction History 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source name
- Reference
- Second reference
- Warehouse
- Bin name
- Fully realised flag
| Filter | The report is filtered to not show obsolete items (linked to BOM) | Transaction History (Archived) 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source name
- Reference
- Second reference
- Warehouse
- Bin name
| Filter | The report is filtered to not show obsolete items (linked to BOM) | Sales Stock Transaction History 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source reference
- Reference
- Warehouse name
- Bin name
- Cost value
- Issue value
| Filter | The report is filtered to not include obsolete items (linked to BOM) and only show sales orders and returns | Sales Stock Transaction History (Archived) 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source reference
- Reference
- Warehouse name
- Bin name
- Cost value
- Issue value
| Filter | The report is filtered to not include obsolete items (linked to BOM) and only show sales orders and returns | Simple Stock Transaction History 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source reference and name
- Reference
- Second reference
- Warehouse name
- Bin name
| Filter | The report is filtered to not include obsolete items (linked to BOM) and internal or customer allocations | Simple Stock Transaction History (Archived) 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 - - Item code and name
- Unit name
- Date
- Transaction type
- Quantity
- Source area type name
- Source reference and name
- Reference
- Second reference
- Warehouse name
- Bin name
| Filter | The report is filtered to not include obsolete items (linked to BOM) and internal or customer allocations | Stock Average Cost History 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 - - Item code and name
- Changed date
- Average buying price
| Filter | The report is filtered not to include obsolete items (linked to BOM) | Stock Standard Cost History 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 - - Item code and name
- Changed date
- Standard cost price
| Filter | The report is filtered not to include obsolete items (linked to BOM) | Stocktake Required 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 - - Warehouse name
- Product group code
- Item code and name
- Stocktake cycle period
- Bin name
- Last stocktake date
- Due date
| Filter | The report is filtered not to include obsolete items (linked to BOM) | Stocktake Status 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 - - Stocktake name
- Stocktake date
- Warehouse name
- Last completed stocktake date
- Status
| Filter | The report is filtered not to include warehouses linked to returns and direct delivery | Stock Items Without Stocktake 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 - - Warehouse name
- Product group
- Item code and name
- Stocktake cycle period
- Bin name
| Filter | The report is filtered not to include obsolete items (linked to BOM) and where the last count is blank | Locations 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 | Search Categories 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 - - Search category
- Search value
| Filter | There is no filter on the report | Sales Order Processing Order Status 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 - - Document number
- Customer account number and name
- Promised for
- Priority
- Net amount
- Allocated, despatched and invoiced flags
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | Not Fully Allocated 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 - - Document number
- Customer account number and name
- Status
- Order date
- Promised for
- Priority
- Net amount
- Allocated flag
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show all items that are not fully allocated | Fully Allocated Not Fully Despatched 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 - - Document number
- Customer account number and name
- Status
- Order date
- Promised
- Priority
- Net amount
- Despatched flags
| 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 | Fully Despatched Not Fully Invoiced 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 - - Document number
- Customer account number and name
- Status
- Order date
- Promised
- Priority
- Net amount
- Despatched flags
| 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 | Sales Orders Not Acknowledged 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 - - Document number
- Customer account number and name
- Amended since last printed flag
- Order date
- Promised
- Priority
- Net amount
| Filter | The report is filtered only to include orders that are not fully acknowledged | Sales Order Allocations Required 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 - - Document number
- Status
- Date
- Promised delivery date
- Customer account number and name
- Priority
- Print sequence
- Item code
- Description
- Allocation required
- Unit description
- Promised
| 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 | Sales Orders Allocation Not Despatched 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 - - Document number
- Status
- Date
- Promised delivery date
- Customer
- Priority
- Print sequence
- Item code
- Description
- To invoice
- Unit description
- Despatched date
- Quantity to be despatched
| Filter | The report is filtered to include items have been despatched but not invoiced | Sales Order Despatches 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 - - Document number
- Status
- Date
- Promised delivery date
- Customer account number and name
- Priority
- Despatch number
- Despatch date
- User name
- Print sequence
- Item code
- Description
- Quantity to invoice
- Unit description
- Despatched date
- Quantity to despatch
| Filter | The report is filtered to not include previously invoiced goods | Sales Returns Status 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 - - Document number
- Customer
- Status
- Return date
- Promised for
- Priority
- Received and credited flags
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | Sales Returns Not Fully Received 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 - - Document number
- Customer account number and name
- Status
- Return date
- Promised for
- Priority
- Net
- Recieved and credited flags
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show that are not fully returned | Sales Returns Fully Received Not Fully Credited 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 - - Document number
- Customer account number and name
- Status
- Return date
- Promised for
- Priority
- Net
- Credited flag
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show items fully received but not fully credited | Sales Returns Receipts Pending 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 - - Document number
- Status
- Document date
- Expected delivery date
- Customer account number and name
- Priority
- Print sequence
- Item code
- Description
- Total quantity
- Outstanding
- Unit description
- Expected delivery date
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and show available amounts to despatch | Sales Returns Receipts Not Credited 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 - - Document number
- Status
- Document date
- Expected delivery date
- Customer account number and name
- Priority
- Print sequence
- Item code
- Description
- Amount to credit
- Unit description
- Quantity to be received
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items and items returned but not credited | Payment Methods Totals Summary 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 - - Document number
- Order date
- Order status
- Customer account number
- Customer name
- Customer order number
- Value
| Filter | The report is filtered not to include records where the payment method name is blank | Sales Order(Detailed) 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 - - Document number
- Status
- Net, VAT and gross amount
- Document date
- Promised delivery date
- Customer order number
- Print sequence
- Item description
- Allocated quantity
- Line quantity
- Despatch quantity
- Line total
| Filter | There is no filter on the report | Sales Order(Summary) 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 - - Document number
- Order status
- Document date
- Promised delivery date
- Priority
- Net, VAT and gross amounts
| Filter | There is no filter on this report | Sales Orders Book Report (Detailed) 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 - - Document name
- Document number
- Order status
- Document date
- Promised delivery date
- Print sequence
- Item code
- Item description
- Uninvoiced quantity
- Uninvoiced value
- Uninvoiced value(Base)
- Line totals
- Promised delivery date
| Filter | The report is filtered to only show amounts that have not been invoiced | Order Allocations 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 - - Customer account number
- Customer account name
- Unit name
| Filter | The report is not filtered | Order Despatches 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 - - Document number
- Despatch date
- Print sequence
- Promised delivery date
- Print sequence
- Invoiced flag
- Invoice number
- Item code
- Item description
- Quantity despatched
- Unit description
- User name
| Filter | The report is not filtered | Returns Receipts 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 - - Document number
- Despatch date
- Return number
- Credited flag
- Credit note number
- Item code
- Item description
- Quantity
- Unit descrption
- Warehouse name
- Bin name
- Username
| Filter | The report is not filtered | Cancelled Lines 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 - - Cancelled date
- Cancelled quantity
- Unit description
- Quantity
- Order/Return number
- Username
| Filter | The report is not filtered | Stock Items Allocation Required 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 - - Item code
- Item description
- Document number
- Amount to allocate
- Stock unit name
- Promised delivery date
| Filter | The report is filtered to only show if the quantity is greater than the quantity already allocated | Sales Orders and Returns with Unposted Invoices and Credit Notes 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 - - Document number
- Status
- Document date
- Customer account number
| Filter | The report is not filtered | Cancelled Invoices 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 - - Docuement date
- Invoice/Credit note number
- Date cancelled
- Reason cancelled
- Cancelled by
| Filter | The report is filtered to only show cancelled invoices | Overpaid Sales Orders 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 - - Document number
- Customer account number and name
- Status
- Order date
- Net / VAT and gross amounts
- Payment value
| Filter | The report is filtered to only show if the payment values is greater than the order value | Sales Order Profitability(Detailed) 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 - - Document number
- Item code
- Item description
- Quantity
- Sales value
- Estimated profit
- Estimated profit %
- Realised profit
- Realised profit %
- Fully realised flag
| Filter | The report is filtered to only show sales orders | Sales Order Profitability (Summary) 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 - - Customer account number and name
- Currency symbol
- document number
- Return type name
- Sales value
- Order status
- Estimated profit
- Estimated profit %
- Realised profit
- Realised profit %
| Filter | The report is filtered to only show sales orders | SOP Quotation Profitability (Detailed) 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 - - Document number
- Currency symbol
- Quotation status
- Item code
- Item description
- Quanitity
- Unit description
- Sales value
- Estimated profit
- Estimated profit %
| Filter | The report is filtered to only show Quotation | SOP Quotation Profitability (Summary) 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 - - Customer account number and name
- Currency symbol
- Document number
- Return name
- Sales value
- Quotation status
- Estimated profit
- Estimated profit %
| Filter | The report is filtered to only show Quotations | Invoice Profitability (Detailed) 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 - - Document number
- Currency symbol
- Item code
- Item description
- Quanitity
- Unit description
- Sales value
- Estimated profit
- Estimated profit %
| Filter | The report is filtered to only show Invoices | Invoice Profitability (Summary) 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 - - Customer account number and name
- Currency symbol
- Document number
- Return name
- Sales value
- Estimated profit
- Estimated profit %
| Filter | The report is filtered to only show Invoices | Allocations with Batch/Serial Items 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 - - Item code
- Item name
- Stock unit name
- Batch/Serial number
- Allocation Recipient reference
- Bin name
- Allocation date
- Reference
- quantity allocated
- Batch serial type
| Filter | The report is filtered to only traceable items | Despatches and Reciepts with Batch/Serial 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 - - document number
- Date
- Batch/serial number
- Order number
- Print sequence
- Invoice number
- Item description
- Quantity
- Batch/Serial type
| Filter | The report is filtered to only show traceable items | Invoices for Batch/Serial 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 - - document number
- Status
- Net, VAT and gross amount
- Date
- Discount valid until date
- Identification number
- Quantity
| Filter | The report is filtered to only show traceable items | Sales Order and Returns (Archived) 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 - - document number
- Date
- Net, VAT and gross amount
- Promised delivery date
- Print sequence
- Item code
- Despatch quantity
- Line total
| Filter | The report is not filtered | Sales Order and Returns (Archived) Summary 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 - - Customer account number and name
- Currency
- Document number
- Document date
- Promised for delivery date
- Net, VAT and gross totals
| Filter | The report is not filtered | Invoices and Credit Notes (Archived) 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 - - Customer account number and name
- Currency
- Invoice/Credit note number
- Document date
- Settlement discount days
- Net, VAT and gross totals
- Return type name
- Item code
- Item name
- Quantity
- Line total
| Filter | The report is not filtered | Invoices and Credit Notes (Archived) Summary 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 - - Customer account number and name
- Currency
- Invoice/Credit note number
- Document date
- Settlement discount days
- Net, VAT and gross totals
| Filter | The report is not filtered | Canceled Lines (Archived) 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 - - Customer account number and name
- Cancelled line item code
- Date
- Quantity
- Selling unit description
- Stock cancelled quantity
- Order number
- User name
| Filter | The report is not filtered | Additional Charges 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 - - Additional charge code
- Charge name
- VAT rate and code
- Nominal account name and number
- Cost centre
- Department
- Charge value
| Filter | The report is not filtered | Repeat Order Templates 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 - - Customer account name and number
- Return type name
- Repeat order description
- Schedule type
- Frequency
- On which day of the month
- Start date
- End date
- Total number of times to repeat
- Current Count
- Last generated date
| Filter | The report is not filtered | Sales Order Items 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 - - Stock item code
- Stock item name
- Stock item description
- Price
- VAT code and name
| Filter | The report is filtered to only show if the item is part of the product group code | SOP Customer Delivery Addresses 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 - - Customer account number and name
- Delivery address description
- Customer name and address
- Telephone number
- Fax number
- Email
- Contact name
| Filter | The report is not filtered | Purchase Order Processing Orders Status Report name | Purchase Orders Status | 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 - - Document number
- Supplier account number and name
- Status
- Order date
- Requested
- Invoiced
- Total Net amount
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | Not Fully Received Report name | Purchase Orders Not Fully Received | 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 - - Document number
- Supplier account number and name
- Status
- Order date
- Requested
- Total net value
- Received flag
| Filter | The report is filtered to include not fully received items | Fully Received Not Fully Invoiced Report name | Purchase Orders Fully Received Not Fully Invoiced | 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 - - Document number
- Supplier account number and name
- Status
- Order date
- Requested
- Net amount
- Invoiced flag
| Filter | The report is filtered to include items fully received that have either not been invoiced or have been part invoiced. | Purchase Orders Not Printed 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 - - Document number
- Supplier account number and name
- Status
- Amended since last printed flag
- Order date
- Requested
- Authorisation
| Filter | The report is filtered on print ID to only show if the order has not been printed | Items Requiring Ordering Report name | POP Items Requiring Ordering | 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 - - Item code
- Item name
- Quantity required
- Quantity to purchase
- Stock unit
- To negotiate flag
- Confirmed flag
| Filter | The report is not filtered | Back to Back Orders Required 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 - - Item code
- Item name
- Unit
- Customer account number and name
- Promised delivery date
- Sales order number
- Quantity required
| Filter | The report is not filtered | Order Receipts Pending Report name | Purchaser Order Receipts Pending | 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 - - Document number
- Status
- Date
- Requested delivery date
- Supplier account number and name
- Print sequence number
- Item code
- Item description
- Total quantity
- Quantity outstanding
- Unit description
| Filter | The report is filtered to include items if there is a quantity outstandiing | Order Invoices Pending Report name | Purchaser Order Invoices Pending | 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 - - Document number
- Status
- Date
- Supplier account number and name
- Item code
- Item description
- Quantity to be invoiced
- Unit description
- Quantity to be received
| Filter | The report is filtered to include items if there is a quantity to be invoiced | Returns Status Report name | Purchase Return Status | 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 - - Document number
- Supplier account number and name
- Status
- Date
- Requested delivery date
- Received flag
- Credited flag
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | Not Fully Despatched Report name | Purchase Return Not Fully Despatched | 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 - - Document number
- Supplier account number and name
- Status
- Return date
- Requested delivery date
- Net amount
- Despatched flag
| Filter | The report is filtered to show items if there is a return required | Fully Despatched Not Fully Credited Report name | Purchase Returns Fully Despatched Not Fully Credited | 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 - - Document number
- Supplier account number and name
- Status
- Return date
- Requested delivery date
- Total net value
- Credited flag
| Filter | The report is filtered to include items that are fully returned but not fully credited | Returns Not Despatched Report name | Purchase Return Not Despatched | 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 - - Document number
- Status
- Date
- Authorisation
- Supplier account number and name
- Print sequence
- Item code
- Item description
- Total quantity
- Outstanding quantity
- Unit description
| Filter | The report is filtered to include items where there is an oustanding quantity to return | Returns Credit Note Pending Report name | Purchase Return Credit Note Pending | 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 - - Document number
- Status
- Date
- Authorisation
- Supplier account number and name
- Print sequence
- Item code
- Item description
- Quantity to be credited
- Unit description
- To be despatched
| Filter | The report is filtered to include items where the return quantity is greater than the quantity invoiced | Orders and Returns (Detailed) Report name | Purchase Orders and Returns (Detailed) | 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 - - Document number
- Status
- Date
- Net, tax and gross
- Requested delivery
- Print sequence
- Item code
- Item description
- Quantity on order
- Line quantity
- Receipt quantity
- Line total
| Filter | The report is not filtered | Orders and Returns (Summary) Report name | Purchase Orders and Returns Summary | 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 - - Document number
- Supplier account number and name
- Status
- Document date
- Requested delivery date
- Credited flags
| Filter | The report is filtered not to include https://internal-kb.sage.com/solutionmanager items | Invoices and Credit Notes Report name | Purchase Invoice and Credit Notes | 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 - - Invoice/Credit number
- Invoice/Credit date
- Item code
- Disputed flag
- Invoice/Credit quantity
- Unit description
- Line tax value
- Line total value
- Username
| Filter | The report is not filtered | Receipts and Despatches Report name | Purchase Receipts and Despatches | 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 - - Document number
- Document date
- Order/Return number
- Print sequence number
- Item description
- Return quantity
- Unit description
- Warehouse name
- Bin name
- Username
| Filter | The report is not filtered | Disputed Invoices and Credits Report name | Disputed Invoices and Credits | 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 - - Invoice/Credit number
- Dispute number
- Dispute code and description
- Invoice/Credit date
- Item code
- Invoice/Credit quantity
- Unit description
- Lis tax amount
- Line total value
- Username
| Filter | The report is not filtered | Cancelled Order Lines 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 - - Item code
- Cancelled date
- Cancelled quantity
- Buying unit description
- Stock quantity
- Order/Return number
- Username
| Filter | The report is not filtered | Deliveries Report name | Purchase Order Deliveries | 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 - - Item code
- GRN number
- Supplier GRN number
- Delivery date
- Received by
- Quantity delivered
- Invoiced flag
| Filter | The report is filtered to include only deliveries | POP Items for Negotiation 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 - - Item code
- Warehouse name
- Status
- Quantity received
- Quantity confirmed
- Total cost
- Supplier account number and name
| Filter | The report is not filtered | Receipts and Dispatches with Batch/Serial Items 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 - - Document number
- Document date
- Batch/Serial number
- Order/Return number
- Print sequence number
- Item code
- Quantity
- Warehouse name
- Bin name
- Batch/Serial type
| Filter | The report is filtered not to include untraceable items | Purchase Orders and Returns (Archived) 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 - - Document number
- Document date
- Net, VAT and gross totals
- Requested delivery date
- Item code
- Item description
- Line quantity
- Receipt return quantity
- Line total
| Filter | The report is not filtered | Purchase Orders and Returns (Archived) Summary 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 - - Supplier account number and name
- Currency symbol
- Document name
- Document number
- Document date
- Requested delivery date
- Net, VAT and gross amounts
| Filter | The report is not filtered | Invoices and Credit Notes (Archived) 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 - - Invoice/Credit number
- Invoice/Credit date
- Item code
- Invoice/Credit quantity
- Unit description
- Line tax value
- Total line value
- Username
- Return type name
| Filter | The report is not filtered | Cancelled Order Lines 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 - - Item code
- Cancelled date
- Cancelled quantity
- Buying unit description
- Stock quantity
- Order/Return number
- Username
| Filter | The report is not filtered | Additional Charges 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 - - Additional charge code
- Additional charge name
- VAT code and name
- Nominal account name
- Nominal account number
- Cost centre
- Department
- Charge value
| Filter | The report is not filtered | Bill of Materials Sales Order with item To Be Made From BOM 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 - - Customer account number and name
- Currency
- Document number
- Status
- Document date
- Priority
- Net, VAT and gross amounts
- Print sequence
- Item code and description
- Allocated quantity
- Despatch quantity
- Line total
| Filter | The report is filtered to include items from sales orders that are part of BOM and still need to be completed | Costing History 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 - - BOM reference
- BOM Sage 200 Version
- BOM costed date/time
- Quantity costed
- Total overheads
- Total cost
- Total cost including overheads
- Unit cost
- Unit cost including overheads
| Filter | There is no filter on the report | Costing History (With Breakdown) 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 - - BOM reference
- BOM Sage 200 Version
- BOM costed date/time
- Quantity costed
- Total overheads
- Total cost
- Total cost including overheads
- Unit cost
- Unit cost including overheads
| Filter | There is no filter on the report | Traceable Built Items 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 - - Built item stock code
- Finished item name
- Identification number
- Build date
- Component code and name
- Build number and name
- Identification number
- Component quantity
| Filter | There is no filter on the report | Traceable Components 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 - - Compoenent stock code and name
- Identification number
- Finished item code and name
- Build number, date and name
- Identification number
- Component quantity
| Filter | There is no filter on the report | Where Used - Component 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 - - Product group code and description
- Component code and description
- BOM reference
- BOM Sage 200 Version
- BOM description
- Sequence number
- Quantity
- Unit of measure
| Filter | There is no filter on the report | Where Used - Drawing 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 - - Drawing reference and description
- Effective from date
- Effective to date
- BOM reference
- BOM Sage 200 Version
- BOM description
| Filter | There is no filter on the report | Where Used - Operation 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 - - Operations reference and description
- BOM reference
- BOM Sage 200 Version
- BOM description
- Sequence number
- Default run time in hours minutes and seconds
| Filter | There is no filter on the report | Where Used - Labour Resource 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 - - Labour resource reference and description
- BOM reference and description
- BOM Sage 200 Version
- Sequence number
- Operation reference and description
- Default run time in hours minutes and seconds
| Filter | The report is filtered to show labour resource types only | Where Used - Labour Resource Group 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 - - Labour resource group reference and description
- BOM reference and description
- BOM Sage 200 Version
- Sequence number
- Operation reference and description
- Default run time in hours minutes and seconds
| Filter | The report is filtered to show labour resource group types only | Where Used - Machine Resource 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 - - Machine resource reference and description
- BOM reference and description
- BOM Sage 200 Version
- Sequence number
- Operation reference and description
- Default run time in hours minutes and seconds
| Filter | The report is filtered to show machine resource types only | Where Used - Machine Resource Group 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 - - Machine resource group reference and description
- BOM reference and description
- BOM Sage 200 Version
- Sequence number
- Operation reference and description
- Default run time in hours minutes and seconds
| Filter | The report is filtered to show machine resource group types only | Audit Trail Log 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 - - History BOM reference
- BOM Sage 200 Version
- Created by
- Date/Time created
- Action
- History reference
| Filter | There is no filter on the report | Construction 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 - - BOM reference and description
- BOM Sage 200 Version
- BOM status
- Print sequence
- Stock code and description
- Quantity
- Unit of measure
- Line type
| Filter | There is no filter on the report | Allocation 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 - - Allocation number
- Reference
- Built item reference
- Sub-assembly flag
- Built item description
- Warehouse and bin name
- Stock code and description
- Quantity allocated
- Unit of measure
| Filter | The report is filtered include component and sub-assembly items which have a quantity allocated greater than zero | Allocation Report with Unassigned Batch/Serial Numbers 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 - - Allocation number
- Reference
- Built item reference
- Sub-assembly flag
- Built item description
- Warehouse and bin name
- Stock code and description
- Quantity allocated
- Unit of measure
| Filter | The report is filtered to include component and sub-assembly items which have a quantity allocated greater than zero | Build Report 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 - - Build number and reference
- Build date
- Built by
- Built item and name
- Quantity
- Unit of measure
- Unit cost
- Total cost
- Unit of measure
| Filter | There is no filter on the report | Sage Business Partners can now log new cases online! 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 [BCB:191:UKI - #GetMoreFeedback:ECB] |