Unapply Journal Entries Through CSV Import

A Journal Entry can be applied to a Bill or an Invoice. In the user interface, editing the journal entry that has an applied transaction will result to a message, “This journal is paying other transactions. Editing the journal will cause these payments to be unapplied. Are you sure you want to edit it? Click on Ok then Save the Journal without changing anything else to remove the link to the Bill or Invoice.” If you want to unapply multiple Journal Entries to Bills or Invoices, you could do it via CSV import.

1. Prepare a CSV file with the Internal IDs of the Journals to be unapplied
2. Navigate to Setup > Import/Export > Import CSV Records
3. On the scan & Upload CSV File Page
   • Import Type: Select Transactions
   • Record Type: Select Journal Entry
   • Click the One File To Upload radio button
   • Click the Select button to choose the file in Step 1 to upload
   • Click Next
4. On theImport OptionsPage
   • Data Handling: Select Update
   • Click Next
5. On File Mapping Page
   • Map Internal ID <> Journal Entry: Internal ID
   • Click Next
6. On Save mapping & Start Import Page
   • Enter a value for Import Mapping Tile
   • Click Save & Run