CREATE WAWF BILLING FILES

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.  

The WAWF file does not handle ceilings, and retainage will be prorated and included within the bill.

If you choose to use a word processing program (for example, 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.

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.

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.

Select Project

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 Maintain Project WAWF Information screen. 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. 

Range

Use this drop-down list to select the range option of projects to be included. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting project for the range you want to include. If you select All or From Beginning in the Range field, this field will be inactive.

To

Enter, or use to select, the ending project for the range you want to include. If you select All, One, or To End in the Range field, this field will be inactive.

Noncontiguous Range

Use this field to select a noncontiguous range of projects.

List Mode

Select this check box to create a customized, non-contiguous list in the list box. The list mode function is different from using a Range because you can include or exclude any projects of your choice.

Using the Range drop-down list, select One, Range, From Beginning, or To End.  Enter the project in the From field and/or the To field. Click the Apply pushbutton to add this project or range of projects to the Noncontiguous Range list box. Once you have selected the list mode, any projects appearing in the From/To range will not be printed unless they have been added to the Noncontiguous Range list box with the Apply button. To remove a selection from the Noncontiguous Range list box, highlight the row and click the Remove button.

Apply

After you have selected the List Mode check box and entered a To/From project, click the Apply button to include the project (or range of projects) in the file.

Remove

Use this button to remove a project or a range of projects that you previously selected.

Select Billing Cycle

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 Cycle screen (Projects » Billing » Controls).

Range

Use this drop-down list to select the range option of billing cycles to be included. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting billing cycle for the range you want to include. If you select All or From Beginning in the Range field, this field will be inactive.

To

Enter, or use to select, the ending billing cycle for the range you want to include. If you select All, One, or To End in the Range field, this field will be inactive.

Select Bill Group

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.

Range

Use this drop-down list to select the range option of bill groups to be included. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting bill group for the range you want to include. If you select All or From Beginning in the Range field, this field will be inactive.

To

Enter, or use to select, the ending bill group for the range you want to include. If you select All, One, or To End in the Range field, this field will be inactive.

Select Project Manager

Use these options to select the range of project managers you want to include in the WAWF file.

Range

Use this drop-down list to select the range of project managers to be included. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting project manager for the range you want to include. If you select All or From Beginning in the Range field, this field will be inactive.

To

Enter, or use to select, the ending project manager for the range you want to include. If you select All, One, or To End in the Range field, this field will be inactive.

Select Invoice

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.

Range

Use this drop-down list to select the range option of invoices to be included. Valid options are:

• All

• One

• Range

• From Beginning

• To End

The default for this field is All.

From

Enter, or use to select, the starting invoice for the range you want to include. If you select All or From Beginning in the Range field, this field will be inactive.

To

Enter, or use to select, the ending invoice for the range you want to include. If you select All, One, or To End in the Range field, this field will be inactive.

Invoice Type

Use the options 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 Maintain Project WAWF Information screen (Projects » Project Setup » Project Master) will be included in the file.

Although a WAWF file is composed of only one invoice type, the source of the individual bills in that file may be different (for example, standard bills for one bill and project product bills for another), depending on your File Source selection in the Maintain 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.

User ID

Enter the WAWF user ID assigned to you by the Department of Defense (DOD).

Output Path

Use this group box to select the output path for your WAWF file.  The default output path comes from the Billing Settings screen (Projects » Billing » Controls). An output path is required.  If you enter an output path that has previously been used, you will get a message asking if you want to overwrite the file. 

Please note that files for a particular invoice type must have the following extension:

Select

To select a different output path than the one provided, click this button to open a dialog screen that you can use to browse to a new output location.

Clear WAWF File Flag

Select this check box 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.

FTP File Layouts

FTP FILE LAYOUTS - MOCAS - PROJECT PRODUCT BILLS

FTP FILE LAYOUTS - MOCAS - STANDARD BILLS

FTP File Layouts - MOCAS Attachment

FTP FILE LAYOUTS - OTHER - PROJECT PRODUCT BILLS

FTP FILE LAYOUTS - OTHER - STANDARD BILLS

FTP FILE LAYOUTS - OTHER - STANDARD BILLS ATTACHMENT

FTP FILE LAYOUTS - PROGRESS PAYMENT BILLS