PO25 Quantity Break

 10 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
pglibra
Veteran Member
Posts: 76
Veteran Member

    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
    Veteran Member
    Posts: 1020
    Veteran Member
      It's just this one line? We do this but the markup is on the header. It applies to all lines.
      pglibra
      Veteran Member
      Posts: 76
      Veteran Member
        PO25 has 3 different items and the markup/price is different for each.
        Kat V
        Veteran Member
        Posts: 1020
        Veteran Member
          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
          Veteran Member
          Posts: 76
          Veteran Member
            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
            Veteran Member
            Posts: 1020
            Veteran Member
              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
              Veteran Member
              Posts: 76
              Veteran Member
                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
                Veteran Member
                Posts: 1020
                Veteran Member

                  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
                  Veteran Member
                  Posts: 76
                  Veteran Member

                    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
                    Veteran Member
                    Posts: 1020
                    Veteran Member
                      Yeah - once the header is marked - it's there. Just change the markup to 0.
                      pglibra
                      Veteran Member
                      Posts: 76
                      Veteran Member
                        Ok...well, looks like PO28 is now showing GPO price (which is good)..have not been able to test PO creation...waiting on buyer...thanks for all your help.