Sage 100

 View Only

  • 1.  GL Journal Import with an automatic offsetting entry to a clearing account

    Posted 12-05-2019 16:25
    Is there a way to setup a Visual Integrator import for a Journal Entry with a csv of only debits and have the import create an offsetting credit to a specific account?

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------


  • 2.  RE: GL Journal Import with an automatic offsetting entry to a clearing account

    Posted 12-05-2019 16:31
    Use Transaction Journal for that...

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



  • 3.  RE: GL Journal Import with an automatic offsetting entry to a clearing account

    Posted 12-09-2019 19:28
    I did think of that. Testing it now. Thanks @Beth Bowers​​

    ------------------------------
    Greg Stiles
    S & W Microsystems
    Torrance CA
    310.787.1010
    ------------------------------

    Original Message


  • 4.  RE: GL Journal Import with an automatic offsetting entry to a clearing account

    Posted 12-05-2019 16:34
    At one point, Vi had a running calculation function.  If this still exists (ahem @Beth Bowers) perhaps you can create some sort of logic to detect the end of the file, then create the final record using this running calc function.  Or write some sort of script to calculate it for you and place it in the import file.  Some some wild A** thoughts.  No clue if it can be done. ​

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



Related Content