Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Supplier Purchasing Data
04-23-2015, 10:39 PM,
#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.
Reply
04-24-2015, 12:06 AM, (This post was last modified: 04-24-2015, 12:06 AM by TimSchofield.)
#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
Reply
04-24-2015, 03:35 AM,
#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.
Reply
05-17-2015, 11:36 PM,
#4
RE: Supplier Purchasing Data
Have it to be hand-mantained?
Is it correct that the price goes to zero after a buy?
Reply
05-18-2015, 10:41 PM,
#5
RE: Supplier Purchasing Data
Which price went to 0 after purchasing? A price in the system got set to 0?
Reply
05-19-2015, 07:31 PM,
#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?
   
Reply
05-19-2015, 11:30 PM,
#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
Reply
05-19-2015, 11:37 PM,
#8
RE: Supplier Purchasing Data
You should use the audit trail to see if you can determine who may have updated the table
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)