Open Forum

Expand all | Collapse all

Smartconnect Vendors - 1099 Address Code

  • 1.  Smartconnect Vendors - 1099 Address Code

    Posted 9 days ago
    Hello,

    I'm trying to use SmartConnect to import new vendors, and I don't see an area in the map for the 1099 Address Code (VADCD1099).
    Is this field unavailable through eConnect?
    How do people who use SmartConnect typically fill out this field?

    Thanks,

    ------------------------------
    Miriam Retter
    Senior Financial Analyst
    The Harry & Jeanette Weinberg Foundation
    Owings Mills MD
    ------------------------------
    Conference-GPUG_200x200


  • 2.  RE: Smartconnect Vendors - 1099 Address Code

    GOLD CONTRIBUTOR
    Posted 8 days ago
    Hi Miriam,
    1099 Address Code (VADCD1099) is not part of the econnect Schema that is why you are not seeing it SmartConnect.

    What you could do is create an update statement, on the After Document task of smartconnect to Update the PM00200 for that field.


    ------------------------------
    Gerald Buenafe
    Owner/Consultant
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Conference-GPUG_200x200


  • 3.  RE: Smartconnect Vendors - 1099 Address Code

    Posted 8 days ago
    Thank you.  I will look into that.

    ------------------------------
    Miriam Retter
    Senior Financial Analyst
    The Harry & Jeanette Weinberg Foundation
    Owings Mills MD
    ------------------------------

    Conference-GPUG_200x200


  • 4.  RE: Smartconnect Vendors - 1099 Address Code

    TOP CONTRIBUTOR
    Posted 8 days ago
    Miriam,

    Gerald is correct in that eConnect does not include the 1099 Address Code field and so you will need to either update it manually in GP or with a SQL script.

    With SmartConnect, you can create a Document Success Task to run the SQL command to update that field so that you don't have to remember to run it if you like.

    Let us know if you have any questions on that.

    ------------------------------
    Nicole Albertson
    Product Manager
    eOne Solutions
    ------------------------------

    Conference-GPUG_200x200


If you've found this thread useful, dive deeper into User Group community content by role