Sage 200 Report Designer - Standard Reports within Sage 200

• Posted date
• Account number
• Transaction date
• Unique reference number
• Transaction reference
• Net, VAT and gross amounts
• Original exchange rate

• Account number
• Short name
• Currency
• Country
• Balance
• Date last amended
• Date of last transaction
• On hold status
• Finance rate
• Analysis 1,2 and 3

• 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

• 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)

• 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)

• Unique reference number
• Transaction type
• Reference
• Transaction date
• Net value
• VAT value
• Discount value

• Transaction type
• Reference
• Transaction date
• Net, VAT, gross value (in base currency)
• Net, VAT, gross value (in foreign 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.

• Account number
• Name
• Turnover MTD
• Turnover YTD
• Turnover last year
• Current balance
• Date of last transaction

• Account number
• Name
• VAT registration number
• Transaction unique reference number
• Transaction type
• Tax point date
• Goods value
• Notional tax value

• Account number
• Name
• VAT registration number
• Goods value
• Notional tax value

• 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

• Account number
• Account name
• Amounts for 5 periods (1 column per period)
• Total amount outstanding (in base currency)
• Account contact name
• Account telephone number

• 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

• 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

• 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

• Account number
• Account name
• Transaction reference
• Transaction date
• Gross (in base currency)
• Date paid
• Days to pay

• Posted date
• Account number
• Transaction date
• Transaction type
• Unique reference number
• Transaction reference
• Net, VAT and gross amounts
• Original exchange rate

• Account reference
• Short name
• Currency
• Country
• Balance
• Date last amended
• Date last transaction
• On hold status
• Payment group
• Analysis 1, 2 and 3

• 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

• 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)

• 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)

• Account number and name
• Unique reference number
• Transaction type
• Reference
• Transaction date
• Due date
• Net, VAT and discount amounts

• 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)

• 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

• 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)

• Account number
• Account name
• Turnover MTD
• Turnover YTD
• Turnover last year
• Current balance
• Last transaction date

• 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)

• Account number and name
• Date of last transaction
• Ageing periods 1 to 4 (1 column per period)
• Current
• Total

• 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

• Account number and name
• Terms of business
• Contact name
• Phone number
• Ageing period 1 to 4 (1 column per period)
• Current
• Total
• Future

• Account number and name
• Transaction date
• Reference
• Gross value
• Discount value
• Net value
• Outstanding value
• Valid until
• If transaction is in query (Y/N)

• Account number and name
• Reference
• Transaction date
• Gross value
• Pay date
• Days to pay

• Posting date
• Account
• Cost centre
• Department
• Transaction date
• Unique reference number
• Reference number
• Amount

• Account reference
• Cost centre
• Department
• Account name
• Account type
• Category code
• Category name

• Account reference
• Cost centre
• Department
• This month's debit, credit and balance
• Year to date debit, credit and balance

• Account reference
• Cost centre
• Department
• This month’s debit, credit and balance
• Year to date debit, credit and balance

• Account reference
• Cost centre
• Department
• This month’s debit, credit and balance
• Year to date debit, credit and balance

• Account reference
• Cost centre
• Department
• This month’s debit, credit and balance
• Year to date debit, credit and balance

• Account reference
• Cost centre
• Department
• This month’s debit, credit and balance
• Year to date debit, credit and balance

• Account reference
• Cost centre
• Department
• Account name
• Brought forward balance
• Unique reference number
• Transaction date
• Period
• Reference
• Narrative
• Debit
• Credit
• Analysis code

• Account reference
• Cost centre
• Department
• Account name
• Brought forward balance
• Unique reference number
• Transaction date
• Period
• Reference
• Narrative
• Debit
• Credit
• Analysis code

• Transaction type
• Reference
• Transaction date
• Net, VAT and gross total

• 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

• 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

• Unique reference number
• Transaction date
• Posting date
• Cost centre
• Department
• Account name
• Reference
• Narrative
• Transaction analysis code
• Debit
• Credit

• Unique reference number
• Transaction date
• Posting date
• Cost centre
• Department
• Account name
• Reference
• Narrative
• Transaction analysis code
• Debit
• Credit

• 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

• Department
• Debit
• Credit
• Balance

• Nominal account
• Department
• Cost centre
• Account name
• Debit
• Credit
• Balance

• Account number
• Cost centre
• Department
• Account name
• Brought forward balance
• Unique reference number
• Transaction date
• Period
• Reference
• Narrative
• Debit
• Credit
• Analysis code

• Account number
• Cost centre
• Department
• Account name
• Brought forward
• Print sequence
• Unique reference number
• Transaction date
• Period
• Reference
• Narrative
• Debit
• Credit
• Analysis code

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Account reference
• Cost centre
• Department
• Net debit, credit and balance for this period
• Net debit, credit and balance year to date

• Account name
• Current year and prior year

• Account name
• Selected year period and YTD and previous year period and year to close

• Account name
• Selected year period and YTD
• Previous year period and year to close

• Account name
• Period budget and actual
• Year to date budget and actual

• Account name
• Period budget and actual
• Year to date budget and actual

• Account name
• Period and year to date %

• Account name
• Period and year to date %

• Account name
• Previous month and previous year to date values

• Account name
• This period and year to date values
• Previous year period and year to date values

• Account name
• This period and year to date values
• Previous year period and year to date values

• Account name
• Selected year and previous year values

• Account name
• Selected year and previous year values

• Account name
• Prior month and prior year to date values

• Account reference
• Cost centre
• Department
• Account name
• Debit and credit YTD values

• Account reference
• Cost centre
• Department
• Account name
• Debit and credit YTD values

• The financial statement title
• Cash flow for 20 periods

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for 13 months (1 column per period)
• Remaining budget

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for 13 months (1 column per period)
• Remaining budget

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for 13 months
• Remaining budget

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for 13 months
• Remaining budget

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for 13 months
• Remaining budget

• Account number and name
• Cost centre
• Department
• Budget, actual, difference and % for the previous 13 months
• Remaining budget

• 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

• Asset number and description
• Depreciation method
• Initial value
• Depreciation date
• Total depreciation
• Disposal date
• Total disposal
• Net book value

• 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

• Unique reference number
• Transaction type
• Account number
• Cost centre
• Department
• Transaction date
• Statement date
• Reference
• Second reference
• Narrative
• Debit
• Credit

• 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

• Bank account code and description
• Currency
• Statement balance as at last statement date
• Transaction type
• Transaction date
• Reference
• Second reference
• Receipt
• Statement amount
• Discrepancy

• Bank account code and description
• Currency
• Statement balance as at last statement date
• Transaction type
• Transaction date
• Reference
• Second reference
• Payment
• Statement Amount
• Discrepancy

• 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

• Product group code and description
• Stock item code and name
• Stock level
• Quantity allocated
• Free stock
• Unit name
• Inactive status

• Product group code
• Stock item code and description
• BOM flag
• Free quantity
• Re-order level
• Required
• Needs re-order flag

• 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

• Warehouse name
• Stock item code
• Bin name
• Quantity
• Stock unit name
• Movement date
• Source area reference
• Area type name

• Stock item code and name
• Stock unit name
• Movement date
• Cost price
• Movement quantity
• Movement value
• Movement type
• Movement reference
• Scourer area reference

• Product group code
• Valuation method
• Item code and name
• Quantity including unconfirmed items
• Quantity
• Unit name
• Valuation price
• Value including unconfirmed
• Value

• Warehouse name
• Stock item code and name
• Stock unit name
• Allocation rule
• Allocation recipient reference
• Bin name
• Allocation date
• Allocation reference
• Quantity allocated

• 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

• 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

• Stock item code and name
• Quantity in stock
• Date of last sale

• Stock item code
• Quantity purchased
• Value purchased
• Quantity sold
• Value sold
• Cost value of sales
• Profit

• Stock item code and name
• Stock unit name
• Transaction date
• Transaction name
• Quantity
• Reference
• 2nd reference
• Sales price
• Cost
• Profit
• Profit % Sales
• Profit % Cost

• Customer account number and name
• Sale price
• Cost price
• Profit
• Profit % Sales
• Profit % Cost

• Stock item code and name
• Stock unit name
• Transaction date
• Transaction name
• Quantity
• Sales value
• Cost
• Profit
• Profit % Sales
• Profit % Cost

• Stock item code and name
• Stock unit name
• Quantity
• Sales value
• Cost
• Profit
• Profit % Sales
• Profit % Cost

• 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

• 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

• Item code and name
• Search category and value

• Product group code and description
• Stock item type
• Costing method
• Batch/Serial type

• Product group code and description
• Stock item type
• Search category name and value

• Product group code and description
• Stock item type
• Search category name and value

• Product group code and description
• Batch/Serial number
• Item code and name
• Quantity
• Batch serial type name

• Item code and name
• Stock unit name
• Batch/Serial number
• Allocation recipient reference
• Bin name
• Allocation date
• Reference
• Quantity Allocated
• Batch/Serial type

• Product group code and description
• Batch/Serial number
• Item code and name
• Quantity
• Batch serial type name

• Batch/Serial type name and number
• Item code and name
• Warehouse name
• Quantity
• Free stock
• Stock unit name

• Item code and name
• Stock unit name
• Sell by date
• Batch/Serial type name
• Traceable ID number
• Warehouse name
• Bin name
• Quantity
• Free stock

• Use by date
• Batch/Serial name and number
• Item code and name
• Bin name
• Quantity
• Free stock
• Stock unit name

• Item code and name
• Stock unit name
• Use by date
• Batch/Serial name and number
• Warehouse name
• Bin name
• Quantity
• Free stock

• 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

• 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

• 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

• 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

• Item code and name
• Unit name
• Date
• Transaction type
• Quantity
• Source area type name
• Source name
• Reference
• Second reference
• Warehouse
• Bin name

• 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

• 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

• 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

• 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

• Item code and name
• Changed date
• Average buying price

• Item code and name
• Changed date
• Standard cost price

• Warehouse name
• Product group code
• Item code and name
• Stocktake cycle period
• Bin name
• Last stocktake date
• Due date

• Stocktake name
• Stocktake date
• Warehouse name
• Last completed stocktake date
• Status

• Warehouse name
• Product group
• Item code and name
• Stocktake cycle period
• Bin name

• Warehouse name
• Bin name

• Search category
• Search value

• Document number
• Customer account number and name
• Promised for
• Priority
• Net amount
• Allocated, despatched and invoiced flags

• Document number
• Customer account number and name
• Status
• Order date
• Promised for
• Priority
• Net amount
• Allocated flag

• Document number
• Customer account number and name
• Status
• Order date
• Promised
• Priority
• Net amount
• Despatched flags

• Document number
• Customer account number and name
• Status
• Order date
• Promised
• Priority
• Net amount
• Despatched flags

• Document number
• Customer account number and name
• Amended since last printed flag
• Order date
• Promised
• Priority
• Net amount

• Document number
• Status
• Date
• Promised delivery date
• Customer account number and name
• Priority
• Print sequence
• Item code
• Description
• Allocation required
• Unit description
• Promised

• Document number
• Status
• Date
• Promised delivery date
• Customer
• Priority
• Print sequence
• Item code
• Description
• To invoice
• Unit description
• Despatched date
• Quantity to be despatched

• 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

• Document number
• Customer
• Status
• Return date
• Promised for
• Priority
• Received and credited flags

• Document number
• Customer account number and name
• Status
• Return date
• Promised for
• Priority
• Net
• Recieved and credited flags

• Document number
• Customer account number and name
• Status
• Return date
• Promised for
• Priority
• Net
• Credited flag

• 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

• 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

• Document number
• Order date
• Order status
• Customer account number
• Customer name
• Customer order number
• Value

• 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

• Document number
• Order status
• Document date
• Promised delivery date
• Priority
• Net, VAT and gross amounts

• 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

• Customer account number
• Customer account name
• Unit name

• 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

• Document number
• Despatch date
• Return number
• Credited flag
• Credit note number
• Item code
• Item description
• Quantity
• Unit descrption
• Warehouse name
• Bin name
• Username

• Cancelled date
• Cancelled quantity
• Unit description
• Quantity
• Order/Return number
• Username

• Item code
• Item description
• Document number
• Amount to allocate
• Stock unit name
• Promised delivery date

• Document number
• Status
• Document date
• Customer account number

• Docuement date
• Invoice/Credit note number
• Date cancelled
• Reason cancelled
• Cancelled by

• Document number
• Customer account number and name
• Status
• Order date
• Net / VAT and gross amounts
• Payment value

• Document number
• Item code
• Item description
• Quantity
• Sales value
• Estimated profit
• Estimated profit %
• Realised profit
• Realised profit %
• Fully realised flag

• Customer account number and name
• Currency symbol
• document number
• Return type name
• Sales value
• Order status
• Estimated profit
• Estimated profit %
• Realised profit
• Realised profit %

• Document number
• Currency symbol
• Pro forma status
• Item code
• Item description
• Quanitity
• Unit description
• Sales value
• Estimated profit
• Estimated profit %

• Customer account number and name
• Currency symbol
• Document number
• Return name
• Sales value
• Pro forma status
• Estimated profit
• Estimated profit %

• Document number
• Currency symbol
• Quotation status
• Item code
• Item description
• Quanitity
• Unit description
• Sales value
• Estimated profit
• Estimated profit %

• Customer account number and name
• Currency symbol
• Document number
• Return name
• Sales value
• Quotation status
• Estimated profit
• Estimated profit %

• Document number
• Currency symbol
• Item code
• Item description
• Quanitity
• Unit description
• Sales value
• Estimated profit
• Estimated profit %

• Customer account number and name
• Currency symbol
• Document number
• Return name
• Sales value
• Estimated profit
• Estimated profit %

• Item code
• Item name
• Stock unit name
• Batch/Serial number
• Allocation Recipient reference
• Bin name
• Allocation date
• Reference
• quantity allocated
• Batch serial type

• document number
• Date
• Batch/serial number
• Order number
• Print sequence
• Invoice number
• Item description
• Quantity
• Batch/Serial type

• document number
• Status
• Net, VAT and gross amount
• Date
• Discount valid until date
• Identification number
• Quantity

• document number
• Date
• Net, VAT and gross amount
• Promised delivery date
• Print sequence
• Item code
• Despatch quantity
• Line total

• Customer account number and name
• Currency
• Document number
• Document date
• Promised for delivery date
• Net, VAT and gross totals

• 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

• Customer account number and name
• Currency
• Invoice/Credit note number
• Document date
• Settlement discount days
• Net, VAT and gross totals

• Customer account number and name
• Cancelled line item code
• Date
• Quantity
• Selling unit description
• Stock cancelled quantity
• Order number
• User name

• Additional charge code
• Charge name
• VAT rate and code
• Nominal account name and number
• Cost centre
• Department
• Charge value

• 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

• Stock item code
• Stock item name
• Stock item description
• Price
• VAT code and name

• Customer account number and name
• Delivery address description
• Customer name and address
• Telephone number
• Fax number
• Email
• Contact name

• Document number
• Supplier account number and name
• Status
• Order date
• Requested
• Invoiced
• Total Net amount

• Document number
• Supplier account number and name
• Status
• Order date
• Requested
• Total net value
• Received flag

• Document number
• Supplier account number and name
• Status
• Order date
• Requested
• Net amount
• Invoiced flag

• Document number
• Supplier account number and name
• Status
• Amended since last printed flag
• Order date
• Requested
• Authorisation

• Item code
• Item name
• Quantity required
• Quantity to purchase
• Stock unit
• To negotiate flag
• Confirmed flag

• Item code
• Item name
• Unit
• Customer account number and name
• Promised delivery date
• Sales order number
• Quantity required

• 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

• Document number
• Status
• Date
• Supplier account number and name
• Item code
• Item description
• Quantity to be invoiced
• Unit description
• Quantity to be received

• Document number
• Supplier account number and name
• Status
• Date
• Requested delivery date
• Received flag
• Credited flag

• Document number
• Supplier account number and name
• Status
• Return date
• Requested delivery date
• Net amount
• Despatched flag

• Document number
• Supplier account number and name
• Status
• Return date
• Requested delivery date
• Total net value
• Credited flag

• Document number
• Status
• Date
• Authorisation
• Supplier account number and name
• Print sequence
• Item code
• Item description
• Total quantity
• Outstanding quantity
• Unit description

• 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

• 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

• Document number
• Supplier account number and name
• Status
• Document date
• Requested delivery date
• Credited flags

• Invoice/Credit number
• Invoice/Credit date
• Item code
• Disputed flag
• Invoice/Credit quantity
• Unit description
• Line tax value
• Line total value
• Username

• Document number
• Document date
• Order/Return number
• Print sequence number
• Item description
• Return quantity
• Unit description
• Warehouse name
• Bin name
• Username

• 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

• Item code
• Cancelled date
• Cancelled quantity
• Buying unit description
• Stock quantity
• Order/Return number
• Username

• Item code
• GRN number
• Supplier GRN number
• Delivery date
• Received by
• Quantity delivered
• Invoiced flag

• Item code
• Warehouse name
• Status
• Quantity received
• Quantity confirmed
• Total cost
• Supplier account number and name

• Document number
• Document date
• Batch/Serial number
• Order/Return number
• Print sequence number
• Item code
• Quantity
• Warehouse name
• Bin name
• Batch/Serial type

• Document number
• Document date
• Net, VAT and gross totals
• Requested delivery date
• Item code
• Item description
• Line quantity
• Receipt return quantity
• Line total

• Supplier account number and name
• Currency symbol
• Document name
• Document number
• Document date
• Requested delivery date
• Net, VAT and gross amounts

• Invoice/Credit number
• Invoice/Credit date
• Item code
• Invoice/Credit quantity
• Unit description
• Line tax value
• Total line value
• Username
• Return type name

• Item code
• Cancelled date
• Cancelled quantity
• Buying unit description
• Stock quantity
• Order/Return number
• Username

• Additional charge code
• Additional charge name
• VAT code and name
• Nominal account name
• Nominal account number
• Cost centre
• Department
• Charge value

• 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

• 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

• 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

• Built item stock code
• Finished item name
• Identification number
• Build date
• Component code and name
• Build number and name
• Identification number
• Component quantity

• Compoenent stock code and name
• Identification number
• Finished item code and name
• Build number, date and name
• Identification number
• Component quantity

• Product group code and description
• Component code and description
• BOM reference
• BOM Sage 200 Version
• BOM description
• Sequence number
• Quantity
• Unit of measure

• Drawing reference and description
• Effective from date
• Effective to date
• BOM reference
• BOM Sage 200 Version
• BOM description

• Operations reference and description
• BOM reference
• BOM Sage 200 Version
• BOM description
• Sequence number
• Default run time in hours minutes and seconds

• 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

• 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

• 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

• 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

• 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

• 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

• History BOM reference
• BOM Sage 200 Version
• Created by
• Date/Time created
• Action
• History reference

• BOM reference and description
• BOM Sage 200 Version
• BOM status
• Print sequence
• Stock code and description
• Quantity
• Unit of measure
• Line type

• 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

• 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

• Build number and reference
• Build date
• Built by
• Built item and name
• Quantity
• Unit of measure
• Unit cost
• Total cost
• Unit of measure

• Key description
• Actual cost
• Committed cost
• Total cost

• Actual cost
• Committed cost
• Total cost
• Total cost budget
• Variance from total budget
• Variance % from total budget

• Revenue
• Prime cost
• Gross profit
• Gross profit %
• Overhead
• Net profit
• Net profit %