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. CMC Account in SEG4 ONLY.
GLV33152ERP2 - Creates two CSV files from GL Accounts and Sub Types. Files are erpglaccts.csv and erpglsubtyp.csv. CMC Account spilts into SEG4 & SEG5 for ERP.
***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.
ARV38026ERP - Creates CSV file (dfltrmks.csv) of customer default remarks, up to 8 remarks each separated by @newlineChar. Can possibly be imported into AEROS-ERP global message table.
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 master, includes the last transaction date where product used. File is INV13011inv.csv.
INV13013ERP - Creates two CSV files from formula master files (INV1C, INV1D).
inv13070t,csv = formula masters, inv13013d.csv = formula master details.
INV13070ERP - Creates CSV file from inventory locations. Format same as spBegInventory (item, price, qty, cocd, divcd, Loc, LotNo,PeriodNo).
Division and period number need to be populated.
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.