to activate the first line in the table window.Use this screen to define all the receiving accounts to be used in the IWO transfer entry. Use the Link Expenses subtask to link each of the receiving accounts to one or more sending accounts, optionally delimited by organizations. All accounts in the sending project’s project account group that have a function code of labor or non-labor must be linked to a receiving account. The IWO transfer process uses all transactions in the BILLING_DETL_HIST table during the transfer process. An error message results if there are missing links for transactions in this table. Only labor, non-labor, and units accounts exist in the BILLING_DETL_HIST table. Unit transactions, however, cannot be included in an IWO transfer.
If you want to transfer at the lowest level of detail, you can assign a new transfer account for each type of cost. These expense mappings are created here and later linked to the sending IWO projects. Create as many expense mappings as you need; however, only one expense mapping can be assigned to an IWO project.
At the conclusion of the IWO process, you post a journal entry to the receiving database, transferring costs from the sending location. The expenses on the receiving side may or may not have the same account numbers or structure as the sending database.
This is the second step in setting up the transfer process. Unless you have previously created transfer location(s), please begin the process with the Configure Transfer Locations screen.
Enter a unique alphanumeric code to represent the account mapping that you are creating in this screen.
Enter a alphanumeric code to describe the expense mapping.
If you select this check box, you cannot use accounts or organizations that have not passed Costpoint validations. This check box is usually selected for internal IWO transfers and left blank for external IWO transfers.
Use this table window to establish the mapping of receiving to sending accounts. Click to activate the first line in the table window.
Click and enter, or click 
to select, the receiving account number for this expense mapping. is available only if you selected the Validate Accounts check box.
Tab through the Account column to view the name of the posting account. No account name is displayed if you did not select the Validate Accounts check box.
IWO expense mapping (IWO_EXP_MAPPING) populates the IWO Expense Mapping screen.
The Expense Mapping field (IWO_EXP_MAP_CD) is a user-defined field. The entries in this field are later available in so that you can select an expense mapping group to which the IWO project is assigned on the Manage IWO Projects screen.
The Description field (IWO_EXP_MAP_DESC) is a user-defined field used to describe the Expense Mapping code.
The Validate Accounts check box (VALIDATE_ACCT_FL) tells Costpoint whether posting accounts need to be validated against the current account structure and content of the database. If an external database is receiving the transfer, the account structure may be different from the sending database. In this type of scenario, leave the check box blank. However, if you intend to transfer data internally within the current database, select this check box and ensure accounts created in this screen are correct at this time.
Modified by (MODIFIED_BY) is a field used by Costpoint to identify the user ID of the person making the entry or modification.
Time stamp (TIME_STAMP) is a field used by Costpoint to identify the time and date of the row creation or modification.
Row version (ROWVERSION) is a field used by Costpoint.
IWO expense account (IWO_EXP_ACCT) populates the table window of the Manage IWO Expense Mappings screen.
The IWO Expense Mapping code (IWO_EXP_MAP_CD) is a key created by Costpoint that maps the child table to the parent IWO expense mapping (IWO_EXP_MAPPING) table.
The Posting Account field (RCV_ACCT_ID) must be a valid account and have valid account structure for the receiving database. If you did not select the Validate Accounts check box, Costpoint does not validate this field. Therefore, be careful when entering accounts to ensure they pass the preprocessor edit after the transfer is made.
Modified by (MODIFIED_BY) is a field used by Costpoint to identify the user ID of the person making the entry or modification.
Time stamp (TIME_STAMP) is a field used by Costpoint to identify the time and date of the row creation or modification.
Row version (ROWVERSION) is a field used by Costpoint.
The Link To Expenses subtask creates the mapping from the receiving accounts entered in the table window. Highlight the row you want to map and click the Link to Expenses link.
To populate the IWO expense account line (IWO_EXP_ACCT_LN), use the Link To Expenses subtask. Functionally, the process is similar to the Accounts subtask of the Manage Generic Billing Formats screen.
These fields are on the Link Expenses subtask:
IWO Expense Mapping ID (IWO_EXP_MAP_CD) is a key created by Costpoint that maps the child table to the parent. The IWO expense account (IWO_EXP_ACCT) information from the main screen appears in a non-editable field directly below the expense mapping ID.
Receiving account code (RCV_ACCT_ID) data appears in the Posting Account field and is non-editable. This value matches the Posting Account on the line highlighted on the main screen.
IWO expense line account key (IWO_EXP_LN_AC_KEY) is a sequence number assigned by Costpoint that is used to uniquely identify the row in the table. The source of the next entry number is in the sequence generator table for this application.
Cost account ID (COST_ACCT_ID) is the Account field in the table window. This is the sending database account that maps to the posting account identified in the screen header. It must be a valid account in the current database. is available for this field.
Cost organization ID (COST_ORG_ID) is the Organization field in the table window. This field, if used, limits the account entry for the project to a specific organization. If all organizations charging to the project must be allowed for selection, leave this field blank. If only some of the organizations need to be transferred, each of the organizations to be transferred needs a separate line. is available for this field.
Allocation group number (ALLOC_GRP_NO) contains only group number one. In Costpoint Cost and Revenue Processing, the only pools that are posted to the General Ledger are those with allocation group number one. IWO creates that allocation group number in a field so that you can post the entry to the General Ledger.
Fiscal Year (FY_CD) is an optional field and, if used, limits data transferred to a specific fiscal year. If this field is left blank, all fiscal years' data are transferred.
Pool number (POOL_NO) field specifies the specific pool used to burden the costs for specific accounts to be transferred.
If you enter a Y (Yes) in the COM (COM_FL) field, cost of money for the specific pool is transferred. If you enter N (No), cost of money is not be included in the pool amount transferred.
If you select the check box in the Fee (FEE_FL) field, fee on costs is transferred. If you leave the check box blank, no fee costs is transferred.
If you select the check box in the Retainage (RTNGE_FL) field, retainage amounts are transferred for the whole account. If you do not select the check box, no retainage is considered. You need to make an entry in this field only once if there are multiple lines for a specific account.
If you select the check box in the Over Ceiling (OVER_CEIL_FL) field, ceiling amounts are transferred for the whole account. If you do not select the check box, no ceilings are considered. You need to make an entry in this field only once if there are multiple lines for a specific account.
Modified by (MODIFIED_BY) is a field used by Costpoint to identify the user ID of the person making the entry or modification.
Time stamp (TIME_STAMP) is a sfield used by Costpoint to identify the time and date of the row creation or modification.
Row version (ROWVERSION) is a field used by Costpoint.
|
Subtask |
Description |
|
Link to Expenses |
Select a line in the table and click this link to open the Link Expenses subtask where you can link an "outgoing" account and organization to the receiving project's account. |