Mark Polino's Blog, page 328

August 29, 2011

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.



 •  0 comments  •  flag
Share on Twitter
Published on August 22, 2011 11:00

Microsoft Dynamics GP: One Key To Rule Them All | azurecurve

azurecure extols the virtues of Microsoft Dynamics GP help in One Key To Rule Them All .



 •  0 comments  •  flag
Share on Twitter
Published on August 22, 2011 09:00

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.



 •  0 comments  •  flag
Share on Twitter
Published on August 22, 2011 08:00

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.



 •  0 comments  •  flag
Share on Twitter
Published on August 22, 2011 06:00

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!



 •  0 comments  •  flag
Share on Twitter
Published on August 18, 2011 10:00