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?
The "Document No." field is the "Document No." that is assigned to the payment. Not the Vendor Ledger.
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!
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