Sage 100

 View Only
  • 1.  3.71 Extended Description import

    Posted 08-05-2021 01:08

    I am trying to import extended descriptions into IM_03 but i have never beengood with the records tab.

    I have already imported the EXTDESC field in IM1 to "Y".

    On the import i have four fields:  item no, seq no, length, text.

    The records tab has four options: skip record, header record, comment record, and standard record. I have header and comment as lines and I am using the seq number field to say if it is 000, it is a header record, and if it is 001, it is a comment (detail record) - i have tried both equal to 000 and not equal to 001, etc.

     

    Any ideas on how it is should work?

     

    What it should be like after the import (the first line is the header and the second line is the detail).

     

    Item code                            seq no   length                   description

    1234                                      000         0050     

    1234                                      001                                         This is my description

     

    What I have imported looks like:

     

    Item code                            seq no   length                   description

    1234                                     000                                       This is my description


    The detail record of 001 is not importing (actually i think it is importing as record by itself with no item code so not good).

    The header record of 000 is not importing the length and has the description (which i can blank out on the source file).

     

    When I go into the UI, I do not of course have the extended description.

     

    It is clearly the records tab, but I do not know what to put.

                   



    ------------------------------
    Douglas Luchansky
    ACI Consulting
    ------------------------------


  • 2.  RE: 3.71 Extended Description import

    Posted 08-05-2021 08:09
    Have you tried two separate imports?  One that does the 000 and one that does the 001?

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Tennessee Software Solutions
    269-445-1625
    ------------------------------