In any organization with business spanning across multiple countries, multi-currency transactions play a vital role in day-to-day business. Any accounting software should be able to facilitate currency conversions not only at the time of booking the transaction but also calculating the forex gain/loss incurred during the end of any period or after settlements are made against open transactions. Dynamics 365 Finance & Operations offers an effectively simple functionality to facilitate such important transactions. Called as Foreign Currency Revaluation, it provides the following features: 1. Calculate the unrealized foreign currency gain/loss against all open transactions for any vendor/customer. 2. Account the unrealized gain/loss into the respective GL accounts. 3. Knocking off the unrealized gain/loss accounts by transferring the balance to the realized gain/loss accounts at the time of settlements. This functionality is beneficial to any accounting manager who wishes to know any gain/loss that might incur before making actual payments and make important business decisions accordingly. Dynamics 365 Finance not only has a very short and simple setup to set up Foreign Currency Revaluations, but also a very easy way to run the process. Setup Starting with the setup, the below settings need to be configured first: 1. Setup currency exchange rates Path: General Ledger -> Currencies -> Currency Exchange Rates As per the above screenshot, the user can have multiple currency conversion rates setup for any date range. 2. Configure main accounts for Unrealized Gain/Loss and Realized Gain/Loss As per different business requirements, the foreign exchange gain/losses can be accounted in a single GL account or multiple GL accounts. Based on that, the necessary accounts should be configured. They can come under Expenses or Revenue. 3. Link the main accounts to the Ledger For the system to account the gain/loss amount into the respective GL accounts, it is necessary to link them in the Ledger first. Path: General Ledger -> Ledger Setup -> Ledger 4. Enable multi-currency option in bank master Path – Cash & Bank management -> Bank account -> Enable the option “Allow transactions in additional currencies” This will enable the bank settlements to be done in any currency. 5. Lastly, Foreign Currency revaluation exists for each module (AP, AR, GL) and it is accessed directly without any setup. The setup is complete with the above steps. Now comes the process flow. As an example, the transactions will be run for the months of June and July where each month has a currency rate of 1 USD = 70 INR and 1 USD = 75 INR respectively. Based on these currency rates, the system will calculate a profit for customer payments and a loss for vendor payments respectively. Let’s start with the profit scenario first 1. Create a back dated FTI journal in the month of June. Select the amount as 1000 dollars. The accounting impact for the journal in USD and INR will be as below: FTI (USD) Dr Cr Customer 1000   Revenue   1000 FTI (INR) Dr Cr Customer 70,000   Revenue   70,000 2. Navigate to Accounts receivable -> Periodic Tasks -> Foreign Currency Revaluation Click on Foreign Currency Revaluation at the top. Clicking that will open the parameters window. Here, user can run the FCR for a specific vendor/customer. The considered date and Date of rate should be selected as the date when the new currency rate will take effect. In this case, it will be 1st of July, where the currency rate will become 1 USD = 75 INR. Click on OK. Once it is run, it will create an entry in the same screen as shown below: By default, the latest entries are at the bottom. Select the entry and click on voucher to see the effect. The voucher effect is as shown below: As per the above accounting impact, the system calculated that from 1st July, there will be a net gain for any customer payments against invoices made in June. Hence, the system will select the Unrealized Gain account and post the currency difference amount in it as an income. The customer’s outstanding balance also increases by the same amount. The simplified accounting effect is as below: FCR (INR) Dr Cr Unrealized Gain   5000 Customer 5000   Now if a payment is created in the month of July against the invoice booked in June, the system will post the payment journal as per the current exchange rate (i.e., 75 INR) and transfer the Unrealized amount to the Realized amount. This effect is as shown below: The simplified impact is as shown below: Payment (INR) Dr Cr Customer   75000 Bank 75000   Final Voucher Dr Cr Unrealized Gain 5000   Realized Gain   5000 The customer account is settled and a revenue of the currency difference amount is recorded as a Realized Gain. The brief summary of these transactions can be found in the Customer transactions (Customer Master  -> Customer -> Select Transactions from the top panel) The above was an example where there is a net gain from customer payment. Exactly equivalent accounting impacts will take place for other scenarios like vendor gain, vendor loss and customer loss as well. The below table shows the exactly the type of impact incurred for vendor/customer transactions for increasing or decreasing currency rate: Vendor Customer If Currency –> Increases If Currency –> Increases Then Vendor Account –> Increases (Cr) Then Customer Account –> Increases (Dr) Net result –> Loss (Dr) Net Result –> Gain (Cr) If Currency –> Decreases If Currency –> Decreases Then Vendor Account –> Decreases (Dr) Then Customer Account –> Decreases (Cr) Net result –> Gain (Cr) Net Result –> Loss (Dr) Now, what if the user makes the payment without running FCR? In that case, the system will directly impact the Realized Gain/Loss account for the currency variation amount against the vendor/customer. No Unrealized GL will be accounted. In conclusion, the process of running FCR is useful to determine the best time span for making payments in order to benefit from currency exchange rates.

Introduction In multi entity environment having separate legal entities for head quarter & regional entities, having separate sets of employees for each legal entity. & only head quarter employees taking decisions for which & how much inventory to be maintained at regional level & same employee having purchasing authority for all regional entities. In this case to keep track, post & report of what & how much purchase made for respective regional entity, need to create Purchase requisition for respective buying legal entity. i.e. USMF is headquarter entity & PM is regional entity. Problem Statement While creating Purchase requisition from headquarter employee’s login, it is created with buying legal entity as headquarter entity. i.e. Julia is employee of Headquarter USMF entity who will be going to issue Purchase requisition for regional entity PM. When Julia login in PM entity & create Purchase requisition then entity will automatically change to USMF. Solution Steps Follow below steps, in order to create Purchase requisition with buying legal entity as respective regional entity & to maintain all details on respective entity. 1. Select employee of headquarter which is going to issue Purchase requisition. i.e. select Julia in USMF entity – Go to Human resource -> Workers -> Employees -> 2. Select required employee. i.e. Julia – 3. Go to Work History 4. Click on Add employment to add respective entity to history. i.e. Add PM entity in Julia’s history 5. Add details of Legal entity i.e. Entity PM, Employment start date & click on Create employment. 6. History is added of PM entity Create Purchase Requisition Go to Procurement & sourcing -> Purchase requisitions -> All purchase requisitions & create new Purchase requisition from PM entity then Purchase requisition will be created for PM entity & window will not switch back to USMF. Now all Items added in this Purchase requisition will be ordered & maintained for PM entity.

In this blog, we are going to address the issue that can be seen in the recent update in Microsoft Dynamics 365 Finance & Supply Chain Management. To solve this issue please follow below steps. Currently If we see before the setup there is no tax information showing in Stock Transfer Transaction. Only the Administrator can see this Tax information. To overcome this issue, in Dynamics 365 F&SCM new update we have to enable “Private” field in the warehouse address tab. For this, Go to Inventory Management Setup->Inventory Breakdown->Warehouses. Go to Address. Click on Advanced. Right click In Address section and Click Add field. Add a field as “Private”. Once it is on the address section just disable the private field. By this every user will be able to see the Tax information on the Stock Transfer. After this, the user will be able to see the Tax Information on the Stock Transfer. That’s it for this blog. Thank you!!!

Introduction A purchase requisition is an internal document that authorizes the Purchasing department to buy items or services. Until now if you wanted to create a Purchase order requisition, D365 Finance and Operations HQ was only an option but in the release wave 2 plan “Microsoft has brought a new feature of creating Purchase order requests from POS.” Business Value The addition of this feature will eliminate the use of multiple tools and make POS the single app for store employees to handle the end-to-end purchase order business processes. Feature Details Create purchase order requests in POS. View purchase orders requests in POS. Edit purchase orders requests in POS. Confirm Purchase order requests in POS. Steps to create a purchase request from POS Step 1 Enable the feature from feature management page as shown in below images : Step 2 Go to Retail and commerce >Retail and Commerce IT > Distribution Schedule and Run 1070 , 1110 , 1090 job. Step 3 Login to POS (MPOS or CPOS) Step 4 Go to Operation “Inbound Inventory” as shown in screenshots  : Step 5 Click on ” +” create new symbol . Step 6 Select Vendors from which you are willing to purchase the products. Step 7 Fill out the necessary details like the Date of delivery, Accounting date, and add a note if required and confirm the order. Step 8 Add the product manually or by scanning the barcode of the product. Step 9 Add Quantity Step 10 Submit request to HQ. Step 11 You can see the Status as Created Step 12 Purchase Order Created and sent for approval at HQ. This completes the process of creating PO requisition from POS itself.

In this blog, we will learn how to change a Product’s Product Number. For this blog, I have created a New Product, Hand Gloves with Product Number P-000015 and released it into the system. The Path for Changing the Product Number is: Product Information Management>Products>Products. Step 1: Click on Change Number under the Maintain tab. Here, my Product number is P-000015 which I will change to P-000020. Step 2: Enter the New Product Number and Click on OK. The above screenshot shows that the Product Number has now changed from P-000015 to P-000020. Note: It is recommended to rename only if no transaction exists for the product. If the Product already has an existing transaction, it is better to create a new Product.

In this blog, I am going to showcase how to initialize a Retail commerce scale unit. If you’re using a Tier-2 sandbox or production environment that has application version 8.1.2.x or later, you must initialize a Commerce Scale Unit (cloud) before you can use retail channel functionality either for point of sale (POS) operations or for e-Commerce operations that use Retail Server in the cloud. Initialization will deploy a Commerce Scale Unit (cloud). Prerequisites Deploy a Tier-2 sandbox or production environment that has application version 8.1.2.x or later. Initialize Commerce Scale Unit as part of a new environment deployment Make sure the headquarters environment is available and not in Maintenance mode. In LCS, on the environment details page, Click on Manage. 2. Click on initialize 3. Select the your region And initialize Ok 4. Inside HQ, go to channel Database new channel DB created. Add channels inside that Channel DB. 5. Go to channel, click on channel profile and select that new channel DB. Run 9999 jobs from the channel Database. I hope this helps!

Many retailers, especially high-end specialty retailers, want their sales associates to form long-term relationships with their key customers. The associates are expected to know about these customers’ likes and dislikes, purchase history, product preferences, and important dates, such as anniversaries and birthdays. Associates need a place where they can capture this information and easily find it when it’s required. If this information is available in a ‘single view, the associates can easily target customers who meet specific criteria. For example, they can find all customers who prefer to shop for handbags, or customers who have an important event approaching, such as a birthday or anniversary. Or if a customer had bought a gift for her husband then the cashier/associate can ask the customer if her husband liked the gift. In a nutshell, this will allow the stores to create a relationship with customers on a personal level. This is bound to make customers happy as they will begin to think that they matter and they are being looked after. Such practice will directly impact the sales Here is how you can set up Clienteling in d365 Commerce.  In the Feature management turn on the clienteling functionality in your environment Turn on the Clienteling feature by selecting Enable now. On the Commerce Parameters page, on the Number sequence tab, select the Client book identifier row. Then, in the Number sequence code field, select a number sequence. The system will use this number sequence to assign an ID to client books. Create a new attribute group that contains the attributes that you want to capture for customers who are managed in client books. Define the required attributes as Can be refined. Sales associates can then use these attributes to filter their client book. On the Commerce parameters page, on the Clienteling tab, in the Client book attribute group field, select the attribute group that you just created. To capture activities that occur at the POS, define the activity types on the Activity types page (Retail and Commerce > Customers > Activity types). Add two buttons to the appropriate POS screen layout, so that sales associates can view their own client book and the store client book. (Store client books include clients from all client books of all associates who share an address book with the store.) The corresponding operations are named View customers in client book and View customers from store client books, respectively. Three additional operations that are related to client books are available. These operations determine which associates can add, remove, and reassign customers from the client book. They are named Add customer to client book, Remove customers from client book, and Reassign customers to a client book, respectively. Run the following distribution schedule jobs: 999. After you’ve completed this procedure, sales associates can open the customer details page at the POS, and add customers to their client book, view and capture activities and notes for customers, and target customers by using customer and client book attributes to filter the client book. Cashier can search for a customer and he would be able to see and add notes of customer account which will allow the store person to offer a more personalized experience to the customer Hope this helps!

In this Blog, we will learn how to Acquire a Fixed Asset from Purchase Requisition (PR). The method that we are using for this process is: Purchase Requisition > Purchase Order Creation > Purchase Order Invoice > Fixed Asset. Prerequisites In the fixed Asset Parameters, Under Purchase Order Enable Allow Asset Acquisition from Purchasing. Step 1: Create a New Purchase Requisition. Step 2: Click Add Line and add the Details such as Units, and Fixed Asset Category. Step 3: Submit and Approve the PR. Step 4: After Approval Click on Release Approved Purchase Requisition. Path: Procurement and Sourcing > Purchase Requisition > Approved Purchase Requisition processing > Release Approved Purchase Requisition. Step 5: Select the Approved PR and then click on Purchase Order. Step 6: Select the Vendor. Step 7: Now open the Purchase Order and enter the Amount. Step 8: Confirm the Purchase Order and post the Product Receipt. After Posting the Product Receipt we can see that the Fixed Asset number has been populated on the Line level and the status of the Purchase Order has been changed to Received and Confirmed. Now if we click on that Fixed Asset and then click on Books, we can see that the Fixed Asset has the status “Not yet Acquired”. Step 9: Post the Invoice to Acquire the Fixed Asset. Now if we check the Status of the Fixed Asset, it is changed to Open which means that the Fixed Asset has been Acquired. That’s it for this blog hope this will help you. Thank You!

The Regression suite automation tool (RSAT) is used to reduce the time and cost of UAT (user acceptance testing) of finance and operations.  UAT is typically required before you take a Microsoft application update, or before you apply custom code and configurations to your production environment. RSAT lets functional power users record business tasks by using a Task recorder and then convert the recordings into a suite of automated tests, without having to write source code. RSAT is fully integrated with Microsoft Azure DevOps for test execution, reporting, and investigation. Test parameters are decoupled from test steps and stored in Microsoft Excel files. Configuration: 1. Open RSAT application. 2. Select the Settings button in the upper right to configure RSAT. And next steps will help you to find those required fields input 3. Go to project settings of Lcs for your projects Go to Visual Studio Team Services. Here you need to mention the Azure DevOps project in the Azure DevOps site URL field. In order to do that, click on 4. Open Azure DevOps and create a new organization if there is no existing one. 5. Now create a new project as shown below  6. Now you need to set up a security token by clicking on  account info>security 7. Once you create the token, save it as you will not be able to access it again when you want to use it.  8. Once that is done, go back to the main page and create a new test plan. Name it as RSAT-TT (or you can use any name)   9. Now right-click on RSAT-TT and create a new suite you can name it ‘Demo’. Azure DevOps setup is done. 10. In the Azure DevOps site URL mention the Organization name that you setup in Azure DevOps. And in the Personal access token field paste the token that you had earlier saved. 11. Click on continue to select the project and continue, Save. 12. Now you need to deploy it to the environment  13. Next, open the Regression Suite Automation Tool, Go to settings In the Azure Dev Ops Url field copy it from the LCS Access token should be the security token you had copied. Click on Test connection so the Project name and Test plan will populate. 14. Now run VM. You will find Hostname and SOAP Hostname by going to IIS and then right-clicking on AOSService>Edit bindings. Copy both the Hostname and in Hostname and SOAP Hostname fields paste these values in step 16 15. Admin username should be the username you use to login to your environment. 16. To generate Thumbprint click on New and save at any location and then copy the generated certificate to the VM 17. Open the copied certificate and install it on the local machine at personal and Trusted Root Certification Authorities locations. Now Open the wif file in admin mode in notepad from the given location of VM In the wif file find whether CN name=127.0.0.1 exists or not. If not, copy the selected portion and paste it below the same authority block. Now add modify those lines as follows:-            <authority name=”CN=127.0.0.1″>             <keys>               <add thumbprint=”F46D2F16C0FA0EEB5FD414AEC43962AF939BD89A”/>             </keys>             <validIssuers>             <add name=”127.0.0.1″ />             </validIssuers>             </authority>  ( Note: Add thumbprint of installed Certificate in wif as shown) Final steps include Copy the thumbprint from RSAT settings (which was generated when you click on New) and paste it in wif file in your VM Then Mention the company name And Working directory Set the default browser as internet explorer Save as and ok 18. Next, Go to LCS open business process modeler and create a new Library 19. Name it as RSAT, go to edit and rename the process as required and you may add a child node to it by clicking on Add process. 20. Now go to Finance and operations, go to test recorder 21. Create a recording by clicking on create a recording and perform the operation and then click on the stop button. Name it as per your need then Save it to Lifecycle services or Save this to PC option. Click ok 22. Now go back to LCS in the project library and click on the requirement, tab check it’s syncing 23. Now Sync test cases and VSTS sync 24. Next go to Visual studio DevOps, test cases, click on Add existing 25. Then click on the run query and click on Add test case 26. Now go to regression suite automation and load the test and download test cases. select test and click on new and generate test execution parameter files 27. Then click on the edit option for the older version to edit values in excel For older version For newer version Now edit metadata for test in an excel file and save and close Now Run the test after this step, the automatic session for the test is handled by selenium where the browser will perform steps as test cases 28. Then run the test and after it’s completed successfully click on upload (Note the result as passed) POS RSAT Follow these steps to create a new recording by using the test recorder: Launch Cloud POS. Select the hamburger icon on the left pane and select Settings. Don’t sign in to Cloud POS. The sign in step must be recorded as part of the test recording flow, so you need to launch the recorder before sign in.) On the Settings page, in the Task and Test recorders section, select Open test recorder. Select Create a new recording. 4. Enter a name and description for the recording, and then select Start.The test recorder enters recording mode, and the recording session begins. The test recorder pane shows information and controls that are related to the recording session.  Perform the needed actions in the POS user interface. Download options After you end a recording session, you can download the recording by selecting Save to this PC. Upload that .axtr file in the business library. The .axtr file is saved to the local file system. You must … Continue reading Regression suite automation tool (RSAT) for D365 Finance and Operations, Commerce →

In this blog, I’m going to showcase to you the impact of the latest purchase price parameter on the item purchase price. Enable the latest purchase price for any product. So whenever new purchase order is created for a product with a specific price or different price, and in case the price of the product keeps changing in every purchase order based on the recent cost price of the item in the purchase order then the price of the item is also changing in the item master. I’m showing the example of the latest purchase in the below steps: Steps to enable the latest purchase parameter in the released products Navigate to the released products. Select the product for which you want to enable the latest purchase price. Open the purchase tab, Inside Price updated to enable the latest purchase price parameter Set the price in the product master to 50 USD (you can also set the prices through a trade agreement . ) Create a purchase order for this product Create a purchase order for this product and add this item to the purchase order lines. Set the purchase price for this product to 100 Confirm the purchase order. Post the product receipt (GRN) for this purchase order. Once it’s received, invoice the purchase order. Once this invoicing process is done, go back to the product master, and open the product for which we have enabled the latest purchase price. The price for this item is changed to the latest purchase order prices (prices changes from 50 USD to 100 USD). NOTE: Inside the manage cost tab item price, you can also see the purchase price is Overrides to 100 If you want to see the history of the fluctuation in purchase prices. You need to enable the Last price history. Steps to enable the last price history. Navigate to the inventory and warehouse parameters. Select the inventory accounting tab Enable the Last price history. So you can see the price change history in the item price. I hope this helps!