In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Days Past Due
I am trying to write I GI that will feed a business event to take certain sales orders off hold. One of the criteria I need to evaluate is the customers current Days Past Due. I see where the Days Past Due limit is set on the Customer but I don't see anywhere that the current past due days is stored in a table.
Or do I have to calculate it on the fly from the oldest open invoice due date? (Which will be problematic in the GI since I will need to avoid grouping - because of the Business Event)
In ARBalances table there is OldInvoiceDate which is the fist due date (oldest invoice due)