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.

Note 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.

Note 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.

Important 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 Solution Configuration Manager > Global Settings > Database SettingsDatabase 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.

Important 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 Solution Configuration Manager > Global Settings > Database SettingsDatabase 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.