Released on: 31, December 1969
, Author: Alba Spectrum Group
, Audience: Computers related
Each ERP application should be open for tailoring:modifications, custom logic, reporting, integration with legacy systems, EDIinterface, etc. In some cases you may expect special modules or third partyextension, however if you have simple customization need you may undergo in-houseGP programming project to make job done. This article intended to be orientationsession for IT people and internal software developers. In the best case scenarioyou should balance external GP consultants and internal programmer and projectmanagers to realize your projects. Let s begin:1. Great Plains customization tools. GP similar to other MRP and accountingapplications is the combination of proprietary and open technologies. Mainproprietary technology is Microsoft Dexterity, which requires special license andGreat Plains Dexterity certification is recommended to do Dex programming. Dexterity is core technology, however as Microsoft .Net platform advances, opentechnologies open the GP customization door. Open technologies typically require MSVisual Studio development skills plus ADO.Net and some SQL scripting expertise. These tools are: eConnect, Modifier with VBA (this one is not a .Net based it israther legacy but should be considered open platform as VBA is popular for MS Excelmodifications). There are other enablers, opening Great Plains Dexterity objects toMS Visual Studio C# or VB developers use them at your discretion2. Programming GP Integration Manager. IM could be considered as end-user toolhowever it is very powerful and customizable, so if you are VBA programmer you canconsider IM as custom integration platform. VBA modification can intervene IMevents: before document, after document, etc. Plus you can do incoming recordstranslation create your customer or vendor translation table in Excel and thenimport it to Integration Manager3. SQL Scripting. This technique requires advanced familiarity with GP tablesstructure and records distribution. You should be aware that SQL insert statementsimply populates SQL tables, but it doesn t validate GP business logic. So, SQLscripting may cause data integrity problem and typically requires longer QualityAssurance (QA) and debugging cycle. As a hint for you eConnect does validate GPbusiness logic, so if you could deploy eConnect and not SQL stored procedures youwill be on the safe side of the programming project4. GP reports design. There are several tools and you got to get the idea on theirusability. First of all GP ReportWriter. This tool is integrated in GPworkstation interface you can modify such popular reports as SOP Invoice, POPPurchase Order, GL trial balance, AP historical trial balances to give you fewexamples. RW is Dexterity application and it has Dex limitations, so if you get tobreak through, you should consider FRx for strictly financial reports (linked toGeneral Ledger GL), Crystal Reports (unlimited in theory, however you have to do allthe work in SQL views or stored procedures from scratch) or Microsoft SQL ServerReporting Service or SRS (at this time we are inclined to consider SRS to becatching up in competition with Crystal, especially considering Microsoft plans topromote its own report design tool)
Andrew Karasev, Alba Spectrum Group, http://www.albaspectrum.comhe lp@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving customers USA/Canadanationwide: Illinois, California, New York, Quebec, Ontario, Colorado, Utah,Wisconsin, Florida, Texas. Local service is available in Houston & Dallas:Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood,Meadows, Mission Bend, Jersey Village, Fort Worth; serving GP customers in Chicago,IL: Naperville, Aurora, Joliet, Wheaton, Bolingbrook, Romeoville, Lyons, Niles,Downers Grove, Lisle, West Chicago, Barrington, Schaumburg, Elk Grove Village,Lombard, Morris, Ottawa, Marseilles, Seneca, Oswego, Plainfield, Darien, Winchester,Hinsdale
Source: Express-Press-Release.com
Related downloads
Use this software suite to easily create media-rich autoplay menus for your CD and DVD discs in minutes! Simply add visual objects such as text, graphics or even a built-in web browser and tell them what to do and when.
GLBasic is a programming language designed for game programming. It has simple commands for 3D, networking, joysticks and media playback. The source code compiles small, fast, stand-alone executables. Compiles for Windows, Linux, PocketPC and GP2X.
SpamSource is an addin for Microsoft Outlook 2000/XP/2003/2007.SpamSource helps collect information from messages for use in reporting unsolicited junk email.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven sound-topics with different listener-positions and changing backgrounds gives a long prolonged motivation.
Blocker Plains is a reaction game with six game-levels, an unlimited ball-number, 50 stone plains and a freely movable Blocker. Seven game-accompanied sound-topics and changing backgrounds gives Blocker Plains a long prolonged motivation.
With jk-ware Theater Blocker Plains, Color LIFE Sound and Perpetuum mobile can be started multiple times and run simultaneously. Think and purpose of jk-ware Theater is to test the capability of modern computers playfully.
You are a pilot of the plane, your goal is to destroy the city, erase it from the surface of Earth. Game control is not easy, but very easy! The bomb hatch is always open, simply press ANY key and the bombs will start to fall.
Real-time OscilloScope + FFT Spectrum Analyzer of data accepted from sound card or other ADC you will want.
This sophisticated piece of software turns your computer into a modern, State-of-The-Art spectrum analyzer giving you features that go far beyond the possibilities of any stand-alone hardware unit.
CD/Spectrum Pro is a CD/MP3 Player with Graphical Spectrum Analyzer for Windows. It comes with CD Audio player, Spectrum Analyzer, Mixer, the MediaFiles (MP3/WAV) Player, Synchronized Visuals Window, etc.