× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

XML.OUTPUT.MSG output customisation

  • richard
  • richard's Avatar Topic Author
  • Offline
  • Premium Member
  • Premium Member
More
8 years 9 months ago #17730 by richard
XML.OUTPUT.MSG output customisation was created by richard
Hi ,

Can anyone please help me to find out the solution for my issue.
Currently I am getting CAMT ouput messages in XML.OUTPUT.MSG table where I need the transaction details to my multivalued for an account.

I mean the Entry details and Party tags should come only once for the account where as the transaction details should populate multiple times with respect to number of transaction(statement Entries) the account has on the day.

A sample output has been attached where I need the highlighted part to come multiple times not the entry details and all.



I am trying to achieve this as below, but its not working I need these tags should be populated multiple times with respect to number of credit or debit transactions.


Y.I ='-1'
IF SYS.ID EQ 'FT' AND STE.REV.MARK EQ 'R' THEN
IF ARCHIV THEN
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = ARCHIV
END ELSE
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = FT.ID
END
END ELSE
IF REV.CD THEN
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = REC.VD
END ELSE
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = FT.ID:'R'
END
END
OUTPUT.DETAILS<TxnDet.Txnamt,Y.I> = "EUR":STE.AMT
OUTPUT.DETAILS<TxnDet.RelDebtrName,Y.I> = TXN.NAME
OUTPUT.DETAILS<TxnDet.RefAcctServref,Y.I> = TXN.NAME
IF STE.REV.MARK EQ 'R' THEN
OUTPUT.DETAILS<TxnDet.RelDtsAcceptDate,Y.I> = R.FT<FT.LOCAL.REF,DAT.POS>
END



Best Regards,

Think green – keep this on the screen
Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.242 seconds