MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Reports > Inventory Control Audit Trail Reports

Inventory Control Audit Trail Reports

IC500

 


 

DATE    3/04/93                              STEVENS SUPPLY                                                              PAGE      1

TIME    8:14:31                                                                                                          CO

REPORT IC-500                                                                                                            WHS

                                                    LOT CONTROL FILE MAINTENANCE

                                                            AUDIT TRAIL

     REF       FUNC   LOT                        L  ORDER      LOT    LOT FIFO   EXPIR                         OPEN           POST

FUNC  NO  MODE CODE   NO         PART NUMBER     S   NO      QUANTITY   DATE     DATE   VENDOR LOT NUMBER      DATE           DATE

---- ---- ---  ---  ------------ --------------- - ------- ---------- -------- -------- -------------------- --------       --------

ADD  V80  OLU  LA2  LOT0000001   ASPIRIN         O *******       .000  0/00/00  0/00/00                       3/03/93        3/03/93

                                                                             **  END OF REPORT  **

DATE    3/04/93                              STEVENS SUPPLY                                                              PAGE      1

TIME    8:14:31                                   CANADIAN WAREHOUSE -GST                                                CO     001

REPORT IC-500                                                                                                            WHS    CAN

                                                      QUOTE FILE MAINTENANCE

                                                            AUDIT TRAIL

     REF       FUNC   QUOTE   O  O  B  REL  HOLD  ORDER     BILL-TO/       ORDER  RSN                                         POST

FUNC  NO  MODE CODE     NO    S  T  A  CODE CODE  DATE      SHIP-TO         NO    CDE                                         DATE

---- ---- ---  ---   --- --   -  -  -   -    -   --------  -----------    ------  ---                                       --------

ADD  V80  OLU  H40   000601   O  Q      D         3/03/93  PJGCAN00001                                                       3/03/93

                                                           PJGCAN00001

     REF       FUNC   QUOTE  LIN                   L                 REL   DUE    PLN SELLING SELLING RSN

FUNC  NO  MODE CODE     NO   NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS   CDE

---- ---- ---  ---   ------  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   ---

ADD  V80  OLU  H25   000601  001  BOLT-200         O      10.000  EA  D   3/03/93  P    001     CAN

ADD  V80  OLU  H25   000601  002  BOLT-100         O      10.000  EA  D   3/03/93  P    001     CAN

FROM V80  OLU  H30   000601  002  BOLT-100         O      10.000  EA  D   3/03/93  P    001     CAN

TO

     REF       FUNC   QUOTE   O  O  B  REL  HOLD  ORDER     BILL-TO/       ORDER  RSN                                         POST

FUNC  NO  MODE CODE     NO    S  T  A  CODE CODE  DATE      SHIP-TO         NO    CDE                                         DATE

---- ---- ---  ---   --- --   -  -  -   -    -   --------  -----------    ------  ---                                       --------

CLSE V80  OLU  H50   000601   O  Q      D         3/03/93  PJGCAN00001             EQ                                        3/03/93

                                                           PJGCAN00001

     REF       FUNC   QUOTE  LIN                   L                 REL   DUE    PLN SELLING SELLING RSN

FUNC  NO  MODE CODE     NO   NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS   CDE

---- ---- ---  ---   ------  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   ---

CNCL V80  OLU  H35   000601  001  BOLT-200         O      10.000  EA  D   3/03/93  P                   EQ

CNCL V80  OLU  H35   000601  002  BOLT-100         O      10.000  EA  D   3/03/93  P                   EQ

     REF       FUNC   QUOTE   O  O  B  REL  HOLD  ORDER     BILL-TO/       ORDER  RSN                                         POST

FUNC  NO  MODE CODE     NO    S  T  A  CODE CODE  DATE      SHIP-TO         NO    CDE                                         DATE

---- ---- ---  ---   --- --   -  -  -   -    -   --------  -----------    ------  ---                                       --------

FROM V80  OLU  H45   000601   C  Q      D         3/03/93  PJGCAN00001                                                       3/03/93

                                                           PJGCAN00001

TO

     REF       FUNC   QUOTE  LIN                   L                 REL   DUE    PLN SELLING SELLING RSN

FUNC  NO  MODE CODE     NO   NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS   CDE

---- ---- ---  ---   ------  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   ---

FROM V80  OLU  H30   000601       BOLT-100         C      10.000  EA  D   3/03/93  P    001     CAN

TO                                                 C

DATE    3/04/93                              STEVENS SUPPLY                                                              PAGE      1

TIME    8:14:31                                   CANADIAN DISTRIBUTION WHS                                              CO     001

REPORT IC-500                                                                                                            WHS    CN1

                                                       SHIPMENT TRANSACTIONS

                                                            AUDIT TRAIL

REF       FNC                 ANL ADJ  ORDER   LIN O O         TRANS          STOCK  B DOC  DOCUMENT   LOT           TRANS    POST

 NO  MODE CDE  PART NUMBER    CDE CDE   NO     NO  S T  SKU   QUANTITY   UM    LOC   T TYPE  NUMBER    NO            DATE     DATE

---- ---  --- --------------- --- --- -------  --- - -  --- ------------ --  ------- - ---- -------- ------------  -------- --------

V80  OLU  S15 BOLT-200             00 10000170 001 C I  EA        10.000 EA  RECV001 D  IN  10000170                3/03/93  3/03/93

V80  OLU  S15 BOLT-200             00 10000170 003 C I  EA      1000.000 EA  RECV001 D  IN  10000170                3/03/93  3/03/93

V80  OLU  S15 BOLT-200             00 10000172 001 C I  EA        10.000 EA  RECV001 D  IN  10000172                3/03/93  3/03/93

V80  OLU  S15 BOLT-200             00 10000172 002 C I  EA        20.000 EA  RECV001 D  IN  10000172                3/03/93  3/03/93

V80  OLU  S15 BOLT-200             00 10000172 003 C I  EA      1000.000 EA  RECV001 D  IN  10000172                3/03/93  3/03/93

V80  OLU  S15 SAW-100              00 10000170 002 C I  EA       100.000 EA  RECV001 D  IN  10000170                3/03/93  3/03/93

                                                                             **  END OF REPORT  **

DATE    3/04/93                              STEVENS SUPPLY                                                              PAGE      1

TIME    8:14:31                                   DISTRIBUTION WAREHOUSE 6                                               CO     001

REPORT IC-500                                                                                                            WHS    DW6

                                                  CUSTOMER ORDER FILE MAINTENANCE

                                                            AUDIT TRAIL

     REF       FUNC  ORDER   REL  O  O ANL REL  HOLD  ORDER       BILL-TO/   CUSTOMER REFERENCE        CONFIG  DIR  MULT     POST

FUNC  NO  MODE CODE    NO    NO   S  T CDE CODE CODE  DATE        SHIP-TO    SPREAD PO NUMBER          ORDER   DST  SITE     DATE

---- ---- ---  ---   ------  --   -  - ---  -    -   --------  --------- --  -------------------------   -      -   -       --------

FROM V80S OLU  F25   006049  00   O  C      D    D    1/25/93   LBMCUST0001  SAMPOA03                           N   N        3/03/93

                                                                LBMCUST0001

TO                                C                             LBMCUST0001

     REF       FUNC  ORDER   REL LIN                   L                 REL   DUE    PLN SELLING SELLING  VENDOR     PO     PO   SH

FUNC  NO  MODE CODE   NO     NO  NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS    NUMBER   NUMBER   LIN  TP

---- ---- ---  ---   ------  --  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   --------  -------  ---  -

FROM V80S OLU  F40   006049  00  001  BOLT-100         O      10.000  EA  D   2/24/93  P    001     DW6   TMPVEND1  0000944    1  W

TO                                                     C

     REF       FUNC  ORDER   REL  O  O ANL REL  HOLD  ORDER       BILL-TO/                             CONFIG  DIR            POST

FUNC  NO  MODE CODE    NO    NO   S  T CDE CODE CODE  DATE        SHIP-TO    CUSTOMER REFERENCE        ORDER   DST            DATE

---- ---- ---  ---   ------  --   -  - ---  -    -   --------  --------- --  -------------------------   -      -           --------

FROM V80S OLU  F25   006051  00   O  C      D    D    1/25/93   LBMCUST0001  SAMPOA04                           N            3/03/93

                                                                LBMCUST0001

TO                                C                             LBMCUST0001

     REF       FUNC  ORDER   REL LIN                   L                 REL   DUE    PLN SELLING SELLING  VENDOR     PO     PO   SH

FUNC  NO  MODE CODE   NO     NO  NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS    NUMBER   NUMBER   LIN  TP

---- ---- ---  ---   ------  --  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   --------  -------  ---  -

FROM V80S OLU  F40   006051  00  001  BOLT-100         O      20.000  EA  D   2/24/93  P    001     DW6   TMPVEND1  0000945    1  W

TO                                                     C

     REF       FUNC  ORDER   REL  O  O ANL REL  HOLD  ORDER       BILL-TO/                             CONFIG  DIR            POST

FUNC  NO  MODE CODE    NO    NO   S  T CDE CODE CODE  DATE        SHIP-TO    CUSTOMER REFERENCE        ORDER   DST            DATE

---- ---- ---  ---   ------  --   -  - ---  -    -   --------  --------- --  -------------------------   -      -           --------

FROM V80S OLU  F25   006066  00   O  C      D    D    1/25/93   LBMCUST0001  SAMPOB01                           N            3/03/93

                                                                LBMCUST0001

TO                                C                             LBMCUST0001

     REF       FUNC  ORDER   REL LIN                   L                 REL   DUE    PLN SELLING SELLING  VENDOR     PO     PO   SH

FUNC  NO  MODE CODE   NO     NO  NO   PART NUMBER      S   QUANTITY   UM CODE  DATE   CDE   CO      WHS    NUMBER   NUMBER   LIN  TP

---- ---- ---  ---   ------  --  ---  ---------------  -  ----------  --  -  --------  -    ---     ---   --------  -------  ---  -

FROM V80S OLU  F40   006066  00  001  BOLT-100         O      10.000  EA  D   2/24/93  P    001     DW6   TMPVEND1  0000947    1  W

TO                                                     C

 DATE   22/07/94                               ANDERSEN CONSULTING APPLICATIONS, INC                                      PAGE      1

 TIME   18:18:12                                   ITALIAN SPAGHETTI FACTORY                                              CO     001

 REPORT IC-500                                                                                                            WHS    ITA

                                                  WAREHOUSE BALANCE FILE MAINTENANCE

                                                             AUDIT TRAIL

      REF       FUNC                  LEADTIME/      MIN/MAX    REORDER PT/  MINIMUM   PRIMARY  REPL/D-S AL CD/ BY CD/ PO/     POST

 FUNC  NO  MODE CODE   PART NUMBER    SAFETY QTY   STK LVL QTY  TARGET QTY  ORDER QTY  STK LOC    L/T    IR CD  SB CD  I/V     DATE

 ---- ---- ---  ---  --------------- ------------ ------------ ------------ ---------- -------  ------    ---    ---   -     --------

 FROM USER OLU  T25  BOLT-100                   0            0            0          0 NOPRLOC     001                 N     22/07/94

                                                0            0            0                      00000                 Y

                                             PK/SH      PK/SH

                                             CODE    QUANTITY     FREIGHT RATING CODE

                                              --       ---------  -------------------

                                                      000000000

                                                      000000000

 TO                  BOLT-100                                                                                                22/07/94

-                                            PK/SH      PK/SH

                                             CODE    QUANTITY     FREIGHT RATING CODE

                                              --       ---------  -------------------

                                                                      ETC-9093882

                                                                              **  END OF REPORT  **

 

Purpose

The Inventory Control module has six audit trail reports:  Customer Order File Maintenance, Lot Control File Maintenance, Manufacturing Order File Maintenance, Inventory Update Transactions, Warehouse Balance File Maintenance, and Quote Order File Maintenance.

Customer Order File Maintenance Audit Trail--Lists all transactions posted to the Customer Order Header File and the line and comment records associated with the order.  The report is sequenced according to order number, posting date, line number (for detail records), and sequence number (for comment records).

Lot Control File Maintenance Audit Trail--Lists all transactions posted to the Lot Control File.  The report is sequenced according to lot number, part number, and posting date.  It is produced only in a lot-controlled environment.

Manufacturing Order File Maintenance Audit Trail--Lists all transactions posted to the Manufacturing Order File and the Component Requirements File.  The component requirement updates associated with a manufacturing order are printed below the order transaction.  The report is sequenced according to order number and posting date.

Inventory Update Transactions Audit Trail--Lists all inventory update transactions posted to Inventory Control master files.  The types of transactions listed on this report include the following: inventory adjustments, cycle count adjustments, stock transfers, manufacturing order receipts, purchase order receipts, component issues, sales order shipments and returns, flow receipts, flow issues, and point of use transfers from and to audit trails.  The report is sequenced according to company number, warehouse number, part number, and posting date.

Warehouse Balance File Maintenance Audit Trail--Lists all maintenance transactions posted to the Warehouse Balance File and the detail records associated with each transaction.  The report is printed in company number, warehouse number, part number, and posting date sequence. 

Quote File Maintenance Audit Trail--Lists all transactions posted to the Quote File Maintenance File and the line and comment records associated with the quote order.  This report is sequenced according to quote order, posting date, line number (for detail records), and sequence number (for comment records). 

The report headings are cross-referenced to their field names below.

The function codes that appear on the report are defined as follows:

A20  -  Manufacturing Order - Add

A25  -  Manufacturing Order - Change

A26  -  Manufacturing Order Descriptive Record for Component Requirements Changes

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

F25  -  Customer Order Header - Change

F26  -  Customer Order Header - Description

F35  -  Customer Order Line - Add

F40  -  Customer Order Line - Change

G25  -  Customer Order Header - Close

G45  -  Customer Order Comment - Add

G50  -  Customer Order Comment - Change

G55  -  Customer Order Comment - Cancel

J40  -  Flow Receipts

J45  -  Backflush Issues

J50  -  Lot Issues

J55  -  Deduct Issues

J60  -  Unplanned Usage Issue

J65  -  Point of Use Transfer - From

J70  -  Point of Use Transfer - To

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

U05  -  Warehouse Description Address - Add

U10  -  Warehouse Description Description - Add

U15  -  Warehouse Description Cycle Count - Add

U20  -  Warehouse Description Address - Change

U25  -  Warehouse Description Description - Change

U30  -  Warehouse Description Cycle Count - Change

U50  -  Warehouse Description - Delete