CREATE EDI FILES

Use this screen to create export files for your EDI billing transmissions. You can use EDI translation software selected by your company to map these files to a transaction set and transmit them electronically to your customers. You can create files for a range of customers and projects. Separate files, representing EDI envelopes, will be created for each customer. Each file can contain multiple projects of the same invoice type for the same customer. You can designate whether the files are test transmissions or production invoices submitted for payment. You can also select the path to which the files will be exported.

For more information, please see Billing Special Topic BL-8, "EDI Billing."

Execute this process after you have calculated and, if necessary, edited your bills. The bills must be unposted and be designated with a "Selected" status. You also must have set up the Maintain Billing EDI Settings screen (Projects » Billing » EDI Billing) and the Maintain Project EDI Information screen (Projects » Billing » EDI Billing) for projects for which you want to create files.

Select Customers

Use this group box to select the customers for which you want to create files. A separate file, which represents a transmission envelope, will be created for each customer for the projects and invoice type selected. Each envelope can contain multiple invoices for the same customer for a given invoice type.

Range Option

Use this drop-down list to select the range of customers you want to create. Valid options are:

The default for this field is All.

From

The value entered in this field varies depending on the range that you have selected. If you have selected All or From Beginning in the Range Option field, this field is inactive. If you have selected One, enter the customer in this field. If you have selected Range, enter the starting customer in this field. If you have selected the To End option, enter that customer in this field.

Use to select values from the appropriate table.

To

The value entered in this field varies depending on the range that you have selected. If you have selected All, One, or To End in the Range Option field, this field is inactive. If you have selected Range, enter the ending customer in this field. If you have selected the From Beginning option, enter that customer in this field.

Use to select values from the appropriate table.

Select Projects

Use this group box to limit the number of projects that will be included in the EDI file.

Range Option

Enter the project or range of projects for which you want to create files. Options available are:

Export files will be created for the customers, projects, and invoice types you have selected.

From

The value entered in this field varies depending on the range that you have selected. If you have selected All or From Beginning in the Range Option field, this field is inactive. If you have selected One, enter the project in this field. If you have selected Range, enter the starting project in this field. If you have selected the To End option, enter that project in this field.

Use to select values from the appropriate table.

To

The value entered in this field varies depending on the range that you have selected. If you have selected All, One, or To End in the Range Option field, this field is inactive. If you have selected Range, enter the ending project in this field. If you have selected the From Beginning option, enter that project in this field.

Use to select values from the appropriate table.

Select Invoices to Transmit

Select the invoice types for which you want to create files. Files will be created only for the range of customers and projects that have been entered in the Maintain Project EDI Information screen with the invoice type selected.

Commercial

Select this option to create files for commercial invoice types.

Form 1034

Select this option to create files for Form 1034 invoices.

Progress Payments

Select this option to create files for progress payment invoice types.

Data Indicator

Select the type of data contained in the export file, production or test. This designation appears in the file header to indicate to your customers whether the file is a test transmission or an actual invoice submitted for payment. In a typical EDI arrangement, your customer may want an initial period in which invoices are submitted parallel using both electronic transmissions and hard copies. Note that all files created for a given customer/project/invoice type range will be include the same data indicator.

Production Data

Select this option to include production data in the export file.

Test Data

Select this option to include test data in the export file.

Output Path

Enter the output path where you would like your file to be stored.

Select

Click the Select button to select an output path where the files will be exported. Note that the output path does not contain the file name. Since the system does not know how many files will be created, you cannot designate the file name. As noted previously, a separate file will be created for each customer in the selected range. Therefore, the file name will consist of the first eight characters of the customer and carry an extension of *.EDI. For example, a customer of SUPERTECH would be created as SUPERTEC.EDI. If a file with this same path and name is detected, a warning will appear in the process. You then have the option of overwriting the file or canceling the process.

Process

Click this button on the toolbar to create the EDI files.

Table Information

This screen uses the following table:

PROJ_EDI_INFO