How are the Average Days to Pay fields on the Customer A/R tab calculated?
Both Year to Date and Life to Date Average Days to Pay fields are calculated in GP and stored in GP calculated fields RM00103, AVGDTPYR and AVDTPLIF. This data is returned through our view, spvCustomer (references spvCustomer_base which pulls the data from RM00103), based on the customer selected in SalesPad.
Customer Card A/R tab: