Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #1
PO From Stock - Wrong PurchData
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:

   

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.

   

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)