Dynamics 365 for Finance and Operations is a three-tier architecture and it takes a significant amount of time for a database call to insert, update, and delete. The system provides us with some constructs that allow us to insert/update/delete more than one record into the database in a single trip, which reduces communication between the application and the database and it increases performance.
In this recipe, we will use these constructs and see how to do so effectively.
- Create a custom table
PacktCustomerInvoices
where we will be inserting records with the following fields:
Field: InvoiceAccount
Property | Value |
Name |
|
Label |
|
EDT |
|
Field: InvoiceId
Property | Value |
Name |
|
Label |
|
EDT |
|
Field: InvoiceAmount
Property | Value |
Name |
|
Label |
|
EDT |
|
Field: InvoiceQty
Property | Value |
Name |
|
Label |
|
EDT |
|
Field: CurrencySymbol
Property | Value |
Name |
|
Label... |