VMIIMP VMI/CMI Import of Delivery data

 

This procedure handles different import formats for a restricted number of TRADE data fields i.e. those that are mandatory to complete a Sale Call-off from existing TRADE  records. The VMI Name, its' format and descriptors are maintained in S01/Import parameters with their friendly column names.  The 11 fields currently enabled can be extended by a software change, if essential. The friendly names must match the import file column names.

 

 

VMIIMP will prompt the user for the Import Style to be used. The selected import file is checked for its' heading columns to be consistent with the S01 Import Style contents. The data is processed as automated Sale call-offs i.e. validation of import Sale Trade Ref and their allocated Stock TRADE record. 

Failure of a import row is listed on the log. Successful imports will list the ITAS Sale reference, the Inventory TRADE reference and the accounting document.