Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

SmartConnect Map

  • 1.  SmartConnect Map

    SILVER CONTRIBUTOR
    Posted 06-13-2018 08:37 AM
    Does anyone already have a map created to update ABC codes using SmartConnect?

    Thanks for your help.


    ------------------------------
    Mary Kay Merkel
    Synthetic Genomics, Inc.
    La Jolla CA
    ------------------------------


  • 2.  RE: SmartConnect Map

    TOP CONTRIBUTOR
    Posted 06-14-2018 03:02 PM
    @Mary Kay Merkel
    Check out the templates available on the eOne website
    https://www.eonesolutions.com/connector/dynamics-gp-sample-integrations-all-in-one/?type=template&products=747

    This one includes a bunch of different GP windows, but you should be able to use the Item template and just update the ABC code.
    Thanks
    Windi​​

    ------------------------------
    Windi Epperson [Designation]
    President/GP Senior Consultant
    Advanced Integrators, Inc.
    Norman OK
    405-946-1774 Ext 102
    ------------------------------



  • 3.  RE: SmartConnect Map

    Posted 06-14-2018 04:17 PM
    I have a SmartConnect map that either updates or creates the ABC code from another system. If you map to the Inventory Group and then the Item Node, choose Create/update item for your map. Then ABC code is a field to map to. Map at least the Item number and the ABC code and check "Update Existing". You need to use the integers here as GP does not recognize "A", "B", "or "C: at the SQL level. The translations are: 1 – (None), 2 – A, 3 – B, 4 – C. So if you needed to map an item to "A", you would need the column to read '2' in your source document.

    Hope that helps!

    ------------------------------
    Audrey Forrest
    Senior Accountant and Business Analyst
    Chihuly, Inc.
    Seattle WA
    ------------------------------