Is it possible to integrate data into Dynamics GP when no eConnect Schema is available ! Yes, In-Transit Case Study

Despite the fact that it might be quite rare, but there are certain cases in which you need to integrate data into Dynamics GP with no eConnect schema available to accomplish such requirement. The challenge is to fulfill such requirements when it is business critical and might definitely be the bottleneck of a complete data integration.

At SIROCo, we have recently been working on an integration project. The client receives an invoice through email including the shipment details including the quantities, cost, landed cost, item number and all the associated important details. They used to do manual entry which required not less than a day to get data into GP which was absolutely time-consuming and inaccurate. Afterwards, they have looked for some in-house development in order to automate the process and the result was not much satisfying (less than a day, but still requires human interactions and not less than four hours of work). The developers used Excel and VBA code in order to get the data into SQL … and then manipulate the data into GP through SQL procedures.

Eventually, we have been introduced to the client, and the resolution was simply to get Smart Connect in order to automate the following:
– Receiving Transaction Entry

– In-Transit Integration

The end result which we’ve thought of is to have the excel file saved in a specific folder, and then run the Smart Connect Map which will handle the whole integration. Although all went well, starting from the excel import into GP to the receiving transaction entry integration, the challenge was to create the In-Transit Integration.

Smart Connect has an interesting feature called, Node Builder, through which you can build custom integration nodes without the need to have much knowledge of SQL and GP tables. As quoted from eOne website;
Node Builder is easy to use interface that is a lot like SmartList Builder. It allows you to choose the tables you want to populate and then choose the fields that will be available to be populated with this node. It also lets you define your own rules about data validation. For example, you could check that an inventory item exists before you create a specific in transit inventory transfer.

You still need to be a Microsoft Dynamics GP expert to use Node Builder and have a good understanding of the table structure and the business rules from the front end. You do not need the ability to write code, however, it helps to think like a programmer without being one.

Resolution
Although node builder is a great method, we’ve decided to follow a different approach and build an integration bridge for In-Transit which can be used not only for this client but also other clients. The integration bridge includes the logical steps following GP standards in Data Entry:

Financial Accounting – An Integral Part of Microsoft Dynamics GP

  • Transformation in Business Process – Microsoft Dynamics GP 2016 provides support for the financial reporting needs of your business with advanced tools that are easy, maneuverable and reliable. The reports can be shared with business partner firms too. With SIROCo & Microsoft Dynamics GP partnership you can do wonders in business accounting. The Management Reporter tool embedded in Microsoft Dynamics GP works in the creation, distribution, and analysis of financial statements. The support from the web client and companion apps on multiple mobile platforms (iOS & Android) shall enable users to connect and contribute at their convenience. The web service console shall provide IT tech support team to extend web access with ultimate security and control.

  • Support for Stabilized Business Growth – The best outcome of the implementation of Microsoft Dynamics GP in business is achieving smooth process and business growth through data analysis. Microsoft Dynamics GP shall allow new processes that are in the pipeline as well improve current ones to accommodate higher demands with the original investment in IT. Microsoft Dynamics GP with SIROCo shall deliver unique customized tools in Microsoft Dynamics GP business solutions with advanced business process expertise with years of experience in businesses financial reporting. With the implementation of Microsoft Dynamics GP through SIROCo, functionality such as financial reporting is supported and trained with web viewer, Power BI, Currency Tracking and eBanking solutions.

  • Accelerates the pace of Business – SIROCo stood with Microsoft Dynamics GP in building a wide range of solutions that address the small, medium and big businesses in specific accounting needs. Our unique customization to each client business giving information roles to each person with training that improves the efficiency of the whole system. These customized solutions help the staff to climb the technology curve with much ease, leading to an acceleration of business growth.

As a 100% reliable Microsoft Partner in Dynamics, SIROCo stands for business acumen and care support. We shall provide all-in-one business transition support including training and analysis of data the business process has generated. This shall increase the productivity of employees in the technical and non-technical side of the business. Your choice for us shall be the best choice for your business!

Escalation of Process Efficiency through Better Data Processing By Microsoft Dynamics GP 2016

Processing of data is an important challenge when a business migrates to Microsoft Dynamics GP. Migration to GP would lead to efficiency in data integrations and smooth running of business processes. Microsoft Dynamics GP has the best record in the industry with a long track record of consistent care with upgrades and interactive developments that cater to needs of user community. Big data analytics derived from Microsoft Dynamics GP ensures that return on investment through growth and sales is improved. Dynamics GP enables powerful tools across various Microsoft product lines (such as Microsoft Office 365, Microsoft Azure, SharePoint Online and Microsoft Power BI); the optimization of daily financial processes; improvements in collaboration through BI and reporting. Microsoft Dynamics GP 2016 provides support on comprehensive business management platform with the latest workflow architecture and functionality enhancement across the board, to streamline the end-to-end business processes with an eye on economic factors.

Here are some of the important performance enhancement features related to better data processing through Microsoft Dynamics GP:

  • In any business ecosystem, the degree of adaptation improves the chances of survival in the long run. Microsoft Dynamics GP provides support to the changes in business environment across various departments and smooth expansions through the integration of IT infrastructure (including hardware and software), leading to better business positioning for future strategic challenges.

  • Effective management of data needs excellent storage and processing capabilities with exemplary cyber protection; both of which Microsoft Dynamics GP is considered topnotch.

  • Advanced capabilities of Microsoft Dynamics GP shall provide reliable long-term returns, with immediate process improvements.

  • Cost-effectiveness through effective Dynamics GP management shall enhance value added by a business to their customers.

As a reliable Microsoft Certified Partner, SIROCo provides all-in-one support for installation to training with customized after-care. Data analysis through our system training delivered to client users and management shall make data-driven results easier and outcomes guaranteed. We provide maximum efficacy, which leads to our clients’ growth with our SIROCo Microsoft Dynamics GP Care.