The Single Journal Entry Import Assistant does not support updates.
For existing journal entries and existing intercompany journal entries, you need to use the CSV Import Assistant at Setup > Import/Export > Import Tasks > Import CSV Records, which can:
- Update transaction body field values
- Add lines to existing transactions
- Update values in existing journal entry lines
In the first step of the CSV Import Assistant select the import type (Transactions) and record type (Journal Entry or Intercompany Journal Entry) as well as the CSV file or files you want to upload. In the next steps you will select the data handling options and the field mapping.
If you set the data handling option to Update, any CSV file line field values for existing transactions are appended as additional lines per transaction.
The lines of the Journal Entry – Line sublist are not keyed, so you cannot directly update specific lines. To update specific journal entry lines, export them all, make the necessary changes in the sublist lines, check the Overwrite Sublists box in the advanced options and overwrite the whole sublist.