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!

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Andy Sather on at

Like (1)

Report

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

Was this reply helpful? Yes No
AsankaP 12 on at

Like (0)

Report

Thank Andy.

Then only option would be a customization right?

Was this reply helpful? Yes No
Andy Sather on at

Like (0)

Report

Correct

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Verified answer

New Steps Solutions 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No