Logistics Applications Open Requisition Status Tutorial AFSAC Your

Logistics Applications – Open Requisition Status Tutorial AFSAC … Your Trusted Airpower Partner!

Description Open Requisition Status • Three ways to access Open Requisition Status – Open Document Number Query tool – Open Requisition Status Report – Daily NMCS Report (NMCS = Not Mission Capable Supply) • These tools provide basic Supply Management functions over the web to USAF and customers around the world • Tools allow customer to view customized reports on open requisitions – Can view a single requisition – Can view all requisitions associated with a particular case and/or line of a case 2

AFSAC Supply Management – Open Material & Services Tools • Open Document Number Query – Research tool for a single requisition (see Open Document Number Query Tutorial) • Open Material & Services – Reporting tool for all requisitions sorted on a choice of parameters (covered in this Tutorial) • Daily NMCS Report – Reporting tool for all requisitions that have been coded NMCS (see Daily NMCS Report Tutorial) 3

Access Via SCIP 4

Access Via SCIP 5

Access Via SCIP 6

Access Via SCIP 7

AFSAC Online https: //afsac. wpafb. af. mil 8

AFSAC Online https: //afsac. wpafb. af. mil 9

Open Requisition Status Tutorial Use this Tutorial, to learn “How To” use the Open Requisition Status reporting tool. 10

AFSAC Online – Open Requisition Status Query Tool The Open Requisition Status Query tool is listed under the Apps Tab in AFSAC Online. 11

Open Material & Services Use this screen to enter the parameters of the Open Requisition Status Report for the requisitions you wish to research. Note: The next few slides shows how to configure the parameters. 12

Open Material & Services Select the Country (International Partner) or Region you wish to research. Note: International Partners can only access their own country’s data. This selection will be defaulted to user’s country code. 13

Open Material & Services The document number, stock number, project code or MMC (Material Management Code) may be entered to constrain the size of the report. Only items that match the entered data will be included in the report. 14

Routing Identifier Code (RIC) Selection Routing Identifier Codes (RIC code) – 3 -digit code that identifies the source of supply (So. S) for your requisition. Choose which So. S you would like to research by clicking on the empty boxes to change them to check marks. In this example, we have chosen FG 5, FNH, SMS, B 16, and B 17 So. Ss. 15

Routing Identifier Code (RIC) Selection Clicking on the “All FMS” button will either CLEAR (no check marks) all RICs or SELECT (check marks) all RICs. 16

Requisition Status Selection Status Codes – 2 -digit code that indicates the supply status of your requisition. Choose which Status Codes you would like to research, by clicking on the empty boxes to change them to check marks. In this example, we have chosen BB (backorder) and BV (on contract for direct vendor delivery) status codes. 17

Requisition Status Selection Status Codes – 2 -digit code that indicates the supply status of your requisition. Click the “Definitions” button to show a help file defining all the Status Codes. 18

Requisition Status Selection Clicking on the “All” button will either CLEAR (no check marks) all Status Codes or SELECT (check marks) all Status Codes. 19

Weasans Selection Clicking on a Weasans will limit the report to the DCNs for that Weasans. (i. e. clicking on C-130 H will return only C-130 H DCNs) Note: For the Weasans to show up on the report, the report must be configured to include Weasans. 20

Case Selection – Case Tab indicates the type of case for inclusion in Daily NMCS Status report. Range of cases can be selected for inclusion in report. Line(s) can be selected for inclusion in report. Choose which Case Codes you would like to research, by clicking on the empty boxes to change them to check marks. In this example, we have chosen all “Q” cases. 21

Case Selection Clicking on the “All Case Types” button will either CLEAR (no check marks) all cases or SELECT (check marks) all cases. Note: At least one case needs to be selected for report generation. If NO cases are selected, system will default to all cases selected during report generation. 22

Saved Queries Window If you would like to use the same parameters for future requested reports: 1. Enter name of the report in “Save selections as” 2. Click “Save” button. 23

Saved Queries Window If you would like to use the same parameters for future requested reports: 1. Enter name of the report in “Save selections as” 2. Click “Save” button. 24

View Report Button Click on the “View Report” button after the report parameters have all been selected. 25

Report View Country Code has been erased from example. 26

Report View Report is displayed in a default configuration as shown. This report has too many columns to be displayed on one screen. To see the rest of the report, click on the slide bar at the bottom of the window and move it to the right. Country Code has been erased from example. 27

Report View At the bottom of the report, you can see how many records are in this report. For Example: 61 rows. Click on the “Download Data” button to download the data to an Excel spread sheet. Country Code has been erased from example. 28

Practice Now it is your turn: • Use your own AFSAC Online user ID and password, and practice configuring reports for Open Material and Services requisitions. • Practice customizing your reports. • Practice downloading your reports into an Excel spread sheet. 29

Questions? 30