PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/21/2020 9:03 AM by  Kat V
PO25 Quantity Break
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
pglibra
Supply Chain Revenue Coordinator
Private
Advanced Member
(96 points)
Advanced Member
Posts:44


Send Message:

--
10/01/2020 1:35 PM

    I have a question regarding how to use the Quantity Break section within PO25.

    The scenario is we have an item that is on our GPO contract using our distributor. However, our distributor will not sell this item individually (EA) and will only sell it by the case. So we purchase it from another vendor at a higher cost by the Each and that vendor is listed as the vendor in PO25. I want to show the contracted GPO price on the first screen but add the vendor's price using the markup section in Quantity Breaks.

    So contract price is $1.1283 Each and price vendor charges is $1.38. How do I set it up in Quantity Breaks/markup or is there another method of handling these situations?

    Thanks everybody.

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2720 points)
    Veteran Member
    Posts:930


    Send Message:

    --
    10/01/2020 2:52 PM
    It's just this one line? We do this but the markup is on the header. It applies to all lines.
    pglibra
    Supply Chain Revenue Coordinator
    Private
    Advanced Member
    (96 points)
    Advanced Member
    Posts:44


    Send Message:

    --
    10/01/2020 3:25 PM
    PO25 has 3 different items and the markup/price is different for each.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2720 points)
    Veteran Member
    Posts:930


    Send Message:

    --
    10/02/2020 8:54 AM
    On your behalf, may I just say - EW. No, I would need to test the following.

    OK - so you have a GPO price and for easy math we're going to say BX of 100 at $100. The example we're going to say the vendor is charging $1.25 EA.

    You're going to have to load that as "UOM Must Match" on the headers. For the direct vendor, you'll have to load EA $1 and then in the Qty break - break by Qty 1 Markup 25%. No other breaks. Try that then look at the item in PO28. It *should* say $1.25, but any queries against the price agreement line should say $1. Then I would go into RQC and attempt to order 1 EA and 100 EA to make sure Lawson doesn't try to grab it from Distribution.
    pglibra
    Supply Chain Revenue Coordinator
    Private
    Advanced Member
    (96 points)
    Advanced Member
    Posts:44


    Send Message:

    --
    10/02/2020 10:50 AM
    Ok...so I changed the Header /UOMs MUST MATCH to Y.
    Then on the line with the pricing markup, I have the base cost at $1.1283 per EA which is the GPO price.
    Then under Purchase/Service Pricing, I should use M for Markup/Discount and Q for By Quantity or Amount.
    Then what do I put in the fields below it? I assume "1" in the first box and then what goes in "New Percentage" and "New Cost"?
    BTW, vendor charges $1.38.

    Thanks again for your help with this.
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2720 points)
    Veteran Member
    Posts:930


    Send Message:

    --
    10/05/2020 9:03 AM
    I would just flat out put 1.38 in new cost and leave the new percent blank - you do one or the other and it doesn't sound like the percentage is fixed. It's just their arbitrary price for breaking the case? If there is a percent - that's preferable as it will calculate a new cost when the base GPO changes.

    And Yes - Qty 1 in the first box.

    Then the fun testing starts. If it doesn't work, at least you'll have something to open an incident with and ask "why doesn't this work?"
    pglibra
    Supply Chain Revenue Coordinator
    Private
    Advanced Member
    (96 points)
    Advanced Member
    Posts:44


    Send Message:

    --
    10/06/2020 5:12 PM
    So on PO26.4, I selected "M" for "Markup/Discount"; left "By Quantity or Amount" blank; put a "1" in the box below it; left "New Percentage" blank and put $1.38 in "New Cost" and I got this error message highlighting the New Cost field..."Value entered must be less than Current Net Cost"
    Any ideas?
    Thanks
    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2720 points)
    Veteran Member
    Posts:930


    Send Message:

    --
    10/16/2020 5:26 PM

    We are testing right now and I got this to work!

    PO25.1 on the header towards the bottom of the first tab, change the Line Level Breaks On: O (Order Totals)  Then on PO25.6, put in the GPO price.  then then rest as described.

    Be sure to release the price file.  Go to RQC, Add 1 to your cart - higher price appears.

     

     

    pglibra
    Supply Chain Revenue Coordinator
    Private
    Advanced Member
    (96 points)
    Advanced Member
    Posts:44


    Send Message:

    --
    10/20/2020 1:56 PM

    Thanks Kat,
    So I was able to do the steps you stated without any errors...yeah.
    However, before I got your response, I was testing the Base Percent Markup on the Pricing tab on another agreement that has only 2 lines.
    The vendor puts a markup of 12% on both items so I put that on the Pricing tab. Now that you explained how to put new price on individual lines of agreement, I put that on one of the lines. I then tried removing the markup from the Pricing tab and got the following error message..."Cannot change Markup/Discount flag; agreement lines exist" as well as PO28 still shows the calculated 12% markup price even though PO25.6 has the GPO price.

    So the 12% does not show up anymore in the Pricing tab but I cannot remove the "M" for Markup Or Discount...keep getting error message above.

    Suggestions?
    Thanks

    Kat V
    Sr Supply Chain System Analyst
    South Broward Hospital District
    Veteran Member
    (2720 points)
    Veteran Member
    Posts:930


    Send Message:

    --
    10/21/2020 9:03 AM
    Yeah - once the header is marked - it's there. Just change the markup to 0.
    You are not authorized to post a reply.