This has been on my list of things to blog about – but when I saw this post in the Forums, I knew its time had come: I have a client who is attempting to create a Sales report which shows sales by Customer. They want the report to include a separate column for each month – based on Document Date. I have attempted to create a calculation for each month (If/Then) but either don’t have the syntax correct or it is truly not going to work. CASE WHEN Sales Transaction History:Document Date > 1/1/2017… Any ideas????? This is something that seems to have become a very popular request in the last few years and I have always coded it in SQL Continue reading →
As many of you are aware Microsoft Dynamics GP 2010 was released to market in May 2010. The product has been extremely well received by analyst, partners, and most importantly, our customers! Please review and leverage the following upgrade resource kit and put your plans in place to promote upgrades within your customer base Continue reading →
Recently I was working on a customer request to print tax details on sales documents like Orders/Invoices. On doing some analysis I was able to get it done with some help from my friend David Musgrave. I have… Continue reading →