JOURNAL ENTRY PREPROCESSOR

Use this preprocessor to import journal entries from an ASCII file or from tables. You can view and edit the transactions loaded in the Enter JEs screen in Costpoint General Ledger. You can also use the Print JE Edit Reports function to review them.

This is a separately licensed product for the current release of Costpoint. An Ongoing Support Plan (OSP) is available for routine maintenance and upgrades to this interface. Customization is priced separately.

You must complete the Journal Entry Suspense Setup screen before running this preprocessor.

Only one user at a time can run this application.

When running the Journal Entry Preprocessor under Process Server, please remember that only the Process step will be performed. You must manually run the Import step.

The workstation that submits the process and the Process Server itself must have a common drive letter that points to the same Server, Volume, and Directory; and the Input File must be stored in that directory. For example, if the Input File is selected from G:\STORAGE on Server 4, Volume 3, the Process Server must have its drive G: mapped to Server 4, Volume 3, and have read and write rights to the STORAGE directory.

Fields Validated by Company

The following fields are validated by company:

Vendor
Vendor Employee
1099 Flag
Pay Vendor
Pay Vendor Address Code
Project
Project Abbrev Code
Project Account Abbrev Code
Organization
Organization Abbrev Code
Voucher/Fiscal Year
Account Entry Group
Subperiod Journal Status
AP Account, Cash Account
Sales/Use Tax Code
Reference ID
General Labor Category
Project Labor Category

Fields Controlled by Company

The following fields are controlled by company:

Suspense Values
Voucher Settings
Vendor Settings
Multicurrency Settings

Input File

Select

Click Select to see a list of files from which you can select, or enter the name of the file to be processed in the blank field to the right.

International users: The data can contain non-English characters, provided they are in the ASCII character set. Before creating an ASCII text (.TXT) file, be sure that your keyboard language is set to "EN" (United States English) to prevent Costpoint from generating errors. Deltek recommends the use of .TXT and .CSV file-naming conventions.

File Format

From the drop-down list, select the Input File format:

Fixed-Length — If you select this setting, each field will be of fixed length and must be padded with spaces to the specified field width. You must use this type of file if you are going to upload information containing commas.
Comma-Separated Values — If you select this setting, each field will be separated by a comma. The final field on each line will not have a trailing comma. Strings are not enclosed in quotes.
Tables — If you select this setting, the columns on the tables will mirror the columns' corresponding record types from the existing ASCII file.

The Tables setting uses three database tables for importing journal entries. These database tables correspond to the three parts of a journal entry: transaction line, employee labor, and vendor labor. The columns found on the Input File layout are also in the tables. There are two additional columns:

Record Number (REC_NO) — Used as the primary key. You should make sure that it is unique when populating the tables with data.
Status Code (S_STATUS_CD) — Used to identify rows that have not been processed, are in error, or have been imported.

The tables are:

Table	Contains Information to be Imported for the:
AOPUTLJE_INP_TR	Transaction type record
AOPUTLJE_INP_VEN	Vendor Labor type record
AOPUTLJE_INP_EMP	Employee Labor type record

Warning: For the Tables setting only, the Journal Type Code, Fiscal Year, and Period Number columns cannot be "null" in the tables. If you do not supply a value for any of these columns, you must set the columns in the tables to a single space (Journal Type Code and Fiscal Year) or zero (for Period Number).

Truncated Values

From the drop-down list, select the action you want Costpoint to take when an Input File field is too long for the target database column. This field is available only if you set the File Format option to Comma-Separated Values.

The choices for Truncated Values are:

Always truncate — Costpoint always truncates values that are too long without warning you first and writes a warning message to the Error Report.
Never truncate — Costpoint never truncates values that are too long. Costpoint rejects the records and writes an error message to the Error Report.
Warn before truncation — Costpoint displays a message when it encounters a value that is too large in the Input File and gives you the option of either truncating the value or rejecting the record.

Accounting Period

Select the fiscal year, period, and subperiod to use as defaults. These settings will not override values in the Input File but will be used if the fiscal year, period, and/or subperiod in the Input File are blank.

Options

Use JE Numbers In Input File

Select this check box to use the journal numbers provided in the Input File when importing journal entries to Costpoint tables.

Leave this check box cleared to allow Costpoint to assign journal numbers automatically when importing to the Costpoint tables.

When assigning adjusting journal numbers, Costpoint uses the Last JE No table to determine the next JE number to use, depending on the fiscal year and period.
When assigning recurring journal numbers, Costpoint determines the next JE number to use by looking up the largest JE number already used in the JE Header table, regardless of fiscal year and period.

Warning: Assigning journal numbers when importing can take significantly longer than using the journal numbers provided in the Input File. The length of time required also depends upon the number of journal entries being uploaded.

Allow Unbalanced JEs

Select this check box to allow unbalanced journal entries to be processed without being rejected. If you leave this check box cleared, a validation routine rejects any journal entry that does not balance (net to zero).

Expand Segmented IDs

Select this check box to expand the Account, Org, Project, Reference Number 1, and Reference Number 2 fields in the Input File when processing.

If you select this check box, Costpoint pads any segment of the affected fields that is shorter than the specified length for that segment:

If the value is numeric, Costpoint pads the segment with zeroes on the left.
If the value is alphanumeric, Costpoint pads the segment with spaces on the right.

Warning: If you select the Expand Segmented IDs option, processing may take significantly longer.

Defaults

Journal Type

From the drop-down list, select the journal type to be used as a default if there is no journal type in the Input File:

Adjusting
Recurring

Your setting for this option will not override values entered in the Input File.

Cycle

From the drop-down list, select a recurring cycle to be used as a default if there is not a recurring cycle on a JE transaction line record in the Input File:

BI-WKLY
MONTHLY
SEMI-MONTHLY
WEEK2

Your setting for this option will not override values entered in the Input File.

Header Description

Enter a header description of up to 30 characters to be used as a default if there is not a header description on a JE transaction line record in the Input File. This description will not override values entered in the Input File.

Process Table Options

This group box is not available unless you set the File Format option to Tables. The three options in this group box become active only when you click Process Input File on the toolbar.

Load Unprocessed Records

Select this option to process rows from the input tables that have a Status Code (S_STATUS_CD) of NULL. The rows are selected from the Transaction, Vendor Labor, and Employee Labor tables.

Records that pass validation and records that fail validation are loaded into separate temporary tables; this is the same procedure for processing Input Files. Costpoint then updates the Status Code (S_STATUS_CD) column to E (Error) in all the input tables for the corresponding records that contain errors.

When you click Process Input File, Costpoint inserts all records that passed validation into the base tables (JE_HDR, JE_TRN, JE_TRN_LAB_EMPL, JE_TRN_LAB_VEND, and RECUR_JE_TMPLT). Costpoint then updates the Status Code column with an I to show that these rows have been successfully imported.

Reprocess Error Records

Select this option to re-process rows from the input tables that have a Status Code (S_STATUS_CD) of E (Error).

Delete Imported Records

Select this option to delete rows from the input tables that have a Status Code (S_STATUS_CD) of I (Imported). If you select this option, Costpoint deletes records from the AOPUTLJE_TR_HDR, AOPUTLJE_INP_VEN, and AOPUTLJE_INP_EMP input tables.

Processing Sequence

Process Input File

Click this button on the toolbar (or use the option in the Process menu) to read the Input File, create temporary tables, validate records, and print the Error Report.

Import JEs

Click this button on the toolbar (or use the option in the Process menu) to import the rows from the temporary table (created by the process) into the JE Header, JE Transaction, JE Reversal, and Recurring JE Template tables.

Processing Details

Input File and Error File Layout

A record in the Input File must be in one of three formats: JE Transaction Line, JE Vendor Labor, or JE Employee Labor. Each Vendor or Employee Labor record must match with a JE Transaction Line record in the Input File.

JE Transaction Line Format (JE_HDR, JE_TRN, and RECUR_JE_TMPLT):

Type	CP Table/Column	Characters	Required?	Format
Record Type		Character 1	Required	(L)
JE Transaction Line Num	JE_TRN.JE_LN_NO	Numeric 5	Required	(99999)
Input Journal Number	JE_HDR.JE_NO	Numeric 9	Required	(999999999)
Journal Type Code	S_JNL_CD in all three tables	Character 3	Default provided	(AJE, RJE)
Fiscal Year	JE_HDR.FY_CD	Character 6	Default provided
Period Number	JE_HDR.PD_NO	Number 2	Default provided	(99)
Subperiod Number	JE_HDR.SUB_PD_ NO	Number 2	Default provided	(99)
Reversal Flag	JE_HDR.RVRS_FL	Character 1	Required	(Y or N)
Header Desc	JE_HDR.JE_DESC	Character 30	Required
Transaction Amount	JE_TRN.TRN_AMT	Number 15	Required	(-99999999999.99)
Account	JE_TRN.ACCT_ID	Character 15	Default provided	(From Proj Acct Abbrev)
Organization	JE_TRN.ORG_ID	Character 20	Default provided	(From Org Abb or Proj Owning Org)
Transaction Desc	JE_TRN.JE_TRN_ DESC	Character 30	Optional
Project	JE_TRN.PROJ_ID	Character 30	Optional
Reference Number 1	JE_TRN.REF_ STRUCT_1_ID	Character 20	Optional
Reference Number 2	JE_TRN.REF_ STRUCT_2_ID	Character 20	Optional
Recurring Cycle	RECUR_JE_TMPLT.CYCLE_DC	Character 15	Optional	(Only needed for recurring JEs)
Org Abbreviation	JE_TRN.ORG_ ABBRV_CD	Character 6	Optional
Project Abbreviation	JE_TRN.PROJ_ ABBRV_CD	Character 6	Optional
Project Account Abbrev	JE_TRN.PROJ_ ACCT_ABBRV_CD	Character 6	Optional
Billable Flag	JE_HDR.UPDATE_ OBC_FL	Character 1	Optional	(Defaults to Y)
Notes	JE_TRN.NOTES	Character 254	Optional

JE Employee Labor Format (JE_TRN_LAB_EMPL):

Type	CP Table/Column	Characters	Required?	Format
Record Type		Character 1	Required	(E)
JE Transaction Line Num		Numeric 5	Required	(99999)
Input Journal Number		Numeric 9	Required	(999999999)
Journal Type Code		Character 3	Default provided	(AJE, RJE)
Fiscal Year		Character 6	Default provided
Period Number		Number 2	Default provided	(99)
Employee Subline Num	SEQ_NO	Numeric 5	Required	(99999)
Employee ID	EMPL_ID	Character 12	Required
General Labor Category	GENL_LAB_CAT_CD	Character 6	Default provided	(From Employee ID)
Project Labor Category	BILL_LAB_CAT_ CD	Character 6	Default provided	(From Project and GLC)
Employee Hours	LAB_HRS	Number 15	Required	(-99999999999.99)
Employee Amount	LAB_AMT	Number 15	Required	(-99999999999.99)
Employee Effective Billing Date	EFFECT_BILL_DT	Character 10	Default provided	(YYYY-MM-DD)

JE Vendor Labor Format (JE_TRN_LAB_VEND):

Type	CP Table/Column	Characters	Required?	Format
Record Type		Character 1	Required	(V)
JE Transaction Line Num		Numeric 5	Required	(99999)
Input Journal Number		Numeric 9	Required	(999999999)
Journal Type Code		Character 3	Default provided	(AJE, RJE)
Fiscal Year		Character 6	Default provided
Period Number		Number 2	Default provided	(99)
Vendor Subline Number	SEQ_NO	Numeric 5	Required	(99999)
Vendor ID	VEND_ID	Character 12	Required
General Labor Category	GENL_LAB_ CAT_CD	Character 6	Required
Project Labor Category	BILL_LAB_CAT_ CD	Character 6	Optional
Vendor Hours	LAB_HRS	Number 15	Required	(-99999999999.99)
Vendor Amount	LAB_AMT	Number 15	Required	(-99999999999.99)
Vendor Empl ID	VEND_EMPL_ID	Character 12	Optional
Vendor Effective Billing Date	EFFECT_BILL_DT	Character 10	Default provided	(YYYY-MM-DD)

Processing Details

Costpoint checks the temporary table to determine whether there are any rows that have not been imported. If there are, Costpoint displays a message and you can continue or cancel the process. If you continue, the temporary table will be cleared.
Costpoint reads records from the Input File and inserts them into the temporary table.
Costpoint applies defaults to certain blank fields in the Input File (Fiscal Year, Period, Subperiod, and Journal Type code).
Validations are performed.
Once the validations are completed, journal entries with errors are written to the error file. If there is an error on one line of a journal entry (transaction line, employee labor, or vendor labor), all lines of the journal entry will be rejected and written to the error file. These rows will then be deleted from the temporary tables. The temporary tables now have only valid rows in them.
The Error Report prints. If there are errors, Costpoint displays a message on the screen. If there are no errors, the Error Report indicates that no records were found.

Import Details

If Costpoint is using the journal numbers from the Input File, it checks the JE Header, JE Header History, and Recurring JE Template tables again to ensure that the journal entries being imported do not already exist. If duplicates do exist, Costpoint will display a message and cancel the import.
If you have set up Costpoint to assign journal numbers automatically, all journal entries in the temporary table will be assigned new and unique journal numbers.
Costpoint sets the JE Header Key, JE Line Key, JE Line Employee Key, and JE Line Vendor Key.
Costpoint inserts rows from the temporary tables into the JE Header and JE Transaction tables. Any reversing or recurring journal entries are inserted into the JE Reversal and Recurring JE Template tables. Any employee or vendor labor lines are inserted into the JE Employee Labor and JE Vendor Labor tables.
Costpoint clears the temporary table to prevent duplicate uploads.

Tables

A list of the Costpoint tables used by this preprocessor and their corresponding Costpoint screens can be found at the end of this topic.

JE Header Table

The JE Header table is filled as follows:

Field	Source	Costpoint performs these Validations
Company Id (COMPANY_ID)	The company for which the user is currently logged in.
JE Number (JE_NO)	The journal number is either taken from the Input File or assigned by Costpoint. The journal number is required in the Input File even if you set Costpoint to assign journal numbers. The field is used as a break point so Costpoint can identify and distinguish individual journal entries.	The input journal number is a required field and must exist in the Input File. The input journal number must be numeric.
JE Header Description (JE_DESC)	The Input File.	JE Header Description is a required field and must exist in the Input File.
Reversal Flag (RVRS_FL)	The Input File.	Reversal Flag is a required field and must exist in the Input File. The Reversal Flag in the Input File must be a Y (Yes) or N (No).
User ID (USER_ID)	Costpoint sets the user ID to the current user.
Journal Type Code (S_JNL_CD)	The Input File or the screen. The default value is from the screen.	The Journal Type Code must be AJE (Adjusting) or RJE (Recurring). Journal Type Code is a required field and must exist in the Input File or have a default supplied.
Fiscal Year (FY_CD) Period (PD_NO) Subperiod (SUB_PD_NO)	The Input File or the screen. The default values are from the screen.	The combination of all three fields must exist in the Subperiod table. The combination must be open in the Subperiod table. The Period and Subperiod fields must be numeric. Fiscal Year, Period, and Subperiod are required fields and must exist in the Input File or have a default supplied.
Approval Date (APPRVL_DTT)	Costpoint leaves this field blank.
Approval User ID (APPRVL_USER_ID)	Costpoint leaves this field blank.
JE Batch ID (JE_BATCH_ID)	Costpoint leaves this field blank.
JE Group DC (JE_GRP_DC)	Costpoint leaves this field blank.
Posting Sequence Number (POST_SEQ_NO)	Costpoint leaves this field blank.
Entry Date (ENTR_DTT)	Costpoint sets this date to the current system date.
Billable Flag (UPDATE_OBD_FL)	The Billable Flag is optional. You may supply a value in the Input File.	The only values allowed for the Billable Flag are Y (Yes) and N (No). If the value is not supplied in the Input File, or the value supplied is not Y or N, Costpoint sets this field to Y.
Over Budget Flag (OVR_BUD_FL)	Costpoint sets the Over Budget Flag field to N (No).
Input File Journal Entry Number (INPUT_FILE_JE_NO)	The Input File Journal Entry Number is taken from the Input File; copied from the JE_NO field. The Input File Journal Entry Number field displays on the Enter JEs screen and is useful to link the Costpoint-assigned journal entry number to the Input File journal entry number when the Use JE Numbers In Input File option is cleared on the Journal Entry Preprocessor screen. The Input File number also displays on the Print JE Edit Report.

JE Transaction Table

The JE Transaction table is filled as follows:

Field	Source	Costpoint performs these Validations
JE Line Number (JE_LN_NO)	The JE Transaction Line Number field from the Input File.	JE Transaction Line Number is a required field and must exist in the Input File. The JE Transaction Line Number must be numeric. The JE Transaction Line Number must start with 1 and must be sequential within each unique journal entry Number, Journal Type Code, Fiscal Year, and Period combination.
Transaction Amount (TRN_AMT)	The Input File.	Transaction Amount is a required field and must exist in the Input File. The Transaction Amount must be numeric.
Account (ACCT_ID)	The Input File. The default value is the Account set up for the Project Account Abbreviation.	The Account must exist in the Account table. The Account must be a detail account. Journal Entries must be included in the account entry group assigned to the account. The Account must match the input mask specified for accounts. If any segment is shorter than the specified length for that segment, it will be padded. Numeric values are padded with zeroes on the left. Alphanumeric values are padded with spaces on the right.
Flow Transaction Type (CFLOW_TRN_TYPE)	Costpoint leaves this field blank.
Organization (ORG_ID)	The Input File. If the Org Abbrev is supplied in the Input File, the default value will be the Organization associated with the Org Abbrev. If both Organization and Org Abbrev are not supplied in the Input File: Project or Proj Abbreviation will be required in the Input File. The Default to Owning Org option in the Maintain Project Master screen in Costpoint Project Setup must be selected for the project. The default value is the Owning Organization set up for the project.	The Organization must exist in the Organization table. The Organization must match the input mask specified for the organization. If any segment is shorter than the specified length for that segment, it will be padded. Numeric values are padded with zeroes on the left. Alphanumeric values are padded with spaces on the right.
Journal Type Code (S_JNL_CD)	Costpoint sets the Journal Type Code the same as the JE Header.
Transaction Type (S_TRN_TYPE)	Costpoint sets the transaction line as follows: The Transaction Type is E if Employee Labor subtask records (in the Enter JEs screen in Costpoint General Ledger) exist for this line. The Transaction Type is V if Vendor Labor subtask records (in the Enter JEs screen in Costpoint General Ledger) exist for this line. The Transaction Type is N if neither Employee nor Vendor Labor subtask records exist for this line.
Organization Abbreviation (ORG_ABBRV_CD)	The Input File. The default value is the Org Abbrev set up for the Organization.	The Organization Abbreviation must exist in the Organization table. If both the Organization Abbreviation and Organization are supplied in the Input File, they must match in the Organization table.
JE Transaction Description (JE_TRN_DESC)	The Input File. The default value is the JE Header Description.
Project (PROJ_ID)	The Input File. The default value is the Project associated with the Proj Abbrev.	If the Project Required option on the Maintain Accounts screen in Costpoint General Ledger has been selected for the account, Project is a required field and either the project or the project abbreviation must exist in the Input File. If the Project Account Abbreviation is entered, Project is a required field and either the project or the project abbreviation must exist in the Input File. The project must exist in the Project table. The project must be active. The project must match the input mask specified for the project. If any segment is shorter than the specified length for that segment, it will be padded. Numeric values are padded with zeroes on the left. Alphanumeric values are padded with spaces on the right.
Project Abbreviation (PROJ_ABBRV_CD)	The Input File. The default value is the Proj Abbrev set up for the Project.	The Project Abbreviation must exist in the Project table. If both the Project Abbreviation and Project are supplied in the Input File, they must match in the Project table.
Project Account Abbreviation (PROJ_ACCT_ABBRV_CD)	The Input File.	The Project Account Abbreviation is required if the Account is not supplied in the Input File. A Project or Project Abbreviation is required with a Project Account Abbreviation. The Project Account Abbreviation must exist in the Account Group Setup table. If both the Account and the Project Account Abbreviation are supplied in the Input File, they must match in the Account Group Setup table.
Notes (NOTES)	The Input File.
Reference Number 1 (REF_STRUC_1_ID)	The Input File.	Reference Number 1 must: Exist in the Reference Structure table. Be available for use in data entry. Be valid as a reference entry code 1. Match the input mask specified for reference 1. If any segment is shorter than the specified length for that segment, it will be padded. Numeric values are padded with zeroes on the left. Alphanumeric values are padded with spaces on the right.
Reference Number 2 (REF_STRUC_2_ID)	The Input File.	Reference Number 2 must: Exist in the Reference Structure table. Be available for use in data entry. Be valid as a reference entry code 2. Match the input mask specified for reference 2. If any segment is shorter than the specified length for that segment, it will be padded. Numeric values are padded with zeroes on the left. Alphanumeric values are padded with spaces on the right.
Percent of Total Return (PCT_OF_TOT_RT)	Costpoint sets the Percent of Total Return field to zero.
Total Hours (TOT_HRS)	The total hours on the Employee or Vendor subtask.

JE Reversal Table

The JE Reversal table is filled as follows:

Field

Source

Costpoint performs these Validations

JE Header Key Rel (JE_HDR_KEY_REL)

Costpoint leaves this field blank.

Reversing Period (PD_NO)

Reversing Subperiod (SUB_PD_NO)

Reversing Fiscal Year (FY_CD)

The Reversing Period is the next period (JE Header Period + 1) or 1.

The Reversing Subperiod is the first subperiod of the reversing period.

The Reversing Fiscal Year is the JE Header Fiscal Year or the next fiscal year.

The combination of all three fields must exist in the Subperiod table.
The combination must be open in the Subperiod table.

Recurring JE Template Table

The Recurring JE Template table is filled as follows:

Field	Source	Costpoint performs these Validations
JE Number (JE_NO)	Costpoint sets the journal number is to be the same as the JE Header.
Cycle (CYCLE_DC)	The Input File.	For recurring journal entries, Cycle is a required field and must exist in the Input File. The Cycle must exist in the Cycle table.
From Fiscal Year (FY_CD_FR) From Period (PD_NO_FR) From Subperiod (SUB_PD_NO_FR)	Costpoint sets the recurring from fiscal year, period, and subperiod the same as the JE Header.
To Fiscal Year (FY_CD_TO) To Period (PD_NO_TO) To Subperiod (SUB_PD_NO_TO)	Costpoint leaves these fields blank.

JE Employee Labor Table

The JE Employee Labor table is filled as follows:

Field	Source	Costpoint performs these Validations
Sequence Number (SEQ_NO)	The Employee Subline Number field from the Input File.	The Employee Subline Number is a required field and must exist in the Input File. The Employee Subline Number must be numeric. The Employee Subline Number must start with 1 and be sequential within each unique journal entry number, journal entry Line Number, Journal Type Code, Fiscal Year, and Period combination.
Labor Hours (LAB_HRS)	The Input File.	Labor Hours is a required field and must exist in the Input File. The Labor Hours field must be numeric.
Labor Amount (LAB_AMT)	The Input File.	Labor Amount is a required field and must exist in the Input File. The Labor Amount field must be numeric.
Employee Effective Billing Date (EFFECT_BILL_DT)	The Input File.	The Employee Effective Billing Date must either exist in the Input File or have a default value available. The default value is the Subperiod End Date. If the Employee Effective Billing Date is supplied in the Input File, it must be a valid date, in the following format: YYYY-MM-DD.
Employee ID (EMPL_ID)	The Input File.	Employee ID is a required field and must exist in the Input File. The Employee ID must exist in the Employee table.
General Labor Category (GENL_LAB_CAT_CD)	The Input File. The default value is the default GLC for the Employee ID.	GLC is a required field and must exist in the Input File or have a default value supplied from the Default Regular Timesheet table. The GLC must exist in the General Labor Category table.
Project Labor Category (BILL_LAB_CAT_CD)	The Input File. The default value may be derived from the Project Employee Labor Category table for the project and employee ID combination, or from the Project Labor Category Map table for the project and GLC combination.	A Project is required in order to enter a PLC. The PLC must exist in the Billing Labor Category table. If a work force is not required for the project, Costpoint checks to see whether the project exists in the Project Labor Category table. If it does, then the project and PLC combination must exist in the Project Labor Category table. If a work force is required for the project, the work force project, employee ID, and PLC combination must exist in the Project Employee Labor Category table.

JE Vendor Labor Table

The JE Vendor Labor table is filled as follows:

Field	Source	Costpoint performs these Validations
Sequence Number (SEQ_NO)	The Input File.	Vendor Subline Number is a required field and must exist in the Input File. The Vendor Subline Number must be numeric. The Vendor Subline Number must start with 1 and must be sequential within each unique journal entry number, journal entry line number, Journal Type Code, Fiscal Year, and Period combination.
Labor Hours (LAB_HRS)	The Input File.	Labor Hours is a required field and must exist in the Input File. The Labor Hours field must be numeric.
Labor Amount (LAB_AMT)	The Input File.	Labor Amount is a required field and must exist in the Input File. The Labor Amount field must be numeric.
Vendor ID (VEND_ID)	The Input File.	Vendor ID is a required field and must exist in the Input File. The Vendor ID must exist in the Vendor table.
Vendor Employee ID (VEND_EMPL_ID)	The Input File.	The Vendor ID and Vendor Employee ID combination must exist in the Vendor Employee table.
Vendor Effective Billing Date (EFFECT_BILL_DT)	The Input File.	The Vendor Effective Billing Date must either exist in the Input File or have a default value available. The default value is the Subperiod End Date. If the Vendor Effective Billing Date is supplied in the Input File, it must be a valid date, in the following format: YYYY-MM-DD.
General Labor Category (GENL_LAB_CAT_CD)	The Input File.	The GLC is a required field and must exist in the Input File. The GLC must exist in the General Labor Category table.
Project Labor Category (BILL_LAB_CAT_CD)	The Input File. The default value may be derived from the Project Vendor Labor Category table for the project and vendor ID combination, or from the Project Labor Category Map table for the project and GLC combination.	A Project is required in order to enter a PLC. The PLC must exist in the Billing Labor Category table. If a work force is not required for the project, Costpoint checks to see whether the project exists in the Project Labor Category table. If it does, then the project and PLC combination must exist in the Project Labor Category table. If a work force is required for the project, the work force project, vendor ID, and PLC combination must exist in the Project Vendor Labor Category table.

Report Error Messages

The following errors may appear on the Error Report.

A list of the Costpoint tables used by this preprocessor and their corresponding Costpoint screens can be found at the end of this topic.

Account

Error Message	Meaning/Related Information
A Project cannot be used with this account.	The Project Required option on the Maintain Accounts screen in Costpoint General Ledger was not selected for the account, but a project was found in the Input File.
Contains segments that are too long.	The account in the Input File has one or more segments that are longer than the specified length for the segment.
Contains too many segments.	The account in the Input File has too many delimiters.
ID / Account Group Setup mismatch.	The account from the Input File and the default account found in the Account Group Setup table for the project account abbreviation supplied in the Input File did not match.
Not a detail account.	The Detail option on the Maintain Accounts screen in Costpoint General Ledger has not been selected for the account in the Input File. You cannot charge accounts unless they are marked as detail.
Not formatted due to a fatal error.	A fatal error occurred when Costpoint tried to check the input mask format. Please call for Technical Support.
Not found in Acct Entry Groups table.	The account entry group assigned to the account in the Input File does not include journal entries.
Not found in Acct table.	The account in the Input File does not exist in the Account table.
Project is required for this account.	The Project Required option on the Maintain Accounts screen in Costpoint General Ledger has been selected for the account, but no project was found in the Input File.
Reformatted to match defined structure.	The account in the Input File does not match the input mask for accounts. It has been padded with spaces or zeroes to match the input mask.
Too long for the defined structure.	The account in the Input File is longer than the specified length for accounts.

Cycle

Error Message	Meaning/Related Information
Needed for recurring JE.	The Cycle field in the Input File is blank, but the journal type code is RJE.
Not found in Cycle table.	The Cycle field in the Input File does not exist in the Cycle table.

Empl Labor Record

Error Message

Meaning/Related Information

No matching JE Trans Line Record.

No JE Transaction Line record was found that matched this Employee Labor Record's input Journal entry Number, Journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination.

Employee Amount

Error Message	Meaning/Related Information
Must be in Input File.	The Employee Amount field in the Input File is blank.
Not numeric.	The Employee Amount field in the Input File is not numeric.

Empl Effective Billing Dt

Error Message

Meaning/Related Information

Not a valid date.

The Employee Effective Billing Date field in the Input File either is not a valid date or is in the wrong format. All dates must be in the following format: YYYY-MM-DD.

Employee Effective Billing Date

Error Message	Meaning/Related Information
Must be in Input File.	The Employee Effective Billing Date field in the Input File is blank and no valid default subperiod end date could be found.

Employee Hours

Error Message	Meaning/Related Information
Must be in Input File.	The Employee Hours field in the Input File is blank.
Not numeric.	The Employee Hours field in the Input File is not numeric.

Employee ID

Error Message	Meaning/Related Information
Must be in Input File.	The Employee ID field in the Input File is blank.
Not found in Employee table.	The Employee ID in the Input File does not exist in the Employee table.

FY/PD/Subpd and Jnl Cd

Error Message	Meaning/Related Information
Not found in Subperiod Journal Status Table.	The fiscal year, accounting period, and subperiod combination along with the code AJE or RJE does not exist in the Subperiod Journal Status table.
Not open in Subperiod Journal Status Table.	The fiscal year, accounting period, and subperiod combination along with the code AJE or RJE is unavailable in the Subperiod Journal Status table.

GLC

Error Message	Meaning/Related Information
No default could be provided.	The GLC field in the Input File is blank and a default was not found.
Not found in Genl Labor Cat table.	The GLC in the Input File does not exist in the General Labor Category table.

Header Data

Error Message

Meaning/Related Information

Inconsistent data.

The header data must be identical on each line of an individual journal entry. The Contents column on the Error Report will identify the field that had incompatible data.

The possible fields are Reversal Flag, Subperiod Number, Header Description, and Recurring Cycle.

Header Description

Error Message	Meaning/Related Information
Must be in Input File.	The Header Description field in the Input File is blank.

Input Journal Number

Error Message	Meaning/Related Information
Must be in Input File.	The Input Journal Number field in the Input File is blank.
Not numeric.	The Input Journal Number field in the Input File is not numeric.

Input Empl Subline Num

Error Message	Meaning/Related Information
Must be in Input File.	The Employee Subline Number field in the Input File is blank.
Not numeric.	The Employee Subline Number field in the Input File is not numeric.
Not sequential beginning with 1.	The Employee Subline Number field in the Input File is not sequential, starting with the number 1, within each unique journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination.

Input Employee Labor Line

Error Message	Meaning/Related Information
Duplicate Employee Labor record in Input File.	The journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination was not unique among the employee labor line records.

Input JE Trans Line Num

Error Message	Meaning/Related Information
Has both Vendor and Empl Labor lines.	Both Vendor Labor records and Employee Labor records were found for this JE Transaction Line Number. Each transaction line can only have one type of labor record associated with it.
Must be in Input File.	The JE Transaction Line Number field in the Input File is blank.
Not numeric.	The JE Transaction Line Number field in the Input File is not numeric.
Not sequential beginning with 1.	The JE Transaction Line Number field in the Input File is not sequential, starting with the number 1, within each unique Journal Entry Number, Journal Type Code, Fiscal Year, and Period combination.

Input JE Transaction Line

Error Message	Meaning/Related Information
Duplicate JE Transaction record in Input File.	The journal entry Number, Journal Type Code, Fiscal Year, and Period combination was not unique among the transaction line records.

Input Vendor Labor Line

Error Message	Meaning/Related Information
Duplicate Vendor Labor record in Input File.	The journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination was not unique among the vendor labor line records.

Input Vendor Subline Num

Error Message	Meaning/Related Information
Must be in Input File.	The Vendor Subline Number field in the Input File is blank.
Not numeric.	The Vendor Subline Number field in the Input File is not numeric.
Not sequential beginning with 1.	The Vendor Subline Number field in the Input File is not sequential, starting with the number 1, within each unique journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination.

JE Balance

Error Message	Meaning/Related Information
Balance of debits and credits must be equal.	When the transaction amount on each individual line of a journal entry is totaled, the balance must equal zero. The Contents column on the Error Report will identify the non-zero balance for the journal entry.

Journal Entry

This validation will be performed only if the input journal numbers are to be used when importing journal entries to the Costpoint tables.

Error Message	Meaning/Related Information
Adjusting JE already exists in JE Header.	An adjusting journal entry already exists in the JE Header table with the same input journal number, code, fiscal year, and period.
Adjusting JE already exists in JE Header HS.	An adjusting journal entry already exists in the JE Header History table with the same input journal number, code, fiscal year, and period.
Recurring JE already exists in JE Header.	A recurring journal entry already exists in the JE Header table with the same input journal number and code.
Recurring JE already exists in JE Header HS.	A recurring journal entry already exists in the JE Header History table with the same input journal number and code.
JE already exists in Recurring JE Template.	A recurring journal entry already exists in the Recurring JE Template table with the same input journal number.

Journal Type Code

Error Message	Meaning/Related Information
Not AJE or RJE.	The Journal Type Code in the Input File is not AJE (Adjusting), RJE (Recurring), or blank.

Org/Acct

Error Message	Meaning/Related Information
Not active.	The account and organization combination is not flagged as Active in the Organization Account table.
Not active in selected fiscal year.	The fiscal year of the record in the Input File is not within the starting and ending fiscal years for the account and organization combination in the Organization Account table.
Not active in selected period.	The accounting period of the record in the Input File is not within the starting and ending periods for the account and organization combination in the Organization Account table.
Not found in Acct/Org table.	The account and organization combination does not exist in the Organization Account table.

Organization

Error Message	Meaning/Related Information
Abbreviation not found.	The Organization Abbreviation from the Input File does not exist in the Organization table.
Contains segments that are too long.	The Organization in the Input File has one or more segments that are longer than the specified length for the segment.
Contains too many segments.	The Organization in the Input File has too many delimiters.
ID / Abbreviation mismatch.	The Organization and Organization Abbreviation supplied in the Input File did not match in the Organization table.
Invalid base segment.	The Organization in the Input File has a base segment that is invalid. It is either too large or does not exist in the Organization table.
Not formatted due to a fatal error.	A fatal error occurred while trying to check the input mask format. Please call Technical Support.
Not found in Org table.	The Organization from the Input File does not exist in the Organization table.
Organization was not found.	Because neither the Organization nor the Organization Abbreviation was supplied in the Input File, Costpoint attempted to look up the Owning Organization set up in the Project table as the default organization. The lookup failed for one of the following reasons: A project was not supplied. The project was supplied but did not exist in the Project table. The project was found, but the Default to Owning Org option was not selected for the project in the Maintain Project Master screen in Costpoint Project Setup.
Reformatted to match defined structure.	The Organization in the Input File does not match the input mask for the top-level organization. It has been padded with spaces or zeroes to match the input mask.
Too long for the defined structure.	The Organization in the Input File is longer than the specified length for the top-level organization.

Period

Error Message	Meaning/Related Information
Not numeric.	The Period Number in the Input File is not numeric and is not blank.

PLC

Error Message	Meaning/Related Information
Not found in Bill Lab Cat table.	The PLC in the Input File does not exist in the Billing Labor Category table.
PLC requires a Project.	You entered a PLC but not a Project.
Project requires a PLC.	You entered a Project but not a PLC.

Proj / Empl / PLC

Error Message	Meaning/Related Information
Proj/Empl/PLC Work force combo does not exist.	The work force project, employee ID, PLC combination does not exist.

Proj / Vend / PLC

Error Message	Meaning/Related Information
Proj/Vend/PLC Work force combo does not exist.	The work force project, vendor ID, PLC combination does not exist.

Project / Acct

Error Message	Meaning/Related Information
Combo not valid in ACCT_GRP_SETUP.	The project and account combination is not valid.

Project / PLC

Error Message	Meaning/Related Information
PLC not authorized for Project.	The Project and PLC combination does not exist.

Project

Error Message	Meaning/Related Information
Abbreviation not found.	The project abbreviation from the Input File does not exist in the Project table.
Contains segments that are too long.	The project in the Input File has one or more segments that are longer than the specified length for the segment.
Contains too many segments.	The project in the Input File has too many delimiters.
ID / Abbreviation mismatch.	The project and project abbreviation supplied in the Input File did not match in the Project table.
Invalid base segment.	The project in the Input File has a base segment that is invalid. It is either too large or does not exist in the Project table.
Not active.	The Active option is not selected on the Maintain Project Master screen in Costpoint Project Setup.
Not formatted due to a fatal error.	A fatal error occurred when Costpoint tried to check the input mask format. Please call for Technical Support.
Not found in Project Master table.	The project in the Input File does not exist in the Project table.
Reformatted to match defined structure.	The project in the Input File does not match the input mask for the top level project. It has been padded with spaces or zeroes to match the input mask.
Too long for the defined structure.	The project in the Input File is longer than the specified length for the top level project.

Project Account Abbrev

Error Message

Meaning/Related Information

Required when Account is not supplied.

The account was not supplied in the Input File; therefore, the project account abbreviation is required in the Input File to look up a default account.

Requires a Project.

The project account abbreviation was supplied in the Input File, but a valid project was not found.

Proj/Acct

Error Message	Meaning/Related Information
Not active.	Active is not selected in the Project Organization Account table.
Not found in Proj/Org/Acct table.	The Validate Project Charging by Organizations option is not selected in the Project Settings screen in Costpoint Project Setup, and the combination of project and account does not exist in the Project Organization Account table.

Project/Proj Acct Abbrev

Error Message	Meaning/Related Information
Not found in Account Group Setup table.	The project and project account abbreviation combination supplied in the Input File does not exist in the Account Group Setup table.

Proj/Org/Acct

Error Message	Meaning/Related Information
Not active.	Active is not checked in the Project Organization Account table.
Not found in Proj/Org/Acct table.	The *Validate Project Charging by Organizations* option in the Project Settings screen in Costpoint Project Setup is not selected, and the combination of project, organization, and account does not exist in the Project Organization Account table.

Record Type

Error Message	Meaning/Related Information
Not L, E or V.	The Record Type field in the Input File is not a valid type (L, E, or V).

Reference Number 1

Error Message	Meaning/Related Information
Contains segments that are too long.	The Reference Number 1 field in the Input File has one or more segments that are longer than the specified length for the segment.
Contains too many segments.	The Reference Number 1 field in the Input File has too many delimiters.
Invalid base segment.	The Reference Number 1 field in the Input File has a base segment that is invalid. It is either too large or does not exist in the Reference Structure table.
May not be used in data entry.	The Reference Number 1 field in the Input File was found in the Reference Structure table, but the Use in Data Entry option in the Define Ref Structures screen in Costpoint General Ledger was not selected.
Not found in Reference table.	The Reference Number 1 field in the Input File is not blank and the value does not exist in the Reference Structure table.
Not formatted due to a fatal error.	A fatal error occurred when Costpoint tried to check the input mask format. Please call for Technical Support.
Reformatted to match defined structure.	The Reference Number 1 field in the Input File does not match the input mask for the reference 1. It has been padded with spaces or zeroes to match the input mask.
This entry is not valid as a reference 1.	The Reference Number 1 field in the Input File was found in the Reference Structure table, but the reference entry code was not set to reference 1.
Too long for the defined structure.	The Reference Number 1 field in the Input File is longer than the specified length for the top-level reference 1.

Reference Number 2

Error Message	Meaning/Related Information
Contains segments that are too long.	The Reference Number 2 field in the Input File has one or more segments that are longer than the specified length for the segment.
Contains too many segments.	The Reference Number 2 field in the Input File has too many delimiters.
Invalid base segment.	The Reference Number 2 field in the Input File has a base segment that is invalid. It is either too large or does not exist in the Reference Structure table.
May not be used in data entry.	The Reference Number 2 field in the Input File was found in the Reference Structure table, but the Use in Data Entry option in the Define Ref Structures screen in Costpoint General Ledger was not selected.
Not formatted due to a fatal error.	A fatal error occurred when Costpoint tried to check the input mask format. Please call for Technical Support.
Not found in Reference table.	The Reference Number 2 field in the Input File is not blank and the value does not exist in the Reference Structure table.
Reformatted to match defined structure.	The Reference Number 2 field in the Input File does not match the input mask for reference 2. It has been padded with spaces or zeroes to match the input mask.
This entry is not valid as a reference 2.	The Reference Number 2 field in the Input File was found in the Reference Structure table, but the reference entry code was not set to reference 2.
Too long for the defined structure.	The Reference Number 2 field in the Input File is longer than the specified length for the top-level reference 2.

Reversal Flag

Error Message	Meaning/Related Information
Must be in Input File.	The Reversal Flag field in the Input File is blank.
Not Y or N.	The Reversal Flag field in the Input File is not Y (Yes) or N (No).

Reversing FY/PD/Sub PD

Error Message	Meaning/Related Information
Next period not found.	Costpoint cannot find a reversing fiscal year, accounting period, and subperiod combination for the next period that exists in the Subperiod table.
Not open.	The reversing fiscal year, accounting period, and subperiod combination is flagged as Closed in the Subperiod table.

Subperiod

Error Message	Meaning/Related Information
Not numeric.	The Subperiod field in the Input File is not numeric and is not blank.

Transaction Amt

Error Message	Meaning/Related Information
Must be in Input File.	The Transaction Amount field in the Input File is blank.
Not numeric.	The Transaction Amount field in the Input File is not numeric.

Tran Amt, Sum of Empl Amt

Error Message	Meaning/Related Information
JE Trans Line Amt must = Sum of Empl Amt.	The sum of the Employee Amount field on all Employee Labor records in the Input File for this journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination does not match the Transaction Amount field on the corresponding JE Transaction Line record.

Tran Amt, Sum of Vend Amt

Error Message	Meaning/Related Information
JE Trans Line Amt must = Sum of Vend Amt.	The sum of the Vendor Amount field on all Vendor Labor records in the Input File for this journal entry Number, Journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination does not match the Transaction Amount field on the corresponding JE Transaction Line record.

Vend / Vend Empl

Error Message	Meaning/Related Information
Not in Vend Empl table.	The Vendor ID and Vendor Employee ID combination in the Input File does not exist in the Vendor Employee table.

Vendor Amount

Error Message	Meaning/Related Information
Must be in Input File.	The Vendor Amount field in the Input File is blank.
Not numeric.	The Vendor Amount field in the Input File is not numeric.

Ven Effective Billing Dt

Error Message

Meaning/Related Information

Not a valid date.

The Vendor Effective Billing Date field in the Input File either is not a valid date or is in the wrong format. All dates must be in the following format: YYYY-MM-DD.

Vendor Effective Billing Date

Error Message	Meaning/Related Information
Must be in Input File.	The Vendor Effective Billing Date field in the Input File is blank and no valid default subperiod end date could be found.

Vendor Hours

Error Message	Meaning/Related Information
Must be in Input File.	The Vendor Hours field in the Input File is blank.
Not numeric.	The Vendor Hours field in the Input File is not numeric.

Vendor ID

Error Message	Meaning/Related Information
Must be in Input File.	The Vendor ID field in the Input File is blank.
Not found in Vendor table.	The Vendor ID in the Input File does not exist in the Vendor table.

Vendor Labor Record

Error Message

Meaning/Related Information

No Matching JE Trans Line Record.

No JE Transaction Line record was found that matched this Vendor Labor Record's input journal entry Number, journal entry Transaction Line Number, Journal Type Code, Fiscal Year, and Period combination.

Screen Error Messages

The following error messages may display on the screen.

Each line of the Input File should contain X fields. Line Y of your Input File contains Z fields. Abort processing?

X is the number of fields that the Input File should contain. Y is the line number of the current record. Z is the number of records found on this line in the Input File. This message displays only if you are importing a comma-separated file. Too many commas were found on the line in the Input File and continuing to process may result in errors. You need to verify the layout of the Input File.

Errors have occurred that may need correcting. Do you want to continue?

This message displays if errors are discovered during processing. You should review the Error Report. The options available at this point are: Import the records that have been validated, make any changes needed in the error file, rename the error file, and then process the errors; or, make any corrections needed to the original Input File and process again.

File does not exist.

The Input File you specified could not be found. The Input File must be in your work directory. Check your working directory via File Properties in the Windows Program Manager.

No records found in table. Please process file before importing or printing.

You clicked Print or Import and there are no rows in the temporary table.

Range of JE Numbers used for Adjusting JEs FY: XXXXXX PD: XX Type: AJE XXXXXXXXX to XXXXXXXXX

Displays the range of journal numbers assigned by Costpoint for an adjusting journal entry. This message repeats for each unique adjusting JE fiscal year and period combination.

Range of JE Numbers used for Recurring JEs: Type: AJE XXXXXXXXX to XXXXXXXXX

Displays the range of journal numbers assigned by Costpoint for all recurring JEs.

Records that have not been imported exist in the temporary table. Do you want to continue?

You clicked Process but there are still rows in the temporary table that have not been imported.

Select Yes to continue, and all the rows in the temporary table will be deleted.
Select Cancel to import the existing rows in the temporary table or if you need to investigate the rows in the temporary table.

The database is unable to process the records required for the requested activity. Possible reasons are: another user is using a record you wish to update, database error or hardware malfunction.

When this error occurs, make note of what was being done and at what point Costpoint stopped, then call for Technical Support.

Journal Entries to be imported already exist in the JE Header table. This condition must be corrected before importing.

When you click Import, Costpoint compares the rows in the temporary table to the JE Header table and JE Header History table to see whether duplicates exist. A journal entry with the same journal number, code, fiscal year, and period already exists for one or more journal entries in the JE Header table or JE Header History table. This indicates that journal entries have been added to Costpoint sometime between the processing of the Input File and the import of the journal entry file. If this message displays, the temporary table will not be imported to the journal entry tables in order to prevent uploading duplicate records.

Journal Entries to be imported already exist in the Recurring JE Template table. You must correct this condition before importing.

When you click Import, Costpoint compares the rows in the temporary table to the Recurring JE Template table to see whether duplicates exist. A journal entry with the same journal number already exists for one or more journal entries in the Recurring JE Template table. This indicates that journal entries have been added to Costpoint sometime between the processing of the Input File and the import of the journal entry file. If this message displays, the temporary table will not be imported to the journal entry tables, in order to prevent uploads of duplicate records.

X 'Y' on Input File line Z is too long. Truncate?

X is the field name. Y is the contents of the field. Z is the line number of the record in question. This message displays only when a comma-separated file is being imported and you have elected to be warned before truncation. This indicates that the field in the Input File is longer than the corresponding field in Costpoint. The extra characters on the right will be truncated.

Technical Details

Tables Read

Table	Menu
Account (ACCT)	Accounting » General Ledger » Accounts » Maintain Accounts
Account Entry Rules (ACCT_ENTRY_RULES)	Accounting » General Ledger » Controls » Account Entry Groups
Account Group Setup (ACCT_GRP_SETUP)	Projects » Project Setup » Controls » Project Account Groups
Accounting Period (ACCTING_PD)	Accounting » General Ledger » Controls » Accounting Periods
Billing Labor Category (BILL_LAB_CAT)	Projects » Project Setup » Project Labor » Set Up Project Labor Categories (PLC)
Cycle (CYCLE)	Accounting » General Ledger » Controls » JE Cycles
Default Regular Timesheet (DFLT_REG_TS)	People » Employee » Basic Employee Setup » Basic Employee Info
Employee (EMPL)	People » Employee » Basic Employee Setup » Basic Employee Info
Fiscal Year (FY)	Accounting » General Ledger » Controls » Fiscal Years
General Labor Category (GENL_LAB_CAT)	People » Labor » Labor Controls » General Labor Categories
General Ledger Configuration File (GL_CONFIG)	Accounting » General Ledger » Controls » G/L Settings
JE Header History (JE_HDR_HS)	Accounting » General Ledger - Journal Entries (JEs) » Print JE Posting Summaries
JE Suspense Setup (X_JE_SUSP_SETUP)	Others » Product Interfaces » Preprocessors » Journal Entry Suspense Setup
Organization (ORG)	Accounting » General Ledger » Organizations » Maintain Org Elements
Organization Account (ORG_ACCT)	Accounting » General Ledger » Accounts » Maintain Account/Org Links
Project (PROJ)	Projects » Project Setup » Project Master » Basic Info
Project Control (PROJ_CNTL)	Projects » Project Setup » Controls » Project Settings
Project Edit (PROJ_EDIT)	Projects » Project Setup » Project Master » Basic Info
Project Employee (PROJ_EMPL)	Projects » Project Setup » Project Labor » Project Employee Work Force
Project Employee Labor Category (PROJ_EMPL_LAB_CAT)	Projects » Project Setup » Project Labor » Assign PLC to Employee Work Force
Project Labor Category (PROJ_LAB_CAT)	Projects » Project Setup » Project Labor » Assign PLC to Projects
Project Labor Category Map (PROJ_LAB_CAT_MAP)	Projects » Project Setup » Project Labor » Link GLC to Project PLC
Project Vendor (PROJ_VEND)	Projects » Project Setup » Project Labor » Project Vendor Work Force
Project Vendor Labor Category (PROJ_VEND_LAB_CAT)	Projects » Project Setup » Project Labor » Assign PLC to Vendor Work Force
Project Organization Account (PROJ_ORG_ACCT)	Projects » Project Setup » Project Master » Maintain Valid Project/Account/Orgs
Reference Structure (REF_STRUC)	Accounting » General Ledger » Reference Numbers (Ref) » Define Ref Structures
Subperiod (SUB_PD)	Accounting » General Ledger » Controls » Subperiods
Subperiod Journal Status (SUB_PD_JNL_STATUS)	Accounting » General Ledger » Controls » Subperiods
Vendor (VEND)	Accounting » Accounts Payable » Vendor Info » Maintain Vendors
Vendor Employee (VEND_EMPL)	Accounting » Accounts Payable » Vendor Info » Maintain Vendor Employees
Input File (User named)

Tables Read and Written

Table	Menu
Function Parameter Catalog (FUNC_PARMS_CATLG)
JE Header (JE_HDR)	Accounting » General Ledger » Journal Entries (JEs) » Enter JEs
JE Transaction (JE_TRN)	Accounting » General Ledger » Journal Entries (JEs) » Enter JEs
Last JE No (LAST_JE_NO) (Used for adjusting journal numbers only.)
Posting Semaphore (POST_SEMAPHORE)
Recurring JE Template (RECUR_JE_TMPLT)	Accounting » General Ledger » Journal Entries (JEs) » Enter JEs
Sequence Generator (SEQ_GENERATOR)
JE Prep Parameters (PARMS_AOPUTLJE)	Others » Product Interfaces » Preprocessors » Journal Entry Preprocessor

Tables Written

Table	Menu
JE Reversal (JE_RVRS)	Accounting » General Ledger » Journal Entries (JEs) » Enter JEs
JE Employee Labor (JE_TRN_LAB_EMPL)	Accounting » General Ledger » Journal Entries (JEs) » Enter JEs
JE Vendor Labor (JE_TRN_LAB_VEND)	Accounting » General Ledger » Journal Entries (JEs) - Enter JEs

Output Files

The following output files are generated by this preprocessor:

Error File (Input File name + .ERR)
Edit Report
Error Report