Open Forum

 View Only
  • 1.  Purchasing error 15482

    SILVER CONTRIBUTOR
    Posted May 17, 2022 06:56 AM
    I am seeing this message
    System Message 15482
    The quantity on the PO is greater than the quantity remaining on the Blanket PO.


    On every line when entering a P.O. line.
    There is no blanket PO shown on the PO screen.
    We have no active blanket POs in the system.
     
    This only happening in the live database.
    The problem does not show in the sandbox database
    It started late yesterday and is prevent the entry of any purchase orders.
     
    I found an old reference to article 846618 in customer source, but an unable to find it.
     
    Does anyone have an answer to this or can send me the article referenced above?
    Thank you in advance for your assistance.
     


    ------------------------------
    Mark Schrier
    Information Systems Director
    Mackay Communications, Inc
    Raleigh NC
    ------------------------------


  • 2.  RE: Purchasing error 15482

    SILVER CONTRIBUTOR
    Posted May 18, 2022 01:26 AM
    Problem was caused by a row in the PurOrdDet table that had a blank PONbr. I deleted the row and all is good.

    ------------------------------
    Mark Schrier
    Information Systems Director
    Mackay Communications, Inc
    Raleigh NC
    ------------------------------



  • 3.  RE: Purchasing error 15482

    Posted May 18, 2022 03:34 AM
    That message means there is a transaction in the purchase order detail table without a PO number.

    select * from purorddet where ponbr = ''


    ------------------------------
    lalon holland

    ------------------------------



  • 4.  RE: Purchasing error 15482

    SILVER CONTRIBUTOR
    Posted May 18, 2022 09:10 AM
    Mark,

    Here is the link to the article. 

    PO (Screen 04.250.00)- System Error 15482 & 15481 - Microsoft Dynamics SL Forum Community Forum

    There is a record(s) in the PURORDDET table that has a Blank POnbr field. 

    Deleting that record(s) will correct the issue. 


    ------------------------------
    David Safstrom
    Senior Consultant
    NexTec Group
    Roswell GA/Houston, TX
    ------------------------------



  • 5.  RE: Purchasing error 15482

    GOLD CONTRIBUTOR
    Posted May 18, 2022 09:45 AM

    We have had this before, kept the article :)

    System Message 15482 "The Quantity on the PO is greater than the Quantity remaining on the blanket PO for this item" in Solomon Purchasing

    TechKnowledge Content

    SYMPTOMS
    When you are in Purchasing, you may receive one of the following error messages:

    System Message 15482 - The quantity on the PO is greater than the quantity remaining on the blanket PO for this item.

    System Message 15481 - The extended cost on the PO is greater than the extended cost remaining on the blanket PO for this item. Would you like to change this value?

    CAUSE
    This issue occurs if one of the following conditions is true:

    In Purchase Orders (04.250.00) the Quantity entered is more than the Quantity remaining on the Blanket Order.

    A record exists in the PURORDDET table with a blank value in the PONbr field.

    RESOLUTION

    Note If you receive System Message 15481 or 15482 in Purchase Orders (04.250.00), and the PO Type is Blanket Order, it may be a valid message. Either message may occur if the Quantity or Extended Cost entered on the Purchase Order is more than the Quantity or Extended Cost remaining on the Blanket Order.

    If you receive System Message 15481 or 15482 and the Purchase Order PO Type is not Blanket Order, a record in the PURORDDET table may exist with a blank value in the PONbr field. To resolve this issue, use Query Analyzer to delete the incorrect record in the PURORDDET table.

    Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

    1. In Query Analyzer, access the appropriate Application database and run the following statement to identify PURORDDET records with a blank PONbr value:

    SELECT * from PURORDDET where PONbr = ''
    (where '' = 2 single quotes)

    2. If records are returned, run the following statement to delete the incorrect PURORDDET records:

    DELETE from PURORDDET where PONbr = ''
    (where '' = 2 single quotes)

     



    ------------------------------
    Karla Johnson
    System Architect
    Schneider Electric IT Mission Critical Services, Inc
    Carrollton TX
    ------------------------------