API sales data does not seem to match basic reports
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 ?