Archive for November 11, 2011

GPUG Summit: Day 2

Day 2 marks the day I get back on stage.

The morning started out very slowly, with most of the time spent at the Mekorma Connections Cafe, catching up on emails and projects I am currently working on back in Atlanta. On the way to the Cafe,  I couldn’t help but realize how there was no one around. That’s good, because it seems GPUG Summit 2011 (twitter: #gpsummit, #GPUG) attendees are definitely getting the best out of the conference and maximizing their time. Also, it would suggest that a number of partners have already left town from the now defunct GP Partner Conference (twitter: #GPCC) event which wrapped up day before yesterday.

Upon arrival at the Cafe, there was a second round of book signing with our community authors – see GPUG Summit: Day 1 for a picture of the authors. Fellow MVP Mark Polino was as usual taking care of business and had some folks approaching him for his signature.

MVP and Author Mark Polino

Following the book signing, my wife and I headed outside of the Conference Center for some breakfast and were back to continue catching up on emails. I decided to give my slide deck a second pass just to make sure my timing was correct for the upcoming 3:00 PM session, GEN13: Where do the experts turn for answers?

I had the opportunity to attend Mark Polino and John Lowther’s session, GEN12: The Worst Mistakes you can make with Microsoft Dynamics GP. This session was fun and clearly a reminder of the things you should not do, unlike all other sessions stressing the things you should be doing.

After Mark’s session it was showtime. I headed over to my presentation room, got my computer setup and waited for attendees to show up. Surprisingly, I had some 20 attendees in the room with lots of questions on where to find resources on GP. Interestingly enough, most attendees were acquainted with the blogs, but are still slow to adopt other resources like Microsoft Dynamics Communities and the Partner Online Technical Community.

After my session, it was time to attend the Microsoft Town Hall meeting with members of the Product Management team and Microsoft Customer and Partner Management team.

Audience settling in for the Microsoft Town Hall meeting

During the session, attendees – Customers and Partners – asked the tough questions and at times put the panelists under the spotlight as it relates to features in upcoming releases, especially those related to Manufacturing and Project Accounting. The panelists reminded the attendees of the importance of Microsoft Connect as a tool to submit requests for product features.

Microsoft Town Hall meeting in course. Left to right: Bill Tattan, Pam Misialek, Chirs Lerum, Mark Albrecht, and Brian Meier, moderated by Kim Peterson

Things turned a little heated when the topic switched from product features to the panelists questioning the audience on their knowledge of the “Unleash your full Potential” program. This program was launched by Microsoft to help customers increase their utilization of their existing system functionality to help their business. Customers complained that partners did not inform them about the program and in some cases didn’t make them aware of existing promotions.

In turn, partners fought back by letting customers know that communication is a two way street and that they need to reach out when in need of new functionality. Some partners reminded customers that there is a fine line between being perceived as always selling something, versus working with customers to understand what else they can implement to complement their initial implementation.

My personal take is this: if you are a customer, you must work with your partner beyond your initial implementation to assess the maturity of your organization as it relates to the Microsoft Dynamics GP features you are using today. In turn, partners should have an honest dialog with customers about their capabilities and how they can help effect the changes needed by their customers. Both customers and partners should recognize their limitations and seek assistance from other organizations who can help closing the gaps.
After the meeting, I went back to my room and headed out to dinner to the Stratosphere Hotel with my wife. We both had a great time looking down to the city from the Top of the World restaurant, located on the 107th floor.

View of Las Vegas from the Top of the World restaurant

The Summit is almost coming to an end, so stay tuned for more.

Until next post!

Mariano Gomez, MVP
IntellPartners, LLC

Continue Reading:
GPUG Summit: Day 2

November 11, 2011 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 532

Everything Dynamics GP #45

GPUG Summit, and GP Partner Connections have been the highlights this week. Check out detailed posts with Pictures from Mariano Gomez, highlights from Mark Polino, Christina Phillips and Jon Rivers.

MSDynamicsWorld has details about the Share My Code Initiative by GPUG.

Now you can subscribe to Everything Dynamics GP via email

GPUG Summit and GP Partner Connections






Other Interesting Stuff

Dynamics GP Videos of the Day

Jivtesh (Microsoft Dynamics GP MVP)
Microsoft Dynamics Certified Technology Specialist: GP 2010
Have any GP related questions ? Feel free to email me at Jivtesh AT
Blog :
GP Help Website : (Over 10,000 Dynamics GP Resources)

Visit link:
Everything Dynamics GP #45

November 11, 2011 · Jivtesh Singh · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 784

Reconciling Inventory, what really happens?

I’ve seen this question come up a couple of times lately, even here at the GPUG 2011 Summit. I have some good information about the details of the inventory reconciliation process so I thought it might help to pass it along to everyone.

The Inventory files involved in the reconcile are:

  • Purchase Receipts (IV10200)
  • Purchase Receipts Detail (IV10201)
  • Item Master (IV00101)
  • Item Serial Number Master (IV00200)
  • Item Quantity Master (IV00102)
  • Item Lot Number Master (IV00300)
  • Item Vendor Master (IV00103)
  • Inventory Transaction Amounts Work (IV10001)
  • Inventory Serial and Lot Numbers Work (IV10002)
  • Item Site Bin Master (IV00112)
  • Inventory Transaction Bin Quantities Work (IV10003)
  • Inventory Transaction Bin Quantities History (IV30302)

Additional files outside of Inventory are involved in the reconcile if modules Purchase Order Processing, Sales Order Processing, or Invoicing are loaded.

The files outside of inventory that may be involved are as follows:

  • Purchase Order Line (POP10110)
  • Purchasing Receipt Line Quantities (POP10500)
  • Sales Transaction Amounts Work (SOP10200)
  • Sales Serial/Lot Work and History (SOP10201)
  • Invoicing Transaction Amounts Work (IVC10101)
  • Invoicing Serial and Lot Number Work (IVC10102)

The Reconcile process goes like this:  

  1. The quantities are reconciled first between the Purchase Receipts and the Item Serial Number Master file.
  2. Then the Purchase Receipts and Item Lot Number Master files are reconciled.
  3. At this point, the quantities are reconciled between the Purchase Receipts file and Item Quantity Master file
  4. Reallocating of Inventory Transaction Amounts Work, Inventory Serial and Lot Numbers Work, Sales Transaction Amounts Work, Sales Serial/Lot Work and History, Invoicing Transaction Amounts Work and Invoicing Serial and Lot Number Work tables is done next.
  5. The On Order quantities are determined for the Item Quantity Master and Item Vendor Master tables by comparing them to the Purchase Order Line and Purchasing Receipt Line Quantities tables.
  6. The last step in the reconcile is to reconcile the quantities on each of the items’ individual quantity location records to the total quantity record for that same item.

This information is avaialble in Article ID: 874220.

I hope this is helpful!

Until next post!

Leslie Vail

View the original here:
Reconciling Inventory, what really happens?

November 11, 2011 · Leslie Vail · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 1,264

Copy Microsoft Dynamics GP Live Company To Test Automatically

Backing up the a Microsoft Dynamics GP company to test is, unfortunately, not as simple as backing up one database and restoring it to the Test one. There are two scripts which need to be run after doing so; the … Continue reading

Read More:
Copy Microsoft Dynamics GP Live Company To Test Automatically

November 11, 2011 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 600