Workshop: GP 2013 – Take Microsoft Dynamics GP & Microsoft Office to the Next Level

Please find the details of the ” GP 2013 – Take Microsoft Dynamics GP & Microsoft Office to the Next Level ” workshop below.

View the original here:
Workshop: GP 2013 – Take Microsoft Dynamics GP & Microsoft Office to the Next Level

July 21, 2014 · Sivakumar V · No Comments
Tags: , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 92

Workshop: GP 2013 – Getting Better KPIs with Business Analyzer

Please find the details of the ” GP 2013 – Getting Better KPIs with Business Analyzer ” workshop below.

See more here:
Workshop: GP 2013 – Getting Better KPIs with Business Analyzer

July 21, 2014 · Sivakumar V · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 93

GP 2013 – Better Reporting with Dynamics GP 2013 – TechNet Blogs

This blog is managed by the Microsoft Dynamics North Americal Partner Technical Services team. It aims at providing highest quality of service to partners in the ERP and CRM solutions from the Microsoft Dynamics family to …

Original post:
GP 2013 – Better Reporting with Dynamics GP 2013 – TechNet Blogs

July 21, 2014 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 71

Workshop: GP 2013 – Overview of Project Accounting

Please find the details of the ” GP 2013 – Overview of Project Accounting ” workshop below. Agenda Project Setup  Projects & Contracts Types of Projects Transaction Processing Timesheets Expenses Different Types of Fees Billing Process Revenue Recognition Process PDK Module Setup and Maintenance Timesheets & Expense Approvals PS Time & Expense in Business Portal Session Duration 120 mins Advisory Hours Used 5-6 hours Target Audience Business Decision Makers End Users If you are interested in any of the workshops mentioned above, click here

Continue reading here:
Workshop: GP 2013 – Overview of Project Accounting

July 21, 2014 · Sivakumar V · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 134

SmartView – exporting to Excel from GO

This is really simple, but for those of you that wait for data to export to Excel – it is really cool.
Check out how long it to pull my data to screen and then get it to Excel.

Martin

Read More:
SmartView – exporting to Excel from GO

July 21, 2014 · Martin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 98

Customising the Company Login window series Part 2 – Visual Basic for Applications

David Meego - Click for blog homepageFollowing on from my previous post: Customising the Company Login window series Part 1 – Introduction, here is the method to create a solution using Visual Basic for Applications (VBA).

As discussed in the earlier post, the problem we are trying to overcome is that the company drop down list on the Company Login window is not wide enough to show a long company name. This can make it difficult to select the correct company when the company names are long and differ only by some characters at the end of the name.

Below is a screenshot of the original window from Microsoft Dynamics GP 2013. 

 

Following are the step by step instructions on how to use Visual Basic for Applications (VBA) code to “modify” the window:

  1. Load Microsoft Dynamics GP and get the Company Login window showing (either on first login or by switching companies after login). 
     
  2. Now that the window is open we need to add it to Visual Basic, but as the window is modal we cannot use the menus. So press the keyboard shortcut Ctrl-F11 to add the window.
     
  3. Then we need add the fields to Visual Basic. Press the keyboard shortcut Shift-F11 to enter selection mode (note the cursor changes). Now click on each of the fields on the right hand side (including the checkbox). Once all fields have been added, press Shift-F11 to exit selection mode.
     
  4. Now that the resources have been added to Visual Basic, we can start writing the code needed. Press Alt-F11 to open the Visual Basic Editor.
     
  5. Best practice is to require variable declaration, so select Tools >> Options and make sure the Require Variable Declaration option is checked and click OK.
     
  6. On the top left of the Visual Basic Editor is the Project Explorer window which will have a list of application dictionaries installed in Microsoft Dynamics GP (if the window is not showing press Ctrl-R). Locate the Microsoft_Dynamics_GP project and expand the tree to show the Microsoft Dynamics GP Objects and double click on the CompanyLogin (Window) to open the script editor.
     
  7. From the resources drop down list (directly above the script editor on the left hand side), select Window. From the event drop down list (on the right hand side), select BeforeOpen (if not already selected). This will generate the declaration for the Window_BeforeOpen() event.
     
  8. Now we can add the code to move the left hand edge of the fields to the left and increase the field widths to fill the space created (except for the numeric fields). Using a variable makes it easier to tweak the changes to meet your requirements. The maximum adjustment that fits nicely in the window is 230 pixels. The code for this customisation is shown below.
     
  9. Finally, select from the Visual Basic Editor’s menus select Debug >> Compile Microsoft Dynamics GP and File >> Save Microsoft_Dynamics_GP.
     
  10. Now you can re-open the Company Login window to see your changes. If you want to tweak the adjustment, change the value, recompile, save and test again. Close the Editor when you are finished.

 

Here is a screen shot of the window with the full 230 pixel adjustment: 

 

Below is the code used:  

Company Login Code

Option Explicit

Private Sub Window_BeforeOpen(OpenVisible As Boolean)
    Dim Adjust As Integer
    Adjust = 230
   
    Company.Left = Company.Left – Adjust
    Company.Width = Company.Width + Adjust
    Rememberthiscompany.Left = Rememberthiscompany.Left – Adjust
    Rememberthiscompany.Width = Rememberthiscompany.Width + Adjust
    Server.Left = Server.Left – Adjust
    Server.Width = Server.Width + Adjust
    UserID.Left = UserID.Left – Adjust
    UserID.Width = UserID.Width + Adjust
    CurrentUsers.Left = CurrentUsers.Left – Adjust
    ‘CurrentUsers.Width = CurrentUsers.Width + Adjust
    UsersAllowed.Left = UsersAllowed.Left – Adjust
    ‘UsersAllowed.Width = UsersAllowed.Width + Adjust
End Sub

 

 

The VBA package for this customisation is attached to the bottom of this article. You can use Tools >> Customize >> Customization Maintenance to load the package.

 

Thanks to Patrick Roth and Aaron Berquist for their feedback on this customisation.

Hope you find this useful and educational. 

David

View post:
Customising the Company Login window series Part 2 – Visual Basic for Applications

July 21, 2014 · David Musgrave · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 224

When things go wrong – Missing or Invalid Date on SOP Edit List

 

3d man holding stop sign

This error kept coming up at a client whom was using the Sales Document Consolidation product from Binary Stream.

As it turned out, the problem was because the DUEDATE field in the SOP10100 table was showing a value of 1900-01-01 00:00:00.000, that is not a valid date in the Dynamics GP SOP posting world. This situation came about because (as near as we could tell), the customer did not have a default payment term assigned to them.

If you get this error on your SOP Edit List, go take a look at that field.

Kind regards,

Leslie

Taken from:
When things go wrong – Missing or Invalid Date on SOP Edit List

July 18, 2014 · Leslie Vail · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 102