Cacher is the code snippet organizer for pro developers

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.