HELP  ARTICLE

How to set a checkbox field using Extender Enterprise


I’m trying to check the “Allow SO Commitments” field in Purchase Order Entry using an Extender Enterprise Set Field Values action.  However I’ve tried setting the value to 1 or TRUE or “TRUE”, I always get the error:

Type incompatibility ‘Allow SO Commitments’.

How can I set this field to be checked? 



From a Dexterity perspective, Checkboxes and Boolean fields would be set to true or false.
Currently in Extender, there isn’t a way using the Set Field Values window as it doesn’t convert the constant value entered into the Boolean value required.
However, this is possible to do using the “Run Dynamics GP script” action since we can set the value via Dexterity sanScript.

The code used to do this is:

{Check to make sure that the field is not disabled}
if Field_GetBooleanProperty(‘Allow SO Commitments’ of window POP_PO_Entry
  of form POP_PO_Entry, FIELD_PROP_DISABLED) = false then
 
   {Check to see if already marked, if so then don’t need to re-mark it again}
 if not(‘Allow SO Commitments’ of window POP_PO_Entry
   of form POP_PO_Entry) then
 
  {Wasn’t marked previously. Mark it}
  ‘Allow SO Commitments’ of window POP_PO_Entry
   of form POP_PO_Entry = true;
 
  {and run the field change script}
  run script ‘Allow SO Commitments’ of window POP_PO_Entry
   of form POP_PO_Entry;
 end if;
end if;

RECENT POSTS


Could not save record. Deleted object would be re-saved by cascade
Error [HY000] [Microsoft] [ODBC Excel Driver] Reserved error (-5016); there is no message for this error.
HTTP Error 500.19 - Internal Server Error when browsing the SmartConnect WCF web service.
HTTP Error 404.3 - Not Found when attempting to browse the SmartConnect WCF web service.
SmartPost stops posting due to Microsoft Dynamics GP change date dialog

POPULAR POSTS


Manufacturing Serial Trace SmartList Builder Template
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP.eConnect/EntityOperations that could accept the message
The server process could not be started because the configured identity is incorrect.
Connection could not be validated when using Excel data source

CATEGORIES

ARCHIVES

open all | close all

TAGS

#fargo 2017 CRM Demo Dynamics Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News eOne Spotlight ERP Events Excel Excel Report Builder Extender GP GPUG integration integration manager Meet the Team Microsoft Microsoft dynamics crm Microsoft Dynamics GP ODBC Office Relationships partners release SalesForce SalesForce.com scripting SmartConnect SmartList SmartList Builder SmartList Designer SmartView SQL Support Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.