code to assign certain amount to credit limit base on certain condition

Business Central/NAV Developers Forum
1

Hi,

Please, i wrote a code to assign a certain value to credit limit base on certain condition but it gave me defferent thing. It is assigning the same amount to all the Customer disregarding the condition. Please do check below .

Thanks

Gbenga

Customer.SETRANGE(Customer.“No.”, Customer.“No.”);
IF Customer.FINDFIRST THEN BEGIN
IF ((Customer.“Balance (LCY)” = 0) AND (Customer.“Credit Limit (LCY)” = 0)) THEN BEGIN
Customer.“Credit Limit (LCY)” := 100000;
Customer.MODIFY
END
ELSE
CurrReport.SKIP;
END;

Quick Reply
2

I would prefer doing it using a processing only report:

Use “Customer” as data item

and on aftergetrecord trigger write the following code:

IF ((Customer.“Balance (LCY)” = 0) AND (Customer.“Credit Limit (LCY)” = 0)) THEN BEGIN
Customer.“Credit Limit (LCY)” := 100000;
Customer.MODIFY
END

And on PostReport trigger write a message informing you completion of report.

3

Hi,

Thanks for your reply but no modification was done on the credit limit. Is there any other suggestion.

Thanks

Gbenga

4

Hello

As Balance (LCY) is a flow field, so Use Customer.CALCFIELDS(“Balance (LCY)”); before the earlier code

5

Hello,

It is still not working, Please is there any way out or am i doing some thing wrong.

Thanks

Gbenga

6

Hi Gbenga,

Can you post your amended code?

7

Customer.CALCFIELDS(Customer.“Balance (LCY)”);
IF((Customer.“Balance (LCY)”=0) AND (Customer.“Credit Amount (LCY)”=0))THEN BEGIN
Customer.“Credit Amount (LCY)”:=100000;
Customer.MODIFY
END

8

Are you using this code in processing only report which has Customer table as dataitem and the code is written on AfterGetRecord trigger?

then it should work…

9

Export your object as text file and paste here, then we can help you out…