Line Item Detail
Kofax AP Agility attempts to capture information at the line item level. Any amounts are converted to a valid amount using a period as the decimal separator.
The following line item fields are supported.
|
Line Item Field |
Description |
|---|---|
|
Quantity |
The quantity of the line item. Note If no quantity is printed on the document and the unit price equals the line total, the quantity is set to 1 by
default.
|
|
Unit Price |
The unit price of the line item. |
|
Line Total |
The total price of the line item. |
|
PO |
Purchase order number related to the line item. This is populated automatically by the line pairing routine when the invoice line is successfully paired to a line on the purchase order. |
|
Line |
Purchase order line item related to the invoice line item. This is populated automatically when the invoice line is paired with a line on the purchase order. |
|
Material Number |
Material number associated with the invoice line item. If the captured material number is the material number from the point of view of the organization, then this is used to facilitate the line pairing function. For line item detail captured at the generic level, valid formats for the material number can be specified in the Material Number Settings. |
|
Description |
Invoice line item description. |
|
UOM |
Unit of measure expressed in the invoice quantity. For line item detail captured at the generic level, valid formats for the material number are specified in the Unit Of Measure Settings tab. |
|
UofQ (Price Unit) |
The number of units grouped for a unit price. For example, if a line item has 5000 units that are invoiced at 100 dollars per 1000 units, then the line item total is 500 dollars. In this case, the price unit is 1000. For certain values, there are several expressions that are recognized as synonyms for those values, and the values are substituted accordingly. Specifically, when the terms C, CENT, HP, and HUNDRED are extracted, they are recognized as a value of 100. Also, the terms M, TH, MLF, MT, 1.000, 1,000, THOUSAND, THOU, TST, TPC, MILLE, 1000,0, 1000.0, MFT, POUR1000, MI, MIL, DUIZEND, 1.000M, and 1,000M all represent a value of 1000. The default is set to 1 for this field. |
|
Discount |
Discount given by the vendor against the quoted unit price. This field can represent a discount expressed as a percentage that is subtracted from the quoted unit price. This field must be populated if the unit price captured is not the net unit price of any discounts. |
|
Category |
Miscellaneous charge category applied to the invoice line item based on the extracted line item description. This field is set by the system automatically, based on the setting specified in the Misc Charge Categories tab. This field cannot be changed by a Validation Activity user. |
|
Tax Rate |
Tax percentage rate applied to the invoice line item. If a valid value is captured, the field value is used by the system in the tax determination routine for countries that do not use tax jurisdictions. During document export, tax rates at line item level are cleaned up. For example, if the total invoice tax amount is zero, then a rate of zero is set for every line item. If the value is not between 0 and 100, it is blanked out. Additionally, if automatic tax determination is activated and tax codes are determined through a database lookup, the system removes any tax rates that do not correspond to valid percentages listed in the table for the country in which tax applies. To increase extraction of tax rates, valid rates must be specified against the primary and secondary rate parameters in the Tax Configuration tab. Note The system is not able to extract custom vendor tax rate codes at the line item level and then perform a
conversion to an actual percentage rate.
|
|
Tax Amount |
Tax amount applied to the invoice line item. This column is also available for a user to enter line level ICMS tax amounts, which are mandatory for multi-line Brazilian Note Fiscal invoices where ICMS tax is being charged and no corresponding line level tax rates have been captured. |
The Line Item Table Settings control the following requirements.
-
Line items are required for any document.
-
Line items are required for Non-PO documents.
-
Line items are required for credit memos.
-
Line items are required for invoices relating to a service purchase order.
-
Only the line item totals is required for invoices relating to a service purchase order.
-
Line items are required if the purchase order has not been released.
-
Line items are required for the MIRA scenario. This is when there is a one-to-one relationship between invoice and purchase order. For example, the total value of the invoice matches either the total value of the purchase order or the total value of all goods receipts against the purchase order that have not yet been invoiced.
-
Line items are required if either the VENDOR NOT FOUND or MISSING/INVALID PO invalid reasons are selected by the user in the Validation Activity.
-
Line items are required if the vendor is a utility vendor.
If line items are not required or if an appropriate invalid reason is set, the line item table is set to valid regardless of content.
Each line item in a table is valid if any of the following calculations are true.
-
Line Item Total = ( Quantity * Unit Price) / UofQ )
-
Line Item Total = ( Quantity * ( Unit Price – Discount ) ) / UofQ )
-
Line Item Total = ( Quantity * ( Unit Price - ( Unit Price * Discount / 100 ) ) ) / UofQ )
The tolerance of the above calculation is set in the Tolerance Settings.
If the invoice relates to a service purchase order then the above check is skipped and only the line total column is required.