Application of Tax Groups & Product Tax Exceptions

Tax groups and product tax exceptions, created in Invoice Tax Codes (ibis_in05), Invoice Tax Groups (ibis_in06) and Invoice Product Tax Exception (ibis_in07), are used in the following programs in PointForce iTopia:

Tax Group - Customers (ibis_sucu.su13)
Tax Group - Customer Ship To Addresses (ibis_su14)
Product Tax Code - Products (ibis_im13)
Product Tax - Inventory Supplementary Charges (ibis_in01)
Tax Group - Order and Quote Entry (ibis_oe30/General), Invoice Direct Bill and Credit Note Entry (ibis_in41/General), Retail Cash Counter Invoice Entry (ibis_rs41/General)
Tax Group - 'More Detail Data' window on the Lines folder in OE30, IN41, RS41
Tax Group - 'Supplementary Charge' window on the Lines folder in OE30, IN41, RS41

Here is an example of a product with a product tax code exception:

  1. Customers (ibis_sucu.su13/Taxes section):

    • A tax group is assigned to each customer. This tax group becomes the default tax group used on the the customer's sales orders in OE30/IN41/RS41. The tax routine uses the tax group to calculate the appropriate taxes for the customer's order.

    • Following our example, Midland Electronics is set up with a tax group of 'Midlan-R', meaning they will be charged the regular Midland area taxes: Michigan State tax, Midland County tax and Midland City tax.

Tax Group SU13
Example of Tax Group in SU13

  1. Customer Ship To Addresses (ibis_su14):

    • A tax group is assigned to each ship to address. When a sales order is shipped to an alternate ship to, the tax group from SU14 overrides the customer's default tax group from the customer record (ibis_sucu.su13).

    • The ship to tax group relates to the taxes required for the destination address whereas the customer's default tax group from the customer record reflects the taxation required for the customer's primary address.

    • In our example, the Midland Electronics West End location is assigned the same tax group as Midland Electronics in SU13, 'Midlan-R'.

    Tax Group SU14
    Example of Tax Group in SU14

  2. Products (ibis_im13):

    • Every product is assigned a product tax code. Product tax codes are created in IN07 and are used by the tax routine to identify any 'exceptions to the rule' when calculating taxes on the product.

    • In our example, the product AAA Battery is assigned a product tax code of 'Battery'. Batteries in Midland include a battery disposal tax. As a result, IN07 is configured with a product tax code of 'Battery'.

      • The 'Battery' product tax group in IN07 is made up of the 'Midlan-R' tax group being overridden by the 'Midlan-B' tax group. (The 'Midlan-B' tax group consists of the Michigan State tax, Midland County tax, Midland City tax PLUS the battery disposal tax.)

    Prod Tax Code IM13
    Example of product Tax Code in IM13

  3. Order and Quote Entry (ibis_oe30/General), Invoice Direct Bill and Credit Note Entry (ibis_in41/General), Retail Cash Counter Invoice Entry (ibis_rs41/General):

    • Following our example, the tax group for Midland Electronics is 'Midlan-R' (from the Customer view). The product tax code for the product AAA Battery is 'Battery' (from the Products view).

      • When Midland Electronics orders AAA Battery, the tax group on the General folder of OE30/IN41/RS41 defaults to 'Midlan-R'. The tax group on the AAA Battery detail record defaults to 'Midlan-B' (from IN07), meaning that this product detail record will be charged the regular Midland taxes (State, County and City) PLUS the battery disposal tax.

Tax Group OE30
Example of Tax Group in OE30/General

Tax Group More Data
Example of Tax Group in 'More Detail Data'

Here is a second example, only this time we are using a supplementary charge with a product tax code exception:

In this example, you are invoicing a customer for interest charges, and the supplementary charge on the invoice (direct bill) is flagged with no taxes.

  1. Customers (ibis_sucu.su13/Taxes section):

    • Following the previous example, the customer Midland Electronics is set up with a tax group of 'Midlan-R', meaning they will be charged the regular Midland area taxes: Michigan State tax, Midland County tax and Midland City tax.

  2. Invoice Supplementary Charges (ibis_in01):

    • Every supplementary charge is assigned a product tax code. Product tax codes are created in IN07 and are used by the tax routine to identify any 'exceptions to the rule' when calculating taxes incurred for this supp. charge.

    • In our example, the supp. charge 'Service Charge' is assigned a product tax code of 'Exempt'. Service charges should not be charged taxes. As a result, IN07 is configured with a product tax code of 'Exempt'.

      • The 'Exempt' product tax code is made up of the 'Midlan-R' tax group being overridden by the 'NOTAX' tax group.

    Prod Tax IN01
    Example of Product Tax in IN01

  3. Order and Quote Entry (ibis_oe30/General), Invoice Direct Bill and Credit Note Entry (ibis_in41/General), Retail Cash Counter Invoice Entry (ibis_rs41/General):

    • Following our example, the tax group for Midland Electronics is 'Midlan-R' (from SU13). The product tax code for the service charge (SC) supp. charge is 'Exempt' (from IN01).

      • When Midland Electronics incurs a supp. charge of SC on the invoice, the tax group on the General folder of IN41 defaults to 'Midlan-R'. The tax group on the supp. charge detail record defaults to 'NOTAXES' (from IN07), meaning that this supp. charge will have no taxes charged against it.

    Tax Group Supp Charge
    Example of Tax Group in 'Supplementary Charge'

  1. 'Supplementary Charge' window on the Lines folder on the Invoice:

    • The tax group on the supplementary charge window determines how the tax routine will assess each supplementary charge on the sales order.

    • Each supp. charge added to the sales order/Invoice defaults to the product tax code assigned to the supp. charge in IN01.

    • When a transaction is totalled, the tax codes (IN05) within the assigned tax group (IN06) of each supp. charge are assessed to determine the taxable sales for each individual tax and to calculate the tax amount. In this case, no taxes will be applied to this supp. charge.

  Back