Extracting Data from MYOB : Total Sales


There are ways to extract data like total sales from MYOB (Database) and generate this data into useful information for the company. Here is one of the ways.


First, we may need to query all the sales data from MYOB by filtering them by type of invoice.


The next step, we can sum up the total amount of all these invoices of this type (credit). By doing this, it will return you the total account receivable.


In addition, we can acquire the sum of the overdue invoices from data mentioned above. In order to achieve this, we will have to compare each of the invoices by their due dates to the current date.