Updating Great Plains Dexterity Customization– changing to …

 | Blog

Upgrading Great Plains Mastery Modification– transforming to new modern-day innovations

This message is for intermediate Great Plains Dexterity developer. It clarifies the directions to end Dexterity efficiency in addition to modification it with even more current advancements.
Microsoft Great Plains along with its existing programs language Dexterity require to still be thought of seriously by developers area. Microsoft Business Solutions presented altering to new modern-day innovations, mostly.Net, where all the MBS applications will definitely be established right into collections (Microsoft Financials, Microsoft Distributions, Microsoft Manufacturing, Microsoft Human Resources) as well as additionally integrated right into so called Microsoft Business Portal. Checking out the future we recommend you to review Microsoft Great Plains Dexterity customization for alternative it’s get rid of Microsoft SQL Server maintained procs, Crystal Reports, straight C#/ VB.Net net uploading, eConnect
1. Modification Dexterity arrowhead with SQL Stored Procedure
Proficiency was developed as multiplatform technology (mostly Btrieve, Ctree, SQL Server, potentially Oracle). Proficiency info obtaining tool is based upon Range start, Range End, Get First as well as likewise Get Next problems.
Think about to alter sticking to Dexterity code:
Range clear SOP_HDR_WORK.
Clear ‘SOP Type’ of table SOP_HDR_WORK.
Clear ‘SOP Number’ of table SOP_HDR_WORK.
Range starting table SOP_HDR_WORK.
Acquire at first table SOP_HDR_WORK.
While errEOF do
If ‘Salesperson ID’ of table SOP_HDR_WORK=” ERIC” afterwards
Edit table SOP_HDR_WORK.
Develop ‘Salesperson ID’ of table SOP_HDR_WORK to “BILL”.
Preserve table SOP_HDR_WORK.
End if.
Get adhering to table SOP_HDR_WORK.
End while.
With the following SQL code
Update SOP10100 developed SLPRSNID=” BILL” where SLPRSNID=” ERIC”
Bringing new details right into a table in Dexterity is based upon change/edit table problems, in SQL they are similar (by effectiveness) to placing one paper at the time.
When having prolonged cycle of change/edit table in Dexterity, consider alternative by SQL maintained therapy with Insert Into arrangement.
2. Use Crystal Reports, call them from through VBA in Modified kind
The really simple methods to call Crystal Report from your VBA code from your transformed kind:
Const RPT=” D: Clients TheClient Invoice Status.rpt”
Public crwApplication As CRPEAuto.Application
Public crwReport As CRPEAuto.Report
Individual Sub Print_BeforeUserChanged( KeepFocus As Boolean, CancelLogic As Boolean).
If SalesTransactionInquiryZoo.Type=” Invoice” Then.
Afterwards, if crwApplication Is Nothing.
Develop crwApplication = CreateObject(” Crystal.CRPE.Application”).
End if.
Develop crwReport = crwApplication.OpenReport( RPT).
crwReport.ParameterFields( 1 ). SetCurrentValue (DocumentNo).
crwReport.Preview.
End if.
3. Use Direct.Net Web Publishing from Great Plains Database.
The most basic as well as additionally most risk-free ways is to make use of eConnect – SDK with VB instances, generated for eCommerce programmers in addition to web designers to call the capacity in Microsoft Great Plains. If your company can not spend for eConnect – create your really own collection of maintained therapies to settle Great Plains information resource along with wage Visual Studio.Net to do the web uploading.
Completely satisfied upgrading in addition to customizing! if you want us to do the job – give us a telephone call 1-866-528-0577! [email protected]

Microsoft Great Plains as well as likewise its existing programs language Dexterity need to still be considered seriously by designers community. Looking right into the future we recommend you to take a look at Microsoft Great Plains Dexterity customization for replacement it’s areas with Microsoft SQL Server conserved procs, Crystal Reports, straight C#/ VB.Net web publishing, eConnect
Proficiency was made as multiplatform contemporary innovation (primarily Btrieve, Ctree, SQL Server, perhaps Oracle). Proficiency details recouping tool is based upon Range start, Range End, Get First as well as additionally Get Next terms. Prolonged varieties in Dexterity are exceptional leads for alternative by SQL maintained therapies with upgrade arrangement.

Microsoft Great Plains as well as its existing programs language Dexterity require to still be assumed regarding seriously by developers community. Microsoft Business Solutions presented altering to new contemporary innovations, mostly.Net, where all the MBS applications will definitely be established up right into collections (Microsoft Financials, Microsoft Distributions, Microsoft Manufacturing, Microsoft Human Resources) as well as likewise integrated right into so called Microsoft Business Portal. Inspecting right into the future we encourage you to examine Microsoft Great Plains Dexterity customization for alternative it’s components with Microsoft SQL Server maintained procs, Crystal Reports, straight C#/ VB.Net net publishing, eConnect
Proficiency details recuperating gadget is based on Range start, Range End, Get First as well as likewise Get Next specifications. Extensive selections in Dexterity are superb potential customers for alternative by SQL maintained therapies with upgrade arrangement.