In QB's, I am able to view Open Invoices and Overdue Invoices (which is great for our collections rep). However, I have been unable to find a solution to separate and display the invoice data in Method. Here is my issue:
Open - The “Open” field (standard name “Balance”) is populating the combined totals from the “Open” and “Overdue” data from QB and needs to only show the “Open” balances from QB.
Overdue – This field was renamed as “Overdue” from the standard “Total Balance” field name and does not populate any data at all. It needs to pull the QB's “Overdue” balances into this field. Any invoice still open 15 days after the original invoice date is considered “Overdue” as our QB billing terms are set as “Net 15.”
Both the Open & Overdue fields need to populate on the Customer List screen as well as within each Edit Customer screen. Essentially, I want to be able to sort by Open and/or Overdue balances on the Customer list screen, and when clicking on the "Edit Customer" link from this screen, I need to see this data here as well.
Any guided help would be greatly appreciated as Method is essentially useless for us until I can get this working correctly.