Creating a Customer Average Days to Pay Data Driller

Need help in making credit limit decisions for your customers? This guide teaches you how to create a datadrill to display credit information on customers’ average days to pay.

1. Under the File menu, select Maintain Dataviews.
2. Type AVG_DAYS_2PAY in the Dataview ID field.
3. Click Add.
4. Type the title and the description for this new dataview.
5. Click the ellipse button located beside the Table field.
6. Select the ARYMST table from the list.
7. Click OK.
8. Click the ellipse button located beside the column field.
9. Add the desired fields for this report, but you must include the CUSTNO field for this datadriller.
10. Select CUSTNO from the Dataview Columns list in the DataDriller - Define Columns screen.
11. Click Details.
12. Click Advanced.
13. Click Add Expr.
14. Type avg(dtepaid-invdte) in the Column or Expression for the SQL Select field:
15. Type avg_days in the Column Alias field.
16. Select Numeric from the Data Type list.
17. Type Average Days to Pay in the Column Title field.
18. Click OK to save changes.
19. Type the following in the Filter field:
    .T.group by custno having avg_days<>0
20. Type the following in the Order by field:
    avg_days desc
21. Click Save.
22. Exit the Maintain Dataviews screen.

The avg_day_2pay dataview that you created is now accessible from the datadriller list. When you select the avg_day_2pay dataview, it displays records for the average days to pay for each customer.