Sage 200 Report Designer - Standard Reports within Sage 200
Description
Cause
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
Time Taken To Pay Sales Invoices
Report name Time Taken To Pay Sales Invoices   View report
Sage 200 Version 2011 and above
Location Sales Ledger > Credit Control
Groups / sorts The report is grouped by customer account number
Report values For each customer the report shows -
  • Account number
  • Account name
  • Transaction reference
  • Transaction date
  • Gross (in base currency)
  • Date paid
  • Days to pay
Filter There is a report filter to only include transactions that have been paid

Purchase Ledger

Day Book
Report name Purchase Ledger Day Book Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is sorted by posted date, account number and unique reference
Report values For each transaction the report shows -
  • Posted date
  • Account number
  • Transaction date
  • Transaction type
  • 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 Purchase Ledger List of Accounts   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number
Report values For each supplier the report shows -
  • Account reference
  • Short name
  • Currency
  • Country
  • Balance
  • Date last amended
  • Date last transaction
  • On hold status
  • Payment group
  • Analysis 1, 2 and 3
Filter There is no filter on the report
Purchase Ledger Account Details Report
Report name Purchase Ledger Account Details Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number
Report values For each supplier the report shows -
  • Supplier account number, name and address
  • Contact name
  • Contact telephone number
  • VAT details
  • Currency
  • Default nominal code
  • Cost centre
  • Department
  • Payment group
  • Trading terms
  • Credit details
  • Current balance
  • Credit limit
  • Turnover month to date
  • Discount %
  • Discount days
  • Last transaction date
  • Date account last amended
  • Order priority
  • Account opened
  • Last credit review
  • Next credit review
  • Application date
  • Date received
Filter There is no filter on the report
Transaction Listing (Current)
Report name Purchase Ledger Transactions Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number and sorted by transaction date and unique reference number
Report values For each supplier the report shows -
  • Supplier account number and name
  • Unique reference number
  • Transaction type
  • Reference
  • Transaction date
  • Due date
  • Query code
  • Net , VAT and discount values
  • Allocated amount
  • Outstanding amount
  • Outstanding amount (in base currency)
Filter There is no filter on the report
Transaction Listing (By Period)
Report name Purchase Ledger Transactions Report (by Period)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by accounting period ID and sorted by transaction date and account number
Report values For each accounting period the report shows -
  • Period number
  • Start and end date of period
  • Period unique reference number
  • Account number
  • Transaction type
  • Reference
  • Transaction date
  • Query code
  • Net, VAT and Discount amount
  • Allocated amount
  • Outstanding amount
  • Outstanding amount (in base currency)
Filter There is no filter on the report
Transaction Listing (Historical)
Report name Purchase Ledger Transactions Report (Historical)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number and sorted by unique reference number
Report values For each supplier the report shows -
  • Account number and name
  • Unique reference number
  • Transaction type
  • Reference
  • Transaction date
  • Due date
  • Net, VAT and discount amounts
Filter There is no filter on the report
Unauthorised Transactions
Report name Purchase Ledger Unauthorised Transactions Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number and sorted by unique reference number
Report values For each supplier the report shows -
  • Account number and name
  • Unique reference number
  • Transaction type
  • Reference
  • Transaction date
  • Due date
  • Net, VAT and discount value
  • Outstanding amount
  • Outstanding amount (in base currency)
Filter The report is filtered to show unauthorised transactions only
Vatable Transactions
Report name Purchase Ledger VAT Transactions Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number and sorted by transaction date
Report values For each supplier the report shows -
  • Account number and name
  • Transaction type
  • Reference
  • Transaction date
  • Net in base and foreign amount
  • VAT in base and foreign amount
  • Total In base and foreign amount
Filter The report is filtered to include invoice or credit notes
Trading Report (Detailed)
Report name Purchase Ledger Trading Report (Detailed)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number
Report values For each supplier the report shows -
  • Account number
  • This year to date
  • Last year to date
  • Base amount spent this period
  • Base amount spent for the last 6 periods (1 column per period)
Filter There is no filter on the report
Trading Report (Summary)
Report name Purchase Ledger Trading Report (Summary)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Account Analysis
Groups / sorts The report is grouped by supplier account number
Report values For each supplier the report shows -
  • Account number
  • Account name
  • Turnover MTD
  • Turnover YTD
  • Turnover last year
  • Current balance
  • Last transaction date
Filter There is no filter on the report  
Aged Creditors (Detailed)
Report name Purchase Ledger Aged Creditors Report (Detailed)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number and sorted by transaction date
Report values For each supplier the report shows -
  • Account number and name
  • Transaction type
  • If transaction is in query
  • Transaction reference
  • Transaction date
  • Due Date
  • Ageing periods 1 to 4 (1 column per period)
  • Current
  • Total (in base currency)
  • Total (in foreign currency)
Filter There is no filter on the report  
Aged Creditors (Summary)
Report name Purchase Ledger Aged Creditors Report (Summary)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number and sorted by transaction date
Report values For each supplier the report shows -
  • Account number and name
  • Date of last transaction
  • Ageing periods 1 to 4 (1 column per period)
  • Current
  • Total
Filter There is no filter on the report
Due Date (Detailed)
Report name Purchase Ledger Due Date Report (Detailed)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number and sorted by due date
Report values For each supplier the report shows -
  • Account number and name
  • Contact name
  • Terms of business
  • Contact telephone number
  • Transaction type
  • Reference
  • Their ref (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 Purchase Ledger Due Date Report (Summary)   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number
Report values For each supplier the report shows -
  • Account number and name
  • Terms of business
  • Contact name
  • Phone number
  • Ageing period 1 to 4 (1 column per period)
  • Current
  • Total
  • Future
Filter There is no filter on the report
Valid Discounts
Report name Purchase Ledger Valid Supplier Discounts Report   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number, unique reference and sorted by transaction date
Report values For each supplier the report shows -
  • Account number and name
  • Transaction date
  • Reference
  • Gross value
  • Discount value
  • Net value
  • Outstanding value
  • Valid until
  • If transaction is in query (Y/N)
Filter The report is filtered to only show if there is a valid discount amount
Time Taken to Pay Purchase Invoice
Report name Time Taken to Pay Purchase Invoice   View report
Sage 200 Version 2011 and above
Location Purchase Ledger > Payments Control
Groups / sorts The report is grouped by supplier account number and sorted by transaction date
Report values For each supplier the report shows -
  • Account number and name
  • Reference
  • Transaction date
  • Gross value
  • Pay date
  • Days to pay
Filter The report is filtered to only show if there is a agreed settlement date

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 -
  • Warehouse name
  • Bin name
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 Pro Forma Profitability (Detailed)
Report name SOP Pro Forma Profitability (Detailed)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account ID
Report values For each item document number the report shows -
  • Document number
  • Currency symbol
  • Pro forma status
  • Item code
  • Item description
  • Quanitity
  • Unit description
  • Sales value
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Pro formas
SOP Pro Forma Profitability (Summary)
Report name SOP Pro Forma Profitability (Summary)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account number
Report values For each document number the report shows -
  • Customer account number and name
  • Currency symbol
  • Document number
  • Return name
  • Sales value
  • Pro forma status
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Pro formas
SOP Quotation Profitability (Detailed)
Report name SOP Quotation Profitability (Detailed)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account ID
Report values For each item document number the report shows -
  • Document number
  • Currency symbol
  • Quotation status
  • Item code
  • Item description
  • Quanitity
  • Unit description
  • Sales value
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Quotation
SOP Quotation Profitability (Summary)
Report name SOP Quotation Profitability (Summary)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account number
Report values For each document number the report shows -
  • Customer account number and name
  • Currency symbol
  • Document number
  • Return name
  • Sales value
  • Quotation status
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Quotations
Invoice Profitability (Detailed)
Report name Invoice Profitability (Detailed)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account ID
Report values For each item document number the report shows -
  • Document number
  • Currency symbol
  • Item code
  • Item description
  • Quanitity
  • Unit description
  • Sales value
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Invoices
Invoice Profitability (Summary)
Report name Invoice Profitability (Summary)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Profitability
Groups / sorts The report is grouped by document number and customer account number
Report values For each document number the report shows -
  • Customer account number and name
  • Currency symbol
  • Document number
  • Return name
  • Sales value
  • Estimated profit
  • Estimated profit %
Filter The report is filtered to only show Invoices
Allocations with Batch/Serial Items
Report name Batch Serial SOP Allocations
Sage 200 Version 2011 and above
Location Sales Order Processing > Batch/Serial Items
Groups / sorts The report is grouped by recipient reference,area type name,product group, bin name and warehouse name
Report values For each stock code the report shows -
  • Item code
  • Item name
  • Stock unit name
  • Batch/Serial number
  • Allocation Recipient reference
  • Bin name
  • Allocation date
  • Reference
  • quantity allocated
  • Batch serial type
Filter The report is filtered to only traceable items
Despatches and Reciepts with Batch/Serial Items
Report name SOP Despatches and Receipts with Batch/Serial Numbers
Sage 200 Version 2011 and above
Location Sales Order Processing > Batch/Serial Items
Groups / sorts The report is grouped by document number, despatch reciept type ID and account number
Report values For each document the report shows -
  • document number
  • Date
  • Batch/serial number
  • Order number
  • Print sequence
  • Invoice number
  • Item description
  • Quantity
  • Batch/Serial type
Filter The report is filtered to only show traceable items
Invoices for Batch/Serial items
Report name Invoices for Batch/Serial items   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by document number and customer account number
Report values For each document number the report shows -
  • document number
  • Status
  • Net, VAT and gross amount
  • Date
  • Discount valid until date
  • Identification number
  • Quantity
Filter The report is filtered to only show traceable items
Sales Order and Returns (Archived)
Report name Sales Order and Returns (Archived)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by document number and customer account number
Report values For each document the report shows -
  • document number
  • Date
  • Net, VAT and gross amount
  • Promised delivery date
  • Print sequence
  • Item code
  • Despatch quantity
  • Line total
Filter The report is not filtered
Sales Order and Returns (Archived) Summary
Report name Sales Order and Returns (Archived) Summary   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by return ID and customer account number
Report values For each customer the report shows -
  • Customer account number and name
  • Currency
  • Document number
  • Document date
  • Promised for delivery date
  • Net, VAT and gross totals
Filter The report is not filtered
Invoices and Credit Notes (Archived)
Report name Sales Invoices and Credit Notes (Archived)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by document number and customer account number
Report values For each customer the report shows -
  • Customer account number and name
  • Currency
  • Invoice/Credit note number
  • Document date
  • Settlement discount days
  • Net, VAT and gross totals
  • Return type name
  • Item code
  • Item name
  • Quantity
  • Line total
Filter The report is not filtered
Invoices and Credit Notes (Archived) Summary
Report name Sales Invoices and Credit Notes (Archived)   View report
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by document number, invoice/credit ID and customer account number
Report values For each document the report shows -
  • Customer account number and name
  • Currency
  • Invoice/Credit note number
  • Document date
  • Settlement discount days
  • Net, VAT and gross totals
Filter The report is not filtered
Canceled Lines (Archived)
Report name Canceled Lines (Archived)
Sage 200 Version 2011 and above
Location Sales Order Processing > Archived
Groups / sorts The report is grouped by cancelled lines item code and customer account number
Report values For each line the report shows -
  • Customer account number and name
  • Cancelled line item code
  • Date
  • Quantity
  • Selling unit description
  • Stock cancelled quantity
  • Order number
  • User name
Filter The report is not filtered
Additional Charges
  
Report name SOP Additional Charges
Sage 200 Version 2011 and above
Location Sales Order Processing > Maintenance
Groups / sorts The report is sorted by the additional charges code
Report values For each additional charge the report shows -
  • Additional charge code
  • Charge name
  • VAT rate and code
  • Nominal account name and number
  • Cost centre
  • Department
  • Charge value
Filter The report is not filtered
Repeat Order Templates
  
Report name Repeat Sales Order Templates
Sage 200 Version 2011 and above
Location Sales Order Processing > Maintenance
Groups / sorts The report is grouped by customer account number and sorted by repeat order type
Report values For each customer the report shows -
  • Customer account name and number
  • Return type name
  • Repeat order description
  • Schedule type
  • Frequency
  • On which day of the month
  • Start date
  • End date
  • Total number of times to repeat
  • Current Count
  • Last generated date
Filter The report is not filtered
Sales Order Items
  
Report name Sales Order Items
Sage 200 Version 2011 and above
Location Sales Order Processing > Maintenance
Groups / sorts The report is grouped by product group code and sorted by stock item code
Report values For each stock item code the report shows -
  • Stock item code
  • Stock item name
  • Stock item description
  • Price
  • VAT code and name
Filter The report is filtered to only show if the item is part of the product group code
SOP Customer Delivery Addresses
  
Report name SOP Customer Delivery Addresses
Sage 200 Version 2011 and above
Location Sales Order Processing > Maintenance
Groups / sorts The report is grouped by delivery address ID and customer account number
Report values For each delivery address the report shows -
  • Customer account number and name
  • Delivery address description
  • Customer name and address
  • Telephone number
  • Fax number
  • Email
  • Contact name
Filter The report is not filtered

Purchase Order Processing

Orders Status
Report name Purchase Orders Status
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Orders
Groups / sorts The report is grouped by document number
Report values For each document number the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Order date
  • Requested
  • Invoiced
  • Total Net amount
Filter The report is filtered not to include https://internal-kb.sage.com/solutionmanager items
Not Fully Received
Report name Purchase Orders Not Fully Received
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Orders
Groups / sorts The report is grouped by document number
Report values For each document number the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Order date
  • Requested
  • Total net value
  • Received flag
Filter The report is filtered to include not fully received items
Fully Received Not Fully Invoiced
Report name Purchase Orders Fully Received Not Fully Invoiced
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Orders
Groups / sorts The report is grouped by document number
Report values For each document number the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Order date
  • Requested
  • Net amount
  • Invoiced flag
Filter The report is filtered to include items fully received that have either not been invoiced or have been part invoiced.
Purchase Orders Not Printed
Report name Purchase Orders Not Printed
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Orders
Groups / sorts The report is sorted by document number
Report values For each document number the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Amended since last printed flag
  • Order date
  • Requested
  • Authorisation
Filter The report is filtered on print ID to only show if the order has not been printed
Items Requiring Ordering
Report name POP Items Requiring Ordering
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Order lines
Groups / sorts The report is grouped by warehouse name and sorted by re-order item code
Report values For each item the report shows -
  • Item code
  • Item name
  • Quantity required
  • Quantity to purchase
  • Stock unit
  • To negotiate flag
  • Confirmed flag
Filter The report is not filtered
Back to Back Orders Required
Report name POP Back to Back Orders Required
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Order lines
Groups / sorts The report is grouped by customer name re-order item code and warehouse description
Report values For each item the report shows -
  • Item code
  • Item name
  • Unit
  • Customer account number and name
  • Promised delivery date
  • Sales order number
  • Quantity required
Filter The report is not filtered
Order Receipts Pending
Report name Purchaser Order Receipts Pending
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Order lines
Groups / sorts The report is grouped by print sequence number and document number
Report values For each document the report shows -
  • Document number
  • Status
  • Date
  • Requested delivery date
  • Supplier account number and name
  • Print sequence number
  • Item code
  • Item description
  • Total quantity
  • Quantity outstanding
  • Unit description
Filter The report is filtered to include items if there is a quantity outstandiing
Order Invoices Pending
Report name Purchaser Order Invoices Pending
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Order lines
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Status
  • Date
  • Supplier account number and name
  • Item code
  • Item description
  • Quantity to be invoiced
  • Unit description
  • Quantity to be received
Filter The report is filtered to include items if there is a quantity to be invoiced
Returns Status
Report name Purchase Return Status
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Returns
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Date
  • Requested delivery date
  • Received flag
  • Credited flag
Filter The report is filtered not to include https://internal-kb.sage.com/solutionmanager items
Not Fully Despatched
Report name Purchase Return Not Fully Despatched
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Returns
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Return date
  • Requested delivery date
  • Net amount
  • Despatched flag
Filter The report is filtered to show items if there is a return required
Fully Despatched Not Fully Credited
Report name Purchase Returns Fully Despatched Not Fully Credited
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Returns
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Return date
  • Requested delivery date
  • Total net value
  • Credited flag
Filter The report is filtered to include items that are fully returned but not fully credited
Returns Not Despatched
Report name Purchase Return Not Despatched
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Return lines
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Status
  • Date
  • Authorisation
  • Supplier account number and name
  • Print sequence
  • Item code
  • Item description
  • Total quantity
  • Outstanding quantity
  • Unit description
Filter The report is filtered to include items where there is an oustanding quantity to return
Returns Credit Note Pending
Report name Purchase Return Credit Note Pending
Sage 200 Version 2011 and above
Location Purchase Order Processing > Processing > Return lines
Groups / sorts The report is grouped by document number
Report values For each document the report shows -
  • Document number
  • Status
  • Date
  • Authorisation
  • Supplier account number and name
  • Print sequence
  • Item code
  • Item description
  • Quantity to be credited
  • Unit description
  • To be despatched
Filter The report is filtered to include items where the return quantity is greater than the quantity invoiced
Orders and Returns (Detailed)
Report name Purchase Orders and Returns (Detailed)
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by document number, document status ID and supplier account number
Report values For each document line the report shows -
  • Document number
  • Status
  • Date
  • Net, tax and gross
  • Requested delivery
  • Print sequence
  • Item code
  • Item description
  • Quantity on order
  • Line quantity
  • Receipt quantity
  • Line total
Filter The report is not filtered
Orders and Returns (Summary)
Report name Purchase Orders and Returns Summary
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by document number and supplier account number
Report values For each document the report shows -
  • Document number
  • Supplier account number and name
  • Status
  • Document date
  • Requested delivery date
  • Credited flags
Filter The report is filtered not to include https://internal-kb.sage.com/solutionmanager items
Invoices and Credit Notes
Report name Purchase Invoice and Credit Notes
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by invoice/credit number, invoice/credit type and supplier account number
Report values For each invoice/credit item the report shows -
  • Invoice/Credit number
  • Invoice/Credit date
  • Item code
  • Disputed flag
  • Invoice/Credit quantity
  • Unit description
  • Line tax value
  • Line total value
  • Username
Filter The report is not filtered
Receipts and Despatches
Report name Purchase Receipts and Despatches
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by document number, return type and supplier account number
Report values For each document item the report shows -
  • Document number
  • Document date
  • Order/Return number
  • Print sequence number
  • Item description
  • Return quantity
  • Unit description
  • Warehouse name
  • Bin name
  • Username
Filter The report is not filtered
Disputed Invoices and Credits
Report name Disputed Invoices and Credits
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by disputed ID, document number, invoice/credit number and supplier account number
Report values For each invoice/credit item the report shows -
  • Invoice/Credit number
  • Dispute number
  • Dispute code and description
  • Invoice/Credit date
  • Item code
  • Invoice/Credit quantity
  • Unit description
  • Lis tax amount
  • Line total value
  • Username
Filter The report is not filtered
Cancelled Order Lines
Report name Purchase Order Cancelled Lines
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by item code and supplier account number
Report values For each cancelled item the report shows -
  • Item code
  • Cancelled date
  • Cancelled quantity
  • Buying unit description
  • Stock quantity
  • Order/Return number
  • Username
Filter The report is not filtered
Deliveries
Report name Purchase Order Deliveries
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by item code and order return numbers
Report values For each item the report shows -
  • Item code
  • GRN number
  • Supplier GRN number
  • Delivery date
  • Received by
  • Quantity delivered
  • Invoiced flag
Filter The report is filtered to include only deliveries
POP Items for Negotiation
Report name POP Items for Negotiation
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by item code
Report values For each item the report shows -
  • Item code
  • Warehouse name
  • Status
  • Quantity received
  • Quantity confirmed
  • Total cost
  • Supplier account number and name
Filter The report is not filtered
Receipts and Dispatches with Batch/Serial Items
Report name POP Receipts and Dispatches with Batch/Serial Items
Sage 200 Version 2011 and above
Location Purchase Order Processing > Batch/Serial Items
Groups / sorts The report is grouped by document number and by return type ID
Report values For each item the report shows -
  • Document number
  • Document date
  • Batch/Serial number
  • Order/Return number
  • Print sequence number
  • Item code
  • Quantity
  • Warehouse name
  • Bin name
  • Batch/Serial type
Filter The report is filtered not to include untraceable items
Purchase Orders and Returns (Archived)
Report name Purchase Orders and Returns (Archived)
Sage 200 Version 2011 and above
Location Purchase Order Processing > Archived
Groups / sorts The report is grouped by document number, document status ID, document type ID and supplier account number
Report values For each item the report shows -
  • Document number
  • Document date
  • Net, VAT and gross totals
  • Requested delivery date
  • Item code
  • Item description
  • Line quantity
  • Receipt return quantity
  • Line total
Filter The report is not filtered
Purchase Orders and Returns (Archived) Summary
Report name Purchase Orders and Returns (Archived) Summary
Sage 200 Version 2011 and above
Location Purchase Order Processing > Archived
Groups / sorts The report is grouped by order return ID, document status ID, document type ID and by supplier account number
Report values For each document the report shows -
  • Supplier account number and name
  • Currency symbol
  • Document name
  • Document number
  • Document date
  • Requested delivery date
  • Net, VAT and gross amounts
Filter The report is not filtered
Invoices and Credit Notes (Archived)
Report name Purchase Invoice and Credit Notes (Archived)
Sage 200 Version 2011 and above
Location Purchase Order Processing > Archived
Groups / sorts The report is grouped by invoice/credit number, invoice credit type and supplier account number
Report values For each invoice/credit the report shows -
  • Invoice/Credit number
  • Invoice/Credit date
  • Item code
  • Invoice/Credit quantity
  • Unit description
  • Line tax value
  • Total line value
  • Username
  • Return type name
Filter The report is not filtered
Cancelled Order Lines
Report name Purchase Order Cancelled Lines
Sage 200 Version 2011 and above
Location Purchase Order Processing > Status
Groups / sorts The report is grouped by item code and supplier account number
Report values For each cancelled item the report shows -
  • Item code
  • Cancelled date
  • Cancelled quantity
  • Buying unit description
  • Stock quantity
  • Order/Return number
  • Username
Filter The report is not filtered
Additional Charges
Report name POP Additional Charges
Sage 200 Version 2011 and above
Location Purchase Order Processing > Maitenance
Groups / sorts The report is sorted by additional charge code
Report values For each additional item the report shows -
  • Additional charge code
  • Additional charge name
  • VAT code and name
  • Nominal account name
  • Nominal account number
  • Cost centre
  • Department
  • Charge value
Filter The report is not filtered

Bill of Materials

Sales Order with item To Be Made From BOM
Report name BOM SOP Items to be Made
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by SOP order returns document number, SOP order returns priority, SOP order returns status, SOP order return type and customer account number
Report values For each customer account the report shows -
  • Customer account number and name
  • Currency
  • Document number
  • Status
  • Document date
  • Priority
  • Net, VAT and gross amounts
  • Print sequence
  • Item code and description
  • Allocated quantity
  • Despatch quantity
  • Line total
Filter The report is filtered to include items from sales orders that are part of BOM and still need to be completed
Costing History
Report name BOM Costing History
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is sorted by BOM reference and the date and time of costing
Report values For each BOM costing the report shows -
  • BOM reference
  • BOM Sage 200 Version
  • BOM costed date/time
  • Quantity costed
  • Total overheads
  • Total cost
  • Total cost including overheads
  • Unit cost
  • Unit cost including overheads
Filter There is no filter on the report
Costing History (With Breakdown)
Report name BOM Costing History (With Breakdown)
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by BOM cost session ID, date/time costed and reference
Report values For each BOM session ID the report shows -
  • BOM reference
  • BOM Sage 200 Version
  • BOM costed date/time
  • Quantity costed
  • Total overheads
  • Total cost
  • Total cost including overheads
  • Unit cost
  • Unit cost including overheads
Filter There is no filter on the report
Traceable Built Items
Report name BOM Traceable Built Items Report
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by traceable product ID number
Report values For each traceable ID the report shows -
  • Built item stock code
  • Finished item name
  • Identification number
  • Build date
  • Component code and name
  • Build number and name
  • Identification number
  • Component quantity
Filter There is no filter on the report
Traceable Components
Report name BOM Traceable Components Report
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by traceable components ID number
Report values For each traceable ID the report shows -
  • Compoenent stock code and name
  • Identification number
  • Finished item code and name
  • Build number, date and name
  • Identification number
  • Component quantity
Filter There is no filter on the report
Where Used - Component
Report name Where Used - Compoenent
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by stock item, product group and sorted by BOM record and Sage 200 Version
Report values For each product group the report shows -
  • Product group code and description
  • Component code and description
  • BOM reference
  • BOM Sage 200 Version
  • BOM description
  • Sequence number
  • Quantity
  • Unit of measure
Filter There is no filter on the report
Where Used - Drawing
Report name Where Used - Drawing
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by drawing reference and sorted by BOM record and Sage 200 Version
Report values For each drawing reference the report shows -
  • Drawing reference and description
  • Effective from date
  • Effective to date
  • BOM reference
  • BOM Sage 200 Version
  • BOM description
Filter There is no filter on the report
Where Used - Operation
Report name Where Used - Operation
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by operations reference and sorted by BOM record, Sage 200 Version and sequence number
Report values For each operations reference the report shows -
  • Operations reference and description
  • BOM reference
  • BOM Sage 200 Version
  • BOM description
  • Sequence number
  • Default run time in hours minutes and seconds
Filter There is no filter on the report
Where Used - Labour Resource
Report name Where Used - Labour Resource
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by labour resource reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each labour resource the report shows -
  • Labour resource reference and description
  • BOM reference and description
  • BOM Sage 200 Version
  • Sequence number
  • Operation reference and description
  • Default run time in hours minutes and seconds
Filter The report is filtered to show labour resource types only
Where Used - Labour Resource Group
Report name Where Used - Labour Resource Group
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by labour resource group reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each labour resource group the report shows -
  • Labour resource group reference and description
  • BOM reference and description
  • BOM Sage 200 Version
  • Sequence number
  • Operation reference and description
  • Default run time in hours minutes and seconds
Filter The report is filtered to show labour resource group types only
Where Used - Machine Resource
Report name Where Used - Machine Resource
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by machine resource reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each machine resource the report shows -
  • Machine resource reference and description
  • BOM reference and description
  • BOM Sage 200 Version
  • Sequence number
  • Operation reference and description
  • Default run time in hours minutes and seconds
Filter The report is filtered to show machine resource types only
Where Used - Machine Resource Group
Report name Where Used - Machine Resource Group
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by machine resource group reference and sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each machine resource group the report shows -
  • Machine resource group reference and description
  • BOM reference and description
  • BOM Sage 200 Version
  • Sequence number
  • Operation reference and description
  • Default run time in hours minutes and seconds
Filter The report is filtered to show machine resource group types only
Where Used - Tool Resource
Report name Where Used - Tool Resource
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by tooling resource reference and is sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each tooling resource the report shows -
  • Tooling 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 tooling resource types only
Where Used - Tool Resource Group
Report name Where Used - Tool Resource Group
Sage 200 Version 2011 and above
Location Bill of Materials > Reports
Groups / sorts The report is grouped by tooling resource group reference and is sorted by BOM record, BOM Sage 200 Version, BOM operations sequence number and BOM operations reference
Report values For each tooling resource group the report shows -
  • Tooling 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 tooling 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

Project Accounting

Cost Analysis (By Group)
Report name Cost Analysis (By Group)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is grouped by project entry key 1 to 5 and sorted by project ID
Report values For each key area the report shows -
  • Key description
  • Actual cost
  • Committed cost
  • Total cost
Filter The report is filtered to not include archived projects that are not part of a template
Cost Analysis (by Structure)
Report name Cost Analysis (by Structure)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by Project ID
Report values For each project ID the report shows -
  • Actual cost
  • Committed cost
  • Total cost
  • Total cost budget
  • Variance from total budget
  • Variance % from total budget
Filter The report is filtered to not include archived projects that are not part of a template
Profitability Breakdown (by Group)
Report name Profitability Breakdown (by Group)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is grouped by project entry key 1 to 5 and sorted by project ID
Report values For each project ID the report shows -
  • Revenue
  • Prime cost
  • Gross profit
  • Gross profit %
  • Overhead
  • Net profit
  • Net profit %
Filter The report is filtered to not include archived projects that are not part of a template
Profitability Breakdown (by Structure)
Report name Profitability Breakdown (by Structure)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by project ID
Report values For each project ID the report shows -
  • Revenue
  • Prime cost
  • Gross profit
  • Gross profit %
  • Overhead
  • Net profit
  • Net profit %
Filter The report is filtered to not include archived projects that are not part of a template
Revenue Analysis (by Group)
Report name Revenue Analysis (by Group)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is grouped by project entry key 1 to 5 and sorted by project ID
Report values For each project ID the report shows -
  • Key description
  • Actual revenue
  • Potential revenue
  • Total revenue
Filter The report is filtered to not include archived projects that are not part of a template
Revenue Analysis (by Structure)
Report name Revenue Analysis (by Structure)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by project ID
Report values For each project ID the report shows -
  • Actual revenue
  • Potential revenue
  • Total revenue
  • Total revenue budget
  • Variance from total budget
  • Variance % from total budget
Filter The report is filtered to not include archived projects that are not part of a template
Cancelled Invoices
Report name Cancelled Invoices
Sage 200 Version 2011 and above
Location Project Accounting > Billing
Groups / sorts There are no groups or sorts on the report
Report values For each cancelled invoice the report shows -
  • Document number
  • Date
  • Type
  • Customer
  • Cancelled date
  • Cancelled by
  • Reason cancelled
  • Value
Filter The report is filtered to include cancelled invoice only
Cost Transactions
Report name Cost Transactions
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each cost transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Project unique reference number
Filter The report is filtered not to include archived projects and zero values or zero quantities
Nominal Transactions
Report name Nominal Transactions
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each nominal transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Project unique reference number
Filter The report is filtered not to include archived projects and zero values or zero quantities
Revenue Transactions
Report name Revenue Transactions
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each revenue transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Project unique reference number
Filter The report is filtered not to include archived projects and zero values or zero quantities
Timesheet Summary (by Resource)
Report name Timesheet Summary (by Resource)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by resource ID and project item
Report values For each resource item the report shows -
  • Project code
  • Project title
  • Hours
  • Total cost
  • Total revenue
Filter The report is filtered not to include archived projects
Timesheet Summary (by Resource)
Report name Timesheet Summary (by Resource)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by resource ID, last name and project item
Report values For each resource ID item the report shows -
  • Employee
  • Hours
  • Total cost
  • Total revenue
Filter The report is filtered not to include archived projects
Timesheet Transaction (by Resource)
Report name Timesheet Transaction (by Resource)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by resource ID and project item
Report values For each project item ID the report shows -
  • item code
  • Date
  • Hours
  • Status
  • Record number
  • Cost rate type
  • Cost rate value
  • Total cost
  • Charge rate type
  • Charge rate value
  • Total revenue
Filter The report is filtered not to include archived projects
Timesheet Transaction (by Project)
Report name Timesheet Transaction (by Project)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by record ID and project item ID
Report values For each project item ID item the report shows -
  • Works number
  • Name
  • Date
  • Hours
  • Status
  • Tran number
  • Cost rate
  • Cost rate value
  • Total cost
  • Charge rate type
  • Charge rate value
  • Total revenue
Filter The report is filtered not to include archived projects
Timesheet Transaction (Charges and Costs)
Report name Timesheet Transaction (Charges and Costs)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by human resource ID and project item ID
Report values For each project item ID item the report shows -
  • Item code
  • Date
  • Status
  • Hours
  • Cost rate
  • Cost value
  • Total cost
  • Charge rate type
  • Charge rate value
  • Total charge
Filter The report is filtered not to include archived projects
Expense Transaction (by Resource)
Report name Expense Transaction (by Resource)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by human resource ID and claim number
Report values For each claim number the report shows -
  • Date
  • Project code
  • Category
  • Item
  • Details
  • Net (in base currency)
  • VAT (in base currency)
  • Gross (in base currency)
  • Gross (in foreign currency)
Filter The report is filtered not to include archived projects and where a quantity is greater than zero
Payroll Report (by Resource)
Report name Payroll Report (by Resource)
Sage 200 Version 2011 and above
Location Project Accounting > Timesheets & Expense Claims
Groups / sorts The report is grouped by human resource ID, last name, payment frequency and company name
Report values For each resource ID the report shows -
  • Works number
  • Name
  • Hours
  • Total pay
Filter The report is filtered not to include archived projects or by resource ID
Project List
Report name Project List
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by customer ID, account ID and project item ID
Report values For each customer ID the report shows -
  • Project code
  • Project title
  • Status
  • % complete
  • Customer account number
  • Order number
  • Quantity
  • Unit price
  • Price quoted
Filter The report is filtered on project item type and not to include archived projects
Project List (by Customer)
Report name Project List (by Customer)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by customer ID and project item ID
Report values For each project ID the report shows -
  • Project code
  • Project title
  • Status
  • % complete
  • Quantity
  • Unit price
  • Price quoted
Filter The report is filtered on project item type and to not include archived projects
Project List (by Status)
Report name Project List (by Status)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by customer ID, project item ID and project status
Report values For each customer ID the report shows -
  • Project code
  • Project title
  • Status
  • % complete
  • Customer account number
  • Order number
  • Quantity
  • Unit price
  • Price quoted
Filter The report is filtered on project item type and to not include archived projects
Project Item List (Setup)
Report name Project List (Setup)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by cost item type ID
Report values For each cost item the report shows -
  • Project code
  • Project title
  • Unit cost
  • Timesheet pricing rule
  • Stock issue pricing rule
  • Other costs pricing rule
  • Is overhead
Filter The report is not filtered
Project Item List (by Project)
Report name Project Item List (by Project)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by project item ID
Report values For each project item code the report shows -
  • Project item code
  • Project item title
  • Cost item type
  • Last cost date
Filter The report is not filtered
Project Item List (Integration)
Report name Project List (Integration)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by cost item type ID
Report values For each cost item the report shows -
  • Project code
  • Project title
  • Expense nominal account
  • Revenue nominal account
  • Uplift rate value
  • Uplift rate %
Filter The report is not filtered
Project Item Type List
Report name Project Item Type List
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is not grouped or sorted
Report values For each cost item the report shows -
  • Cost item type title
  • Unit of measure name
  • Status
  • Expense nominal account
  • Revenue nominal account
  • Timesheet pricing rule
  • Stock issue pricing rule
  • Other costs pricing rule
  • Is overhead
Filter The report is not filtered
Additional Information List
Report name Additional Information List
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by analysis field name
Report values For each additional field the report shows -
  • Value
  • Persons last name
  • Persons middle name
  • Persons first name
Filter The report is filtered to only show if the additional fields are used
Cost Analysis (by Structure) (Archived)
Report name Cost Analysis (by Structure) (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by Project ID
Report values For each project ID the report shows -
  • Actual cost
  • Committed cost
  • Total cost
  • Total cost budget
  • Variance from total budget
  • Variance % from total budget
Filter The report is filtered not to include archived projects and those that are not part of a template
Profitability Breakdown (by Structure) (Archived)
Report name Profitability Breakdown (by Structure) (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by project ID
Report values For each project id the report shows -
  • Revenue
  • Prime cost
  • Gross profit
  • Gross profit %
  • Overhead
  • Net profit
  • Net profit %
Filter The report is filtered not to include archived projects and those that are not part of a template
Revenue Analysis (by Structure) (Archived)
Report name Revenue Analysis (by Structure) (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Analysis
Groups / sorts The report is sorted by project ID
Report values For each project ID the report shows -
  • Actual Revenue
  • Potential Revenue
  • Total Revenue
  • Total revenue budget
  • Varaince from total budget
  • Variance % from total budget
Filter The report is filtered not to include archived projects or those that are not part of a template
Cost Transactions (Archived)
Report name Cost Transactions (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each cost transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity/li>
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Project unique reference number
Filter The report is filtered not to include show archived projects and zero values or zero quantities
Nominal Transactions (Archived)
Report name Nominal Transaction (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each nominal transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Proect unique reference number
Filter The report is filtered not to include archived projects and zero values or zero quantities
Revenue Transactions (Archived)
Report name Revenue Transactions (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Transactions
Groups / sorts The report is grouped by project entry key 1 to 5 and is sorted by unique reference number and date
Report values For each revenue transaction the report shows -
  • Date
  • Type
  • Reference
  • Account number
  • Parent project code
  • Project item code
  • Details
  • Quantity
  • Cost rate
  • Total cost
  • Charge rate
  • Value to bill
  • Project unique reference number
Filter The report is filtered not to include archived projects and zero values or zero quantities
Project List (Archived)
Report name Project List (Archived)
Sage 200 Version 2011 and above
Location Project Accounting > Setup
Groups / sorts The report is grouped by customer ID, Account ID and project item ID
Report values For each customer ID the report shows -
  • Project code
  • Project title
  • Status
  • % complete
  • Customer account number
  • Order number
  • Quantity
  • Unit price
  • Price quoted
Filter The report is filtered not to include archived projects and zero values or zero quantities

Sage Business Partners can now log new cases online!

If you're unable to find the help you require from our online resources, log a new case with us without having to use phone or email. Simply select 'Manage your cases' from the dashboard or visit my.sage.co.uk/cases

[BCB:191:UKI - #GetMoreFeedback:ECB]
Steps to duplicate
Related Solutions