How to Modify the behavior in the Price List when using the Customer’s Price Group

A short time ago, I had a support case where the customer showed that the Price List was not working correctly.

After a couple of hours, we were able to identify that the problem was that the Sales Order had a “Bill-to Customer No.” different from the “Sell-to Customer No.“, and the Price Lists are triggered with the “Bill-To Customer No.” only.

Source : Ivan Singleton
Read more…

How to group data in AL? Best practicies. Performance review.

Data manipulation is one of the most trivial things for Navision/Business Central Developer. We are constantly working with data in tables, adding, deleting, modifying, and so on. Today we’re going to discuss data grouping. What does it mean to group data? How do you do it in AL? What is the best and fastest way to do it? I hope we can find answers to all these questions.

Source : Volodymyr Dvernytskyi
Read more…

Grouping records using a List

I don’t know why, but grouping records in in C/AL in the past had always been a difficult topic to understand for new programmers during my development courses.

In C/AL the best method was using temporary tables, as in the example below, in which I group the Sales Orders by Customer and then I make a loop over the customers I found to make something.

Source : Marco Ferrari
Read more…