Today, I would like to share a resolution to an error message when using Integration Manager to import records into Sales Order Processing. Recently, I was working with a customer who was trying to import sales invoices into Microsoft Dynamics GP, but the integration was failing with an error on one document: “ERROR: Document cannot be edited, it is being edited by another user.” These types of errors usually point to temp records being stuck in one of the temp tables… SELECT * FROM DYNAMICS..ACTIVITY SELECT * FROM DYNAMICS..SY00800 SELECT * FROM DYNAMICS..SY00801 SELECT * FROM TEMPDB..DEX_LOCK SELECT * FROM TEMPDB..DEX_SESSION …where the resolution is to delete those tables after having all users exit the system. DELETE … [Read more...] about Integration Manager: “Document cannot be edited; it is being edited by another user”
Boyer & Associates Named to 2014 Bob Scott’s Insights Top 100 VARs for the Fifth Year
We are delighted to announce that Boyer & Associates has been selected as a member of Bob Scott’s Insights Top 100 VARs for 2014. The Top 100 resellers are chosen from organizations specializing in the sale, implementation and support of Enterprise Resource Planning (ERP) and accounting software. This is the fifth time Boyer & Associates was named to the list. “We are extremely pleased to once again receive the important distinction of being named a Top VAR for 2014,” said Jack Boyer, president of Boyer & Associates. “It’s an honor to be recognized as one of the outstanding Microsoft Dynamics ERP resellers and service providers.” The selection of VARs is based on annual revenue generated by each reseller. Boyer & … [Read more...] about Boyer & Associates Named to 2014 Bob Scott’s Insights Top 100 VARs for the Fifth Year
Management Reporter Balance Sheet Tips
Most of you already have a balance sheet that you are using for your monthly reports. The typical process is a combination of running a report in Management Reporter and then exporting to excel to make formatting adjustments or to correct the dollar amounts so they balance. Below are some tips to avoid having to export to excel to achieve a completed report straight from Management Reporter. 1. Separating Your Report onto Two Pages: Balance sheet reports are a good example where you would want to separate the Assets section from the Liabilities and Equity section. To do this, enter the “PAGE” function in the Format Code section of the row definition just above where you would want to start the new page of the report. 2. … [Read more...] about Management Reporter Balance Sheet Tips
June 18 Event – Microsoft Dynamics ERP Shootout
Don’t Miss This Head-to-Head Evaluation of the Leading ERP Solutions from Microsoft Dynamics Finding the right accounting and ERP solution to help improve operational efficiency for your organization is critical to your success, but narrowing the field to one that fits your needs and budget can be overwhelming and time-consuming. Jump start your enterprise selection projects and join us June 18 from 8:30 a.m. – noon at this FREE event. We will dissect and compare the most popular Microsoft Dynamics ERP solutions on the market, including Microsoft Dynamics GP, Microsoft Dynamics NAV, and Microsoft Dynamics SL, to enable you to see, feel, and determine which solution best serves your specific business needs. The presentations will review … [Read more...] about June 18 Event – Microsoft Dynamics ERP Shootout
Currency Translation in Management Reporter 2012 CU8
Currency Translation was added in Management Reporter in the CU8 update. This allows you to switch between currencies on the fly when printing the report to the web viewer by clicking on the Currencies button and selecting which currency you wish the report to display in: Before this will work, however, you need to have all currencies setup in the Multicurrency Setup in GP, as shown here: First, mark the Currency ID check box next to the currency you wish to add to the Exchange table. Then, assign the Current, Historical, Average, and Budget Exchange Table IDs. (For more information on setting up Multicurrency, I would recommend taking a look at the documentation for it in the GP code folder.) Once the currencies are setup, the … [Read more...] about Currency Translation in Management Reporter 2012 CU8
Document Attachments in Microsoft Dynamics GP 2013
A long awaited feature for Microsoft Dynamics GP has finally been added into the core product. That feature is Document Attachment Management and is available in the core GP 2013 product. When GP 2013 is installed, this feature is disabled by default but can be easily enabled with a straight forward setup window provided in Tools → Setup → Company → Document Attachment Setup. Documents are considered specific to a company, so if you have multiple companies the feature may be enabled in one company and not another, depending on your business needs. Document attachments can be used to associate electronic documents with various GP components, such as, but not limited to, Items, Sales Transactions, and Vendors. Any file that is available … [Read more...] about Document Attachments in Microsoft Dynamics GP 2013
Dynamics GP 2013 SmartList Export Error
We have seen a new issue with SmartList export in Microsoft Dynamics GP 2013 – it is truncating numbers to the thousands place. For example, on the two incidents we saw, they had a number in SmartList like 4,950.00. When exported to Excel, it exported as 4. Changing the format on the column does nothing to fix the problem. This error seems to be related to a change Microsoft did with the formatting of SmartList data for Excel. With the introduction of the Web Client in Microsoft Dynamics GP 2013, the development team needed the ability improve the performance of SmartList exports over the browser. To gain a dramatic improvement in performance, during the export to Excel, the number format in a SmartList amount column is ignored and the … [Read more...] about Dynamics GP 2013 SmartList Export Error
Using SmartList Designer to Modify Existing Stock SmartLists in Dynamics GP 2013 SP2
Want to build new SmartLists, but don’t have SmartList Builder? Prior to Dynamics GP 2013 SP2, that wouldn’t have been possible. SmartList Designer is a new tool that lets users build new or modify existing SmartLists without SmartList Builder. This post will focus on modifying an existing preloaded SmartList stock from Microsoft Dynamics GP. When you open SmartLists, the “New” button at the top left will be present. Again, this was new in Dynamics GP 2013 SP2, which is version 12.00.1482 or higher. To modify an existing SmartList, start by highlighting the SmartList node you wish to change. Click New on the SmartList header and notice it loads the fields from the highlighted SmartList node. The SmartList must be given a new name. … [Read more...] about Using SmartList Designer to Modify Existing Stock SmartLists in Dynamics GP 2013 SP2
March 19 Event – Dynamics ERP Shootout for Distribution and Supply Chain Management
Don't Miss This Head-to-Head Evaluation of the Leading ERP Solutions from Microsoft Dynamics Jump start your enterprise selection projects and join us March 19 from 8:30 a.m. – noon at this no-charge event. Learn how you can: Increase Sales Reduce Inventory Improve Customer Service Increase Supply Chain Visibility Utilizing Microsoft Dynamics ERP distribution and supply chain management solutions, discover how your sales force can grow revenue through add-on and high-margin products, decrease inventory and holding costs and leave your customers feeling appreciated and well-served. We will showcase all this functionality across 3 distinct ERP solutions including Dynamics GP, NAV and SL, to enable you to see, feel and determine … [Read more...] about March 19 Event – Dynamics ERP Shootout for Distribution and Supply Chain Management
Using SmartList to Display the Name of the User Who Posted a Transaction in Dynamics GP
From time to time we have had clients contact us wanting to know if there is an easy way to see who posted a transaction to the GL in Microsoft Dynamics GP. The Journal Entry Inquiry window will provide you with additional information associated with the journal entry, such as the Audit Trail Code and Source Document; however, it does not tell you who posted the transaction. Dynamics GP does store the user who posted the transaction in the database. So, an SQL script could be used to query the GL20000 (Open Year Posted Transactions) or GL30000 (Historical Year Transactions) tables with USWHPSTD being the User Who Posted field. However, most users do not have access to SQL to run ad hoc scripts. The easiest solution for all users is … [Read more...] about Using SmartList to Display the Name of the User Who Posted a Transaction in Dynamics GP
