Invoice Lines
Administrator

Table of Contents
Invoice Lines with Financial Tracking Transactions 	 # 
Report Parameters 	 # 
Information Columns 	 # 

Invoice Lines with Financial Tracking TransactionsReport Parameters
Information Columns

Invoice Lines with Financial Tracking Transactions
Financial Tracking Code bookings (FTC) bookings against Invoice lines whose dimensions are the Organisation, requisitioner and supplier, budget and account codes.

Report Parameters
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.

Information Columns
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.