Sage 100

 View Only

  • 1.  VI Miscellaneous Item Description

    Posted 10-12-2021 15:00
    We are trying to import sales order using miscellaneous items. The client did not purchase inventory management. Unlike the inventory items where the imported field will create the extended description by having the length of the description being >30 we cannot get the extended descriptions for miscellaneous items to import using the same logic.

    Any suggestions? TIA

    ------------------------------
    Doug Clark
    Ardent Consulting LLC
    Charlotte NC
    ------------------------------


  • 2.  RE: VI Miscellaneous Item Description

    Posted 10-13-2021 10:15
    UDF

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: VI Miscellaneous Item Description

    Posted 10-13-2021 15:02
    I can bring the description in as a comment but I wanted to convert and train using the item description if possible. Thanks

    ------------------------------
    Doug Clark
    Ardent Consulting LLC
    Charlotte NC
    ------------------------------

    Original Message


  • 4.  RE: VI Miscellaneous Item Description

    Posted 10-13-2021 11:20
    Skip Source Data Truncation (checkbox on the first tab of the VI job).

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



  • 5.  RE: VI Miscellaneous Item Description

    Posted 10-13-2021 15:05
    The Skip Source Data Truncation box being checked did not bring in the description field on the records with description >30 Thanks

    ------------------------------
    Doug Clark
    Ardent Consulting LLC
    Charlotte NC
    ------------------------------

    Original Message


  • 6.  RE: VI Miscellaneous Item Description

    Posted 10-14-2021 17:13
    Look at my last couple posts in this thread, VI to import IM extended descriptions without replacing the regular descriptions | Sage 100 (90minds.com), you maybe able to make use of the coBusiness'ExtDescriptionText$ property in the after assign perform logic.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 7.  RE: VI Miscellaneous Item Description

    Posted 10-14-2021 17:18
    Also, what version is this on and are you trying to import the extended descriptions into CI_Item or SO_SalesOrderDetail?

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


  • 8.  RE: VI Miscellaneous Item Description

    Posted 10-15-2021 08:22

    Advanced 2020 6.20.1.0

     

    I'm trying for SO_SalesOrderDetail

     

    I will review your threads.

     

    Thanks

     

    Doug Clark
    Senior Sage 100 Consultant

    T: 910.617.4534


    E: Doug.Clark@ArdentConsultingLLC.com


    W: www.ArdentConsultingLLC.com

     

    Book A Meeting

     




    Original Message


  • 9.  RE: VI Miscellaneous Item Description

    Posted 10-16-2021 01:06
    The following worked in version 2018 but I haven't had a chance to test on 2020 yet.



    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------

    Original Message


Related Content