DMEE tree: to split the details to 2 type; payment and invoices

[former_member399569]

my client requests to have new set of payment format. the header footer stil same, but on the details, they request to split to 2 type; P-payment and I-invoice. the flow will be like below:

H,P

P,ACH,ON,,,, MY,KUL,312148938785,25/01/2006,XXXXXX BERHAD ,MENARA XXXX,84 JALAN RAJA CHULAN,50200 KUALA LUMPUR,,ABNAMYKLXXX,, ,,732837238,,,,,,,,,,,,,,,,,4,MYR,201000,C,,,,,,,,,S, , ,MENARA ING,84 JALAN RAJA CHULAN,50200 KUALA LUMPUR,,,Please call XXXXX Supplier Helpdesk at +603 21653215 for payment inquiry,,,,,

I,N8788,01/12/2005,N8788,1000

I,XXX,01/12/2005,XXX,200000

P,ACH,ON,,,, MY,KUL,312148938785,25/01/2006,XXXXXX SDN BHD ,NO 6C TINGKAT 3 JLN MAMANDA 7,TMN DATO AHMAD RAZALI,68000 AMPANG SELANGOR,,CITIMYKLXXX,, ,,8734736712,,,,,,,,,,,,,,,,,4,MYR,36000,C,,,,,,,,,S, , ,NO 6C TINGKAT 3 JLN MAMANDA 7,TMN DATO AHMAD RAZALI,68000 AMPANG SELANGOR,,,Please call XXXXX Supplier Helpdesk at +603 21653215 for payment inquiry,,,,,

I,TTTTT,01/12/2005,TTTTT,30000

I,11111,01/12/2005,11111,2000

I,09872,01/12/2005,09872,4000

T,2,237000

normally, for invoices i just combine into 1 line and concatenate with the payment record. which means, the detail will have 1 type only; P-payment. but now the new request is to split it to few lines.

appreciate somebody who has experience on this to give idea/suggestion. Or maybe if you think got forum on this topic, then please forward me the linkage.

thanks a lot

[former_member399569]

solve by myself

[Former Member]

Could you tell us how you solved this issue?