Inventory Usage - Summit Systems Inc.
Contents
1. oo lt gt mm no oo oo lt oo ae NNN ot oo co oo KO LO LO t c CO CO CO CO CO OO Oh lt t t St t TO C4 C5 C r C C 4 c c c c c CO CO t CO CO t lt CO lt lt CO C4 C NN 1 lt REO RE M 51 MA 00000000000000000000000000 BANS SMM HS I OG CC I CC CC CC I CC IL ec ec ff 1 CC ec _FOrFFOOCOFFEFOOFOOFFOOOOFFOOF Example of a purchase order document berag listed in so avai KKK KKK KKK E KG EEEE X x X X X EEE x the 80 column format 132 column format a COMMAND 60 1 891 List transaction log by part or document v1 0 ENTER DESIRED OUTPUT OPTION 0 LINE PRINTER 1 TERM2. EEE EEEE EE EEE EEEE t Example of transaction log records summarized by category and month 132 column format also available KEKKK LEE EEEE EEE EEEE EEE EEEE EEEE x x COMMAND MG 60 1 892 Transaction log period summary by part number v1 0 ENTER DESIRED OUTPUT OPTION 0 LINE PRINTER 1 TERMINAL 132 COLUMNS 2 ENTER LOGICAL DEVICE DISC FILE 132 COLUMNS 3 TERMI NAL OPTION 3 3 DOWNLOADED LAST TRANSACTI ON LOG TO BE 0422 RECORD NUMBER 1263 3 04 PM TRANSACTION LOG TROO LISTING OPTI ON 1 USAGE SUMMARY 2 CATEGORY SUMMARY OPTI ON 2 PART NUMBER 231000 15 STAINLESS SHEET 23 75 47 75 YEAR 95 95 GATHERING DATA SORTI NG 245 RECORDS BY CATEGORY SAT SEP 23 1995 TRANSACTION LOG SUMMARY 1995 231000 15 STAINLESS SHEET 23 75X 47 15 P CATEGORY MAR APR MAY INV ADJ UST 00 1 00 00 00 00 ISSUES 00 00 00 00 00 PRODUCTI ON 00 100 254 00 00 00 RECEIPTS 00 00 00 000 140 00 SHI PMENTS 119 00 113 00 116 00 47 00 92 00 ENDING BAL 157 00 43 00 181 00 134 00 182 00 CATEGORY JUL AUG SEP NOV INV ADJ UST 1 00 00 5 00 00 00 ISSUES 00 00 00 00 00 PRODUCTION 00 00 00 00 00 RECEIPTS 00 80 00 55 00 00 00 SHI PMENTS 39 00 76 00 65 00 00 00 ENDING BAL 121 00 125 00 120 00 120 00 120 00 YEAR 95 1 LEERE EE
3. TXLDET Date TXDAT TXLDET Ti me TXTIME TXLDET User the user that performed the transaction TXUSER TXLDET If you are listing to printer 132 col umn Debit Account number TXDR TXLDET Credit Account number TXCR TXLDET Unit Cost TXUNTCST TXLDET Extended Cost unit cost times transaction quantity From lot number and To lot number are displayed on second line if they are non blank 16 Usage and Transaction Log System L 1 893 after the transaction has occured TXQOH TXLDET Date TXDAT TXLDET Ti me TXTI ME TXLDET User the user that performed the transaction TXUSER TXLDET If you are listing to a printer 132 column Debit Account number TXDR TXLDET Credit Account number TXCR TXLDET Unit Cost TXUNTCST TXLDET Extended Cost unit cost times transaction quantity From lot number and To lot number are displayed on second line if they are non blank LERE EEEE EE EEEE EEEE EEEE KK t Example of a the transaction log entries for a part number being listed 132 column format also avallable RK KKK KK KKK KK KK KKK KK KK KKK KK KK KKK KK KK KKK KK KK KKK KKK KKK KK KKK COMMAND MG 60 1 891 List transaction log by part or document v1 0 ENTER DESIRED OUTPUT OPTION 0 LINE PRINTER 1 TERMINAL 132 COLUMNS 2 ENTER LOGICAL DEVICE DISC FILE 132 COLUMNS 3 TERMINAL
4. Inventory Usage System User M anual Summit Systems Inc 308 Orchard Ave St Louis Mo 63119 2526 Phone 314 963 9021 Fax 314 968 4122 Email SummitSys aol com Web www sumsystems com products html Version 4 0 February 2005 ASK Manman and OMAR are registered trademarks of Computer Associates International Inc Inventory Usage System Contents Fed tUr S Suc ai 5 rio The Transaction Log Data Accessing with Qui Zaran maia E A ET The Command Master aA LI 891 List Transaction Log 892 List Usage and Categories by 890 Maintain Command UT 891 Download Transaction Log Files to the Data Base 892 Calculate Monthly Usage LI 893 List a Parts Transactions across databases 2 Inventory Usage System Features Inventory Usage System Features Stores Transaction Log History with Minimal Resources The Inventory Usage System archives very small record of your transaction log entries to a data base This allows you to retain your transaction log history using only 20 of the space you would require to keep an equivalent number of months of transaction logs on your system View a Parts Usage for each Month of the Year The
5. DEBIT ACCOUNT CFG USER 06 01 95 THRU 99 99 99 3 04 PM DATE 09 22 95 QUANTI TY TI ME TRANSACTI ON LOG DETAIL 1263 v1 0 132 COLUMNS RECORD NUMBER NUMBER 132 COLUMNS TR000422 9 19 LOC LOT ENTER LOGICAL DEVICE DISC FILE TERMI NAL 225225 1995 DOCUMENT LINE PRINTER 1 TERMINAL 2 3 OPTION 3 1 PART NUMBER DOCUMENT WO PO SO MR SEP 23 NUMBER 0 TRANSACTI ON 106 INQUIRY OPTION List transaction log by part or document 1 ENTER DESIRED OUTPUT OPTION LAST TRANSACTION LOG BE DOWNLOADED COMMAND MG 60 1 891 2 OPTI ON 1 1 BEGI NNI NG DATE 6 1 ENDI NG DATE 99 PART NUMBER 225225 SAT PART NUMBER COMMAND CO DOOM 10 lt gt 10 co co NI co CO c4 XO LO FO C5 C5 c IR CO e r 10 gt co 10 10 10 lt o 10 amp MAR 10 fF XO LO XO C r r r Ot TOM lt im co eo LO LN LO LO LO LO LO LO LO LO LO LO LN LN LN LN
6. archives the records from your transaction logs in reduced format This format allows you to store transaction log history on your system using only 20 of the space requirements you would require by keeping the equivalent number of months of transaction logs on your system Additionally which commands get archived is entirely optional You may decide not to archive any account number changes cost changes or location transfer types of commands since they have no effect on the usage of your parts This would in turn yield even less storage requirements for your history Dataset TXLDET key fields TXPARTNO 018 Part Number Issued Received Scrapped TXWO U10 Work Order Sales Order or Purchase Order No TXWOPNI D 1 0 component part 1 assembly part TXDOCTYP 02 Document Type 0 50 TXFLOC U10 Inventory Location Parts moved FROM TXTLOC U10 Inventory Location Parts moved TXLOT U18 Inventory Lot Number TXLOTFLG 1 Lot Id 0 both to and from lot are blank 1 from lot blank to lot non blank 2 to lot blank from lot non blank 3 to lot and from lot are equal gt 0 to lot and from lot different from lot starts in byte value TXQTY R2 Quantity Issued Received or Scrapped TXQOH R2 Nettable Qty On Hand after Update TXDR U10 Debit Account Number TXCR U10 Credit Account Number TXUSER U8 Log On Name TXCMDNO 06 Command Number TXUNTCST R2 Unit Cost TXFILNO 1 TLOG file number TXDAT 1
7. 1 DISPLAY INVENTORY UNITS 2 DISPLAY INVENTORY VALUE OPTI ON 1 If you would care to see the inventory value of the transactions instead of the inventory units enter 2 to this prompt If you select options 3 or 4 the following prompts appear CLASS CODE GROUP CLASS CODE Enter the class code group 1 2 3 or 4 and the class code belonging to the parts you wish to inquire upon If you are performing category summary the following prompt appears YEAR Enter the year you wish to inquire upon The default is the current year The values are summarized by month and printed You return to the year prompt if you are inquiring by category or the listing option prompt if you are listing usage Files Accessed Item master file TXLCMD Transaction Log Command file TXLDET Transaction Log Detail file TXL MAS Transaction Log Master file TXLUSG Transaction Log Usage file Screen Format Category TXCCMD TXLCMD TXLCMDNO TXLDET Monthly Buckets Sum of transaction quantities if ing by category TXQTY TXLDET Lists the months calcul usage if this is a usage inquiry TXUSAGE TLXUSG uiring ated 12 Inventory Usage System UT 890 UT 890 Maintain Command File The command file in the Inventory Usage System performs 3 functions l Determines if the command will be included in usage calculations when executing command UT 892 Calculate Monthly Usage File 2 Determines whether the co
8. LN LN LO LO LN LO LO 1 LO LO 6 4 COST NV NV gt gt gt gt OO n a CQ 2 2 2 2 2 2 Z SMITH 2 260 GRAVES 2 260 GRAVES 10 454 GRAVES 10 454 GRAVES 10 414 SMITH 5 10 10 c FF EE EEE OE SE ES ES lt gt 1010 oo 1 10 e o c OOS 5 cn c o lt gt t co en r tr totoo 08434 ON HAND cA 10 co 10 t XO 10 TNO lt c qo
9. N This is a friendly warning that appears before you start the calculation process CALCULATE USAGE FOR 1 ALL DOWNLOADED TRANSACTION LOGS 2 THE CURRENT YEARS DOWNLOADED TRANSACTION LOGS ON 1 By default this command will recalculate the last three years monthly usage for each part on the system If you no longer have all three years of transaction log details downloaded in your database we allow you the option of zeroing out the current years usage numbers and just recalculating the current year The first step is that all previously existing usage records are deleted from the the transaction log data base In other words you wipe out your usage calculations from the last time you ran this utility The next step is to read the transaction log detail For each type of command the Command Master file is checked to see if this command should effect the usage calculation If so the transaction quantity of this command is summarized into monthly buckets for the last three years or the current year only Files Accessed TXLCMD Transaction Log Command file 16 TXLDET TXLMAS TXLUSG Inventory Usage System Transaction Log Detail fi Transaction Log Master fi le Transaction Log Usage file updated UT 892 Inventory Usage System 11 893 List Parts Transaction L og Detail Across Databases This command is used to list the individual transactions in the transaction log data base for a pa
10. OPTION 3 3 LAST TRANSACTION LOG TO BE DOWNLOADED TRANSACTION LOG 78000422 RECORD NUMBER 1263 TIME 09 22 95 3 04 PM I NQUI RY OPTION 1 PART NUMBER 2 DOCUMENT WO SO MR NUMBER OPTI ON 1 1 PART NUMBER 225225 ALUMI NUM BAR 095 10 48X 46 31 M SAT SEP 23 1995 TRANSACTI ON LOG DETAIL PAGE 1 225225 ALUMINUM BAR 095 10 48X 46 31 DOCUMENT FROM TO TRANS QTY ON COMMAND NUMBER LOCATION LOCATION QTY HAND DATE TIME USER TR 402 PO 102823 60 4300 4300 09 15 55 SMITH 210 0 44068 60 3025 0 09 05 10 17A GRAVES 309 WO 3868 65 100 3025 08 31 2 25P SMITH 309 WO 3868 65 2375 2925 08 30 3 05P SMITH 210 50 44067 65 600 550 08 30 7 44 SMITH 210 50 44067 620103 500 1150 08 30 7 44A SMITH 210 50 44067 614103 360 1650 08 30 7 44A SMITH 309 WO 3868 65 550 2010 08 29 3 18 SMITH 309 WO 3868 65 600 1460 08 28 3 33P THOMPSON 402 102823 60 500 860 08 25 7 36A SMITH 210 50 44066 60 2400 360 08 24 11 32 GRAVES 210 50 44066 65 600 2760 08 16 8 10 SMITH 309 3870 65 2560 3360 08 15 3 06 SMITH 210 50 44066 620207 600 800 08 15 11 58 SMITH 210 50 44066 620206 2400 1400 08 15 11 58 SMITH 309 WO 3870 65 200 3800 08 14 3 27 THOMPSON CONTINUE Y INQUIRY OPTION 1 PART NUMBER 2 DOCUMENT WO PO SO MR NUMBER OPTI ON 1 E 1 EXTENDED COST PAGE UNIT ies by LEE E EEE E EE E CREDIT ACCOUNT tr t
11. RETURN FROM SV STOC CHANGE QTY RETURND TO SERV R CHANGE QTY SCRAPD FROM SERV R RECEIVE PARTS INTO SERV R RECEIVE INTO STOCK FROM SV R RECEIVE PARTS INTO SERV STOCK RETURN PARTS FROM SERV R RETURN PARTS FROM SERV STOCK RETURN FROM STOCK TO SERV R SCRAP PARTS FROM SERV R CHANGE A MR SERV EXCHANGE QTY CHANGE A MR SERV EXC QTY RECVD ENTER UPDATE AN INCIDENT REPT ENTER UPDATE PRIORITY NCDENT RECORD PICKING DISPATCH NOTES STOCK RECEIPT FOR AN NCI DENT STOCK RECEIPT FOR A MANUAL REQ STOCK RECEIPT FOR A RETURN ENTER SERV EXCHANGE RECEIPT RETURN PARTS FROM A REQUSI TI ON SERVICE INVENTORY ADJUSTMENT TRANSFER TO SERV TRANSFER SERVICE INV LOCATNS ENTER A SERVICE CALL INVENTORY CONVERSI ON PROGRAM BACKFLUSH A REWORK PART REVERSE BACKFLUSH REWORK PART ISSUE MATERIAL FOR A PULL RELI EVE REPETITI VE SHORTAGE BACKFLUSH AT COUNT POINT REVERSE BACKFLUSH COUNT POINT SCRAP ASSEMBLIES AT COUNT PT WIP VALUE ADJUSTMENT REPETITVE PULL LIST TRANSACTIO BACKFLUSH FROM WORK AREA SCRAP ASSEMBLIES FROM WORK ARE REVERSE SCRAP ASSEMBLIES COMPONENT CYCLE COUNT BALANCE REVALUE WIP VALUE SHIP I NTERPLANT ORDER RECORD A LOST SHI PMENT RECEIVE RETURNED PARTS YES YES YES SHI PMENTS SHI PMENTS SHI PMENTS ACCOUNTING RECEI PTS RECEI PTS RETURNS RETURNS ACCOUNTI NG SCRAP ACCOUNTI NG RECEI PTS RECEIPTS RETURNS RETURNS ACCOUNTI NG SCRAP ISSUES ISSUES ACCOUNTI NG ACCOUNTI NG ACCOUNTI NG ACCOUN
12. Xx X x eclassifing command to new cate ory CK OK KK E X Xx X X KKK KK KKK x x x x COMMAND MG 60 0 890 1 Maintain Command Master File v1 0 COMMAND NUMBER ALL TO LIST TR 100 CYCLE COUNT A PART IN STORES RETAIN THIS COMMAND IN TRANSACTION LOG DATA BASE Y Y gt USE THIS COMMAND IN USAGE CALCULATIONS N Y CATEGORY INV ADJUST CYCLECOUNT COMMAND NUMBER ALL TO LIST E 5 t Example of downloading current transaction log since 5 the last time we ran the utility last record read LSE ES SE SE SE KE KG KG KE EG E KG EG E SE SE SE SE JE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE SE x COMMAND MG 60 U 891 Download transaction logs to transaction data CURRENT TRANSACTION FILE IS TR000422 TRANSACTIONS RANGE FROM 09 18 95 TO 09 22 95 CONTAI NING 1263 TRANSACTIONS UPDATE OPTI ON 1 UPDATE FROM LAST RECORD READ 2 DOWNLOAD A RANGE OF TRANSACTION LOG NUMBERS OPTION 1 1 LAST TRANSACTION LOG TO BE DOWNLOADED TRANSACTION LOG TR000422 RECORD NUMBER 1260 TIME 3 04 PM OPENING TRANSACTION LOG FILE NAME TRO00422 READING TRANSACTION LOG TRO00422 3 RECORDS UPDATED KKK KKK KKK T Example of initially downloading your transaction logs to the data base using a range of
13. environment Quiz schema is provided if you want to write your own inquiries Inventory Usage System Enhancements of Usage and Transaction L og Release 4 0 Capture of Scrap Reason Code The scrap reason code is now kept in the Transaction log detail data set It resides in the to location field of the data base The scrap reason code will be displayed on the 11 891 screen in the to location column in the format SCRAP R xx Enhancements of Usage and Transaction Log Release 3 5 A Inventory Value Listing A new option has been added to program LI 892 transaction log summary by part to allow you to list either inventory units of inventory value by category within a class code group 1 2 3 or 4 B Class code total option A new option has been added to program LI 892 transaction log summary by part to allow you to list the totals only for the class code selected Enhancements of Usage and Transaction L og Release 3 0 A New option to list parts by class code A new option has been added to program LI 892 transaction log summary by part to allow you to list all parts within a class code group 1 2 3 or 4 Two new list options will allow you to list a all parts usage summary or list a parts transactions by category for all parts in a selected class code B New Usage yearly totals The command 11 892 Transaction log summary by part number now has a 13th column in the report version that will total all 12 mon
14. selected transaction log file names COMMAND MG 60 0 891 Download transaction 1005 to transaction CURRENT TRANSACTI ON FILE IS TR000422 TRANSACTI ONS RANGE FROM 09 18 95 TO 09 22 95 CONTAI NI NG 1263 TRANSACTIONS UPDATE OPTI ON 1 UPDATE FROM LAST RECORD READ 2 DOWNLOAD A RANGE OF TRANSACTION LOG NUMBERS OPTION 1 2 BEGINNING TRANSACTION LOG NUMBER 421 ENDING TRANSACTION LOG NUMBER 422 SEARCHING TRANSACTION LOG DATA BASE NUMBER OF RECORDS DELETED FROM TRANSACTION DATA BASE 1895 OPENING TRANSACTION LOG FILE NAME TRO00421 READING TRANSACTION LOG TR000421 OPENING TRANSACTION LOG FILE NAME TRO00422 READING TRANSACTION LOG TR000422 1895 RECORDS UPDATED LEERE EEE EEEE EEE EEE EEE EEEE KKK KKK Example of running usage calculation utility UT 892 to recalculate the monthly usage buckets in the data base KG GE KG GE GG GG SE SE SE SE SE SE SE SE x COMMAND MG 60 892 Calculate Monthly Usage Record v1 0 THIS PROGRAM RE
15. At their completion you will return to the Inquiry option prompt Files Accessed Item master file TXLDET Transaction Log Detail file TXL MAS Transaction Log Master file Inventory Usage System Screen Format Command number TXLCMDNO TXLDET Part number or Document number TXWO or TXPARTNO TXLDET From location number TXFLOC TXLDET To location number or scrap reason code TXTLOC TXLDET Transaction Quantity TXLDET Quantity on hand quantity on hand of the part number listed after the transaction has occured TXQOH TXLDET Date TXDAT TXLDET Ti me TXTI ME TXLDET User the user that performed the transaction TXUSER TXLDET If you are listing to a printer 132 column Debit Account number TXDR TXLDET Credit Account number TXCR TXLDET Unit Cost TXUNTCST TXLDET Extended Cost unit cost times transaction quantity From lot number and To lot number are displayed on second line if they are non blank 10 Inventory Usage System L 1 892 11 892 List Usage and Categories by This command is used to summarize part numbers transactions by month and year You have the option of inquiring by selected part number or to list all part numbers within a class code group 1 2 3 or 4 You may summarize by either categories or by listing parts calculated usage Categories are defined for each command in the transaction log data base using command UT 890 Usag
16. CALCULATES THE MONTHLY USAGE FILE CONTINUE N Y Y CALCULATE USAGE FOR 1 ALL DOWNLOADED TRANSACTION LOGS ON FILE 2 THE CURRENT YEARS DOWNLOADED TRANSACTION LOGS OPTI ON 1 SEARCHING TRANSACTION LOG DATA BASE USAGE RECORDS DELETED FROM TRANSACTION DATA BASE 4345 GATHERING DATA SORTING 59509 RECORDS NUMBER OF USAGE RECORDS CREATED 4388 COMMAND MG 60 E
17. CCOUNTI NG ACCOUNTI NG ACCOUNTI NG ACCOUNTI NG ISSUES ISSUES ISSUES RODUCTI ON SUES ODUCTI ON SUES SUES SUES ODUCTI ON SUES SUES RAP SUES ODUCTI ON SUES UES ee ACCOUNTING ACCOUNTING ACCOUNTING RECEI PTS RECEIPTS RETURNS RETURNS ACCOUNTI NG SCRAP SHI PMENTS ACCOUNTI NG ACCOUNTI NG ACCOUNTI NG SHI PMENTS SHI PMENTS Un Un Un Un C ZO On 223 On o lt OT 300 OT 301 oo Cn 33 29 29 29 29 cr cr ccr o0 gt gt gt HEHEHE gt gt EE PP lt gt o 4 i lt gt UT gt AAA ST 752 51 765 ST 766 ST 770 ST 775 ST 776 lt lt dee ee eee eM 4 4 gt 29 20 20 1 20 20 20 70 70 70 70 70 lt U DDD W C CJ CJ CJ C CJ CJ C CO CJ CO CO XO UT MJ PO ODD lt gt 4 4 lt gt CO Oii ji lt gt 00 ro INVOICE SALES ORDER VOLD AN INVOICE CASH SALE CHANGE SERV QTY IN R CHANGE QTY RECVD FROM SERV R CHANGE QTY RECV TO SERV STOCK CHANGE QTY RETURN FROM SERV R CHANGE QTY
18. Date transaction is logged to Log File TXTI ME 2 Time transaction is logged to log file Dataset TXLUSG TXPARTU U18 TXUSAGE 36R2 The TXUSAGE array stores up 36 months of usage history Buckets 1 to 12 are the current years usage for the part Buckets 13 to 24 are last years usage for the part Buckets 25 to 36 are the prior years usage for the part The buckets reflect calendar months Bucket 1 13 25 are for the month of January bucket 2 14 26 are February 12 24 36 are December key fields Part number usage file Calculated Usage 5 r Accessing TXLDB with Quiz 6 Inventory Usage System The Data Base A Quiz Schema file dictionary is provided with the Inventory Usage System There is a QDD dictionary which should work with most versions of Quiz named QTXLSCHC PUB PDL dictionary name PTXLSCHC PUB MMV110 is also available for Powerhouse 8 To access the TXLDB use Quiz by entering file equation and SET DICTIONARY command QUI Z QUI Z 7 29 C8 Level 999 Copyright 1997 COGNOS NCORPORATED gt FILE TXLDB MDATABAS TXLDB MDATAB60 point at database 60 SET DICTI ONARY QTXLSCHC PUB MMV110 ACCESS TXLDET The Command Master File The Inventory Usage System keeps a record for each of the 140 different commands that can be written to the transaction log You can maintain each of the 140 commands using UT 890 to tailor the following options 1 00 you wish to archive this command
19. EE EEEE EEEE EEEE EEE EE EEEE EE EEEE EEE EE EEEE EEE EE EEE EEEE EEEE Example of usage summary showing the monthly usage calculated by 892 over the last 3 years 1 COMMAND MG 60 1 892 Transaction log period summary by part number v1 0 ENTER DESIRED OUTPUT OPTION 0 LINE PRINTER 1 TERMINAL 132 COLUMNS 2 ENTER LOGICAL DEVICE DISC FILE 132 COLUMNS 3 TERMI NAL OPTION 3 1 DOWNLOADED LAST TRANSACTION LOG TO BE 0422 RECORD NUMBER 1263 TIME 3 04 PM TRANSACTION LOG TROO LISTING OPTI ON 1 USAGE SUMMARY 2 CATEGORY SUMMARY OPTION 2 1 PART NUMBER 231000 15 SAT SEP 23 1995 9 50 231000 15 STAINLESS SHEET 23 75 47 75 CATEGORY J AN FEB MAR APR MAY J UN USAGE 95 119 00 113 00 370 00 47 00 92 00 41 00 USAGE 94 139 00 160 00 146 00 78 00 191 00 88 00 USAGE 93 00 00 00 00 00 00 LISTING OPTION 1 USAGE SUMMARY 2 CATEGORY SUMMARY OPTI ON 2 TRANSACTI ON LOG SUMMARY AUG 76 00 106 00 00 55 00 60 00 00 OCT 00 129 00 00 NOV won or 1 DE C Example of X 9 X Xx KK KKK KKK RK X X
20. IN STORES ISSUE PARTS FROM STORES ISSUE PARTS TO STORES SCRAP A PART FROM STORES CYCLE COUNT A PART IN WIP ISSUE PARTS FROM WIP ISSUE PARTS TO A LOCATION SCRAP A PART FROM WIP STORES TO STORES LOC TRANSFER STORES TO WIP LOCATN TRANSFER WIP TO STORES LOCATN TRANSFER WP TO WP LOCATION TRANSFER STORES TO STORES TRANSFER A WORK ORDER WORK ORDER DEKIT COMPLETE AND MOVE PARTS COMPLETE PARTS TO STOCK YES COMPLETE MOVE PARTS INTO STOCK COMPLETE MOVE PARTS INTO STOCK YES RELIEVE A SHORTAGE MULTIPLE WORK ORDER KIT LABOR TICKET TRANSACTI ON LABOR TICKET COMPLETI ONS YES KIT WORK ORDER WORK ORDER DEKIT SCRAP A COMPONENT FROM WO JOB TICKET TRANSACTION JOB TICKET COMPLETI ONS YES COMPLETE PARTS AT A WO OPER MOVE PARTS THRU A WO OPERATN MOVE PARTS THRU A WO OPERATN YES KIT A WORK ORDER FROM LABELS SPLIT A WORK ORDER WO TO WO TRANSFER RECEIVE PARTS INTO R RECEIVE INTO STOCK FROM R RECEIVE PARTS INTO STOCK RETURN PARTS FROM R RETURN PARTS FROM STOCK RETURN PARTS FROM STOCK TO R SCRAP PARTS FROM R PARTS ISSUED TO A SALES ORDER CHANGE ACCOUNT A TO B INDIVIDL ASSEMBLY COST ROLLUP MOVE CURRENT COSTS TO STANDARD SALES ORDER SHIPMENT ALTER A SHIPMENT RETAIN TRANS DATA BA n YES YES I NCLUDE IN USAGE CALCULATN CATEGORY INV ADJUST INV ADJ UST ACCOUNTING ACCOUNTING ACCOUNTING ACCOUNTING ACCOUNTING RECEI PTS RECEIPTS RETURNS RETURNS ACCOUNTI NG SCRAP INV ADJUST INV ADJUST ACCOUNTI NG A
21. INAL 132 COLUMNS 2 ENTER LOGICAL DEVICE DISC FILE 132 COLUMNS 3 TERMI NAL OPTION 3 3 DOWNLOADED LAST TRANSACTI ON LOG TO BE 0422 RECORD NUMBER 1263 TRANSACTION LOG TROO INQUIRY OPTION 1 PART NUMBER 2 DOCUMENT WO PO SO MR NUMBER OPTI 0N 1 2 DOCUMENT NUMBER 102823 SAT SEP 23 1995 TRANSACTI ON LOG DETAIL DOCUMENT NUMBER 10283 PART FROM TO TRANS COMMAND NUMBER LOCATION LOCATION QTY 4 gt c N UJ UJ N N UJ NJ NJ lt NN 4 NJ I NN RI RI gt 09 N CO 4 lt lt lt lt lt lt lt lt 2 ooon r2 INQUIRY OPTION 1 PART NUMBER 2 DOCUMENT WO SO NUMBER OPTI ON 1 1 SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH SMYTH able TIME 09 22 95 3 04 QTY ON HAND DATE TIME USER 4800 09 15 8 55 0 09 15 8 55 4300 09 15 8 554 20 09 14 7 224 542 08 25 7 36 463 08 25 7 36 564 08 25 7 36 860 08 25 7 36 491 08 25 7 354 70 08 25 7 35 29 08 25 7 35 30 08 25 7 35 LEERE EEEE
22. TI NG RECEIPTS RECEIPT RECEIPTS RETURNS INV ADJUST ACCOUNTI NG ACCOUNTI NG ACCOUNTI NG ACCOUNTI NG V ADJUST COUNTI NG PMENTS PMENTS PMENTS 8 Inventory Usage System L 1 891 11 891 List Transaction L og Detail This command is used to list the individual transactions in the transaction log data base for a part number or a document work order purchase order sales order material req number number The transactions are listed in descending date and ti sequence therefore listing the most recent transactions first Prompts Displays output options OPTION 3 The system keeps track of the last time the current transaction log was downloaded to the transaction log data base The date and time this last occured UT 891 was ran is displayed NQUI RY OPTI ON 1 PART NUMBER 2 DOCUMENT 50 NUMBER OPTI ON 1 If you selected option 1 to inquire by part number or option 2 to inquire by document number If you are directing the output to a printer 132 column device the following two prompts appear BEGINNING DATE ENDING DATE Enter a date range for the transaction log entries you would like to print To print all entries on file enter zero for the beginning date and 99 for the ending date You will receive one of the following two prompts based upon your inquiry option PART NUMBER DOCUMENT NUMBER The transaction log entries will be listed in descending date sequence
23. UTI 1 1 Reserved for future use If you have a non Manman transaction that resides in the transaction log TR 180 you may need to use Query and add a record to TXLCMD above so that the records get archived to TXLDET Set the TXUSGLFG to 1 if the custom command effects Usage The following two pages is a list of the predefined archive options usage calculations and categories that come with the system COMMAND NUMBER 45 lt gt 501 GJ WWW CO CJ CJ GJ GJ I3 I3 i3 I3 Pe lt 2 rJ i i i i lt gt lt gt lt gt gt gt gt lt gt lt gt lt gt MG I gt gt co co W I C5 o co W CJ rJ rJ i lt 4 IA lt W FJ i Co COMPL DESCRIPTION ASSMB CHANGE EVERYTHING ABOUT PART CHANGE A PART S QUANTITY ON CHANGE A PART S GL ACCOUNT NO CHANGE EVER ABOUT LOCATION CHANGE A LOCATIONS GL ACCOUNT CHANGE A WORK ORDER ACCOUNT NO CHANGE QUANTITY IN RECV INSP CHANGE QUANTITY RECVD FROM R CHANGE QUANTITY RECV TO STOCK CHANGE QTY RETURNED FROM R CHANGE QTY RETURND FROM STOCK CHANGE QTY RETURNED TO R CHANGE QTY SCRAPPED FROM R PHYSICAL INVENTORY UPDATE UPDATE WIP COMPONENT ISSUES CYCLE COUNT A PART
24. ate the data base from the last record read Once you have downloaded all of your transaction logs using option 2 execute option 1 periodically throughout the day to keep the transaction log data base current Option 3 is used to purge old transaction log details from your transaction log data base It will not purge your transaction 1005 If you select option 2 or 3 the following prompts will appear BEGI NNI NG TRANSACTI ON LOG NUMBER ENDING TRANSACTI ON LOG NUMBER Enter the numbers of the transaction logs you would like to download The beginning and ending numbers may be the same if you only wish to download one transaction log Enter the transaction log numbers as whole numbers ie 123 You do not need to enter the and the zeros that prefix the transaction log number 53 2 The program begins reading the transaction log data base and wil delete any previously downloaded history that exists within this range of transaction log numbers The purpose of this is twofold 1 Should this utility ever abort due to the data base filling up it will purge any portion of the transaction log that was in the process of being loaded Thus no duplications will appear in your data base If you wanted to change which commands you archive at 14 Inventory Usage System UT 891 later date you can download the transaction log again to reflect what commands you wanted to include or exclude The transaction logs are read and written to
25. e numbers are calculated by executing command UT 892 Transactions are sorted into monthly buckets For inquiries by category the user is prompted for a year For usage inquiries the last 3 years if on file are listed The category listing option will always include an ending balance line at the conclusion of listing all of the parts categories The ending balance line lists the parts on hand balance at the end of the month listed Prompts Displays output options OPTION 3 The system keeps track of the last time the current transaction log was downloaded to the transaction log data base The date and time this last occured UT 891 was ran is displayed LISTING OPTI ON 1 USAGE SUMMARY BY PART NUMBER 2 CATEGORY SUMMARY BY PART NUMBER 3 USAGE SUMMARY BY CLASS CODE 4 CATEGORY SUMMARY BY CLASS CODE UNITS OR VALUE OPTI ON 2 If you selected option 1 3 to list the monthly calculated usage buckets for the part number Select option 2 or 4 to Summarize the parts activity by month and category If you select options 1 or 2 the following prompt appears PART NUMBER Enter the part number you wish to inquire upon If you selected option 4 the following prompts appear 1 LIST EACH PART IN THE CLASS CODE 2 LIST CLASS CODE TOTALS ONLY OPTI ON 1 If you only want the totals of all parts in the class code 11 Inventory Usage System then enter 2 to this prompt To see all parts enter a 1
26. egory Enter a new category you would like to classify this command under The category is not a validated field You may enter up to ten characters to describe a category You are limited to 20 different different categories within the data base The data base is initialized with 8 standard categories which you may change at your discretion Press return to retain the same value Files Accessed TXLCMD Transaction log command file Inventory Usage System UT 891 Download Transaction Log Files to the Data Base The command writes selected records from your transaction log files to the transaction log data base Which commands get archived is at your option depending on the setting in the Command Master file see UT 890 This command should be run periodically throughout the day once all your history has been loaded to keep transaction log data base in synch with todays transactions Prompts The current transaction log number dates and number of transactions is displayed UPDATE OPTION 1 UPDATE FROM LAST RECORD READ 2 DOWNLOAD RANGE OF TRANSACTI ON LOG NUMBERS 3 DELETE RANGE OF DOWNLOADED TRANSACTI ON LOGS OPTI ON 1 If this is the first time you have run UT 891 you will want to use option number 2 to download one or more of your transaction logs to the transaction log data base You must also download your current transaction log shown above using option number 2 before you use option number 1 to upd
27. mmand will be written archived to the transaction log data base when the transaction log download utility UT 891 is executed 3 Determines what category this transaction is included in The transaction history of the part is summarized using the category in command 11 892 The system uploads a default set of values and categories the first time you execute this command You may use this command to change whether the command should be archived usage should be calculated using this command or what category this command should appear in Prompts COMMAND NUMBER ALL TO LIST Enter the command number you wish to maintain You must enter the command with a two character prefix a comma and a 3 digit suffix ie TR 309 If you want a listing of the current settings enter ALL and output options will appear RETAIN THIS COMMAND IN TRANSACTION LOG DATA BASE Y If you want this command written to the transaction log data base enter Y If disc storage is a concern we reccommend you do not archive commands that archive account number changes cost changes or location transfer commands that have no effect on usage USE THIS COMMAND IN USAGE CALCULATIONS Y If you would like the transaction quantity of this command included in your calculations of monthly usage UT 892 enter a y The data base is initialized with the standard ASK defaults for usage calculations Press return to retain the same value CATEGORY old cat
28. rt number in multiple manufacturing data bases This command will search to see if you have more than one transaction data base TXLDB in the account you are in and gathers all of the detailed transaction log records from each of the data bases and combines them into a single inquiry screen Prompts Displays output options OPTION 3 The following two prompts appear BEGI NNI NG DATE ENDING DATE Enter date range for the transaction log entries you would like to print To print all entries on file enter zero for the beginning date and 99 for the ending date PART NUMBER Enter the part number you wish to inquire upon You wil be warned If the part number does not exist in the data base and you will be asked if you wish to continue Each of the transaction log data bases will be searched for records on this part number The transaction log entries will be listed in descending date and time sequence Files Accessed IM Item master file TXLDET Transaction Log Detail file TXLMAS Transaction Log Master file Screen Format Data base number Command number TXLCMDNO TXLDET Part number or Document number TXWO or TXPARTNO TXLDET From location number TXFLOC TXLDET location number scrap reason code TXTLOC TXLDET Transaction Quantity TXQTY TXLDET Quantity on hand quantity on hand of the part number listed 18 Inventory Usage System 11 893 after the transaction has occured
29. system will calculate parts usage for each month of the year and store it in the data base List commands allow you to view up to 3 years of a parts usage by month Instantly inquire into Transaction L og details List commands inquire into part number or document work order purchase order sales order material requisition number s transaction log detail Transactions are listed in descending date and time sequence This allows you to view the most recent transactions first and lists a running on hand balance of the part over time Summarize History into User Definable Categories Transactions may be summarized into user definable categories for each month of the year default set of categories are supplied which allows you to view the Production Shipments Issues Receipts and Ending Inventory Balance for each month of the year This is no limit to the number of years of history you may retain Other Features The user can define which commands they wish to archive This eliminates the need to store cost adjustments account changes or location transactions that do not effect the parts usage inquiry screens provide 80 column and 132 column view with output options You may define how usage is calculated The system contains the defaults of which commands in Manman effect parts usage You may choose to include other commands such as cycle counts in your monthly usage numbers to best suit your
30. the transaction log data base If you selected option 1 the current transaction log file is read since the point you last ran this utility The new records are written to the transaction log data base If you were to open one or more new transaction logs since the last time this utility was run the program recognizes this and continues incrementing the transaction log number it is reading until all records in the current transaction log have been downloaded Files Accessed TXLCMD Transaction Log Command file TXLDET Transaction Log Detail file updated TXLMAS Transaction Log Master file updated Inventory Usage System 892 Calculate onthly Usage Record The Inventory Usage System contains a file TXLUSG which will store your last 3 years 36 monthly buckets usage of part number This command reads the downloaded transaction log detail and calculates monthly usage based on values in the Command Master file The Command Master File has record for each command in the data base and indicator as to whether this command should be used to calculate usage The standard ASK usage defaults are preloaded into the Command Master File You must have downloaded your transaction log history using command UT 891 before running this command You may view the results of how usage was calculated using command 11 891 and selecting the usage listing option Prompts THIS PROGRAM RECALCULATES THE MONTHLY USAGE FILE CONTINUE Y
31. ths of a parts usage and display a total yearly usage C New command to summarize transactions accross data bases Inventory Usage System Enhancements M ade new command 11 893 has been added to the product which will allow you to view parts transaction log entries in multiple manufacturing data bases If you are multiplant user or simply have more than one manufacturing data base and you use the same part numbers in your data bases this command will extract the transaction log detail from all data bases and display it to you in descending date and time sequence Features of Inventory Usage System Release 2 0 New option to delete transaction log details new option has been added to program UT 891 download transaction log to the data base to purge old transaction logs from the data If you select this option the program will prompt you for beginning and ending transaction log number to delete B New calculation option for Usage history The command UT 892 calculate Usage history now has an option to recalculate the current years usage history rather than al of the years usage history on file This allows users to retain a small number of transaction logs in the data base and still retain the prior years usage history as well Inventory Usage System The Transaction L og Data Base The transaction log data base is the key component of the Inventory Usage System The transaction log data base
32. to the transaction log data base 2 00 you wish to include this command in your usage calculations The data base is preloaded with how Manman normally calculates a part s usage There are other commands TR 100 cycle count a part for example which you may want to include in your usage calculations Therefore you can have control over how you feel usage would be best calculated in your environment 3 What category does this command represent Each of the 140 commands is assigned a default category There are eight default categories that come predefined for each command in the data base ACCOUNTI NG Account number changes cost changes and commands with no effect on usage NV ADJUST Inventory adjustment transactions I SSUES Commands that issue parts to work orders PRODUCTI ON Work order completions where the part number in the transaction log is the assembl y RECEI PTS Purchase Order receipt commands RETURNS Purchase Order return commands SCRAP Scrap commands SHI PMENTS Shi pment commands You may define up to twenty categories of your own to customize your environment Transaction log history is summarized by category using command LI 892 Inventory Usage System Dataset TXLCMD TXCCMD 06 Command Number TXCDESC U30 Command Description TXCMDKEP 1 Store transaction detail of this command TXASSEMB 11 Assembly completion 1 0 no TXUSGFLG 1 Effect usage 1 5 0 no TXCATEG U10 Command Category TXCF
Download Pdf Manuals
Related Search