Sage 100

 View Only

  • 1.  I have a client that has 590 vendors that they nee

    Posted 01-13-2015 14:53
    I have a client that has 590 vendors that they need to file 1099's. About 100 use dba names and that is how their vendors records are configured. However, for 1099 reporting purposes, they have to report by name used to register their tax id. The only two ways we can find to do this is either 1) change the name on the vendor records, create and file the 1099's, then change the vendor names back, or 2) change the mail information in the Aatrix file prior to transmitting. The later is fraught with potential for missing a vendor. The second has to be done while the transmittal file is open as a review step. It can't be done over a period of days and reviewed prior to submitting. Anyone have any bright ideas?


  • 2.  RE: I have a client that has 590 vendors that they nee

    Posted 01-13-2015 16:05
    My users put the ""registered"" name in the vendor name field and ""dba ..."" in the address1 field. IE: Joe Blow is the vendor name and dba Joe's Snow Removal in the address line 1 field in the case where the id number is a social security number.


  • 3.  RE: I have a client that has 590 vendors that they nee

    Posted 01-28-2020 22:04
    Not seeing any DBA fields in the AP vendor master yet.  Does anyone know if Aatrix/Sage has ANY way of handling this?  Can a UDF be mapped to Aatrix?  Is @Mary Jo Krueger way the way?
    ​

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

    Original Message


  • 4.  RE: I have a client that has 590 vendors that they nee

    Posted 01-29-2020 10:59
    In addition to the solution above, I found another work around years ago at one client site with a large number of customers with multiple addresses.  Initially they weren't using the Remit to Address area, I think mainly because Sage thought it a good idea to hide that under a button.  Back then I found if we enter the 1099 info in the Remit To area and we have the option selected to print the remit address selected in check printing, it would print the remit address info on the 1099s.  They don't typically choose the option to print remit to info when doing check printing.  I still use it to this day for that particular client.  However, just this year tried to get it to work on another installation but couldn't get it to work.  I don't remember doing anything else back then.  I just tried with ABC data and couldn't get it working there either.  You might want to try playing around with that and see if you can get it to work for you.

    ------------------------------
    Mary Jo Krueger
    Senior Software Consultant
    CLA (CliftonLarsonAllen LLP)
    Appleton WI
    920-996-1176
    ------------------------------

    Original Message


Related Content