Re: [WebERP-developers] StockStatus.php Quantity on Order wrong

[Phil D. <ph...@lo...>]

Thanks Bob - fixed.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 20/09/14 07:02, rfthomas wrote:
> We order many items where tehre are conversions required between the vendor
> units and our units.  For example we inventory washers by piece but order
> then by package.  The package contains 100 washers.
>
> We enter the conversion into the order, ordering 1 package.  The order
> detail shows 100 pieces ordered.  Aside from StockStatus.php, all displays
> properly show the quantity on order being 100 pieces.  StockStatus.php
> incorrectly multiplies by the conversion factor on the order detail record,
> showing 10,000 pieces on order.
>
> Lines 177 & 178 have been changed to:
>
> 		$sql="SELECT SUM(purchorderdetails.quantityord -
> 							purchorderdetails.quantityrecd)
>
> the quantity on order is now properly displayed.
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/StockStatus-php-Quantity-on-Order-wrong-tp4657660.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Slashdot TV.  Video for Nerds.  Stuff that Matters.
> http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>