A journal entry can be applied to a bill or 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."
To do this through CSV Import for a large number of un-applied journals:
1. Prepare a CSV file with the Internal ID's of the Journals to be unapplied.
2. Navigate to Setup > Import / Export > Import CSV Records.
3. Set the Import type to Transactions then Record type is Journal Entry.
4. Choose the file in Step 1 to upload.
5. Set Data Handling to Update.
6. Map the Internal ID to Internal ID
7. Click Run.
Note: This process does not provide a message like when the process is done in the User Interface so like any other imports, care must be exercised in the data to be included in the CSV File to avoid inappropriate updates.
No comments:
Post a Comment