News

Integration of Dynamics 365 F&O with Sharepoint

Sharepoint is a cloud service using which employees can easily share documents and information with colleagues, partners and customers. This article is about the integration of the MS Dynamics 365 F&O ERP system with this service.

The customer is a large retail holding of weighing equipment, which has representative offices in different European countries: France, Italy, Germany and the United Kingdom.

The company collects interim purchase reports in the form of Excel spreadsheets, which are stored on the Sharepoint data exchange portal for the convenience of collaboration. Employees, receiving this data, entered them into Dynamics 365 F&O, registering warehouse orders manually. It took quite a long time, and the company set out to optimize this process. The main task was the integration of Dynamics 365 F&O with Sharepoint, for which IT-Commune specialists were engaged.

Inventory management and accounts receivable modules were involved in the integration.  The implementation of the solution took about two weeks.

The convenience of work lies in the fact that warehouse managers can generate data in the form of Excel tables, as before, in the usual Sharepoint. The new Dynamics 365 F&O operation checks for changes in the storage and automatically processes the data.

So, for example, it can create serial number receipts in the main purchase order. To do this, it processes an Excel spreadsheet from Sharepoint, which contains the serial numbers specified by the manager for registration of the arrival.

The periodic operation polls Sharepoint for changes in the file version and loads data from the file. The system always stores data for each day, so that the user can find the source data to track changes during the procurement process.

As a result, the processing time of information is significantly reduced (manually entering data from one report took an entire working day of one employee, the system enters the same amount of data in less than 30 minutes). Another advantage was the reduction in the cost of licenses to work with the system: thanks to the automation of document processing, the number of employees working in Dynamics 365 F&O has decreased. And the reduction in the number of users has further increased the level of data storage security.

This solution is relevant for companies that use Sharepoint documents as a data source for Dynamics 365 F&O. They often face the problem of low processing speed of these documents. Integration allows you to speed up the processing of documents and reduce the cost of using the system.

Read more...

Modifications of Microsoft Dynamics AX functionality for a client from UAE

The client of our partner, a wholesale distributor of FMCG in the UAE and Oman, assigned us with the task of refining standard Microsoft Dynamics AX 2012 functionality. The company has a vast customer database, which includes large-scale retail chains and small neighborhood stores.

The client’s problem

Within the standard functionality of Microsoft Dynamics AX 2012 each customer’s card states the sum that limits monetary expenses – a credit limit for sales. If a client goes outside their limits, i.e. delays payment or buys goods at the cost exceeding the specified sum – the system will block further transactions on generation of orders and related documents.

To resume operations, managers had to call or write to sales representatives and several-days negotiations would ensue.

In short – the client didn’t want the work to stop with their clients in cases of credit overdraft.

Our solution

We have developed a workflow — an operating process with the help of which a manager can send to a responsible person a suggestion to approve a client’s order, even if their limit has been exceeded. If a person in charge approves the order, the program allows to create a purchase and draft all necessary documents. A person in charge can send the proposal for correction or reject it.

Result of work

After modification of standard functionality, the communication within the company enhanced — in case of disputed orders, the necessity to call or write disappeared. The only thing they need to do is to send a request to a manager. Approval of disputed orders now takes one day instead of three days. The workload of staff has decreased by 50 percent. Monitoring of a client’s credit score has improved as well.

Read more...

Microsoft Dynamics 365 for Unified Operations – Switching from Laptops to Mobile Devices

One of our dedicated teams recently completed a project for a client that involved the development of a mobile application based on the Microsoft Dynamics 365 for Unified Operations mobile app framework. The client’s customer is a major waste disposal company that wanted to switch from laptops to mobile devices in an effort to optimize the way users performed two key operations – weighing vehicles on weighbridges and editing weighing slips.

Upon return to a warehouse, every waste collection truck is weighed on a weighbridge to determine the quantity and classification of the material collected. Previously, the user would record all this information using a laptop. Now with the new app, the user can simply scan the barcode with a smart phone or tablet and begin to enter the weight of the truck, select the material classification (e.g. dangerous goods), allocate the appropriate storage location in the warehouse, and create a weighing slip in Dynamics 365 that will be used to invoice the customer. All weighing slips accumulated throughout the day are then automatically posted together as a batch in Dynamics 365 at a later time.

Importantly, the app also allows for the user to make deductions to the weighing slip in the event that the collected load contains more than one type of material. These changes will be reflected in the customer invoice and ensures that the customer is charged the correct amount.

The second functionality provided by the app is the ability to edit weighing slips after they are created. Once again, using a mobile device, the user can select an existing weighing slip and change the weight, edit/delete deductions, correct errors, or even edit weighing slips produced via automated weighbridges.

The project took approximately 3 months to complete with the team of 3 (2 developers and 1 consultant) working on a full-time outstaffing basis. The experience gained by our team means that they are now able to create mobile applications for DAX365 much faster in the future.

Outstaffing is ideal when the client has an experienced project manager and only requires developers and consultants to perform the work. Essentially, they become an extension of your team where you control the entire process. If you have projects but are experiencing a shortage of resources, reach out to us. We have a strong pool of resources of senior developers and consultants with a wide spectrum of experience that can help you to deliver your projects successfully.

Read more...

Case in Waste Management: Recycling Industry

We have a long-term client who is an MS Partner and ISV-solution provider. As part of our cooperation, we provide them with a dedicated team of D365FO developers and consultants.

The client implemented a vertical solution for their customer in the recycling industry and utilizes our team for solution customization. A technical support project also runs in parallel where bug fixing is performed and new functionality constantly implemented.

DIXF framework and OData protocol are extensively used throughout the project for data exchange. For DIXF framework, numerous custom data entities are implemented and our developers perform their modifications, as well as create new entities. The OData protocol provides an access to the system externally, with multiple OData actions implemented within.

Business-events feature is also widely used in the project. Major events that occur in the solution are covered by business-events. They are then consumed from within the MS Flow.

Solution Customization

The features of the vertical solution that were developed and tested by our team include:

  1. Business Partner Maintenance

Ability to maintain business partners (customers & vendors). Each business partner has its own settings, contact information and default values used throughout the system. The way the user interacts with the “Business partners” form is quite similar to that applied to the standard “Party” form.

  1. Container Maintenance

It’s possible for the user to view a container’s on-hand information (e.g. dimensions, weight, contents, container type, ownership, etc.), associated container movements and a posting history.

  1. Contracts and Contract Quotations

Contract quotation is nothing more than just a contract draft. Once a contract quotation is confirmed, an associated contract is created that is very similar in details to the initial quotation.

Every contract and contract quotation is associated with some particular business partner, and a contract is an agreement with the business partner for a service, waste disposal, material shipment or material removal. Contract has an effective date.

There are lines user creates within the contract/contract quotation, describing terms of the contract. Each line has its own item identifier, quantity, price, delivery terms, storage dimensions, as well as financial dimensions.

Lines can contain a link to containers, which means that the particular material is going to be shipped/removed within the container specified.

  1. Work Orders

Once the contract is confirmed, an associated work order is created in the system, containing all or particular lines from the initial contract. A work order creation is accompanied with the related sales/purchase order creation, and this sales/purchase order contains lines from the contract as well.

Work order is shipped, and in a parallel an associated sales order is delivered as well as a purchase order is received.

It is possible to schedule a service, and the system will create work orders based on contracts on a regular basis.

  1. Hazardous Materials Maintenance

Classes of hazardous materials are applied to contracts. NFPA identifiers selection is available, as well as transport/health/physical/environmental hazard labels.

Applied to the waste removal, EWC, OECD, Basel, Y-Code and H-Code available.

These are then inherited into the work order.

Technical Support

In regards to technical support, bug fixing is performed as well as new functionality is constantly implemented. It is usually so that while implementing one particular functionality, code refactoring and system optimization is done by a particular developer to ensure that the overall system demonstrates a high level of performance.

While working on the project developers usually administered their own development boxes by themselves. They applied updates and hot-fixes, and dealt with database routines. Every developer has experience with an environment set up.

If you also have a project that requires a dedicated team of D365FO professionals, contact us and let us show you how we can help.

Read more...

IT-Commune is Clutch.co’s 2019 #1 Microsoft Dynamics ERP Consultant!

Although we were only founded 8 years ago, our team has over 15 years of experience in making complicated IT services convenient and affordable to clients all around the world. We have been able to provide development and consultancy services for Microsoft Dynamics and machine learning. Specifically, our expertise in Microsoft Dynamics has caught the attention of Clutch.co, as we were recently ranked #1 in their 2019 Leading IT & Business Services report and #1 in their Leaders Matrix for Microsoft Dynamics ERP consultants.

Headquartered in Washington D.C., Clutch is a B2B site that rates and reviews agencies in numerous industries. Their goal is to connect businesses with the ideal firm to resolve a precise need. They rank hundreds of agencies based on a unique methodology that evaluates expertise, portfolio of work, and ability to deliver top-notch products for their clients. Their analysts spoke directly with our clients to assess these areas. Based on their research, we were ranked #1 in their annual listing and #1 in their Leaders Matrix out of close to 300 firms.

Beyond holding this highly coveted spot, our success is also shared on Clutch’s sister-sites: The Manifest and Visual Objects. The Manifest publishes state-of-tech news and how-to guides for businesses, assisting them in simplifying their hunt for solutions providers. You can find us listed here among other ERP consultants. Likewise, Visual Objects is a platform that displays portfolios from developers to creative agencies alike so firms can imagine what a future project might look like.

Without our clients, we wouldn’t have been ranked #1 by Clutch! We’d like to thank them, as well as Clutch, for taking the time to review our company. We understand that “only a happy employee can make a client happy”, and we will continue to implement this notion as we innovate, experiment, and grow.

Read more...

Case in Retail: Daily Sales & Vendor Invoices Blocking Issues in AX2012

We have an end-client who is a furniture, appliances, electronics and home furnishing retailer. They reached out to us to help them with 2 blocking issues in Microsoft Dynamics AX 2012 – blocking that occurs during the posting process of both daily sales and vendor invoices.

The posting of daily sales is normally scheduled to run as a batch job overnight. But, if there are any over the limit differences in amounts, the job reports an error and execution comes to a complete halt. This meant that first thing in the morning, before stores opened for business, the accounting department had to frantically make corrections and post them manually. The problem was that if they couldn’t resolve the issues in time, their Customer table would remain blocked, which meant they couldn’t insert new customers, and this was a major issue for their regular sales process.

The second problem the client was experiencing was posting vendor invoices. When they posted one vendor invoice, it would cause a block to the Inventory tables, which resulted in not being able to post another vendor invoice.

Once we were assigned the task of fixing the blocking issues, our developers quickly found the problem. We noticed that when a mass-update was performed, it caused an exclusive block on the InventTrans table. By replacing the bulk updating of rows to instead update line-by-line (while selected), the blocking issue was no longer present because an index is used across the field RecId.

Blocking on the CustTable was also resolved after we changed the bulk update performed on the InventTrans table to row-by-row. This was caused by intermediate tables including InventDim and InventTransOrigin which were being blocked during the update process on the InventTrans records.

If your business experiences blocking issues in Microsoft Dynamics AX 2012 or you need to resolve technical issues fast, contact us, and let us show you how we can help you.

Read more...