GP Power Tools Form Control is a “No Code/Low Code” customization tool for Microsoft Dynamics GP. It can be used to solve many requirements without any coding.

Here is a real-life example showing how you can quickly use Form Control to prevent entering Shipment/Invoices on the Receivings Transaction Entry window.

In Microsoft Dynamics GP, the Receivings Transaction Entry window has 3 types of transactions available: Shipment, Shipment/Invoice and In-Transit Inventory. In many businesses, this window is used by the warehouse team to receive inventory that comes in. However, the warehouse team are usually not responsible for invoicing for the inventory. This is usually handled by the accounts payable team using the Purchasing Invoice Entry window as a separate step.

A very common business requirement is to grant the warehouse team access to the Receivings Transaction Entry window but not allow them to use the Shipment/Invoice type.

This requirement can be created with the Form Control module in a few minutes.

Validate Receivings Transaction Type

The FORM CONTROL RECEIVING Form Control ID is limited by the Base Settings Resource Filter to exactly the POP_Receiving_Entry form in the core dictionary (0).

The Validate Field Value rule is limited to exactly the Pop Type field.

The Expression specifies that the value must not be 2 using the text “!2” where the exclamation mark means “not”. The Warning Message is displayed when the validation fails and the previous value for the field is restored.

Note: The rule in the Expression field could also be specified as “1,3” signifying that a value of 1 or 3 is allowed.

Click the Info button to the right of the Expression field to display the help window shown above.

Downloading and Installing

Download the example settings, import using the Project Setup window (without any project showing, select the path to the xml file and click Import):

• GP Power Tools Settings Form Control Receiving.dbg.zip

The Form Controls will be active immediately when the affected windows are next opened.

More Information

For an introduction series for Form Control with step-by-step instructions see:

• #GPPT Form Control Introduction – Making Maintenance windows Read Only

For more information see:

• GP Power Tools Portal: https://winthropdc.com/GPPT
• GP Power Tools Samples: https://winthropdc.com/GPPT/Samples
• GP Power Tools Videos: https://winthropdc.com/GPPT/Videos

Hope you find this example useful.

David

This article was originally posted on https://www.winthropdc.com/blog.