April 26, 2019

QuickFix-2: Export up to 1 million rows to Excel

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

April 17, 2019

How to set new admin user post DB refresh

Hi Folks,

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 have 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 your DEV box RDP.

Step 2: Go to below path K:\AosService\PackagesLocalDirectory\Bin (In most of the cases it will be same as mentioned if you didn’t found search for ‘PackagesLocalDirectory’ or ‘Packages’ shortcut in one of the drive.

Step 3: Open ‘AdminUserProvisioning’
















Step 4: Enter your email Id, which you want to give admin access to this environment and click on submit button.

















Step 5: Here you go.

















Cheers

Harry
Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta