Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

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

Correct import of bank transactions in payment reconciliation journal

(0) ShareShare
ReportReport
Posted on by 2
I would like to make the upload of camt.053 file to the payment reconciliation journal and as far as I know there is no built-in API route for it. That's why I decided to upload parsed information from my backend with ODataV4 web services and write it directly in the necessary tables. In general, I need an explanation about the tables I need to fill in and in general if it's possible to do so.
  • Correct import of bank transactions in payment reconciliation journal
    No i haven't actually, the only thing I managed to do was to upload the Bank Acc. Reconciliation Line via ODataV4 in json format. But I've noticed that there is no details for such lines in proper table.
  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,070 Super User 2025 Season 1 on at
    Correct import of bank transactions in payment reconciliation journal
    Have You created the needed setup tp be able to import the file manually in the system?

    Field Mapping When Importing SEPA CAMT Files - Business Central | Microsoft Learn

    After that, if You want to do the import automated from external place, You can use the same actions as in manual process.

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

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans