Update Due Date in Customer Ledger Entry

MAJB69 · 2010-09-09

We have 100's of entries in the Customer Ledger Entry Table with the wrong due date.

I have change the Payment Terms Code on the Customer Card.

What I would like to do is create a routine that would take the Document Date for each individual CLE line, get the Payment Terms Code from the Customer Card and Re-Calculate the Due Date.

Any Help would be appreciated.

klavin · 2010-09-09

You'll just have to write a report to run down these Cust. Ledger Entries and do something along the lines of:

In Table View
<Filter to the payment terms that was wrong, date etc... filter for open>

OnAfterGetRecord()
Customer.GET("Customer No.");
PaymentTerms.GET(Customer."Payment Terms Code");
VALIDATE("Due Date",CALCDATE(STRSUBSTNO('+%1',PaymentTerms."Due Date Calculation"),"Document Date");   //VALIDATE to get Reminder Entries if exists...
MODIFY;

Alex_Chow · 2010-09-09

make sure you use the developer's license when doing this.

ssingla · 2010-09-13

Alex Chow wrote:

make sure you use the developer's license when doing this.

Due Date can be manually changed after posting entries with Cust. License so I see no need of Developer License.

Alex_Chow · 2010-09-13

ssingla wrote:

Alex Chow wrote:

make sure you use the developer's license when doing this.

Due Date can be manually changed after posting entries with Cust. License so I see no need of Developer License.

Only from the form, not if you go into the table directly or run a process only report.

Essentially, you have to incorporate Cust. Entry-Edit codeunit into your process.

Update Due Date in Customer Ledger Entry

Comments

Categories