Sage 100

 View Only

  • 1.  GL Exchange

    Posted 02-03-2019 17:11
      |   view attached
    I am trying to import GL transactions....I run the GL Exchange test and it says it is importing 313 lines of 313...
    But when I actually go and do the import...nothing imports...
    This is the import log message in every line...
    YOU MUST ENTER AT LEAST ONE LINE.


    ------------------------------
    Lourdes Sobrino
    LU2 Solutions
    ------------------------------


  • 2.  RE: GL Exchange

    Posted 02-03-2019 17:36
    It is something that is rejecting all records.  Posting to a closed period, bad source journal code, bad date format etc ?

    ------------------------------
    Jeff Fiddelman
    Exeplex, LLC
    ------------------------------



  • 3.  RE: GL Exchange

    Posted 02-03-2019 20:19
    I have verified everyting....tried changing date format and nothing helps....😡😡

    ------------------------------
    Lourdes Sobrino
    LU2 Solutions
    ------------------------------

    Original Message


  • 4.  RE: GL Exchange

    Posted 02-03-2019 20:25
    Edited by Nancy Hanson 02-03-2019 20:34
    Can you post a snipped of the first few lines of the source file?
    Any blank columns between fields?
    By any chance is this a new company and is source journal JE setup?

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


  • 5.  RE: GL Exchange

    Posted 02-03-2019 20:45
      |   view attached
    Here you go....and I have tried with both formats mm/dd/yy and YYYY-MM-DD

    ------------------------------
    Lourdes Sobrino
    LU2 Solutions
    ------------------------------

    Original Message


  • 6.  RE: GL Exchange

    Posted 02-03-2019 20:59
      |   view attached
    Are you using the Alternate or Standard. If using Standard, the posting amount should be before the posting comment and no Reference Description.  Maybe swap H & I?​

    ------------------------------
    Nancy Hanson
    Blytheco LLC
    Eagan MN
    ------------------------------

    Original Message


Related Content