Mark Polino's Blog, page 328
August 29, 2011
Quick Tip: Using eConnect to update Customer or Vendor Addresses with a blank Address Line 3 - Developing for Dynamics GP
Davis Musgrave gives us a Quick Tip: Using eConnect to update Customer or Vendor Addresses with a blank Address Line 3.








Mohammad R. Daoud: Inventory Reset Utility– HITB Did not match Staging Report and actual GL Journals!
Mohammad Daoud continues his POP and Inventory work with a look at the Inventory Reset Utility– HITB Did not match Staging Report and actual GL Journals!








August 22, 2011
SQL Script – Orders Needing Purchase « Real Life Dynamics User
Real Life Dynamics User gives us a new SQL Script with details on Orders Needing Purchase « Real Life Dynamics User.








When It's Time to Upgrade an Outdated, Customized Microsoft Dynamics GP System…Who You Gonna Call? | MSDynamicsWorld.com
New at MSDynamicsWorld.com, Mariano busts a few ghosts looking at When It's Time to Upgrade an Outdated, Customized Microsoft Dynamics GP System…Who You Gonna Call?.








Microsoft Dynamics GP: One Key To Rule Them All | azurecurve
The Creation of the Support Debugging Tool - Developing for Dynamics GP
Speaking of the Support Debugging Tool, David Musgrave takes a look at The Creation of the Support Debugging Tool.
I still maintain that there were alien's involved and that all of David's hard work built on their core technology but hey, what do I know.








Support Debugging Tool Customization #6 – Removing Voided Documents from Customer Statement | Interesting Findings & Knowledge Sharing
Sivakumar continues to use the Support Debugging Tool in interesting ways. This time he's Removing Voided Documents from Customer Statement.








Weekly Dynamic: Dealing with Leading Zeros in Excel
When working with Dynamics GP it's common to need to import information from other systems. Typically this is an extract from some other system into a comma separated values (CSV) file. Then an integration tool like Integration Manager is used to import the file into Dynamics GP.
The most common problems with this process happen when the source properly includes leading zeros. So a vendor ID for example might be 0001234. What happens is that a user opens the CSV to validate the information or adjust the file using Microsoft Excel. When the file is opened in Excel, the leading zeros get removed and users end up with a vendor ID like 1234.
So assuming that the source file does include the leading zeros, how does someone ensure that the leading zeros stay intact when working with the file in Excel?
Rename CSV file so it has a TXT extension. This tells Excel to trigger the Excel Import Wizard. Within Excel, open the TXT file. You may need to use the the 'Files of Type' drop-down list at the bottom of the dialog box, indicate that you want to open Text Files (*.prn; *.txt; *.csv). . Excel starts the Text Import Wizard, displaying the Step 1 of 3 dialog box. Check Delimited and Next to move to step 2. Select Comma as the delimiter and click next to move to step 3. At the bottom of the dialog box, click on the field that has leading zeros. The entire column should now be selected. In the Column Data Format area, make sure the Text radio button is selected. Repeat steps 6 and 7 for any other fields that have leading zeros. Click on Finish. Your file is imported, with leading zeros still intact.While there may be other ways to trigger the Excel Import Wizard this one works every time.








Friday Fun: Tax Court: Accountant Cannot Deduct Bathroom as Home Office
August 18, 2011
Dynamics GP Land: Sherlock Holmes I Am Not- Finding Missing Deductions and Benefits
I'm liking Christina's mystery themed posts like her new one Sherlock Holmes I Am Not- Finding Missing Deductions and Benefits.
However, if we get to Murder on the Dynamics GP Express I'm outta here!







