UOM Multiplier

 6 Replies
 0 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
Metrazal
Basic Member
Posts: 14
Basic Member

     I have a situation where I need to convert a unit of measure down.  I need to buy 25 units and then have Lawson convert this down to a stocking unit of measure of 1.  Is this possible?  Can I use a multiplier of .04 to achieve this?  Any help would be appreciated.

    Example:  I buy 50 units of Product A from a vendor and when it is received into my inventory it is "stocked" as 2 boxes.




    Thanks,

    Metrazal 
    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
      I'm not sure how that would work, but you could try setting up IC11 with your Stock UOM set to EA with EA being the Buy UOM and BX set up as a secondary Trans UOM. Then on IC12, you would set the Transaction Default UOM as BX.

      The system will still track your item by EA, but it might force transactions to process by the BX.
      David Williams
      JonA
      Veteran Member
      Posts: 1163
      Veteran Member
        I'm not sure I understand completely what you're trying to do. It sounds like you're buying a CA of 50 units and your UOM conversion is set at 2 (BX per CA), BX being your low UOM. Do you want to stock by the EA?
        Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
        Metrazal
        Basic Member
        Posts: 14
        Basic Member
          I have a vendor that will only distribute a product by each.  Even though the product is provided in a box of 25.  IE: If I order 25 boxes via EDI, the vendor will supply (1) box.  This creates confusion and leads to potential issues.  Normally, I would just match the vendors UOM but the product in question is tracked by lot numbers and using an their UOM as a Stocking UOM creates other issues. 

          Thanks,

          Metrazal
          JonA
          Veteran Member
          Posts: 1163
          Veteran Member
            If the vendor refuses to sell by the BX you don't have a lot of choice. I would set up your UOM conversions as David said (you can also set BX as the primary transaction UOM and EA as the secondary). We don't track any supplies by lot # in Lawson so I'm not sure what issues you would run into with this setup.
            Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
            Red
            Veteran Member
            Posts: 87
            Veteran Member
              Metrazal,
              You CAN have fractional/decimal conversions for units of measure, but it is not recommmended. You can do this by adding a UoM lower than the Tracking UoM. As painful as it may be, especially if you have the item as inventory-tracked, it is much better to update the lowest UoM as the Tracking UoM and calculate back up from there. It can require some work to clear out open transactions, but it is functionally much cleaner.

              Also, we experience the same issues with a few of our suppliers. We order by the BX, the vendor accepts the order at the BX, but then invoices by the EA. As long as AP is paying attention, it is not terrible, but it still causes issues in what should be an automated process.

              Good luck,
              Red
              Learn from the Past. Prepare for the Future. Act in the Present.
              Metrazal
              Basic Member
              Posts: 14
              Basic Member
                Thanks for everyone's suggestions. I am trying to work with our vendor to resolve this without having to make any internal adjustments but if that fails, I will try your recommendations.

                Thanks again,

                Metrazal