Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Supplier Purchasing Data
04-23-2015, 10:39 PM
Post: #1
Supplier Purchasing Data
It could be useful a procedure that auto-update the Supplier Purchasing Data (suppliers, price, date, ...) looking at the last deliveries of the items.
Find all posts by this user
Quote this message in a reply
04-24-2015, 12:06 AM (This post was last modified: 04-24-2015 12:06 AM by falkoner.)
Post: #2
RE: Supplier Purchasing Data
The problem with this is that the last delivery may not be at the standard price (you maybe needed it in a hurry so paid a premium, or you got it cheap in a one off fire sale for instance) and you wouldn't want this overwriting the standard price setup in the supplier purchasing data.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
04-24-2015, 03:35 AM
Post: #3
RE: Supplier Purchasing Data
I agree. Purchasing data should drive P/O price and only be overwritten for a specific reason. Then the P/O price should be compared against the invoice price before entering Invoice and they should match.
Find all posts by this user
Quote this message in a reply
05-17-2015, 11:36 PM
Post: #4
RE: Supplier Purchasing Data
Have it to be hand-mantained?
Is it correct that the price goes to zero after a buy?
Find all posts by this user
Quote this message in a reply
05-18-2015, 10:41 PM
Post: #5
RE: Supplier Purchasing Data
Which price went to 0 after purchasing? A price in the system got set to 0?
Find all posts by this user
Quote this message in a reply
05-19-2015, 07:31 PM
Post: #6
RE: Supplier Purchasing Data
Maybe the price in supplier data goes to zero in the time lapse between the material incoming and the invoice entry?
   
Find all posts by this user
Quote this message in a reply
05-19-2015, 11:30 PM
Post: #7
RE: Supplier Purchasing Data
Quickly greping the code shows that the price in the purchdata table only gets updated via the PurchData.php and the SupplierPriceList.php scripts, so there is nothing that can be dynamically changing that cost.

Tim
Visit this user's website Find all posts by this user
Quote this message in a reply
05-19-2015, 11:37 PM
Post: #8
RE: Supplier Purchasing Data
You should use the audit trail to see if you can determine who may have updated the table
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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