Use this screen to create batch files that you can submit to the WAWF via FTP. A bill must have a Status of "S" (Select), indicating that it has been approved, before you can include it in a WAWF file.
Note: The WAWF file does not handle ceilings, and retainage will be prorated and included within the bill. |
Note: If you choose to use a word processing program (e.g., Microsoft Word, WordPerfect, Microsoft WordPad, Microsoft Write, etc.) to create your FTP files, you must cut/copy the text out of the word processor program and paste it into Microsoft Notepad, or another ASCII text editor, before sending the data to WAWF. This converts the text to text-only format and removes control characters that contain formatting information. |
Warning: If you have project total ceilings enforced on a project to be included in the file, the over ceiling rows will cause the file to be rejected. |
This screen has one subtask, Project Non-Contiguous Ranges. If you select the Non-Contiguous Range checkbox, use this subtask to select a noncontiguous range of projects.
Click a link below to view information about a particular FTP file layout:
Other - Standard Bills
Other - Project Product Bills
MOCAS - Standard Bills
MOCAS - Project Product Bills
Execute this screen after calculating bills (standard or progress payment) or entering bills (project product bills). All bills must have a status of "Selected" to be included within the file. You must execute this screen before posting the bills because the primary file source is the billing edit tables.
Wide Area Workflow (WAWF) is a secure web-based system set up by the Department of Defense (DoD) for electronic invoicing, receipt, and acceptance. You can electronically submit invoices and government inspection and acceptance documents. Using web-based applications, government contractors and authorized DoD personnel can generate, capture, and process receipt and payment-related documentation. Authorized DoD users are notified of pending actions by e-mail and are presented with a collection of documents required to process the contracting or financial action. The system uses Public Key Infrastructure (PKI) to electronically bind the digital signature to provide non-refutable proof that the user has electronically signed the document. More importantly, WAWF helps to mitigate interest penalty payments caused by lost or misplaced documents. The WAWF website is https:\\wawf.eb.mil.
You can use the WAWF screens in Costpoint to prepare batch files to be transmitted to WAWF via File Transfer Protocol (FTP).
How do I set up Wide Area Workflow?
You can use the WAWF screens in Costpoint to prepare batch files to be transmitted to WAWF via File Transfer Protocol (FTP). Here is how you will typically use the WAWF feature:
We have added a new WAWF Options group box to the Billing Settings screen. Use it to specify a default output path for the Create WAWF Billing Files screen (Projects\Process\Billing). This will provide guidance to your users and assist them in ensuring that their output files are directed to the proper location.
Select the Enable Project Product Bills for WAWF checkbox to enable the WAWF Info, ACRNs, and MILSTRIPs subtasks in the Enter Project Product Bills screen (Projects\Transactions\Billing), and for the Line Item Type, GFE, Product Service Type, and Stock No columns to become visible in the table window of the main screen. These columns are key components for the generation of a WAWF invoice using project product bills.
In this screen, set up all the valid CAGE codes for your company. A company can have more than one CAGE code. You must also enter the Department of Defense Activity Address Codes (DoDAAC) specified in your contract. These become the defaults assigned to the CAGE Code, but you can change them in the Project WAWF Information screen (Projects\Maintain\Billing) when you assign the CAGE Code to a project.
Set up this screen at the billing level of the project for which you would like to create a WAWF FTP file. You also need to assign a CAGE Code to this project. You can assign only one CAGE code to an invoice-level project. The DoDAACs you assigned to the CAGE code in the WAWF Billing Settings screen (Administration\Configure\Projects\Billing Settings) will default in to the DODAACs group box at the bottom of the screen, but you can change them.
Next, you need to specify a CLIN mapping method:
If you select the Generic Billing Format radio button, you need to select a CLIN in the Group Subtotal Heading column of the Generic Billing Formats screen (Projects\Maintain\Billing) that has been specified for the project in the Project Billing Info screen. This will allow you to map accounts to a specific CLIN. If the billing formula is a loaded labor type, you must use the PLC Mapping subtask to map PLCs to your CLINs. (Set up generic billing formats in the Generic Billing Formats screen.)
If you select the Default CLIN radio button, enter a CLIN ID in the field to the right of the radio button. The Create WAWF Billing Files application will use this CLIN when creating the FTP file.
You also need to specify what type of invoice you want to generate. The valid invoice types are Cost Voucher, Commercial Invoice, 2N1, Combo, and Progress Payment. The system generates a different FTP file for each invoice type. Each must be submitted separately.
After you determine what type of invoice you want to generate, you need to specify what source the Create WAWF Billing Files application should use to retrieve the data for this invoice project. The available file sources are Standard Bills, Progress Payment Bills, or Project Product Bills.
Note: Please be aware that the Create WAWF Billing Files process (Projects\Process\Billing) will retrieve the data from the billing edit tables. Do not post your bills until you have generated your WAWF FTP files. |
Use the appropriate subtasks to enter additional information for each invoice type. This information is required for the generation of the FTP file but is not available in the billing edit tables.
For a project to be included in an FTP file, there must be data in the billing edit tables and the bill must have a status of "Selected." Also, the Included in WAWF File checkbox must be unchecked. This ensures that the project is not included in more than one FTP file.
Use this screen to generate an FTP file for one invoice type at a time. The application will reference the Project WAWF Information screen (Projects\Maintain\Billing) to determine which projects are assigned the invoice type selected. The program will also look at the File Source selection (Standard Bills, Progress Payment Bills, or Project Product Bills) in that screen to determine which billing edit tables to use to retrieve the invoice information.
If, after generating an FTP file, you find that it has a project you do not want to include, you should deselect the project bill and rerun the process. You can select the Clear WAWF File Flags checkbox and rerun the Create WAWF Billing Files process again for the project selection. This will allow you to recreate the file to include all selected invoices, even if they were created in a prior process.
For information on how the FTP file is structured and populated, see the "FTP File Layouts" sections in the documentation for the Create WAWF Billing Files screen.
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Projects
Use these options to select the range of projects for which you want to create a WAWF billing file. You can create a file for all projects initialized in the Project WAWF Information screen (Projects\Maintain\Billing). If you are using billing user groups and/or billing cycles, you can create a file only for those projects that are authorized for your user group and/or billing cycle.
Use this drop-down box to select the range option for your file. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting project for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, the ending project for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be inactive.
Select this checkbox to create a customized, non-contiguous list of projects in the Project Non-Contiguous Ranges subtask. The list mode function is different from using a range because you can include or exclude any projects of your choice.
Billing Cycles
Use these options to select the range of billing cycles you want to include in the WAWF file. Your selection of projects will be limited to those included in the range of billing cycles selected. Set up billing cycles in the Billing Cycles screen (Projects\Configure\Billing).
Use this drop-down box to select the range option for your file. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting billing cycle for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, the ending billing cycle for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be inactive.
Bill Groups
Use these options to select the range of bill groups you want to include in the WAWF file. You are limited to bill groups to which you belong. Your selection of projects will be limited to those included in the range of bill groups selected.
Use this drop-down box to select the range option for your file. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting bill group for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, the ending bill group for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be inactive.
Project Managers
Use these options to select the range of project managers you want to include in the WAWF file.
Use this drop-down box to select the range option for your file. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting project manager for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, the ending project manager for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be inactive.
Invoices
Use these options to select the range of invoices you want to include in the WAWF file. Invoices within this range for the projects selected will be included.
Use this drop-down box to select the range option for your file. The following options are available:
All - Select this option to include all available records. The Start and End fields are disabled for this option.
One - Select this option to include only one record. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of records. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the records from the beginning of the available records to a specific record in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the records from a specific record to the end of all the available records. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, the starting invoice for the range you want to include. If you select "All" or "From Beginning" in the Option field, this field will be inactive.
Enter, or use Lookup to select, the ending invoice for the range you want to include. If you select "All," "One," or "To End" in the Option field, this field will be inactive.
Use the radio buttons in this group box to select the invoice type for this file. The default is Cost Voucher. Only selected projects linked to the invoice type in the Project WAWF Information screen (Projects\Maintain\Billing) will be included in the file.
Note: Although a WAWF file is composed of only one invoice type, the source of the individual bills in that file may be different (i.e., standard bills for one bill and project product bills for another), depending on your File Source selection in the Project WAWF Information screen. Although it is possible for bills to exist in both standard bills and project product bills for the same project, only the one designated as the File Source will be used in the batch file. |
Enter a file name for your WAWF file. Please note that files for a particular invoice type must have the following extension:
Cost Voucher - *.FTP
Commercial Invoice - *.FTP
2N1 - *.FTP
Combo - *.FTP
Progress Payment - *.FTP2
This field displays the default output path from the Billing Settings screen, but you can change it. Lookup is available. If there is no Alternate File Location specified in the Billing Settings screen and you do not enter one here, the file will be created in the W_USER_FILE_CATLG table, and you will have to download the WAWF file using the Download Manager application.
Note: When you execute this process, the output path will be inserted into BILL_EDIT_INVC_HDR.W_OUTPUT_FILENAME as a concatenated field (concatenated with a semi-colon). For example if the Alternate File Location is PROJECT and the File Name is DOD09122005.FTP, the W_OUTPUT_FILENAME will be "PROJECT;DOD09122005.FTP." If you do not enter an Alternate File Location, the File Name will be inserted. |
Select this checkbox to overwrite an existing file with the same name.
Select this checkbox to clear the Included in WAWF File and Output Path fields. You can use this feature to re-create a billing file without having to change the flag for each individual project. This feature is helpful if you need to re-create multiple WAWF billing files because it enables you to clear the Included in WAWF File and Output Path fields so that you can re-populate them during the same session.
Enter the WAWF user ID assigned to you by the Department of Defense (DoD).
* A red asterisk denotes a required field.
Select this subtask link to open the Project Non-Contiguous Ranges, where you can select a noncontiguous range of projects.