Finance | Project Operations, Human Resources, ...

Overflow in floating point, number too large

(0) Share

Report

Posted on by Patricia Pico

This error ocurs in Receipt/Invoice Entry (04.010.00) screen trying to modify the quantity received field.

This happens only in the first line. We tried to modify the others without problems

This is the receipt nbr 4 for the PO

I need a work around to save this error.

Thanks

I have the same question (0)

All responses (11)

Answers (0)

CFROTON 4,710 on at

Like (0)

Report

Dear Patricia,

It could be that the curyid is blank or incorrect on the transaction. You might check the POTRAN table for anything that might look wrong for this transaction.

Best Regards,

Jana MacDonald

Was this reply helpful? Yes No
Patricia Pico 15 on at

Like (0)

Report

Hi Dana

When I clicked the buttom OK at the message the receipt/invoice entry screen closed.

So no POtran record is created.

Patricia

Was this reply helpful? Yes No
CFROTON 4,710 on at

Like (0)

Report

Dear Patricia,

Isn't the record from a PO?

Best Regards,

Jana Macdonald

Was this reply helpful? Yes No
Patricia Pico 15 on at

Like (0)

Report

No.. I happens when trying to modify the quantity received and then the screen is closed.

We discovered that there is a control in the number of positions of the data to be entered.

The quantity field is parameterized in 6 decimal places.

For which a number such as 99999999.000000 causes the error and closes the screen

It is an issue that we have to resolve with the client

Thanks a lot for your help...

Was this reply helpful? Yes No
Patricia Pico 15 on at

Like (0)

Report

in the purchase setup screen the quantity and price fields are configured with 6 decimal places

The PO is entered as follows, the quantity ordered is 40428499.000000 and the price is 1.000000

Then a receipt was entered and released successfully. The quantiy received was 9852107,89

Then we try to enter a new receipt for the pending amount of the PO and when trying to save the transaction the error message 118 is displayed and the screen closes without saving the transaction.

Another case was to perform the PO for quantity equal to 40428499.000000 and unit cost equal to 1.000000 and then we tried to receipt it completely and again when we saving the receipt transaction the same error message 118 is shown and no receipt transaction is generated.

We try to enter new partial receptions for smaller amounts but in a moment we get the same error message 118

What can be causing this error that does not allow us to make new receptions. We couldn't find a way to get around this problem.

Was this reply helpful? Yes No
Patricia Pico 15 on at

Like (0)

Report

Hi.

Let me tell you that in the purchase setup screen the quantity and price fields are configured with 6 decimal places

At the PO screen we order a quantity like 40428499.000000 and the price is 1.000000

Then a receipt was entered and released successfully. The quantiy received was 9852107,89

Then we try to enter a new receipt for the pending amount of the PO and when trying to save the transaction the error message 118 is displayed and the screen closes without saving the transaction.

Another case was to perform the same PO for quantity equal to 40428499.000000 and unit cost equal to 1.000000 and then we tried to receipt it completely and again when we saving the receipt transaction the same error message 118 is shown and no receipt transaction is generated.

We try to enter new partial receptions for smaller amounts but in a moment we get the same error message 118

What can be causing this error that does not allow us to make new receptions. We couldn't find a way to get around this problem.

Was this reply helpful? Yes No
CFROTON 4,710 on at

Like (0)

Report

Dear Patricia,

You should probably create a case in support for the distribution team. Perhaps there is a limit to the decimal places?

I actually followed your screenshots and I was able to reproduce the error. I'm in 2018 CU5

I just set PO setup to 6 decimals and apparently receipt entry did not like it because I immediately got the floating point error. I changed it to 4 decimal places in PO setup and it allows me to save.

Best Regards,

Jana MacDonald

Was this reply helpful? Yes No
Suggested answer

CFROTON 4,710 on at

Like (0)

Report

I wrote up bug 40776 for this issue with the floating point error when using 6 decimal places. Workaround I guess would be to change it to 4

Best,

Jana MacDonald

Was this reply helpful? Yes No
Patricia Pico 15 on at

Like (0)

Report

Jana, thanks for registering the bug in MS
The issue is that due to the characteristics of the company, a construction company, working with 4 decimal places is almost impossible. They certify work progress with the precision of 6 positions.
How is the bug proritized? Is it possible that it has the highest? And how can I follow the progress of it?

Thansk again

Patricia

Was this reply helpful? Yes No
TomMalia 325 on at

Like (0)

Report

I am experiencing very similar issues at a client running SL 2018 CU2 ....the PO setup screen was set to precision = 4

The overflow error is happening when trying to release a receipt batch that has a quantity of of only 25.0 units and a unit price of 8.87

I am going to attempt to submit a support request but wanted to contribute to this post as confirmation that there appears to be a really error in the PO Receipts processing logic related to floating point over flow and it still exists in SL 2018 CU2.

I will try to remember to come back and post results of attempting to submit to tech support.

Was this reply helpful? Yes No