webERP Forum
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
    ORDER BY purchdata.effectivefrom DESC
    LIMIT 1";

I think we should add effectivedate to the Stock purch data area table as well.

[attachment=763]