Sourcing

Get Involved. Join the Conversation.

Topic

    Amit Arora
    How to upload price breaks or price tiers with negotiation...
    Topic posted July 27, 2018 by Amit AroraRed Ribbon: 250+ Points, tagged FAQ, How-To, Negotiation Creation, Negotiation Management, Spreadsheet Related, Tip 
    89 Views
    Title:
    How to upload price breaks or price tiers with negotiation lines spreadsheet
    Summary:
    Import multiple price breaks or quantity based price tiers in negotiation lines using negotiation lines spreadsheet
    Content:

    Starting update 18B, you can upload price breaks or quantity based price tiers using the negotiation lines import spreadsheet.

    New template for Negotiation Lines Spreadsheet comes with the price breaks and price tiers columns. To insert additional price break, add new columns for Price Break Ship-to Organization, Price Break Location, Price Break Quantity, Price Break Target Price, Price Break Start Date, and Price Break End Date in the spreadsheet. Similarly, to insert additional quantity based price tier, add new columns for Price Tier Minimum Quantity, Price Tier Maximum Quantity, and Price Tier Target Price. These columns can be inserted as many number of times as the number of price breaks or price tiers needed.

    Note,

    • Columns Suppliers Modify Price Breaks and Price Break Type apply to all price breaks and therefore must not be repeated in the spreadsheet.
    • Insert new columns in the same sequence as the existing price break or price tier columns.
    • New set of price breaks or price tiers columns must be inserted after Price Break End Date and before Attribute columns.

    For more details, refer to Release Readiness Updates.

    Image: