Business System Modernization – Energy (BSM-E)

1. Business System Modernization – Energy (BSM-E) FAS Enterprise Server (FES) Functionality July 2008

2. Fuels Enterprise Server (FES) • An automated system for collecting, managing, and collating petroleum product transactions from the Service Level and Defense Fuel Support Points (DFSP) • Acts as the point of entry for retail transactions into BSME • Interfaces to other BSME components

3. FES Web Screen

4. FES Account Explorer Fuels Automated System (FAS) Enterprise Server (FES) • Located under menu item “Utilities” • Queries FES transaction from buyer’s perspective • Provides snapshots of product purchases • Enables account managers to download individual transactions for more detailed analysis

5. Fuels Automated System (FAS) Enterprise Server (FES) FES Utility Menu Screen Select the “Utilities” option to open the Utility Menu Select “Account Explorer” link The Account Explorer option allows the user to create FES Data Reports that can be displayed on screen or downloaded to Excel Spreadsheet or Access Database.

6. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Allows user to enter the search parameters for the data they want. The “Query” option will display data on screen. The “Download” option will pull Specified data into a flat, comma delimited file that can be uploaded to Excel and/or Access.

7. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Enter specific parameters for the search—the more specific you are the more concise the report will be. For example, to show the transaction detail for a specific DFAS bill, enter the Bill Number only.

8. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function FES will display a summary of the transactions included in that particular bill number. To view the detail, click on the hyperlink.

9. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function FES will display only the transactions included in the specified Bill.

10. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function This report “Download” will pull Commercial Ground fuel (Fleet Card) purchases charged to customer N00188 that have transaction date in FES from 1 Jan 08 through 20 Mar 08

11. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function The below screen dialogue box displays once download is completed. Note the File name convention is the User ID with a date/time stamp. Click on the “Download Directory” link to open the file directory.

12. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Select the file you want to open and save for import to Microsoft Excel.

13. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Recommend creating a Download Folder to save FES download files to. Name the file and save it to the download folder.

14. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Go to Excel, select the Download folder and open the file.

15. Fuels Automated System (FAS) Enterprise Server (FES) Account Explorer Function Note the FES transaction data is extracted in flat, comma delimited format (comma separates each data field). Follow screen prompts to format the file as you want it. Click “Finish” once you have completed formatting the file.

16. Import Step 3 Data Format select text Format select Record ID to display it as text instead of number

17. Import Step 3 Data Format select Text format select NSN

18. Import Step 3 Data Format select date format select trans date

19. Fuels Enterprise Server (FES) Account Explorer Function Once you have the file in Excel, you can format, sort, subtotal, etc. as you want.

20. Account Explorer Query Attributes Select specific attributes to narrow the query results Combine attributes to produce more targeted query

21. Account ExplorerProduct Query All NMU purchases from 1/1/2008 to 1/5/2008

22. Account Explorer Query Results Summary drill down to detail

23. Account ExplorerDocument ID Query Query on Document ID

24. Account ExplorerQuery Results

25. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Allows user to view transaction data by Fiscal year and/or Program type.

26. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function The system will default to “A” Aviation. The user can change to either “G” (Ground) or “N” (Non-fly). Click “Query” to refresh the screen.

27. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Displays current Fiscal Year Summary Click appropriate hyperlink to open monthly summary report

28. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Displays Monthly Summary Note color coded summary by category of purchase:“Billed” - - “Valid” - - “Challenged” by category “DoD Purchase, Credit, Non-DoD Purchase Click on the appropriate hyperlink to view transaction detail on-screen.

29. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Displays transaction detail for selected month Additional transaction detail is to right of page—use scroll bar to move over.

30. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Continuation of Monthly Summary

31. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Date range can be changed to reduce the transaction detail report To specified date range. Select date range from drop down boxes and click on “Query” to refresh the report.

32. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Note that when you change the date range, the monthly summary Report will not change. However, the transaction detail report will now Only reflect the transaction detail for the specified date range.

33. Fuels Automated System (FAS) Enterprise Server (FES) Buyer Information Function Before changing the date range the detail report contained 14 Transaction details; now the report only contains 4 details.

34. Fuels Automated System (FAS) Enterprise Server (FES) Stars-FL Download Function

35. Fuels Automated System (FAS) Enterprise Server (FES) Stars-FL Download Function Allows user to download financial obligation file for upload to STARS-FL Note: once STAR-FL file is created, the transaction data is flagged and will not be extracted in subsequent STARS-FL downloads.

36. Fuels Automated System (FAS) Enterprise Server (FES) Stars-FL File Preview Function User should first preview the file prior to creating it for download. This screen shot shows an example of a STARS-FL file preview.

37. Fuels Automated System (FAS) Enterprise Server (FES) DWAS File Directory Allows user to download financial obligation file for upload to DWAS

38. Fuels Automated System (FAS) Enterprise Server (FES) DWAS File Directory Click Hyperlink for file to be downloaded

39. Fuels Automated System (FAS) Enterprise Server (FES) DWAS File Directory ASCII Text File

40. Summary Select the appropriate query attributes to get the desired results A combination of multiple attributes will narrow the results and give a more targeted report Sometimes it might be more convenient to download the transaction file and perform your analysis Please contact the helpdesk if there is any question. Comm: 800-446-4950 DSN: 697-6733/34/35 Email: bsme.helpdesk@dla.mil

41. DON Support • DESC Navy/Marine Account Manager Don Williams 703 767-9552 or DSN 427 Donald.Williams@dla.mil • DON Component Program ManagerAlexis Anderson 717 605-9371 or DSN 430 Alexis.Anderson@navy.mil