"attempted to divide by zero navision" error

(0) Share

Report

Posted on by manish.yadav

1,893

Dear Experts,

I have write the code for calculate the INR value of foreign purchase invoice. But when I try to run the report it is showing the error:

"attempted to divide by zero navision"

My code are below:

Purch. Inv. Line - OnAfterGetRecord()
txtINRValue := txtFinlAmount * 1/(recPurchInvHeader."Currency Factor");

Here txtINRValue,txtINRValue are decimal type variables.

Please help me to resolve it.

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (2)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

You’ve to test if recPurchInvHeader."Currency Factor" is 0 before performing the calculation:

IF recPurchInvHeader."Currency Factor" <> 0 then

txtINRValue := txtFinlAmount * 1/(recPurchInvHeader."Currency Factor")

ELSE

txtINRValue := 0;

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

You can use below statement :

IF recPurchInvHeader."Currency Factor" <> 0 THEN

txtINRValue := txtFinlAmount * 1/(recPurchInvHeader."Currency Factor")

ELSE

txtINRValue := txtFinlAmount;

Was this reply helpful? Yes No
Suggested answer

manish.yadav 1,893 on at

Like (1)

Report

Thank you very much. I have tested it, working fine. You guys are always best.

Was this reply helpful? Yes No
Verified answer

Olister Rumao 3,967 on at

Like (0)

Report

Hi,

Have you used

recPurchInvHeader.FINDFIRST or recPurchInvHeader.GET?

As, the recPurchInvHeader."Currency Factor" results to be zero without FINDFIRST or GET function.

The IF recPurchInvHeader."Currency Factor" <> 0

might only check if there is any value in recPurchInvHeader."Currency Factor" but using GET or FINDFIRST might give the actual value. Try putting MESSAGE to check what values you get.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Hello Olister,

I have tried with

IF recPurchInvHeader.GET(recPurchInvHeader."Currency Factor") THEN BEGIN

IF recPurchInvHeader."Currency Factor" <> 0 THEN

txtINRValue := txtFinlAmount * 1/(recPurchInvHeader."Currency Factor")

ELSE

txtINRValue := txtFinlAmount;

END;

but result is showing 0 value in all column. What should I do? Please suggest me.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

Currrncy Factor must be different than 0 in your Purchase Invoice Header. Check your Currency Code you’re using, you’re not using your local base currency so a conversion factor must be set. Otherwise you obtain zero always.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

Dear Stefano,

Thank you for your valuable feedback and sharing the knowledge.

Currently I am using the below code to get the INR value. But I don't know the reason, In some invoices value is coming correctly(converted amount which is matched with detailed vendor ledger entry) and some invoice have coming the invoice amount not coming the converted amount.

IF recPurchInvHeader."Currency Factor" <> 0 THEN

txtINRValue := txtFinlAmount * 1/(recPurchInvHeader."Currency Factor")

ELSE

txtINRValue := txtFinlAmount;

I have attached the screenshot below.

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

I suspect that in these cases the Currency Factor in your Purchase Invoice Header is 0.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

No, sir in every Purchase Invoice Header have a value. 0 is not there.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

As per Olister, if I added the code in my report, problem is resolved.

recPurchInvHeader.GET("Document No.");

thank you very much Olister.

Was this reply helpful? Yes No