Replace

The Replace mode replaces all the transactions in the database for the given scenario, year, period, entity with the transactions specified in the load file. In the Replace mode, the system first clears all records for the entity for the scenario, year, period. If the system encounters any intercompany transactions for the entity that have a status of Posted or Matched, it does not clear those transactions; it skips them and continues with the load process. After clearing all applicable transactions for the entity, the system replaces all transactions for the entity with the records from the load file.

Table 16. Example of Load In Replace Mode  

Entity A - Existing Records

Load File for Entity A

Entity A After Load in Merge Mode

Record 1

N/A

N/A

Record 2 - Matched

New Record 2

Record 2 - Matched (not affected by clear or load process)

Record 3

N/A

N/A

Record 4 - Posted

New Record 4

Record 4 - Posted (not affected by clear or load process)

Record 5

New Record 5

New Record 5

N/A

New Record 6

New Record 6