Introduction
This US Sales Tax Rates Upload SOP describes the process for customers who receive tax files from Iptor, on how to download and update BNA masterfiles with the relevant tax data. Each month an email from Iptor notifies customers that the newest Sales Tax Rate files have been received and are ready for deployment. The files from Iptor would come via one of the following.
- Save file (SAVF) as an email attachment to the monthly email – customer can use IFS to dump the save file into a directory before it can be updated to the BNA tax masterfiles in iSeries.
- FTP – Iptor can FTP the save file (SAVF) directly to a library from where it can be updated to the BNA tax masterfiles in iSeries. Iptor must have direct access to the customer’s iSeries.
Save file name is always BNTXIMP.
Business rules setup
The following business rules have to be setup to handle US Sales Tax Rates Upload. Business rules for US Sales Tax Rates Upload must be setup with support from Iptor IP1 consultants. It is critical to understand the setting of control files and how it works. Control files must be setup correctly for the system to operate as intended. Any changes to the control files setup should be addressed cautiously and in consultation with Iptor IP1 consultants.
| Note | This document does not cover customised setup tasks of specific companies. Deviations from this setup should be covered by setup tasks written by individual companies. |
| Control file | Setup |
| BNADS/TAX-IFS |
Type 1 = directory name Type 2 = library For email attachment delivery, nominate the IFS directory (type 1) and a temporary location (type 2) where the file is temporarily dumped by IP1 program before its updated to relevant BNA masterfiles. For FTP delivery, leave Type 1 as blank. Type 2 should be the library that Iptor will FTP the save file to. Note: This library name should always be BNATAXIMP. Do not change this library name for FTP delivery.
|
Procedure
It is your responsibility to ensure that you understand this procedure before performing the following tasks.
| Note |
Deviations from this procedure should be covered by procedures written by your company. Before performing any tasks please ensure all the business rules are set-up accordingly. |
| Process | Steps |
| Method 1 using email/IFS |
|
| Method 2 using FTP |
|
BNTXO590A
BNTXO590A is the program which controls updating the IP1 sales tax rate files. The automated upload will update the import files. It is recommended that the job be run in off-hours. The IP1 sales tax rate tables are cleared as a first step, which could affect order processing. After the import files have been updated, BNTXO590A must be run utilizing one of the following:
- From the menu option: The option “Taxation File Import” can be found on the US options menu in IP1.
- Setup a scheduled job: The program can be setup to execute as a submitted job at a specific off-hours time. This alleviates the necessity of manually getting into the iSeries after hours. This job should be setup on hold and released manually once the monthly email from Iptor has been received.
