Enter the SQLSYSSETTING.EXE located within the manexSQL root directory.

Enter password when prompted.

Select General Setup > Sales Tax Authority Table from the menu. 

 


The following screen will be displayed:



Depress the "Foreign Tax" tab on the right-hand side of the screen:
 

To modify this screen, click on the add, edit, or delete button and supply the password, and this will enable the screen.

Pressing the add button will enable the data entry boxes at the bottom of the screen for the user to enter new data.

Selecting an existing tax ID and pressing the edit button will bring the selected information to the data entry box to be modified.

Selecting an existing tax ID and pressing the delete button will remove the selected information.

The user selects the tax type from the pull-down menu, enters in the tax ID, description, rate, the GL liability account and the GL asset account. Pressing on the down-arrow keys will display the GL account numbers. 
If the user is using the accounting module. Keep in mind the following:


  • If you select "Primary" tax type, this tax will be calculated first, and the calculation will be based on what the user checks for primary tax to include product totals, and/or freight totals. 
  • If user selects "Secondary" tax type, this tax will be calculated after primary tax, and the calculation will be based on what boxes are checked, product totals, and/or freight totals, and/or primary tax totals.  
  • If user checks "Primary Tax Totals," the tax calculated will be based on only the "Primary Tax Total."   

The user must save or abandon changes when finished adding or editing the screen.  


For examples, see the attached files below:


File IconCanadian province vats.xls

File IconForeign_Tax_Examples(1).xlsx 



Where Used: In customer setup, sales orders, packing lists, invoicing, purchase setup, receiving and billing information, and accounting.