Excel VBA function to create a delimited file I use this if I have a spreadsheet of values in a row of cells and I want to turn that row into something I can use as a text import file. This article walks you thr...
This article started (as so many do) from a question posted on the newsgroup about how data flows through the system and how you can figure out what the tables contain. I did a little research and concluded there wasn’t any summary of data f...
So, you’ve changed banks and opened a new account. Now it’s time to create a new checkbook in GP and assign it as the default Checkbook ID. No problem, you’ve got this:Create a New GL AccountCreate a New Checkbook IDAssign the new Checkbook as the...
While preparing our annual 1099s, we had the need to change the name on the 1099 from the Vendor Check Name to an individual’s name. We use the name and social that match the name of the sole proprietor. While the new(ish) field on the Vendor Main...
I know, I know, we should all be using Management Reporter. News flash! Not everybody wanted to change if I could get FRx to print the reports with their new GP versions. Let’s face it, getting that software installed and getting all of your FRx r...
Things are going great this year and your company has decided to pay bonuses to all of the employees. YAY!So, how much should we withhold on the bonus? How should we set up that bonus pay in Dynamics GP? The first question you need to answer is wh...
I've finally updated the Dex.ini switch document on Box. If you want a copy, please download it here: https://app.box.com/s/xkgae2rz1vil1ap4o579Thanks to Redbeard for giving me the latest switch!
Our own Victoria Yudin has once again hit a home run with her view revealing unposted checks in Dynamics GP. She has solved the problem of the "... universally hated ..." Check Batch Edit List report. You can read her post, and get her c...
Below you'll find a list of additional tools available from Microsoft that are free for the downloading. This is a copy of the document displayed on Microsoft's web site. You will need access to Customer/PartnerSource in order to...
