HOW TO change data for all Companies?
You have different ways to complete this task, the choice depends from how many lines or Companies you have. In the following steps I will explain you how to change data for all Companies in C/SIDE using the CHANGECOMPANY Function (Record):
- Create a new ProcessingOnly Report using with the System Table 2000000006 – Company as Data Source of a DataItem.
- Declare a C/AL Globals Variable of DataType Record with the table that you need.
- Insert the following code in the OnAfterGetRecord trigger
GLSetup.CHANGECOMPANY(Name); GLSetup.MODIFYALL("Allow Posting From", 010114D); GLSetup.MODIFYALL("Allow Posting To", 310114D);
Here find another reading suggestion, this time in T-SQL: HOW TO run SQL query for multiple companies in NAV database
Did my HOW TO help you? Leave a reply.