Blog

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.

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.