PO20 Dists Out of Balance

 6 Replies
 1 Subscribed to this topic
 38 Subscribed to this forum
Sort:
Author
Messages
SCMaster-jk2
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 2
New Member
No - it is blank except for the % symbol.