DynDeveloper.com

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 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.

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.

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

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 Generic List of Sites (Locations/Warehouses) from Dynamics GP using Service Based Architecture.

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

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 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.

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.

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 the first screen you will see when you log into Business Analyzer for the first time

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 

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 lists URLs that will be helpful in working with Service Based Architecture for Dynamics GP

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.

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

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>

I'm currently testing through Service Based Architecture. I can get the help URL to work:

https://vmgp2015.devshed.local/GPService/Tenants(DefaultTenant)/Companies(Fabrikam,%20Inc.)/help

This returns the expected help files. However this does not work:

https://vmgp2015.devshed.local/GPService/Tenants(DefaultTenant)/Companies(Fabrikam, Inc.)/Dynamics/Inventory/Items(100xlg)

it returns "An error occurred during script processing."

Anyone have a clue?

I am currently looking to read budget data from Great Plains Analitical Accounting. I already do this well for standard GL Budgets stored in GL00200 and GL00201 but the AA structure is somewhat different.

Do you have access t the standard linkages between the AA tables used specifically for the checking of Budgets?

Thank you