cv304
9/7/2017 - 7:48 PM

Client invoice dates past due

Client invoice dates past due


Client Invoice Inquiry Custom Formula [ New ]
Options

‎06-05-2015 01:49 PM

Custom Formulas

 

1. Client Invoice Inquiry: Add the number of days past due based off invoice date and current date

SELECT DateDiff(d, ciInvoiceDate, GETDATE() ) as DaysSinceInvoice

FROM AxClientInvoice

WHERE cikey =[Client Invoice Key]

 

To Use these Custom Formulas

Copy the desired Formula into the definition of your Inquiry column.