Sage 100

 View Only

  • 1.  VI import for General Journal Entry

    Posted 05-31-2019 12:17
    Does anyone have a VI job they can share (or advice)?  In this case, I'm not sure if the file the client will receive will have the DR and CR amounts in a single field (or if I can request the layout where they are in separate columns).  I need help building a job if the file will only have one Amount field.

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------


  • 2.  RE: VI import for General Journal Entry

    Posted 05-31-2019 12:20
    I believe a negative DR in GJE should be automatically flipped to a positive CR without special handling.

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



  • 3.  RE: VI import for General Journal Entry

    Posted 05-31-2019 12:43
    I prefer single column imports.  Easier to balance.  Back in the day, I would condition the import field to populate the debit if it was greater than zero and populate the credit field if it was less than zero (also use an ABS() (Absolute value) and to skip the zero line.  Kevin probably has the more modern idea.

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

    Original Message


  • 4.  RE: VI import for General Journal Entry

    Posted 05-31-2019 12:46
    And Kevin is correct!  I had envisioned having to do something with temp fields & what Jeff said.  :-)

    Thanks!

    ------------------------------
    Barbara Goldstein
    Sr. Consultant
    DSD Business Systems
    San Jose CA
    800.627.9032 x221
    ------------------------------

    Original Message


Related Content