I know this is a common issue and the question has been asked numerous times but never answered. I'm hopeful that somebody will be able to assist me. I have used the PMW several times and am familiar with the various DME configuration documents which have been very useful so please don't just respond with links to existing posts as I have already read them :-)
In DMEE I have defined my sort field as FPAYHX-REF01 (Level 1). Unfortunately this sort is only taken into account after the payment proposal sort which seems to be by vendor number.
The result is that my dataset looks like this:
Vendor REF01
1 E
2 V
3 V
4 E
5 V
Required result: 2 files get generated as follows:
1 E
4 E
2 V
3 V
5 V
Actual result: 4 file are being generated as follows
1 E
2 V
3 V
4 E
5 V
I understand from reading previous posts on the subject that the sort depends on the value in FPAYH-SORTF1. I'm not clear on when this field is populated and how I can impact this field to give me the result I require. Greatful for any assistance and of course points will be awarded for helpful responses