Costpoint Online Help

Contents of the Create iRAPT Billing Files Screen

Use the fields and options to configure the Create iRAPT Billing Files screen.

Identification

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. After 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. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options, if there are any, are also included in the saved parameter ID. You can change any of the associated selection defaults as necessary.

Field Description
Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display on the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use this block to limit the iRAPT billing files that are created.

Projects

Use these options to select the range of projects for which you want to create an iRAPT billing file. You can create a file for all projects initialized on the Manage Project iRAPT 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. 

Field Description
Option

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.

Start

Enter, or click 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 is inactive.

End

Enter, or click 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 is inactive.

Non-Contiguous Ranges

Select this checkbox to enable the Project Non-Contiguous Ranges subtask.

Billing Cycles

Use these options to select the range of billing cycles you want to include in the iRAPT file. Your selection of projects is limited to those included in the range of billing cycles selected. Set up billing cycles on the Manage Billing Cycles screen.

Field Description
Option

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.

Start

Enter, or click 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 is inactive.

End

Enter, or click 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 is inactive.

Bill Groups

Use these options to select the range of bill groups you want to include in the iRAPT file. You are limited to bill groups to which you belong. Your selection of projects is limited to those included in the range of bill groups selected.

Field Description
Option

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.

Start

Enter, or click 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 is inactive.

End

Enter, or click 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 is inactive.

Project Managers

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

Field Description
Option

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.

Start

Enter, or click 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 is inactive.

End

Enter, or click 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 is inactive.

Invoices

Use these options to select the range of invoices you want to include in the iRAPT file. Invoices within this range for the projects selected are included.

Field Description
Option

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.

Start

Enter, or click 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 is inactive.

End

Enter, or click 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 is inactive.

Options

Use this block to select the invoice type and set other options for creating iRAPT billing files.

Field Description
Select 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 on the Manage Project iRAPT Information screen are included in the file.

Note: Although an iRAPT 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 on the Manage Project iRAPT 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 is used in the batch file.
File Name

Enter a file name for your iRAPT 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
Use User ID/Timestamp as File Name

Select this checkbox to use the user ID/timestamp as the file name.

Alt File Location

This field displays the default output path from the Configure Billing Settings screen, but you can change it. Lookup is available. If there is no Alternate File Location specified on the Configure Billing Settings screen and you do not enter one here, the file is created in the W_USER_FILE_CATLG table, and you must download the iRAPT file using the Download Manager application.

Note: When you execute this process, the output path is inserted into BILL_EDIT_INVC_HDR.W_OUTPUT_FILENAME as a concatenated field (concatenated with a semi-colon). For example, if the Alt File Location is PROJECT and the File Name is DOD09122005.FTP, the W_OUTPUT_FILENAME is "PROJECT;DOD09122005.FTP." If you do not enter an Alt File Location, the File Name is inserted.
Override File

Select this checkbox to overwrite an existing file with the same name.

Clear iRAPT File Flags

Select this checkbox to clear and repopulate the Included in iRAPT File and Alt File Location fields on the Header tab of the Manage Standard Bills screen. 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 iRAPT billing files. When you select this checkbox and click , the fields in the iRAPT Information group box on the Header tab of the Manage Standard Bills screen are updated with the newly created file.

User ID

Enter the iRAPT user ID assigned to you by the Department of Defense (DoD).

Subtask

Subtask Description
Project Non-Contiguous Ranges Click this link to open the Project Non-Contiguous Ranges subtask, where you can select a noncontiguous range of projects.

FTP File Layouts

Refer to the topics below to see the FTP file layouts used for iRAPT billing files.

Note: The FTP file layouts are also available as spreadsheets from Deltek's Customer Care Connect site. See the "Invoicing, Receipt, Acceptance and Property Transfer" topic for more information.

FTP File Layouts - MOCAS - Project Product Bills

  • FTP File Layout - MOCAS - Project Product Bills - 2N1
  • FTP File Layout - MOCAS - Project Product Bills - Combo
  • FTP File Layout - MOCAS - Project Product Bills - Commercial Invoice
  • FTP File Layout - MOCAS - Project Product Bills - Cost Voucher

FTP File Layouts - MOCAS - Standard Bills

  • FTP File Layout - MOCAS - Standard Bills - 2N1
  • FTP File Layout - MOCAS - Standard Bills - Combo
  • FTP File Layout - MOCAS - Standard Bills - Commercial Invoice
  • FTP File Layout - MOCAS - Standard Bills - Cost Voucher

FTP File Layouts - Other - Project Product Bills

  • FTP File Layout - Other - Project Product Bills - 2N1
  • FTP File Layout - Other - Project Product Bills - Combo
  • FTP File Layout - Other - Project Product Bills - Commercial Invoice
  • FTP File Layout - Other - Project Product Bills - Cost Voucher

FTP File Layouts - Other - Standard Bills

  • FTP File Layout - Other - Standard Bills - 2N1
  • FTP File Layout - Other - Standard Bills - Combo
  • FTP File Layout - Other - Standard Bills - Commercial Invoice
  • FTP File Layout - Other - Standard Bills - Cost Voucher

Others

  • FTP File Layout - MOCAS Attachment
  • FTP File Layout - Other - Standard Bills Attachment
  • FTP File Layout - Progress Payment Bills