Multi-Order Spreadsheets

Purchase Orders Excelerator can produce single purchase orders per spreadsheet sheet, where the purchase order and other header information (e.g supplier, alpha, order date) is at the top of the sheet. Below is an example of a single purchase order sheet.


Purchase Order spreadsheet example

It is also possible to set up your sheet to allow more than one purchase order to be entered. You do this by having the header information in columns beside the detail information (e.g. product, quantity). Below is an example of a multi-order sheet.

Purchase Orders

Purchase Orders

Order number

Supplier code

Wh

Product

Description

Long description

Quantity

When processing a multi-PO spreadsheet, the Excelerator program reads each row of data in turn, including header information. When a value in a “key range” changes, it considers that to be the start of a new purchase order. Key ranges are purchase orders numbers, suppliers, reference, alpha code, header analysis a, b and c. If a blank value is found in any of these, it is NOT considered to be a change (and therefore not a new order).

Key ranges are:

  • purchase orders numbers
  • suppliers
  • reference
  • alpha code
  • header analysis a, b and c.

If a blank value is found in any of these, it is NOT considered to be a change (and therefore not a new order).