These posts are ranked by two factors.
Traffic: the number of times the post was read.
Popularity: the level of engagement as measured by “time on page" metrics.
- A few months ago I published a blog post describing the different options for handling large datasets in Microsoft Dynamics NAV 2013 and gave a list of factors to consider when determining which option to use. One of the options discussed was creating a SQL stored procedure to perform the necessary data processing. I noted …
- Determining the best deployment option for their business software has given companies even more decisions to make during the software evaluation process. What is the best option for your company? Work with a provider that understands your unique business challenges, including budgets and internal resources, to assist you in making the best decision for your particular …
- Microsoft Excel can be a powerful tool to evaluate SQL data. In Excel, a connection can be created to directly link to a particular database filtered according to your requirements. This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update …
Creating Microsoft Excel Connections to SQL databases Read More »
- Microsoft Dynamics GP offers many fun features within the fixed asset module. Whether you are new to GP or a seasoned vet, GP fixed assets module is here to handle your every need. If it’s turning your capital purchases into an asset or simple depreciation reporting, the fixed asset module fulfills virtually every business need. …
- In a previous blog we discussed how tables in Dynamics AX have more capabilities than standard SQL Server tables. In this article, we will discuss how to manipulate data stored in Dynamics AX tables. The RecId column To make it easier to identify records in AX tables and to avoid duplicates, AX adds a column to each …
Microsoft Dynamics AX 2012 Tables Overview – Part two Read More »
- With digital transformation becoming a key enabler of success, a slew of companies are embracing technological advances to improve efficiency and throughput. With IT spending figures on the rise, and expected to reach almost $3.8 trillion in 2019, organizations are looking to embrace a number of emerging trends. While cloud adoption is the winner, ERP …
- Microsoft continues to innovate and advance its ERP accounting software solutions. Dynamics Great Plains has been supporting small and mid-sized businesses successfully for over 20 years, while Dynamics 365 Business Central is coming on strong as a leading true cloud solution for SMBs. If you are exploring your options, you might be wondering what is the …
Microsoft Dynamics 365 vs Great Plains: Key Comparisons Read More »
- Reconciling Bank Accounts is Easy with Microsoft Dynamics 365 Business Central Without the right software solution, attempting to reconcile your business’ bank accounts can be a time consuming and difficult task. But, with Microsoft Dynamics 365 Business Central, reconciling your bank accounts is easier than ever. Do you have questions about Dynamics 365 Business Central? …
How to Reconcile Bank Accounts in Dynamics 365 Business Central Read More »
- I love a good graph or even a good table. A compelling infographic can totally distract me from what I’m doing. And a good dashboard—nirvana. (Data geek—yeah, yeah, I’ve heard it all before.) But when it comes to your business dashboards, you don’t want dashboards that distract people. You want a dashboard that gives you …
- What makes refunding a customer even more painful than the act itself is the number of tedious steps it would take to process the refund manually. Some of these steps include, posting debit memos, applying documents, creating vendors from customer information, posting miscellaneous invoices, debit/credit account validation for transfer, and processing the actual payment. Luckily, …
Refunding Customers is Automated in Microsoft Dynamics GP Read More »