---
title: "ProStix Queries"
canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31097519/ProStix%20Queries"
format: markdown
---
## Customer Queries

<details>
<summary>For more information about Customer Queries, click here.</summary>

|  |  |  |  |  |  |
| --- | --- | --- | --- | --- | --- |
| **Query Name** | **Author** | **Description / Requirements** | **Screenshots** | **Query Downloads** | **Last Modified Date** |
| **Customer Postal & Delivery Addresses** | Chris Low | Report to show Customer Postal Address and Delivery Address. |  | [CustomerAddresses.nqy](https://sterlandsupport.atlassian.net/wiki/spaces/PROSTIXV48DOC/pages/31100962)<br>[28914 Query Development Handover Sheet.doc](https://sterlandsupport.atlassian.net/wiki/download/attachments/31097519/28914%20Query%20Development%20Handover%20Sheet.doc?version=1&modificationDate=1413192740777&cacheVersion=1&api=v2) | Oct 20, 2011 |
| **Customers Outside Payment Days** | Chris Johnston | A listing of all customers whose account payment is overdue according to their defined payment days.<br>This only lists customers whose payment days > 0.<br>Aged balances in credit are ignored.<br>The Payment Due date is calculated from the end of the month of purchase.<br>The listing shows the customer, payment due date and their aged balances.<br>> Macro (nested-table) |  | [Customers Outside Payment Days.nqy](https://sterlandsupport.atlassian.net/wiki/download/attachments/31097519/Customers%20Outside%20Payment%20Days.nqy?version=1&modificationDate=1413195152183&cacheVersion=1&api=v2) | May 16, 2011 |
| **Customers By Balance Due** | Andrew Pritchard | Listing similar to Debtors ATB sorted by customer balance due. Excludes zero balance customers and Bad Debt Customers |  | [Customers By Balance Due.nqy](https://sterlandsupport.atlassian.net/wiki/download/attachments/31097519/Customers%20By%20Balance%20Due.nqy?version=1&modificationDate=1413238235106&cacheVersion=1&api=v2) | Aug 02, 2010 |
| <span style="color: #ffffff">1111111111111111111111111111111</span> | <span style="color: #ffffff">11111111111111111111</span> | <span style="color: #ffffff">1111111111111111111111111111111111111111111111111111111111111111111111111</span> | <span style="color: #ffffff">1111111111111111111111111111111111111111111111111111111111111111111</span> | <span style="color: #ffffff">111111111111111111111111111111111111111111111</span> |  |
</details>