This topic contains 2 replies, has 0 voices, and was last updated by OneITGuy 8 years, 6 months ago.

  • Author
    Posts
  • #9003

    OneITGuy

    Hey Y’all! I often update purchase prices on our existing PO’s by pushing rate to the items on the order. Works Great! Very straight forward csv, 3 fields. (PO internal id, Item number, Rate=purchase price) This is works well for single PO’s and specific items.

    I am in a situation now where Purchase price has been changed for 100 items. I need to update the purch price on existing PO’s, but not all 100 items are on every PO. I know I can dig into each of the POs and find the items on it and adjust my CSV items to match accordingly. Is there anyway I can fashion my csv to contain all 100 items but only updates the ones that appear on the existing PO I am pushing to?

    Thanks
    This is a cached copy. Click here to see the original post.

  • #9004

    samzad

    Why you have to use all 100 line items? Does not make sense, generate a saved search with an extra column “Line ID” and use these line Ids to identify your target line item. This way you don’t have to include all 100 lines only the lines you need to change. Remember in this case there are 2 keys PO internal ID and line ID, make sure to include PO internal ID on every line.

  • #9005

    OneITGuy

    I don’t have to use all 100 lines, it would just make it easier. Otherwise i have to go through every single one of the 40 PO’s and determine what items of the 100 are on each. I am trying to avoid extra work of determining specific items of each PO. Looking for a shortcut. Thanks for the reply though.

You must be logged in to reply to this topic.