Update tax classifications

Tax Management for Drink-IT  •  Article  •  10/21/2026  • 

The Tax Classification Update tool provides a unified way to bulk-update tax classifications on master data records and open document lines. It replaces the need to run separate batch reports for items. The process follows a two-step approach: first, a preparation step clones the required tax-code-level classifications and tax rules from the existing code to the new one; then the actual update modifies master data and document lines. Every update run produces a complete audit trail of what changed, what was skipped, and why.

In this release, the tool supports items and their related open document lines. Support for customers, vendors, and locations will be added in a future release.

Prerequisites

Before updating tax classifications:

  • The new general tax classification must already exist on the General Tax Classifications page for the Item entity type. The preparation step clones tax-code-level classifications and tax rules, but does not create the general classification itself.
  • Tax classification relations must exist on the item records that need updating.
  • Open documents (sales orders, purchase orders, transfer orders) that should be included in the update must not be released, fully shipped, received, or invoiced.

Set up tax classification update entries

  1. Select the Search icon, enter Tax Classification Updates, and choose the related link.
    The Tax Classification Updates page opens. You can also access this page from the Tax page (card) by selecting the Tax Classification Updates action in the Navigate group.

  2. On the Tax Classification Updates page, create a new line and enter information in the following fields:

FieldDescription
TypeSelect the entity type to update. In the current release, only Item is available. Support for Customer, Vendor, and Location will be added in a future release. Changing this field clears all downstream fields.
UpdateSelect the update mode. Options: General (updates all entities of the selected type carrying the existing tax classification), Specific (targets a single named entity).
No.Select the entity number when the Update field is set to Specific. This field is not editable when the Update field is set to General. The lookup filters to the selected entity type.
Address CodeReserved for future use. This field becomes relevant when customer and vendor entity types are available in a future release.
DescriptionSpecifies the name or description of the entity, derived automatically from master data.
Existing Tax ClassificationSelect the current tax classification to replace. The lookup filters to tax general classifications matching the selected entity type.
New Tax ClassificationSelect the new tax classification to assign. The lookup filters to tax general classifications matching the selected entity type.
Planned UpdateSpecifies the planned date for executing the update. Defaults to the work date. This field cannot be blank.
  • When the Update field is set to General, the update applies to all entities of the selected type that carry the existing tax classification. However, entities that have a concurrent Specific entry with a planned update date within the same date range are automatically excluded from the general update.
  • Fields are editable only when the Status field is Open, Error, or Prepared.
  1. Repeat step 2 for each tax classification change that needs to be applied.

Prepare the update

Before executing the actual update, run the preparation step to clone the required background setup from the existing classification to the new one.

  1. On the Tax Classification Updates page, select the Prepare update action.

  2. The system processes all entries with status Open:
    For each entry, tax-code-level classifications (including rate code, excise type, and references) and tax rules are cloned from the existing classification code to the new one. If the tax-code-level classification or tax rule already exists for the new code, it is not duplicated. After preparation, the Status field is set to Prepared.

If no open entries exist, the message "No open tax classification update entries were found." is displayed.

Preview changes with a dry run

After preparation, you can preview what will change and what will be skipped before committing.

  1. On the Tax Classification Updates page, select the Tax Classification Update action.

  2. In the dialog that opens, enter information in the following fields:

FieldDescription
Date FromEnter the start date for selecting tax classification update entries. This field is mandatory.
Date ToEnter the end date for selecting entries. Leave blank to include all entries from the start date onwards.
ProcessClear this checkbox to perform a dry run. When cleared, log entries are written showing what would change, but no master data or document lines are modified.
  1. Select OK to run the dry run.
    The system writes log entries for each affected master data record and document line. The No. of Log Lines Master Data and No. of Log Lines Documents fields on each entry show the counts.

  2. Select the Tax Classification Log Entries action to review the log. Each log entry shows:

    • The existing and new tax classification
    • The existing and new movement type, tax amount, and rate code (for document lines)
    • Whether an item charge line was added, deleted, or already existed
    • The Action field: To be updated (eligible for update), Updated (successfully changed), or Skipped (blocked)
    • The Reason field (populated when the action is Skipped)
  • Document lines are skipped (not updated) when any of the following conditions applies:
  • The document is released.
  • The line has a partial shipment or receipt (duty point = Ship/Receive).
  • The line has been partially invoiced (duty point = Invoice).
  • The new tax classification would trigger a blocked tax rule for the transaction.

Execute the update

  1. On the Tax Classification Updates page, select the Tax Classification Update action.

  2. In the dialog, set the Date From field and optionally the Date To field, then select the Process checkbox.

  3. Select OK to execute the update.
    The system processes all entries with status Open, Prepared, or Partially Processed whose planned update date falls within the specified range. For entries still in status Open, the preparation step runs automatically before the update executes. For each entry:

    • Master data: the existing tax classification relation is deleted and a new one is inserted with the new tax classification. For items, the Default Class. field is also updated if it matches the existing classification.
    • Document lines: eligible lines are updated with the new tax classification. Item charge lines are added, updated, or deleted as needed based on movement type changes.
    • The Status field is set to Processed when all lines are updated, or Partially Processed when some document lines are skipped. The Remarks field shows "Some documents are skipped." for partially processed entries.
  4. Review the results in the Status, Date of Update, Time of Update, and Updated by User fields.

  • Entries with status Processed or Partially Processed cannot be deleted.
  • Entries with status Partially Processed can be re-run. When re-running, only the previously skipped document lines are retried; lines that already succeeded are not touched.

For example, a brewery needs to reclassify all items from tax classification S001 to SA03 effective 1 January 2026. On the Tax Classification Updates page, a new line is created with Type = Item, Update = General, Existing Tax Classification = S001, New Tax Classification = SA03, and Planned Update = 01/01/2026. However, item 1010 requires a different classification (SA01 instead of SA03), so a second line is created with Update = Specific, No. = 1010, and New Tax Classification = SA01. First, the Prepare update action is run to clone the tax-code-level classifications and tax rules from S001 to SA03 and from S001 to SA01. Then the Tax Classification Update action is run with Process cleared to preview the changes. After reviewing the log entries and confirming they are correct, the update is run again with Process selected. Item 1010 is excluded from the general S001-to-SA03 update because a specific entry exists for it, and is instead updated to SA01. All other items carrying S001 are updated to SA03.

Review log entries

The Tax Classification Log Entries page is a read-only list showing every master data and document line affected by an update run.

  • Select the Document Tax Line action to open the document tax lines filtered to the source document of the selected log entry.
  • Select the Show Record action to open the affected entity card or source document (sales order, purchase order, or transfer order).

Deleting a tax classification update entry also deletes all related log entries.