Microsoft Dynamics GP Web Client Training – Last Chance to get registered for classes at the end of the month in Fargo!

Now Accepting Partner Advisory Hours as Payment

We will offer another session each of the Microsoft Dynamics GP Web Client for Functional Consultants and the Microsoft Dynamics GP Web Client for Implementation Consultants classroom training sessions in Fargo on
April 29-30 and May 1-3 respectively.

 

NEW!

For these sessions, partners have the option of selecting Partner Advisory Hours (PAH) as a payment method.  We will apply PAH at the rate of 1 Partner Advisory Hour per 2 hours of training, or a partner would need:

  • 8 PAH available to complete payment for the 2-day Functional Consultant Workshop (or, $799 via standard payment options)
  • 12 PAH available to complete payment for the 3-day Implementation Consultant workshop (or, $1,299 via standard payment options)

This new payment option will apply only to the GP Web Client Courses. We will not be able to accept partial payment via PAH.  If a partner does not have sufficient PAH available to cover the cost of the workshop(s), they must pay via standard methods.

Action requested:

If you’re thinking about attending, please register today as the classes are nearing capacity.  Time is limited and space is limited to attend!  

Agendas for the classes can be found at: https://mbs.microsoft.com/partnersource/worldwide/northamerica/training/instructorlead/gpwebclient.htm

Jay Manley

Read more here:
Microsoft Dynamics GP Web Client Training – Last Chance to get registered for classes at the end of the month in Fargo!

April 17, 2013 · Jay Manley MSFT · No Comments
Tags:  · Posted in: Blogs I Follow Total Views: 411

Convergence Attendees: Continue the Learning!

Now that you’ve returned from Convergence 2013, be sure to continue the learning! In addition to viewing the session downloads and recordings, extend the value of your Convergence attendance by leveraging the enhanced learning opportunities that are available with online Hands on Labs. To take the labs, all you need is your computer, so set aside some time during your day – or night! – for this informative, hands on training.

To get started, log into the secure portion of the Convergence website (using the same login credentials as when you registered for the event–either your username and password OR our Microsoft account), and navigate to Schedule Builder; search by session type “Hands on Lab”. You can also filter by product to drill down even further. When you’ve found the lab you want to take, launch the lab by clicking on “View Lab”.

More here:
Convergence Attendees: Continue the Learning!

April 17, 2013 · Pam Misialek · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 162

Updating the ‘Display in Lookups’ selections on the Account Maintenance window

 

You may have noticed that Integration Manager does not let you choose the individual selections for the ‘Display in Lookups’ field on the Account Maintenance window. It’s either all on, or all off. I used to use Table import to set the flags, but there is a much better way.

My thanks goes out to Tim Hickey of ConexusSG for showing me how to update this field using SQL. So much easier than table import.

Since the field GL00100.DSPLKUPS is a binary field, Tim converted the values for the multi-select list box to binary. He then used the corresponding value in a SQL UPDATE statement. Now, all of his clients (and you) can easily take advantage of this power feature in General Ledger.

For example, if you wanted to set the Payroll accounts to display only in the payroll module lookups (option 9), you would write something like this:

UPDATE GL00100
SET DSPLKUPS = 0X8
WHERE ACCATNUM in (39,36)

Take another look at your chart of accounts, and use this feature to help speed up account selection. The table below has every option you can choose for the ‘Display in Lookups’ field, along with the correct SQL value.

Enjoy!

Option

Image

SQL

Binary

1

clip_image0014

0X0

0000

2

clip_image0024

0X1

1000

3

clip_image0034

0X2

0100

4

clip_image0044

0X3

1100

5

clip_image0054

0X4

0010

6

clip_image0064

0X5

1010

7

clip_image0074

0X6

0110

8

clip_image0084

0X7

1110

9

clip_image0094

0X8

0001

10

clip_image0104

0X9

1001

11

clip_image0114

0XA

0101

12

clip_image0124

0XB

1101

13

clip_image0134

0XC

0011

14

clip_image0144

0XD

1011

15

clip_image0154

0XE

0111

16

clip_image0164

0XF

1111

See more here:
Updating the ‘Display in Lookups’ selections on the Account Maintenance window

April 16, 2013 · Leslie Vail · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 220

Where is my Custom Reminder window to add reminders to my GP home page?

I was reported with a very vague issue: user could not create a custom reminder from a smartlist. He received an error message as follows:

Snip20130417_3

Basically, below is the window which user is trying to open:

Snip20130417_4

Ideally, you would think that this window is a part of Microsoft Dynamics GP dictionary. But it is NOT. It is a part of Smartlist dictionary.

But trick here is, you cannot see this window listed on when you try to assign this window a particular Security Task using Security Task Setup window. Then, how? How would I give access to this window?

After around an hour or so, with several script logs and profilers misleading me, I found one interesting statement on SQL Profiler trace, that was executed when the user tried opening that window:

Snip20130417_6

Exactly after this SQL statement, the above error message was thrown at the user. Which means, I must focus my troubleshooting efforts on this table; DYNAMICS..SY10000. This table is simply called User Security.

When user tried to open Custom Reminder window, system checked this table and see whether this user has got access to a window whose resource ID is 1452 in dictionary 0 (which is nothing but product Microsoft Dynamics GP) inside company ID 1 (which is my production GP company).

I was always thinking about something in Smartlist (which is, without any doubt), but system was checking something else in a different dictionary altogether. I wanted to see the window in Microsoft Dynamics GP dictionary which is of resource ID 1452. Opened the DYNAMICS.DIC on Dexterity and checked it, only to realise with disbelief that it was referring to following window:

Snip20130417_7

I did not understand first. Why would it check something totally irrelevant from what user wanted to open? Why would it check access to this window, when opening a window in different dictionary? I have no answer to these questions.

But I just thought I would take a chance. I checked this user’s security task setup and found that Reminders window was not assigned. I assigned that window for this user as shown below:

Snip20130417_8

Tested whether he could open Custom Reminder. To my utter disbelief, IT DID.

So, if somebody is facing same issue and has already lost almost all your hair, here you have, a solution that would bring upon peace.

VAIDY

Read More:
Where is my Custom Reminder window to add reminders to my GP home page?

April 16, 2013 · Vaidyanathan Mohan · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 234

Tech Tuesday – SmartConnect Key Fields and Grouping

One of the most important steps to setting up an integration in SmartConnect is ensuring that the correct key fields are set and the proper grouping is done.

Key fields needs to be added in on every map when setting up the data source, these fields are used by SmartConnect to break up the data into different records that it sends through to eConnect. SmartConnect does not look at the original source to determine the keys – it only cares about what is setup in the key fields section.

An example below shows how we broke up a GL Entry map into different records. There wasn’t a journal number in the source, so the batch ID and GL Reference were the fields used to break up the data. This setup will cause every unique combination of batch ID and reference to create a separate document/record that is sent through to eConnect.

 
An easy way to test whether the grouping and key fields are setup correctly is to change the destination to GP – File and run the map. The map will then create one xml file per record – which is determined based on the key fields. If one of those files are opened up, there should be one occurrence of the header node and possibly multiple entries for the line nodes in the record.
 
Chris Hanson
Senior Technical Consultant

Read More:
Tech Tuesday – SmartConnect Key Fields and Grouping

April 16, 2013 · Abbey · No Comments
Tags: , , , , , ,  · Posted in: Blogs I Follow Total Views: 269

SOP User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Sales Order Processing.

Enjoy!

SALES ORDER PROCESSING

  1. How to modify the SOP Blank Invoice Form to display the total amount of the invoice in words in Microsoft Dynamics GP and in Microsoft Great Plains
    (917473 – modified: 2012-07-14)
    Describes how to modify the SOP Blank Invoice Form in Microsoft Dynamics GP and in Microsoft Great Plains to display the total amount of the invoice in words.
  2. How to change the date format on a Sales Order Processing report in Microsoft Dynamics GP
    (852554 – modified: 2012-06-27)
    Describes how to change the date Format on the Sales Order Processing reports in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains 8.0.
  3. How to add the “Customer Item Number” field to a quote, order, or invoice form in Sales Order Processing in Microsoft Dynamics GP
    (918943 – modified: 2012-07-14)
    Describes steps that let you print both the “Inventory Item Number” field and the “Customer Item Number” field. You must have access to Report Writer, and you may need the system password to grant security.
  4. How to print the difference between the list price and the unit price for items on Sales Order Processing order forms in Microsoft Dynamics GP
    (871675 – modified: 2012-07-14)
    Describes how to print the difference between the list price and the unit price for items on Sales Order Processing order forms in Microsoft Dynamics GP.
  5. How to create a Line Number field for the lines items on the SOP Blank Quote Form, on the SOP Blank Order Form, on the SOP Blank Invoice Form, on the SOP Blank Return Form, and on the SOP Blank Back Order Form reports in Microsoft Dynamics GP
    (857285 – modified: 2012-07-13)
    Describes how to create a Line Number field for the lines items on various reports in Microsoft Dynamics GP.
  6. How to add the customer e-mail address to the SOP Blank Order Form report or to the SOP Blank Invoice Form report in Microsoft Dynamics GP
    (874101 – modified: 2012-07-14)
    Describes how to add the customer e-mail address to the SOP Blank Order Form report or to the SOP Blank Invoice Form report in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains 8.0.
  7. How to add Internet information for an item to the “SOP Blank Invoice” form in Microsoft Dynamics GP
    (924538 – modified: 2012-07-14)
    Describes how to use the Report Writer module to modify the SOP Blank Invoice Form.
  8. How to use Report Writer to add the functional currency list price to the SOP Blank Invoice Form in Microsoft Dynamics GP
    (852962 – modified: 2012-06-27)
    Describes how to use the rw_ivGetFuncListPrice function script in Report Writer to add the list price of an item to the SOP Blank Invoice Form or other non-options forms in Sales Order Processing.

Continue Reading:
SOP User-Defined Functions for Report Writer

April 16, 2013 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 334

Receivables Management User-Defined Functions for Report Writer

 

We all know there is some really great things you can do with the Report Writer User-defined functions. Unfortunately they are not well documented.

What will follow is a series of posts where I will list all of the KB articles I could find include information about one of the RW functions in Report Writer.

The posts will be separated by module. This post is dedicated to Receivables Management.

Enjoy!

RECEIVABLES MANAGEMENT

  1. How to add the customer purchase order number to the Receivables Management Accounts Due Report in Microsoft Dynamics GP
    (856461 – modified: 2012-07-13)
    Describes how to add the customer purchase order number to the Receivables Management Accounts Due Report in Report Writer in Microsoft Dynamics GP and in Microsoft Business Solutions – Great Plains 8.0.
  2. How to suppress the Address 2 field and the Address 3 field in a report in Receivables Management for Microsoft Dynamics GP
    (853430 – modified: 2011-07-11)
    Describes how to suppress empty address line fields so that the City, State, and Zip fields print under the last line of the address.
  3. How to use Report Writer to print all seven aging periods on the RM Aged Trial Balance report in Microsoft Dynamics GP 9.0
    (933643 – modified: 2011-08-01)
    Describes how to print all seven aging periods on the RM Aged Trial Balance report in Microsoft Dynamics GP 9.0 and Microsoft Business Solutions – Great Plains 8.0.
  4. How to use the aging date to calculate the “Days Past Due” field on the RM Detail Historical Aged Trial Balance report in Microsoft Dynamics GP
    (856016 – modified: 2007-11-13)
    Describes how to use the aging date to calculate the “Days Past Due” field on the RM Detail Historical Aged Trial Balance report in Microsoft Dynamics GP.

Read More:
Receivables Management User-Defined Functions for Report Writer

April 16, 2013 · Leslie Vail · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 228