PO From Stock - Wrong PurchData - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: Problems / Bugs? (http://www.weberp.org/forum/forumdisplay.php?fid=8) +--- Thread: PO From Stock - Wrong PurchData (/showthread.php?tid=8105) |
PO From Stock - Wrong PurchData - VortecCPI - 02-21-2018 SelectProduct.php PO_Items.php When clicking on "Order" hyperlink new PO does not use latest pricing from PurchData table. In example below we have new pricing coming into effect today and the code uses the old price. In the example below the top entry went into effect this morning: [attachment=762] I revised the SQL and added the following: Code: AND DATEDIFF(NOW(), purchdata.effectivefrom) >= 0 I think we should add effectivedate to the Stock purch data area table as well. [attachment=763] |