Dynamics 365 Business Central | Copying Fields with Simple Object Designer
Our previous article on Simple Object Designer (SOD) as developed by Erik Hougaard, describes an overview of SOD’s intuitive user interface for completely customizing Microsoft Dynamics 365 Business Central.
SOD allows the end user to add fields to screens, reports, and other objects without using Microsoft Application Language (AL) programming.
As expressed in those articles, instead of using AL for Business Central, simply rely on SOD.
Here, we’ll study SOD’s ability to copy fields from one screen to another. Doing so calls for using SOD FlowFields.
Copying Unit Price
Business Central’s “Sales Prices” screen creates specialized pricing in Business Central, and this screen includes the “Unit Price” field:
Users allowed access to Item Card but not Sales Prices may want to see the devised “Unit Price” field displayed on Item Card, especially when pricing can change on a dime.
By using SOD FlowFields, Unit Price is copied onto the face of the “Item Card” screen as Unit_Price:
Choosing Create new fields on existing tables in the SOD screen allows us to add fields:
After creating our new “Unit_Price” field, we’ll click Placed on pages as seen on the right-hand side of the “Create Fields” screen. This places the field after the “Profit %” field on Item Card:
Returning to Create Fields, we’ll click the “Field Settings” button:
Next, in addition to selecting FlowField within the “Type” drop-down list, we’ll update the sections called FlowField and FlowField Filters:
In FlowField, we choose the “Sales Price” table and its “Unit Price” field.
The one row in FlowField Filters simply shows that we have joined to the Sales Price table based on the “No.” field (i.e., the “Item Number” field).
Going back to SOD’s main screen and clicking and the “Yes” button allows us to see Unit_Price on the “Item Card” screen:
For more information about Simple Object Designer, please reference our other blog by clicking here. For any other questions about how to maximize your Dynamics investment, please reach out to us at Sales@BondConsultingServices.com or you can schedule a free consultation by clicking here. Alternatively, you can always visit our YouTube channel for helpful product videos and recorded webinars.