Sage 100

 View Only
  • 1.  I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:34
    I am working on an import into GL_TransactionJournalHeader and I cannot get the import to recognize that the header fields are there. With the test, I get ""L record AddLine() Failed. Missing or invalid header"". I have assigned a value to all the header fields so I don't know what it doesn't like. I checked the knowledgebase a found a couple of articles with links to sample imports, but of course, the links are no longer valid. Imagine that. Anyone have a sample import you would care to share or an idea on why my import won't work. Thanks.


  • 2.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:37
    What version? Do you get any invalid fields on the Header?


  • 3.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:40
    Version 5.00.4. No valid fields. When I test, the header line doesn't even show on the test and I have assigned all values so it is not even looking at the import file. I thought the file might be the problem and so tried assigning all values.


  • 4.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:45
    Anything on the select or record tabs that would be filtering those out? I run into problems when I assign every value on the header. Maybe try adding a few columns with the info you have assigned and see if that works.


  • 5.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:47
      |   view attached

    Attachment(s)

    EXP
    GLTransJournal_v4.EXP   90 KB 1 version


  • 6.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 17:47
      |   view attached
    Sample

    Attachment(s)

    exp
    gl_trn_entry_sample_40.exp   90 KB 1 version


  • 7.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-24-2014 18:05
    Batches? Are they using batches and you don't have the BatchNo field in your import?


  • 8.  RE: I am working on an import into GL_TransactionJourn

    Posted 04-28-2014 11:12
    Thank you all for the help. We were trying to use run time assigns for all the header fields and it turns out that you have to have at least one header field read from the file.


  • 9.  RE: I am working on an import into GL_TransactionJourn

    Posted 11-08-2016 12:23
    Fyi, my solution was to remove the Import Job's H JournalComment field that was doing a Replace from col 3 of which col 3 in the import source file was completely empty.