Hi,
I need set due date to invoice date according to payment terms (14,30,60 days). I tried to ensure this by using calculated fields. I used the {addDays (dmY; {P1}; {P0)} function, where P1 is the invoice date and the P0 value is selected in the payment conditions list. Unfortunately, nothing is written to the due date …
The formula is fine, but I do not know if there is a problem in that the value from the list of payment terms is probably taken as a text and not a number. However, the function for converting text to number and vice versa is missing.
Thanks for your help. Radim