Using Journal Entry Import for Updates

The Single Journal Entry Import Assistant (see Single Journal Entry Import) 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.

For more information about updating records with a CSV import see Choose Data Handling for Import.

For CSV file samples see Journal Entry CSV Files.

Warning:

If you update any type of journal entry that has been applied as a payment to an invoice or vendor bill, the relationship between the journal entry and payment is removed and the payment is no longer applied.

Related Topics