Recalculate Costs on Purchase Orders

Is there a way to Recalc Cost on a PO similar to the Recalc Price function on SO?  We have many open POs in our system where we need to update line item cost to new vendor cost based on price increases.  Those new vendor costs are uploaded to the SKU, so we just need an efficient way to update existing PO line-item detail to that new cost.

Parents
  • Just wondering if you came up with a good way of doing this.  We have several vendors that even though they have had our POs since the end of last year, they are still pushing through price increases on product that has not shipped yet.  Since these are sole source suppliers we basically have no choice but to take it.   Thanks in advance.

  • in reply to Hobie16

    Or receive at the updated price and the difference flows through as a purchase variance

  • in reply to Wayne Schulz

    It will only be a variance during Receipt of Goods if the item was a Standard Valuation item.  Otherwise, it will be received at the cost on the PO AND the PO will be updated with received cost.  I just tested this with a Lot, Std, and FIFO item on a PO - all with an original cost of 15.  I received at 20 each.  There was a variance for the std item, nothing for the others, and the PO now shows a cost of 20 each. The only variance at that point would be if the invoice was at a different cost.  Note that the cost is put into inventory when you do ROG - it's too late to get it right with a ROI.

Reply
  • in reply to Wayne Schulz

    It will only be a variance during Receipt of Goods if the item was a Standard Valuation item.  Otherwise, it will be received at the cost on the PO AND the PO will be updated with received cost.  I just tested this with a Lot, Std, and FIFO item on a PO - all with an original cost of 15.  I received at 20 each.  There was a variance for the std item, nothing for the others, and the PO now shows a cost of 20 each. The only variance at that point would be if the invoice was at a different cost.  Note that the cost is put into inventory when you do ROG - it's too late to get it right with a ROI.

Children
  • in reply to bethbowers

    I have a client with the same issue. They do ROG without the invoice number and want the correct cost in inventory for commission sake.  It is good to know someone already tried VI. I started looking at scripting but it would just be nice if Sage added an update utility.