Manufacturing System Notes

M-SET ? CGI-BIN ezfunction REG-00
M-MAKE ? CGI-BIN field REG-00
M-QWE CGI STRING text to show REG-00 new screen? REG-00
M-SET ? CGI-BIN RECIPES

Bar Codes in PDF forms

http://www.bangboompow.com/xml/barcode/
http://barcode4j.krysalis.org/
http://www.ci-inc.com/documentconnection/ablelabel/product-labels.htm

Inspection Types

Type	Attribute	Inspection
A Range	Yes	A, B, E
B Number	Yes	B (must match perfectly), E
C Text	Yes	C (no check), E
D Date	Yes	Cannot be inspected
E Pass/Fail	No
F Product Code	Yes	E
G Look Up List	Yes	E, G

Inventory Simulation

START INVN SIMULATION - used at beginning of sort - DEL MPV's the CONSOLIDATED DOC SORT FILE and INVN PPO DEF SORT FILE
START INVN SIMULATION FOR REPORT - used at beginning of sort for report - also sets a flag so that the inventory inquiry does not re-sort the consolidated documents.

SORT INVN SIMULATION - must set the INVN NUMBER before calling this program. It fills the CONSOLIDATED DOC SORT FILE and INVN PPO DEF SORT FILE. Option to drill through INVN PPO DEF FILE to get all items that use this product.

FINISH INVN SIMULATION - Restores the open docs flags and also resets the flag to re-run simulation in INVN INQ.

For consolidated documents, there is a IGNORE WO CREATE REF field that if you have a WO CREATE REF in this field, it will ignore that document when figuring the date and quantity for the INVN PPO DEF SORT FILE. This is used in the Planned Work Orders to figure the date that a product is needed.

Lot Traceability

ADD TO RAW LOT ARRAY - used on WO EXT PROC FILE and MFG PRODUCTION FILE

C FILE Ram File (REF = (C ONE)~(C TWO)
C ONE= Ref to WO RAW FILE
C TWO= Lot Number
C THREE= Quantity
C FOUR = Heat
C FIVE = MFG LOT
C SIX = Country of Origin
C SEVEN = Melting Country
C8 = Mfg Name

Work Order Utilities

SET WO INVN CODE (for scroll boxes)
SET WO INVN INFO (sets WO INVN CODE and WO INVN DESC)

GET WO CREATE FACTORS

D FILE ram - ref=(WO CREATE REF)(SCHED DTL NUMBER)
D ONE - % of SCHED DTL overhead costs to assign to this WO CREATE (based on actual quantity made)
D TWO - SCHED DTL NUMBER
D THREE - Total (PMQ Method) to make
D FOUR - % of SCHED DTL overhead costs to assign to this WO CREATE (based on quantity to make)
D FIVE - Total (PMQ Method) made

E FILE ram - ref = SCHED DTL NUMBER
E001 - Total to make for process
E002 - Total made in process
E003 - Total to receive in process

GET WO RAW FACTORS 2

D FILE ram - ref=(WO CREATE REF)(WO RAW REF)
D ONE - Theoretical Quantity Used (SQ METHOD of RAW)
D THREE - % of raw material cost to assign to WO CREATE (based on quantity received and factors)
D FIVE - WO RAW REF

E FILE ram - ref=(WO RAW REF)
E001- Total Qty Used (SQ METHOD of Raw Code)
E002 - Total BO Qty (SQ METHOD of Raw Code

 

GET WO RAW FACTORS (NOT USED ANYMORE!!!!!)

D FILE ram - ref=(WO CREATE REF)(WO RAW REF)
D ONE - Quantity Received (SQ METHOD of RAW)
D TWO - Qty Backordered
D THREE - % of raw material cost to assign to WO CREATE (based on actual quantity)
D FOUR - % of raw material back ordered per WO CREATE (based on actual quantity)
D FIVE - WO RAW REF

E FILE ram - ref=(WO RAW REF)
E001- Total Qty Received (SQ METHOD of Raw Code)
E002 - Total BO Qty (SQ METHOD of Raw Code

General Utilities

PAD CHAR - combines BS, IC and an option to pack the field.

General Ledger Programs

UPDATE INVN ADJ - used when updating TOTAL COST - records the transaction in/out in INVN ADJ FILE.

UPDATE TRACKING I HIST - used when adjusting a record in INVN TRACKING AVAIL FILE. need to use logic similar to this (to set all the fields).

25 COPY T QTY to PO T QTY
26 COPY T COST EXTENSION to PO T COST EXTENSION
27 COPY T BAR CODE NUMBER to PO T BAR CODE NUMBER
28 COPY PPO LOC to PO T LOC
29 COPY PPO LOT to PO T LOT
30 COPY AVAIL TO ADJ
31 JOIN STRINGS "PPO# " and PO # result in ADJ COMMENT
32 PACK DATE mm-dd-yy PO DATE REC into I HIST DATE
33 COPY TB DESC to INVN MAN ADJ DESC
34 UPDATE TRACKING I HIST a=man adj, b=auto adj, e=proc po "E"

UPDATE SCHED WIP DTL - used when updating the overhead values in the SCHED DTL FILE (SCHED DTL OH CURRENT VALUE).

UPDATE INVN WIP DTL - used when updating the INVN WIP TOTAL VALUE - includes Overhead and direct materials (all sched dtl records added SCHED DTL OH CURRENT VALUE and SCHED DTL DM CURRENT VALUE).

UPDATE INVN WIP TRACKING - INCR - where records are moved from the INVN TRACKING AVAIL file when production is posted and the raw material is consumed. Only used for tracked records in Inventory. This is a temporary holding file of the lots for when they are actually part of WIP. Once the final product is finished, the lots will be removed from this file.

UPDATE INVN WIP TRACKING - DCR - moving records out of the INVN WIP TRACKING FILE when the product manufacturing is complete. Values will move from the INVN WIP # to the INVN ASSET #.