How to generate the daily “MFCS/TIR” …

Background Knowledge:

Material Financial Accounting System – Transaction Reporting (MFCS/TIR) is the financial reporting for Navy Working Capital Fund.

 MFCS - Retail is designed to account for the value of retail assets carried in the Navy Working Capital Fund (NWCF) Account; thereby providing Centralized Accounting and Billing (CAB) in an interim migratory accounting system. MFCS - Retail combines wholesale and retail inventory assets in the N32/N35 databases respectively; with all other COG inventory assets residing in the NUA database. This combining of databases incorporates retail business rules, standardizes pricing, reduces pipeline accounting and billing procedures, and provides Navy-wide inventory visibility. MFCS - Retail satisfies the Navy’s requirement for an interim migratory accounting system.

Once an activity is implemented with MFCS - Retail, it becomes a CAB Activity. MFCS - Retail performs Centralized Accounting and Billing (CAB) for the activity utilizing the Transaction Item Reporting (TIR) process. This process allows MFCS to track all issues, receipts, and adjustments of inventory assets making appropriate debits and credits to stores account and generate bills. MFCS also performs financial tracking and reconciliation of OSO transfers of Navy wholesale inventory assets when one of the activities (issuer or receiver) is a CAB activity.

Procedures:

To generate the daily MFCS/TIR, follow the steps listed below:

Step #1: LOGON to R-Supply and GoTo: File>Utilities>File Transfer>MFCS Build Transfer File.

Step #2: Select the “Build Transfer File” radio button (if daily TIR request).

Step #3: Click “Apply” icon to initiate the Batch Job.

Step #4: Click “Submit” button to submit the Batch Job to NTCSS.

Step #5: Approve the Batch Job. GoTo: Site>Management>Site Internal>Batch Job Scheduling>

Approval. Type-in “R” and click “Apply” icon to release the batch job to NTCSS for processing. This step is applicable only if the “Approval Required” indicator on the Control Parameter Update screen is set.

Step #6: Verify hard copy output. No action required. DO NOT ATTEMP TO MAKE ANY

CORRECTIONS OR CHANGES TO THE OUTPUT.

Step #7:  Download the electronic output to the system hard drive directory (i.e. C: \MFCS\). Do not

download the output directly to a Floppy Diskette. GoTo: File>Utilities>File Transfer>Batch File Transfer.

Substeps for Step #7:

Step #7a. Receive From Server

Step #7b. Check MFCS Download checkbox

Step #7c. Select the (drive and directory) the files should be transferred to

(i.e. C: \\MFCS\)

Step #7d. Select “File” radio button in the ‘Receive from Server Option’

Step #7e. Select the specific date of TIR data you are requesting under

the MFCS Data Available for Transfer Option. Use the scroll button to view and select current day calendar date.

The following files will be written to the specified directory:

* ULMTJJJ.N32 (TIR data for N32 COGs).

* ULMTJJJ.N35 (TIR data for N35 COGs).

* ULMTJJJ.NUA (TIR data for NUA COGs).

* ULMBJJJ.WK1 (BP Management data A0_s).

* ULMSJJJ.WK1 (BP Management status).

* ULMMJJJ.WK1 (Open Purchase and SERVMART Receipts and Expenditures)

* ULMNJJJ.WK1 (New Stock Record File NSN/NICN/LICN Additions)

* ULMXJJJ.SSD (Automated TIR Work Sheet)

* ULMPJJJ.NUA (Proof of Shipment for NUA COG Offloads)

* ULMPJJJ.N32 (Proof of Shipment for N32 COG Offloads)

* ULMPJJJ.N35 (Proof of Shipment for N35 COG Offloads)

* ULMZJJJ.CHG (Local Change Notice Actions)

* ULMRJJJ.DLA (9_ COG TIR Data for DLA)

Step #8: Send the output to NAVICP – M (with designated info addressee).

Refer to: MFCS User’s Guide for further guidance.

Any questions, feedback or comments, email Lonnie Auza.