Validate IWO Allocations

Use this screen to review the imported data and validate it against the receiving database structure.

Using this screen, you can:

  • Examine a range of sending locations,
  • Examine a range of transfer entries,
  • Place all failed entries into a suspense account for later review and correction, and
  • Define the year, period, and subperiod into which to post the entry.

An entry is either accepted or rejected in its entirety. If data is rejected, you can post the failed lines to a suspense account. If you choose not to do this, the entire entry is put on hold and an error report is printed showing the reason for rejection. You can make corrections to the Organization, Account, and Project on the Validate IWO Suspense Transactions screen. You can also edit information related to sales tax and value-added tax in the Destination Sales Tax Code, Recovery Percent, Recovery Suspense Account, and Recovery Suspense Organization fields in Validate IWO Suspense Transactions. Amount fields are non-editable. If accepted, the entry is moved out of the IWO_ALLOC_XXX_SUSP tables into the IWO_ALLOC_XXX tables.

If you set up the IWO project to transfer to a single employee (that is, you selected To Single Employee for Labor Transfer on the Manage IWO Projects screen), Validate IWO Allocations changes the general labor category (GLC) of labor transactions for the IWO receiving entry when the IWO project is imported and validated. It uses the following hierarchy:

  1. Costpoint checks the GLC field on the Timesheet Defaults tab of the Manage Employee Information screen. If the field is not null, this is the GLC that replaces the GLCs in IWO labor transactions.
  2. If the GLC field above is null, Costpoint checks the GLC field on the Salary Info tab of the Salary Details subtask of Manage Employee Information. If the field is not null, the GLC with the latest effective date is the GLC used to replace the GLCs in IWO labor transactions.
  3. If both fields above are null, Costpoint retains the GLCs in the original billing transactions.
Note: Validate IWO Allocations uses this hierarchy for external IWO transfers only. For internal IWO transfers, the Create IWO Allocations application replaces the GLC in labor transactions for a single employee.

This screen is step nine for external transfers. Use this screen before posting the IWO invoices, if the transfer is between different databases. If the IWO transfer is within the same database, this screen is not necessary.