CMC Programs that create Template Data

Owned by Charles Torres
Last updated: Jun 16, 2016
2 min read

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, Customer Order Templates 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.

ARV35002ERP - Create a CSV files from AR Customers Standard Orders. Filename is ARV35002H.CSV, ARV35002C.csv.

***Note: ARV30055 needs to be compliled and is needed from /inc/qnd/erp directory.

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  (AP Aging Register) for 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.