This article provides details of the standard reports available within Sage 200.
Resolution
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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Orders |
Groups / sorts | The report is grouped by document number |
Report values | For each document number the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Orders |
Groups / sorts | The report is grouped by document number |
Report values | For each document number the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Orders |
Groups / sorts | The report is grouped by document number |
Report values | For each document number the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Order lines |
Groups / sorts | The report is grouped by warehouse name and sorted by re-order item code |
Report values | For each item the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Order lines |
Groups / sorts | The report is grouped by print sequence number and document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Order lines |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Returns |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Returns |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Returns |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Return lines |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Processing > Return lines |
Groups / sorts | The report is grouped by document number |
Report values | For each document the report shows - - 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) View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by document number, document status ID and supplier account number |
Report values | For each document line the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by document number and supplier account number |
Report values | For each document the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by invoice/credit number, invoice/credit type and supplier account number |
Report values | For each invoice/credit item the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by document number, return type and supplier account number |
Report values | For each document item the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by disputed ID, document number, invoice/credit number and supplier account number |
Report values | For each invoice/credit item the report shows - - 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 View report |
Sage 200 Version | 2011 and above |
Location | Purchase Order Processing > Status |
Groups / sorts | The report is grouped by item code and order return numbers |
Report values | For each item the report shows - - 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