The Export to Excel feature can now be configured to allow users to export up to 1 million rows from a grid in Finance and Operations, a substantial increase from the previous 10,000-row limit. By default, the export limit is set to 50,000 rows, but through the Client performance options page, system administrators can adjust the export limit as high as 1 million rows.
Check below link
https://docs.microsoft.com/en-us/business-applications-release-notes/october18/dynamics365-finance-operations/export-more-row
-Harry
Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta
Yet another blog for Dynamics 365 for Finance and Operations. This blog primarily targets technical readers. I will be sharing my experience with Dynamics AX using code snippets, errors, and solutions, Tips, and tricks. Any feedback regarding a post or overall site are always welcome.
April 26, 2019
April 17, 2019
[Updated] How to set new admin user post DB refresh
[Last updated on Feb 24, 2022]
Many times we need to get actual data for our development and to get such data in your dev box you need to restore data from either UAT/QA/SIT or any environment which has such data.
Once you complete DB restore in your target system, here issues come, you don't have admin access or maybe SysUser access to this new DB.
Microsoft provides a script to update your email id as admin in your dev box. Follow the below steps to achieve this.
Step 1: Go to your DEV box RDP.
Step 2: Go to below path K:\AosService\PackagesLocalDirectory\Bin (In most cases it will be the same as mentioned if you didn’t find search for ‘PackagesLocalDirectory’ or ‘Packages’ shortcut in one of the drives.
Step 3: Open ‘AdminUserProvisioning’
Step 4: Enter your email Id, which you want to give admin access to this environment, and click on the submit button.
Step 5: Here you go.
the other option is using scripts,
Step1: Run below script on old DataBase
select SID, NETWORKDOMAIN, NETWORKALIAS, * from UserInfo where Id = ‘Admin’
make a note of all these values.
Step 2: Run below script on new Database
update userinfo
set
networkdomain = ‘YourDomainName’,
networkalias = ‘Administrator’,
SID = ‘SID’
where ID =
‘Admin’
Harry
Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta