Skip to Content
0
Jun 25, 2020 at 12:11 PM

Calculating Payment Date based on terms

78 Views

Hi All,

Scenario:

In my SAC model, I have the Invoice date and agreed terms of the amount to be paid. So, now based on the terms I want to calculate the payment date.

For example,

In the above chart, I have the invoice date 01-01-2020 and payment terms 30 days, so I am able to calculate the payment date by adding 30 to the invoice date.

But in SAC, I am not able to achieve such functionality as no formula can be applied on date dimensions.

Can you please help me with an idea to achieve this?

Thanks for helping!!

Attachments

nxaqp.png (7.5 kB)