CONSOLIDATION TRANSFER HISTORY

Use this screen to initialize the transfer history. The transfer history is a summarization by receiving location, fiscal year, and consolidation account/ organization of previous amounts transferred. It is updated each time a consolidation entry is created. The consolidation account/organization that you initialize is the account/ organization into which the costs will be transferred. This is the same set of account/organizations stored in the Consolidation Mapping table (CONS_MAP_WILDCARD).

If you change the consolidation mapping, you must update the consolidation transfer history to reflect the changes. The consolidation creation process is always an adjustment between costs incurred and previous amounts transferred. Costs incurred are translated or converted into these account/organizations and added to this history when the comparison is performed. This allows for prior period adjustments to be made and captured in the next transfer. The system updates this table when you execute the Create Consolidation Entry function.

For mid-year conversions, you should execute this screen before the Create Consolidation Entry screen. Because the amounts from this screen are subtracted from the calculated General Ledger amounts to arrive at the consolidation entry, adjustments should not be needed unless a replacement entry is desired. You will not need to make adjustments in this screen when moving to a new fiscal year because the Create Consolidation Entry screen will create the initial record for that year. 

Receiving Location

Use the drop-down box to select the location to which you want to send consolidation information. All locations that have been entered in the Maintain Transfer Locations screen are available for selection.

When you select a receiving location, the receiving name is displayed in the non-editable field to the right.

Fiscal Year

Enter, or use the drop-down box to select, the fiscal year of the consolidation transfer.

Currency Info

Reporting Currency

This non-editable field displays the receiving company's currency. The non-editable field to the right displays the name of the receiving company's currency code.

Country Name

This non-editable field displays the receiving company's country name.

Previous Transfers

Period

Enter, or use Lookup to select, a period.

You must use this column when you set up consolidation beginning balances as part of a first-time Costpoint implementation. Later in the consolidation process, this process will be taken over by the system functionality in the Update Consolidation Beginning Balances application.

Consolidation Account

Enter, or use Lookup to select, the account to which costs have been transferred. Lookup includes the consolidation accounts from the Consolidation Acct/Org Mappings screen that have been linked to the receiving location in the Link Consolidation Locations screen.

Consolidation Organization

Enter, or use Lookup to select, the organization to which costs have been transferred. Lookup will include the consolidation organizations from the Consolidation Acct/Org Mappings screen that have been linked to the receiving location in the Link Consolidation Locations screen.

Previous Amount Transferred

This column displays the YTD amounts from the sending company after the last transfer. 

This column will display only if the reporting currency of the receiving location is the same as the functional currency of the sending location.

Previous Amt Trans Functional Currency

This column displays the YTD amounts in the functional currency of the sending company after the last transfer. 

This column will display only if the reporting currency of the Receiving Location is different from the functional currency of the sending location.

Previous Amt Trans Reporting Currency

This column displays the YTD amounts in the functional currency of the receiving company after the last transfer. 

This column displays only if the reporting currency of the receiving location is different from the functional currency of the sending location.

Account Name

This non-editable column displays the name of the consolidation account to which costs have been transferred.

Organization Name

This non-editable column displays the name of the consolidation organization to which costs have been transferred.

Table Information

Data entered in this screen is stored in the CONS_XFR_HS table.