Tariff Calculation

The tariff calculation must be executed manually on a document, or it occurs automatically during the transfer process. To calculate a document in Sales Transaction Entry go to Additional >> Recalc Tariff (CTRL + 6 is the hotkey).

The tariff can also be recalculated/applied for a Sales Batch from the Sales Batch Entry window. Select the Batch then go to Additional >> Recalc Tariff (CTRL + 6 is the hotkey). Only ORDERS will be processed and any locked documents will be skipped (i.e. they are open in a window).

The tariff calculation processes each line on the document separately, then adds the total to get the document level tariff.

GLOBAL SCOPE

• If the Customer is excluded no calculation is performed
• If Calculate On = Subtotal in multiples the Subtotal by the Percent from Setup. This is stored either as a Sales Line using the TARIFF item, or in the Miscellaneous field.
• If Calculate On = Sales Inventory Items it calculates a per line tariff based on either:
  • % Value: The Item’s Current or Standard Code multiplied by the Percent
  • % Price: The Sales Line Price multiplied by the Percent
  • This is stored either Sales Line using the TARIFF item, or in the Miscellaneous field.
  • IMPORTANT: This calculation can also use a SQL stored procedure to override the Default Calculation on a per line basis. See the Custom Sales Line Tariff section.

DETAILED SCOPE

• If the Customer is excluded no calculation is performed
• For each sales line:
• If the Item Number does not exist in Item Maintenance it is skipped
• It retrieves the Item-Tariff Codes. For each Tariff Code assigned:
  • It calculates the tariff based on the Rate and Method
  • If the Tariff Code has Specific Amount and Weight the additional amount is calculated:
    • Specific Amount $ * (Sales QTY * (Item Wt/Per Wt))
  • The two values are added together and added to the Sales Line Total (W7136SOPLineTotal)
  • The Tariff Code and Amount are added to the Sales Line Detail (W7136SOPLineDtl) if “Sales Line per Item w/Detail” is selected in Setup.
  • IMPORTANT: If you assign Tariff Codes to a top level item (i.e. 100XLG) that will prevent the software from calculating the tariff based on the BOM, and it will treat the item like a “buy” item.
• BOM Source
  • IMPORTANT: If a top level item such as 100XLG has Tariff Codes assigned to it, the Tariff Module will treat it as a “buy” item and will not explode the BOM.
  • If the Tariff Method is % List Price no BOM is used and tariff will be calculated based on the top-level item only.
  • Based on the setup options that are enabled it checks for an assembly in the order shown below. It uses the first one it finds. The calculation explodes the BOM and extends the quantities to calculate the tariff for each purchased part within the assembly. The total is rolled up to arrive at the finished good tariff. For each item in the BOM, if “Sales Line per Item w/Detail” is select in Setup, it will create a cumulative total for each Tariff Code, this total for the code will be stored in the Sales Line Detail (W7136SOPLineDtl)
    • MFG BOM
    • INV BOM
    • INV KIT
• If No BOM Source is used tariff is calculated as:
  • % Value = Tariff% * Cost
  • %Price = Tariff% * Price

The total for the document is rounded using the decimal setting from Tariff Setup.

The SOP Line Tariff is calculated as the total per unit tariff.

Sales Line per Item w/Detail

If the Tariff is added per sales line there will be a TARIFF line per sales line that will have the total tariff for that item. If the “With Detail” option is marked the Tariff Code details will be added into the SOP Line Comments for the Tariff line. There are 4 available Comment Lines per sales line, if there are more than four Tariff Codes for an item (such as in a complex assembly) the Tariff Module will add additional TARIFF lines as needed so that more Tariff Codes can be displayed (i.e. there will be an additional line for each four Tariff Codes).