Change Tax Group Utility (CC55)

The Change Tax Group Utility (CC55) program is an optional program. If it is necessary to create a new Tax Group to accommodate an upcoming tax change, then that Tax Group needs to be passed to the applicable Customer Master file records, their Ship To Addresses and Cost Center Master file records so tax on new orders will calculate properly. The Tax Group on any existing Orders/Quotes for those customers also needs to be reassigned so that tax will be calculated properly on an order entered prior to the effective date of the tax change, but invoiced after the effective date (the new tax needs to be applied to the invoice in this scenario).

  • This program will reassign the Tax Group code in the Customer Master, Ship-To Master, Cost Center Master and Open Order file based on the parameters entered by the operator.

  • If the Summary Invoicing and/or E-Commerce modules are in use, then the Tax Group information will be converted. Specifically, the tax group will be recoded in the Cost Centre Master and/or the Open Carts File.

In the example below, Tax Group GST is changing to Tax Group HST-ON for all Ontario customers:

Once the Tax Group in the Customer Master, Ship-To Master and Cost Center Master are changed, the program then processes the Open Order file using the customer's new Tax Group Code from the Customer or Ship To Master.

All order detail lines (products and supplementary charges) are re-processed through the Tax Calculation routine.

  • If the Product Tax Code has changed for a product (IM13) or for a Supplementary Charge (IN01) since the order was entered, it will be picked up and written into the order detail line and subsequently used to look for exceptions in IN07.

  • If the new tax change triggered the creation of a new exception record in IN07, each order line will be examined to see if the new exception is now applicable.

  • If the Tax Group was overridden in the order detail line, then it will be retained; the utility will not change a Tax Group that was overridden on the original order detail line.

It may be necessary to run this program more than once depending upon the extent of the tax change. For example, to facilitate the changes depicted in the table below, you would need to run CC55 five times:

    Province Existing Tax Group New Tax Group
    ON GST (GST only) HST-ON (HST 13%)
    ON ON-BOTH (GST & Ontario PST) HST-ON (HST 13%)
    BC GST (GST only) HST-BC (HST 12%)
    BC BC-BOTH (GST & BC PST) HST-BC (HST 12%)
    NS HST HST-NS (HST 15%)

Note: Upon execution of this program, backup copies are made of the Customer Master, Ship-To Master and Open Order files. This is a precaution in the event that we should need to reset Tax Groups to their original setting.

The following list defines every field on CC55:

  • Company – defaults to the company from which program CC55 was executed and processes only the Customer Master, Ship To Master and Open Order file for that company.

  • Province – enter or select from the query a valid Province Code. Only Customers and Ship To records matching the entered code will be processed. There is not a Province Code in the header of an order. The province on the order is set to the customer’s province if the Ship To address = SAME; otherwise the province is set to the province assigned in the Ship To Address.

  • Current Tax Group - enter or select from the query a valid Tax Group, as defined in IN06. Customers, Ship to records and Open Orders that match the entered Province + Current Tax Group will be processed.

  • New Tax Group – enter or select from the query a valid Tax Group, as defined in IN06. The Tax Group Code in the Customer Master, Ship To Master and Open Order file will be reassigned to the New Tax Group Code for all eligible records.

  • Update Data Update Data – click this button to start the program.

Upon the completion of CC55, you can stay in the program and process another Tax Group or Exit the program.