How is the Average Days to Pay calculated in AP Vendors?

Question

Just wondering what tables and fields I need to calculate the "Average Days to Pay" that shows up under the AP Vendor record on the Activity tab? I tried the APVSM table but that doesn't seem to correspond with the data shown on the Activity tab.

Shane - Ascend Business Solutions · Accepted Answer

There is a field populated with this:
APVEN.AVGDAYSPAY

You can also calculate with a statement like:
SELECT VENDORID, CASE WHEN CNTINVPAID <> 0 THEN DAYSTOPAY / CNTINVPAID END AS AVG_DAYS_TO_PAY
FROM dbo.APVEN

Sage 300

How is the Average Days to Pay calculated in AP Vendors?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING