I want to export data from multiple tables into a CSV file.
How can accomplish this in business central online?
Depends one what you are exporting, from where to where. Business Central have many ways to handle export to CSV files.
So what do you need?
I need to be able to export fields from Payment Journal and other related tables like Gen Journal line, Company information, Vendor bank account, Vendor etc. I need to generate a CSV file containing these fields.
did you use rapidstart packages/ configuration packages?
In other words, you are creating a payment file?
If that is the case, then you must look into the Data Exchange Framework. That’s what is already being used tor vendor payment exports. With DEF you can define your CSV formats via setup.
The best way to learn how it works would be to check out the payment export data definitions that you find in Cronus (depends on localization).
Yes Erik, I need to create a payment file in a format which is accepted by the bank.
No, I haven’t used them yet. Can I use rapidstart with Business central online?
yes it is not possible to export payment file using rapidstart, you need to ue data exchange framework as suggested by Erik.
if it is data import and export then rapidstart will work.
I tried data exchange definition but we can’t use more than one source table with data exchange definition. Can we use more than one source tables with XML ports?
That is not correct.
You can use many source tables with data exchange definitions, otherwise for example then you could not use it for PEPPOL the European E-invoicing function, where you import/export sales invoices etc. And you always have the option of creating your customized, but that should not be required.