Prepayment Percentage Accurecy Problem

(0) Share

Report

Posted on by ADIGA88

Hi All,

I have had this problem for a while now, this issue happens when I enter the Prepmt. Line Amount Excl. VAT directly and not using the percentage (I don't know if our partner allowed us to edit it) the scenario goes as follows:

on line level Prepayment % = Prepmt. Line Amount Excl. VAT / Line Amount Excl. VAT

Prepayment % = 245,019.75 / 516,256.00 = 0.4746090118080952

and the prepayment field only allows 4 after the decemal point so it will store it as 47.4609%

so now 245,019.75 / 47.4609% = 516,256.0128442571

516,256.0128442571 <> 516,256.00

in short this is what I think the problem is and getting this trying to approve the PO or view PO statistics.

2804.Image-1.png

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Andy Sather on at

Like (0)

Report

Hello,

If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hello,

I tried your scenario in my CRONUS US database and this was my results:

then try Approval -

I am guessing you should check with your Partner if anything was done to the field value. It should round properly and work.

You could always test all this in CRONUS to see if it works.

Thanks,

Steve

Was this reply helpful? Yes No
ADIGA88 on at

Like (0)

Report

Thank you Steven for your answer,

Did you try to check the PO status or approve the approval request? There where this error appears.

Regards,

Hisham

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hisham,

Yes, and I still did not get the error. I suggest putting a support ticket into Microsoft or asking your Partner to debug the issue.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

ADIGA88 on at

Like (0)

Report

Hi Steve,

We solved this issue with our partner but put restrictions on entering numbers that will produce a lot of numbers after the decimal point.

Hisham.

Was this reply helpful? Yes No