Credit note due date

Hi

Client wants the due date in a credit note (A/R) to reflect a date according to the Payment term of a customer. This I can achieve with a formatted search. The payment terms for customers are -

30 days

Due date based on posting date

Start from month end + 1 month + 7 days

60 days

Due date based on posting date

Start from month end + 2 months + 7 days

How to do a SQL query like that is a bit advanced for me.

Can anyone help, please?

Regards

Edited by: Philip Eller on Jun 4, 2008 8:47 AM

Edited by: Philip Eller on Jun 18, 2008 9:09 AM*