how do we get a formula to get bill payment date m...
# administrations
sureshconsultant35
08/14/2023, 10:12 PMhow do we get a formula to get bill payment date minus invoice date. i am looking to find the no of days took
s
Sam-I-Am
08/14/2023, 10:25 PMInvoice (vendor bill) and bill payment has the following - bill payment is a applying transaction to Bill/Invoice. So use the {trandate}-{applyingtransaction.trandate}. See search criteria below:
s
sureshconsultant35
08/14/2023, 10:34 PMsureshconsultant35
08/14/2023, 10:36 PMs
Sam-I-Am
08/14/2023, 10:37 PMshould work - make sure to have bill payment as applying transaction in the criteria also in the result apply appropriate summery type for all the other columns
s
sureshconsultant35
08/14/2023, 10:37 PMsureshconsultant35
08/14/2023, 10:37 PMsorry i am getting count as 1
sureshconsultant35
08/14/2023, 10:37 PMi am looking for the difference of bill paymnet minus invoice date
sureshconsultant35
08/14/2023, 10:37 PMno of days
s
Sam-I-Am
08/14/2023, 10:38 PMopps try out sum or max
Sam-I-Am
08/14/2023, 10:38 PMmight need to add some SQL
s
sureshconsultant35
08/14/2023, 10:40 PM(applying transaction.trandate)-{trandate}
sureshconsultant35
08/14/2023, 10:40 PMis this correct
sureshconsultant35
08/14/2023, 10:40 PMif i need bill payment minus invoice date
sureshconsultant35
08/14/2023, 10:40 PMs
Sam-I-Am
08/14/2023, 10:41 PMoh no I did that other way around
s
sureshconsultant35
08/14/2023, 10:41 PMinvalid exprssion if i use this
s
Sam-I-Am
08/14/2023, 10:41 PMlet me see
s
sureshconsultant35
08/14/2023, 10:41 PMthese are columns i added
sureshconsultant35
08/14/2023, 10:41 PMsureshconsultant35
08/14/2023, 10:42 PMcriteria
sureshconsultant35
08/14/2023, 10:42 PMsureshconsultant35
08/14/2023, 10:43 PMrequirement is to get the no of days it took
sureshconsultant35
08/14/2023, 10:43 PMwhich we can get if we minus invoice date from bill payment date
sureshconsultant35
08/14/2023, 10:45 PMsays invlaid expression
sureshconsultant35
08/14/2023, 10:45 PMits pretty urgent now
sureshconsultant35
08/14/2023, 10:46 PMcan u help please
s
Sam-I-Am
08/14/2023, 10:47 PMSimilar SQL for date count - this following suiteanswer
https://suiteanswers.custhelp.com/app/answers/detail/a_id/13764
s
sureshconsultant35
08/14/2023, 10:49 PMthis will take more time to figure out no w