Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

...

APV33315ERP - Create a CSV file from  (AP Aging Register) for open AP Vouchers to be used by Aeros Import Vouchers.

...

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).

...