Archives

 

You want to rebind a project that was previously bound to either a network or cloud source that no longer exists or you do not have access to the cloud account.  You try changing the current source control but the Microsoft Cloud login screen keeps appearing and you cannot select a new source.

The error that you get is

The Path <local path> is already mapped in workspace <machine name [old tfs server]>

 

This article, and all the other .NET development articles, can be found on the .NET Development Menu  

Here is a very powerful and convenient technique to expand methods on existing root controls, data types, etc.

 Got this error today integrating into SOP:

 

Sql procedure error codes returned:

Error Number = 722 Stored Procedure= taSopLineIvcInsert Error Description = Unit Price calculation does not match out to Extended price Node Identifier Parameters: taSopLineIvcInsert
SOPNUMBE = SUM000005
SOPTYPE = 3
Related Error Code Parameters for Node : taSopLineIvcInsert SOPTYPE = 3 QUANTITY = 2.00000 UNITPRCE = 70.78 MRKDNAMT = Note: This parameter was not passed in, no value for the parameter will be returned.
XTNDPRCE = 141.57000


<taSopLineIvcInsert>
<SOPTYPE>3</SOPTYPE>
<SOPNUMBE>SUM000005 </SOPNUMBE>
<CUSTNMBR>CD BELGIUM </CUSTNMBR>
<DOCDATE>9/19/2014</DOCDATE>
<ITEMNMBR>.K84766 </ITEMNMBR>
<UNITPRCE>70.78</UNITPRCE>
<XTNDPRCE>141.57000</XTNDPRCE>
<QUANTITY>2.00000</QUANTITY>
<NONINVEN>1</NONINVEN>
<CURNCYID>Z-EURO </CURNCYID>
</taSopLineIvcInsert>

 Got this error today while coding an eConnect Apply document. I had to go to a consultant friend to get help...

 

Sql procedure error codes returned:

Error Number = 4694 Stored Procedure= taRMApply Error Description = Apply To or Apply From document are different currencies then functional
Node Identifier Parameters: taRMApply
APFRDCTY = 7
APFRDCNM = SUM000001-001
APTODCTY = 1
APTODCNM = SH12/04260


<taRMApply>
<APTODCNM>SH12/04260 </APTODCNM>
<APFRDCNM>SUM000001-001</APFRDCNM>
<APPTOAMT>1216.65000</APPTOAMT>
<APFRDCTY>7</APFRDCTY>
<APTODCTY>1</APTODCTY>
</taRMApply>

 This is a no brainer...

 

Sql procedure error codes returned:

Error Number = 569 Stored Procedure= taRMApply Error Description = Apply From Document (APFRDCNM) is missing
Node Identifier Parameters: taRMApply
APFRDCTY = 7
APFRDCNM = INV00000000000003-001
APTODCTY = 3
APTODCNM = SH12/05028 SUM


<taRMApply>
<APTODCNM>SH12/05028 SUM </APTODCNM>
<APFRDCNM>INV00000000000003-001</APFRDCNM>
<APPTOAMT>3606.32000</APPTOAMT>
<APFRDCTY>7</APFRDCTY>
<APTODCTY>3</APTODCTY>
</taRMApply>

 This was... hard to spot

 

Sql procedure error codes returned:

Error Number = 1340 Stored Procedure= taRMDistribution Error Description = Account does not exist for Account Number String (ACTNUMST)
Node Identifier Parameters: taRMDistribution
RMDTYPAL = 1
DOCNUMBR = INV00000000000002-001
CUSTNMBR = CD AUSTRALIA
DISTTYPE = 9
Related Error Code Parameters for Node : taRMDistribution
ACTNUMST = 2205-


<taRMDistribution>
<RMDTYPAL>1</RMDTYPAL>
<DOCNUMBR>INV00000000000002-001</DOCNUMBR>
<CUSTNMBR>CD AUSTRALIA </CUSTNMBR>
<DISTTYPE>9</DISTTYPE>
<ACTNUMST>2205-</ACTNUMST>
<CRDTAMNT>3606.32000</CRDTAMNT>
</taRMDistribution>

Duh.  

 

All transaction type child nodes must contain the same document number. Please ensure your transaction is not missing this unique identifier for the element DOCNUMBR. (If you would like the document number generated, please ensure a document number value is not contained in the document number element DOCNUMBR.)



<eConnect xmlns:xsi=
"http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<RMTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateCustomerRcd xsi:nil="true" />
<taCreateCustomerAddress_Items xsi:nil="true" />
<taRMCommissions_Items xsi:nil="true" />
<taRMTransactionTaxInsert_Items xsi:nil="true" />
<taRMDistribution_Items>
<taRMDistribution>
<RMDTYPAL>1</RMDTYPAL>
<DOCNUMBR>INV00000000000002</DOCNUMBR>
<CUSTNMBR>CD AUSTRALIA </CUSTNMBR>
<DISTTYPE>9</DISTTYPE>
<ACTNUMST>2205-</ACTNUMST>
<CRDTAMNT>3606.32000</CRDTAMNT>
</taRMDistribution>
<taRMDistribution>
<RMDTYPAL>1</RMDTYPAL>
<DOCNUMBR>INV00000000000002</DOCNUMBR>
<CUSTNMBR>CD AUSTRALIA </CUSTNMBR>
<DISTTYPE>3</DISTTYPE>
<ACTNUMST>2205-</ACTNUMST>
<DEBITAMT>3606.32000</DEBITAMT>
</taRMDistribution>
</taRMDistribution_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taRMTransaction>
<RMDTYPAL>7</RMDTYPAL>
<DOCNUMBR>INV00000000000002-001</DOCNUMBR>
<DOCDATE>9/19/2014</DOCDATE>
<BACHNUMB>CONSOL1009</BACHNUMB>
<CUSTNMBR>CD AUSTRALIA </CUSTNMBR>
<DOCAMNT>3606.32000</DOCAMNT>
<SLSAMNT>3606.32000</SLSAMNT>
<DOCDESCR>SH12/05028 SUM </DOCDESCR>
<CSTPONBR>INV00000000000002</CSTPONBR>
<PYMTRMID>1% 30 NET 31</PYMTRMID>
</taRMTransaction>
<taMdaUpdate_Items xsi:nil="true" />
</RMTransactionType>
</eConnect>

Typically when I craft a report I put the parameters on the report so the users know what the dataset represents.

With multi select params you can't do that.

This small tidbit of code will display the params properly

Why blog such a simple piece of code? So I don't have to search Google the next time that I need it. You'll find this on the SSRS menu for this site.

Whilst setting up an SSRS server today I got this error:

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database

The solution was not too hard.

While running year-end for 2014, the screen shot below is what I came across.  I considered marking 2000 - 2013 as Historical years on the Fiscal Calendar screen.   I also checked to see if 2000 had been reopened with the fiscal period tool in PSTL.

Recently, a client asked us to add an additional filter field to the standard GL Trial Balance SSRS report for Dynamics GP.  

This tutorial contains the report and the custom SQL that you will need to implement this for yourself. The object is to add an additional filtering field (in our case the User Defined 1 in the Account card) to a report.

The script and report can be further altered without too much effort.

Recently a customer asked us to produce a list of RM applied documents where the customer has an older document that should have been applied.

This is a SQL view that will do that. We put it in a view so that it can be hooked up in SmartList

 

I'm getting this error: The specified executable is not a valid application for this OS platform

when installing Tenant Services on a server...

 How to change the look of the toolbar in GP2013 R2 and above

From Action Pane:

Back to Menu Bar:

I recently received a request to write a certified payroll report, and the query turned out to be a tough one. The client needed me to bring in the project from the gpUPRCPR table, which I'd never heard of; and several other custom fields. Like most GP reports, this report does not run from a query but they build the dataset one line at a time behind the form. I had to trace through several hundred SQL calls to get this figured out. More, the stored procedures that they did call were not on the machine. I'm not sure how that works, because they didn't return errors. Maybe they create them on the fly and delete them?

At any rate, the query for the report is below. I don't what to have to do this twice <smiles>

If you can shed any light on how this process works, would you add a comment below the article?

Updating the Master Base Template project.
Installing the Master Project template for new customer is multi-step process.  It is important to follow all the steps in order.

This article will describe how to add forms authentication web site. Although there are several tutorials out there, I struggle to get all the info that I need in one place. And since I seem to need this more and more, I'll blog it here and then I'll own the technique.

Be warned that I'll not be using the 'aspnet' tables for authentication, I like creating my own tables, it give me more control.

 

Adding a custom field to the Dynamics report "Historical Aged Trial Balance" to filter the results.

I have a set of data that I'm trying to summarize but it's not doing what I want. I have replicated the problem with the query below. The issue is that my data is not summarizing because of the item descriptions. Help?

declare @t table (itemnmbr varchar(31), itemdesc varchar(65), quantity int, xtndprce numeric(19,2))
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('100XLG', 'hammer'  , 1,6.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('100XLG', 'hammer 2', 2,12.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('128 SDRAM', 'saw'     , 1,5.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('128 SDRAM', 'saw 2'   , 2,10.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('24X IDE', 'pliers'  , 1,4.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('24X IDE', 'pliers 2' , 2,8.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('256 SDRAM', 'wrench'  , 1,3.00)
insert into @t (itemnmbr, itemdesc, quantity, xtndprce) values ('256 SDRAM', 'wrench 2', 2,6.00)
 
select i.itemnmbr, t.itemdesc, t.quantity, t.xtndprce
    from iv00101 i
        join @t t on t.itemnmbr = i.ITEMNMBR
 

I'm not seeing any GP Web Service methods for managing email addresses.  When I CreateCustomer or UpdateCustomer, I want to include email with the addresses.  I see the GP is managing "Internet Addresses" (SY01200) separately from physical addresses ... fine ... but where are the web service methods for handling them?  The only thing I see in MSDN is GetChangedInternetAddressKey(), and I can't do much with that, if it's the only method available.

Thanks in advance,

Rich

HI,

I had an interface with GP and another software that my software creates Items in GP through eConnect.  It works fine.  I'm using the same code in another software and is giving me this error.

This is part of the code

            Dim UpdateCreateItemRcd As New taUpdateCreateItemRcd
            With UpdateCreateItemRcd
                .ITEMNMBR = item.ItemLookupCode
                .ITEMDESC = item.Description
                .ITMCLSCD = item.Department.Code
                .UOMSCHDL = item.UnitOfMeasure.Schedule
                .ITEMTYPE = CShort(item.ItemType)
                .DECPLQTY = CShort(ItemDefaults.DECPLQTY)
                .DECPLQTYSpecified = True
                .DECPLCUR = CShort(ItemDefaults.DECPLCUR)
                .DECPLCURSpecified = True
                .PRCHSUOM = ItemDefaults.PRCHSUOM
                .LISTPRCE = item.Price
                .CURRCOST = item.Cost
                .UpdateIfExists = 1
            End With

 

Error: Unable to increment next document number from Inventory Setup after 1000 attempts

There is a related post here:

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

Error: Unable to increment next transaction number from General Ledger Setup after 1000 attempts

Error: Unable to increment next transaction number from Document Type Setup after 1000 attempts (RM40401)

Error: Unable to increment next document number from Document Type Setup after 1000 attempts (RM40401)

Error: Unable to increment next document number from Purchasing Setup Table (POP40100) after 1000 attempts

Error: Unable to increment next payment number from Payroll Setup Table (UPR40200) after 1000 attempts

Error: Unable to increment next manual transaction number from Payroll Setup Table (UPR40200) after 1000 attempts

All,

Our dexterity-based ISV solution is being adversely impacted by another product in the .set file. We have resolved the issue by moving our product above the offending product in the .set file. However, someone mentioned that the .set file may be automatically reordered by product id if a new .cnk file is installed. We are not aware of this behavior and was wondering if anyone can confirm or rebut this 'hear say'.

Jeff

Error: An EXGTBLID default was not found for the CURNCYID and RATETPID - please check the setups in Great Plains

When trying  to customize  "Customer Address Maintenance" form .I am getting the error saying that "The Modifier is currently unavailable because another user is editing resource in the forms dictionary" 

Could you please help ?

 

 

Thanks 

 

 

This is an example of how to use the GridTemplateColumn                       
Common code for the GridViewCheckBoxColumn

My forays into Telerik Reporting continue. I'm developing reports by dropping a SQLDataSource onto the design surface and configuring a stored procedure.

The code below shows how to replace the stored procedure at runtime

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3