Invoice with multiple items has incorrect data in the report

  • Resolved tortoisepads

    (@tortoisepads)


    7 years, 1 month ago

    If I have an invoice with multiple items (products), each item shows on the report as a separate line but with the total invoice amounts for each entry. For example:

    If:
    Item 1 on invoice cost $20 with $2 tax
    Item 2 on invoice cost $30 with $3 tax
    Total shipping for the order $5
    The invoice total is $60

    Then the report would show:
    Item 1 – Cost: $50, Tax: $5, Shipping: $5, Total: $60
    Item 2 – Cost: $50, Tax: $5, Shipping: $5, Total: $60

    I have to manually adjust the entries for every invoice with multiple items. Is there a fix for this?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author algol.plus

    (@algolplus)

    hi

    Could you open section format “XLS”( or “CSV” ) and
    mark checkbox “Populate other columns if products exported as rows” ?

    thanks, Alex

    Thread Starter tortoisepads

    (@tortoisepads)

    That checkbox has been checked for both XLS and CSV. I’ve unchecked and rechecked multiple times with the same results. When it is unchecked the second item on an invoice shows up in it’s own row but only the SKU, Name and Quantity are present. All the other columns for the second item are blank.

    Plugin Author algol.plus

    (@algolplus)

    hi

    I’m sorry, but I misunderstood what result you want to get.

    Could you submit ticket and upload both files (wrong and edited)?
    thanks, Alex

    Thread Starter tortoisepads

    (@tortoisepads)

    I’ve submitted a support ticket. Please let me know if you did not get it.

    Plugin Author algol.plus

    (@algolplus)

    thank you. I’ve replied.

    Thread Starter tortoisepads

    (@tortoisepads)

    It works great. Thanks for the help

    Plugin Author algol.plus

    (@algolplus)

    these instructions solved the problem

    Please, open section “Setup Fields”, scroll down to “Products”, click button “Setup Fields” and mark checkboxes “Order Line Subtotal”, “Order Line Tax”.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Invoice with multiple items has incorrect data in the report’ is closed to new replies.