DynDeveloper.com

This article discusses this error:

Error Number = 67 Stored Procedure= taSopHdrIvcInsert Error Description = Subtotal does not match the line item totals

Node Identifier Parameters: taSopHdrIvcInsert

SOPNUMBE = ORD0000025

SOPTYPE = 2

Related Error Code Parameters for Node : taSopHdrIvcInsert

SUBTOTAL = Note: This parameter was not passed in, no value for the parameter will be returned.

The definitive discussion about what causes this error

Sql procedure error codes returned:

Error Number = 299 Stored Procedure= taSopLineIvcInsert Error Description = Unit Price calculation does not match out to Extended price
Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = ORDST2226
SOPTYPE = 2
LNITMSEQ = 16384
Related Error Code Parameters for Node : taSopLineIvcInsert
SOPTYPE = 2
QUANTITY = 4.00000
UNITPRCE = 135.20000
MRKDNAMT = Note: This parameter was not passed in, no value for the parameter will be returned.
XTNDPRCE = 676.00000

This article contains code to retrieve a PO document using Web Services for Dynamics GP 2015

Today we'll look at how to create a new SSRS report from scratch using one of the standard views that ship with Dynamics GP

Here's the situation:

You open up a stock Dynamics GP SSRS report and you examine the data source. Your objective is to learn how Dynamics GP does things, or maybe to 'soup it up' a little by adding a field or something like that.

When you examine the spot in the data source where the query or stored procedure normally is, you see this:

What on earth is a SemanticQuery??

It happens occasionally that I develop and Integration Manager integration on one machine and it needs to get distributed to clients. This article will detail how to do that.

I blog a lot.

A lot, really.

I have occasion to wonder if I need to be using an apostrophe or not... and I'm usually too lazy to look it up. I'll blog the rule here and have it for a reference.

This is our third in a series on Making Changes to an Existing Dynamics SSRS report. In Part 1 we explored the Report Builder. In Part 2 we looked at Report Builder expressions.

In this article we put it all together and have some fun.

I love my job. Every day is something new.

Today's challenge is a new, migrated SQL Server install that has several databases that show (Recovery Pending)

Unable to open the physical file "E:\SQLDATA\DYNAMICS_1.ldf". Operating system error 5: "5(Access is denied.)".

This article discusses the fix

If you code in Visual Studio, there are things that you do over and over. I try as much as possible to reduce the repletion because it just goes faster, and I'm impatient like that.

That's why we started this site and www.TelerikDeveloper.com, to blog all the cool code samples so that we only type them once.

To that end, I type this all the time:

I created a Code Snippet to automate the typing. If you've never seen how a Code Snippet works, you really should read this.

I'm trying to use the built in TACreateEmployee Stored procedure to integrate data from our clinical system into our Payroll system of GP.

 When I query the UPR00100 Table all employees have an ACTINDX value of 0 in the table. If I try to pass the 0 into the TACreateEmployee SP (variable named @I_vAccountNumber)it gives me an error validating to the GL00105 table.  If I don't pass the value I get an error from the SP saying that it cannot insert a null into the ACTINDX field. 

Has anybody else encountered this?  My current plan is to populate the value with one validated in the GL table, and then go back through and update that field to a 0 as part of a cleanup script. 

 Here is the sample code I'm working with:

DECLARE @return_value int,

@O_iErrorState int,

@oErrString varchar(255)

EXEC @return_value = [dbo].[taCreateEmployee]

@I_vEMPLOYID = N'123456789',

@I_vLASTNAME = N'Bosephus',

@I_vFRSTNAME = N'Bojangles',

@I_vSOCSCNUM = N'989909523',

@I_vDEPRTMNT = N'BERK',

@I_vEMPLCLAS = N'FARM',

@I_vJOBTITLE = N'OT',

@I_vInactive = N'0',

@I_vAccountNumber = @Valid Value here (but I want to push through a 0 or NULL or no value to get it to work w/o this)

@I_vCHANGEDATE_I = N'2015-08-05',

@I_vDefaultFromClass = 1,

@O_iErrorState = @O_iErrorState OUTPUT,

@oErrString = @oErrString OUTPUT

SELECT @O_iErrorState as N'@O_iErrorState',

@oErrString as N'@oErrString'

SELECT 'Return Value' = @return_value

GO

Hi

I am inserting an invoice with a payment record that is EFT. I am setting the PYMTTYPE to 5

if i just do this it work fine however when i add the 

PROCESSELECTRONICALLY  flag its giving me a 

Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

Exception message:

Sql procedure error codes returned:

Error Number = 11457  Stored Procedure= taCreateSopPaymentInsertRecord  Error Description = Invalid payment type for PROCESSELECTRONICALLY=True. Valid PYMTTYPE values are 3 and 6 Node Identifier Parameters: taCreateSopPaymentInsertRecord SOPNUMBE = 1362420 SOPTYPE = 3 PYMTTYPE = 5 Related Error Code Parameters for Node : taCreateSopPaymentInsertRecord PROCESSELECTRONICALLY = 1

Error Number = 11458  Stored Procedure= taCreateSopPaymentInsertRecord  Error Description = PROCESSELECTRONICALLY cannot be set when Dynamics Online is not installed and Active Node Identifier Parameters: taCreateSopPaymentInsertRecord SOPNUMBE = 1362420 SOPTYPE = 3 PYMTTYPE = 5 Related Error Code Parameters for Node : taCreateSopPaymentInsertRecord PROCESSELECTRONICALLY = 1

<taCreateSopPaymentInsertRecord>

  <SOPTYPE>3</SOPTYPE>

  <SOPNUMBE>1362420</SOPNUMBE>

  <CUSTNMBR>54962</CUSTNMBR>

  <DOCDATE>8/10/2015</DOCDATE>

  <DOCAMNT>576.0400</DOCAMNT>

  <CHEKBKID>SBBT OPER</CHEKBKID>

  <CHEKNMBR>EFT0085324</CHEKNMBR>

  <PYMTTYPE>5</PYMTTYPE>

  <PROCESSELECTRONICALLY>1</PROCESSELECTRONICALLY>

</taCreateSopPaymentInsertRecord>

Recientemente se adquirieron unas maquinas con windows 10 y otras fueron actualizadas a windows 10, a partir de ese momento me sale el error,  File not Found Vba6.dll cuando se ejecuta código Visual basic. 

Dado que antes resolví el mismo problema con windows 7 con el procedimiento indicado aqui: 

http://dyndeveloper.com/thread.aspx?Threadid=1355

Pero ahora he hecho esto mismo uno me funciona.

Conocen ustedes alguna otra alternativa?

Recently bought a machine with Windows 10 and others were upgraded to Windows 10 , from the time I get the error , File not Found Vba6.dll when Visual Basic code is executed. As previously I solved the same problem with windows 7 to the procedure outlined here:

But now it's not working.

Any ideas?

This article shows how to edit the size of a GRIDBOUNDCOLUMN text box in edit mode (in place editing)

This article details how to save and restore the geometry for a Winforms RadGridView