Line Item Table Settings
These settings control invoice line item data validation. Depending on what options are selected, different settings are available.
- Extract Line Items
-
If selected, line items are extracted.
If cleared, line items are not required for any document.
- Skip For Service
-
If selected, line items are not be mandatory for invoices relating to a service purchase order.
For the best results, select this option. This is because line items are not usually required for service purchase orders. If cleared, data may be extracted that has no purpose.This setting is available only when Extract Line Items is selected above.
- Line Total Only For Service
-
If selected, only the line item total value is required for the invoices relating to a service purchase order.
This setting is available only when Extract Line Items is selected above.
- Skip For Multi Line Limits
-
If selected, the system does not require line items for invoices relating to a multiple line item purchase order. All line items are limits (category 1) or category 9, where a goods receipt based invoice verification is not set.
If cleared, the system requires the user to enter line items for the above mentioned purchase order types. They enter a description and total only.
This setting is available only when Extract Line Items is selected above.
- Skip For NO PO
-
If selected, line items are not mandatory for non-purchase order invoices.
For the best results, select this option. This is because line items are not usually required for non-purchase orders. If cleared, data may be extracted that has no purpose.This setting is available only when Extract Line Items is selected above.
- Skip For Credit
-
If selected, line items are not mandatory for credit memos.
This setting is available only when Extract Line Items is selected above.
- Skip For MIRA
-
If selected, line items are not mandatory for invoices that have a 1-1 match with the total purchase order value, or the value of all goods receipts not yet invoiced for the entire purchase order.
This setting is available only when Extract Line Items is selected above.
- Skip For Unreleased PO
-
If selected, line items are not mandatory for invoices relating to a purchase order that has not yet been released.
This setting is available only when Extract Line Items is selected above.
- Skip For Invalid PO
-
If selected, the system does not require line items if a missing or invalid purchase order invalid reason is selected by the user.
This setting is available only when Extract Line Items is selected above.
- Skip For Invalid Vendor
-
If selected, the system does not require line items if the vendor-not-found invalid reason is selected by the user.
This setting is available only when Extract Line Items is selected above.
- Skip For Utility Vendor
-
If selected, the system does not require line items for a utility vendor. This saves considerable processing time if utility invoices are large documents with multiple backing sheets. This is because the system does not need to evaluate as potential line items that require extraction.
This setting is available only when Extract Line Items is selected above.
- Never Validate Line Items
-
If selected, line items may be extracted, but no validation is carried out.
This setting is available only when Extract Line Items is selected above.
- Validate UOM from DB
-
If selected, the system validates UOMs against an external database.
This option and all of its dependent settings are not available in the Azure cloud environment. - SQL Connection Group
-
The SQL connection group that specifies the UOM database connection string as set in the Database Connection Settings. If no connection group is specified, the system uses group 1.
This setting is available only when Validate UOM from DB is selected above.
- DB Table Name
-
The name of the database table that contains the UOM information.
This setting is available only when Validate UOM from DB is selected above.
- DB UOM reference values
-
The UOM database column.
This setting is available only when Validate UOM from DB is selected above.
- Validate UOM from MarkView
-
If selected, the system validates UOMs against a MarkView database.
This option is not available in the Azure cloud environment. - SQL Connection Group
-
The SQL connection group that specifies the UOM database connection string that refers to the MarkView database. This is set in the Database Connection Settings. If no connection group is specified, the system uses group 1.
This setting is available only when Validate UOM from MarkView is selected above.