You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Due Date Calculation Formula based on Terms Date and Terms Name in OTBI Report

Received Response
47
Views
12
Comments
edited May 7, 2019 7:13PM in Reporting and Analytics for ERP 12 comments

Summary

Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI Repoert

Content

Hi All,

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 !!!

Example:-

Terms Date  =  05/07/2019 (MM/DD/YYYY)

Terms Name = Net30  (Or can be Net15, Net60, Net90, Immediate etc,.)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!