Proceed with the transfer process as soon as you have calculated and posted the bills for IWO projects. All untransferred records (IWO_XFR_FL=N) in the Billing Detail History (BILLING_DETL_HIST) table will be used as the basis for the IWO allocation. The creation process is run by the performing database and is an Inception to Date (ITD) calculation. When IWO entries are created, they are marked with a location. This location identifies the receiving database. It may or may not be the same as the sending database. The process produces two journal entries: one for the sending database and one for the receiving database. The accounts to be used in the journal entry are designated in the IWO Project Setup screen. The two entries are stored in the IWO Allocation Header (IWO_ALLOC_HDR), IWO Allocation Transaction (IWO_ALLOC_TRN), and IWO Allocation Labor (IWO_ALLOC_LAB) tables. If labor is also transferred, it is stored separately in the third of these three IWO staging tables. The system uses the tables to send the data to another database, if necessary, or to just hold the data for posting if the sending and receiving databases are the same. In the receiving database, the data is posted to the Open Billing Detail table, all the general ledger tables, and the Labor History table of the receiving database. The S_JNL_CD in the GL_POST_SUM table will be shown as IWO.
This screen is the fourth step in the IWO process.
Select the range of IWO projects that you want to process. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter the starting project for the range you want to process. If you select All or From Beginning in the Range Option field, this field will be inactive.
Enter the ending project for the range you want to process. If you select All, One, or To End in the Range Option field, this field will be inactive.
Only transactions in the BILLING_DETL_HIST table that have a fiscal year, period, and subperiod that falls on or before the date entered here will be selected for transfer.
Select the ending fiscal year that will be used to select data from the Billing History table.
Select the period that will be used to select data from the Billing History table.
Select the subperiod that will be used to select data from the Billing History table. The field to the right will display the subperiod date.
Click this icon on the toolbar to allocate the IWO projects.
The source of the data for the entries is the Billing Detail History (BILL_DETL_HIST) table.
Sending Database entry
Dr. - IWO Inter-company Receivable (defined in the IWO Project Setup screen (Projects » Inter-Company Work Orders » Controls)). One of the three, or four if you select cost instead of revenue, accounts defined in that screen.
Cr. - Unbilled Receivable
or, if you selected Cost Transfer in the IWO Project Setup screen (Projects » Inter-Company Work Orders » Controls):
Dr. - IWO Inter-company Receivable (Defined in the IWO Project Setup screen)
Cr. - IWO Cost Transfer Out (Defined in the IWO Project Setup screen)
Receiving Database entry
Dr. - Each receiving expense account (defined in the IWO Expense Mapping screen (Projects » Inter-Company Work Orders » Controls) and mapped to sending direct cost, indirect cost, and revenue accounts in the Link Expenses subtask). In the main screen, you have defined each account on the receiving project that will take expenses and, in the subtask, which accounts will feed that account from the sending project .
Cr. - IWO Inter-company Payable (Defined in IWO Project Setup screen)
After you create the entry, the system creates the two journal entries in the IWO Allocation Header (IWO_ALLOC_HDR) table. Supporting detail is created in the IWO Allocation Transaction (IWO_ALLOC_TRN) table. If labor entries are part of the transfer, the detail is in the IWO Allocation Labor (IWO_ALLOC_LAB) table. You can review these entries, but only the account and organization are editable. Once you have reviewed the entries and found them acceptable, use the Export IWO Allocations screen (Projects » Inter-Company Work Orders) to export them to the receiving database.