Public preview for Business central wave 2 (BC21) is available now
You can create preview version from SAAS version.
You will get more information about major updates from following
Stay tuned for more updates and lets start explore new features from new version.
Cheers…
Today we will see how we can data from business central table using new data type Text Builder.
To check how this data type work build small program as below which pick up data from customer table and export the data in text file.
pageextension 50101 CustomerMasterExtension extends "Customer List"
{
actions
{
addlast(General)
{
action(DataExport)
{
Caption='Data Export to Text';
ApplicationArea=All;
PromotedCategory=Process;
Promoted=true;
Image=ExportDatabase;
trigger OnAction()
var
CustomerMaster :Record Customer;
Tempblob:Codeunit "Temp Blob";
TextFileBuilder :TextBuilder;
FileName:Text;
InStreamData:InStream;
OutStreamData:OutStream;
begin
FileName:='CustomerData.Txt';
TextFileBuilder.AppendLine('Customer No'+','+'Customer Name'+','+'Balance');
If CustomerMaster.FindSet() then repeat
CustomerMaster.SetAutoCalcFields(CustomerMaster.Balance);
TextFileBuilder.AppendLine(CustomerMaster."No."+','+CustomerMaster.Name+','+Format(CustomerMaster.Balance));
until CustomerMaster.Next()=0;
Tempblob.CreateOutStream(OutStreamData);
OutStreamData.WriteText(TextFileBuilder.ToText());
Tempblob.CreateInStream(InStreamData);
DownloadFromStream(InStreamData,'','','',FileName);
end;
}
}
}
}
If you look at the above code it is taking required data from customer table and export the data in text file as below.
To get more insight of data type have a look at MS documentation from below link
Hope this will help you.
Stay tuned for more.
Recently one of my customer asked me to add few more fields on primary key and I was looking at the customer like he asked something which is daunting task to be done with business central as everybody aware of that we can not change the primary key fields when table is already having data as while deploying the app it throws an error as below
Even I tried using Force sync also but it is still failing to deploy the app as this is breaking change for the app.
Now question is how to do this and overcome from such situation as your customer is behind you to do that.
To make it work we need to use ObsoleteState and ObsoleteReason that means we need to make your table obsolete and create a new table with new primary key and change the references in all those object where the object is referred.
To make the table obsolete mention the property as below.
Obsolete property value
| Value | Description |
| No | Not obsolete. This is the normal/default setting. |
| Pending | Will become obsolete in a future version. |
| Removed | Has been made obsolete. |
After making above table obsolete created new table with the new primary key.
Next point is how to transfer data in the new table .
To transfer data from obsolete table to new table used Installed code unit . Additionally you can use temporary table to update data from old table to new table.
If you would like to learn more about ObsoleteState Property then visit here.
Hope this will help you.
Stay tuned for more updates.
As we are gearing up for new release of business central and already the buzz is started for new version . Here I will list few upcoming features which I am looking forward in new version.
In-Client Performance Profiler
Demo tool and demo data for manufacturing scenarios
Users can export report datasets to XML
Introduce copy link option in the Share menu
Guided tour that helps users find settings and personalization tools
Support for rich text in teaching tips and tours
New capabilities for financial reporting with account schedules
Use Excel to design layouts for reports
With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers.
One of new feature added in business central V19 for role explorer where in one can explore all the reports and other screens.
There is new button added on Business Central V19 as below
Once you click on this button all the modules will be displayed irrespective of assign role center.
There are few more options once you click on Explore More roles where in you can filter for reports or administration pages.
With this new features you can find all the reports or administration pages at one place efficiently.
Hope this will help to find the reports.
Stay tuned for more.
With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers.
Now from business central V19 onwards we can select location code for non-inventory items and it was having issue till version 18
Let See how to create Non Inventory Items
Go to Item Card
While creating Item select type as Non-Inventory. If the item is noninventory then Inventory Posting Group is disabled.
Let see how it works in Transaction.
Once you post this transaction then it will store the cost in Cost Amount(Non-Invtbl).
All these location will be copied to ledger entries.
Hopefully this will help you.
Stay tuned for more.
Do you remember this post of mine where in I mention Microsoft hosting an event for launch of Business Central Wave 2 2021.
Yesterday this event gone live and all the recordings are available to view till 31st December 2021.As like the most event this event is not live and all sessions are recorded and there will be no chat room or live Q & A sessions.
You can view the session by registering here  Join the Event and it will redirect you to following screen to register
Just register yourself and get the more details insight of features implemented in business central wave 2 2021 by going through above sessions.
I just gone through few session and found it very well explained and looking forward for all other sessions.
Stay tuned for more..
Yesterday we were installing PTE app on production environment and it throw an error as below.
We are juggled by seeing this message and thinking why it is showing an error message when we are uploading extension by using administrator login which is global administrator.
To overcome this error there is new permission set has been introduced in business central wave 1 2021
EXTEND. MGT. – ADMIN
You need to assign the above permission to install the app as below.
Hopefully this will help
Stay tuned for more.
With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers.
Can we change App name and/ or publisher name to meet marketing branding ? If you ask me till V18 it was not possible to change that and in V19 it is possible.
Lets see how it works.
Here is my app.json file
Publish the app
Changed the app.json
Hopefully this will help to give branding name to your app even after published.
Stay tuned for more.
With the release of Business Central Wave 2 2021 aka BCV19 lot of new features has been added to make life easier of developer and/or customers.
There is new feature added in business central to control address where country/region code is used.
New option added on general ledger setup to control country/region code that means if this field is checked and if user change the country/region code then it will clear the values from related fields like city ,state and zip code.
Navigate to General Ledger Setup.
If the option is not ticked then following is behavior
If the option ins general ledger setup is ticked then it will not clear the address fields.
Hopefully it will help in controlling the address.
Stay tuned for more.
Ammolh Saallvi Blog 