Software HOME | + BOOKMARK THIS PAGE  
More Articles about Software:
  1   2   3   4   5   6   7   8   9   10
site search
 
Web software monster
Best price to where to sell my car here
related articles about software

We'll only consider custom stored procedures way here. If you are using eConnect - this is kind of issue, so you have to appeal to GP internal architecture and do it with the stored procs approach. The first question is - are we allowed to create stored proc in Great Plains DYNAMICS and companies databases. Great Plains SOP module is working in concert with Inventory control, making allocation of inventoried items in IV. So, this is very challenging to replicate allocation logic.

Microsoft Great Plains eCommerce - Stored Procedures Approach


Do not manually create stored procedures in the database for transactional operations or for queries that are otherwise handled by TierDeveloper. Any stored procedures for transactional operations or queries can be generated by TierDeveloper so you do not have to manually write them in the database. Remember, these stored procedures contain sophisticated business rules. These stored procedures should be those that contains complex business rules or other data manipulation logic. TierDeveloper can generate stored procedure DDL for you in that situation.

Five Steps to Rapid Development with TierDeveloper 4.0


Usually you need Dexterity programmer to take a look at your Company or Dynamics databases and tell you which stored procedures are deployed by Dexterity customization. And you are lucky if they are not encrypted. In eEnterprise, beginning with version 5. Sometimes we see heavy VBA coding, using element of Continuum, where it switched Dexterity dictionaries and then uses inline Dexterity sacscript scripting. These customizations, probably considered as very high-skills programming in the past should be redone.

Microsoft Great Plains Customization Recovery & Upgrade for Large Corporation


Nowadays, however - and this is a good thing - most of Great Plains installations are moved to SQL Server - so you can use Dexterity for custom forms drawing only and make the buttons run SQL stored procedures. Integration Manager, VBA/Modifier, Great Plains Dexterity, SQL Server stored procedures to name a few. Plus you probably want to have several SQL stored procs. Feel free to create views and stored procs directly in the companies databases - it doesn't hurt the Dexterity engine. It allows you to feed data into Great Plains and was primarily created for eCommerce developers.

Microsoft Small Business Manager Customization Options - Overview


If you think your stored procedures are still capable to do the job at the data manipulation level, you can redesign front end as web application. If your Great Plains is integrated with Unix, Oracle, DB 2, Lotus Domino, Siebel or other third party application - you need to consider synchronous upgrade for integrated applications to avoid retuning integration piece twice. Then, somebody should carefully analyze and design the upgrade path for both. Unfortunately business logic level may deploy third party vendors logic, and these flourishing ISV of late 1990th might be now out of business. Happy customizing! You can always appeal to us to help you with your system.

Microsoft Great Plains: Customization Upgrade & Recovery - Visual Studio VB 6.0


Great Plains or RMS and then synchronize via stored procedures. If the business is small/mid-size, instead of using eConnect - consider working with direct sql custom stored procedures. One of the ways to synch both systems is to use RMS promotions and update Great Plains price list via custom stored procedures. Some customers mentioned the need in editing global customer data on the store level and the second interesting suggestion was immediate propagation across all the stores gift card balance - if customer walk in into several stores within the day - the chances are that balance is still not updated via Headquarters worksheets. Again you can base your items in either one of the systems.

Microsoft Great Plains Implementation & Customization: Computer Parts Retailer Example


You need custom stored procedures, posting and transferring Sales Orders. In the case of integrated web application with Great Plains, we would expect heterogeneous sql queries and reporting, based on these queries and stored procedures. You can create these procedures yourself or purchase the ones, available on the market. As mentioned above - this should be preferably done by Great Plains user with approval logic. To produce nice and flexible reports - you usually deploy Crystal Reports and publish them in your web application.

Microsoft Great Plains: exchange & brokerage - implementation notes


Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. Report Flexibility - when you have report based on the SQL view or stored proc - if you need to modify the data query - you don't have to change the report - you change your SQL view/ stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query. Create SQL Query to probe the data - again - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query. Microsoft, Best Software, Oracle to name a few.

Crystal Reports - Geterogeneus databases: SQL Server, Oracle, Unidata, Btrieve - Tips For Developer


So, these custom stored procedures are available on the market, but they are not packaged as eConnect and could be purchased on the individual agreement base with Microsoft Great Plains partner. Tool->Resource Desciption->Tables, re-sort by Table Group technical name, then make test transactions in Great Plains (SOP module) and see where records go. This is how you design and test your queries. You usually need consultant help, however you could try to make maximum work done at home. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http.

Microsoft Great Plains eCommerce: overview for developer


SQL Stored procedures - performance improvement. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle and having locations in multiple states and internationally (www. Great Plains Dexterity is proprietary programming language/environment, which was created in early 1990-th to provide platform / database / graphical interface independence for Mac and Windows based Great Plains Dynamics. Great Plains, Solomon, Navision and Axapta to web-based Microsoft Business Portal.

How to Upgrade Dexterity Customization - Tips for IT Manager


In your case - you need the whole set of stored procedures to enable eCommerce. Plus eConnect allows you to create and update customer record in Great Plains - this is however relatively simple to imitate in the stored procedure. You are not the first and not the last one to face this dilemma - somebody already has it implemented (SOP10200, SOP10100, SOP30200, SOP30300 tables. This is probably the best advise we could give you - just create orders, or invoices, leave them to the Great Plains user to approve and post. However in some cases it is absolutely critical and required.

eConnect: eCommerce Development for Microsoft Great Plains


Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. Report Flexibility - when you have report based on the SQL view or stored proc - if you need to modify the data query - you don't have to change the report - you change your SQL view/ stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query. Create SQL Query to probe the data - again - we always recommend tuning your query and see that you are getting adequate results - in any case - Crystal Report is just a nice tool to show the results of your query. Net, Crystal Reports and Microsoft CRM SDK developer.

Crystal Reports - Microsoft SQL Server


When having long cycle of change/edit table in Dexterity, consider replacement by SQL stored procedure with Insert Into clause. Private Sub Print_BeforeUserChanged(KeepFocus As Boolean, CancelLogic As Boolean. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia, Arizona, Minnesota, Washington, Colorado and Florida and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer. Net Web Publishing from Great Plains Database.

Upgrading Great Plains Dexterity Customization - switching to new technologies: SQL, Crystal, eConne


This integration technique uses SQL stored procedures and views to pull data from your legacy or third party application and push it into Great Plains. DIC with Dexterity procedures and functions scripts - in regular DYNAMICS. Obviously the development environment should be Visual Studio. This is end user tool and is easy to use. As the result - it is very slow - we recommend using integration manager when you have up to one thousand transactions per day.

Microsoft Great Plains Integrations - Tips for Developer


If you are trying to relay on eConnect exclusively and not researching Great Plains Architecture - you will need additions to eConnect from third party vendor, such as Alba Spectrum Technologies, which has the whole set of SOP populating stored procedures. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. For eCommerce developer the most important is to understand Great Plains tables structure and business processes in Sales Order Processing, Accounts Receivables, Inventory Control (inventory items allocation, backordering, etc), posting to Bank Reconciliation and General Ledger. And this is where Great Plains structure seems to be not transparent. Microsoft Great Plains, designed back in 1990th as database transferable and graphical platform independent ERP application - Great Plains Dynamics/Dynamics C/S+/eEnterprise.

Microsoft Great Plains e-Commerce - additional considerations for programmer

 
More Articles about Software:
  1   2   3   4   5   6   7   8   9   10
contact us:
© copyright 2006 softwaremonster.info
Link Partners