Method Community

 

Report Designer - Invoice Line Items Showing in Reverse

Last post 11-28-2012 10:22 AM by Wiretrip. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 11-27-2012 4:34 PM

    Report Designer - Invoice Line Items Showing in Reverse

    I am having trouble figuring out why my invoice line items are in reverse order. Let's say that on an invoice in QB the line items go in order by row 1, 2, 3. When I view the print priview in the report designer for the template I am working on, the line items are going reverse such that it appears as 3, 2, 1. Is there a formatting string that causes this?

  • 11-28-2012 9:15 AM In reply to

    Re: Report Designer - Invoice Line Items Showing in Reverse

    Answer

    Hi,

    There is a field in the InvoiceLine.Invoice called LineOrder.  You can sort the invoice items by this field.  There is a sort option when you click on the section.

    - Adam

    Adam Lyons
    Manager of Support
    Method Integration
    a.lyons@method.me
  • 11-28-2012 10:22 AM In reply to

    Re: Report Designer - Invoice Line Items Showing in Reverse

    I had to add the sort option in myself but that worked for me. Thank you.

Page 1 of 1 (3 items)