Province / State Maintenance GB1300

The Province / State Maintenance program is used to establish codes for Provinces / States and to define the provincial or state rate of taxation. The user may also assign a General Ledger account to which province or state taxes payable will be posted. In addition, the system will update a field which shows total sales to that state or province, as well as sales tax in dollars.

Where Used: Global File Maintenance (GB0100) Customer File Maintenance (GB0900) Prospective Customer File Maintenance Program (GB4700) Vendor File Maintenance (GB1000) Sales Reporting (SA 3700) Price File Maintenance (OE1700)

Province / State

Enter a Province/State code and press return. System will prompt for another code to be entered or for use of query mode, if record already exists.

Province Name

Enter the Province / State name and press return.

Country

Enter the name of the country for this province / state and press return.

Sales Tax Registration

Enter the sales tax registration he state / province. This value will print on Order Entry invoice for all shipments made to this province.

Tax Description

Enter a tax description for the state / province, e.g. PST, HST.

Tax Percent 1

Enter the provincial / state tax rate applicable.

Tax Percent 2

If province/state has a two tier tax system, the second tax rate applicable is entered here.

In most situations only the first tax rate is applicable but some jurisdictions have 2 sales tax rates. For example, in some states/provinces certain items are taxed at 7% while others are taxed at 5%. In this case Tax Percent 1 is 7% and Tax Percent 2 is 5%. In the Stock Maintenance the Ordering State/Province Tax flag and the Purchasing State/Province Tax flag of 1, 2 or blank for exempt will determine the tax rate for that particular product/warehouse combination.

Provincial Tax After State Tax

Checked if provincial / state tax is to be charged on State Tax. Leave unchecked if provincial / state tax is not to be charged on State Tax.

Provincial Tax On Freight

Checked if provincial/state tax is to be on freight. Leave unchecked if no provincial/state tax is to be charged on freight.

State Tax On Freight

Checked to include State Tax on freight in tax calculation. Leave unchecked if no State Tax is to be charged on freight.

Treat As Federal Tax

Checked to treat provincial tax as federal tax. This should be used in provinces/states where provincial taxes are remitted to the federal government such as provinces with HST (Harmonized Sales Tax). Leave unchecked to treat provincial tax normally.

Ecology Fee Charge Type

Valid values are Amount or Percent.

Ecology Rate 1

Enter rate here.

Ecology Rate 2

Enter rate here.

Ecology Rate 3

Enter rate here.

Bottle Deposit Amount 1

Enter rate here.

Bottle Deposit Amount 2

Enter rate here.

Bottle Deposit Amount 3

Enter rate here.

 

Branch

Enter a General Ledger branch number.  The provincial/state tax for this branch and province/state will be posted to the corresponding tax account specified on the next field.

General Ledger Account

Enter the applicable General Ledger account number to which you wish to post the provincial/state tax.  This account will override the provincial/state tax account set up in the currency table.  The only time that the account setup in the currency table is used is if this account is left empty.

Eco Tax General Ledger Account

Enter the applicable General Ledger account number to which you wish to post the eco tax. 

Deposit Amount General Ledger Account

Enter the applicable General Ledger account number to which you wish to post the deposit amount.