Sorting in Reports

AEL

Hi

I have created a report based on the unposted payment journal to show all invoices to be paid in the payment run.

However I can't get it to sort by vendor ledger document number despite having set the DataItemTableView to sort by document number.

Anyone have any suggestions?

Thanks

AEL

Tommy_Schou

If you want to sort by Vendor Ledger Document no. you should set your sorting key to "Applies-to Doc. No.".

The "Document No." field is the "Document No." that is assigned to the payment. Not the Vendor Ledger.

AEL

Thanks but it still doesn't work!

Tommy_Schou

If you only one dataitem and you set the sorting order of that dataitem in the properties to what you want then all things considered it will always work! :P

There may be some code on the data-item (press F9 and check) that selects another key and that will override what you have selected in the DataItemTableView property!

Gl 8)

AEL

Ah ha!

Is the problem that I am using more than one dataitem (gen. journal line, vendor ledger entry and vendor)? :?

(already checked the code - there is none on any dataitem)

Your help is much appreciated