| Inventory Transaction Data Integration
TechTonics Software Architects, Inc., has
created an auto import for Inventory Management Transactions.
This modification has been written in Cobol. This program
will read a text file and populate the fields on the screen
with what is in the text file. If a field is left blank in
the text file, the program will use the standard Macola default
values.
The naming convention of the text file is
as follows:
- The first two characters determine which program to run.
- 03 = Inventory Transaction
- The next six characters is the time in hhmmss format.
- The extension of the file ends in “.TSA”.
- Example: 03091435.TSA
The general flow of the import program is
as follows:
- The user creates a text file with the provided record
layout. The record layout contains the starting and ending
position of each field. It will also state if a field is
a required field or an optional field. If the field is
an optional field, the layout will also give you the default
values to use for that field.
- The user places the text file into the x:\macola\data_??
Directory.
- The TSA Polling Program will look for all files that
end in a *.TSA and will read the first two characters of
the file name and determine which program it will need
to call to do the processing.
- The TSA Inventory Transaction Auto Import program will
populate the fields on the screen with the values in the
text file. The import program will continue to use Macola’s
validation and business logic. If there is an error during
import, the import program will move the invalid record
to an error reprocessing file for a user to review the
error.
- The TSA Reprocess program gives the user the ability
to view the errors from the TSA Inventory Transaction Auto
Import program. This program allows the user to change
the data in the text file and after save the changes, the
TSA Polling Program will find the just corrected text file
and start the processing loop all over again.
TSA Polling Program – This
program can be started in the morning and left running all
day or it can be started and stopped by the user at any given
time as long as it is not processing any text files. This
program will look for the text files in the x:\macola\data_??
Directory and call the TSA Order Entry Auto Import program.
A screenshot of the TSA Polling Program is seen below:
TSA Inventory Transaction Auto Import
Program – This program will read the text
file passed from the TSA Polling Program and populate the
fields that are in the text file to do a Confirm Ship transaction.
If any errors are found during the import, the order will
be written to the Reprocessing file. The user can then
use the TSA Reprocess program to fix any errors. The order
will not be in a confirmed pick status.
TSA Reprocess Program – This
program will read all the orders that are in error and display
them on the screen so that user can select which order to
reprocess. Once the order number has been selected, another
screen will be displayed showing the detail record. The user
will have the capability to fix the field in error and save
the record.
Once the record is saved, the TSA Polling
Program will pick up the fixed text file and process the
file. Screen shots of the TSA Reprocess Program are shown
below:
|
