How To Install Business Analyzer for Microsoft … – azurecurve

View azurecurve’s Google+ · View azurecurve’s Summary RSS Feed · View azurecurve’s Detailed RSS Feed. Ramblings of a Dynamics GP Consultant. Skip to content. Home · azurecurve.co.uk · azurecurve.com · Browse…

Visit link:
How To Install Business Analyzer for Microsoft … – azurecurve

January 21, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 308

How To Install Microsoft Dynamics GP 2013 – How To … – azurecurve

View azurecurve’s Google+ · View azurecurve’s Summary RSS Feed · View azurecurve’s Detailed RSS Feed. Ramblings of a Dynamics GP Consultant. Skip to content. Home · azurecurve.co.uk · azurecurve.com · Browse…

Continued here:
How To Install Microsoft Dynamics GP 2013 – How To … – azurecurve

January 16, 2013 · Ian Grieve · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 300

Published at last! Developing Microsoft Dynamics GP Business Applications

 

0264EN_mockupcover_normal

If anyone has noticed my absence on the newsgroup, this is why. This book was published on Christmas Eve! – too late for Santa, but just in time for Valentine’s Day!

You can try out seven different development tools in this book. There’s a small project using each of the following:

  • Dexterity
  • VS Tools
  • Modifier
  • VBA
  • SmartList Builder
  • Extender
  • Drill-down builder

If you’ve ever wanted to dabble, now’s your chance to work a little bit with each tool. There’s no other publication like it that includes a little about so many different tools; I hope you enjoy it.

I want to thank my technical reviewers, Mohammad R. Daoud, Jivtesh Singh, Vaidhyanathan Mohan, and Frank Hamelly, for their valuable time, ideas, and insights. This is a much better, more complete book because of them and their willingness to help and advise me. How could I miss with that kind of talent backing me up?

The book was only supposed to be 300 pages, but 300 pages just wasn’t enough. Even at 600 pages, there’s so much more I wanted to add. Please let me know if you have any suggestions on how I can make the book better next time.

I look forward to getting back with the Community!

Kind regards,

Leslie

Read the original post:
Published at last! Developing Microsoft Dynamics GP Business Applications

December 28, 2012 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 202

Upgrade Paths to Microsoft Dynamics GP 2013

Microsoft Dynamics GP Support & Services blog has given the two direct upgrade paths, in case you are looking for: Upgrade Paths to Microsoft Dynamics GP 2013!

Quite crucial information that we must remember.

VAIDY

Visit site:
Upgrade Paths to Microsoft Dynamics GP 2013

December 25, 2012 · Vaidy Mohan · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 355

Voiding a partially applied Payables transaction in Dynamics GP

Periodically I get calls or see questions online about how to void a partially applied Payables transaction in Dynamics GP. This is one area where the Payables module differs drastically from the Receivables module and you have to jump through some hoops to actually accomplish this.

The issue is that when you go to void a partially applied Payables transaction you receive the following message:

Your only option here is to click OK. So is it possible to void a partially applied Payables transaction? The short answer is no. The long answer is that there is a workaround by following the steps below:

  1. Fully apply the transaction. (This might involve creating a ‘dummy’ invoice if there is nothing else to apply it to.)
  2. Void the now historical transaction. (And void the ‘dummy’ invoice if you had to create one.)

Below are details on these steps:

Step 1: Fully apply the transaction

In my example, I have a credit memo for $200 and $142.32 of it is still unapplied:

Let’s look at the more complicated option, where I do not have anything else open for this vendor and I need to void this credit memo. To be able to fully apply this credit memo, I first need to create a ‘dummy’ invoice for the unapplied amount on the credit memo:

  • Go to  Transactions | Purchasing | Transaction Entry
  • Select either Invoice or Misc Charge for the Document Type
  • Enter the Vendor and Doc. Date  (the date doesn’t much matter, as we will be voiding this a few steps down)
  • Enter the unapplied amount of the credit memo under Purchases (in my example, $142.32)
  • The GL distributions do not matter here either, as again, we will be voiding this, however you do want to make sure they are all there so there is no issue with posting this transaction

  • Post this transaction

Now you can fully apply the credit memo:

  • Go to Transactions | Purchasing | Apply Payables Documents
  • Select the Vendor
  • Click on the looking glass icon next to the Document No. at the top right and select the credit memo
  • Apply it to the invoice you just posted: 
  • Click OK to close the Apply window and now we’re ready for step 2:

Step 2: Void

Since the credit memo is now fully applied, it is in history. To void it:

  • Go to Transactions | Purchasing | Void Historical Transactions
  • Select the transaction, change the date(s) if needed, and Void:

Now the ‘dummy’ invoice is unapplied (and is thus Open), to void it:

  • Go to Transactions | Purchasing | Void Open Transactions
  • Select the Vendor and the ‘dummy’ invoice and Void

That should do it on the Payables side. Depending on your settings, you might have some General Ledger postings to complete from transactions this generated.

Now you have a reference for the steps to follow next time you have to void a partially applied Payables transaction in Dynamics GP.

Filed under: Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 8.0, GP 9.0 Tagged: Dynamics GP, featured, Payables

Continued here:
Voiding a partially applied Payables transaction in Dynamics GP

October 11, 2012 · Victoria Yudin · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 742

Create a Vendor in Dynamics GP 2010 with eConnect using In Memory Serialization

Developing several integrations between Microsoft Dynamics GP 2010 and various third-party systems the last few weeks reminded me to update my previous article on In Memory Serialization for eConnect 10.

Microsoft Dynamics GP 2010 uses eConnect version 11 which includes significant updates. Notably, the COM+ component has been changed to a WCF service.

In this example, I am creating a new vendor record in Dynamics GP using the same in memory serialization technique. Why write a file to disk unnecessarily?

To run the following code on your machine:

  1. Install the latest version of the eConnect 11 SDK.
  2. Create a new Console Application in Microsoft Visual Studio.
Add references to these dynamic link libraries which are located by default in C:Program Files (x86)Microsoft DynamicseConnect 11.0API. (Ignore the x86 if you are using a 32-bit system.)
  1. Microsoft.Dynamics.GP.eConnect.dll
  2. Microsoft.Dynamics.GP.eConnect.Serialization.dll
Replace the Program.cs class in the project for the new class below.

using System;
using System.IO;
using System.Xml;
using System.Xml.Serialization;
using Microsoft.Dynamics.GP.eConnect;
using Microsoft.Dynamics.GP.eConnect.Serialization;
 
class Program

    static void Main(string[] args)
    
        Console.WriteLine("Beginning integration test.");
 
        using (eConnectMethods eConnectMethods = new eConnectMethods())
        
            try
            
                Console.WriteLine("Creating a new customer.");
 
                // Modify the connection string for your environment.
                string connectionString = @"data source=localhost; initial catalog=TWO; integrated security=SSPI";
 
                // Create the customer.
                taUpdateCreateCustomerRcd customer = new taUpdateCreateCustomerRcd();
 
                // Assign the vendor to a new master vendor type.
                PMVendorMasterType vendorType = new PMVendorMasterType();
                vendorType.taUpdateCreateVendorRcd = vendor;
 
                // Assign the master vendor type to a new 
                // collection of master vendor types.
                PMVendorMasterType[] masterVendorTypes =  vendorType ;
 
                // Serialize the master vendor type in memory.
                eConnectType eConnectType = new eConnectType();
                MemoryStream memoryStream = new MemoryStream();
                XmlSerializer xmlSerializer = new XmlSerializer(eConnectType.GetType());
 
                // Assign the master vendor types to the eConnectType.
                eConnectType.PMVendorMasterType = masterVendorTypes;
 
                // Serialize the eConnectType.
                xmlSerializer.Serialize(memoryStream, eConnectType);
 
                // Reset the position of the memory stream to the start.              
                memoryStream.Position = 0;
 
                // Create an XmlDocument from the serialized eConnectType in memory.
                XmlDocument xmlDocument = new XmlDocument();
                xmlDocument.Load(memoryStream);
                memoryStream.Close();
 
                // Call eConnect to process the XmlDocument.
                eConnectMethods.CreateEntity(connectionString, xmlDocument.OuterXml);
 
                Console.WriteLine("Successfully created vendor 0.", vendor.VENDORID);
            }
            catch (Exception ex)
            
                Console.WriteLine("Exception occured: " + ex.Message);
            
            finally
            
                eConnectMethods.Dispose();
            
        }
 
        Console.WriteLine("Integration test complete." +
                           Environment.NewLine +
                           Environment.NewLine);
        Console.WriteLine("Press  to continue...");
        Console.ReadLine();
    }
}
Execute the project and you should see the following output:

And you should see the vendor created in Dynamics GP:

http://mbsguru.blogspot.com/atom.xml

Read the article:
Create a Vendor in Dynamics GP 2010 with eConnect using In Memory Serialization

October 5, 2012 · Bryan Prince · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 279

Dynamics GP Excel Paste–New version has been released

Yesterday we have released a new version of the Dynamics GP Excel Paste, it has many new features and enhancements, I am showing the main additions in this post:

1. One installation across all GL Versions: (GP 10.0, GP 2010, GP 2013), ALL Service Packs, all platforms (Windows XP, Windows 7, Windows Server), any CPU (64x, 32x).

2. Messages Handling: We left this option for end user to decide either to auto answer the dialogs or by manually handling answers:

image

Another message will be shown:

image

3. Added more free screens: we have allowed the paste over common objects across all companies, like Currencies, Users, Tasks and Roles.

4. Enhanced the connectivity to the internet: if you are running behind firewalls we been facing difficulties loading templates as your firewalls are blocking the outbound access to the SQL, by using an alternative to the 1433 port, currently the application automatically calls a web service using the default port and using default proxy settings to pass through firewalls and get the templates installed.

5. Enhanced the ability to paste into distribution windows: we found many issues pasting using Advanced Excel Paste into “Distribution Windows”, issue have been resolved and you can paste safely:

PM Transaction Entry with Distribution

Regards,

Mohammad R. Daoud MVP – MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 – 79 – 999 65 85
me@mohdaoud.com
http://www.di.jo

Read more here:
Dynamics GP Excel Paste–New version has been released

October 4, 2012 ·  · No Comments
Tags: , , , , , , ,  · Posted in: Blogs I Follow Total Views: 263