Hi,
I'm using data exchange definition for import data from CSV file to general journal.
In that file, all the amounts are defined in positively and if it's Debit line, 'D' letter is showing in next column and if it's Credit line, 'C' letter is showing in the next column.
My question is how can I import the file with above condition to a journal? Can I configure this in BC?
Thanks in advance!
Hi, was also looking for a solution for this. Posting it here so it can help others.
You can use the Negative-Sign Identifier:
1. In column definitions, mention C in the column of the credit/debit indicator.
2. In the field mapping, map the column of the credit/debit indicator to the same field Amount.
Hope it helps.
Or get your csv to have the '-' sign for credits and import into the amount fields versus importing into the debit amount and credit amount fields.
Correct
Thank Andy.
Then only option would be a customization right?
Hello - We currently do not have an option to put an offset entry in the Data Exchange Definition.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148