D365 Finance and Operations Archives - Page 23 of 25 - - Page 23

Category Archives: D365 Finance and Operations

Open URL in Web browser from D3fO using X++

In this blog article, we will see how we can open a URL in web browser from D3fO using X++ code. It is achieved using Browser class which extends System Class xBrowser having only method navigate(). It has three parameters from which only first is mandatory: downloadURL (string) – URL you want to browse. openInNewTab (Boolean) – It is used to specify url should be open in same tab or new tab showExitWarning (Boolean) – Prompt a dialog to exit the current page. Create a new Class: class CFSBrowseURL { } Call URL: public static void main(Args _args) { Browser browser = new Browser(); browser.navigate(‘www.cloudfronts.com’, true, false); } So, this will open URL within a new tab in browser using X++. Let me know your reviews and queries. I will soon come up with more articles, as I further explore D365 Operations.

Share Story :

Deploy Package in Dynamics 365 Operations Environment

As an entrepreneur, if you want to streamline your operations and finance departments, you should go for an ERP solution. Countless companies are offering ERP or Enterprise Resource Planning solutions or software. Dynamics 365 for finance and operations, however, is one of the best ERP solutions that you can find in the market today. One of the key reasons why a lot of companies are using this software is that it is easy to install, configure, and to use. You can scale your business when you use ERP solutions like Dynamics 365. A lot of resources are available online that will help your employees become smart and efficient.  Deploying this software is easy. Here is some information for you In this blog article, we will see how we can deploy the package in Dynamics 365 Operations. This Package can be any latest update, hotfix or deployment package you have created. Prerequisites: LCS login VM Instance Steps: 1. Download, Extract and Unblock Package 2. Update topology configuration data 3. Generate a runbook from the topology 4. Execute runbook Download, Extract and Unblock Package a. Login to LCS and download the Zip file of Deployable Package. b. After downloading, go to downloaded Zip file properties and select unblock. c. Extract the Zip file to a non–user folder. Update topology configuration data a. Go to extracted folder and open the file “DefaultTopologyData.xml” b. Populate the file with VM name. i. Go to This PC -> Properties. Find the name of the machine. ii. Update the VM name with the machine name in the file. c. Populate the file with installed components i. Open a command prompt as an administrator. ii. Run the command from extracted folder path to see a list of all installed components on the computer. iii. Update the file with a list of components. 3. Generate a runbook from the topology a. Run the command to generate a runbook. AXUpdateInstaller.exe generate -runbookid=[runbookID] -topologyfile=[topologyFile] -servicemodelfile=[serviceModelFile] -runbookfile=[runbookFile] Example: b. Runbook will contain instructions in sequential steps to deploy the package. 4. Execute Runbook a. Import the runbook. AXUpdateInstaller.exe import -runbookfile=[runbookFile] Example: b. Verify the runbook. c. Execute the runbook. AXUpdateInstaller.exe execute -runbookid=[runbookID] Example: d. Export the runbook. Export the runbook for future reference, you can use it to refer the steps, time to execute each step and logs for each step. UpdateInstaller.exe export -runbookid=[runbookID] -runbookfile=[runbookFile] Example:

Share Story :

Selecting Multiple products for Sales in D365 for operations

Dynamics 365 for finance and operations is an ERP system built and designed to match your business needs in this modern day business scenario. Elements are currently as much a business system as it is innovation deliverable, some portion of a bigger biological system where data pulled from unique channels, (for example, social, IoT, and Office) is caught, investigated, and spread so as to help explicit business objectives. Make planning simpler by giving your spending chiefs simple to-utilize apparatuses. A wizard causes them to make spending plan worksheet formats for Microsoft Excel.  This cloud-based ERP framework gives the pertinent data you have to convey vital, information-driven bits of knowledge to key divisions. Additional quick monetary bits of knowledge drive corporate procedure and development, declining obligation through effective assortment of the board. Generally, users spend lot of time in selecting each product and their variants for sales in Sales order. Dynamics 365 for operations gives option to select the product by category. Following is the process to select multiple products and their variants in a quick way: 1. Create a new Sales Order 2. Click on Add products in Sales Order Line 3.  A new form will open which is divided in to three parts Select category – To select the respective category Available Products – It shows all the products available in the selected category Add Selected products- The products which are selected for the Sales order 4.  Once the category is selected, select the product and click on Add variants to select the variants for that product. 5.  A new form will open listing all the variants for that product. The user can select all the variants by checking on Select all or can select specific variants and can put quantity. 6.  On clicking OK , all the products selected with their variants will come in the sales line. Conclusion : In this way the user can save lot of time in creating Sales order having multiple lines.

Share Story :

Purchase voucher effects for stocked item (Dynamics 365 for Operations)

Dynamics 365 for finance and operations is one of the best ERP solutions that you find in the market. ERP is an acronym for Enterprise Resource Planning. It is a software that helps small and medium-sized companies to organize their work and to scale up high.  It is quite popular because there it has got some excellent features. For example, when you deploy this ERP software in your company. You get to enjoy things such as these: Feature Management Extensibility Enhancements An Option to Cancel Batch Job that is Running and so forth On top of it, it is quite affordable when you compare with the other Softwares that you find. Getting a solution to a problem is easy, as there are a lot of resources available online. Introduction: Two types of accounting for Purchase that take place when an accounting entry is generated for a product receipt or an invoice that contains stocked items. 1. Purchase order voucher entry after posting product receipt Accounting entry for the accrued liability Purchase expenditure, un-invoiced DR Purchase, accrual CR Accounting entry for the cost in inventory for the received quantity of the stocked item Cost of purchased materials received DR Purchase expenditure, un-invoiced CR 2. Purchase order voucher entry after posting product invoice Accounting entry on the product receipt for accrued liability are reversed. Purchase, accrual DR Purchase expenditure, un-invoiced CR Account entry liability for the vendor invoice. Purchase expenditure for product DR Vendor Balance CR Accounting entry on the product receipt that records the inventory cost is reversed. Purchase expenditure, un-invoiced DR Cost of purchased materials received CR Accounting entry to record the actual inventory cost. Cost of purchased materials invoiced DR Purchase expenditure for product CR Conclusion: Inventory value as well as Vendor balance will increase.

Share Story :

Setting Up Ceridian Payroll Extension in D365 for Finance and Operations

If you are planning to get Dynamics 365 for finance and operations, that is an excellent thing. It is wise to plan on getting it as soon as possible. It is an Enterprise Resource Planning (ERP) solution from Microsoft. Entrepreneurs that want their company to scale up high in a few years prefer to get this software.  It is apt for companies that are small and medium-sized. But, even large companies can use it to their benefit. While indeed, so many companies are creating ERP solutions. Nothing comes close to Dynamics 365.  The best part is that it is easy to install and configure than any other ERP solution you can find in the market. The pricing of this software is quite reasonable. Here is a solution to one of the common problems that you might face.  To account for salary payments and related transactions, you must import and post financial transactions made by payroll provider to the general ledger. The extension has been provided in Extension Market place for Importing of Ceridian Payroll Entries. The Ceridian Payroll extension allows you to import payroll transactions from the Ceridian HR/Payroll (US) and Ceridian PowerPay (Canada) services. Please find below the steps on how to install extension and import payroll entries in Financials: In the top right corner, choose theSearch for Page or Report icon, enter Extension, and then choose the related link. Click on Extension Marketplace. Select Ceridian Payroll from the list of apps. Click on Install Once it is installed user needs to logout of the Financials and log in to see the changes. Once the extension is installed the user can now import payroll entries into the system. To Import a file that is received from payroll provider user needs to map the external accounts in the payroll file and then open General Journal by searching in global search. In the General Journal, on the Action tab user needs to click on Import Payroll Transactions. Click on Next to proceed importing transaction. System will ask to provide the path of the file. Once the file is uploaded in the system User can post the general journal. Conclusion: The Ceridian payroll extension helps in reducing time and effort to create manual payroll entries in system and eliminates human error.

Share Story :

Creating a Web Template Page Template Using Liquid in CRM Portals

In this blog , we will see how can a user create a custom Page Template Web Template Using Liquid template code in CRM Portals. Pre-Requisites: 1. Dynamics 365 Portal(CRM) 2. D365 CRM Environment Scenario: The user will have to create a simple two-column template that WebLink Set as left -Side navigation, with the page content to the right. The Web Template Page Template that we are going to create is shown below. Steps for Implementing Above Scenario Step 1: The user will first have to create two Web Templates one which will have the layout design and the other will have the content to the layout designed previously. In the Layout web template the user has to go to Portals > Web Templates on the dashboard and select new in the CRM Environment. The user has to enter the following details along with the Liquid Template code as shown below. Step 2: In this step the user has to create the second Web Template as shown below which will contain the Liquid Template code for inserting data content in to the Web template layout designed previously. Step 3: Now the user will have to create a new web link set according to the Web Link Set that the user has defined and intends to use in his Web Template. Over here the user has referred to Web Link Set ‘My Order Link’. The user has to go to Portals > Web Link Sets and click on New and enter the details as shown below. The user needs to add Links to the Web Link Set as shown below by clicking on the ‘+’ button to the right after the Web Link Set is saved. Step 4: Once this is done the user now has to create a Page Template that will include the web templates that we have created previously. In order to create a new Page Template the user has to go to Portals > Page Template. The user will enter the details of the Page template as shown below and click on ‘Save’. Step 5: Now the user will create a Web Page that will utilize the Page Template that we have designed. The user can create a Web Page directly form a Page Template by clicking on the ‘+’ button to the right on the Web Page Tab or by going to Portals > Web Pages and clicking on New. The user has to enter the details of the Web Page as shown below. The user can create a custom Localized Content that will be used in the 2nd section of the layout of the Web Template. The user can create a new localized content for the following Web Page by selecting the ‘+’ option. Step 6: The user will have to go to the Dynamics 365 portal environment and create a new child page that will display the result. While Entering the details of the child page the user will have to specify the Page Template that we have created previously as shown below.

Share Story :

D365 Operations Table browser error – Object reference not set to an instance of an object.

In D365 Operations, many times we need to check what data is store in tables. So, we open table browser from backend. Sometimes we face below error for all tables while opening table browser, it is a very common error and it simply means any recent customization is not compiled or sync in database. Solution: Go to Dynamics 365 -> Build Models Select the model which you have recently customized. Go to options tab. Select Synchronize database. Click Build.

Share Story :

Direct Delivery (Dynamics 365 for Operations and AX 2012)

ERP means Enterprise Resource Planning. So many companies are creating ERP software these days. Microsft Dynamics is a product from the world’s leading company Microsoft. Dynamics 365 for Finance and Operations is one of that ERP software that can help companies (Small & Large) to streamline their finance and operations departments so that they can become efficient.  The price is affordable, and once you install it, using the software is quite easy. There are some of the best features that this ERP software offers. You need to take the time to understand how to use this software to do things much quicker. If you are the employer, you should plan on organizing training sessions so that people can understand how to use it. Microsoft Dynamics 365 for Operations supports Direct delivery to customers. With direct delivery, sales orders are delivered directly from the vendor to the customer without physically entering your company’s inventory.  This type of delivery saves delivery time, labour cost, and inventory carrying costs, reduce transportation cost because you do not hold the products in your warehouse before you ship them to the customer. Below is the procedure to send ordered products directly to the customer from the vendor. 1) Open Sales and marketing > Common > Sales orders > All sales orders. Or Accounts receivable > Common > Sales orders > All sales orders. 2) Click Sales order in the New group of the Action Pane to create a new sales order. 3) In the Create sales order form, select Customer account and then click OK. 4) In the Item number drop-down, select Item. Enter quantity in Quantity Field. Specify all other information which is required. 5) Click Direct delivery in the New group of the Action Pane. 6) Then Direct Delivery form will be opened. If Vendor account number specified on item then it will automatically come on Direct Delivery form otherwise you can select or change it manually. Select the Include all check box if you want to create direct deliveries for all the sales order lines in the form. You can also select individual lines by clicking the Include check box for each sales order line and click OK. 7) Once Purchase order is created you will get below Infolog on screen Automatic purchase creation Vendor account: XXXX Purchase order XXXXXX has been created. And also you can see Purchase order number on Sales order line details in reference number field. 8) Open Purchase order, Click Header view in the Page Option group of the Action Pane, and then click the Address FastTab. You can see Customer Delivery address which came from Sales order form. 9) Now confirm the Purchase order and Post the Product receipt. 10) Once Product receipt has been posted then Purchase order status will be changed to Received and Sales order status will be automatically changed to Delivered. Conclusion: By using Direct delivery functionality you can create deliveries directly from vendors to customers, reducing delivery time and order administration.

Share Story :

Create Service Order from Sales Order using X++

Dynamics 365 for finance and operations which is earlier known as Dynamics AX is nothing but Microsoft’s flagship ERP solution. Small, medium and large companies can use this ERP suite to become efficient and to streamline their processes. It is an application that helps companies stay flexible. There are so many excellent features in this particular software that will help users become a lot more efficient than they were before.  Since it is a cloud-based, and all the changes that occur in it are real-time. Teams can work with team members that are working across the world with ease. New users might struggle with a few aspects such as creating service orders from the sales order when they are using X++. In this blog article, we will see how we can create Service Order from Sales Order using X++ in Dynamics 365 Operations. I have created a button in Sales Order form which will run a class (MenuItem – Action) to create Service Order Header. Create a new Class: class CFSServiceOrderCreateFromSalesOrder { SMAServiceOrderTable serviceOrderTable; SMAServiceOrderLine serviceOrderLine; SMAserviceTaskRelation serviceTaskRelation; SalesTable salesTable; } Create a main method: public static void main(Args _args) { Args serviceOrderTableArgs = new Args(); CFSServiceOrderCreateFromSalesOrder serviceOrderCreateFromSalesOrder = CFSServiceOrderCreateFromSalesOrder::construct(); ttsbegin; //Call to method createSMAServiceOrder() for Service Order Header creation serviceOrderTable = serviceOrderCreateFromSalesOrder.createSMAServiceOrder(_args.record()); ttscommit; //Infolog to display service order id if service order created else failure message if(serviceOrderTable) info(strFmt(“ServiceOrderHeader created with ID: %1”, serviceOrderTable.ServiceOrderId)); else info(“ServiceOrderHeader creation failed”); } Create SMAServiceOrder() method: This method is used to create a Service Order header record. public SMAServiceOrderTable createSMAServiceOrder(SalesLine _salesLine) { //initialize SMAServiceOrderTable serviceOrderTable.initvalue(); //Initialize Service Order ID NumberSeq NumberSeq; NumberSeq = NumberSeq::newGetNum(SMAParameters::numRefServiceOrderId(),true); serviceOrderTable.ServiceOrderId = NumberSeq.num(); serviceOrderTable.CustAccount = _salesLine.custAccount; serviceOrderTable.ProjId = _salesLine.ProjID; //display Customer Name as Service Order Description serviceOrderTable.Description = CustTable::find(_salesLine.CustAccount).name(); //insert Service Address serviceOrderTable.updateCustAddress(); serviceOrderTable.insert(); return serviceOrderTable; } So, this will create a Service Order Header from Sales Order. Let me know your reviews. I will soon come up with more articles, as I further explore D365 Operations.  

Share Story :

Importing Budgets using Excel in Dynamics 365 for Financials

Dynamics 365 for finance and operations is a product from Microsoft. It is an ERP or enterprise resource planning software. Both medium and large companies can benefit from using this ERP solution. Companies can streamline the processes in the finance and operations functions. You will get a detailed view of what’s happening in departments such as warehousing, manufacturing, finance, budget planning, IT, demand forecasting and transportation to name a few.  It is very easy to install and use this ERP solution. But, if you are a new user, you might struggle initially as you do not know how to operate the system and to get what you want on it. For example, you might not know how to import the budget using excel in this application. Dynamics 365 for Financials has a feature of defining Budgets for chart of accounts. The budgets can be defined in a multiple combination using dimensions and periods. Generally, companies have a huge list of Chart of Accounts and it becomes difficult to create budget for each chart of accounts in the system. Thus, Microsoft has provided a tool to import budgets in Dynamics 365 for Financials using Excel. Following are the steps to import budgets: In the global search, search for G/L budgets and click on it. Click on new to create a new budget. Provide a name & description to the budget and then click on Edit budget. Once the budget is created, go to Action tab and click on Export to Excel. On clicking of Export to excel, system will ask for Start date, No. of periods in budget and Period length. This data will be useful to design the budgets. (For e.g. Starting from 1st February 2017 I need to create a two-monthly budget for petty cash, then I will select start date as 01/02/2017, no. of period would be 2 and period length would be 2M). Once OK is clicked, an excel file will be downloaded in the system. Open the excel file and put the amount against the respective ledger and save the file. Once the file is saved, click on Import from Excel in the Action tab. The system will ask the Budget name which will be the newly created budget. There are two options available either to replace entries if there are any entries created previously or to add new entries if the user needs to append already created budget. On clicking of OK, the system will ask the path where the excel file is stored. After providing the path system will automatically either replace or add entries to the budget (depending on the option selected). Conclusion D365 for financials is a very good product for Small and medium size enterprises. The import budget features can become a very effective tool to design complicated budgets in the system within very less time.  

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange