Sage 100

 View Only

  • 1.  VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-23-2025 20:00

    Client has GL options and security role to allow users to create new GL accounts when segments are valid.  Works perfectly in the General Journal Entry UI but fails on import, not allowing the creation of the accounts.  They primarily use imports for their entries and would like to have this capability.  Do I need perform logic on there to make this work?  Is it even possible? @Alnoor Cassim?



    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------


  • 2.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-23-2025 21:29

    What's the table name in VI you are using to import the accounts?



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



  • 3.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-23-2025 23:38

    Haven't specifically checked but seems likely you can do this with scripting even. In V/I on the General Journal Header import when the AccountKey gets assigned based on what you set up in the Data tab, you could have a Post-Validate of AccountKey script fire off right at that point in the import to:

    • Check if Left(oSession.StartProgram,4) = "VIWI" to limit the script to run only on imports
    • Connect to GL_Account_Svc to use the CheckSegments(ffa$) function (ffa=fully formatted acct)
    • If segments are valid (retVal = 1), connect o GL_Account_bus to SetKey(ffa$) as this will also set AccountKey, Account, & RawAccount fields.
    • Do a SetValue for the AccountType & MainAccountCode & everything else you need for GL_Account_bus then Write

    Something like that.



    ------------------------------
    Alnoor Cassim
    Accounting Systems, Inc. (ASI)
    ------------------------------



  • 4.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-24-2025 14:40

    Thank you Alnoor.



    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 5.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-24-2025 09:56

    Start with an import to GL_Account, skip existing records, chain to the job for importing the GJE...



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



  • 6.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-24-2025 14:41

    Thanks Kevin.  I've offered this option to the client already, they were just hoping to have the imports work the same as the data entry screens. 



    ------------------------------
    Janna Crowther
    RKL eSolutions, LLC
    ------------------------------

    Original Message


  • 7.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-24-2025 16:40

    I don't think a script would give you any indication of what accounts need to be added manually... but importing directly to GL_Account first will, with job results presented before the GJE import.  The extra step gives a clearer indication that something is wrong.



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

    Original Message


  • 8.  RE: VI Import GL_JournalEntryHeader - create new on the fly accounts

    Posted 06-24-2025 14:54

    Should the starting point be GL_MainAccount?



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

    Original Message


Related Content