Inter-Company Work Orders

The purpose of this manual is to provide, screen-by-screen, the instructions for the setup, processing, and transfer of Inter-Company Work Order (IWO) information. Costpoint Inter-Company Work Orders is an add-on module and may not be suitable for all Costpoint customers.

 Please check with your Costpoint consultant before running this process. When processing transactions in this module, follow all instructions carefully.

You must enter some supporting data for this module into screens in other modules. For those screens, please refer to the documentation for that module. You set up Costpoint Inter-Company Work Orders with the three screens in the Controls menu. Processing includes those steps that need to be accomplished up to the point of transfer.

Before an IWO project can be set up, you must have previously set up a project with a classification of Inter-Company and entered a billing formula for that project. You must also set up two screens in the Controls menu, Configure Transfer Locations and Manage IWO Expense Mappings, because these contain codes required to complete the IWO project setup.

You must post bills for IWO projects before transferring IWO data to the receiving project. You must do this because the data transferred during the process is from the BILLING_DETL_HIST table. Billing and Receivable tables are updated as usual by the Post Bills program. As part of the IWO process, you must run the Create IWO Allocations screen. This creates an IWO allocation journal entry that updates the General Ledger when the entry is posted.

If you are transferring IWO allocations from one database to another, you must export data from the sending database, import data into the receiving database, preprocess the data to validate account, organization, and project information, and finally post journal entries in the receiving database.

Warning: IWO projects must have a Project Classification of INTER-COMPANY on the Basic Info tab of the Manage Project User Flow AND must be set up on the Manage IWO Projects screen before you post IWO bills. These criteria preclude the posting of IWO bills to the General Ledger

Because there are two types of IWO transactions, one within the database and one to a different database, not all screens may be needed. Following is a list, in order, of the steps used in the IWO process:

For internal transfers:

1. Configure Transfer Locations screen
2. Manage IWO Expense Mappings screen
3. Manage IWO Projects screen
4. Create IWO Allocations screen
5. Manage IWO Allocations screen
6. Post IWO Journal screen

For external transfers:

1. Configure Transfer Locations screen
2. Manage IWO Expense Mappings screen
3. Manage IWO Projects screen
4. Create IWO Allocations screen
5. Manage IWO Allocations screen
6. Export IWO Allocations screen
7. Import IWO Allocations screen
8. Validate IWO Allocations screen
9. Validate IWO Suspense Transactions screen
10. Post IWO Journal screen