Sage 100

 View Only

  • 1.  Importing in journal entries with Premium

    Posted 09-16-2020 16:59
    Customer is using an acct structure of 4-4-4 and they are on Premium. We have a VI job to import in journal entries on a daily basis but only allows for 9 characters. What's the secret with Premium???

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------


  • 2.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 17:13

    Checkbox on tab 1 of the VI job (not specific to Premium).


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



  • 3.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 17:19

    Check this option.

     

     

     

    Thanks

    David Speck

    TSS

    Sage | Sage 100 Certified Consultant

     




    Original Message


  • 4.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 17:37
    That was it!! Thanks much!!!

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 5.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 17:20
    I always bring in the account number field in the source file as a temp field (string). Then I make the account key a calculated field and put the temp field as the calculation.

    ------------------------------
    Billy Balser
    Sage 100 Consultant
    Blytheco LLC
    Atlanta GA
    9495839500
    ------------------------------



  • 6.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 17:39
    I tried that but with an extended account number, it didn't work. Good thought though!

    ------------------------------
    Therese Logeais, Technology Integrators
    ------------------------------

    Original Message


  • 7.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 18:16
    I  use a  calculation  method o f imp$[x] and replace the x with the column of field from the import file.

    Sent via my IPad

    Jim Woodhead | VP of Professional Services
    DSD Business Systems
    direct: 858.550.5900 ext. 125 | mobile: 619-990-3946



    Original Message


  • 8.  RE: Importing in journal entries with Premium

    Posted 09-16-2020 18:27
    Thumbs up for @Billy Balser suggestion.  Import to temp and calc the actual field has been working for me since v4.3.  Still runs like clockwork in v2020 ​

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

    Original Message


Related Content