Den 07.04.2016 08:42, skrev venussof...@gmail.com [firebird-support]:
Hi all
Sorry for resurrecting this very old thread but I have come across a
situation (hopefully Jose would be able to answer). I have found a
bug in the bQty column it was not able to reduce itself to the current
stock,
I have confirmed that the part
, COALESCE((SELECT SUM(PurchaseBillItemInner.bQty)
If I remove the SUM() I get an error that there are multiple records returned
in a singleton select. There is an iID field on each row of each table (I have
tried to use it to no avail) that can distinguish both
Hi all
Sorry for resurrecting this very old thread but I have come across a situation
(hopefully Jose would be able to answer). I have found a bug in the bQty
column it was not able to reduce itself to the current stock, eg. 3, and still
it returns two row with a qty of 3+2 = 5 qty is valued