DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

I'm getting this error:

 HTTP Error 503. The service is unavailable

When trying to access Service Based Architecture for Dynamics GP 2015

The fix is not too hard...

I'm getting

The specified user is not authorized to perform operations in this context.

When attempting a connection with Service Based Architecture for Dynamics GP

We've found two things that caused this error

Microsoft Dynamics GP 2015 (version 14.00.0661 )

Benefit Self Service There are a variety of fixes for Benefit Self Service, if you plan to setup open enrollment, it would be encouraged to install this hotfix.

Advanced Human Resource dependent window missing ACA field.

Affordable Care Act (ACA) – YOU CAN PRINT THE FORMS....WITH LINES!!!!!
Click HERE for detailed documentation changes on ACA.

Deduction in Arrears
When deduction in arrears is marked, a deduction may be taken from a Business Expense pay type when it is not based on this pay code.
Templates do not advance dates when there is no deduction in arrears to post for mandatory arrears.

Dynamics Online Services Changes to cash receipt functionality with credit card payments.

Web Client
Navigation List display may go to a blank state.
Server side error after applying January Hotfix when you switch companies.

Project Time and Expense
Transactions were not posting to Payables Management.
Incorrect PABillnoteidx values for timesheets entered in the Project Time and Expense entry window.

Payroll Self Service Timecard sequence issues when deleting and adding pay codes while entering time.

Dexterity
This issue could cause concern in multiple areas, to name a few, Integration Manager, VBA, Analytical Accounting, etc. the typical error is: Run-time error '70'; Permission deniedPermission denied.
Arabic characters displayed incorrectly.
Distribution
Sales order processing to Purchase order processing link may cause duplicate serial numbers on the sales order.

Download links:

Microsoft Dynamics GP 2013  Customersource                Partnersource
Microsoft Dynamics GP 2015  Customersource                Partnersource

Click HERE for March hotfix instructions.

Microsoft Dynamics GP 2013 (version 12.00.1894)

Affordable Care Act (ACA)YOU CAN PRINT THE FORMS....WITH LINES!!!!!
Click HERE for detailed documentation changes on ACA.
Dynamics Online Services Changes to cash receipt functionality with credit card payments.

Payroll Self Service Timecard sequence issues when deleting and adding pay codes while entering time.

Distribution Sales order processing to Purchase order processing link may cause duplicate serial numbers on the sales order.

This article will contain help on troubleshooting SBA

Grrr.

When running the March Hotfix on Dynamics GP 2015, I get the message 'Unable to upgrade SBA from RTM. Please remove the SBA feature before running this patch.

Details below.

This article will be the overview for the process of installing Service Based Architecture for Dynamics GP. There are several steps, we'll break them up to make it easier to understand.

 

In order to install Service Based Architecture, you'll need to create some Active Directory Components. This article discusses that process.

Installing Service Based Architecture for Dynamics GP is a series of steps that need to be coordinated. Be sure that you're using our guide located here

This article assumes that you've just installed Service Based Architecture for Dynamics GP, and you need to test it. If you're looking for help on installing SBA, we have that too,here.

 

We're setting up Service Based Architecture here, and it's going well. Now we need to get it working on another machine. The second machine is giving us a bunch of errors that seem to point to security:

Internet Explorer gives you There is a problem with this website's security certificate.

If you click on the 'certificate error', you'll see this:

This CA Root certificate is not trusted. To enable trust, install this certificate in the Trusted Root Certification Authorities store.

  

Chrome will give you a 'privacy error', and tell you that 'Your connection is not secure'

 

Visual Studio will report:

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

Using the WADL Generator for Project Siena, I get this error:

Unexpected character encountered while parsing value: T. Path '', line 0, position 0

and

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

This article will discuss the fix for all that.

This article contains sample code for getting a Site (Location/Warehouse) from Dynamics GP using Service Based Architecture.

 

This article contains sample code for getting a Generic List of Sites (Locations/Warehouses) from Dynamics GP using Service Based Architecture.

 

When querying Service Based Architecture for Dynamics GP, you might get a 'Service is not available' error, it looks like this:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""http://www.w3.org/TR/html4/strict.dtd">
<HTML>
    <HEAD>
        <TITLE>Service Unavailable</TITLE>
        <META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii">
        </HEAD>
        <BODY>
            <h2>Service Unavailable</h2>
            <hr>
                <p>HTTP Error 503. The service is unavailable.</p>
            </BODY>
        </HTML>

 

 

Have you ever had multiple lines appear for an Extender window you created?  You are not alone.  Two simple reolutions for a fix.

Puzzler: given a customer table with 3 lines and an address table with 6 lines, write a query to return one line per customer and only the first address.

 

--task:
--given a customer table with 3 lines and an address table with 6 lines,
--write a query to return one line per customer and only the first address.
declare @Customer table (custnmbr varchar(15), custname varchar(50) , rowid int identity)
declare @Address table (custnmbr varchar(15), address1 varchar(20), city varchar(20), rowid int identity)
 
insert into @Customer (custnmbr, custname) values ('Able', 'Able Technology')
insert into @Customer (custnmbr, custname) values ('Baker', 'Baker Delivery')
insert into @Customer (custnmbr, custname) values ('Charlie', 'Charlie Bakery')
 
insert into @Address (custnmbr, address1, city) values ('Able', '123 Main', 'Reno')
insert into @Address (custnmbr, address1, city) values ('Able', '123 Oak', 'Las Vegas')
insert into @Address (custnmbr, address1, city) values ('Baker', '123 Persimmon', 'Buffalo')
insert into @Address (custnmbr, address1, city) values ('Baker', '123 Apple', 'Rochester')
insert into @Address (custnmbr, address1, city) values ('Charlie', '123 Elm', 'Tampa')
insert into @Address (custnmbr, address1, city) values ('Charlie', '123 Walnut', 'Miami')

 

 

This is a Consultant-Level definition of Service Based Architecture, without all the techno-geek speak <smiles>

SBA is a web service (for our definition, I'm going to say web site. That's not technically correct but it's really very close and it's a better mental image)

So, SBA is a web site (service) that you can use to view and update data from Dynamics GP 2015. Why bother? Can't we just use eConnect, SQL queries, Integration Manager?

You access SBA from a URL, like this: https://vmgp2015.devshed.local/GPService/Tenants(DefaultTenant)/Companies(Fabrikam,%20Inc.)/Dynamics/Inventory/Items(100xlg). This URL returns (in a browser, or to whatever tool you use) all the data on the TWO 100XLG item. Cool, right? It's that simple.

One advantage is that the SBA web site (service) can be called from apps, which have a hard time running complicated data access code. Since it is accessed via a URL, apps can easily manage it. Here's an app that I coded in a few hours:

  

In about 50 lines of code I retrieved the Location Codes from TWO and displayed them. Imagine the possibilities.

Here's Mariano Gomez on hooking up SBA to Microsoft's new Project Siena (Consultant-level tools to build apps. Really. )

http://www.gpug.com/gpugsummit/participate-summit/ourlibrary/viewdocument?DocumentKey=4fd4f5f5-ce9d-472e-a318-aafde09c141e&tab=librarydocuments&CommunityKey=a2dad28f-23bb-4426-adda-04f9e22d61d4

Microsoft says that with eConnect they have to maintain two code bases, and by going to SBA they'll only have to maintain one code base.

I'd love to hear your comments.

 

This might be a little obscure, but it's the path that I'm going down right now, so it is what it is.

This is a code example for returning a list of sites using the Telerik Kendo model to build a phone app. It's a one page demo that returns a list of sites (warehouses) from the TWO company. The resulting page looks like this:

This is an interesting piece of code, it took me a day to write it and I don't want to lose it so I'm going to blog it here.

The code uses reflection to populate an eConnect class (taSOPHdrIvcInsert... but it'll work for any class) with data from a stored procedure... by iterating through the class.

Reflection is cool.

I have the task today of copying a SOP Order. The user supplies the order that needs to be copied, I need to make a complete copy.

I have the standard SOP code documented here but I know that there is going to be a ton of manual typing to get all the 150 or so fields in each of the SOP header and lines eConnect documents populated. So, in order to avoid that hour of work, I spend a day working on .NET Reflection. <smiles>

My initial foray into reflection is here. The code is simpler and easier to understand if all you're looking for is Reflection.

The resulting code is below. Basically, we get a query of the SOP Header and then (using Reflection) loop through the eConnect taSOPHdrIvcInsert object and populate all the fields with the data from the order to be copied.

Then we repeat that with all the lines, and create the order.

 Send comments!

Installing MR, I'm getting this error:

Management Reporter: An error occurred while configuring the 'Management Reporter Application Service'. check the deployment log for details.

The deployment log says:

 *** The target databases schema provider could not be determined. Deployment cannot continue.

Then on the next line is says to check the deployment log. <smiles> I'll just leave that alone.

 

 

This article will discuss linking fields to prompts in Modifier. This applies to all versions of Dynamics GP

 

Got a call this morning on two SSRS errors that are common: rsAccessDenied and Cannot create a connection to data source 'DataSourceGPCompany'

This article discusses the fixes.

The full text of the errors:

An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'DataSourceGPCompany'. (rsErrorOpeningConnection)
        For more information about this error navigate to the report server on the local server machine, or enable remote errors.

rsAccessDenied400The permissions granted to user 'xxx' are insufficient for performing this operation.
...
             

 

This is a step by step instruction on how to install Business Analyzer for GP 2013 & 2015.  This is standard and can be done at the time of installing GP or at a later time.

 

 

This is the first screen you will see when you log into Business Analyzer for the first time

So, you're thinking 'what??'

Why would you want to create a table from the parameters of a stored procedure?

Well, I've got a good reason. I've struggled for years with a way to pass parameters into eConnect code, and to have a piece of eConnect code that is portable between clients. That's really important for me, I work at a different client every day. So, code portability makes me money.

The idea is that I take the eConnect stored procedures and create tables that mirror the procs. The sending code populates the table and then calls the eConnect library which knows to pick up the data from the tables and run.

I still have to edit some of it... but a majority of the work is done. And there is no need to reference any eConnect objects in any code except the eConnect library.

This code loops through the parameters of a stored procedure and creates a table.

I get the error

A problem occurred creating a session. Please try again later or contact your administrator

While attempting to log onto the web client the first time. This article discusses the fixes 

 

https://youtu.be/2K04yKOxySY

This is the Microsoft video for installing SBA, it was very helpful to use in compiling this page.

I'm attempting to test Service Based Architecture, trying to PUT into Chrome Postman, and I'm getting this error: 

CORS validation failed for the origin 'chrome-extension://fdmmgilgnpjigdojojpjoooidkmcomcm'. Please ensure this origin has been explicitly allowed access to call this service in the server configuration.

This article discusses the fix

This article discusses how to update/insert data in Service Based Architecture for GP2015 using Chrome and Postman

 This article lists URLs that will be helpful in working with Service Based Architecture for Dynamics GP

This article shows how to update an item in VB.NET using Service Based Architecture for Dynamics GP 2015

This is a basic, step by step instruction on how to build an Excel Refreshable Report in Dynamics GP.

Excel Refreshable Reports gives access to employees without GP access with up-to-date information as data is entered into GP.

Also, default access to Excel Report Builder is turned off except for SA and the Poweruser role unless enabled.

These are the steps for an install in a new environment.

 

This article will cover installing PSTL and a common error:

Install & Invalid Versions!  This version of Professional Services Tools is only compatible on GP 2013 

There are 2 different approaches you can take to install PSTL in Dynamics GP 2015 RTM.

This article also covers the error

Have you ever seen this window?

You don't have security privileges to open this window.  Contact your system administrator for assistance.

 

This article will cover adding a resource to a security task, adding security tasks to security roles and adding security for an individual user.

Hi Experts,

 

I am trying to do order fulfillment process for existing order id

but while my transcation i gave one serial "358991021539638" number but transaction works fine.so order fulfillment done succesfully

but in sales transcation entry table showing another serial as allocated against the order id. its looks some issue in my code i think so.

But in line serial history showing passed serial number but serial transcation entry screen showing another serial number

please help me to proceed further.

Please refer the below screenshot and XML for your reference.


 

 

My XML:

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<SOPTransactionType>

<eConnectProcessInfo xsi:nil="true"/>

<taRequesterTrxDisabler_Items xsi:nil="true"/>

<taUpdateCreateItemRcd xsi:nil="true"/>

<taUpdateCreateCustomerRcd xsi:nil="true"/>

<taCreateCustomerAddress_Items xsi:nil="true"/>

<taSopSerial_Items>

<taSopSerial>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>ORD0016039</SOPNUMBE>

<LNITMSEQ>23425</LNITMSEQ>

<ITEMNMBR>HTCMAPL10-10B2-TMNTM233-1S</ITEMNMBR>

<LOCNCODE>FINGOODS</LOCNCODE>

<SERLNMBR>358991021539638</SERLNMBR>

</taSopSerial>

</taSopSerial_Items>

<taSopLotAuto_Items xsi:nil="true"/>

<taSopLineIvcInsert_Items>

<taSopLineIvcInsert>

<SOPTYPE>2</SOPTYPE>

<SOPNUMBE>ORD0016039</SOPNUMBE>

<CUSTNMBR>ABCP001</CUSTNMBR>

<DOCDATE>04/01/2015</DOCDATE>

<LOCNCODE>FINGOODS</LOCNCODE>

<ITEMNMBR>HTCMAPL10-10B2-TMNTM233-1S</ITEMNMBR>

<UNITPRCE>69</UNITPRCE>

<XTNDPRCE>69</XTNDPRCE>

<QUANTITY>1</QUANTITY>

<PRCLEVEL>DEFAULT</PRCLEVEL>

<DOCID>ORDER</DOCID>

<ADDRESS1>XXXXXX</ADDRESS1>

<CITY>XXXXXX</CITY>

<STATE>XXXXXX</STATE>

<COUNTRY>XXXXX</COUNTRY>

<UpdateIfExists>1</UpdateIfExists>

</taSopLineIvcInsert>

</taSopLineIvcInsert_Items>

<taSopLineIvcInsertComponent_Items xsi:nil="true"/>

<taSopTrackingNum_Items xsi:nil="true"/>

<taSopCommissions_Items xsi:nil="true"/>

<taSopLineIvcTaxInsert_Items xsi:nil="true"/>

<taCreateSopPaymentInsertRecord_Items xsi:nil="true"/>

<taSopUserDefined xsi:nil="true"/>

<taSopDistribution_Items xsi:nil="true"/>

<taAnalyticsDistribution_Items xsi:nil="true"/>

<taSopMultiBin_Items xsi:nil="true"/>

<taSopHdrIvcInsert>

<SOPTYPE>2</SOPTYPE>

<DOCID>ORDER</DOCID>

<SOPNUMBE>ORD0016039</SOPNUMBE>

<LOCNCODE>FINGOODS</LOCNCODE>

<DOCDATE>04/01/2015</DOCDATE>

<CUSTNMBR>XXXXX</CUSTNMBR>

<CUSTNAME>XXXXXX</CUSTNAME>

<ADDRESS1>XXXXXX</ADDRESS1>

<CITY>XXXXXX</CITY>

<STATE>XXXXXX</STATE>

<COUNTRY>XXXXX</COUNTRY>

<SUBTOTAL>15.99</SUBTOTAL>

<DOCAMNT>15.99</DOCAMNT>

<BACHNUMB>BATCH</BACHNUMB>

<PYMTRMID>CREDIT CARD</PYMTRMID>

<UpdateExisting>1</UpdateExisting>

</taSopHdrIvcInsert>

<taSopToPopLink xsi:nil="true"/>

<taSopUpdateCreateProcessHold xsi:nil="true"/>

<taCreateSOPTrackingInfo xsi:nil="true"/>

<taMdaUpdate_Items xsi:nil="true"/>

</SOPTransactionType>

</eConnect>

 

Saludos a Todos. 
Próximamente, la organización para la cual laboro, estará migrando la plataforma informática de GP 10.0 a GP 2015. Como miembro de equipo de IT , deseo estar preparado para esta tarea, por lo que acudo a ustedes para que me recomienden: información, sitios web y cualquier otro contenido online, archivos pdf o físico que pueda adquirir a fin de estudiar para este gran proyecto. Además agradeceré aquellos consejos, sugerencias, trucos  que ustedes ya conozcan como resultado de su vasta experiencia en estos temas de Dynamics. 
Bendiciones a todos..
Eric Ayala
 
Greetings to all.
Soon, the organization for which I work, will be migrating computing platform GP 10.0 to GP 2015. As a member of the IT team, I want to be prepared for this task, so I come to you to recommend me information, websites and other online content, pdf or physical files that can acquire to study for this great project. I also thank those