CMC Template Programs in /inc/qnd/erp folder on LINUX Server

GL Accounts

GLV33152ERP - Creates two CSV files from GL Accounts and Sub Types. Files are erpglaccts.csv and erpglsubtyp.csv. 

                           ***When erpglsubtyp is loaded into Excel duplicates need to be removed.***

AR Customer and Products

ARV35022ERP - Create a CSV files from AR Customers. Filename is ARV35022.csv.

ARV35080ERP - Create a CSV file from AR customers for routing (route/stop/day/customer number). Filename is ARV35080rt.csv.

ARV35006ERP - Creates two CSV files from AR Products. Files are ARV35006item.csv and ARV35006misc.csv.

ARV38500ERP - Creates two CSV files from AR products AND includes the last invoice/ shipper date where product used. Files are ARV38500item.csv and ARV38500misc.csv.

AP Vendors and Vouchers

APV33212ERP - Create a CSV file from AP Vendors. Filename is apv3vend.csv.

APV33315ERP - Create a CSV file from open AP Vouchers to be used by Aeros Import Vouchers.

                           Filename is apv33315eXX.csv. (XX=Company Number)

Inventory Products

INV130111ERP - Creates a CSV file from Inventory product aster AND included the last transaction date where product used. File is INV13011inv.csv.

Purchase Order Products

POS23010ERP - Creates a CSV file from PO product master AND includes the last PO due date where product used. File is POS23010pos.csv.