These settings are use to configure the identification and handling of miscellaneous charges. For example, freight, customs charges, or fuel charges.

Some options are displayed only if specific settings are selected. These settings are indicated below.

Unplanned Threshold

The invoice maximum value that the sum of all unplanned miscellaneous charges can reach before the system takes a course of action.

Important This option is not available in the Azure cloud environment.

The value for this option is set to 10000 by default.

Block If Over Threshold

If selected and if the total sum of all unplanned miscellaneous charges on the invoice exceeds the value defined in Unplanned Threshold, the system sets a block on an invoice. This means that the payment is blocked in the ERP system.

Important This option is relevant only if you are using SAP.

Important This option is not available in the Azure cloud environment.

This option is cleared by default.

Block Code

The block code that is applied to an invoice for reasons of excessive unplanned miscellaneous charges.

This setting is displayed only if Block If Over Threshold is selected above.

Third Party Freight Code

The block code that is applied to an invoice if it has excessive unplanned miscellaneous charges.

The value for this option is set to F by default.

Read SAP PO Conditions

If selected, the system reads the planned condition records on the purchase order in SAP.

Important This option is not available in the Azure cloud environment.

This option is cleared by default.

Handle Misc Charges For Services

If selected, the miscellaneous charge processing logic is also applied to invoices that relate to service purchase orders.

This option is cleared by default.

Validate From DB

If selected, the system looks in a database to determine the correct general ledger entry for a miscellaneous charge.

Important This option and all of its dependent settings are not available in the Azure cloud environment.

This option is cleared by default.

Database Connection Name

The database connection that specifies the miscellaneous charge database connection string.

This setting is available only when Validate From DB is selected above.

This setting is available only when Validate From DB is selected above.

DB Schema

Enter the name of a schema to filter the list of database tables available for the selected Database Connection Name.

If this field is left blank, all database tables that you have permission to access, are displayed.

This setting is available only when Validate From DB is selected above.

DB Table Name

The name of the database table that contains the GL coding strings that are used for miscellaneous charges. The list is populated based on the selected Database Connection Name and if used, the specified schema. If the selected table has columns that match the settings below, they are populated automatically.

This setting is available only when Validate From DB is selected above.

Note For more information about what columns in the database table are used for filtering and what columns are used for export, refer to Handle miscellaneous charges.

Use PO Partition

If selected, the purchase order database lookup uses a purchase order partition. Purchase order partitions are set against the organization that is configured in Settings > Organizations.

This setting is available only when Validate From DB is selected above.

This option is cleared by default.

PO Partition Column

The PO Partition ID as specified in the Settings > IP Configuration > Global Settings > Partition Settings > PO Number Partition tab.

This option is available only when Validate From DB and Use PO Partition are selected above.

DB Company Code

The name of the database table column that holds the company code or business unit of the miscellaneous charge.

This setting is available only when Validate From DB is selected above.

DB Category

The name of the column that contains the miscellaneous charge category. This refers to the Code value in the Misc Charge Categories tab.

This setting is available only when Validate From DB is selected above.

DB Plant

The name of the column in the plant database table that contains the plant ID.

This setting is available only when Validate From DB is selected above.

DB Line Type

The name of the column that contains the line type. This refers to the Line Type value in the Misc Charge Categories tab.

This setting is available only when Validate From DB is selected above.

DB GL Account

The name of the column that contains the GL account where matching miscellaneous charges are booked.

This setting is available only when Validate From DB is selected above.

DB Cost Center

The name of the column that contains the cost center where matching miscellaneous charges are booked.

This setting is available only when Validate From DB is selected above.

DB Profit Center

The name of the column that contains the profit center where matching miscellaneous charged are booked.

This setting is available only when Validate From DB is selected above.

DB Tax Code

The name of the column that contains the tax code for matching miscellaneous changes.

This setting is available only when Validate From DB is selected above.

The following buttons are available at the bottom of the window.

Save

Saves your changes and the window is closed.

Reload

Deletes any unsaved changes and resets the field values back to the last saved settings.