Revised: August 28, 2009                                         Click here to Print in Word (.doc)

Cyclic LOGREP Schedule of Events: A Step-by-Step Guide

Step-by-Step
Sequence
of Events

 

Event Name

 

Menu Path

 

Actions and Remarks

Step #1
Add or Update the Customer's UIC data on the 'Other Activities' Table
Site>Activity Controls>Other Activities

Update or Add the Ship's UIC to the "Other Activities" table prior to initiating the LOGREP events. Also, pay attention on Color Code. Make sure color codes are not duplicated. This table works about the same as SUADPS’ CIA and CID Tables. Customer's UIC must be loaded properly to avoid problems with financial reports.  

NWCF/DWCF Activities: 

T-AFS, T-AKE, and T-AOE.

Cash Sales Activities:

MSC Contract Ships, U.S. Embassies, DOD activities, U.S. Coast Guards, Foreign Govt/ Navy, and USNS Ships (1Q Cog/APA items).

Processing NWCF/LTL and End-Use requirements for T-AOE with one UIC:

- Use Service Designator “V or R” for all NWCF/DWCF Load-To-Load requirements.

- Use Service Designator “N” for all End-Use  requirements.
Step #2
Initialization of LOGREP Cycle
Site>Activity Controls>LOGREP Cycle Numbers
Instead of having one cycle working at a time, the activity will have an active record of all LOGREP Cycles for the past 12 months. In addition, future LOGREP Cycles can be loaded and prepared in advance if needed. One LOGREP Cycle can be assigned to multiple Customers in the event that several Customers submitted LOGREP Request at the same time (i.e. Battle Group customers).
Step #3

See Note on the Actions and Remarks column.

File Transfer
File>Utilities>File Transfer>Batch File Transfer

Upload requirements to Server under Batch Job JSS220 – Incoming STS/RQN/REF/ LOGREP. After uploading the customer's requirements, input transactions should be verified by viewing the input file @ File>Utilities>Batch Review then Select the 'Input' radio button. Select the file and click OK or double click on file to display the input file.

 

It is a good practice to count the number of line items in the input file (JSS220) before running the JSS220 Batch Job so you can compare the number of input that was read during the process. Verify the “Total records read” on the ‘Incoming Requisitions Summary Listing’ located almost to the end of the output. It is highly recommended not to include ‘incoming supply status input’ in any LOGREP Request update/run.

 

Note: Make sure all 1Qcog (Ship’s Store) and 9M cog (Provisions) requirements have 5K advice code to avoid referrals. However, it is normal that LOGREP Requirements will have 5K advice codes. (Consult TYCOM for current policy).
Step #4
Process customer requirements (Batch) - Batch Job Number: JSS220
Site>Management>Site Internal>Batch Job Scheduling>Predefined Parameters>Incoming STS/RQN/REF/LOGREP

Incoming requisitions (in MILSTRIP format) are fed into a batch process - Batch Job number JSS220. The incoming LOGREP Requests were uploaded in Step #3.

 

Report ID JSS220A & JSS220AR are produce after completion of Batch Job JSS220. Report JSS220A will be in three headings: INCOMING STATUS FOR SUPPLY, CARCASS AND MOV’, ‘INCOMING REFERRAL REQUESTS AND LOGREP/REFERRAL STATUS’, and ‘INCOMING PREVIOUSLY SUBMITTED SUPPLY AF/AT/AM/AC/AK’.

Report JSS220AR “INCOMING REQUISTIONS SUMMARY LISTING” lists all incoming LOGREP Requests. This portion of the report (Report ID JSS220AR) must be included in the customer’s LOGREP Package so the customer can verify what they have sent to the Supply Ship .

 

Note: Prepare an envelop and label it with the customer ’s UIC. This envelop will contain all documents that will be handed to the customer during the UNREP.

Step #4a

(As Required)

Process customer requirements (Interactive)
Logistics>LOGREP Requirements>New LOGREP Requests (Interactive)
If additional LOGREP Request comes in at this point of the process, you can enter these requests through the interactive process. Ensure these requests are tied in with the same LOGREP Cycle number that is currently in progress.
Step #5
Process Suspended Transactions
Logistics>Suspense
This step is critical and must be performed. Go to: Log>Suspense then select LOGREP Requests function. Any suspended transactions must be processed before you proceed to the next step (Activate Customer Requirements). Otherwise, these requests will not be included in the expenditures listing for the particular LOGREP Cycle. In the event that the suspended transactions were not processed, you may delete the transactions from the suspense module (take notes of the reason for suspension so you can make the corrections) and use ‘Material Requirements – External’ function to process these transactions or refer to Step #13a or if the reason for suspension is “Not Carried”, you may manually prepare and send an “AE8” with “CA” status to the customer. The status can be included in Step #6b or Step #15.
Step #6

See notes on the Actions and Remarks column.

Activate customer requirements (Batch) - Batch Job Number: JSI302
Inventory>Management>Inventory Actions>LOGREP Processing>Activate Requirements

This Batch Job will match all LOGREP Requests in the queue to the 'stock_item' table and set the items for "Hatch Sheets" and printing of "Picking Tickets". Statuses (AE8/A41) will be created for transmission to the customers (See Step #6b).

Notes:

(1) You must generate the ‘Activate Requirements’ twice if you are processing requirements from USNS ships using Service Designator of “N” with UIC.  Transferring End-use requirements to another USNS Ship that consists of 1Q cog (XP” fund code) and other FILL/HULL/9M cog items.

First Run: Generate the ‘Activate Requirements’ selecting the LOGREP Cycle Number and UIC. (Make sure the Service Code of this UIC at the ‘Other Activities’ table is equal to N”. DO NOT set the Cash Sales indicator.) The first run should set the ‘Activate Date’ for LOGREP Requirements with non-XP fund code. After completion of the first run, perform query of a LOGREP Requirement with an “XP” fund code. The ‘Activate Date’ should be blank.

Second Run: Generate the ‘Activate Requirements’ for the second time. Make sure to set the “Cash Sales” indicator (Both the Cash Sales checkbox and the Cash Sales Non-local radio button on the ‘Cash Sale' option block.) After completion of the second run, perform queries to some of the LOGREP requirements (Both XP and non-XP fund code on this LOGREP Cycle Number to ensure all LOGREP transactions have an ‘Activate Date’ set. If everything is OK, proceed to the next Step (Either Step #6b or Step #7).

(2) Set Cash Sale Indicator. This indicator must be set if the transactions you are processing are Cash Sales either cash collected locally or not.

(3) Set Load-to-Load (LTL) Indicator. (This is required only for CLF Activities with Service Designator of “V or R”- NWCF/DWCF units). This indicator must be set when transferring NWCF/DWCF material between CLF units.  Ensure Color Code is different from UIC with service designator of “N” (End-use account).

(4) Batch Job JSI302 (Activate Requirements) will produce Report ID JSI302AR in various headers. Review the report. If the LOGREP Cycle consists of two or more customers, pay attention of the report header that says ACTIVATE REQUIREMENTS RATION CANDIDATES REPORT”. If Ration Candidates are present, you must run Step #6c to ration the quantity to various customers. This happens when you (the Supply Ship) do not have enough onhand to fill each customer's request requesting the same item in any given LOGREP Cycle process.

Step #6a

(As Required)

Pre-Edit Report
Inventory>Management>Inventory Reports>LOGREP Reports>Pre-Edit
This is a management tool which provides a snapshot of customer requirements per UIC. Highly recommended when multiple UIC's are present in any given LOGREP Cycle process.

Step #6b

(As Required)

Release Initial Status - Batch Job Number: JSL319
Logistics>Release Outgoing Transaction>Status

This process can be deferred and can be consolidated in Step #15. Supply status BA, CA, or BM (DI: AE8/A41) are produced after the batch process (JSI302) and are written in 'logrep_status_out' table.

After completion of the Batch Process (JSL319), you must perform 'File Transfer' to download the status file from the Server to create a file for transmission to the customer. Open the downloaded file with 'NotePad' program and edit/(clean-up) the file before transmitting the data to the customer. The edited file can be transmitted through SALTS/DAAS or attached to an email whichever is convenient.

Ensure NO 1Q/9M cog requisitions will be referred (A41) to shore supplying (POE) activities.

Step #6c

(As Required)

Ration Requirements
Inventory>Management>Inventory Actions>LOGREP Processing>Ration Requirements
This batch job must be ran if “ACTIVATE REQUIREMENTS RATION CANDIDATES REPORT” have items on it for rationing. See note from Step #6.

Step #6d

(As Required)

Reorder - Batch Job Number : JSI208
Inventory>Management>Inventory Actions>Reorders
Uses the regular reorder window, with added functionality for LOGREP. Highly recommended to avoid delay of Load replenishment.
Step #7
Hatch Sheets - Batch Job Number: JSI301
Inventory>Management>Inventory Actions>LOGREP Processing>Print Hatch Sheets

Now able to print 'Hatch Sheets' separate from 'Picking Tickets (DD 1348-A’s). Batch Job JSI 301 will produce Report ID SI2600AR (Hatch Sheets).

Recommend 3 copies, 1 copy for YNSK, 1 for Q.A., 1 copy to be retained in Stock Control as back-up copy.

Step #8
Print DD 1348-1As - Batch Job Number: JSI310
Inventory>Management>Inventory Actions>LOGREP Processing>Print DD 1348-1A
Printing the Picking Tickets (DD 1348A’s)

Note: Ensure the “Radio Button – ‘Priority’” is selected at this screen: Site>Activity Controls>Constants>Printer Identification. Ensure to click on “Apply” button to save the changes.

Ensure number of picking tickets equals to number of requisitions indicated on the hatch sheets.

Step #9

(QA)

   

VERIFY QUANTITIES ON THE HATCH SHEET and/or DD 1348-1As AGAINST THE ACTUAL QUANTITY PULLED.

 

Step #10
Update changes in quantities or issue substitute (if applicable)
Logistics>LOGREP Requirements>Edit LOGREP Requests
This process is critical for the accuracy of your invoice/billing process. Ensure all changes to the Q.A. smooth hatch sheets and picking tickets are processed, otherwise your billing will not reflect the correct expenditures.
Step #11
Stage requirements
Inventory>Management>Inventory Actions>LOGREP Processing>Stage Requirements
Added functionality allowing the activity to stage requirements for delivery and lock-in requirements. Transactions cannot be modified after completion of the 'Stage Requirements' process. This batch job will not produce any output. It will only set the 'Staged' date and have the items ready for delivery.  To correct erroneous LOGREP transactions, run “Clear Stage Requirements” batch job, correct erroneous transaction, and run “Stage Requirements” to lock-in rqmnts.

Step #11a

(As Required)

Pallet Count Report
Inventory>Management>Inventory Reports>LOGREP Reports>Pallet Count Report
This report may be generated for management. It will give the user a good estimate of how many pallets will be transferred during the UNREP. Pallet count is an estimate figure based on the cube data of the items in your database.
Step #12

See notes on the Actions and Remarks column.

Produce Invoice/ Billing Package - Batch Job Number: JSI285
Inventory>Management>Inventory Actions>LOGREP Processing>Produce Invoice/Billing Package

This process will generate billings for all transactions processed in Step #11.  Ensure DD 1348-1A (1Q Cog) and DD 1149 documents (Cash Sales Report) were generated and included in customer’s billing package.  Recommend 2 copies, 1 copy for customer billing package and 1 copy to be retained in customer’s completed LOGREP folder. 

 

Notes:

(1) Batch Job JSI285 will produce hard copy output (Report ID: SL3530AR) and generate electronic X71 transactions. Copy of this report will be included in the customer’s LOGREP Package.

 

(2) X71 transactions (located at h/data/local/SUP1BT/tape_out) … menu path: File>Utilities>Batch Review>Output File) must be downloaded (Using File Transfer) into CD for inclusion to the customer’s LOGREP Package. These X71 transactions can be used by the customer to automate the receipt processing. If File Transfer does not work, select and open the file then highlight the transactions to copy (Ctrl + C) and paste into ‘Notepad’ (Ctrl + V). Print a hard copy of the file and include it (with CD) in the customer's LOGREP Package.

(3) If batch job number JSI285 did not produced the actual invoice/billing package listing on the first run (Step 12), run/process another batch job to print "Duplicate Invoice/Billing Package" listing for subject customer/UIC." - Path: Inventory>Management> Inventory Actions>LOGREP Processing>Produce Invoice/Billing Package

Step #13
LOGREP Summary Report - Batch Job: JSI327
Inventory>Management>Inventory Reports>LOGREP Reports>LOGREP Summary Report
Generate the LOGREP summary report. Highly recommended to generate this report for the management.

Step #13a

(As Required)

Process supplemental requirements (Interactive)
Logistics>LOGREP Requirements>New LOGREP Requests (Interactive)

Supplemental LOGREP requirements can be added at this point. If it happens, follow Steps #3 through #11).

Note: Supplemental LOGREP Requirements are defined as additional requirements from the customers included in this current LOGREP Cycle Number.
Step #14
Process Expenditures - Batch Job Number: JSI280
Inventory>Management>Inventory Actions>LOGREP Processing>Process Expenditures

This Batch Job (JSI280) completes the LOGREP cycle process. Shipment status are generated at this point and are written in 'logrep_status_out' table. This batch job generates a hard copy output (Report ID: SL3530AR).

 

Step #15
Release Final Status - Batch Job Number: JSL319
Logistics>Release Outgoing Transaction>Status

This will consist of AS8 and may contain AE8 if you deferred your initial "Status Release" from Step 6b.

 

After completion of the Batch Process (JSL319), you must perform 'File Transfer' to download the status file from the Server to create a file for transmission to the customer. Open the downloaded file with 'Notepad' program and edit/(clean-up) the file before transmitting the data to the customer. The edited file can be transmitted through SALTS/DAAS or can be attached to an email, whichever is convenient. This completes the LOGREP Cycle.  Ensure NO 1Q/9M cog requisitions will be referred (A41) to shore supplying (POE) activities.

Highly recommended to run the Reports listed below after completion of the LOGREP Cycle.

(Data from these reports maybe utilized for the monthly submission of your Supply Effectiveness report to your TYCOM)

 

 

Reports

LOGREP Supply Effectiveness Report
Inventory>Management>Inventory Reports>LOGREP Reports>LOGREP Supply Effectiveness Report
Reports have been separated so that the activity only needs to generate the reports they need when they need them.
LOGREP Depth Effectiveness Report
Inventory>Management>Inventory Reports>LOGREP Reports>LOGREP Depth Effectiveness Report
Reports have been separated so that the activity only needs to generate the reports they need when they need them.
Summary of Replenishments Report

Inventory>Management>Inventory Reports>LOGREP Reports>Summary of Replenishments Report

Reports have been separated so that the activity only needs to generate the reports they need when they need them.

Assets Report

Inventory>Management>Inventory Reports>LOGREP Reports>Assets Report

Report format changed to aid in tracking fleet material assets

 

Prepared by: Lonnie Auza - SPAWAR

Darryl Harvey - SPAWAR

Romy Aguilar - SURFLANT

Ed Evangelista - NAVSUP

Bob Lawson - SPAWAR

      

Last revision: August 28, 2009