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 (0)

Sort by

Suggested answer

Andy Sather Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

Thank Andy.

Then only option would be a customization right?

Was this reply helpful? Yes No
Andy Sather Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Correct

Was this reply helpful? Yes No
Suggested answer

Dallefeld 235 User Group Leader on at

Like
a
(1)

Report
Copy link

Link copied!

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

New Steps Solutions 10 on at

Like
a
(0)

Report
Copy link

Link copied!

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