Credit note due date

[Former Member]

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*

[helen_sun · Accepted solution]

Hi,

The Due date will be grayed out in the Credit memo in case it

was based on an Invoice.

In case the Credit memo is not based on another document, the Due date

will be changeable as mentioned in the note [941272].

it is by system design that credit memos retrieve their due date from

their posting date and not based on the defined payment terms

This behaviour is consistent through all versions.

Best Regards

Helen Sun

[Former Member]

Thank you for replying