Error Tax amount is not receiving from PO Order to Receivable {Shipment/Invoice} Entry.

Hi All, hope all of you are good.

Today i am going to discuss about tax amount is not display from PO order to receivable transaction. Please follow the bellow work around.

Step1: Verify the Vendor with Tax Schedule ID:

Vendor

Step 2: Click on Tax Schedule ID details

Tax Schedule Detials

Step 3: Create a PO Order and once you entered all details, the Tax amount will automatically calculate as shown in below screen shoot. I want you to check the Purch Add Tax Sched which is in marked.

PO1

Step4: For Verification , please click on next to Tax amount arrow mark.

PO2

Step5: And by verifying in Item Detail Entry window we able to see the Purch Add Tax Sched details, please follow the below image.

PO3

Step6: Now click on action button to receive and Invoice PO Items.

PO4

Step7:  If we wanna verify the tax detail information then please click on Next to Tax amount Arrow mark verify the same tax schedule id is carry forwarded.

PO5

Here we go with all fine…… Please let me know if u have any comments and reviews i really appreciate it.

Advertisements
Posted in Uncategorized | Leave a comment

A get/change operation on table ‘Batch_Headers’ could not find a record.

Hi ,

Hope all of you good…..

As my today task i got an error like “A get/change operation on table ‘Batch_Headers’ could not find a record.” i was searching in google to complete the issue.

Some of blocks will help me on that …….Very small solution for this.

Please navigate the path: MS Dynamics GP–>Tools–>Maintenance–>Check links

By the open window we can select the series of module and process ,.

My issue has gone out.

Hope this will help you….

Thanks

Nizamudeen syed.

Posted in Uncategorized | Leave a comment

How to create New User with out login as user SA and create through Power user

Hi Guys ,

Today i completed one small and interesting task hope this will help you all.

Please check the user which is created without  login user as “sa”, we need to follow the steps to create new user.
1 ) For example i took the login details as  Nizam and logined in to GP. As Nizam is already a power user  in Dynamics GP.
2) Before creating New user without “sa” login , we need to follow one more step like go to the  Microsoft SQL Server Management Studio.
Now, proceed to assign the user login to the sysadmin role in SQL Server. Open Microsoft SQL Server Management Studio, open the Security folder, open the Logins subfolder.
 

 
3) Click the Properties  and select the  Server Roles page.And please check the “sysadmin“, click ok
4) Now please login in to  GP as anish user and Create New user and give Access,security and Roles to the New user.
Please let me know any queries .

Thanks

Nizamudeen

Posted in Uncategorized | Leave a comment

Microsoft Dynamics GP 2010 – Modified Dictionary Upgrade

Hi All,

By Reference of Sarah i have resolved issue.

https://community.dynamics.com/gp/b/dynamicsgp/archive/2013/04/11/modified-dictionary-upgrade

This link will help you out..:)

Thanks

Nizam

Posted in Uncategorized | Leave a comment

Error message when you try to log on to Microsoft Dynamics GP: “This login failed. Attempt to log in again or contact your system administrator”

The below link was helped my issue.

https://support.microsoft.com/en-us/kb/919345

Hope this will help you all.

Posted in Uncategorized | Leave a comment

Create a Customer in Dynamics GP 2010 using eConnect

A few days ago I created a simple example to create a vendor in Dynamics GP using eConnect. I received a few requests to show a sample integration to create new customers. Creating new customers in Dynamics GP via eConnect is a common request and usually proceeds the creation of other receivables documents.

The sample below creates a new customer using the eConnect .NET assembly and in-memory serialization.

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 Dynamics\eConnect 11.0\API\. (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();
                customer.CUSTNMBR = "TEST001";
                customer.CUSTNAME = "Test Customer";

                // Assign the customer to a new master customer type.
                RMCustomerMasterType customerMasterType = new RMCustomerMasterType();
                customerMasterType.taUpdateCreateCustomerRcd = customer;

                // Assign the master customer type to a new collection of master customer types.
                RMCustomerMasterType[] customerMasterTypes = { customerMasterType };

                // Serialize the master vendor type in memory.
                eConnectType eConnectType = new eConnectType();
                MemoryStream memoryStream = new MemoryStream();
                XmlSerializer xmlSerializer = new XmlSerializer(eConnectType.GetType());

                // Assign the master customer types to the eConnectType.
                eConnectType.RMCustomerMasterType = customerMasterTypes;

                // 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 customer {0}.", customer.CUSTNMBR);
            }
            catch (Exception ex)
            {
                Console.WriteLine("Exception occured: " + ex.Message);
            }
            finally
            {
                eConnectMethods.Dispose();
            }
        }

        Console.WriteLine("Integration test complete." +
                           Environment.NewLine +
                           Environment.NewLine);
        Console.WriteLine("Press <Enter> to continue...");
        Console.ReadLine();
    }
}
Execute the project and you should see the following output:

And you should see the vendor created in Dynamics GP:

Refence by 

Posted in Uncategorized | Leave a comment

Adding DrillDown Option in SSRS Report

PLease check it up below link ,it will help you ,how to add Drill Down Button in SSRS.

Hope you enjoy with this.

Posted in Uncategorized | Leave a comment