MYOB Integration: Extracting total sales data

Here’s a couple of examples you might find helpful if integrating with MYOB. The following query extracts the total sales from July 2011 to June 2012. SELECT SUM(TotalTax + TotalLines – TotalDiscounts) As TotalSales from Sales WHERE InvoiceDate BETWEEN ‘2011-07-01’ AND ‘2012-06-30’ +——————+ |    TotalSales   | +——————+ |      29223.5     | +——————+ You can…

Read More