Home

AS/400 - Acclaim Software

1. ne record Logical File s CSSTREG for every physical count transaction updated Key Field s RCCOMP RCITEM RCDATE YMD FIELD FIELD LENGTH DESCRIPTION 3 Company code 15 Item number 1 Transaction type C 9 2 Quantity adjusted 6 0 Date counted 3 Stock unit of measure File Name CSSTREGB Record Format TREGBREC E H iD NO FMT NAME BYTES A RBCOMP 3 A RBITE 15 A RBTYPE 1 P RBOTY 5 N RBDATE 6 Logical File s CSSTREG for every end of month balance updated DATE YMD Key Field s RBCOMP RBITEM R FIELD FIELD LENGTH DESCRIPTION 3 Company code 15 Item number ae Transaction type T 9 2 End of month balance 6 0 End of month date Section 1 Page 105 Introduction System Description LE LAY OUTS Transaction Register History Files This file contains one record File Name Record Forma FMT PAP Pr PUP PP CSSTRI Tes gura E Continued or every transfer from transaction updated GF TREGFREC NO BYTES 3 15 1 5 3 8 15 6 3 Logical
2. Program Name Description INV601 Print count sheets INV602 Phvsical count entrv INV603 Print phvsical count edit INV604 Print difference report INV605 Phvsical count update PARAM1 Read control file and place parameters from last run into the Local Data Area PARAM2 Update parameters from last run into control file Section 1 Page 110 Introduction System Description CL Program Descriptions Description Switch to Inventory Control library and main menu Print item master maintenance listing CL Prog Name INSTALL Install STRINV command into OGPL INV INV101CL Company master file maintenance INV102CL Item master file maintenance INV103CL Remove deleted items INV103P Display prompt screen for INV103 INV104CL Purge transaction register INV104P Display prompt screen for INV104 INV112CL INV120CL Enter application options NV201CL Transaction entry INV202CL Print transaction edit INV202P Display prompt screen for INV202 INV203CL Transaction update INV203P Display prompt screen for INV203 INV204CL End of month processing INV204P Display prompt screen for INV204 INV205CL End of year processing INV205P Display prompt screen for INV205 INV301CL Item master inquiry Section 1 Page 111 Introduction System Description IN
3. CLASS 2 B LOC SHIPPING COMP DTX TEM S432S0000 DESC SOL SOFFIT SAND U M PC CLASS 2 B LOC SHIPPING COMP DTX TEM S433B0000 U M PC LOC PACKAGI DESC VENT SOFFIT BROWN COMP DTX TEM S433P0000 U M PC DESC VENT SOFFIT PEBBLE CLASS 2 B tem Bin Labels Section 1 Page 88 Introduction System Description LOC PACKAGING Section 1 Page 89 Introduction System This fi File Name Record Format Key Field s FMT PPZPZPPPPPPPPA APPPPPPPPP NAME COCOMP CONAME COMETH COADRI COADR2 COCI COSTTE COZIP COAUPO CONXTP COPRTP COSHA1 COSHA2 COSHCT COSHST COSHZP COBI COAUOR CONXTO COPRTO CONXTI COPRTI COTERM Description CSSCO D LAYOUTS Company Master File COMPR EC COCO NO BYTE 30 30 30 20 10 30 30 20 10 Hj ELD ENGTH E E 30 30 30 20 10 30 30 20 10 Section 1 Page 90 le contains one record for every company entered FIELD DESCRIPTION Company code Company name
4. Enter YES if you wish to hold the printout on ing at a later time The default is NO Introduction System Description Explanation of command and function keys available F3 Cancel this job Section 1 Page 43 Introduction System Description Physical count entry Option 2 on the Physical Processing INV6 menu Add revise or delete physical count transactions Explanation of entry fields Record number In ADD mode this number is automatically incremented with each transaction entered In UPDATE mode you must enter a record number to access a previously entered transaction Company code Enter a valid company code During ADD mode this field is automatically duplicated from the previously entered transaction however you may type over this entry if you wish to enter a different company code Item number Enter a valid item number for this company Delete code If the transaction has been deleted this field will be displayed with a D To un delete this transaction enter a blank Count Enter the physical count in stock units Two decimal places are allowed Date counted Enter the date of count The default is today s date Explanation of command keys available F3 End the job F10 Switch to ADD mode F11 Switch to UPDATE mode F12 Return to transaction entry screen F23 Delete this transaction Section 1 Page 44 Introducti
5. SAN ANTONIO ABOVE MAXIMUM STK QTY QTY QTY QTY BACK QTY MAXIMUM DATE OF ITEM NUMBER DESCRIPTION CLASS VENDOR U M ON HAND ON ORDER RESERVED ORDERED AVAIL QTY LAST SALE S379F0000 2 A A11023 FT 60 00 30 00 00 00 90 00 100 00 9 30 88 FP 14 UNDERLAXMENT 5430P0000 1 A C40111 EA 11 00 100 00 00 00 111 00 100 00 8 17 88 D 5 SIDING PEBBLE 430S0000 1 A A11023 EA 5 00 00 00 00 5 00 50 00 6 12 88 D 5 SIDING SAND S43350000 2 B D23445 FT 144 00 00 00 00 144 00 500 00 9 25 88 VENT SOFFIT PEBBLE S439P0000 3 A A11023 EA 240 00 00 00 00 240 00 1000 00 0 05 88 TR PEBBLE S448B0000 4 C R20010 FT 2500 00 00 00 00 2500 00 2000 00 0 07 88 COIL 24 BROWN 5448P0000 4 C R20010 FT 00 2500 00 00 00 2500 00 2000 00 0 07 88 COIL 24 PEBBLE S494B0000 1 A A11023 EA 100 00 100 00 00 00 200 00 500 00 5 31 88 CAULK BROWN TOO3A0000 2 A B30010 EA 37 00 100 00 00 00 137 00 200 00 8 31 88 DISPENSER TOO4A0000 2 B30010 CAN 125 00 00 00 00 125 00 500 00 9 01 88 ALUMINUM POLISH T006A0000 2 C B30010 SET 5 00 10 00 00 00 15 00 100 00 9 15 88 SUPPORT BLOCKS r100A0000 1 A C40111 EA 20 00 00 00 00 20 00 100 00 0 5 88 FLAG STOP r101A0000 LFA D30000 EA 5 00 5 00 00 00 10 00 00 0 5 88 CUTTING UNIT r121A0000 28 K10020 SET 00 00 00 00 00 100 00 9 20 88 CAST ALUMINUM STOP Section l Page 79 Introduction System Description PAGE 1 DATE 10 17 88 STOCK ST
6. below minimum wish to run this job in un in batch enter tput queue to ault output queue t lines per inch f characters per inch to use The ter the number of copies to be printed Introduction System Description Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 58 Introduction System Option 4 on the Print a list of items wii Explanation of Sort sequence number by item number Company code blank for ALL this entry blank to print for to print Description Reports screen prompts INV4 menu th inventory abov Enter 2 to sort by class The default is 1 Print only items with inventory above maximum quant tity wish to print The default is Y Run in batch batch mode Job queue the job queue to run from The default is Y all companies items t all items with an asterisk beside those Printer output queue place this report on Lines per inch The default is 6 Characters per inch The default Form type is 10 default is STD Copies The default is 01 Section 1 Page 59 E This entry defaults Excess inventory report th suggested maximum Enter 1 to print the
7. Form type default is STD Copies to sort by class The default is 1 to print for default is Y CJ 109 run from on is 10 The default is 01 Hold spooled file the output queue for printing all companies This entry defaults Enter Y at a later tim by item number If you entered YES to run in batch The default is QBATCH Enter the to Enter 1 to print the report sorted by item Enter 3 to sort by vendor Enter a valid company code to print only the items for that company The default is to print all or leave Enter YES if you wish to run this job in enter name of the output queue to your default output queue Enter the number of print lines per inch Enter the number of characters per inch Enter a special form type to use The Enter the number of copies to be printed ES if you wish to hold the printout on The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 61 Introduction System Description Inventory valuation report Option 6 on the Reports INV4 menu Print the value of current inventory according to the cost method used for each company Explanation of screen prompts Sort sequence Enter 1 to print the report sorted by item number Enter 2 to sort by class by item number Enter 3 to sort by vendor by i
8. RONDE onth to date quantity sold onth to date sales amount onth to date cost of sales Year to date quantity sold Year Year Last Last Last to date sales amount to date cost of sales year quantity sold year sales amount year cost of sales Current LIFO value Current LIFO layer Current FIFO value Starting FIFO layer Ending FIFO layer Section 1 Page 93 Introduction System Description This file contains one record LE LAYOUTS Transaction Entry Files for every sale transaction entered File Name CSSTRANS Logical File s CSSTRAN CSSTRANU Record Format TRANSREC Key Field s TSRECN FIELD NO FIELD FIELD EMT NAME BYTES LENGTH DESCRIPTION A TSDELT 1 1 Delete code N TSRECN 5 5 0 Record number A TSCOMP 3 3 Company code A TSITE 15 15 Item number A TSTYPE 1 i Transaction type S P TSQTY 5 9 2 Quantity sold P TSUPRC 5 9 3 Unit price A TSCUST 8 8 Customer number A TSINNO 8 8 Invoice number P TSDATE 4 6 0 Date sold This file contains one record for every receipt transaction entered File Name
9. to UPDATE mode this transaction to transaction entry screen Section 1 Page 36 this t The Introduction System Description Print transaction edit Option 2 on the Processing INV2 menu Print an edit of all transactions entered Explanation of screen prompts Run in batch batch mode The default is Y Job queue the job queue to run from Printer output queue E ep If you entered Y The default is QBATCH Enter the place this report on This entry defaults to Lines per inch The default is 6 Characters per inch The default is 10 Form type default is STD Copies The default is 01 Hold spooled file Enter the ter the CJ 3 E 3 ti the output queue for printing at a later tim nam you num num ber o ter a special fo nter the number o ber of from this workstation Enter YES if you wish to run this job in ES to run in batch enter e of the output queue to r default output queue print lines per inch characters per inch rm type to use The copies to be printed Enter YES if you wish to hold the printout on The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 37 Introduction System Description Option 3 on the Processing Transaction updat INV2 menu
10. Inventory Control Release 2 0 User s Manual for the AS 400 A Product of Acclaim Software formerly Customized Software Support 1306 Cantwell Ave SW Decatur AL 35601 256 306 0783 FAX 256 350 5129 Web www acclaim software com Copyright 1988 1998 Acclaim Software PART 1 INSTALLATION AND OPERATION Section 1 System Description Tptroduetion ia ia Package Features What s New in This Release Section 2 Installing the Package Installation Checklist Section 3 Operating Instructions A Getting Started B Application options C File Maintenance Company master Item master ooo Remove deleted items Purge transaction regis D Processing Menu iaa a Transaction entry Print transaction edit Transaction update End of month processing End of year processing OF CONT ti pa TS ECT a A a n E Le TABLE OF CONT ti pa TS ERystical count SOLE il Ke ss tests Print physical Count dt eat Print difference report ossis eirs srties te Physical count update 223 ri ls de Ses Inquiry Item MASTER e A a A A ae Transaction register sw ia i i a al es F Reports Menu 4 oscar ea aaa ta See e a o eta Ses Etem ma step listi gn A ei ee dd e te A ete ia Item price AL SCINOO sars dB ta tas ee a gia Item re 0rder
11. 00 00 34 00 T006A0000 SUPPORT BLOCKS 2 C PRODUCTION SET 10 00 100 00 00 00 10 00 Section 1 Page 80 Introduction System Description TOO9A0000 MASTIC STICK B R10000 TOOL SHOP EA 1 00 500 00 00 00 501 00 TO10A0000 ACRYLIC PANEL CUTTER A Z10000 TOOL SHOP EA 00 5 00 00 00 5 00 T100A0000 FLAG STOP E A11023 SHIPPING EA 10 00 00 00 00 0 00 T101A0000 CUTTING UNIT A C20000 TOOL SHOP EA 1 00 3 00 00 00 4 00 T105A0000 GUAGE TRACK 2 A SHIPPING ET 00 00 00 00 00 T121A0000 CAST ALUMINUM STOP 2 A B10010 SHIPPING SET 10 00 10 00 00 00 20 00 T122A0000 8 IN BLADE SHARPENER 1 A A11023 TOOL SHOP EA 5 00 00 00 00 5 00 T123A0000 10 IN BLADE SHARPENER 1 A C20000 TOOL SHOP EA 5 00 5 00 00 00 0 00 Section 1 Page 81 Introduction System Description PAGE L DATE 10 17 88 INVENTORY VALUATION REPORT REPORT ID INV406 LIFO METHOD TIME 14 26 21 COMPANY RNC RALEIGH STK QTY INVENTORY LAYER INFORMATION ITEM NUMBER DESCRIPTION CLASS VENDOR U M ON HAND VALUE LAYER UNITS UNIT COST S379F0000 FP 14 UNDERLAYMENT 2 A A11023 FT 50 00 250 00 50 00 5 000 5430P0000 D 5 SIDING PEBBLE 1 A K10020 EA 10 00 150 00 8 00 14 500 2 00 17 000 543050000 D 5 SIDING SAND 1 A B10010 EA 00 5432B0000 SOL SOFFIT BROWN 2 B A11023 FT 5 00 7 00 2 00 250 3 00 500 5433P0000 VENT SOFFIT PEBBLE 2 B B10010 FT 100 00 138 40 20 00 150 20 00 250 20 00 500 20 00 470 20 00 550 543350000 VENT SOF
12. CSSTRANR Logical File s CSSTRAN CSSTRANU Record Format TRANRREC Key Field s TRRECN FIELD NO FIELD FIELD FMT NAME BYTES LENGTH DESCRIPTION A TRDELT 1 1 Delete code N TRRECN 5 570 Record number A TRCOMP 3 3 Company code A TRITE 1 5 EG Item number A TRTYPE el T Transaction type R P TROTY 5 9 2 Quantity received P TRUCST 5 9 3 Unit cost A TRVEND 8 8 Vendor number A TRREFN 8 8 Reference number P TRDATE 4 6 0 Date received Continued on next page Section 1 Page 94 Introduction System Description This file contains one record E L E LAYOUTS Transaction Entry Files Continued for every adjustment transaction entered File Name CSSTRANA Record Format TRANAREC FIELD NO FMT LENGTH BYTES Ll TADELT TARECN TACOMP TATTE TATYPE TAOHAD TAOOAD TAREFN TACMNT TADATE bh 4 10000 Radaawd0a Ra Uprprvuuprrrap H This file contains one record Logical File s CSSTRAN CSSTRANU Key Field s TARECN FIELD FIELD ENGTH DESCRIPTION Delete code Record number Company code Item number Transaction type A On hand quantity adjusted On order quantity adjusted Reference number Comment s Reason Date adjusted OT s H s H O WO 0 OMMNNHUVVOKK for every purchase transaction entered File Name CSSTRA
13. Costing method A F L R Company address line 1 Company address line 2 Company city Company state Company zip code Automatic PO numbers Next PO number Print name address on PO Ship to address line 1 Ship to address line 2 Ship to city Ship to state Ship to zip code Blind receipts entry Automatic order numbers Next order number Print name addr on order Next invoice number Print name addr on invoice Terms code Introduction System Description I E LAYOUTS Item Master File This file contains one record for every item entered File Name CSSITEM Record Format TEMREC Key Field s TCOMP ITITEM FIELD NO FIELD FIELD FMT NAME BYTES LENGTH DESCRIPTION A TDELT il il Delete code A TCOMP 3 3 Companv code A TITE ES 15 Item number A TDESC 25 25 Description A ITCLAS 5 5 Class A TLOC 10 10 Location P IWEHT lg 9 4 Weight A TSTU 3 3 Stock unit of measure A ITPUU 3 3 Purchasing unit of measure A TSEU 3 3 Selling unit of measure P TPERP 4 Irz Stock units per Purch U M P TPERS 4 EZ Stock units per Selling U M A TATT 15 15 A
14. S xcess inventory tock status Inventory valuation Sales analysis Transaction register Bin item labels Physical inventory count sheets Book vs Physical difference Proof lists of all on line file maintenance Reports include multiple sort options with company selection All files are externally defined so that user may create their own reports with Query SQL etc Section 1 Page 8 Introduction System Description What s New in This Release Application options Specify a default company code for all Option to use a single transaction fil separate transaction file for each user Data dictionary entry and inquiry screens le or the current method of using a Default entries may be specified for item and transaction entries Option to skip certain entry fields on item and transaction entry screens User may exit program from directory list screens Physical count now includes option to s All programs have been modified to accep 12 31 99 Section 1 Page 9 non counted items to zero and process dates past Introduction System Th tape Description Installation Checklist ntire Inventory Control library named CSSINV is contained on 2 diskettes or 1 This includes the complete source code NEW INSTALLATION Ts Mount the first diskette or tape Enter RSTLI E B S
15. Update transactions entered from this workstation Explanation of screen prompts Run in batch batch mode Job queue the job queue to run from Print update listing showing updates Printer output queue place this report Lines per inch The default is 6 Characters per inch The default Form type default is STD Copies The default is 01 Hold spooled file is 10 The default is to on order on If you entered Y is QBATCH The default ti Enter the n This entrv defaults Enter the n Enter the n Ent CJ 3 and on hand inventory e nter YES if you wish to print a report The default is YES ES to run in batch Enter YES if you wish to run this job in enter ame of the output queue to umber o umber o ter a special fo ter the number o the output queue for printing at a later tim Explanation of command and function keys available E3 Cancel this job Section 1 Page 38 to your default output queue f print lines per inch f characters per inch rm type to use The f copies to be printed Enter YES if you wish to hold the printout on The default is NO Introduction System Description End of month processing Option 4 on the Processing INV2 menu Perform end of month maintenance on master files This step will clear the month to
16. selling unit For example the stock unit is EA the selling unit of measure is CAS and there are 120 EA per CAS therefore you would enter 120 into this field Two decimal places are allowed This entry defaults to 1 00 If you wish to reference this item with another item number serial company id f etc enter an alternate number in this field Enter a vendor number where this item is purchased This entry is optional however many reports allow sorting by vendor therefore you may wish to use this field Alternate vendor If you purchase this item from another vendor number Vendor s item number Lead time Economic order quantity Minimum quantity Enter on hand Maximum quantity Enter on hand List price Enter Unit price 1 5 enter the second vendor number Enter the item number which the vendor uses to identify this item Enter the number of days weeks months etc that it takes to receive this item after ordering Enter the optimum quantity in purchasing units that you re order this item in Two decimal places are allowed a minimum quantity in stock units that this item should not fall below This quantity is used when printing the item re order report Two decimal places are allowed a maximum quantity in stock units that this item should not exceed This quantity is used when printing the excess invento
17. 2 PEBBLE B PC 250 000 240 000 230 000 220 000 210 000 200 000 544450000 J CHAN 1 2 SAND B PC 250 000 240 000 230 000 220 000 210 000 200 000 5448B0000 COIL 24 BROWN 4 C FT 24 950 23 000 22 750 20 000 9 000 8 000 5448P0000 COIL 24 PEBBLE 4 C FT 24 950 23 000 22 750 20 000 9 000 8 000 5494B0000 CAULK BROWN A A11023 EA 2 125 2 000 1 825 1 700 1575 450 5494P0000 CAULK PEBBLE A EA 2 125 2 000 1 825 1 700 LSS 450 TOO3A0000 DISPENSER 2 A EA 3 000 3 000 2 950 2 800 2 700 2 600 TOO4A0000 ALUMINUM POLISH EG CAS 24 000 22 500 20 000 18 500 16 000 4 000 T006A0000 SUPPORT BLOCKS 250 SET 6 000 5 500 5 000 4 500 4 250 4 000 Section 1 Page 76 Introduction System Description TOO9A0000 MASTIC STICK B EA 2 950 2 500 2 250 2 000 1 750 650 TO10A0000 ACRYLIC PANEL CUTTER A EA 950 850 800 750 700 650 T100A0000 FLAG STOP E EA 700 000 685 000 650 000 640 000 625 000 600 000 T101A0000 CUTTING UNIT A EA 1495 000 1400 000 1375 000 1300 000 1250 000 225 000 T105A0000 GUAGE TRACK 2 A FT 65 000 60 000 55 000 50 000 45 000 40 000 T121A0000 CAST ALUMINUM STOP 2 A SET 10 000 9 000 8 500 8 000 7 500 7 000 T122A0000 8 IN BLADE SHARPENER 1 A EA 30 000 27 000 24 000 21 000 18 000 5 000 T123A0000 10 IN BLADE SHARPENER 1 A EA 30 000 27 000 24 000 21 000 18 000 5 000 Section 1 Page 77 Introduction System Description PAGE l DATE 10 17 88 ITEM RE ORDER REPORT Es TIME 14 26 21 REPORT I
18. Copies the Reports Item master listing INV4 menu screen prompts to sort by class The default is 1 to print for default is Y CJ 109 run from on is 10 The default is 01 Hold spooled file the output queue for printing all companies This entry defaults Enter Y at a later tim listing of inventory items by item number If you entered YES to run in batch The default is QBATCH Enter the to Enter 1 to print the report sorted by item Enter 3 to sort by vendor Enter a valid company code to print only the items for that company The default is to print all or leave Enter YES if you wish to run this job in enter name of the output queue to your default output queue Enter the number of print lines per inch Enter the number of characters per inch Enter a special form type to use The Enter the number of copies to be printed ES if you wish to hold the printout on The default is NO Explanation of command and function keys available F3 Cancel this job Section l Page 55 Introduction System Description Item price listing Option 2 on the Reports INV4 menu Print a listing of selling prices of items Explanation of screen prompts Sort sequence number Enter 2 by item number Company code to blank for ALL print this entry blank Run
19. FIELD LENGTH DESCRIPTION 1 Delete code 570 Record number 3 Company code 15 Item number 1 Transaction type 1 9 2 Quantity issued 8 Reference number 15 Comment s 6 0 Date issued for every transfer transaction entered File Name CSSTRANT Record Format TRANTREC FIELD NO NAME BYTE E H ep TTDELT TTRECN TTCOMP TTITE TTTYPE TTOTY TTTOCO TTREFN TTCMNT TTDATE H 4 0100 A AOT a Re HP PP UPP PAD bh Logical File s CSSTRAN CSSTRANU Key Field s TTRECN FIELD FIELD LENGTH DESCRIPTION 1 Delete code 5 0 Record number 3 Company code 15 Item number HE Transaction type T 92 Quantity transferred 3 To company code 8 Reference number 19 Comment s 6 0 Date transferred Section 1 Page 97 Introduction System Description Section l Page 98 Introduction System Description E L E LAYOUTS Physical Count Entry File This file contains one record for every physical count transaction entered File Name CSSPCNT Record Format PCNTREC Key Field s PCRECN FIELD NO FIELD FIELD FMT NAME BYTES LENGTH DESCRIPTION A PCDELT 1 1 Delete code N PCRECN 5 5 0 Record number A PCCOM
20. File s CSSTREG Key Field s b Section 1 Page 106 RFCOMP RFITEM REDATE YMD ELD FIELD ENGTH DESCRIPTION 3 Companv code 15 Item number 1 Transaction tvpe T 9 2 Quantitv transferred 3 From companv code 8 Reference number 15 Comment s 6 0 Date transferred S Stock unit of measure Introduction System Description LAYOUTS LIFO FIFO Layers File This file contains LIFO cost layers for each item File Name CSSLI Record Format Kev Field s FMT U U Z pp G LD in F NA LFCO LAY LAYO LAYC FO LIFOREC LFCOMP LFITEM LFLAYR NO FIELD FIELD BVTES LENGTH DESCRIPTION 3 3 Companv code 15 15 Item number 3 3 0 Laver number 5 9 2 Quantitv per stock unit 5 9 3 Unit cost per stock unit This file contains FIFO cost layers for each item File Name Record Format Key Field s EMT U U Z p PS in F NA FFCO FF Fed FFI FFI LAY LAYO LAYC CSSFIFO FIFOREC FFCOMP FFITEM FFLAYR NO FIELD FIELD BYTES LENGTH DESCRIPTION 3 3 C
21. GOODS SOLD PROFIT 5379F0000 2 A A11023 FT T D 5 00 35 00 25 00 10 00 28 6 FP 14 UNDERLAYMENT Y T D 10 00 70 00 50 00 20 00 28 6 LAST YR 00 00 00 00 0 5430P0000 1 A K10020 EA T D 3 00 90 00 40 00 50 00 55 6 D 5 SIDING PEBBLE Y T D 3 00 90 00 40 00 50 00 55 6 LAST YR 10 00 200 00 100 00 100 00 50 0 543050000 1 A A11023 EA T D 00 00 00 00 0 D 5 SIDING SAND X T D 00 00 00 00 0 LAST XR 00 00 00 00 0 5432B0000 2 B PC T D 4 00 7 00 5 50 1 50 21 4 SOL SOFFIT BROWN LATED 4 00 7 00 5 50 1 50 21 4 LAST YR 00 00 00 00 0 5433P0000 2 B PE T5D 20 00 40 00 23 00 17 00 42 5 VENT SOFFIT PEBBLE X T D 45 00 89 00 56 00 33 00 IE LAST YR 1020 00 1980 00 1205 00 775 00 39 543350000 2 B PC T D 00 00 00 00 0 VENT SOFFIT SAND Y T D 00 00 00 00 0 LAST XR 00 00 00 00 0 Section 1 Page 86 Introduction System Description PAGE 1 DATE 7 17 88 TRANSACTION REGISTER E TIME 14 26 21 REPORT ID INV408 COMPANY BAL BIRMINGHAM PRICE STOCK TEM NUMBER DESCRIPTION DATE TYPE QTY U M COST gt REFERENCE QTY U M T100A0000 FLAG STOP 6 24 88 PURCH 50 00 EA 95 000 VEN 12111 PO A1110 T100A0000 FLAG STOP 6 24 88 REC 50 00 EA 95 000 50 00 EA T100A0000 FLAG STOP 6 23 88 TRAN 21 00 EA TO DTX 00 EA T100A0000 FLAG STOP 6 23 88 SALE 25 00 EA 25 000 CUS 11111111 INV 12345678 5 00 BA T100A0000 FLAG STOP 6 24 88 REC 10 00 EA 00 000 10 00 A T100A0000 FLAG STOP 6 24 88 TRAN 10 00
22. LENGTH DESCRIPTION A RICOMP 3 3 Company code A RIITE E5 15 Item number A RITYPE a ii Transaction type 1 P RIQTV 5 9 2 Quantitv issued A RIREFN 8 8 Reference number A RICMNT il 5 15 Comment s N RIDATE 6 6 0 Date issued A RISTU 3 3 Stock unit of measure This file contains one record or every transfer to transaction updated File Name CSSTREGT Logical File s CSSTREG Record Format TREGTREC Key Field s RTCOMP RTITEM RIDATE YMD FIELD NO FIELD FIELD EMT NAME BYTES LENGTH DESCRIPTION A RTCOMP 3 3 Company code A RTITE 15 15 Item number A RTTVPE l L Transaction tvpe T P RTQTY 5 9 2 Quantity transferred A RTTOCO 3 3 To company code A RTREFN 8 8 Reference number A RTCMNT 15 15 Comment s N RTDATE 6 6 0 Date transferred A RTSTU 3 3 Stock unit of measure Section 1 Page 104 Introduction System Description This file contains o File Name CSSTRI Record Format RCCOMP RCITE RCTYPE RCOTY RCDATI RCSTU E Demo Dy pb This file contains o E LE LAYOUTS Transaction Register History Files ne record Continued EGC TREGCREC NO BYTES 3 15 1 5 6 3
23. PANEL CUTTER 1 A TOOL SHOP 2344 EA EA EA T100A0000 FLAG STOP 1 A SHIPPING 89 5000 EA EA EA T101A0000 CUTTING UNIT 1 A TOOL SHOP 550 0000 EA EA EA T105A0000 GUAGE TRACK 2 A SHIPPING 10 0000 FT ET ET T121A0000 CAST ALUMINUM STOP 2 A SHIPPING 25 0000 SET SET SET Section 1 Page 74 Introduction System Description T122A0000 8 IN BLADE SHARPENER 1 A TOOL SHOP 3 0000 EA EA EA T123A0000 10 IN BLADE SHARPENER 1 A TOOL SHOP 3 0000 EA EA EA Section 1 Page 75 Introduction System Description PAGE al DATE 10 17 88 ITEM PRICE LISTING TIME 14 26 21 REPORT ID INV402 COMPANY DTX DALLAS SELLING LIST UNIT UNIT UNIT UNIT UNIT ITEM NUMBER DESCRIPTION CLASS VENDOR U M PRICE PRICE 1 PRICE 2 PRICE 3 PRICE 4 PRICE 5 S379F0000 FP 14 UNDERLAYMENT 2 A A11023 FT 7 390 7 000 6 500 6 000 5 500 5 000 S430P0000 D 5 SIDING PEBBLE l A K10020 EA 30 000 28 000 26 000 24 000 22 000 20 000 543050000 D 5 SIDING SAND 1 A A11023 EA 30 000 28 000 26 000 24 000 22 000 20 000 5432B0000 SOL SOFFIT BROWN 2 B PC 950 1 850 1 750 650 1 550 1 450 5433P0000 VENT SOFFIT PEBBLE 2 B PC 950 1 850 1 750 650 1 550 1 450 543350000 VENT SOFFIT SAND 2 B PC 950 1 850 1 750 650 1 550 1 450 5439P0000 TRIM PEBBLE 3 A A11023 EA 4 250 4 000 3 750 3 500 3 250 3 150 S43950000 TRIM SAND 3 A 12222057 EA 10 000 9 000 8 000 7 500 7 000 6 750 5444B0000 J CHAN 1 2 BROWN A PC 250 000 240 000 230 000 220 000 210 000 200 000 5444P0000 J CHAN 1
24. TIME 14 26 21 REPORT ID INV401 COMPANY DTX DALLAS STK PUR SELL ALTERNATE VENDOR ITEM NUMBER DESCRIPTION CLASS LOCATION WEIGHT U M U M U M ITEM NUMBER NUMBER S379F0000 FP 14 UNDERLAYMENT 2 A PACKAGING 4 0000 FT YD ET UNDERFP14 A11023 3 00 FT S430P0000 D 5 SIDING PEBBLE 1 A PACKAGING 25 5000 EA EA EA K10020 S43050000 D 5 SIDING SAND 1 A SHIPPING 25 5000 EA EA EA A11023 S432B0000 SOL SOFFIT BROWN 2 B PRODUCTION 2 0000 FT PC PC SOLSOFFIT 12 00 FT 12 00 FT 5433P0000 VENT SOFFIT PEBBLE 2 B PRODUCTION 2 0000 FT PC PC 12 00 FT 12 00 FT 543350000 VENT SOFFIT SAND 2 B PRODUCTION 2 0000 FT PC PC 12 00 FT 120 07 EFT S439P0000 TRIM PEBBLE 3 A SHIPPING 5 2500 EA BOX EA TRIMPEBBLE A11023 24 00 EA 543950000 TRIM SAND 3 A SHIPPING 5 2500 EA BOX EA TRIMSAND 12222057 24 00 EA 5444B0000 J CHAN 1 2 BROWN A PACKAGING 13542322 PE PC PC 5444P0000 J CHAN 1 2 PEBBLE B PACKAGING 135 2322 PC PC PC 544450000 J CHAN 1 2 SAND B PACKAGING 13532322 PC PC PC 5448B0000 COIL 24 BROWN 4 C COIL METAL 12 0000 FT RL FT 500 00 FT 5448P0000 COIL 24 PEBBLE 4 C COIL METAL 12 0000 FT RL ET 500 00 FT S494B0000 CAULK BROWN A PACKAGING 1 5000 EA EA EA A11023 5494P0000 CAULK PEBBLE A PACKAGING 1 5000 EA EA EA TOO3A0000 DISPENSER 2 A PRODUCTION 2 2505 EA EA EA TOO4A0000 ALUMINUM POLISH 256 PRODUCTION 34550 CAN CAS CAS 10 00 CAN 10 00 CAN T006A0000 SUPPORT BLOCKS 2 C PRODUCTION 68000 SET SET SET TOO9A0000 MASTIC STICK 1 B TOOL SHOP 1 0000 EA EA EA TO10A0000 ACRYLIC
25. Ts T Company code to print blank for ALL Enter this entry blank to print for all co Include non counted items Enter 1 to print the report sorted by sort by item number alone The default a valid company code to print only the items for that company or leave mpanies The default is to print all ti nter YES to include items that were not counted The report will show adjustments to set all non counted items to zero inventory Enter NO to show only co NO Run in batch batch mode The default is Y Job queue E ep the job queue to run from The defa Printer output queue place this report on Lines per inch The default is 6 Characters per inch The default is 10 Form tvpe default is STD Copies The default is 01 This entry de Section 1 Page 47 unted items on the report The default is m B ter YES if you wish to run this job in If you entered YES to run in batch enter ult is QBATCH m Enter the name of the output queue to faults to your default output queue m la ter the number of print lines per inch E 3 ter the number of characters per inch E 3 ter a special form type to use The E 3 ter the number of copies to be printed Introduction System Description Hold spooled file Enter YES if you wish to hold the
26. dat any item with activity Please note It is not mandatory correct date the end of the month and update transaci However you may want sales and cost of goods sold amounts Also an end of month balance transaction will be added to the transaction register for that this step be run exactly at tions for the remainder t to change the session date to the end of month date before calling this the transaction regist You may require time to enter of the month step so that ter balance will reference the This is only a recommendation We do strongly suggest that you run this step every month in order to maintain the accuracy of sales analysis figures Explanation of screen prompts Run in batch batch mode The default is Y Job queue the job queue to run from Enter YES if you E ep If you entered Y The default is QBATCH Explanation of command and function keys available F3 Cancel this job Section 1 Page 39 wish to run this job in ES to run in batch enter Introduction System Description End of year processing Option 5 on the Processing INV2 menu Perform end of year maintenance on master files This step will transfer year to date sales and cost of goods data into the last year fields and the year to date data will be cleared Explanation of screen prompts Run in batch Ent
27. files Restore master files 3 Backup inventorv librarv N 10 Data dictionary 90 Sign off Selection or command gt The following menu options are available 1 Backup all CSS master files CSSDATA to save device 2 Restore all CSS master files CSSDATA to disk B Backup the Inventorv Control librarv CSSINV to save device 10 En options to skip the entrv of certain entries Section 1 Page 71 ter or revise default data for item and transaction entry screens Set Introduction System Description Options 1 3 utilize the AS 400 SAVLIB and RSTLIB commands Please consult your AS 400 manuals for detailed information on these commands Section 1 Page 72 Introduction System Description Data dictionary Option 10 on the Utilities INV5 menu Enter or revise default data for item and transaction entry screens Set options to skip the entry of certain entries Explanation of entry fields Default data nter the default data that will be displayed for item additions and or new transactions E Skip entry Y N Enter Y to skip and prevent the entry of data into this field Enter N to allow entry The default is N Explanation of command keys available F3 End the job F12 Return to previous entry screen Section 1 Page 73 Introduction System Description PAGE 1 DATE 10 17 88 ITEM MASTER LISTING
28. generated for you if you have the CSS Order Entry Invoicing package Purchase order transactions record what you have on order On hand inventory is not affected Reports show what you have on order as well as what you have on hand Purchase transactions are automatically generated for you if you have the CSS Purchase Order package Receipt transactions ar ntered whenever you receive goods from a vendor On hand is increased and on order is decreased On order can never fall below zero If you receive more than what is on order the on order quantity is set to zero Receipt transactions are automatically generated for you if you have the CSS Purchase Order package Issue transactions decrease on hand inventory but do not affect sales quantities or Section 1 Page 30 Introduction System Description amounts Issues are used when inventory is utilized for a purpose other than a sale For example if an item is used to make another item an issue would be appropriate Section 1 Page 31 Introduction System Description T Transfer transactions are used to move inventory from one company to another company A transfer transaction creates two transaction register records a decrease from one company and an increase to the other company A Adjustment transactions can be used to correct errors in on hand and or on order inventory balances Please note It may be easier to maintain inv
29. in batch batch mode The Job queue the job queue to Printer output queue place this report on This entry d Lines per inch The defaul lt is 6 Characters per inch The defaul Form type default is STD Copies The defaul Hold spooled fil the output queue for printing Le to sort by class The default is 1 to print for all companies default is Y E ep It is 10 lt is O1 Enter bv item number Enter 1 to print the report sorted bv item Enter 3 to sort bv vendor Enter a valid companv code to print onlv the items for that companv or leave If you entered Y run from The default efa ti n XVES if vou wish to hold the printout on The default is NO CJ 3 E 3 Enter Y t is ter ults ter Ler OBATCH the number o the number o ter a special fo ter the number o at a later tim Explanation of command and function keys available F3 Cancel this job Section 1 Page 56 ES tor Y the name of the out to your default o rm type The default is to print all ES if you wish to run this job in un in batch enter tput queue to utput queue print lines per inch characi ters per inch to use The f copies to be printed Introduction System Option 3 on the Description Item r Reports INV4 menu orde
30. to identify the class or category for this item This entry is optional however some reports allow sorting by class therefore you may want to use this field ti n opt ter a warehouse location This entry is tional however some reports allow sorting by location therefore you may want to use this field Enter the weight of this item Four decimal places are allowed For example an entry of 205 would yield 205 0000 Enter the unit of measure which describes how the item is stocked and counted This entry is required Enter the unit of measure which describes how the item is purchased If not entered this entry defaults to the stock unit of measure Enter the number of stock units contained in one Section 1 Page 19 Introduction System Description purchasing unit purchasing unit For example the stock unit of measure is EA the purchasing unit of measure is BOX and there are 12 EA per BOX therefore you would enter 12 into this field Two decimal places are allowed This entry defaults to 1 00 Selling unit of Enter the unit of measure which describes how the measure item is sold If not entered this entry defaults to the stock unit of measure Section 1 Page 20 Introduction System Description Stock units per selling unit Alternate item number Vendor number Enter the number of stock units contained in one
31. to run in batch enter the job queue to run from The default is QBATCH Explanation of command and function keys available F3 Cancel this job Section 1 Page 26 Introduction System Description Purge transaction register Option 4 on the File Maintenance INV1 menu Remove transactions from the transaction register history file within a range of dates Explanation of screen prompts Beginning date to purge Enter the date of the first transactions you wish to remove ter the date of the last transactions E 3 Ending date to purge you wish to remove ter YES if you wish to run this job in E 3 Run in batch batch mode The default is Y CJ 109 Job queue If you entered YES to run in batch enter the job queue to run from The default is QBATCH Explanation of command and function keys available F3 Cancel this job Section 1 Page 27 Introduction System Description Processing menu From this menu you can make selections regarding the entry edit and update of transactions end of month and end of year processing as well as access to the physical count processing menu INV2 INVENTORY CONTROL Processing Menu Select one of the following Transaction entry Print transaction edit Transaction update End of month processing End of year processing Physical Processing menu NO FPF WN FE 90 Sign off Selection o
32. 0 225 00 CLASS TOTAL 225 00 5432B0000 SOL SOFFIT BROWN 2 B A11023 FT 5 00 2 125 10 63 5433P0000 VENT SOFFIT PEBBLE 2 B B10010 FT 100 00 1 099 109 90 543350000 VENT SOFFIT SAND 2 B FT 00 000 00 CLASS TOTAL 120 53 5439P0000 TRIM PEBBLE 3 A A11023 EA 24 00 2 850 68 40 543950000 TRIM SAND SA C47567 EA 00 000 00 CLASS TOTAL 68 40 COMPANY TOTAL 603 93 Section 1 Page 84 Introduction System Description PAGE 1 DATE 10 17 88 INVENTORY VALUATION REPORT REPORT ID INV406 REPLACEMENT COST METHOD TIME 14 26 21 COMPANY RNC RALEIGH STK QTY REPLACEMENT INVENTORY ITEM NUMBER DESCRIPTION CLASS VENDOR U M ON HAND COST VALUE 5430P0000 D 5 SIDING PEBBLE 1 A K10020 EA 10 00 20 000 200 00 543050000 D 5 SIDING SAND 1 A B10010 EA 00 000 00 CLASS TOTAL 200 00 S379F0000 FP 14 UNDERLAYMENT 2 A A11023 FT 50 00 5 000 250 00 CLASS TOTAL 250 00 5432B0000 SOL SOFFIT BROWN 2 B A11023 FT 5 00 2 500 12 50 5433P0000 VENT SOFFIT PEBBLE 2 B B10010 FT 100 00 1 000 100 00 543350000 VENT SOFFIT SAND 2 B FT 00 000 00 CLASS TOTAL 112450 5439P0000 TRIM PEBBLE 3 A A11023 EA 24 00 3 000 72 00 543950000 TRIM SAND 3 A C47567 EA 00 000 00 CLASS TOTAL 72 00 COMPANY TOTAL 634 50 Section 1 Page 85 Introduction System Description PAGE L DATE 10 17 88 SALES ANALYSIS REPORT TIME 14 26 21 REPORT ID INV407 COMPANY 101 JACKSONVILLE SELL QTY SALES COST OF GROSS PROFIT ITEM NUMBER DESCRIPTION CLASS VENDOR U M SOLD AMOUNT
33. ATUS REPORT oy TIME 14 26 21 REPORT ID INV405 COMPANY SWA SEATTLE STK QTY QTY QTX BACK QTX QTY ITEM NUMBER DESCRIPTION CLASS VENDOR LOCATION U M ON HAND ON ORDER ORDERED RESERVED AVAIL S379F0000 FP 14 UNDERLAYMENT 2 A A11023 PACKAGING FT 50 00 50 00 00 00 00 00 S430P0000 D 5 SIDING PEBBLE l A K10020 PACKAGING EA 10 00 35 00 00 00 45 00 S43050000 D 5 SIDING SAND 1 A B10010 SHIPPING EA 00 100 00 00 00 00 00 5432B0000 SOL SOFFIT BROWN 2 B A11023 PRODUCTION FT 5 00 5 00 00 00 0 00 5433P0000 VENT SOFFIT PEBBLE 2 B B10010 PRODUCTION FT 100 00 00 00 00 00 00 543350000 VENT SOFFIT SAND 2 B PRODUCTION FT 00 00 00 00 00 5439P0000 TRIM PEBBLE 3 A A11023 SHIPPING EA 24 00 5 00 00 00 29 00 543950000 TRIM SAND 3 A C47567 SHIPPING EA 00 125 00 00 00 125 00 5444B0000 J CHAN 1 2 BROWN A C47567 PACKAGING PC 10 00 00 00 00 10 00 5444P0000 J CHAN 1 2 PEBBLE B B10010 PACKAGING PC 5 00 00 00 00 5 00 544450000 J CHAN 1 2 SAND B PACKAGING PC 00 00 00 00 00 5448B0000 COIL 24 BROWN 4 C K10020 COIL METAL FT 25 00 25 00 00 00 50 00 5448P0000 COIL 24 PEBBLE 4 C K10020 COIL METAL FT 00 25 00 00 00 25 00 5494B0000 CAULK BROWN A B10010 PACKAGING EA 100 00 00 00 00 00 00 5494P0000 CAULK PEBBLE A B10010 PACKAGING EA 75 00 25 00 00 00 00 00 T003A0000 DISPENSER 2 A PRODUCTION EA 00 00 00 00 00 T004A0000 ALUMINUM POLISH EG C20000 PRODUCTION CAN 34 00 00
34. AVLIB CSSINV DEV device name If you DO NOT have the Purchase Order Receiving or Order Entry Invoicing software installed enter the following Enter RSTLIB SAVLIB CSSDATA DEV device name Enter CALL CSSINV INSTALL If you are upgrading from Version 1 0 which runs in the 5 36 environment nter the following Enter CALL CSSINV CONVERT INSTALLING A NEW RELEASE Save the existing Inventory Control library Mount a diskette or tape and key HE ta the following ter SAVLIB LIB CSSINV DEV device name SAVLIB LIB CSSDATA DEV device name Rename the existing Inventory Control library and data library to a different name Key the following Enter RNMOBJ OBJ CSSINV OBJTYPE LIB NEWOBJ CSSINVOLD RNMOBJ OBJ CSSDATA OBJTYPE LIB NEWOBJ CSSDATAOLD Enter RSTLI Mount the first diskette or tape B SAVLIB CSSINV DEV device name If you DO NOT have the Purchase Order Receiving or Order Entry Invoicing software installed enter the following Section 1 Page 10 Introduction System Description Enter RSTLIB SAVLIB CSSDATA DEV device name 6 Enter CALL CSSINV INSTALL When you are satisfied that the new release is operating properly you Can delete the renamed Inventory Control library CSSINVOLD and d
35. D INV403 COMPANY STX SAN ANTONIO BELOW MINIMUM PUR QTX QTY QTY QTY BACK QTY MINIMUM ECONOMIC LEAD VENDOR ITEM NUMBER DESCRIPTION CLASS U M ON HAND ON ORDER RESERVED ORDERED AVAIL QTY ORDER TIME A11023 5379F0000 2 A YD 20 00 10 00 00 00 30 00 25 00 10 00 5 FP 14 UNDERLAXMENT A11023 543050000 ISA EA 5 00 00 00 00 5 00 10 00 20 00 A D 5 SIDING SAND A11023 5439P0000 IZA BOX 10 00 00 00 00 10 00 10 00 10 00 3 TRIM PEBBLE A11023 5494B0000 l A EA 100 00 100 00 00 00 200 00 250 00 200 00 10 CAULK BROWN B30010 T003A0000 2 A EA 37 00 100 00 00 00 137 00 100 00 100 00 DISPENSER B30010 T004A0000 2 C CAS 12 50 00 00 00 12 50 15 00 25 00 5 ALUMINUM POLISH B30010 T006A0000 2 C SET 5 00 10 00 00 00 15 00 10 00 00 SUPPORT BLOCKS C40111 5430P0000 1 A EA 11 00 100 00 00 00 111 00 100 00 50 00 2 D 5 SIDING PEBBLE C40111 T100A0000 1 A EA 20 00 00 00 00 20 00 25 00 30 00 FLAG STOP D23445 543350000 2 B PC 12 00 00 00 00 12 00 100 00 00 4 VENT SOFFIT PEBBLE D30000 T101A0000 ISSA EA 5 00 5 00 00 00 10 00 00 00 CUTTING UNIT 10020 T121A0000 2 A SET 00 00 00 00 00 10 00 10 00 CAST ALUMINUM STOP R20010 S448B0000 4 C RL 5 00 00 00 00 5 00 5 00 5 00 4 COIL 24 BROWN R20010 5448P0000 4 C RL 00 5 00 00 00 5 00 5 00 5 00 4 COIL 24 PEBBLE Section 1 Page 78 Introduction System Description PAGE 1 DATE 10 17 88 EXCESS INVENTORY REPORT TIME 14 26 21 REPORT ID INV404 COMPANY STX
36. Descriptions Cl Prog Name Description INV603P Display prompt screen for INV603 INV604CL Print difference report INV604P Display prompt screen for INV604 INV605CL Physical count update INV605P Display prompt screen for INV605 OE Switch to Order Entry Invoicing library and main menu PARAM1CL Read parameters from control file PARAM2CL Update parameters to control file PO Switch to Purchase Order library and main menu Section 1 Page 115 Introduction System Menu Name Description Menu Descriptions Commands Description for menu option GO CSSINV INVI GO CSSINV INV2 GO CSSINV INV3 GO CSSINV INV4 5 GO CSSINV INV5 20 CALL CSSINV INV120CL 50 GO CSSINV CSS 90 SIGNOFF ain menu Ss 0D DN PP File maintenance menu 1 CALL CSSINV INV101CL 2 CALL CSSINV INV102CL 3 CALL CSSINV INV103P 4 CALL CSSINV INV104P 90 SIGNOFF Processing menu 1 CALL CSSINV INV201CL 2 CALL CSSINV INV202P 3 CALL CSSINV INV203P 4 CALL CSSINV INV204P 5 CALL CSSINV INV205P 6 GO CSSINV INV6 90 SIGNOFF pa CALL CSSINV INV301C 2 CALL CSSINV INV302CI 90 SIGNOFF Inquirv menu CALL CSSINV INV401P CALL CSSINV INV402P CALL CSSINV INV403P CALL CSSINV I
37. EA FROM DTX 10 00 A T100A0000 FLAG STOP 6 24 88 SALE 5 00 EA 15 000 5 00 EA T100A0000 FLAG STOP 7 11 88 REC 20 00 EA 23 000 20 00 EA T100A0000BAL FLAG STOP 7 13 88 39 00 END OF MONTH BALANCE 39 00 A T100A0000 FLAG STOP 7 13 88 SALE 100 00 EA 1 200 00 00 EA T100A0000 FLAG STOP 7 13 88 TRAN 120 00 EA TO DTX 20 00 EA T100A0000 FLAG STOP 7 13 88 COUNT 181 00 EA PHYSICAL COUNT ADJUSTMENT 181 00 EA T101A0000 CUTTING UNIT 6 24 88 PURCH 2 00 EA 1400 000 VEN A11023 PO C1110 T101A0000 CUTTING UNIT 7 01 88 REC 2 00 EA 1400 000 1400 00 EA T105A0000 GUAGE TRACK 7 23 88 TRAN 3 00 FT FROM DTX 3 00 EA T105A0000 GUAGE TRACK 7 24 88 SALE 3 00 FT 60 000 CUS 10111 INV 45666 3 00 FT Section 1 Page 87 Introduction System Description COMP DTX TEM S397F0000 DESC FP 14 UNDERLAYMENT U M FT CLASS 2 A LOC PACKAGING ALT ITEM UNDERFP14 COMP DTX TEM S430P0000 DESC D 5 SIDING PEBBLE U M EA CLASS 1 A LOC PACKAGI NG COMP DTX ITEM 543050000 DESC D 5 SIDING SAND U M PC CLASS 1 A LOC SHIPPING COMP DTX TEM S432B0000 DESC SOL SOFFIT BROWN U M PC CLASS 2 B LOC SHIPPING TEM 5432P0000 FIT PEBBLE COMP DTX DESC SOL SOE U M PC
38. FIT SAND 2 B FT 00 5439P0000 TRIM PEBBLE 3 A A11023 EA 24 00 72 00 24 00 3 000 543950000 TRIM SAND 3 A C47567 EA 00 COMPANY TOTAL 617 40 Section 1 Page 82 Introduction System Description PAGE 1 DATE 10 17 88 INVENTORY VALUATION REPORT REPORT ID INV406 FIFO METHOD TIME 14 26 21 COMPANY RNC RALEIGH STK QTY INVENTORY LAYER INFORMATION ITEM NUMBER DESCRIPTION CLASS VENDOR U M ON HAND VALUE LAYER UNITS UNIT COST S379F0000 FP 14 UNDERLAYMENT 2 A A11023 FT 50 00 241 25 25 00 5 000 10 00 4 500 15 00 4 750 5430P0000 D 5 SIDING PEBBLE 1 A K10020 EA 10 00 192 50 5 00 18 500 5 00 20 000 543050000 D 5 SIDING SAND 1 A B10010 EA 00 5432B0000 SOL SOFFIT BROWN 2 B A11023 FT 5 00 10 50 7 00 1 500 5433P0000 VENT SOFFIT PEBBLE 2 B B10010 ET 100 00 125 00 50 00 1 150 30 00 1 250 20 00 1 500 543350000 VENT SOFFIT SAND 2 B FT 00 5439P0000 TRIM PEBBLE 3 A A11023 EA 24 00 72 00 24 00 3 000 543950000 TRIM SAND 3 A C47567 EA 00 COMPANY TOTAL 641 25 Section 1 Page 83 Introduction System Description PAGE 1 DATE 10 17 88 INVENTORY VALUATION REPORT REPORT ID INV406 AVERAGE COST METHOD TIME 14 26 21 COMPANY RNC RALEIGH STK QTY AVERAGE INVENTORY ITEM NUMBER DESCRIPTION CLASS VENDOR U M ON HAND COST VALUE S430P0000 D 5 SIDING PEBBLE 1 A K10020 EA 10 00 19 000 190 00 543050000 D 5 SIDING SAND 1 A B10010 EA 00 000 00 CLASS TOTAL 190 00 S379F0000 FP 14 UNDERLAYMENT A A11023 ET 50 00 4 50
39. N Pages the item directory backward Section 1 Page sl Introduction System Description Option 2 Display tran Transaction register inquiry on the Inquiry INV3 menu saction information Transactions are displayed in the order that they were updated All transactions are converted to stock quantities to aid in tracking the effect o Explanation Company code Item number Explanation F3 F4 F12 ENTER HELP key ROLL UP ROLL DOWN f each transaction on the ending on hand balance of entry fields Enter a valid company code Enter a valid item number for this company of command and function keys available End the job Display an alphabetized directory of all items that have been entered You may select an item from this directory for display Roll forward and backward or position the directory alpha search until you find the item you want Then enter the line number of that item Return to the company code item number entry screen Page forward another group of transactions Displays a help screen Pages the item directory forward Pages the item directory backward Section 1 Page 52 Introduction System Description From this menu INV4 Reports menu you can print various inventory analysis reports INVENTORX CONTROL Reports Menu
40. NP Record Format TRANPREC FIELD NO NAME BYTE E H ep TPDELT TPRECN TPCOMP TPITE l TPTXPE TPOTY TPUCST TPVEND TPPONO prvobpbppzjp om oUUKRKUVUt K Logical File s CSSTRAN CSSTRANU Key Field s TPRECN ELD FIELD LENGTH DESCRIPTION Hj Delete code Record number Company code Item number Transaction type P Quantity ordered Unit cost Vendor number Purchase order number OT s H om 0 Wu NHK UVOK s WO WO s Section 1 Page 95 Introduction System Description P TPDATI 4 6 0 Date ordered P TPDLV 6 0 Delivery date Je I Continued on next page Section 1 Page 96 Introduction System Description E L E LAYOUTS Transaction Entry Files Continued This file contains one record File Name CSSTRANI Record Format TRANIREC ep NAME BYTE E H U ELT ECN COMP A H T Oo OF OW UR TYPE IOTY REFN Q 2 H H A jp HHHHHHHH HH 3 H H DATE This file contains one record for every issue transaction entered Logical File s CSSTRAN CSSTRANU Key Field s TIRECN FIELD
41. NV4 From inventory analysis reports 5i Displays the Utilities menu named INV5 restore master files and the CSSINV library 20 Enter or revise options which control the operation of The following is the sequence of steps using this package If that we recommend you you can make selections you can print various you can backup and the application take in getting started Enter application options if applicable Main menu option 20 Set data dictionary options if applicable Utilities menu option 10 Add all companies Maintenance menu option 1 Add all items Maintenance menu option 2 Enter RECEIPT transactions for the current on hand inventory of each item added These receipt transactions should include unit cost amounts in order to initialize costing balances for these items Processing menu options 1 3 At this point you may begin entering periodic transactions to maintain your you need help key will display may also displ ay inventory balances while using any of the on line ent an instructional screen describing that particular program try programs help screens from menus and promp Please note All prompt screens reports or running batch processing jobs display default options for those entries that you change these options required If you run that job you as the new defa
42. NV404P CALL CSSINV INV405P CALL CSSINV INV406P CALL CSSINV INV407P CALL CSSINV INV408P CALL CSSINV INV409P Reports menu OMIA BWNE Section 1 Page 116 Introduction System Description 90 SIGNOFF Section 1 Page 117 Introduction System Description Menu Descriptions Menu Commands Name Description for menu option INV5 Utilities menu 1 CALL CSSINV INV501P 2 CALL CSSINV INV502P 3 CALL CSSINV INV503P 10 CALL CSSINV INV510CL 90 SIGNOFF INV6 Physical processing menu 1 CALL CSSINV INV601P 2 CALL CSSINV INV602CL 3 CALL CSSINV INV603P 4 CALL CSSINV INV604P 5 CALL CSSINV INV605P 90 SIGNOFF CSS CSS Applications menu 1 CALL CSSINV INV 2 CALL CSSINV PO 3 CA L CSS NV OE 90 SIGNOFF Section 1 Page 118 Introduction
43. P 3 3 Company code A PCITE 15 5 Item number A PCTYPE 1 1 Transaction type C P PCOTY 5 9 2 Quantity counted P PCDATE 4 6 0 Date counted A PCLOC 10 10 Location Section 1 Page 99 Introduction System This file contains one record File Name Record Format EMT Upurapr pr vU YP b p Description I in LAYOUTS Transaction Register History Files CSSTREGS TREGSREC Key Field s NO BYTE Hj RSCOMP RSITE RSTYPE RSOTY RSUPRC RSCUST RSI RSDATE RSSEU RSSTKO RSSTU RSCOST O OWOWDDAOUE um vw ELD ep b my Di ENGTH bh WO WO s s OD s to NWN WUO OTW NAO O s or every sale transaction updated Logical File s CSST REG RSCOMP RSITEM RSDATE YMD FIELD DESCRIPTION Company code Item number Transaction type Quantity sold Unit price Customer number Invoice number Date sold Selling unit of measure Stock quantity Stock unit of measure Cost of sale S This file contains one record for every receipt transaction updated File Name CSSTREGR Log
44. Select one of the following 00 J004s On Ke o I I I S Invento tem master listing tem price listing tem Y order report Excess inventory report tock status report ry valuation report Sales analysis report Transaction register Print bin item labels Sign off Selection or command gt a a menu options are available mas lis ter listing of all inventory items ting of selling prices of items t of items that fall below a minimum quantity t of items with inventory above a maximum the current status of inventory balances The following Ts Print Zia Print 3 Print 4 Print Di Print 6 Prin ts the value of inventorv according to the method used Section 1 Page 53 Introduction System 7 P 8 P 9 P Description rint month to date and year to date sales analysis data rint a history of transactions updated to each item rint labels with basic item information listed Section 1 Page 54 Introduction System Description Option 1 on Print a master Explanation of Sort sequence number Enter 2 by item number Company code to print blank for ALL this entry blank Run in batch batch mode The Job queue the job queue to Printer output queue place this report Lines per inch The default is 6 Characters per inch The default Form type default is STD
45. V302CL Transaction register inquiry NV401CL Print item master listing NV401P Display prompt screen for INV401 INV402CL Print item price listing INV402P Display prompt screen for INV402 Section 1 Page 112 Introduction System Description CL Program Descriptions CL Prog Name Description INV403CL Print item re order report INV403P Display prompt screen for INV403 INV404CL Print excess inventory report INV404P Display prompt screen for INV404 INV405CL Print stock status report INV405P Display prompt screen for INV405 INV406CL Print inventory valuation report INV406P Display prompt screen for INV406 INV407CL Print sales analysis report INV407P Display prompt screen for INV407 INV408CL Print transaction register INV408P Display prompt screen for INV408 INV409CL Print bin item labels INV409P Display prompt screen for INV409 INV501P Backup CSS master files INV502P Restore CSS master files INV503P Backup CSSINV inventory library INV503P Display prompt screen for INV503 INV510CL Enter or revise data dictionary defaults INV601CL Print count sheets Section 1 Page 113 Introduction System Description INV601P Display prompt screen for INV601 INV602CL Physical count entry INV603CL Print physical count edit Section 1 Page 114 Introduction System Description CL Program
46. asure This file contains o File Name CSSTRI Record Format FIELD FMT NAME A RPCOMP A RPITE A RPTYPE P RPOTY P RPUCST A RPVEND A RPPONO N RPDATE N RPDLVR ne record for every purchase transaction updated EGP Logical File s CSSTREG TREGPREC Key Field s RPCOMP RPITEM RPDATE YMD NO FIELD FIELD BYTES LENGTH DESCRIPTION 3 3 Company code 15 ES Item number 1 1 Transaction type P 5 9 2 Quantity ordered 5 9 3 Unit cost 8 8 Vendor number 8 8 Purchase order number 6 6 0 Date ordered 6 6 0 Delivery date Section 1 Page 102 Introduction System Description A RPPUUM 3 3 Purchasing unit of measure Continued on next page Section 1 Page 103 Introduction System Description F L E LAYOUTS Transaction Register History Files Continued This file contains one record for every issue transaction updated File Name CSSTREG Logical File s CSSTREG Record Format TREGIREC Key Field s RICOMP RIITEM RIDATE YMD FIELD NO FIELD FIELD EMT NAME BYTES
47. ata library CSSDATAOLD Section 1 Page 11 Introduction System Description Getting Started Once you have installed the CSSINV library you may sign on to CSSINV using either of two methods Method one is to sign off of the current session and sign back on to library CSSINV menu INV The second method is to simply enter the command STRINV while signed on to any library The following menu should appear INV xx INVENTORY CONTROL Release 2 0 Main Menu Select one of the following File maintenance menu Processing menu Inquirv menu Reports menu Utilities menu Ns WN RA 20 Application options 50 Applications menu 90 Sign off Copyright 1988 1998 CSS Selection or command gt The following menu options are available L Displays the File Maintenance menu named INV1 From this menu you can make selections regarding the maintenance of company item and transaction register files 2 Displays the Processing menu names INV2 From this menu you can make selections regarding the entry edit and update of transactions end of month and end of year processing as well as access to the physical count processing menu Section 1 Page 12 Introduction this menu this menu From this menu System Description Dis Displays the Inquiry menu named INV3 From to display item and transaction register data 4 Displays the Reports menu named I
48. d and function keys available F3 F4 F12 F23 HELP key ROLL UP ROLL DOWN E nd the job Display an alphabetized directory of all companies that have been entered You may select a company from this directory for editing Roll forward and backward or position the directory alpha search until you find the company you want Then enter the line number of that company Return to the company code entry screen Delete this company Displays a help screen Pages the company directory forward Pages the company directory backward Section 1 Page 18 Introduction System Description Item master maintenance Option 2 on the File Maintenance INVI menu Add revise or delete flag inventory items Explanation of entry fields Company code Item number Delete code Description Item class Location Weight Stock unit of measure Purchasing unit of measure Stock units per If the it bi B CJ 3 Enter Ler ter TO up Enter the 3 character alphanumeric code assigned the company using this item to 15 alphanumeric characters for this item This entry is required tem has been deleted a D will be displayed The item is not removed from the file un it til menu option 3 is run To un delete this m replace the D with a blank a description of the item a code
49. entory if you enter your transactions grouped by type For xample enter all purchases then all receipts etc The transaction entry program was designed to speed up the entry process using this method Company code Enter a valid company code During ADD mode this field is automatically duplicated from the previously entered transaction however you may type over this entry if you wish to enter a different company code Item number Enter a valid item number for this company Delete code If the transaction has been deleted this field will be displayed with a D To un delete this transaction enter a blank For Sale tr ansdetionsvslsssamesreatkss ee Lag te A A AS ae Ste Es Quantity sold Enter the quantity sold in selling units Two decimal places are allowed nm Unit price per XXX Enter the unit price per selling unit Two decimal places are allowed E 5 Customer number ter a customer number for reference only E 5 Invoice number ter an invoice number for reference only Date sold ti nter the date of this sale The default is todav s date EOorpurchaserttansactionsa cn BM ide sa BA KA AEN bon se L kam UU Royse Quantitv ordered Enter the quantitv ordered in purchasing units Two decimal places are allowed Section 1 Page 32 Introduction System Description Unit cost per XXX Enter the unit cost per purchasing
50. er YES if you wish to run this job in batch mode The default is Y E ep Job queue If you entered YES to run in batch enter the job queue to run from The default is QBATCH Explanation of command and function keys available F3 Cancel this job Section 1 Page 40 Introduction System Description Physical processing menu From this menu you can print inventory count sheets make selections regarding the entry edit inventory vs physical count difference report INV6 and update of physical count transactions and print a current INVENTORY CONTROL Physical Processing Menu Select one of the following CSI 90 Sign off Print count sheets Physical count entry Print physical count edit Print difference report Physical count update Selection or command gt The following menu options are available jik Print count sheets to aid in recording and entering phvsical count information 2 Add revise and delete inventory physical counts 33 Print an edit of physical count data entered 4 Print a report showing the difference between the current inventory balance on file vs the physical count de Update the physical count amounts to the item master file Current balances are forced to match the physical count balance Section 1 Page 41 Introduction System Description Print count sheets Option 1 on the Physical Processi
51. fault is STD Hold spooled file the output queue for printing at a later tim u wish to print The default is Y E 3 Cer bi ta Ler Enter and 3 to print 2 7 8 x 3 7 8 labels CJ ep The defa This entrv de Enter m 5 m 5 Item number description and alternate item number are printed stock the company code of the first labels you the item number of the first labels you ter the company code of the last labels ter the item number of the last labels 1 to print 15 16 x 3 1 2 labels Enter The default is Enter YES if you wish to run this job in If you entered YES to run in batch enter ult is QBATCH m E 3 ter a special form bi 5 Enter the name of the output queue to faults to your default output queue type to use The ter the number of copies to be printed YES if you wish to hold the printout on Explanation of command and function keys available Section 1 Page 69 The default is NO Introduction System F3 Description Cancel this job Section 1 Page 70 Introduction System Description Utilities menu From this menu you can backup and restore master files and the CSSINV library Data dictionary options may also be set from this menu INV5 xx INVENTORY CONTROL Utilities Menu Select one of the following 1 Backup master
52. ical File s CSSTREG Record Format TREGRREC Key Field s RRCOMP RRITEM RRDATE YMD FIELD NO FIELD FIELD EMT NAME BYTES LENGTH DESCRIPTION A RRCOMP 3 3 Company code A RRITE 15 ES Item number A RRTYPE 1 1 Transaction type R P RROTY 5 9 2 Quantity received P RRUCST 5 9 3 Unit cost A RRVEND 8 8 Vendor number A RRREFN 8 8 Reference number N RRDATE 6 6 0 Date received A RRPUU 3 3 Purchasing unit of measure Section 1 Page 100 Introduction System Description P RRSTKQ 9 9 2 Stock quantitv A RRSTUM 3 3 Stock unit of measure Continued on next page Section 1 Page 101 Introduction System This file contains o File Name Record Form a CSSTRI Es EMT pPppzporpovoovpp P Description I in LAYOUTS Transaction Register History Files Continued ne record for every adjustment transaction updated EGA Logical File s CSSTREG TREGAREC Key Field s RACOMP RAITEM RADATE YMD NO FIELD FIELD BYTES LENGTH DESCRIPTION 3 3 Company code E5 15 Item number T ils Transaction type A 5 9 2 On hand quantity adjusted 5 9 2 On order quantity adjusted 8 8 Reference number 15 15 Comments Reason 6 6 0 Date adjusted 3 3 Stock unit of measure 3 3 Purchasing unit of me
53. ing menu options are available l Displav item information including stock status data reference fields price and cost information sales analvsis and cost of sales information 2 Display a history of transactions updated to this item Transactions are listed in the order they occurred Section 1 Page 50 Introduction System Description Item master inquiry Option fil on the Inquiry INV3 menu Display stock status sales analysis and basic item information Explanation of entry fields Company code Item number Please note Enter a valid company code Enter a valid item number for this company Quantity reserved and quantity back ordered are used with the Order Entry Invoicing package If this product is not installed these quantities will be zero Explanation of command and function keys available F3 End the job F4 Display an alphabetized directory of all items that have been entered You may select an item from this directory for display Roll forward and backward or position the directory alpha search until you find the item you want Then enter the line number of that item F12 Return to the company code item number entry screen ENTER Toggle between displaying item information and displaying sales analysis information HELP key Displays a help screen ROLL UP Pages the item directory forward ROLL DOW
54. ish deleted during this session The default is YES Printer output queue Enter the nam place this report on This entry defaults to you Lines per inch Enter the number o The default is 6 Characters per inch Enter the number o The default is 10 Form type Enter a special fo default is STD Section 1 Page 23 to prin to prin e of the ou print number of that item number entry screen the following prompts are displayed after the job is printing added and or revised and deleted items tems added tems updated or tput queue to r default output queue lines per inch characters per inch rm type to use The Introduction System Description Copies Enter the number of copies to be printed The default is 01 Section 1 Page 24 Introduction System Description Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 25 Introduction System Description Remove deleted items Option 3 on the File Maintenance INV1 menu Remove items that have been deleted flagged from the master fil Explanation of screen prompts Run in batch Enter YES if you wish to run this job in batch mode The default is Y E ep Job queue If you entered YES
55. lt is today s date Section 1 Page 34 Introduction System Description For transfer transactions Quantity To company code Enter the quantity transferred ar ti quantitv to Section 1 Page 35 in stock nits Two decimal places are allowed nter a valid companv code to transfer the Introduction System Description Reference number Comments Date transferred For adjustment transactions Quantity on hand Quantity on order Reference number Comment s Reason Date adjusted You may use this field for any reference to this transact Enter commen Enter the date of today s date the on order tion ts about this transaction transfer The default is the on hand balance in stock units the Field key to subtract Two decimal places are allowed Enter the quantity to add to or subtract from Press Enter the quantity to add to or subtract from balance in purchasing units decimal places are allowed Press the Field key to subtract Two You may use this field for any reference to this transact Enter commen adjustment Enter the dal tion ts or a reason for te of the adjustment default is today s date Explanation of command keys available F3 F10 FIL F12 F23 Swi Swi Return End th tch tch Delete e Job to ADD mode
56. lternate item number A ITVEND 8 8 Vendor number A ITAVEN 8 8 Alternate vendor number A TVIT 15 15 Vendor s item number P TLEAD 2 35 0 Lead time days weeks etc P ITOHND 5 D2 Quantity on hand P ITRSRV 5 9 2 Quantity reserved P TTOORD 5 9 2 Quantity on order P TBKOR 5 9 2 Quantity back ordered P TMIN 5 9 2 inimum quantity on hand P TTMAX 5 9 2 aximum quantity on hand P TEOQ 5 9 2 Economic order quantity P ITLPCH 4 6 0 Date of last purchase P TLREC 4 6 0 Date of last receipt P ITLSAL 4 6 0 Date of last sale P ITLCNT 4 6 0 Date of last physical count P ITLCST 5 9 3 Last unit cost P ITACST 5 9 3 Average cost Section 1 Page 91 Introduction System Description Continued on next page Section l Page 92 Introduction System FMT ZZ2 U 2 U ao ao a o a o ao ao ao ao UU tU tU ao a o tU ty Description NAME BYTE v w wa MV OM MMM G a OA OOT OOT OT OO Oo E LE WA Y OUTS Item Master File Continued FIELD FTELD LENGTH DESCRIPT xo lt lt s a gt O 0 0 10 0 O O O LO LO s s s s s s s ww O 0NONN NN NNN lib b o bswowbowbowoowow 0 W ss s ON List Unit Unit Unit Unit Unit Replacement cost price price price price price price 5
57. ng INV6 menu Print count sheets for taking inventory Space is provided for physical count counted by and checked by notat Explanation of screen prompts Sort sequence location by item number is 1 Companv code to print blank for ALL this entrv blank to print Print current inventorv balances balances as a referenc ions Enter 1 to print the report sorted bv Enter 2 to sort bv item number alone The default Enter a valid companv code to print onlv the items for that companv or leave for all companies The default is to print all Enter YES to print the current inventory The default is NO Run in batch batch mode The default i Job queue the job queue to run from Printer output queue place this report on Thi Lines per inch The default is 6 Characters per inch The default is 10 Form type default is STD Copies The default is 01 Hold spooled file the output queue for print Section 1 Page 42 HE jan ter YES if you wish to run this job in 5 Y E n If you entered YES to run in batch enter The default is QBATCH Enter the name of the output queue to s entry defaults to your default output queue Enter the number of print lines per inch Enter the number of characters per inch Enter a special form type to use The Enter the number of copies to be printed
58. ng the maintenance of company item and transaction register files INV1 xx INVENTORY CONTROL File Maintenance Menu Select one of the following Company master Item master Remove deleted items Purge transaction register BONE 90 Sign off Selection or command gt The following menu options are available Ly Add update or delete company s using this system Zo Add update or delete flag inventory items Ba Remove inventorv items that have been flagged for deletion 4 Remove transactions from the transaction register history file You must enter a beginning and ending date to purge Section 1 Page 16 Introduction System Option 1 on the File Maintenance Add revise Description Company master maintenance INV1 menu or delete company s using the inventory control system Explanation of entry fields Company code Company name Cost method Average FIFO LIFO Replacement Costs Please note E nter a 3 character alphanumeric code to identify this company This entry is required bi B ter the company name Enter A to use the average costing method F for the first in first out FIFO method L for the last in first out method or R for the replacement method This entry is required Explanation of costing methods The average is recalculated each time a receipt or a sale is entered so tha
59. ompany code 15 15 Item number 3 3 0 Layer number 5 9 2 Quantity per stock unit 5 9 3 Unit cost per stock unit Section 1 Page 107 Introduction System Descr iption Program Descriptions Program Name Description INV101 Company master file maintenance NV102 Item master file maintenance INV103 Remove deleted items from LIFO and FIFO files NV104 Purge transaction register Nv112 Print item master file maintenance listing INV201 Transaction entry INV202 Print transaction edit INV203 Transaction update INV204 End of month processing INV205 End of year processing INV213 Output a transfer in transaction for any transfer out If both quantity on hand and quantity on order are adjusted generate two adjustment transactions INV301 Item master inquiry INV302 Transaction register inquiry INV401 Print item master listing INV402 Print item price listing INV403 Print item re order report INV404 Print excess inventory report INV405 Print stock status report INV406 Print inventory valuation report Section 1 Page 108 Introduction System Description INV407 Print sales analysis report INV408 Print transaction register INV409 Print bin item labels INV510 Enter or revise data dictionary defaults Section 1 Page 109 Introduction System Description Program Descriptions
60. on System Description Section 1 Page 45 Introduction System Description Print physical count edit Option 3 on the Physical Processing INV6 menu Print an edit of physical count transactions entered Explanation of screen prompts Run in batch Enter YES if you wish to run this job in batch mode The default is Y E ep Job queue If you entered YES to run in batch enter the job queue to run from The default is QBATCH Printer output queue Enter the name of the output queue to place this report on This entry defaults to your default output queue Lines per inch Enter the number of print lines per inch The default is 6 Characters per inch Enter the number of characters per inch The default is 10 Form type Enter a special form type to use The default is STD Copies Enter the number of copies to be printed The default is 01 Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 46 Introduction System Description Option 4 on the Physical Processing Print difference report INV6 menu Print a report of on hand vs physical count differences Explanation of screen prompts Sort sequence location by item number Enter 2 to
61. ports month to date and year to dat Description Sales analysis report INV4 menu Explanation of screen prompts Sort sequence number by item number amount The default is sales analysis information Company code blank for ALL this entry blank Run in batch batch mode Job queue The default is Y CJ 109 If you entered YES to run in batch Enter 1 to print the report sorted by item Enter to sort by class by item number Enter 3 to sort by vendor Enter 4 to sort in descending order by month to date sales Enter to sort in descending order by year to date sales amount to print Enter a valid company code to print only the items for that company or leave to print for all companies The default is to print all Enter YES if you wish to run this job in enter e of the output queue to utput queue lines per inch to use ters per inch The the job queue to run from The default is QBATCH Printer output queue Enter the nam place this report on This entry defaults to your default o Lines per inch Enter the number of print The default is 6 Characters per inch Enter the number of charact The default is 10 Form type Enter a special form type default is STD Copies Enter the number of copies to be printed The default is 01 Hold spooled file the output queue for p
62. printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 48 Introduction System Description Option 5 on the Physical Proc Update physical count transactio differs from the on hand balance inventory equals physical count transaction register history fil Explanation of screen prompts Set non counted items to zero Physical count update essing INV6 menu ns to the item master file an adjustment is made so that If the physical count the on hand An adjusting transaction is placed in the Es Enter YES to set all non counted items to zero inventory Enter NO to adjust only items that were counted The default is NO Run in batch batch mode The default i Job queue the job queue to run from SY CJ 109 Enter YES if you wish to run this job in If you entered YES to run in batch enter The default is QBATCH Explanation of command and function keys available F3 Cancel this job Section 1 Page 49 Introduction System Description Inguiry menu From this menu you can make selections to display item and transaction register data INV3 INVENTORY CONTROL Inquirv Menu Select one of the following 1 Item master 2 Transaction register 90 Sign off Selection or command gt The follow
63. programmer in customizing the package should you decide to do so Disclaimer of Warranty This software and manual are sold as is Acclaim Software or any distributor of this package does not warrant that the software will meet the user s requirements and can assume no liability for the misuse of any part of the package It is the user s responsibility to determine if the programs procedures and other information are suitable for the user s needs The user should back up files and libraries periodically to insure against a loss of information Section l Page 7 Introduction System Description Package Features Multi company capability 15 character item number 3 units of measure stocking purchasing and selling Inventory may be valued using average FIFO LIFO or replacement costing methods On line entry and editing of master files and transactions Up to 6 price fields for each item Quantities are maintained for On hand On order Minimum Maximum Economic order quantitv EOQ Sales analvsis quantities amounts and cost of sales for month to date year to date and last year Item and transaction register inquiries Reference fields for alternate item number serial numbers class location vendor alternate vendor vendor s item number lead time weight etc Reports for Transaction edit Item master listing tem price listing E Item re order
64. r command gt The following menu options are available ee Add revise or delete inventory transactions This may consist of sales purchases receipts issues transfers and adjustments Di Print an edit of transactions entered from this workstation 3 Update all transactions entered at this workstation and optionallv print an update listing 4 Run end of the month processing steps This will clear month to date totals and post an end of month balance to the transaction register history file Section 1 Page 28 Introduction System Description 5s Run end of the year processing steps This will clear year to date totals and save this year to last year 6 Display the Physical Processing menu named INV6 Section 1 Page 29 Introduction System Description Option fil on the Processing Transaction entry INV2 menu Add revise or delete inventory transactions Explanation of entry fields Record number Transaction type Enter In ADD mode this number is automatically incremented with each transaction entered In UPDATE mode you must enter a record number to access a previously entered transaction one of the following transaction codes S sale P purchase R receipt I issue T transfer A adjustment Sale transactions decrease on hand inventory and add to month to date and year to date sales quantities and amounts Sales are automatically
65. r report Print a list of items that fall below a minimum quantity Explanation of screen Sort sequence vendor Company code blank for ALL this entry blank to print for by item Enter 3 to sort to print prompts number Print only items with inventory below minimum quant tity wish to print Run in batch batch mode Job queue the job queue to run from E S The default is Y Printer output queue place this report on Lines per inch The default is 6 Characters per inch The default Form type is 10 default is STD Copies The default is 01 Enter 2 to by item number alone items t all items with an aste The default is Y E The defa This entry de bi that fall bv vendor The default is Enter YES to print only below minimum risk beside those Enter YES if you If you entered YES to r ult m Enter faults m la ter E 3 ter E 3 bi 5 the name of to your def the number o is QBATCH the ou the number of prin ter a special form type Section 1 Page 57 that fall nter 1 to print the report sorted by sort by class The default is 1 by item number Enter a valid company code to print only the items for that company all companies or leave to print all those Enter NO if you
66. report sorted by item by item number Enter 3 to sort by vendor Enter a valid company code to print only the items for that company or leave The default is to print all those Enter N if you that are above maximum Enter YES to print only that are above maximum Enter YES if you wish to run this job in If you entered YES to run in batch enter The default is QBATCH Enter the name of the output queue to to your default output queue Enter the number of print lines per inch Enter the number of characters per inch Enter a special form type to use The E 3 ter the number of copies to be printed Introduction System Description Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 60 Introduction System Description Option 5 on the Reports Stock status report INV4 menu Print the current status of inventory balances Explanation of screen prompts Sort sequence number Enter 2 by item number Company code to print blank for ALL this entry blank Run in batch batch mode The Job queue the job queue to Printer output queue place this report Lines per inch The default is 6 Characters per inch The default
67. report ss ise thee e bles Excess Inventory report minas ies Stock status Eeport li as Inventory valuation report earn widest akse Sales anal ysis report rm er skreket je Transaction K gister ti sk l a lb Print binj item Labels risas sprite be She hoes aat eres G Utilities TABLE OF CONT TS ti pa PART 2 SVSTEM DOCUMENTATION Section 2 Sample Reports L Bissi st lia g a nel Hp ba l o b l e A we 48 Section 154 FLIG MIYOUES ski iz b ie aa aa aa kI tA u 60 Section 6 Program Descriptions c sox eed Peeters Sak OS es 18 section 1 CL Program DESECELPETONS a A NES 75 Section gs Menu Descriptions mesa we be reke we SE Na ie 78 System Description Introduction The purpose of this manual is to provide you with a step by step approach towards using the features of this package as a stand alone inventory system or as part of a complete distribution system You will be provided with sufficient information to 1 Understand the functions of each menu option in the package 2 Perform the installation tasks and 3 Operate the system in an efficient productive manner Part 1 of this manual INSTALLATION AND OPERATION covers all of the above Part 2 of the manual SYSTEM DOCUMENTATION contains detailed reference material describing the reports programs procedures and menus used in Inventory Control This information will aid a
68. rinting at a later tim Explanation of command and function keys available Section 1 Page 64 Enter YES if you wish to hold the printout on The default is NO Introduction System F3 Description Cancel this job Section 1 Page 65 Introduction System Description Transac Option 8 on the Reports INV4 menu tion register Print a history of transactions updated to the item master file Explanation of screen prompts Sort sequence Enter 1 to print the report sorted by item number Enter 2 to sort by transaction type by item number The default is de Company code to print blank for ALL Enter this entry blank to print for all co Transaction type s to print Enter S R A P 1 T C or blank for ALL transa print all types Run in batch batch mode The default is Y Job queue CJ 109 the job queue to run from The defa Printer output queue place this report on Lines per inch The default is 6 Characters per inch The default is 10 Form type default is STD This entry de Section 1 Page 66 a valid company code to print only the items for that company or leave mpanies The default is to print all one or more of the following ction types or leave this option blank to S sale R receipt A adjustment P purchase I issue T transfers from and to C physical count adjustmen
69. ry report Two decimal places are allowed the list price in selling units of this item Three decimal places are allowed Enter up to five other prices in selling units for this item Three decimal places are allowed Section 1 Page 21 Introduction System Description Replacement cost Enter the cost in purchasing units that is required to replace this item This entry is required for companies using the replacement cost method Three decimal places are allowed Section 1 Page 22 Introduction System Description Explanation of command and function keys available Display an alphabetized directory of all items that You may select an item from this Roll forward and backward alpha search until you find nter the lin F3 End the job F4 have been entered directory for editing or position the directory the item you want Then item F12 Return to the company code F23 Delete flag this item HELP key Displays a help screen ROLL UP Pages the item directory forward ROLL DOWN Pages the item directory backward If items are added or revised ended You have the option of Explanation of screen prompts Print added items Enter YES if you wish during this session The default is YES Print updated deleted items Enter YES if you w
70. t The default is blank Enter YES if you wish to run this job in If you entered YES to run in batch enter ult is QBATCH Enter the name of the output queue to faults to your default output queue Enter the number of print lines per inch Enter the number of characters per inch Enter a special form type to use The Introduction System Description Copies Enter the number of copies to be printed The default is 01 Section 1 Page 67 Introduction System Description Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 68 Introduction System Option Print labels wii Description 9 on the Reports unit of measure class location Print bi n item labels INV4 menu th basic item information listed Explanation of screen prompts yo Ending it yo Label size Beginning company code wish to print Beginning item number wish to print Ending company code u wish to print tem number 2 ika to print 1 7 16 x 4 Run in batch batch mode Job queue the job queue to run from Printer output queue place this report on Form tvpe de Copies The default is O1
71. t updated by the system the average is continually A cost level is created each time an item is received These levels are depleted when a sale issue transfer or adjustment is made As the name implies inventory is depleted from the first receipts Under this method inventory is represented by the most recently incurred costs therefore it bears a close relationship to current replacement costs IL cost levels are maintained recent receipts the from As with FIFO inventorv is depleted from the most Under this method inventorv is represented by earliest costs therefore tax savings may result using it However are entered and maintained by the user 2 of the File Maintenance menu Option If FIFO or LIFO methods are used it is important for the on hand inventory balances not to fall below zero If they do cost of sales values will be inaccurate because inventory cost would be zero The costing method may be changed at any time he system maintains accurate cost values for all four Section 1 Page 17 Introduction System Description methods no matter which one is chosen This will allow you to experiment with the different valuations in order to determine the optimum tax benefit for your company However cost of sales information will always represent the cost method used at the time of sale Explanation of comman
72. tem number The default is 1 Company code to print Enter a valid company code to print blank for ALL only the items for that company or leave this entry blank to print for all companies The default is to print all Print LIFO FIFO layers Enter YES to print the cost layers for companies using the LIFO or FIFO cost method The default is NO Run in batch batch mode The default is Y bi jan ter YES if you wish to run this job in E n Job queue If you entered YES to run in batch enter the job queue to run from The default is QBATCH Printer output queue Enter the name of the output queue to place this report on This entry defaults to your default output queue Lines per inch Enter the number of print lines per inch p p The default is 6 Characters per inch Enter the number of characters per inch The default is 10 Form type Enter a special form type to use The default is STD Copies Enter the number of copies to be printed The default is 01 Section 1 Page 62 Introduction System Description Hold spooled file Enter YES if you wish to hold the printout on the output queue for printing at a later time The default is NO Explanation of command and function keys available F3 Cancel this job Section 1 Page 63 Introduction System Opt Print tion 7 on the Re
73. ult value For example report on output queu would change the prin options to reflect these choices run this report your entries wi if you n r previous ent eed to print L screens the next tries are displaved m pressing the H You E screens displayed before printing initially Care time the Stock Status e P3 with a forms name 1412 ter output queue and forms name you The next time you 11 Section 1 Page 13 be displayed Introduction System Description This allows you to set up default options for each report or job The next few pages of the manual discuss the features of each one of the menu options available Section 1 Page 14 Introduction System Description Application options Option 20 on the Main Menu INV menu Set options to control the operation of the entire application Explanation of entry fields Default company code Enter a 3 character alphanumeric code to specify the default company code for all entry screens This entry is required Use a single transaction Enter Y to use a single transaction file for file Y N all users or enter N to use a separate transaction file for each user ID Explanation of command and function keys available F3 End the job Section 1 Page 15 Introduction System Description File maintenance menu From this menu you can make selections regardi
74. unit This entry is for reference only and is not required Three decimal places are allowed Section 1 Page 33 Introduction System Description Vendor number Enter a vendor number for reference only Purchase order Enter a purchase order number for reference only Date ordered Enter the date of the order The default is today s date Delivery date Enter th xpected delivery date of the goods Por receipt transactions ere das Quantity received Enter the quantity received in purchasing units Two decimal places are allowed Unit cost per XXX Enter the unit cost per purchasing unit This field should always be entered otherwise cost of sales data and LIFO or FIFO cost levels will be inaccurate Three decimal places are allowed E 5 Vendor number ter a vendor number for reference only Reference number You may use this field for any reference to this transaction For example you could enter a receiving report number purchase order number etc ti Date received nter the date of receipt The default is today s date For ISSUES transactions ii tii Quantity Enter the quantity issued in stock units Two decimal places are allowed Reference number You may use this field for any reference to this transaction Comment s Enter comments about this transaction Date issued Enter the date of issue The defau

AS/400 - Acclaim Software

Contents

Download Pdf Manuals

Related Search

Related Contents