Due Date Calculation Formula based on Terms Date and Terms Name in OTBI Report
SummaryLooking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI Repoert
I have a requirement to derive Invoice Due Date based on Terms date and terms name. I am using following subject area which has Terms Date and Terms Name
OTBI Subject Area :- [Payable Invoices - Transaction Real Time]
I want to calculate Invoice Due date based on Terms Date and Terms name on the Payable invoices. Please suggest the formula or custom SQL to achieve this.
Appreciate your help !!!
Terms Date = 05/07/2019 (MM/DD/YYYY)
Terms Name = Net30 (Or can be Net15, Net60, Net90, Immediate etc,.)