Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Contents of the Manage IWO Expense Mapping Screen

Use the fields and options to configure the Manage IWO Expense Mapping screen.

Identification

Field Description
Expense Mapping Code

Enter a unique alphanumeric code to represent the account mapping that you are creating in this screen.

Description

Enter a alphanumeric code to describe the expense mapping.

Validate Accounts

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.

Posting Account

Use this table window to establish the mapping of receiving to sending accounts.  Click to activate the first line in the table window.

Field Description
Account

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.

Account Name

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.

Technical Information

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.

Subtasks

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.