Skip to main content

Notifications

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

Data Exchange definition's debit /credit segregation

(0) ShareShare
ReportReport
Posted on by 12

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!

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

    pastedimage1681468280811v1.png

    2. In the field mapping, map the column of the credit/debit indicator to the same field Amount.

    pastedimage1681468310168v2.png

    Hope it helps.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    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 Profile Picture
    Andy Sather on at
    RE: Data Exchange definition's debit /credit segregation

    Correct

  • AsankaP Profile Picture
    AsankaP 12 on at
    RE: Data Exchange definition's debit /credit segregation

    Thank Andy.

    Then only option would be a customization right?

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    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.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans