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”
Constraint-Based Scheduling in Dynamics NAV
With all the features of Microsoft Dynamics NAV’s manufacturing module, it is easy to overlook one of the most powerful – Constraint-Based Scheduling. For those people who are not familiar with Constraint-Based Scheduling, it is based on the theory that you should only finite (schedule to only open buckets of time) your production constrained work centers and infinite (schedule each order without regard to other orders in the shop) for all other work centers. For those people that are familiar with the book “The Goal,” written by Eliyahu Goldratt, this is the major message in the book.The theory of constraints is best described using laundry as an example, since just about everyone understands the process of doing laundry. Because the … [Read more...] about Constraint-Based Scheduling in Dynamics NAV
Constraint-Based Scheduling in Dynamics NAV
With all the features of Microsoft Dynamics NAV’s manufacturing module, it is easy to overlook one of the most powerful – Constraint-Based Scheduling. For those people who are not familiar with Constraint...(read more) Source: Microsoft Dynamics NAV … [Read more...] about Constraint-Based Scheduling in Dynamics NAV
Charting your Data with Microsoft Dynamics NAV 2013
In an ERP system, actual numbers are usually preferred. However, there are times when the information is better presented in a graphical format. Microsoft Dynamics NAV 2013 has a number of graphs that are available within the Role Tailored Client, but most users don’t realize they can create additional graphs.In the Search box, located in the upper right corner of the menu screen, enter Generic Charts and then choose the link. This will take you to Departments / Administrator / Application Setup / RoleTailored Client / Generic Charts. The screen below is an example of the available charts with NAV 2013.There are over 45 predefined charts that come with NAV 2013, but what if the chart you want is not available? NAV 2013 allow you to … [Read more...] about Charting your Data with Microsoft Dynamics NAV 2013
Charting your Data with Microsoft Dynamics NAV 2013
In an ERP system, actual numbers are usually preferred. However, there are times when the information is better presented in a graphical format. Microsoft Dynamics NAV 2013 has a number of graphs that...(read more) Source: Microsoft Dynamics NAV … [Read more...] about Charting your Data with Microsoft Dynamics NAV 2013
Review of Microsoft Dynamics SL
An organization named TrustRadius asked me to review Microsoft Dynamics SL from a user’s perspective. I don’t know how they knew that we use Dynamics SL, or if they know that we have 200 Dynamics GP clients either. Boyer & Associates has a Dynamics SL practice with roughly the same number of users as GP, as well as a new Dynamics NAV practice that is only 3 months old with 5 clients. My expectation was that the group would not think I am objective enough to review their product being that we resell it. I was delighted to see that they published my review. Having used the product for 20 years, I was able to provide a different viewpoint, and it was enjoyable to be asked so many challenging and interesting questions.Here is the link to … [Read more...] about Review of Microsoft Dynamics SL
Renaming Records in Microsoft Dynamics NAV
One of the more interesting features of Microsoft Dynamics NAV is the ability to rename a record. Within NAV, you can rename a Customer, a Vendor, an Item – almost anything. NAV will go through the entire database and rename the record everywhere it is found.Renaming a Customer or Item will change all open and historical records to reflect the new number for the record. This feature can be valuable in many situations. One situation that comes to mind is where clients have used intelligent customer numbers, putting their customers in alphabetic order, only to have a customer change their name. (I want to state here that I always recommend against intelligent numbering schemes, but sometimes clients don’t listen to me.)To rename a record, … [Read more...] about Renaming Records in Microsoft Dynamics NAV
Renaming Records in Microsoft Dynamics NAV
One of the more interesting features of Microsoft Dynamics NAV is the ability to rename a record. Within NAV, you can rename a Customer, a Vendor, an Item – almost anything. NAV will go through the entire...(read more) Source: Microsoft Dynamics NAV … [Read more...] about Renaming Records in Microsoft Dynamics NAV
Unlimited Report Formats in Dynamics SL 2015
About every three years, a new version of Microsoft Dynamics SL is released. The next one is scheduled for 2015, and Microsoft is educating us about the new enhancements.In Dynamics SL 2015, there will be unlimited report formats. In previous versions, you were limited to eight. Now, in Report Control, there is no restriction.This is a report writer’s dream come true!To stay up-to-date on other Dynamics SL 2015 enhancements, and to learn additional tips and tricks regarding Dynamics products, visit our blog. … [Read more...] about Unlimited Report Formats in Dynamics SL 2015
Boyer & Associates Named to 2014 Bob Scott’s Insights Top 100 VARs for the Fifth Year
Boyer & Associates Selected as 2014 Top 100 VAR for 5th Year from Bob Scott’s Insights June 24, 2014, Minneapolis, MN --- Boyer & Associates, (Boyer) a leading provider of Microsoft Dynamics ERP business management solutions for mid-sized businesses,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. Boyer & Associates sells and supports Microsoft Dynamics GP, Microsoft Dynamics SL and Microsoft Dynamics NAV financial management solutions to a variety of industries … [Read more...] about Boyer & Associates Named to 2014 Bob Scott’s Insights Top 100 VARs for the Fifth Year
