DataTransfer should be able to create SQL query from AL code
DataTransfer should be able to create SQL query from AL code. Business Central already does a lot of this behind the scenes for all normal data operations so similar approach could be used for data migration as well.
Here is pseudo code how the feature would be used. Explanati...
Migrate/Copy One Company from one Cloud environment to Another
As Microsoft has made it posible to Migrate/Transfer one company from OnPrem to Cloud, Why are the risk bigger copying from Cloud to Cloud. The Migrate from OnPrem does not delete the source, so it can be done with proper "Prepare", "Testing", and "GoLive",
I see especially two...
Set up Data Exch. table in retention policy
Add the data exch. table as allowed table in retention policy.
I talked with MS support, and there is no built in way to remove old entries automatically from this table.
Just add this line of code:
RetenPolAllowedTables.AddAllowedTable(Database::"Data Exch.")
Migrating data into existing production enviroment
We've had several examples of customers where it would be handy to be able to migrate data into an existing production enviroment.
Examples:
- Customer aquires another company running older NAV or BC
- Customer has made a "clean start" with new Chart of Accounts...
STATUS DETAILSNeeds Votes
Enable Invoke-NAVApplicationDatabaseConversion to run from Visual Studio Code powershell ADD-ON
Summary :
When Running
Invoke-NAVApplicationDatabaseConversion from within Powershell Terminal in Visual studio code raises an error apperantly related to Telemetry.
WARNING: UnhandledErrorMessage
Invoke-NAVApplicationDatabaseCo...
Extend Excel Buffer field and function variables from 250 to 2048 characters
Please increase the size of the related variables and field "Cell Value as Text" from 250 to 2048.
The 250 character limit is inherited from the old NAV, but it can be easily extended to 2048 in business c...
Select No. Series Code while importing data through Configuration Package
In the current version of Business Central release 23.2, if we wish to import master data or transactional data en-masse, we have to assign primary key (Code, Number) in the upload file manually. I tried assigning just the No. Series by exporting the relevant field in the excel template and ke...
Exisiting Configuration Packages and new fields
Many customers create Configuration Packages they use for certain tasks.
But, if a new field is created in a table, that is part of One or more Configuration Packages, this new field will automatically be inserted in all Configuration Packages containing this table.
Th...
Show all errors for Configuration Packages in one place rather than one at a time
To see the errors after importing, users have to click on the number of errors link to see each document that was imported that contains one or more errors. To see the errors, the user has to highlight each document individually and click on the Show Errors button. This is very time consumin...
Mapping
I can export my clients from my current CRM and from my current invoicing platform into excel and CSV. You should create a mapping option for me to map the columns in my current spreadsheets to your fields rather than forcing me copy/paste multiple rows of data, thousands of lines, just one c...