From the Microsoft Dynamics 365 Finance & Operations Blogs: Security how-to; Mass deletion; Vendor payments; Project accounting

This week, on the Dynamics 365 Finance and Operations blog roundup:

• Security how-to: Only finance users are allowed to see cost prices in Dynamics 365 Finance and Operations
• Better approach for mass deletion in D365FO
• Automating your vendor payments in D365FO
• Project accounting in Dynamics 365 Finance & Operations and Supply Chain Management

Security how-to: Only finance users are allowed to see cost prices in Dynamics 365 Finance and Operations

Writing on his Dynamicspedia blog, André Arnaud de Calavon continued his "Security how-to" series.

In this particular post, he discussed how to secure a common scenario where cost amount fields should be hidden for the majority of users. He explained how to secure fields, form controls, and an easy way to apply this scenario to the users.

Arnaud de Calavon stated that there are a number of reasons that companies decided to hide cost amounts, including that workers would make the wrong assumptions about margin, and prevent them from leaking information about the cost of producing items.

In the post, Arnaud de Calavon described the steps necessary to only allow finance users to see cost prices.

Better approach for mass deletion in D365FO

On Sohaib Cheema's Microsoft Dynamics 365 Extensions blog, Cheema asked how a developer would delete records from a table.

Although writing the following query, "Delete from TableName Where Clause/Condition," might work in certain situations, it won't work in every case, according to Cheema.

Let’s suppose if you have 1 million records in a table and you have to delete 90% of those records. Would you still write the query in a similar way??