English French Notes Complete/Exclude *** ONLY SUMMARY OF ADJUSTMENTS PRINTED *** TRAN# ADJ SUMMARY The Abbreviated Item Report will sort the Primary or Secondary inventory items by the group category code and description. Select the Group Categories to display *** NO GROUP CATEGORIES SELECTED ! NOTE: The report will include items not stored in a group category. Abbreviated Item Report ABBREVIATED ITEM REPORT FOR: QTY OH UNIT/IS MAIN STORAGE ADD STORAGE Select the range of NSNs to display AVG USAGE: ESTIMATED VALUES LOW USAGE (NOT UPDATED) UNABLE TO UPDATE (LOCKED) NEW VALUES AUTOMATIC LEVEL SETTER FOR: AVG USAGE START DATE: TOTAL DAYS) DAYS/PERCENTAGE USED FOR CALCULATION: REO PT The Automatic Level Setter will calculate and reset the Normal Stock Level, Emergency Stock Level, Standard Reorder Point, and Optional Reorder Point for selected items or items in selected group categories. Select Items BY The average daily usage will be calculated from the selected date to the current date. Start Usage Average with Date (Month Year): *** STARTING WITH MO-YR: *** TOTAL DAYS: The normal stock level will be calculated by multiplying the average daily usage by the number of days. Enter number of days to be on hand for Normal Stock Level The Normal Stock Level will be set equal to this number multiplied by the average usage. The emergency stock level will be calculated by multiplying the average daily usage by this percentage. Enter the percentage of usage for Emergency Stock Level The Emergency Stock Level will be set equal to this percentage multiplied The standard reorder point will be calculated by multiplying the average daily usage by this percentage. Enter the percentage of usage for Standard Reorder Point The Standard Reorder Point will be set equal to this percentage multiplied The optional reorder point will be calculated by multiplying the average daily usage by this percentage. Enter the percentage of usage for Optional Reorder Point The Optional Reorder Point will be set equal to this percentage multiplied Do you want to update the levels in the database Enter 'YES' to update the levels in the database based on my calculations Enter 'NO' to print estimated levels, '^' to exit. I will print the current levels versus the estimated levels. WARNING -- Check the changes I make carefully. Errors in the database can drastically mess up automatic level setting. As you debug your database I am going to become a trusted friend, but always keep an eye on what I am doing because I do not have the common sense that you do. Automatic Level Setter The Availability Listing will display the current quantity and value of the inventory point items. The report will sort Warehouse inventory items by Account Code or NSN. Select the type of Sort Select the Account Codes to display Warehouse Availability Listing ACCOUNT* ISSUE+NONISSUE TOTALS : INVENTORY VALUE NONISSUABLE VALUE SELLING VALUE ACCT AVAILABILITY LISTING FOR: *** ONLY SUMMARY OF ITEMS PRINTED *** GROUP CATEGORY Primary Availability Listing PRCPRAVP TOT <> <> GROUP The Order Form prints the current or selected inventory point's items sorted by main storage location and description. Blanks for daily ordering may be included. Select a Distribution Point or press the key to select the current inventory point. Select the month-year of the order form for Print Catalog/Order Form for DATE: Print only items with a non-zero normal level Enter YES to print only items whose normal level is not zero in Enter NO to print all items in Print only the items stocked by Enter YES to only print the items stocked by Include blanks on printout Enter YES to print blanks on the order form. Enter NO to print just the items and related information. Order Form MAIN STORAGE LOCATION: DAY: ORDER FORM FOR: FOR THE MONTH-YEAR: The Conversion Factor Report will display the inventory point items with procurement sources and conversion factors. This report will sort the Primary and Secondary inventory items by the Group Category, Description, and Procurement Source. Conversion Factor Report CONVERSION FACTOR REPORT FOR: PROCUREMENT SOURCE IV# UNIT/RE START WITH NSN: FIRST// @ <<-- ENTER '@' TO PRINT ITEMS WITHOUT A NSN START WITH GROUP CATEGORY CODE: FIRST// @ <<-- ENTER '@' TO PRINT ITEMS WITHOUT A GROUP CATEGORY CODE THIS OPTION CAN ONLY BE USED BY THE WAREHOUSE INVENTORY POINT. Inventory Unit Cost Report WHSE* NOT REQ >> NO ITEMS FOUND << UNIT COSTING REPORT FOR: The Cost Trend Analysis Report will compute the average item cost for the specified period based on the monthly opening balance last receipt cost. It will compare the computed average item cost with the current monthly opening balance average cost and display the percent increase or decrease change. Enter the date range (month-year) for computing the average item cost. Select the range of NSNs to display. Cost Trend Analysis COST TREND ANALYSIS FOR: CUM AVG CALCULATED FROM DATE RANGE: CUM AVG The report will sort Primary inventory items by description. Select the Items to display. NO FOOD GROUP DESCRIPTION SUBTOTAL REFERENCE NUMBER TOTAL FOOD GROUP TOTALS FOR INVENTORY POINT: DIETETIC COST REPORT FOR: ITEMS RECEIVED IN INVENTORY POINT BETWEEN DATES: TOTAL $ REC DT The Dietetic Cost Report is sorted by the inventory point (selectable), food group from the item master file, NSN, and date received (selectable). You can select multiple dietetic inventory points for printing this report. A dietetic inventory point is defined as a primary inventory point with the first two digits of the department number equal to '11'. CANNOT BE SELECTED. FIRST TWO DIGITS OF DEPARTMENT NUMBER NOT EQUAL TO '11'. Select the range of RECEIPT DATES to display Receipt Dietetic Cost Report YOU WILL NOT BE ABLE TO CALCULATE DUE-INS FOR ISSUE BOOK REQUESTS. Start with Transactions Requested After DATE: Print Report with Calculated Due-Ins If you choose to update the due-ins, ALL CONTROL POINT and INVENTORY POINT ACTIVITY will be HALTED for several hours. I STRONGLY suggest you run this report after hours. ARE YOU SURE YOU WANT TO UPDATE THE DUE-INS (FROM DATE: ) FOR THIS INVENTORY POINT Calculate Due-Ins PRCPRDI1-DI PRCPRDI1-CK PRCPRDI1-NO CALCULATED TOTAL DUE-IN QTY: DUE-INS AND OUTSTANDING TRANSACTIONS WILL NOT BE UPDATED UNTIL ENTIRE REPORT IS PRINTED. DUE-INS AND OUTSTANDING TRANSACTIONS HAVE BEEN UPDATED. CALCULATED DUE-INS REPORT FOR: UNIT per ISS DUE-IN QTY UNIT per REC CONV FACT DUE-IN This report displays items whose on-hand quantity in differs from the supply station's on-hand amount No QOH information was ever received. It is recommended you request a QOH update. The Last QOH update was received on If this date is too old, you may now request an update. Do you want to request a refresh of the supply station QOH Enter YES to request the supply station send a QOH update to GIP, Enter NO to continue with the report using what has already been received, Sending request... Please give GIP time to get the information before printing the report. Item discrepancy report GIP: SUPPLY STATION: unposted refills: ORD# SUPPLY STATION QUANTITY DISCREPANCY REPORT SUPPLY STATION QTY NOW QTY (AS OF DATE and TIME) ITEM NUMBER AND DESCRIPTION ITEM NUMBER AND DESCRIPTION ** CURRENT QUANTITY DUE- IS NOW EQUAL TO DOES NOT MATCH CALCULATED QUANTITY DUE- DUE- ITEM REPORT FOR QTY DUE- ORD# DATE ORD QTY DUE-OUT UNIT/REC QTY DUE-IN THIS OPTION SHOULD ONLY BE USED BY PRIMARIES AND SECONDARIES. REPORT for inventory point You have the option to update the DUE- 's to the calculated values. If you choose to do this, the distribution order file and inventory point will be locked and NO orders can be placed and NO data in the inventory point can be changed until the program finishes. Therefore, I suggest this be done outside of normal business hours. Do you want to update the inventory DUE- Enter 'YES' to update the DUE- 's, 'NO' to only print the report, '^' to exit. In order to update the DUE- 's, this report must be queued ! Distribution Order Due- I am not updating the DUE- 's since this report has not be QUEUED ! Do you want a BAR CHART Enter YES to display a BARCHART, NO to display a LINE CHART Do you want to include ZERO values when calculating the AVERAGE Enter YES to include ZERO values when calculating the AVERAGE, NO to calculate average using values greater than zero. * * * ITEM MASTER NUMBER: *** AMOUNT USED VERSUS MONTH-YR USED *** AMOUNT USED MONTH-YR ^ | ERROR -- NUMBER ' ' NOT IN CONTROL POINT ACTIVITY FILE Temp Stock Level: Req Issue Mult: Special Remarks: Special Remarks (continued): Justification: Justification (continued): Control Point Official: Approved by: |Obligated by: Storekeeper: |Responsible Official: TEMP.TRANS#: *INTERVAL ISSUE *ISSUE BOOK Control Pt : |Request Date: Cost Center: |Delivery Date: Deliver To : Classification Of Request: | (*--OVER LEVEL OR ISSUE MULT.) ON HAND ORD QTY QTY DELIV The Inactive Items Report will print items which have no receipts or issues after a specified cutoff date. The report is sorted by group category and description. Enter the Inactivity cutoff date. Enter Inactivity Cutoff MONTH and YEAR: Inactive Item Report GROUP* TOTAL INACTIVE ITEM VALUE IN STOCK: INACTIVE ITEM REPORT FOR: INACTIVE ITEMS RANGE FROM Select FILE for inquiry Do you want to see the inventory point parameters Enter YES to see the inventory point data, NO to just see item data, ^ to exit. --Press RETURN to print parameters for Print control parameters for Inventory Parameters TYPE OF INVENTORY POINT SUPPLY WAREHOUSE ABBREVIATED NAME KEEP PERPETUAL INVENTORY KEEP TRANSACTION/USAGE HISTORY PRIMARY UPDATED BY WAREHOUSE SPECIAL INVENTORY POINT TYPE DRUG ACCOUNTABILITY SPD PICKING TICKET PRINTER: ISSUE BOOK SORT ALPHA SORT NSN SORT REGULAR WHSE ISSUES SCHEDULE EVERY 2 WEEKS DEPARTMENT NUMBER MONTHS INACTIVE ITEM DELETION TOTAL NUMBER OF ITEMS STORED FUND CONTROL POINTS MIS COSTING SECTION INVENTORY USERS DISTRIBUTION POINTS INVENTORY PARAMETERS FOR: The Inventory Sales Report will display all sales from the Primary to the Secondary inventory points. This report is sorted by description, the distribution point, and date issued. Select the DISTRIBUTION POINTS to display *** NO DISTRIBUTION POINTS SELECTED ! Select the range of ISSUE DATES to display Primary Inventory Sales Report PRCPRISP TOT TOTALS BY DISTR. PT: TOTALS BY ITEM: TOTAL SALES TO DISTRIBUTION POINTS: INVENTORY SALES FOR: INVENTORY SALES DATE RANGE: *** ONLY SUMMARY OF SALES PRINTED *** DATE ISSUED SELL COST TOTAL VALUE Warehouse Inventory Sales Report PRCPRISR TOT Select the RECIPIENTS to display *** NO RECIPIENTS SELECTED ! Secondary Inventory Sales Report TOTALS BY RECIPIENT: TOTAL SALES TO RECIPIENTS: THERE ARE NO RECIPIENTS OF THAT NAME IN THIS INVENTORY POINT WHICH RECIPIENT Enter the DISTRIBUTION POINT to select an item from the distribution point, or Enter to select an item from the Display Item Report UNIT per ISSUE: QTY ON HAND: DUE-IN: DUE-OUT: QTY NON-ISS: ** DELETE ITEM WHEN QTY ON HAND REACHES ZERO ** TOTAL VALUE: NORM STL LVL: REORDER PT: #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### #################### ####################