Remaining Quantity not display in extracts

[base]

Hello, I thought Bug #448 seems to fix this problem, however I still doesn't work for me. I'm running 2.1.1 and the attached shot shows an emtpy "remaining" field for the extract. It's a bit strange because sometimes it works and some other it does not. I think the problem comes if you try to update the fields once you have created an empty extract. In any case the update does not seem to change the remaining quantity value. Could you please fix the problem ??

[base]

screenshot

[Nicklas Nordborg]

Your description is not very clear on how to reproduce the error. It works fine when I try it. Can you please give a step-by-step instructions how to reproduce the error.

[base]

Ok, 1:Create a sample "Adipose" 2:Create an empty extract (don't fill neither original quantity or used quantity).Save 3:Edit your extract, add the used quantity and original quantity. SAVE ->Problem, you don't see the remaining quantity. More over when you delete an extract the sample doesn't get updated properly and the remaining quantity is wrong.

Is that ok ?

[base]

The sample quantity does not get updated when you delete the extract.

[Nicklas Nordborg]

The problem is that the remaining quantity is given a null value if no original value is specified when the extract is created. Then, whenever you change the original value the remainging still is null since in the database world you can't add or subtract anything from a null value. The end result is still null.

A possible solution is to put 0 for the remaining quantity in the case no original is specified. Then we can always add/subtract when the original value changes. When asked for the remaining quantity we have to return null if the original is null.

The fix should be rather simple to implement, but we also has to consider those biomaterials that already has a null value in the remaining quantity and calculate a new value for them.

[Nicklas Nordborg]

(In [3079]) References #466: Remaining Quantity not display in extracts

Fixed problem for new items. Still remains to fix existing items that has a null value for the remaining quantity.

[Nicklas Nordborg]

(In [3086]) Fixes #466: Remaining Quantity not display in extracts

[Jari Häkkinen]

Reopened since the previous upgrade failed.

[Nicklas Nordborg]

I don't think the updateToSchemaVersion29() works for Postgres. See the mailing list archive: ​http://sourceforge.net/mailarchive/forum.php?thread_id=31617247&forum_id=12992

It is not the same error as the MySQL 5.0.27 bug.

[Martin Svensson]

(In [3136]) Fixes #466 Remaining Quantity not displayed in extracts.