News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Is it possible to gene...

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

Unanswered

Is it possible to generate Separate CSV for each line of payment in payment journal

(0) Share

Report

Report

Posted on by user 123

165

In the payment journal page, there is an action called /Export/ under the /Bank/ menu.

Current scenario: If we have 5 lines in a batch and click on the export action, only one CSV file will be generated containing all 5 lines.

Expected scenario: If we have 5 lines in a batch and click on the export button, separate CSV files should be generated for each line. This means that each line will have its own individual CSV file.

Is it possible? if yes then how?

Categories:

Dynamics 365 Business Central

All responses Img

All responses (1)

Answers Img

Answers (0)

Community member 4 on at

Like (0)

Report

Is it possible to generate Separate CSV for each line of payment in payment journal

Hello,

First of all Create a new field in the Payment Journal Line table to store a unique identifier for each line. This identifier will be used to generate separate CSV files. Customize the Export action code in the Payment Journal page to iterate through each line in the batch. For each line, create a separate CSV file using the unique identifier and populate it with the relevant line data. Provide a mechanism to download or store these separate CSV files for each line. pickleball drills for advanced players

I hope this will help you.

Thanks.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans