Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
PO From Stock - Wrong PurchData
02-21-2018, 09:32 AM, (This post was last modified: 02-21-2018, 09:43 AM by VortecCPI.)
PO From Stock - Wrong PurchData

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:


I revised the SQL and added the following:

    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.

Forum Jump:

Users browsing this thread: 1 Guest(s)