API sales data does not seem to match basic reports

sam123456sam123456 Member Posts: 54

I'm trying to generate some reports with data i'm getting from the API and while the numbers are close they don't quite match what I see in basic sale-lines reports. I'm wondering if I'm using the wrong data or if there is some underlying issue.

If I want to replicate the sale-lines report (Reports/ Sale Lines):

  • Is the date filter using timestamp or createtime?
  • if I want to get the "Subtotal w/ Discounts" aggregation should I sum displayableSubtotal ?
  • is "Cost" using avgCost or fifoCost ?
Sign In or Register to comment.