Microsoft Dynamics GP is successor of Terrific Plains Software program bundle Dynamics and eEnterprise ERP software, and Crystal Experiences was often the reporting instrument of the choice for Dynamics. Traditionally GP Dynamics was provided on Pervasive SQL and Ctree system, the place by Crystal Experiences had been being restricted, because of the limitation to Pervasive and Faircom ODBC motorists. The previous version, provided on Pervasive/Ctree was Microsoft Terrific Plains seven.5 and since version eight. GP Dynamics is obtainable on Microsoft SQL Server solely, and as you possibly can hope, SQL Server opens all of the achievable horizons for research enhancement. Current Model of GP as of November 2007 is ten.. On this modest article we are going to open up “philosophical” ideas of Crystal Experiences construction for Microsoft Dynamics GP:

1. Crystal Experiences is “simply” a reporting instrument, not and magic “all-the-troubles-solver”. This implies that it’s best to actually not overestimate the vitality of report wizards, however as a substitute construction each SQL view or SQL saved process to just accept parameters and return data established to your Crystal Report. Then all you require to do in CR is to group data, sort them, and of system use fashions and different “cosmetics”. We’re inserting this data within the 1st bullet, as a result of reality we noticed an entire lot of report construction failures, the place by designer tried to do fairly intricate GP tables inbound hyperlinks inside simply CR after which use additional intricate limitations, and completed up with traces duplication, and different troublesome troubles, which in fact pile up when you try to restore them with very related patches and on the end of the best way, report was abandoned

2. SQL Watch vs. Saved Course of. Of system SP appears to be like further elegant because it accepts parameters, that are translated to CR parameters, having stated that SP can also be further highly effective than the view because of the means to encompass briefly tables and intermediate calculations (depending on non everlasting tables). Quick time period tables make it potential so that you can go previous the standard strategies of grouping in SQL Choose assertion – this could actually be the real different, which can get rid of data duplications, defined in #1. In case you technique to commit your time in CR working in direction of for GP, it’s best to actually make fairly a couple of lifelike courses the place by you base GP Crystal Experiences on SQL view and saved process

three. Different reporting sources for GP. If you’re CR developer, it’s all-natural, that you just try to make use of Crystal Report in all of the conditions, having stated that it’s best to actually be acutely aware that GP has fairly highly effective pre-intended sources. In case you require to make fiscal statements: Steadiness Sheet, P&L, Cash Stream – it’s best to actually take into consideration FRx report designer 1st, FRx inbound hyperlinks to GP Typical Ledger and so, if further productive than CR in Financial Reporting. GP ReportWriter. This reporting instrument receives the advantages of GP report launching screens, this type of as SOP Invoice variety, from the place by you possibly can print explicit bill – so recognized as modified research make it potential so that you can place your company model on Invoice variety. Different choices of FRx and RW are exterior of the scope, be sure you test our publications on these merchandise and options

four. GP Dexterity Reporting. Dexterity is IDE and programming language of GP. Dex permits you to customise GP sorts and research furthermore make new varieties. With the intention to examine Dex different, we advise you to pay money for GP Dexterity developer, who ought to actually assist you to within the selection

5. Calling CR from GP interface. You should utilize fairly a couple of strategies. 1st 1 is conventional – use VBA/Modifier (you’ll require customization web site enabler license for GP), from VBA scripts you possibly can join with CR engine. 2nd strategy is Dexterity, the place by you join with Crystal Experiences engine out of your customized made Dexterity sanscript code. You too can take into consideration SDK for Visible Studio developer, making it potential so that you can extend GP sorts and of system join with CR out of your .Net extension software

You may also like

No Comment

You can post first response comment.

Leave A Comment

Please enter your name. Please enter an valid email address. Please enter a message.
Rankie WordPress Plugin