Data Exchange Definition Exports

Dean_AxonDean_Axon Member Posts: 192
edited 2020-04-03 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

Comments

  • krikikriki Member, Moderator Posts: 8,902
    [Topic closed because of double posting]
    See https://forum.mibuso.com/discussion/75127
    This topic will be deleted after a week.

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2020: 19 & 20 November 2020, Antwerp (Belgium)
This discussion has been closed.