Options

Sorting in Reports

AELAEL Member Posts: 12
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

Comments

  • Options
    Tommy_SchouTommy_Schou Member Posts: 117
    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.
    Best regards
    Tommy
  • Options
    AELAEL Member Posts: 12
    Thanks but it still doesn't work! :(
  • Options
    Tommy_SchouTommy_Schou Member Posts: 117
    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)
    Best regards
    Tommy
  • Options
    AELAEL Member Posts: 12
    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 :D
Sign In or Register to comment.