Installing and configuring the tax integration interface

About this task

To install and configure the tax integration interface, you need to register the new commands provided by the tax integration kit to the database. If you are using third-party tax software, sales tax and shipping tax are now separated into individual commands for the Tax Integration Kit. If you need to separate sales tax and shipping tax to allow separate auditing of sales and shipping tax, you must follow these steps instead.

For a store to use the new command provided by the tax integration kit for tax calculation, you need to register the new commands, ApplyCalculationUsageCmd and TaxCalculationUsageTIKCmd, to the HCL Commerce database, by updating the CALMETHOD and STENCALUSG tables, which you do by following these steps:

Procedure

Insert a new entry for ApplyCalculationUsageCmd in the CALMETHOD table.


Column	Values
CALMETHOD_ID	The key, a unique ID that is assigned to the entry.
STOREENT_ID	-1 or the `store_ID`
CALUSAGE_ID	-3
TASKNAME	com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageTIKCmd
DESCRIPTION	This is a description of the sales tax method of the ISV.
SUBCLASS	12
NAME	ApplyCalculationUsageTIK

Use the following sample SQL statements as your guide:


DELETE FROM calmethod WHERE TASKNAME = 
  'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageTIKCmd'
  AND STOREENT_ID = store_ID AND CALUSAGE_ID = -3

INSERT INTO CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, 
  DESCRIPTION, SUBCLASS, NAME) VALUES ((select coalesce((min(calmethod_id)-1),1)
  from calmethod), store_ID , -3,
  'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageTIKCmd', 'default
  method for calculation taxes using Taxcompany', 12, 'ApplyCalculationUsageTIK')

Insert a new entry for TaxCalculationUsageTIKCmd in the CALMETHOD table.


Column	Values
CALMETHOD_ID	The key, a unique ID that is assigned to the entry.
STOREENT_ID	-1 or the `store_ID`
CALUSAGE_ID	-3
TASKNAME	com.ibm.commerce.isv.kit.tax.TaxCalculationUsageTIKCmd
DESCRIPTION	This is a description of the sales tax method of the ISV.
SUBCLASS	12
NAME	TaxCalculationUsageTIK

Use the following sample SQL statements as your guide:


DELETE FROM calmethod WHERE TASKNAME = 
  'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageTIKCmd' AND
  STOREENT_ID = store_ID AND CALUSAGE_ID = -3

INSERT INTO CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, 
  DESCRIPTION, SUBCLASS, NAME) VALUES ((select coalesce((min(calmethod_id)-1),1)
  from calmethod), store_ID, -3, 
  'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageTIKCmd', 'default
  method for setting audit flag using Taxcompany', 14, 'TaxCalculationUsageTIK')

Update the STENCALUSG table with the new CALMETHOD ID (obtained from above) for the store: update STENCALUSG set CALMETHOD_ID_APP = CALMETHOD_ID where CALUSAGE_ID = -3 and STOREENT_ID = store_ID

Use the following sample SQL statements as your guide:


UPDATE STENCALUSG SET (CALMETHOD_ID_APP, CALMETHOD_ID_FIN) = 
  ((SELECT CALMETHOD_ID FROM CALMETHOD WHERE TASKNAME =
  'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageTIKCmd' AND 
  STOREENT_ID = store_ID AND CALUSAGE_ID = -3), 
  (SELECT CALMETHOD_ID FROM CALMETHOD WHERE TASKNAME =
  'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageTIKCmd' AND STOREENT_ID = store_ID
  AND CALUSAGE_ID = -3)) WHERE CALUSAGE_ID = -3 and STOREENT_ID = store_ID

If the CMDREG contains an entry with this interface name, then remove the entry: com.ibm.commerce.taxation.commands.ApplyOrderTaxesCmd

Results

The tax software vendor also would require you to register the TaxIntegrationOrdercmd and TaxIntegrationOrderItemCmd commands in the CMDREG table. Refer to the tax software vendor's documentation for details.

Use the following sample SQL statements as your guide:


DELETE FROM cmdreg WHERE storeent_id = store_ID
  AND interfacename = 'com.ibm.commerce.isv.kit.tax.TaxIntegrationOrderCmd' AND 
  classname = 'com.taxcompany.utl.TaxcompanyOrderCmdImpl'

INSERT INTO cmdreg (storeent_id, interfacename, description, classname, 
  properties, target) VALUES (store_ID,
  'com.ibm.commerce.isv.kit.tax.TaxIntegrationOrderCmd', 
  'Taxcompany Tax Integration Kit implementation', 
  'com.taxcompany.utl.TaxcompanyOrderCmdImpl', null, 'Local')

DELETE FROM cmdreg WHERE storeent_id = store_ID 
  AND interfacename = 'com.ibm.commerce.isv.kit.tax.TaxIntegrationOrderItemCmd' AND 
  classname = 'com.taxcompany.utl.TaxcompanyOrderItemCmdImpl'

INSERT INTO cmdreg (storeent_id, interfacename, description, classname, 
  properties, target) VALUES (store_ID, 
 'com.ibm.commerce.isv.kit.tax.TaxIntegrationOrderItemCmd', 
 'Taxaware Tax Integration Kit implementation', 
 'com.taxcompany.utl.TaxcompanyOrderItemCmdImpl', null, 'Local')

Note: Use 0 (site) or store_ID.

Steps for separate sales tax and shipping tax when using third-party tax software

Sales tax and shipping tax can be separated into individual commands for the Tax Integration Kit (third-party tax software). This separation allows individual auditing of sales tax and shipping tax.

Complete the following steps to audit sales and shipping tax separately:

Add the following SQL statement to update the CMDREG table:


db2 insert into CMDREG (STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET) 
values (0,'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageSalesTaxTIKCmd','Sales Tax calculation usage for third-party tax 
providers','com.ibm.commerce.isv.kit.tax.TaxCalculationUsageSalesTaxTIKCmdImpl',null,null,'Local') 

db2 insert into CMDREG (STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET) values 
(0,'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageShippingTaxTIKCmd','Shipping Tax calculation usage for third-party tax 
providers','com.ibm.commerce.isv.kit.tax.TaxCalculationUsageShippingTaxTIKCmdImpl',null,null,'Local')


db2 insert into CMDREG (STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET) values
(0,'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageSalesTaxTIKCmd','Apply Sales Tax calculation usage for third-party tax 
providers','com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageSalesTaxTIKCmdImpl',null,null,'Local'); 

db2 insert into CMDREG (STOREENT_ID, INTERFACENAME, DESCRIPTION, CLASSNAME, PROPERTIES, LASTUPDATE, TARGET) values 
(0,'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageShippingTaxTIKCmd','Apply Shipping Tax calculation usage for third-party tax 
providers','com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageShippingTaxTIKCmdImpl',null,null,'Local');

Add the following SQL statement to update the CALMETHOD table:


db2 insert into CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, DESCRIPTION, SUBCLASS, NAME) VALUES 
((select coalesce((min(calmethod_id)-1),1) from calmethod), store_ID, -3, 
'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageSalesTaxTIKCmd', 'default method for setting audit flag for sales 
tax using third-party tax software', 12, 'TaxCalculationUsageSalesTaxTIK') 

db2 insert into CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, DESCRIPTION, SUBCLASS, NAME) VALUES 
((select coalesce((min(calmethod_id)-1),1) from calmethod), store_ID, -4, 
'com.ibm.commerce.isv.kit.tax.TaxCalculationUsageShippingTaxTIKCmd', 'default method for setting audit flag for 
shipping using third-party tax software', 12, 'TaxCalculationUsageShippingTaxTIK') 

insert into CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, DESCRIPTION, SUBCLASS, NAME) VALUES 
((select coalesce((min(calmethod_id)-1),1) from calmethod), store_ID, -3, 
'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageSalesTaxTIKCmd', 'applies calculation usage sales tax', 12, 'ApplyCalculationUsageSalesTaxTIK') 

insert into CALMETHOD (CALMETHOD_ID, STOREENT_ID, CALUSAGE_ID, TASKNAME, DESCRIPTION, SUBCLASS, NAME) VALUES 
((select coalesce((min(calmethod_id)-1),1) from calmethod), store_ID, -4, 
'com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageShippingTaxTIKCmd', 'applies calculation usage shipping tax', 12, 'ApplyCalculationUsageShippingTaxTIK')

where store_ID is the store or store group ID.

Refresh the Calculation registry and Command registry from the Administration Console.
Set the STENCALUSG.CALMETHOD_ID_FIN column. The STENCALUSG table must be updated so that TaxCalculationUsageSalesTaxTIKCmd and TaxCalculationUsageShippingTaxTIKCmd are called for your store.
Query the CALMETHOD table to find the CALMETHOD_ID values for com.ibm.commerce.isv.kit.tax.TaxCalculationUsageSalesTaxTIKCmd and com.ibm.commerce.isv.kit.tax.TaxCalculationUsageShippingTaxTIKCmd. Using those values, update the STENCALUSG table so that CALMETHOD_ID_FIN for shipping and sales is called. Use the following SQL statements to update the STENCALUSG table:
Also when updating STENCALUSG the CALMETHOD_ID_APP field should be updated NOT the CALMETHOD_ID_FIN column
To update STENCALUSG
```
set CALMETHOD_ID_FIN=calmethod_ID_1 where STOREENT_ID=store_ID and CALUSAGE_ID=calusage_ID_1
 
```
To update STENCALUSG
```
set CALMETHOD_ID_FIN=calmethod_ID_2 where STOREENT_ID=store_ID and CALUSAGE_ID=calusage_ID_2, where calmethod_ID_1 is the CALMETHOD_ID for TaxCalculationUsageSalesTaxTIKCmd, 
calmethod_ID_2 is the CALMETHOD_ID for TaxCalculationUsageShippingTaxTIKCmd, store_ID is the store or store group ID, calusage_ID_1 is the calculation usage 
ID for sales tax (-3), and calusage_ID_2 is the calculation usage value for shipping tax (-4). 
 
```

Set the STENCALUSG.CALMETHOD_ID_APP column. The STENCALUSG table must be updated so that ApplyCalculationUsageSalesTaxTIKCmd and ApplyCalculationUsageShippingTaxTIKCmd are called for your store.
Query the CALMETHOD table to find the CALMETHOD_ID values for com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageSalesTaxTIKCmd and com.ibm.commerce.isv.kit.tax.ApplyCalculationUsageShippingTaxTIKCmd. Using those values, update the STENCALUSG table so that CALMETHOD_ID_FIN for shipping and sales is called. Use the following SQL statements to update the STENCALUSG table:

To update STENCALUSG for sales tax:

set CALMETHOD_ID_FIN=calmethod_ID_3 where STOREENT_ID=store_ID and CALUSAGE_ID=calusage_ID_3

To update STENCALUSG for shipping tax

set CALMETHOD_ID_FIN=calmethod_ID_4 where STOREENT_ID=store_ID and CALUSAGE_ID=calusage_ID_4,
calmethod_ID_3 is the CALMETHOD_ID for ApplyCalculationUsageSalesTaxTIKCmd,
calmethod_ID_4 is the CALMETHOD_ID for ApplyCalculationUsageShippingTaxTIKCmd,

Where:

store_ID: Is the store or store group ID,
calusage_ID_3: Is the calculation usage ID for sales tax (-3),
calusage_ID_4: Is the calculation usage value for shipping tax (-4).

The tax software vendor also requires you to register the TaxIntegrationOrderCmd and TaxIntegrationOrderItemCmd commands in the CMDREG table. Refer to the tax software vendor's documentation for details.