Violation of PRIMARY KEY constraint ‘PKSY40100’. Cannot insert duplicate key in object ‘dbo.SY40100’. The duplicate key value is….Computer Checks. DBMS: 2627

On creating a new fiscal period or even calculating on an existing fiscal period, you are greeted with a cryptic error that suddenly came from nowhere. You have been opening and closing fiscal years for years and why suddenly this: There is not much info out there with regards to this error. I have a […]

, ,

Leave a comment

Monitoring Windows File Folders for Specified Files and Windows Event Viewer for Events

I have developed a sample windows folder monitoring application. The sample application as a general, acts as a watch dog for any potential breakdown of XML files processing. Let us begin with the statement of the problem: Problem: Customer orders come from different sources – i.e. via emails, third party applications that are installed as […]

, , , , ,

Leave a comment

Creating Applications for Scanners and Handheld Devices

I have developed many handheld applications in the past and it is not difficult to create one as there is not much difference between handheld apps and windows apps. Depending on the requirement of the business or process, some handhelds are plug and play. All it has to do is read the bar code from […]

, , , , ,

Leave a comment

Enabling Dimension Writeback

Cube information is commonly a read-only information and that will be the case most of the time. Seldom will you be required or requested that your dimensions be editable by the users. However, there might be a time that you will need to do so as a requirement. However, do take note that writeback functionaliy […]

, , , , , , , ,

Leave a comment

Using Dynamics GP Web Services As Well As Your Own Web Services in Your Web Applications

Using Dynamics GP Web Services As Well As Your Own Web Services in Your Web Applications Microsoft did a good job of creating multiple gateways in order to integrate with Dynamics GP. Integration is a very important factor to an accounting application as the data that need to be processed and analyzed by the application […]

, , , , ,

3 Comments

TASK 1: Create your own web service to be used in your web application

TASK 1: Create your own web service to be used in your web application In my sample, I have created a web service where I utilized a SQL stored procedure that came out of the box when I installed Dynamics GP  in order to get the next SOP Number. Here is the source code of […]

, , , , ,

2 Comments

TASK 2: Deploy and Test Your Web Service

TASK 2: Deploy and test your web service Deploy your web service the way you normally deploy any web service in Visual Studio. Once you are done deploying, test your web service right away by entering the address. On the sample that I did, I entered the address: http://dev1/WS/Service1.asmx You can further test by clicking […]

, , , , ,

3 Comments