Updating Great Plains Dexterity Customization– changing to brand-new modern technologies

 | Blog

Updating Great Plains Dexterity Customization– changing to brand-new modern technologies

This post is for intermediate Great Plains Dexterity designer. It explains the instructions to terminate Dexterity performance as well as change it with more recent innovations.
Microsoft Great Plains as well as its present programs language Dexterity need to still be thought about seriously by programmers neighborhood. Microsoft Business Solutions introduced changing to brand-new modern technologies, mostly.Net, where all the MBS applications will certainly be set up right into collections (Microsoft Financials, Microsoft Distributions, Microsoft Manufacturing, Microsoft Human Resources) and also incorporated right into so called Microsoft Business Portal. Checking into the future we advise you to evaluate Microsoft Great Plains Dexterity personalization for substitute it’s parts with Microsoft SQL Server kept procs, Crystal Reports, straight C#/ VB.Net internet posting, eConnect
1. Change Dexterity arrow with SQL Stored Procedure
Mastery was created as multiplatform innovation (mainly Btrieve, Ctree, SQL Server, possibly Oracle). Mastery information getting device is based on Range begin, Range End, Get First and also Get Next conditions.
Take into consideration to change adhering to Dexterity code:
Array clear SOP_HDR_WORK.
Clear ‘SOP Type’ of table SOP_HDR_WORK.
Clear ‘SOP Number’ of table SOP_HDR_WORK.
Variety beginning table SOP_HDR_WORK.
Obtain initially table SOP_HDR_WORK.
While errEOF do
If ‘Salesperson ID’ of table SOP_HDR_WORK=”ERIC” after that
Edit table SOP_HDR_WORK.
Establish ‘Salesperson ID’ of table SOP_HDR_WORK to “BILL”.
Conserve table SOP_HDR_WORK.
If, end.
Obtain following table SOP_HDR_WORK.
End while.
With the complying with SQL code
Update SOP10100 established SLPRSNID=” BILL” where SLPRSNID=” ERIC”
Bringing brand-new information right into a table in Dexterity is based upon change/edit table conditions, in SQL they are comparable (by efficiency) to putting one document at the time.
When having lengthy cycle of change/edit table in Dexterity, think about substitute by SQL kept treatment with Insert Into provision.
2. Usage Crystal Reports, call them from by means of VBA in Modified kind
The very easy means to call Crystal Report from your VBA code from your changed kind:
Const RPT=”D: Clients TheClient Invoice Status.rpt”
Public crwApplication As CRPEAuto.Application
Public crwReport As CRPEAuto.Report
Personal Sub Print_BeforeUserChanged( KeepFocus As Boolean, CancelLogic As Boolean).
If SalesTransactionInquiryZoo.Type=”Invoice” Then.
After that, if crwApplication Is Nothing.
Establish crwApplication = CreateObject(” Crystal.CRPE.Application”).
If, end.
Establish crwReport = crwApplication.OpenReport( RPT).
crwReport.ParameterFields( 1 ). SetCurrentValue (DocumentNo).
crwReport.Preview.
If, end.
3. Usage Direct.Net Web Publishing from Great Plains Database.
The simplest and also most safe means is to utilize eConnect – SDK with VB examples, produced for eCommerce developers as well as internet developers to call the capability in Microsoft Great Plains. If your firm can not pay for eConnect – produce your very own collection of kept treatments to resolve Great Plains data source as well as proceed with Visual Studio.Net to do the internet posting.
Satisfied updating as well as personalizing! if you desire us to do the work – provide us a phone call 1-866-528-0577! [email protected]

Microsoft Great Plains and also its existing shows language Dexterity must still be taken into consideration seriously by programmers neighborhood. Looking right into the future we suggest you to examine Microsoft Great Plains Dexterity personalization for substitute it’s sections with Microsoft SQL Server saved procs, Crystal Reports, straight C#/ VB.Net internet posting, eConnect
Mastery was made as multiplatform modern technology (mostly Btrieve, Ctree, SQL Server, possibly Oracle). Mastery information recovering device is based on Range begin, Range End, Get First and also Get Next stipulations. Lengthy arrays in Dexterity are excellent prospects for substitute by SQL kept treatments with upgrade provision.