MAC-PAC Homecontact ussupport login 
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