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

Flat file export of sales header and sales line information on seperate lines

(0) Share

Report

Posted on by KJ-03062255-0

I have a need to export sales order information into 1 file where the sales header information is on one line and then the sales line information would be on the following lines., something like this:

/SH/,/2016981433/,/12345678/,/JOAN HARRY/,/5050 Road N/,//,/Waterloo/,/ON/,/N1N 1N1/,/CA/,//,/555-666-7777/,/JOAN HARRY/,/5050 Road N/,//,/Waterloo/,/ON/,/N1N 1N1/,/CA/,/Ground/,/P/,//,/2020-03-07T00:00:00Z/,/AMZ/,///SL/,/2016981433/,/1/,/13358A/,/16/,/0.00//SL/,/2016981433/,/2/,/2564A/,/6/,/0.00//SL/,/2016981433/,/3/,/568955/,/6/,/0.00//SL/,/2016981433/,/4/,/5666/,/6/,/0.00//SL/,/2016981433/,/5/,/5665/,/4/,/0.00/

has anyone done something similar or seen anything like this? Is it even possible?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

There are many ways to do that in Business Central.

The easiest way is probably to use an XML port if you want to do it in the AL language.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-xmlport-object

You can also use configuration packages to create an export like that.

You can also use the CSV,XML og Json buffers if you want a more standard format for your data.

Was this reply helpful? Yes No
KJ-03062255-0 10 on at

Like (0)

Report

Thanks Inge,

I have been working on the XML port, what I am trying to figure out is how to do one XMLPort where the first line is the header information, and then the next 3 lines would be the 3 items on the sales order, then the next line would be the next sales header and then then lines below that etc.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,729 Super User 2025 Season 2 on at

Like (0)

Report

Hi, for how to skip rows, hopefully the information below will give you some tips.

https://yzhums.com/38802/#toc1

Thanks

ZHU

Was this reply helpful? Yes No