Open Forum

Expand all | Collapse all

Error when combining vendors Subquery returned more than 1 value.

  • 1.  Error when combining vendors Subquery returned more than 1 value.

    Posted May 13, 2019 07:22 AM

    When attempting to combine a vendor the following error occurrs.

    Subquery returned more than 1 value.  This is not permitted when the subquery follows =,!=…..;etc

    Anyone know where to start looking?  I have used this tool for years without a hitch.

    Vendor Combiner / Modifier error




    ------------------------------
    Chuck Curtiss
    IT Mgr.
    BNI Coal, Ltd.
    Center ND
    ------------------------------


  • 2.  RE: Error when combining vendors Subquery returned more than 1 value.

    TOP CONTRIBUTOR
    Posted May 13, 2019 02:16 PM
    You need to move the error message window to view what is hidden in the main window.

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



  • 3.  RE: Error when combining vendors Subquery returned more than 1 value.

    Posted May 14, 2019 07:30 AM


    ------------------------------
    Chuck Curtiss
    IT Mgr.
    BNI Coal, Ltd.
    Center ND
    ------------------------------



  • 4.  RE: Error when combining vendors Subquery returned more than 1 value.

    TOP CONTRIBUTOR
    Posted May 14, 2019 09:25 AM
    Hi Chuck,

    Is there another error that comes up after closing the one in the screenshot?

    At any rate, see if rebuilding the PSTL stored procs makes a difference... click on the button on the lower left side of the PSTL main window.





    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    Chantilly VA
    ------------------------------



  • 5.  RE: Error when combining vendors Subquery returned more than 1 value.

    Posted May 28, 2019 07:18 AM
    ​After I close the error message it asks me to print the vendor combiner and modifier report.  The report prints but the vendors are not combined / modified.   I rebuilt the stored procs for PSTL and attempted the combine / modify again and received the same error message.

    ------------------------------
    Chuck Curtiss
    IT Mgr.
    BNI Coal, Ltd.
    Center ND
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role