Hello everyone! Shopify has become a powerful platform for companies to build their online presence and run their operations in the e-commerce space. Effectively maintaining consumer data is one of the most important aspects of running an online shop. In this article, we’ll show you how to build a custom connection to use a Postman collection to extract a single customer’s information from Shopify. You may easily get client information using this simplified procedure for better customer service and data analysis. Let’s get started! Click this link ‘https://documenter.getpostman.com/view/3800273/SWLk55pF’ to get the Postman Collection. Click ‘Run in Postman’ button, select ‘Postman Desktop App to Import’ and select ‘Open App Make sure Postman is installed in your device. Once this is imported, you will see the pre-built libraries. Export the Postman Collection and Select ‘Customer’ Imported the Collection which is exported which is in the swagger.json format Add an image as the connector icon and description as shown below. Add the host name and move to the next Section ‘Security’ Select a type of Authentication. Here, in this case, I selected Basic Authentication. Basic Authentication involves Username and Password. Provide appropriate parameter labels. We can see the pre-defined Actions as we imported the postman collection. We will be retrieving details of a single customer so select ‘RetrievesASingleCustomer’. Enter the verb Get request URL to retrieve the single customer detail Verb: GET, URL: https://{apikey}:{password}@{hostname}/admin/api/2020-10/customers/{customer_id}.json Paste this: Like this:https://8b3340489beedff0d96efe51699060e2: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@cassrodshop.myshopify.com/admin/api/2023-01/customers/{customer_id}.json Here, {customer_id} is the input parameter. So, I have edited and pre-defined the Customer ID value. Click on Create ‘Custom Connector’ Add a new connection to test the connection. Enter the API Key as the Username and Admin API Access Token as Password. You will find this in your Shopify environment Developer Options. A connection is displayed here. If it doesn’t reflect, refresh the Connection. Add the Customer ID here and click ‘Test Operation’. Voila, the response is successfully generated. Hope this helps!

In financial management, the accurate recording and reconciliation of transactions within the general ledger stand as paramount tasks. Microsoft Dynamics 365 Finance and Operations, a comprehensive enterprise resource planning (ERP) solution, offers a feature known as General Ledger Adjustments. This feature, often overlooked or misunderstood, plays a pivotal role in addressing critical challenges associated with ledger adjustment entries due to environmental issues or data corruption. The recent discovery of the General Ledger Adjustments feature within the feature management workspace prompted a deeper exploration. However, upon enabling this feature, it became apparent that Microsoft aims to streamline and systematize a fundamental problem-solving process. Reflecting on past experiences, various challenges related to ledger adjustments surfaced: Traditionally, when encountering such issues, the path forward often involved engaging Microsoft support to delve deeper into the problem. While Microsoft proficiently identifies the root cause and initiates steps to address it in future product updates, the immediate concern revolves around rectifying the existing corrupted or missing data. The suggested workaround typically involves manual journal entries. However, this process traditionally unfolds through email communications, leading to potential discrepancies or misunderstandings regarding the specifics—such as the nature of the journal entries, relevant dates, or designated journals. The introduction of the General Ledger Adjustments feature within Microsoft Dynamics 365 Finance and Operations appears as a structured attempt to address these challenges within the system itself, streamlining and formalizing the process that was previously conducted through ad hoc communications. Enabling General Ledger Adjustments: In this section, Microsoft Dynamics 365 Finance and Operations provides an interface where recommended journal entries for data correction are populated based on identified discrepancies or issues within the system. Users are presented with suggested adjustments, and based on their discretion and analysis, they can decide to create a journal entry directly from this interface. Note: Creating a journal entry from this interface generates a “Daily” type of journal within the General Ledger, facilitating a more organized and systematic approach to handling the necessary corrections or adjustments. In conclusion, this feature signifies a proactive step towards enhancing the efficiency and accuracy of managing ledger adjustments within the Microsoft Dynamics 365 Finance and Operations ecosystem.

In the dynamic landscape of manufacturing, retail and distribution, the selection of the right Warehouse Management System (WMS) holds paramount importance. It’s a pivotal decision that influences operational efficiency by saving time and labor in tracking processes, reducing loss of inventory, prevents loss of sales opportunities, greater productivity & stock control. Hence resulting into greater customer satisfaction and ultimately, business growth. Among the plethora of available options, two prominent choices stand out: D365 F&O out-of-the-box WMS solutions and SATO Global WMS. Out-of-the-box WMS solutions in D365 Finance and Operation offers standardized features designed to suit general warehouse management needs. These solutions are pre-configured and cater to businesses that prioritize simplicity and adherence to standard industry practices. Advantages of D365 F&O Out-of-the-Box WMS: Conversely, SATO WMS along with D365 F&O ERP: SATO WMS is 3rd party software which is tailored for customization and efficiency. SATO WMS is renowned for its adaptability and tailored functionalities. It offers a high level of customization, empowering businesses to mold the system according to their unique requirements. This flexibility facilitates seamless integration with existing processes, ensuring a smoother transition and optimized operations. Key Features of SATO WMS: The decision between SATO WMS and out-of-the-box WMS hinges on understanding the specific needs and priorities of the customer. If a customer prefers standardized processes and does not require extensive customization, an out-of-the-box WMS might be more suitable, offering a cost-effective and efficient solution. However, for businesses seeking a highly customizable solution to align with their unique operational workflows, SATO WMS stands out as the preferred choice, providing adaptability and tailored functionalities that enhance efficiency and productivity. Conclusion: Selecting the right WMS is a critical decision that directly impacts operational efficiency and business growth in the manufacturing, retail and distribution sectors. While SATO WMS offers unparalleled customization and flexibility, out-of-the-box solutions excel in providing standardized, cost-effective options. By comprehensively evaluating factors such as customization needs, operational workflows, scalability, and budget constraints, businesses can make an informed decision that maximizes efficiency and drives growth.

In today’s fast-paced business environment, efficient workflow management is essential for organizations to stay competitive.  Workflow email alerts help organizations stay on top of important business processes by automatically notifying designated individuals when certain tasks are completed or when specific conditions are met.  In this article, we will provide a step-by-step guide for setting up workflow email alerts in D365 FO. Before getting started, it’s important to ensure that email parameters are configured correctly and that you are able to receive test emails from D365 in your inbox.  To check this, navigate to System Administration> Setup > Email > Email Parameters.  1. In the configuration, Enable the email provider as per your requirement.  2. If your using the SMTP setting then enter the outgoing server information, and SMTP port and enable SSL/TLS required button. Set up an email address for the user who will receive alerts and enable workflow email alerts for that user. To accomplish this, go to the System Administration section, select Users, and then click on Users. Highlight and click on the user you wish to enable email alerts for.  If no email address is attached, enter the user’s email address. To enable email notifications, go to ‘User options’ on the ribbon, then click on ‘Workflow’ on the left side and set the option to ‘Send notifications in email’ to Yes. Create an email template or email message. Templates are generic and can be configured while configuring workflows.  Navigate to System Administration> Setup > Email> System email templates. Here you can create a template, such as “Workflow emails.” Assign your email template to the specific workflow. To configure the workflow email alerts, you can navigate to the workflow for which you want to send email notifications, Open that workflow access the basic settings, and choose the relevant workflow template from the dropdown menu. Configure the necessary notifications for the particular task, control, or approval while setting up the workflow steps. Here, you will specify the notification content which will be sent to the user in the email. Configure the batch job to distribute the email notifications. Navigate to System administration > Periodic tasks > Email processing > Email distributor batch.  Since we are now adding a batch job, it can be scheduled to run automatically at specified intervals. To schedule autorun, adjust the ‘Recurrence’ settings as per the requirements. Monitor email sending status. To access the E-mail Sending Status page, go to System administration > Periodic tasks > Email processing > Batch email sending status.  Here, you can monitor successfully sent, pending, or failed email messages. In conclusion, configuring workflow email notification alerts can be a simple yet effective way to stay on top of important business processes.  By following the above steps, you can set up workflow email alerts in D365 FO and start reaping the benefits of streamlined workflow management. Thank you for reading my blog!

Introduction –   A few years ago, Dual Write (DW) was introduced with the objective of providing a reliable integration between Dynamics CRM and Dynamics Finance & SCM. The intent is in the right direction, but the execution of this vision has not been reliable.   In this blog we have talked about some of the challenges we have faced and our recommendations for reliable integration.   Let’s look at some of the challenges we have faced –  Initial Sync Limitations –  Unavailability of solution in few regions –  Enabling Solution issue and missing File –  Billing Rule Error –  Table Version mismatch –  Other Issues –  Recommendations for reliable integrations –  We hope you found this article useful and if you would like to discuss anything you can reach out to us at transform@cloudfronts.com 

Introduction: A Step-by-Step Guide to Creating Opportunities and Processing Sales in Business Central Pre-requisites for creating Sales Opportunities: Create Sales Opportunities You can create opportunities from the Opportunity List page. Typically opportunities are created from a specific contact or salespeople. Globally search “Salesperson” and select related link. Select the salesperson from the list for whom you want to create an opportunity. On the salespeople card page, select opportunities action –> selected salesperson opportunities page will open up –> user can create new by clicking on New action. If opportunity is created through salespeople then salesperson code is automatically generated. Globally search “Contact” and select related link. Contacts list page will open up, user can select the contact for which opportunity has to be created. Click on Home –>Create Opportunity for new opportunity. Click on Contact–> Open Opportunity (To view existing opportunity of selected contact) If opportunity is created through contact then contact name is automatically generated. No. – This field is auto generated based on the set no. series. Description – Description of the opportunity. Contact no. – User can select existing contact or create new. Contact name: Contact name is auto generated based on contact no. Phone/mobile/email: Auto generated from contact card page. Contact company name: This field is auto generated from contact card page Salesperson code: if opportunity is created through salesperson then this field is auto populated, if not then user can manually select the salesperson. Campaign no. User can select specific campaign to link with the opportunity. Priority: The default priority is set as normal. Other priorities are Low and High. Sales Cycle code: This is a setup. (To know more refer part 1 of this blog) Status: The status field is updating automatically. Closed: Specifies if the opportunity is closed. Creation date: Opportunity creation date  Date Closed: Specify the date the opportunity was closed. Segment no.: User can link segment to the opportunity. (If any) Sales cycle stages To start the sales cycle, user can click on “Activate first stage” To move an opportunity through sales cycle stages: Sales cycle stage is automatically updated Fill in the rest of the details as necessary. To Close opportunity When the negotiations are finished, you can close the opportunity. When closing an opportunity, you can specify whether it was won or lost, as well as why it was closed. To specify a reason, you must set up closed opportunity codes. To Create Sales Quote To Create Sales Order To Delete Opportunities After you have deleted an opportunity, it is removed it from the Opportunity List page. Conclusion Microsoft Dynamics 365 Business Central provides a robust framework for creating opportunities and processing sales seamlessly. By following this step-by-step guide, you can harness the full potential of Business Central to optimize your sales processes, enhance customer relationships, and drive business growth. Hope this helps!

Introduction: In this blog I will demonstrate the set ups for opportunities. The sequence for setting up opportunity to sales cycle is as follows: Opportunities: Any inbound lead could be viewed as a potential sales opportunity. You can make opportunities and link them to certain salespeople to keep track of possible sales. You must first build up sales cycles and sales cycle stages before you start working with opportunity management. When creating opportunities, you should include details such as the contact, salesperson, sales cycle, and dates as well as your estimates of the opportunity’s sales value and success odds. Set up Opportunity Sales cycle Codes: Set up Opportunity Sales cycle Stages: On the Sales Cycles page, select the line for which you want to set up stages, and then choose the Stages action. The Sales Cycle Stages page opens. Stage: Specify the stage number. Description: A description for particular stage Completed %: Specifies the percentage of the sales cycle that has been completed when the opportunity reaches this stage. Chances of Success %: Specifies the percentage of success that has been achieved when the opportunity reaches this stage. Activity Code: User can select the activity Code for particular stages. (Activities have to be created separately) Quote Request: this check box puts a validation on that particular stage to request quote. Allow Skip:  this check allows user to skip that stage. Date Formula: Specifies how dates for planned activities are calculated when you run the Opportunity – Details report. Comment: Specifies if comments exist for the selected stage. (To add comment on any stage, navigate to Related –> Sales cycle –> Comments) Set up activities with task: You can combine multiple task, in an activity. A task represents a step in the activity. You can assign activities to opportunities, salespeople, or contacts. Assign tasks or activities of tasks to opportunities. The following procedure describes how to assign activity tasks to opportunities. The steps are similar when you assign tasks to salespeople and contacts. I will be demonstrating how to create Opportunity and Process sales Opportunities in part 2. Hope this helps!

In every organization, all kinds of expenses and revenues are tracked under dimensions like cost centers, departments, employees, etc. It is often a business requirement to split expenses or incomes in fixed proportions between two or more dimensions for accurate reporting.  On the other hand, it may be required to assign a dimension only on one GL account, restricting it from others. D365 Finance offers a smooth, flexible and a very easy process to fulfill both kinds of requirements to achieve accurate reporting of the organization’s P&L from a dimension standpoint. The blog assumes the reader is already aware about setting up financial dimensions and using them for regular transactions so the point of focus will be on the advanced features only. The procedures for both requirements are as follows: – Let’s assume that an organization tracks all kinds of office expenses in two dimensions – department and cost center. The organization wants to split the cost in a 70:30 proportion between both. In order to do that, we will use Ledger Allocation Journals. Path – General Ledger -> Allocations -> Ledger Allocation Rules The source defines the main account that will be used to split the amount. The Destination defines the dimensions and the proportion in which the amount will be split between them. In the General tab, we define the validity date for which the rule will be active. The allocation method defines the various methods in which the GL amount can be distributed. Most often, the splitting is in fixed percentages. Turn the Active checkbox to activate the rule. In the source, define the main account. In Destination, define the percentages of distribution. From the above image, we are using a 70:30 distribution ratio between Cost Center and Department.  Here, we have defined a default dimension so that the system will know how to distribute the amount between the cost center and the department only. It will ignore any other dimension. If the default field is left blank, then the user will have to manually select the dimensions at the time of the transaction. In the first distribution, a fixed percentage of 30% is applied to the Cost Center. Create a new distribution again and allocate the remaining 70% to a department dimension. In this example, we are using only 2 dimensions, but the user may define as many distributions between multiple dimensions as required as long as the percentages add up to 100%. Save the rule and close it. Now, create any regular transaction with the GL account, like a general journal. Select the dimensions for the cost center and the department as shown above and post the document. Once posted, go to General ledger -> Ledger Allocations -> Process Allocation Request. Select the allocation rule. In the field Proposal Options, there are two options: – The first option will directly post the entry and allocate it to the dimensions. The second option will keep the entry unposted so that the user may verify the dimensions or make changes to them manually if required. It is always preferable to select the second option. Upon clicking Okay, the system will create an allocation journal as shown below: – Upon clicking open the allocation journal, the accounting impact is shown as below: – The accounting impact can be summarized below as follows: – GL Account/Dimension Description Dr Cr 5103-007 Office Expense – Cost Center 700   5103-257 Office Expense – Department 300   5103 Office Expenses   1000 From the above ledger impact, the GL balance stays the same, but the amount gets distributed between the 2 dimensions in the exact proportion. II. Using advanced rules to assign an additional dimension to a particular GL account only. To understand this requirement, let’s take the example of an organization that has a mandatory Department dimension assigned on all expense accounts. But there may be an exceptional case where one expense GL account requires one more dimension apart from Department.   In this case, if we add a dimension in the account structure, then that dimension will be needlessly assigned to all GL accounts. We must ensure that it should be applicable to the one account only. For this, we use the concept of Advanced Rules. With the help of Advanced Rules, we can configure the Account Structures to accommodate any additional dimension for one particular GL account only. The steps to configure it are as follows: – Go to: General ledger -> Chart of Accounts -> Structures -> Advanced Rule Structures The screen displays all the Advanced Rule Structures present. Create a new one. Select the dimension that is required. In this example, we have selected the dimension of ‘Worker’ and kept it as mandatory. Activate the Advanced Rule Structure and close it. Open Account Structures. From the above image, all the GL accounts here will have a mandatory Department dimension. But let’s assume that one GL account – 4101 will require the dimension for Worker along with Department. For that, open Advanced Rules on top. Create a new rule. Select the Main Account where you want to apply the dimension as shown above. Then in the below section, add the Advanced Rule Structure that was created earlier. The rule works like this: – If Main Account = 4101, then apply Advanced Rule Structure where dimension = Employee. Therefore, in any transaction with the account 4101, it will assign the Worker dimension on it. Let’s take an example where a GL account other than 4101 is used here. In this transaction, for the account 4102, the system is prompting us to select the Department dimension only, as required. Now let’s select the account 4101. As observed from the above image, the system is now prompting us to select the Worker dimension also. Thus, this ensures that only some GL accounts may be configured to enter an additional dimension. We can also configure the rules such that there are combinations of Main Accounts and Dimensions to add any additional dimension. … Continue reading Distributing GL amounts between financial dimensions and using advanced rules to link a dimension to only one particular account →

While electronic methods of payment are becoming increasingly popular everywhere for quick payments, check payments are still popular across the world, especially post dated checks, which can be cashed out only after a specified date, giving them an edge over electronic payment methods. D365 Finance has a very simple process to create post dated checks and account their entries.  Since post dated checks are cleared after a certain date, known as the maturity date, the amount is not directly accounted in the bank account, but to a bridging account instead. A bridging account serves as a ‘bridge’, for the transaction amount between the bank account and the vendor/customer account till the maturity date of the PDC. When a payment entry with a PDC is made, the system will store the amount temporarily in the bridging account till the maturity date. On the maturity date, the system will transfer the amount from the bridging account in the bank account. The accounting process of the PDC is summarized below: – For Vendor:- PDC (Before Maturity) Dr Cr Vendor XX   Bridging Account   XX PDC (After maturity) Dr Cr Bridging Account XX   Bank   XX For Customer: PDC (Before Maturity) Dr Cr Customer   XX Bridging Account XX   PDC (After maturity) Dr Cr Bridging Account   XX Bank XX   The steps to set up and use PDC are as follows: – 7. Select the Account type as Bank. 8. Enable the parameters for Bridging posting and Post Dated check clearing posting. 9. The bridge account gets selected automatically by default based on the one defined in the Cash & Bank management parameters defined earlier. 10. Do the exactly same setup in AR module -> Methods of payment as well. This concludes the setup part. Now we can proceed with the transactions. Process: – Go to Postdated Checks tab and enter the maturity date for the PDC. Until the maturity date is reached, we cannot settle the PDC. So either we can wait till that date or for the sake of testing purposes, we can set the system clock to a future date. This concludes the configuration and process for PDC in D365 Finance.

Personalization stands as a robust feature within Microsoft Dynamics 365 Finance and Operations, significantly enhancing consultants’ and users’ experiences while interacting with the platform. Among these personalization options, the workspace stands out as a feature I routinely recommend to end-users. Its advantages span from streamlining daily business activities, time-saving capabilities, and improved visibility into work items that require attention, to the crucial benefit of reducing clicks and navigation across multiple screens. In this blog, I aim to demonstrate the process of creating a new workspace and sharing it with the necessary users. Creating a Workspace To initiate the personalization of your Dynamics 365 experience, follow these steps to craft a new workspace tailored to your specific requirements: Right-click on the right side blank screen and select “Personalize TitlepageContainer.” Your newly created workspace will now appear on the dashboard. After completing the initial steps, it’s time to fine-tune the configuration to suit your operational needs: Navigate to the required form or list page that you wish to include in the workspace. Select the presentation type: Tile, List, or Link. Additionally, you can create a saved view on the required form by applying filters and then add that saved view to the workspace. For instance, from the “All Sales Order” page, applying a filter for invoiced orders and saving that view to be added to the workspace. For this blog’s demonstration, I’ll illustrate adding the “Sales Order Invoice” to the new workspace. Navigate to the “Open Invoice” page. Click on the “Options” tab within the action tab. Select “Add to Workspace.” Choose the workspace created in the first part of the blog. This showcases the output when you click on the Custom workspace in Dashboard Configure Workspace Post workspace creation and configuration, the subsequent crucial step is sharing it with the relevant user groups: Identify User Groups: Determine the teams or individuals who would benefit from accessing this customized workspace. In conclusion, creating and sharing personalized workspaces in Microsoft Dynamics 365 Finance and Operations empowers users with tailored interfaces, offering enhanced efficiency, streamlined workflows, and a more intuitive user experience. I hope these steps will guide you in optimizing your Dynamics 365 experience, boosting productivity, and attaining better outcomes for your business operations.