Enhancing insert, update, and delete operations

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.

How to do it...

1. Create a custom table PacktCustomerInvoices where we will be inserting records with the following fields:

Field: InvoiceAccount

Property	Value
Name	InvoiceAccount
Label	Invoice account
EDT	AccountNum

 

Field: InvoiceId

Property	Value
Name	InvoiceId
Label	Invoice id
EDT	DocumentNum

 

Field: InvoiceAmount

Property	Value
Name	InvoiceAmount
Label	Invoice amount
EDT	Amount

 

Field: InvoiceQty

Property	Value
Name	InvoiceQty
Label	Invoice qty
EDT	Qty

 

Field: CurrencySymbol

Property	Value
Name	CurrencySymbol
Label...