Microsoft Dynamics GP

Forum Post: RE: Dynamics GP 10.0: Where is stored procedure documentation?

Andrew John Dean — Thu, 23 May 2013 05:05:00 GMT

Each GP table has a series of associated stored procedures that allow records to be selected, inserted and deleted. These stored procedures have prefix 'zDP' followed by the table name. There are some stored procedures that contain business logic however for the most part, the GP business logic is performed in the dexterity code.

The architecture of eConnect differs in that all the business logic is contained inside of the stored procedures however these procedures are encrypted. If you looking for these eConnect stored procedures have the prefix 'ta'. Although I have directly called the eConnect stored procedures for a past project where I needed to wrap GP function calls into a larger database transaction, I would not recommend it. Better option is a use the .NET library or web service.

Regards

Andrew Dean

Forum Post: RE: Create sales Invoice in GP

PriyaS — Thu, 23 May 2013 04:38:00 GMT

Hi Joseph,

Thanks for the reply.

I checked Dynamics GP Web Service Exception Console. I am getting the same validation exception in the console as well. It has no exception details.

Is it possible to get a sample code to create an invoice using web service.

Any help would be greatly appreciated.

Regards,

Priya

Forum Post: Dynamics GP 2013 Integration Manager GL Integration Fails

Richard Wheeler — Thu, 23 May 2013 03:26:00 GMT

I have the most basic of integrations. This one is into GL. This is my first integration using GP 2013 IM. The data resides in a SQL table and the structure of the records is:

TRXDATE, TRXAMNT,ACTNUMST

I created a header which is just SELECT DISTINCT TRXDATE from MyTable

then a detail which is SELECT TRXDATE, TRXAMNT,ACTNUMST

The query relationship is simply on TRXDATE

When I run the integration it appears to randomly decide not to import the distributions. The header will be there but the detail is missing. Half the transactions are fine and the other half are missing the distributions.

Do we have an issue with IM for GP 2013? I do not see a service pack. This integration could not be much simpler. I even tried creating a table with just the dates thinking maybe I have a record lock problem but it fails the same way. If there is no resolution using IM I will need to resort to VS but that will be a waste of time when IM is sitting right here.

Forum Post: RE: Cannot insert the value null into column Print_Phone_NumberGB table Two.db.SOP10200

John Lowther — Thu, 23 May 2013 03:17:00 GMT

What version of GP are you on?

I looked at the SOP10200 table in GP2010R2 and did not see a field named "Print_Phone_NumberGB"; however, I did not see a field anywhere in the table that did allow nulls. So, as just a guess, and I stress the "just a guess" part try adding the line "customerAddress.Print_Phone_NumberGB = "try different values here" and see if that helps.

Just a shot in the dark,

Forum Post: RE: Lookup function error in SSRS

John Lowther — Thu, 23 May 2013 03:03:00 GMT

Without digging into your SSRS report I am not really sure; however, I did notice that the first two objects in your lookup were the same "Fields!Item_Number.value" usually, or at least in the cases that I have seen they are different like "=Lookup(Fields!SaleProdId.Value, Fields!ProductID.Value, Fields!Name.Value, "Product")"

But then I could be totally off base, please let me know how it goes,

Forum Post: RE: Opening Smartlist Speed issue

John Lowther — Thu, 23 May 2013 02:50:00 GMT

Well, I am not sure what version of Microsoft Dynamics GP you are currently using. However, I have seen problems similar to this in the past.

Once I found the answer I posted SmartList & Table Scans, for everyone's benefit.

Hope this helps,

Forum Post: RE: Emailing documents from GP with Outlook 2010, Citrix XenApp

John Lowther — Thu, 23 May 2013 02:36:00 GMT

Sorry, Blog site moved since this post. Here is the new link ==> Multiple Users Sending Emails from a Single Email Account.

Forum Post: RE: GP 10 Memory Error

LuisJahn — Thu, 23 May 2013 02:22:00 GMT

After some investigation we found out that the memory error only appeared when we tried to select any of the custom payroll reports to export. So it was in fact a corrupt payroll dictionary.

Thanks for your help!

Forum Post: Customer Credit Limit Has Been Exceeded

jmawebtech — Thu, 23 May 2013 02:06:00 GMT

Hi,

I am trying to create sales orders for a customer. I receive an error that the customer credit limit has been reached.

I am using the API to create transactions. When creating a customer, how do I tell GP that the customer has an unlimited credit? Here is my code:

static void CreateCustomer()
{
CompanyKey companyKey;
Context context;
Customer customer;
CustomerKey customerKey;
Policy customerPolicy;

// Create an instance of the service
DynamicsGP wsDynamicsGP = new DynamicsGP();

// Be sure that default credentials are being used
wsDynamicsGP.UseDefaultCredentials = true;

// Create a context with which to call the service
context = new Context();

// Specify which company to use (sample company)
companyKey = new CompanyKey();
companyKey.Id = (-1);

// Set up the context
context.OrganizationKey = (OrganizationKey)companyKey;

// Create a new customer object
customer = new Customer();

// Create a customer key
customerKey = new CustomerKey();
customerKey.Id = "ADMINISTRATORGL";
customer.Key = customerKey;

//assign unlimited class

CustomerCreditLimit cc = new CustomerCreditLimit();
cc.Item = //what do I put into item?
cc.Period = 10;
cc.PeriodAmount = new MoneyAmount { Currency = "USD", DecimalDigits = 4, Value = 20000 };

customer.ClassKey = new CustomerClassKey { Id = "USA-ILMO-T1" };
// Set properties for the new customer
customer.Name = "Global Admin";
// Get the create policy for the customer
customerPolicy = wsDynamicsGP.GetPolicyByOperation("CreateCustomer", context);

// Create the customer
wsDynamicsGP.CreateCustomer(customer, context, customerPolicy);

}

Forum Post: RE: Import Orders

Frank Hamelly — Thu, 23 May 2013 02:02:00 GMT

A number of tools exist for importing orders - Dynamics GP Integration Manager, Scribe, eConnect, Smart Connect. If you need to import on a pre-defined schedule, any of the last three provide scheduling capability. Integration Manager requires an add-on called 'Auto-Dim' to schedule integrations.

Forum Post: MR 2012 RU5 Latest Hot Fix breaks GP Legacy Option

Richard Wheeler — Thu, 23 May 2013 00:39:00 GMT

After trying to apply the latest hot fix to MR 2012 RU5 I can now longer configure the GP Legacy Option. In the log file in this. What must I do to enable the GP Legacy option?

System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_IntegrationSourceID'. Cannot insert duplicate key in object 'dbo.ControlConfiguredIntegration'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Dynamics.Performance.Reporting.DataAccess.Design.ConfiguredIntegrationsDataSetTableAdapters.ConfiguredIntegrationTableAdapter.Insert(String SourceName, String SourceDiscriminator, Nullable`1 GLEntityID, String GLEntityConnectionInformation) at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.ConfiguredIntegration.<>c__DisplayClassd.b__c() at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 transact, Func`1 connect, Func`1 execute, Boolean retry) at Microsoft.Dynamics.Performance.Reporting.DataAccess.DataExecution`1.Execute[T](Func`1 connect, Func`1 execute) at Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService.<>c__DisplayClass2c.b__2b() at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.<>c__DisplayClass1f.b__1e() at Microsoft.Dynamics.Performance.Reporting.Security.Service.SecureServiceBase.SecureExecuteInternal[TResult](Func`1 hasPermission, Func`1 executor) at Microsoft.Dynamics.Performance.Reporting.Common.Service.ServiceBase.BaseExecute[TResult](Func`1 executor) Component: Microsoft.Dynamics.Performance.Reporting.DataAccess.Server.CompanyService

Forum Post: RE: Completed PO removal.

Richard Wheeler — Thu, 23 May 2013 00:36:00 GMT

Did anyone run Edit PO on this and change the status to Closed? The Remove Completed PO routine only moves completed POs to history. Since it was not invoiced it would not have been closed.

Forum Post: RE: Posted voided checks that were actually cashed

Frank Hamelly — Wed, 22 May 2013 22:48:00 GMT

You can't 'Unvoid' a transaction. You'll have to enter a new transaction, replacing the voided one. Are we talking payments to vendors? If so, then you need a record of the payment on the vendor account as well. I would use Manual Payments for this, which will allow you to enter the payment without creating a check and leavew the unapplied payment on the vendor account.

Forum Post: RE: Unhandled script exception error

Sanjay.Rajarao — Wed, 22 May 2013 22:39:00 GMT

Found a script to rebuild pm00400 table.

--**/ REBUILD PM00400 PM KEY MASTER

truncate table PM00400

if exists (select * from dbo.sysobjects t1, dbo.sysindexes t2

where t2.name = 'AK2PM00400'

and t2.id = t1.id