Downloading an Interfund Bill MILSBILLS Via the DAASC Website

1
Downloading an Interfund Bill (MILSBILLS) Via the
DAASC Website

• An Alternative to
• 1. Using DFAMS to examine a Bill
• 2. Waiting for the hard-copy Interfund Bill

Jim Mandziara, USAF FAS Representative Defense
Energy Support Center
25 Apr 02
2
Overview of FES and MILSBILLS Queries

• MILSBILLS Query requires Billed DoDAAC, Bill
  Number, and Bill Date
• FES bills are always Billings for Bulk Petroleum
• Identified as FJ1 or FJ2 transaction types in
  MILSBILLS
• Greater detail provided later in this briefing
• Key point FES displays the Billed DoDAAC, Bill
  Number, and Bill Date
• Contract Intoplane bills are currently not billed
  through the FES
• Identified as FP1 or FP2 transaction types in
  MILSBILLS
• These are not discussed in detail in this
  briefing, consult DoD 4000.25-7-M
• Key Point FES does not currently display Billed
  DoDAAC, Bill Number, and Bill Date
• Consult DoD 4000.25-7-M (MILSBILLS) for more
  detail
• The following slides will demonstrate downloading
  an Interfund Bill (MILSBILLS)

3
Step 1 Open the DAASC website
Click on this hyperlink or type it into your
browser
https//www.daas.dla.mil/daashome/daasc_milsbills.
htm
This is the first alert you get, Select OK
This is the second alert you get, Select Yes
4
Step 2 Verify you are at the MILSBILLS System
5
Step 3 Select Connect
6
Step 4 This brings up a Telnet Window
7
Step 5 Type in MILSINQ and hit Enter Note
This TELNET session is not Case Sensitive
8
Step 6 Enter 1 and hit Enter at the Option
Menu
9
Step 7 This is the main Query Screen. As a
discriminate User, Focus on just the A Query
Query A Example You need the year and month of
the Interfund bill (YMM), the Billed DoDAAC, and
the Bill Number.
Use the FES to find these required data elements
10
Location of Required Data Elements needed for
DAAS Query
Signal Code
Billed DoDAAC If Signal Code A, the Billed
DoDAAC is the Customer DoDAAC. If Signal Code B
or C, the Billed DoDAAC is the Supp DoDAAC.
In this example, the Signal Code is C so
the Billed DoDAAC is in the Supp DoDAAC
column. In this example, the Billed DoDAAC is
W81THF.
11
Location of Required Data Elements needed for
DAAS Query (Continued)
Bill Number
Year and Month of the Interfund Bill
In this example, the Bill Number is F3024. The
year and month (YMM) of the Interfund Bill is 203
12
Step 8 Enter data into the Query
Notice the input is not case sensitive, and no
commas are used.
13
Step 9 The Summary Bill is displayed
14
Step 10 Request the Detailed Bill by entering
D 01 and hit Enter
Line Number
To request the detail bill, type D and the Line
Number. In this example, Entered d 01 (Not Case
Sensitive)
15
Step 11 The Detailed Bill
16
Capturing the Bill to a text file, Step 1
Step 1 Select Terminal and Start Logging
17
Capturing the Bill to a text file, Step 2
Once you select Start Logging, the Open log
file Dialog box appears
A
C
B
Step 2 Select location A to put the file, and
type in a File Name B. Then select Open C.
In this example, the selected location to save
the file to is The Desktop and the file name is
F3024.txt
18
Capturing the Bill to a text file, Step 3
After you select open, the log file saves each
screen.
Step 3 enter D and the line number, hit
Enter. In this example, D 01
19
Capturing the Bill to a text file, Step 4
Step 4 Continue to hit Enter or Return to
log the bill details.
20
Capturing the Bill to a text file, Step 5
Step 5 Once the Query is completed, the screen
will depict Query Complete Press Return
21
Capturing the Bill to a text file, Step 6
Step 6 Once you see the query is complete,
Select Terminal And Stop Logging
22
Capturing the Bill to a text file, Step 7
Step 7 Open your saved text file, or you may
import it into Excel.
23
Translating the Interfund Bill Source
DoD.25-7-M MILSBILLS
Example Text File
Line 1 Header File
203SC0600F3024FS1SA02C7999R09206595 S
USAWIIWK9G24QAMBF5034I0880710 0658170326
The Header File is used to transmit the Bill via
DAAS from the Billing Office to the Billed
Office (Usually within DFAS). The technical data
elements are not part of the actual Bill and Are
not explained in detail.
24
Translating the Interfund Bill (Continued)
Line 2 The Summary Record, identified by FS1
or FS2
FS1 06597X49305CF0S9F WK9G24203
F3024SC0600 BT2122020 000196639
FS1 Summary Billing Record (Net Charge) FS2
Summary Billing Record (Net Credit)
SUMMARY
Line 3 to End of File Billing for Bulk
Petroleum, identified by FJ1 or FJ2
FJ1S9F 9130001487104 00000017WK9G242001FF02
CBTF30249 0000023970001410
FJ1 Billing for Bulk Petroleum (Charge) FJ2
Billing for Bulk Petroleum (Credit)
DETAIL
25
Translating the Summary Billing Record
FS1 06597X49305CF0S9F WK9G24203
F3024SC0600 BT2122020 000196639
26
Translating the Billing for Bulk Petroleum Record
FJ1S9F 9130001487104 00000017WK9G242001FF02
CBTF30249 0000023970001410