Create Specific Sales Report

  • Posted:
  • Proposals: 13
  • Remote
  • #2862449
  • via mobile app
  • OPPORTUNITY
  • Awarded
Santiago S.
Muhammad H.MUHAMMAD Kashif M.Ali Hasnain C.Ruslan P. + 8 others have already sent a proposal.
  • 1

Description

Experience Level: Expert
I need a simple report or the sql query with date range that can display those information below.
This will concern only the orders with status = complete.
The orders products have two different Tax rate (5.5 or 20) so we need to have the total amount of each per order.

Exemple:
N° Invoice / Date / Customer name / Country / Shipping amount / Total without tax / Amount VAT 5,5% / Amount VAT 20%
789899 / 2019-07-06 / name name / France / 12 / 3 / 0
299899 / 2019-07-06 / name name / France / 155 / 12 / 37
Thanks


New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.