Skip to main content

Notifications

Microsoft Dynamics GP forum
Answered

SOP Integration - drop ship checkbox

Posted on by 1,439
We are working on a SOP Invoice integration using SmartConnect which in turn uses the eConnect objects.  The integration works fine, however we are now trying to mark the drop ship checkbox via the integration and unable to get it to stick.  There is a list option that works, however we need to set the field conditionally and are trying to use a formula that sets the field to either 1 or 0 based on the required condition.  
 
Has anyone had issues with marking the drop ship checkbox via eConnect, SmartConnect or any other tool that uses the eConnect objects?  Please advise.  Look forward to a reply.  This is GP18.5
 
JG
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,827 on at
    SOP Integration - drop ship checkbox
    Sometimes the yes/no fields in GP are hit or miss with eConnect and SmartConnect. Glad you figured it out!
     
    Joe
  • Verified answer
    JGarcia123 Profile Picture
    JGarcia123 1,439 on at
    SOP Integration - drop ship checkbox
    We resolved this.  The SmartConnect GP adapter was using "TRUE" and "FALSE" as list options which worked fine within the adapter but not within formula.  We then switched to the database values of 1 or 0, but that also didn't work.  We then went with a string value of "1" or "0", and the formula finally functioned.

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,186 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,996 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans