Documentation >
MAC-PAC Reference Library >
Manufacturing >
Inventory Control >
Reports >
Inventory Control Transaction Register Reports
Inventory Control Transaction Register Reports
IC510
DATE 3/05/93 STEVENS ART SUPPLY PAGE 1
TIME 18:01:20 CO
REPORT IC-510 WHS
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
FUNC LOT ORDER LOT LOT FIFO EXPIRA TRANS ----------- ERROR -----------
CODE NO PART NUMBER NO QUANTITY DATE DATE VENDOR LOT NUMBER DATE CODE MESSAGE
--- ------------ --------------- ------- ---------- ------ ------ -------------------- ------ ----- -------------------------
LA2 000000000900 JITPART 0 000000 000000 030493
LA2 LOT33 HY-PEROXIDE ORD0333 0 000000 000000 030593
LA2 PATLOT000010 JITTST1 0 000000 000000 030593
LA1 V492EST CHEMICAL ABC ORDER305 0 000000 000000 030593
DATE 3/05/93 STEVENS ART SUPPLY PAGE 2
TIME 18:01:20 CO
REPORT IC-510 WHS
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
****************************************
* *
* REFERENCE TOTAL *
* *
* TRANSACTIONS READ 4 *
* *
****************************************
** END OF REPORT **
DATE 3/05/93 STEVENS ART SUPPLY PAGE 1
TIME 18:01:20 DISTRIBUTION WAREHOUSE WAS CO 002
REPORT IC-510 WHS DW2
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS ----------- ERROR -----------
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE CODE MESSAGE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------ ----- -------------------------
G26 C J 030493 KELLY JONES 030493
KELLY JONES
FUNC TRANS ADJ STOCK B RVL TRANSACTION NEW UNIT COST/ LOT NUMBER/
CODE PART NUMBER QUANTITY UM CDE LOC T CDE DESCRIPTION CHANGE IN VALUE TRANS DATE
--- --------------- ------------ -- -- ------- - - --------------- --------------- ------------
D15 CANDY 10000 EA PA NOPRLOC D
030593
D15 BASEBALL 10000 EA PA NOPRLOC D
030593
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------
G25 007690 00 C 030593
FUNC ORDER REL LIN L REL DUE PLN VENDOR PO PO S TRANS
CODE NO NO NO PART NUMBER S QUANTITY UM CODE DATE CDE NUMBER NUMBER LIN T DATE
--- ------ -- --- --------------- - ---------- -- - ------ - -------- ------- --- - ------
F35 007690 00 001 BOLT-100 O 100.000 EA D 030593 P W 030593
F35 007690 00 002 CANDY O 100.000 EA D 030593 P W 030593
W0125 G/M exceeds upper limit
F35 007690 00 003 BASEBALL O 200.000 EA D 030593 P W 030593
W0123 Cost equals zero
W0125 G/M exceeds upper limit
G40 007690 00 001 BOLT-100 C W 030593
G40 007690 00 002 CANDY C W 030593
G40 007690 00 003 BASEBALL C W 030593
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------
G25 007691 00 C 030593
****************************************
* *
* REFERENCE TOTAL *
* *
* TRANSACTIONS READ 11 *
* *
****************************************
** END OF REPORT **
DATE 3/05/93 STEVENS ART SUPPLY PAGE 47
TIME 18:01:20 BELGIUM MANUFACTURING WHS. CO 001
REPORT IC-510 WHS BEL
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
FUNC ORDER REL LIN L REL DUE PLN VENDOR PO PO S TRANS ----------- ERROR -----------
CODE NO NO NO PART NUMBER S QUANTITY UM CODE DATE CDE NUMBER NUMBER LIN T DATE CODE MESSAGE
--- ------ -- --- --------------- - ---------- -- - ------ - -------- ------- --- - ------ -------------------------------
F35 007737 00 001 GLASS O 25.000 EA M 030993 P W 030593
W0125 G/M exceeds upper limit
F40 007737 00 001 GLASS W 030593
FUNC ORDER REL LIN STOCK B R DOC DOCUMENT ADJ LOT TRANS
CODE NO NO NO PART NUMBER QUANTITY UM LOC T C TYPE NUMBER CDE NO DATE
--- ------ -- --- --------------- ---------- -- ------- - - ---- -------- --- ------------ ------
S15 007737 00 001 GLASS 25.000 EA NOPRLOC H IN 10000807 00 030593
W0064 Location bal is negative
W0123 Cost equals zero
W0125 G/M exceeds upper limit
W0126 Price manually entered
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------
F25 007737 00 C C 030593 AC-FRANCE N 030593
AC-FRANCE
FUNC ORDER REL LIN L REL DUE PLN VENDOR PO PO S TRANS
CODE NO NO NO PART NUMBER S QUANTITY UM CODE DATE CDE NUMBER NUMBER LIN T DATE
--- ------ -- --- --------------- - ---------- -- - ------ - -------- ------- --- - ------
F40 007737 00 001 GLASS C 25.000 M 030593 P W 030593
****************************************
* *
* REFERENCE TOTAL *
* *
* TRANSACTIONS READ 5 *
* *
****************************************
** END OF REPORT **
DATE 3/05/93 STEVENS ART SUPPLY PAGE 1
TIME 18:01:20 RUE DE GRAND CHIEN 1 CO 001
REPORT IC-510 WHS DW2
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
FUNC LOC PFRD ABC CONTROL MANUAL COUNT COUNT TOLERANCE TOLERANCE ----------- ERROR -----------
CODE PART NUMBER CTL LOC CLS GRP SELECT INTERVAL DATE PERCENT VALUE CODE MESSAGE
---- --------------- - ------- - - - --- ------ ----- -------------- -------------------------
T05 A N A N N 030493 030493
FUNC LEADTIME/ MIN/MAX REORDER PT/ MINIMUM PRIMARY REPL/D-S TRANS
CODE PART NUMBER SAFETY QTY STK LVL QTY TARGET QTY ORDER QTY STK LOC L/T A DATE
---- --------------- ------------ ------------ ------------ ---------- ------- ------ ------
T10 A 030493
- ANL CDE/ BYR CDE/ PO/ PK/SH PK/SH
IR CD SB CD I/V CODE QUANTITY FREIGHT RATING CODE
--- --- - -- ---------- -------------------
ETC-9093882
FUNC UNIT PRICE/ MVG AVG UNIT COST/ LIFO UNIT COST/ TRANS
CODE PART NUMBER STD UNIT COST LAST PURCH REPL COST TRANSFER PRICE LP DATE
---- --------------- ---------------- -------------------- ---------------- -- ------
T15 A 030493
VAT T P C ALLOW PR PRICE/SKU MIN/MAX
CDE X C D REM SRC UM NUM/DEN GROSS MGN %
--- - - - - -- ------- -----------
1 Y
QTY BREAK 1/ QTY BREAK 2/ QTY BREAK 3/ QTY BREAK 4/ QTY BREAK 5/
PRICE OR DISC PRICE OR DISC PRICE OR DISC PRICE OR DISC PRICE OR DISC
---------------- ---------------- ---------------- ---------------- ----------------
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------
F20 007709 00 O C D 030593 J1 N N 030593
J1
FUNC ORDER REL LIN L REL DUE PLN VENDOR PO PO S TRANS
CODE NO NO NO PART NUMBER S QUANTITY UM CODE DATE CDE NUMBER NUMBER LIN T DATE
--- ------ -- --- --------------- - ---------- -- - ------ - -------- ------- --- - ------
F35 007709 00 001 CANDY O 3.000 EA D 030793 P W 030593
W0125 G/M exceeds upper limit
DATE 3/05/93 STEVENS ART SUPPLY PAGE 1
TIME 18:01:20 SOMMER ALLIBERT CO 001
REPORT IC-510 WHS SOM
INVENTORY CONTROL TRANSACTION REGISTER
REFERENCE NUMBER V80
FUNC TRANS ADJ STOCK B RVL TRANSACTION NEW UNIT COST/ LOT NUMBER/ ----------- ERROR -----------
CODE PART NUMBER QUANTITY UM CDE LOC T CDE DESCRIPTION CHANGE IN VALUE TRANS DATE CODE MESSAGE
--- --------------- ------------ -- -- ------- - - --------------- --------------- ------------ ----- -------------------------
D15 CANDY 100000 EA PA NOSRCLC D
030593
D15 BASEBALL 1000000 EA PA NOSRCLC D
030593
FUNC ORDER REL O O ANL REL HOLD ORDER BILL-TO/ CONFIG DIR TRANS
CODE NO NO S T CDE CDE CODE DATE SHIP-TO CUSTOMER REFERENCE ORDER DST DATE
--- ------ -- - - --- - - ------ ----------- ------------------------- - - ------
G25 007698 00 C 030593
FUNC ORDER REL LIN L REL DUE PLN VENDOR PO PO S TRANS
CODE NO NO NO PART NUMBER S QUANTITY UM CODE DATE CDE NUMBER NUMBER LIN T DATE
--- ------ -- --- --------------- - ---------- -- - ------ - -------- ------- --- - ------
F35 007698 00 001 BOLT-100 O 10.000 EA D 030593 P W 030593
F35 007698 00 002 CANDY O 10.000 EA D 030593 P W 030593
W0125 G/M exceeds upper limit
F35 007698 00 003 BASEBALL O 20.000 EA D 030593 P W 030593
W0123 Cost equals zero
W0125 G/M exceeds upper limit
G40 007698 00 001 BOLT-100 C W 030593
W0123 Cost equals zero
W0125 G/M exceeds upper limit
G40 007698 00 002 CANDY C W 030593
W0123 Cost equals zero
W0125 G/M exceeds upper limit
G40 007698 00 003 BASEBALL C W 030593
W0123 Cost equals zero
W0125 G/M exceeds upper limit
FUNC UNIT PRICE/ MVG AVG UNIT COST/ LIFO UNIT COST/ TRANS
CODE PART NUMBER STD UNIT COST LAST PURCH REPL COST TRANSFER PRICE LP DATE
---- --------------- ---------------- -------------------- ---------------- -- ------
T30 CANDY 030593
VAT T P C ALLOW PR PU/SKU MIN/MAX
CDE X C D REM SRC UM NUM/DEN GROSS MGN %
--- - - - - -- ------- -----------
V1 1 Y
QTY BREAK 1/ QTY BREAK 2/ QTY BREAK 3/ QTY BREAK 4/ QTY BREAK 5/
PRICE OR DISC PRICE OR DISC PRICE OR DISC PRICE OR DISC PRICE OR DISC
---------------- ---------------- ---------------- ---------------- ----------------
|
Purpose
The Inventory Control Transaction Register lists all transactions submitted since the last execution of this program. The report consists of various heading breaks, which are printed according to function code and determined by the reference number. Error codes and messages are printed for all transactions that were not posted. Warning messages associated with valid transactions that were posted are also printed. The Inventory Control Transaction Register print option on the System Control File is used to specify whether to print all or only invalid transactions. Certain transactions are listed in relation to the transactions of which they are a part. For example, component requirements transactions are listed in relation to the corresponding manufacturing order.
Report Sequence
Reference Number, Date/Time Entered, internal report sequence (for example, manufacturing order header; manufacturing order line), Date/Time Posted.
The function codes that appear on the report are defined as follows:
A20 - Manufacturing Order - Add
A25 - Manufacturing Order - Change
A96 - Generate Labor Requirements
A97 - Manufacturing Order Dates Change
A98 - Post Labor Requirements (on M.O. Record)
A99 - Generate Labor Requirements (on M.O. Record)
C20 - Component Requirements - Add
C25 - Component Requirements - Change
D15 - Shipment/Return/Adjustment - Update
D20 - Purchase Order Receipts
D22 - Purchase Order Receipts (Phantom Order)
D30 - Stock Transfer - To
D31 - Stock Transfer - From
D50 - Cycle Count Adjustment
E20 - Manufacturing Order - Reopen
E30 - Manufacturing Order Receipts
E35 - Component Issue (not thru SIR processing)
E37 - Component Issue (thru SIR processing)
E40 - Manufacturing Order - Close
E45 - Manufacturing Order - Cancel/Delete
F20 - Customer Order Header - Add
F21 - Open Item - Add
F25 - Customer Order Header - Change
F35 - Customer Order Line - Add
F40 - Customer Order Line - Change
G25 - Customer Order Header - Close
G26 - Open Item - Close
G40 - Customer Order Detail - Delete
G45 - Customer Order Comment - Add
G50 - Customer Order Comment - Change
G55 - Customer Order Comment - Cancel
H10 - Quote Order - Add
H15 - Quote Order - Change
H20 - Quote Order - Close
H25 - Quote Order Detail - Add
H30 - Quote Order Detail - Change
H35 - Quote Order Detail - Close
H40 - Quote Order Header - Add
H45 - Quote Order Header - Change
H50 - Quote Order Header - Close
H55 - Quote Order Reason - Change
H60 - Quote Order Line Reason - Change
H65 - Quote Order Header - Reopen
H70 - Quote Order Detail - Reopen
J40 - Flow Receipts
J45 - Backflush Issue
J50 - Lot Issue
J55 - Deduct Issue
J60 - Unplanned Usage Issue
J65 - Point of Use Transfer - From
J70 - Point of Use Transfer - To
L20 - Add Labor Requirements
L30 - Change Labor Requirements
L31 - Activate Alternate Labor Requirements
L32 - Open Labor Requirements
L33 - Close Labor Requirements
L35 - Delete Labor Requirements
LA1 - Lot Control - Add (Purchase Order)
LA2 - Lot Control - Add (Manufacturing Order)
LC1 - Lot Control - Change
LD1 - Lot Control - Close
LR1 - Lot Control - Reopen
OR1 - Order Release (Manufacturing Order)
OR2 - Order Release (Component Order)
P05 - Purchase Order Vendor - Add
P10 - Purchase Order Vendor - Change
P15 - Purchase Order Vendor - Open
P20 - Purchase Order Vendor - Reopen
P25 - Purchase Order Vendor - Close
P30 - Purchase Order Header - Add
P35 - Purchase Order Header - Change
P40 - Purchase Order Header - Close
P45 - Purchase Order Header - Reopen
P50 - Purchase Order Detail - Add
P55 - Purchase Order Detail - Change
P60 - Purchase Order Detail - Cancel
P65 - Purchase Order Comment - Add
P70 - Purchase Order Comment - Change
P75 - Purchase Order Comment - Cancel
S15 - Customer Order Shipment/Return
T05 - Warehouse Balance Cycle Count - Add
T10 - Warehouse Balance Description - Add
T15 - Warehouse Balance Sales - Add
T20 - Warehouse Balance Cycle Count - Change
T25 - Warehouse Balance Description - Change
T30 - Warehouse Balance Sales - Change
T40 - Warehouse Balance - Reactivate
T50 - Warehouse Balance - Delete