PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/17/2017 8:05 AM by  JonA
PO20 Dists Out of Balance
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
SCMaster-jk2
SCM Analyst
Private
Veteran Member
(240 points)
Veteran Member
Posts:100


Send Message:

--
03/16/2017 11:04 AM

    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
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    03/16/2017 11:24 AM

    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    SCMaster-jk2
    SCM Analyst
    Private
    Veteran Member
    (240 points)
    Veteran Member
    Posts:100


    Send Message:

    --
    03/16/2017 5:08 PM
    Nice! I'll have our buyer look into that. Forgive my ignorance but what is distribution by qty vs percent?
    JonA
    Private
    Private
    Veteran Member
    (2766 points)
    Veteran Member
    Posts:972


    Send Message:

    --
    03/17/2017 8:05 AM
    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 - Supply Chain Analyst - Materials Management - MidMichigan Health
    You are not authorized to post a reply.