Sage 100

 View Only

  • 1.  Error when copying custom sales order panels

    Posted 07-06-2023 13:05

    Client running Sage Premium 2022 PU2 has a large number of UDF's on the sales order header, address and lines panels.  Trying to copy the customization from one user to another and get this:

    Error 15

    O/S Error 42000:[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '/'.

    Program CM_SELECTOR_UI.PVC

    Statement 1973

    The header and address tab customizations get copied but nothing on the lines panel. 

    I tried copying the so_salesorder.m4l file from the source user and that brings the line UDF's in but one drop-box UDF is missing the drop-down arrow.  It's a 57 character text field with a validation list and a default value that shows up blank and without a drop arrow.  I can type data in the field and it will try and validate against the list.

    I've been banging my head against this for a while today, hoping someone else has run across it before.

    Thanks!



    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------


  • 2.  RE: Error when copying custom sales order panels

    Posted 07-06-2023 13:17

    Grid data isn't contained within the M4L... it is stored in a system table (SY_GridDefinition).  Try to reset panels / reset grids... or remove / re-add the field to see if it straightens out the table entry.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: Error when copying custom sales order panels

    Posted 07-06-2023 13:46

    Thanks Kevin, I tried both of those suggestions and still a blank field with no drop arrow.  I did find an article on the Sage KB about a drop box UDF behaving in a similar way:  

    Summary: A new UDF (User Defined Field) was created using Custom Office in SO_SalesOrderDetail but in Sales Order Entry the drop box does not allow selection of existing values and does not work as a "drop box" in grid definition although values can be typed in.

    Cause:  Drop Down does not have proper room to display in the Grid Definition area.

    I looked at SY_GridDefinition for the affected user and the source user and can't find any differences for the UDF.  Not sure if there is a "master" record for a grid that might have a setting that could be changed?

    Open to any other suggestions too.

    Thanks!



    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------

    Original Message


  • 4.  RE: Error when copying custom sales order panels

    Posted 07-06-2023 14:02

    Even though the field value may be one line, Are you sure the drop-box has enough vertical room to display the selection options?



    ------------------------------
    Lee Graham
    Friendly Systems, Inc.
    ------------------------------

    Original Message


  • 5.  RE: Error when copying custom sales order panels

    Posted 07-06-2023 15:13
    Edited by Bernie Lehman 07-07-2023 10:26

    I figured this out, these are the steps I had to take:

    1. Delete the form for the user in customizer
    2. Copy the form from the good source user in customizer
    3. Bypass the error in Sage
    4. Open the form in customizer and add the UDF's to the primary grid and save it
    5. Use DFDM for SY_GridDefinition (thanks @Kevin Moyes), locate the UDF in SO_SALESORDER:GD_LINES:###:UserKey:Bxxx (the Bxxx appears to be a field sequence number) and change the CellType to LookupHideBtn
    6. The user signed in to Sage and opened sales order entry
    7. Sage created new records with the key SO_SALESORDER:GD_LINES:"CompanyCode":UserKey:"WorkstationName" based on the Bxxx record

    I still don't know what is causing the error when copying the customization but this fixed the issue with the default value and drop list missing from the UDF.

    Many thanks for the suggestions!



    ------------------------------
    Bernie Lehman
    Partner
    Lehman Wesley & Associates
    ------------------------------

    Original Message


  • 6.  RE: Error when copying custom sales order panels

    Posted 07-06-2023 15:08

    Create a new UDF.  Export the data from the current UDF and import it to the new one.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



Related Content