Sage 100

 View Only
  • 1.  Remember VI AddAmt

    Posted 10-12-2021 10:23
    I have a client that is trying to import multiple AR deposits. They have payment amount per invoice but not the payment total.  There was a operator of AddAmt (or something like that) you could accumulate the payment total.  How do we do that now?

    ------------------------------
    Larry Bradford
    Accounting Technology LLC Consultant and Owner
    Accounting Technology, LLC
    Fairfax VA
    703-913-3500
    ------------------------------


  • 2.  RE: Remember VI AddAmt

    Posted 10-12-2021 10:28
    I was disappointed when they removed that function several years ago.  Here's a few options:
    • Have the client add that additional data/column to your source file.
    • Have the users add it prior to importing.
    • Run the file through MS Access to generate the data, prior to importing.


    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: Remember VI AddAmt

    Posted 10-12-2021 10:37
    just fyi (from Oct '13 when I initially addressed this): https://community.90minds.com/communities/community-home/digestviewer/viewthread?GroupId=13&MID=433219&CommunityKey=4593d843-4557-43ff-ba4d-6240681ed696&tab=digestviewer

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 4.  RE: Remember VI AddAmt

    Posted 10-12-2021 13:47

    If it is the deposit amount you're missing and not the individual check amounts for each customer, then the I believe that the business logic will total up the deposit amount for you as long as you uncheck the setting in Accounts Receivable for "require deposit amount".

     

     

    Thanks

    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