Parameter

Description

Invoice Status

"ALL" is the default and the user is presented with a list.

Organisation

This will default to the highest level of buying Organisation and will be used to restrict the data extracted. The report requester will be able to select a lower level group within their Organisation tree and thus filtering the order data extract.

Start Date

This is the start date of the date range used to select the orders based on the Purchase order date.

End Date

This is the end date of the date range used to select the orders based on the Purchase order date.

Number of Days to Extract

Used to calculate a moveable date range every time the report job runs..

• Start date will be set to (Run date - Number of days to extract)
• End date will be set to the Run date

This assumes that the Extract Up to and Including (End date) has No Value entered.

If a value is entered for the Extract Up to and Including (End date) then the date range becomes a Fixed Range.

Extract Up to and Including

If a value is entered for the Extract Up to and Including (End date) then the date range becomes a Fixed Range used in conjunction with the Number of Days to Extract.

Budget or Account Code Filter

A string part or all of the account code for the posting of a budget reference code. The system will prompt for the type of match.

Invoiced PO Line level FTC

Derivation

Requisition No

The Identifier that the system assigns to make each requisition unique.

Requisition Type

Requisition, Standard Order, Public Template or Private Template.

Grouping Name (Rec Req)

If the field is empty it is an identifier of a template from which the order has been generated.

Original PO No

The Internal number Identifier that the system assigns to the first version of the order and can be used to group all versions of an order.

PO No

The Identifier that the system assigns to make each order unique within your organisation. Subsequent version adds a numeric suffix to the Original Purchasing Order Number.

Version

This is the sequence number of the version of an order.

Line No

The line number will be that of the item number. However as some charges are accounted for at invoice rather than line level a value of 0 is used to show is tax or delivery amounts.

Invoice Status

The status of the invoice from receipt to the matching and settlement.

Invoice Type

The Invoice can be either a "Debit" or "Credit".

Settlement Status

The settlement status of the invoice. Received - unprocessed

·         Reconciled.

·         Mismatch between order and invoice (for non-tolerance errors).

·         Processed to Accounts Payable.

·         Remittance received from A/P.

·         Reconciled - pending full invoicing.

·         Invoice requires approval routing.

·         Returned to requisitioner.

·         Returned to Invoicer.

·         Invoice suspended due to mismatch at summary level.

·         Deactivated.

·         Exception - Partial match pending receipt.

·         Exception - Full match pending receipt.

·         Exception - order tolerance exceeded.

·         Force settled.

·         Exception - VAT tolerance exceeded.

·         Delivery tolerance exceeded.

·         VAT tolerance exceeded.

Settlement Type

The invoice is settled either on the amount or on the basis of the quantity.

Invoice No

The Invoice number from the supplier.

Invoice Line

The line number will be that of the item number. However as some charges are accounted for at invoice rather than line level a value of 0 is used to show is tax or delivery amounts.

Invoice Line Type

The enumeration that indicates if the amount is against a "Line Item", "Invoice Tax", or "Invoice delivery".

Currency

The ISO Currency Code in which the Invoice is raised.

Invoiced Qty

The quantity of the Item that is invoiced.

UOM

The unit of measure code that the item is Invoiced in. Usually a subset of the ISO standard for measure. E.g., ‘EA' for each or ‘KG’ for Kilo etc.

Unit Price

The price of each item.

Invoiced Net Price

The invoiced Qty multiplied by the unit price.

Invoice Tax

Any invoice tax amount.

Tax Code

The tax type for which the tax applies.

Invoice Gross Price

The Invoice net price + the Invoice Tax.

Invoice Received

The date the Invoice was received in the organisation. This date may be null for Invoices loaded from other systems or when an organisation does not make this a mandatory field.

Invoice Date

The Date of issue of the invoice.

Invoice Processed Date

The date the invoice was last processed in the system. The status indicates if this is matching, approving, paying or rejection.

Item No

The SKU (item number) from the invoiced item.

Description

Any description of the invoiced item.

Source

The manner in which the invoice was received, either manually entered or from another system.

Invoice Loaded by ID

The identifier of the user who was responsible for the loading of the invoice data.

Invoice Loaded by Name

The name of the user who loaded the invoice.

Supplier ID

The internal identifier that make the supplier unique.

Supplier

The name of the supplying organisation.

Order Qty

The number of units of the line item ordered.

Ordered UOM

The unit of measure code that the item is ordered in. Usually a subset of the ISO standard for measure. E.g., ‘EA' for each or ‘KG’ for Kilo etc.

Item Price

The price per unit for the ordered item.

Ordered Net Price

The item price multiplied by the item Quantity.

Order Est Tax

The taxation code applied to the line. This can be empty for customers that do not implement taxation features.

Order Est Gross

The projected estimated value of any tax anticipated on the Invoice. This may vary from that which the supplier calculates.

Owning Org ID

The internal identifier of the owning organisational group within the buying organisational tree that owns the order. This Identifier will allow the renaming of organisational nodes.

Owning Organisation

The name of the organisational group within the buying organisational tree that owns the Order.

Full Parentage

The full path with the organisation tree of the organisational group. This is done by the concatenating the identifiers of the parents of the owning group together. E.g., “A.B.C” this allows the filtering/grouping of data into higher levels within the organisation.

Method Key

The Internal Identifier of the account method used to describe the account code segments.

Method

The organisation’s title for the account method used to describe the account code segments.

Line %

The proportion of the net price to be posted to the account code.

Account Code

The Account Code against which the value will be posted.

Segment n(1-10)

10 Fields that show the individual value of components of the account code string.

Segment n(1-10) Description

The description associated with an individual value of component of the account code string.

Budget Ref

The short identifier used with the business to identify a budget.

Line Reference

The line reference within the budget.

Budget Code

The budget account code string used to group the posting.

Budget Period End

The date of the end of the budget period to which this applies.

Period Name

The name of the budget period e.g., Jan 2013.