Report 10531 Sort Order

TrippyZ

I am try to change to sort order of the line items for report 10531 Remittance Advice.

I want the body items to be listed by doc number not due date. So I created a suitable key on VLE.

Though I have adjusted to the dataitems to use this key it still doesn't work. My last gasp is to try and manipulate the PrintLoop with setcurrentlkey or settableview, without success, perhaps you can't sort a integer?

Please advise.

DaveT

Hi,

Although the PrintLoop is based on the Integer dataitem - it is in effect looping the Vendor Ledger entry using the AppliedVendLedgEntryTemp variable. Try setting the key on this variable.

TrippyZ

Thanks DaveT.

Doing the setcurrentkey for AppliedVendLedgEntryTemp in the pre trigger of printloop did the trick

DaveT

Glad to Help