Sage 100

 View Only

  • 1.  VI for Transaction JE -

    Posted 04-14-2022 14:47
    Having a frustrating time with a VI for a transaction JE.  Client wants to import ACH deposits instead of keying.  Over a week, they have hundreds of direct deposits to their account.  They currently do TJE's so that EACH deposit appears in BR, but but manual entry allows them to consolidate all the deposits into one JE.

    They send me a sample import file and I created an import that works exactly as desired.  100's of deposit, five TJE's for the week.  I use the VI NEXT function to detect a change date column (import file is sorted by date).  Perfect.

    Works great for me, not for them.  They get a TJE for every deposit.  What is different?  I am v2021, they are v2020.  I test in v2020.  Works for me. 

    I rekey the entire VI on their v2020 system.  Nope.

    They are v2020 PU 4, I am PU2.  Import file is tab delimited TXT.

    Thoughts?

    TIA

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------


  • 2.  RE: VI for Transaction JE -

    Posted 04-14-2022 15:00

    Two thoughts come to mind although I've not done specifically what you are doing.

     

    ·         Could it be batches turned on/off different in your system and theirs?

    ·         On their system open the journal entry with that source journal and click on Format button. Is that information different between your system and there?

     

     

     

    Don't miss out on the 2022 Basic Crystal Reports for Sage 100 online Training: View the details

    Don't miss out on the 2022 Intermediate Crystal Reports for Sage 100 online Training: View the details

     

     

    David Overholt

    DWD Technology Group, Inc.

    9921 Dupont Circle Drive West, Suite 300 | Fort Wayne, IN 46825

    260.423.2414 main

    800.232.8913 toll free

    sagesupport@dwdtechgroup.com

    www.dwdtechgroup.com

     






  • 3.  RE: VI for Transaction JE -

    Posted 04-14-2022 15:52
    Thanks, much appreciated.

    Batches are off in both.  In setting up the test TJE source code, I did verify the format panels matched.

    But after working with this for a couple hours now, the frustration level is growing and the eyes are bleary.  I will go back and look again.

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------

    Original Message


  • 4.  RE: VI for Transaction JE -

    Posted 04-14-2022 21:33
    Got it.  The temp field being used was being assigned based on "key assigns only".  I changed it to "line record".  All is well in Whoville.

    Thanks @David Overholt for getting me to refocus.
    ​

    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    ------------------------------

    Original Message


Related Content