supportseries2000.com

4/1/2009 - import spreadsheet to IETC batch.

number one, phil had to convert the excel column to literal numbers from formulas. Then he exported it to var-tmp. However the file name was unwieldy and he renamed it to xxxx.csv, this looked good but when we looked at var-tmp, the name was xxxx.csv.csv.

So I issued the following bash command in var-tmp, mv xxxx.csv.csv xxxx.csv.

Then we went to IETC, 'UT', option 3, now was able to open Will2009.csv, select a , delimiter, tell it that the cost is in field two, and away we go.

TO invoice # - enter invoice number - 'D' to see detail - commission amount, for credit memos shows original invoice number and original invoice date.

4/9 - added reason code to 'D' - format
4/29 - added disposition code and r&r order number

Menu SL4

1. LFPC option 3 - delete given period - enter as yymm
2. LFPC option 4 - rebuild given period - enter as yymm
3. LGPC set commission rate and update graduated rate schedule stats
4. LRPD Freight Reimbursement Report
5. LRPC - Commission Report

MQDF - NS - Shows all Non stock PO Line Items, and their linked work order.

KQDH - NS - Shows all non stock
KQDH - NSB - show Non Stock Buys
KQDH - Enter Job #, - '4W' - displays four wall costs.

LQDE, enter 4 digit yymm in invoice field for summary. t38472 - srl # 320372, 320373 - contract T36497 lsi

run KFDM periodically to pick up KQDH records on PO sort.

KRDB - CH - link purchase orders on closed work orders
KRDB - U - Update header fields for total
KRDB - P - Toggle - display on screen or output to printer - see toggle setting in upper right