Small and medium business | Business Central, N...

Data Exchange definition's debit /credit segregation

(0) Share

Report

Posted on by AsankaP

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.

5861.Capture.PNG

My question is how can I import the file with above condition to a journal? Can I configure this in BC?

Thanks in advance!

All responses (5)

Answers (0)

Suggested answer

New Steps Solutions 5 on at

Like (0)

Report

RE: Data Exchange definition's debit /credit segregation

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.
Suggested answer

Dallefeld 175 User Group Leader on at

Like (1)

Report

RE: Data Exchange definition's debit /credit segregation

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.
Andy Sather on at

Like (0)

Report

RE: Data Exchange definition's debit /credit segregation

Correct
AsankaP 12 on at

Like (0)

Report

RE: Data Exchange definition's debit /credit segregation

Thank Andy.

Then only option would be a customization right?
Suggested answer

Andy Sather on at

Like (1)

Report

RE: Data Exchange definition's debit /credit segregation

Hello - We currently do not have an option to put an offset entry in the Data Exchange Definition.