PO20 Dists Out of Balance

 6 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member
Posts: 100
Veteran Member

    Hi everyone - we're getting a weird error here. We issued a PO a few days ago but we have to update the quantity. After we made the change, the buyer tried to release it but we're getting "Cannot release. Line dists out of balance"

     

    I've never seen this before, does anyone have insight?

    JonA
    Veteran Member
    Posts: 1163
    Veteran Member

      You probably have this line distributed by quantity and not percent. When you change the quantity on the line and the distribution on the line is by quantity and not percent, for some reason Lawson doesn't update the quantity in PO21.3 (Mult button). The quantities on the line and in PO21.3 have to be equal or you get that error.

      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      SCMaster-jk2
      Veteran Member
      Posts: 100
      Veteran Member
        Nice! I'll have our buyer look into that. Forgive my ignorance but what is distribution by qty vs percent?
        JonA
        Veteran Member
        Posts: 1163
        Veteran Member
          You can distribute a single PO line across multiple cost centers and that distribution can be set by quantity, percent or amount. For instance, let's say you have a snow removal service for 5 physician's offices in the area. You can set the distribution on the line by assigning 20% to each office. Or perhaps PT wants to order bulk Theraband for a discount and they want the 50 BX to be expensed to multiple PT departments across the health system. You can set the distribution by quantity in this case. Setting distribution by amount can be problematic if the vendor isn't invoicing for the full amount of the line. If the invoice comes in less than the full amount AP has to determine how much to apply to each distribution. God forbid they should have to do math (did I say that out loud?). I recommend to our buyers to use percent rather than amount for services with multiple distributions.
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          Michelle Junk
          New Member
          Posts: 2
          New Member
            This information is very helpful! I am having the same issue but the distribution for the line is only for 1 cost center and it is set at 100%. I did notice that the PO quantity was for 76 EA, Received Qty was 75 EA, Matched quantity was approved at 76 EA and we paid for 76 EA. Not sure if the received qty and paid quantity being different would cause this error, "Cannot release, line 000002 dists out of balance".
            Any thoughts on how to correct this one?
            I appreciate any help you can provide.
            JonA
            Veteran Member
            Posts: 1163
            Veteran Member
              Is there any “remaining” amount or quantity in PO21.3? Shows toward the top of the form above the distribution lines.
              Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
              Michelle Junk
              New Member
              Posts: 2
              New Member
                No - it is blank except for the % symbol.