New Item added - cost not populating in Search

 9 Replies
 2 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Bev Edwards
Veteran Member
Posts: 366
Veteran Member

    I added a new item to our item master (it's a LUM item).

    It was ordered automatically via our Omnicell system and the correct cost was pulled.

    However, when you use the Search option in Requisition Center and try to add the item to the shopping cart, a zero cost is displayed and you get an error upon adding.

    Is there a way to fix this?

    Sheri
    Veteran Member
    Posts: 163
    Veteran Member
      In RQC are you in the correct from Location on Profile Tab?

      You need to be in the same location as the item resides to pull pricing, and/or have a PO25 record of the item.
      Bev Edwards
      Veteran Member
      Posts: 366
      Veteran Member

        Yep. I had the correct Requesting location (the user did too) and there is a PO25.6 line for the item, showing the correct pricing.

        When you search, locate the item, then add it to the shopping cart, the error pops up saying that you have to add a cost and the cost in the cart displays as 0.00.

        lars
        Veteran Member
        Posts: 54
        Veteran Member
          Is this item new to 25.6?
          If it was added after other items, you need to release the PO25 all over again, or, at least, that is what I had to do.
          JonA
          Veteran Member
          Posts: 1163
          Veteran Member
            I believe Sheri was referring to the From Location associated with that requesting location used on the req. If you have participants identified in PO25.3 for the agreement the From Location on the req needs to be added as a participant in order to pull the cost from the agreement on the req line. 
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            Kat V
            Veteran Member
            Posts: 1020
            Veteran Member
              Which version of RQC are you on? It periodically goes buggy for us. EX: Search part number ABC and find L#123 but no cost. Search again for 123 and it displays with cost.

              I asked Infor and it of course works just fine in Infor 10.
              Bev Edwards
              Veteran Member
              Posts: 366
              Veteran Member
                We're on 9.1, msp 7
                Of course 10 works!

                They're working on XI now. I think we're scheduled to move to 10 sometime next year.
                Bev Edwards
                Veteran Member
                Posts: 366
                Veteran Member
                  Jon - There are no participants listed in PO25.3 for this agreement. All of the items are available in RQC via Express order. Some are available in a LUM template if they want to order that way.
                  Scott Perrier
                  Veteran Member
                  Posts: 39
                  Veteran Member
                    Everyone comments are leading you in the right direction. if you run a catalog search in RQC and no cost is returned, typically it is (particitpants, end dates, on hold, or not released).

                    RQC catalog search uses the RQIC interface which relies on the keywords to get items and then finds best price based on participation/ priority. RQC Express order uses a different RQI* interface. RQ10/RQ500 finds the contract through a slightly different method using lawson/ vendor item master cross reference to pull the correct vendor item to lawson item. it then pulls the best PO25 pricing from based on participation / priority / price for that vendor which is why your replenishment works. Check the po13.3 to make sure the correct vendor default item is flagged and it matches your contract vendor item. Verify the contract that vendor item is not on that contract twice, po28 will not reflect that. Check the contract header for the UOM must match flag set to yes. Release the contract line and then re-release the entire contract. Next, add the company to the agreement participants list. Check RQC catalog search after each step to see if a price shows.
                    SCMaster-jk2
                    Veteran Member
                    Posts: 100
                    Veteran Member
                      In addition to what Scott said, make sure the contract is released. I can't tell you how many times I've forgotten to release and not have my pricing show up.

                      Maybe you can also put a fake req in using RQ10 to see where the item is trying to pull pricing from (check under the purchasing tab after the line is added)