In this blog we will discuss about creating Auto Sales Document from the Data present in the Excel Sheet. We will create 2.6 Process as mentioned in the Customer Requirement for AL Development.
Tag Archives: Create
Create recurring sales invoices automatically
A common issue is to generate invoices per month for items and services automatically, which are being sold periodically.
You can use report “Create recurring Sales Invoice” to generate sales invoices with the needed lines manually. The parameters “Order Date” and “Posting Date” in the request page are mandatory. So, the report cannot be used to generate invoices automatically without setting the mandatory parameters.
Creating new instances of Business Central web servers using PowerShell
Although you can use the Business Central Setup to install the Business Central Web Server components and create a single web server instance in IIS for client connection, there may be scenarios when you want to set up multiple instances.
For example, you could set up a separate Business Central Web Server instance for the different companies of a business, for this scenario, you can use the Business Central Web Server PowerShell cmdlets.
Source : Roberto Stefanetti NAV & Business Central Blog
Read more…
Use Excel to create a permission set
When developing in AL creating permission sets isn’t the must fun thing to do…. I thought it must be possible to find a better tool than editing the xml file manually and found some inspiration here. Based on that I created this excel sheet that you can use to create a permission set xml file.
More Details On Creating Tables In Power BI/Power Query M Code Using #table()
About two years ago I wrote a blog post describing how the #table M function can be used to generate tables, but in that post I only covered the functionality I used regularly – namely using #table with a list of column names or a table type in the first parameter. However there two other variations on #table that I have used recently that I thought were worth pointing out.
Procedure to create custom folders in a specific location using C/AL code in Dynamics NAV
In this article I will be giving the procedure to create custom folders according to the posting date of the posted sales invoices on the click of an action.
Create flow to create or update data in Dynamics NAV
In this blog post, I will show how you can create a flow which will create data (Items) in Dynamics NAV 2018.
To create the connection between Flow and Dynamics NAV 2018 I will use Microsoft Dynamics NAV connector which I show how to configure in this blog post.