Page 1 of 4312345678910...2025303540...Last »

CBM Cash Receipt Customer GL Posting Account Error

A user reported this issue when he tried to enter a cash receipt in CBM module. Following error message prevented him from continuing further.

Screen Shot 2015-02-23 at 3.10.24 PM

This error was confirmed to be happening only for one particular customer record. For all other customers, it worked.

We basically do not have posting accounts setup for each customer or customer class. So it is absolutely no way due to missing posting accounts. Several minutes later, decided to compare customer records between this particular customer and one other customer that’s working.

REASON: Customer Class ID for this customer record was wrong and was not part of the list of customer classes that we have setup on our company. Because this class ID was wrong, posting accounts validation stopped right there and threw a message that was totally irrelevant to actual reason.

RESOLUTION: I changed the customer class ID for this customer with an existing one. User could then enter a cash receipt in CBM.

Troubleshooting issues successfully is probably the best way to end a business day!

VAIDY

Filed under: #MSDYNGP, Cashbook, CBM, Troubleshooting

Continue reading here:
CBM Cash Receipt Customer GL Posting Account Error

February 23, 2015 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 20

SQL view for total payments to 1099 vendors in the prior year

We received several requests just yesterday for a listing of total vendor payments in the prior calendar year. Below is a view that will show the total payments in the prior year for all 1099 vendors. This is not necessarily meant to match the report that comes out from the Print 1099 window, rather this is total payments for […]

View article:
SQL view for total payments to 1099 vendors in the prior year

January 20, 2015 · Victoria Yudin · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 19

Microsoft Dynamics GP backups with Windows Azure Blob Storage Service – Follow up

As a follow up to my post yesterday (see Microsoft Dynamics GP backups with Windows Azure Blob Storage Service), an issue has been identified with Microsoft Dynamics GP 2015 running on SQL Server 2014 when choosing Microsoft Azure storage as the destination for the backup.

You will receive the following warning message:

The SQL Server version that you are using does not support backing up or restoring your database from Microsoft Azure storage.

I have traced the issue back to the logic in the ‘(L) RGRestoreBackupOption’ of window BackupRestore of form syBackupRestore field change script, which seems to compare the build number even after it has determined the version number is greater than SQL Server 2012 SP1 CU2 (11.0.3339). Of course, the build number for SQL Server 2014 CU4 is 12.0.2430. Since 2430 is not greater than 3339, the script sets the validation flag to false, causing the script to abort with the message indicated above.

This problem is exclusive to Microsoft Dynamics GP 2015 RTM (14.00.0524) running on SQL Server 2014, and cannot be replicated if you are running Microsoft Dynamics GP 2013 R2 or Microsoft Dynamics GP 2015 on SQL Server 2012 SP1 CU2 or greater. Microsoft is currently aware of this situation (at least via the Dynamics GP Online Partner Technical Community Forum), but if you are

For more information on SQL Server 2014 build numbers, see Microsoft Support kb article 2936603, SQL Server 2014 build versions.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

View article:
Microsoft Dynamics GP backups with Windows Azure Blob Storage Service – Follow up

December 15, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 47

Microsoft Dynamics GP 2015 Developer’s Preview: Dexterity Service Patterns – Part 5

In my previous article (see Microsoft Dynamics GP 2015 Developer’s Preview: Dexterity Service Patterns – Part 4), we discussed the merits of the Wrapped Window pattern and how it can save time by avoiding refactoring of complex business logic embedded on Dexterity forms. I also provided an intro on the Decoupled Logic pattern and why this is the preferred method for exposing Dexterity services as it provides the best performance. However, we also came to the conclusion that refactoring is only feasible in cases where decoupling the business logic from the UI will yield a reasonably increase in performance, without negatively impacting development and product release timelines.

We also looked into the Decoupled Logic pattern considerations and today we will accompany these with sample code to clarify the meaning of each.

Decoupled Logic Considerations

  • In decoupled logic mode, there is no implicit data types validation or conversion. Unlike the Window Wrapped pattern where the map statement manages casing, signed versus unsigned precision, and nulls during the binding of window fields to our instantiated class properties; in the Decoupled Logic pattern we must perform all the conversion and validations.

     

  • Check for valid value for decimals
(Click to enlarge)
     

  • Check for a valid value for a drop-down or radio group
(Click to enlarge)

     

  • Force strings to upper case as needed, for example, items, customers, vendors, etc. (see first example).
  • Set default values as needed as user may pass a null value as a parameter to a service procedure

    

There you have it! Working with services and .NET interop is quite frankly not that complicated so long you understand the patterns and some of the rules governing them. So finally, we will put this all together in a final installment that will complete this series.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

See the original post:
Microsoft Dynamics GP 2015 Developer’s Preview: Dexterity Service Patterns – Part 5

December 2, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 54

Working with Dex.ini Settings to customize the Microsoft Dynamics GP Connect gadget

I take a pause in my Microsoft Dynamics GP 2015 Developer’s preview series to bring something fun before the Thanksgiving holiday here in the United States. Hopefully you find this trick very cool and enjoy it in your workplace.


Have you ever wanted to wake up with The Dynamics GP Blogster page as the centerpiece of your Microsoft Dynamics GP application homepage? Or how about your favorite online news outlet? What if you just want to display your company web page or an intranet portal to allow employees to update their information or view the latest company news?

Today I will show you how to take advantage of two obscure Dex.ini settings to customize the Connect gadget.

The standard Connect gadget displays Microsoft Dynamics Community news and updates, but there are two Dex.ini keys used to enable runtime debugging of the Connect gadget. One of the Dex.ini keys turns on the debugging feature and the other allows you to specify a URL to be displayed. The keys are:

DebugConnect=TRUE
ConnectTestURL=http://dynamicsgpblogster.blogspot.com

If you add these two keys to your Dex.ini file and re-launch Microsoft Dynamics GP the result will jump right at you.

Customized Connect Gadget

I also noticed that if the customized URL contains videos, these will play fine within the Connect gadget. How about that for some educational YouTube videos from the Microsoft Dynamics Channel? I tested it in the Web Client and it also worked just fine.

Please send in your comments as I would like to hear how you plan to use these new settings. Also remember, if you are using the Support Debugging Tool, you can roll out the settings to every user without having to visit their workstations.


Take a look at the following related articles:

Working with the Dex.ini Settings in Microsoft Dynamics GP 2013
More DEX.INI Settings!

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

Original post:
Working with Dex.ini Settings to customize the Microsoft Dynamics GP Connect gadget

November 26, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 61

AX 2012 Sales and Marketing (CRM)

Please find the details of the “AX 2012 Sales and Marketing (CRM)” workshop below. Agenda Sales Management Prospects management Leads and Opportunities Case Management Sales order processing Session Duration 2 hours Advisory Hours 5 Hours Target Audience Business Decision Makers End Users

Read the original:
AX 2012 Sales and Marketing (CRM)

November 10, 2014 · Parinitha V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 35

GPUG Summit 2014 St. Louis – Wrap Up!

Wrap Up Post

It’s time to close this chapter, but not without a few thoughts:

1. The Summit keeps attracting more and more attendees each and every year. This year, we maxed out at around 3,500 people which is quite a feat if you put it in perspective. My gut feeling tells me in a couple years we will be talking Convergence numbers and this will be mostly end-users!

2. I feel the Summit could take advantage of repeat sessions, similar to Convergence. Many topics were too similar in title and content, which could confuse the end-user when selecting a session to attend, given that each presenter (and presenter style) is different.

3. There aren’t enough parties! Rock-n-Rave and FastPath alone cannot entertain 3,500 people — on another note, after seeing Andy Snook rock the bass at the PBR St. Louis, I’m convinced that we could take advantage of a stadium or arena to make something big.

4. It’s cool to hang out with Polino. They guy simply knows when to relax and have fun! I wish he rode the bull at PBR. That would have been quite the show.

Coverage from the previous days can be found using the links below:

GPUG Summit 2014 St. Louis – Day 3
GPUG Summit 2014 St. Louis – Day 2
GPUG Summit 2014 St. Louis – Day 1
GPUG Summit 2014 St. Louis – Academy Training
Partner Connections 2014 Kicked Off a Great Summit
GPUG Summit 2014 St. Louis – The Journey Begins

Downloads

You can download the presentation materials for my sessions (including the session I did with Kitty Geiger on Modifier with VBA) from OneDrive using the following link:

http://1drv.ms/1rbF97W

See you in Fargo, North Dakota in November for reIMAGINE 2014. I will co-presenting with Kevin Racer on some GP 2015 Service Based Architecture stuff and with David Musgrave on the Support Debugging Tool. You will not want to miss any of this action.

Until next post!

MG.-
Mariano Gomez, MVP
Intelligent Partnerships, LLC
http://www.intelligentpartnerships.com/

More:
GPUG Summit 2014 St. Louis – Wrap Up!

October 22, 2014 · Mariano Gomez · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 65