INTER-COMPANY WORK ORDERS (IWOs) OVERVIEW

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. 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. Although a Billing Journal is printed, there is no entry to the General Ledger when you post the IWO bills. The transfer process from one database to another includes creating the journal entries, reviewing for errors, exporting data from the sending database, importing data into the receiving database, preprocessing the data to validate account, organization, and project information, and finally posting journal entries in the receiving database.

IWO projects must have a Project Classification of INTER-COMPANY in the Maintain Project Master screen (Projects » Project Setup » Project Master) AND must be set up in the IWO Project Setup screen (Projects » Inter-Company Work Orders » Controls) 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. Maintain Transfer Locations screen

  2. IWO Expense Mapping screen

  3. IWO Project Setup screen

  4. Create IWO Allocations screen

  5. Maintain IWO Allocations screen

  6. Post IWO Journal screen

For external transfers:

  1. Maintain Transfer Locations Screen

  2. IWO Expense Mapping screen

  3. IWO Project Setup screen

  4. Create IWO Allocations screen

  5. Maintain IWO Allocations screen

  6. Install Export/Import data sources (see Special Topic IW-1)

  7. Export IWO Allocations screen

  8. Import IWO Allocations screen

  9. IWO Allocation Preprocessor screen

  10. Maintain IWO Suspense screen

  11. Post IWO Journal screen