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