Tino Di Natali - Development - JDE
International Consultant for International Projects
Development of JDE-Related Programs
Trade Counter Backup (TCB)
We all know how sensitive networks are, especially to remote locations.
The idea is to pull a backup file of the stock from the server on a daily
base and email this file to the remote location.
This program does not consider ongoing sales as the data is static..
The program allows for search by item number and shows on-hand, availability in the primary unit of measure for up to 6 different locations.
The data is extracted from JDE using simple a simple SQL:
SELECT imaitm, imdsc1, imdsc2, imuom1, lilocn, lipqoh, (lipqoh - lihcom -
lipcom - lifcom) liaval
The result (pipe-separated) is then loaded as a flat file and
off you go.