Data Exchange Definition Export

Dean_Axon
Dean_Axon Member Posts: 193
in NAV Three Tier
Hi Community :)

I am trying to export Banking data using the Data Exchange Definitions and sending to a flat file. I have got it working using a repeatable line (multiple payment lines)
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5

but what I cannot work out how to do it a file that has the following format:
Header Record,Field 1,Field 2,Field 3 (date)
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Line Record, Field 1,Field 2,Field 3,Field 4,Field 5
Trailer Record, Count of lines,SUM of Line value,Field 3

I thought it was going to be straight forward and have multiple line definitions, but I have noticed that when you can only define one "Pmt. Export Line Definition" on the payment method, so that would suggest that I can only use one of the line definitions anyway ?

Does anyone know if it is possible to work this within standard data exchange definitions or is the multiple line definitions really used for importing as a lot of the online documentation would seem to suggest ?

If not possible, using DEF has anyone done this using "parts" of DEF rather than a completely customised solution?
Remember: Keep it simple

Best Answer

Answers

Categories