Net Web Publishing from Great Plains Database.
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.
Clear 'SOP Number' of table SOP_HDR_WORK.
If you need to query MS CRM database - you should create your custom database and place your objects. Microsoft technical support encourages you to use Microsoft CRM SDK objects and discourages you from direct SQL server programming. Microsoft CRM has MS CRM SDK (Software Development Kit. This is open source tool, you can download it from Microsoft site and it is description of Microsoft CRM classes and methods with sample codes in C# and VB. Net, Crystal Reports and Microsoft CRM SDK developer.
If you purchase Microsoft Great Plains, Oracle eBusiness Suite, PeopleSoft, or other ERP application - you will have to pay one or another type of annual fee to get new version and regular support from the software vendor. Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. We'll try to be more liberal to our clients, but considering large demand - we'll have to implement the plan to improve the service to existing clients. If MS CRM is business critical and Lotus investments should be protected - we recommend our customers Lotus Notes Domino support contract. Alba Spectrum serves corporate clients in Aerospace & Defense, Oil & Gas, Chemicals, Manufacturing, Transportation & Logistics, Pharmaceutical, Food Processing, Placement, Healthcare & Medicine, Beverages, Agriculture, Non-profit, Distribution & Supply Chain Management, Financial Services, Furniture, Textile, Apparels, Conglomerates, Wholesale & Retail.
It is not a secret, that nowadays multiple companies from Fortune 500 list use midmarket solution, such as Microsoft Great Plains as their corporate ERP. In this small article we'll try to defend our position and give you highlights on deploying Microsoft Great Plains for large corporation. We believe in this - seeing signs of maturing ERP software industry. Good luck and you can always seek our help in customization, implementation, integration and support. If you purchase expensive module and use 10% or its functionality, because the whole bundle has what you need among other features, then you are in trap of paying 20% annually for the logic you don't need and don't use.
We heard complains about this tight integration. However you can improve MS CRM Exchange connector to catch emails by addresser email or domain, also you can deploy Lotus Notes Domino as email server - check with Alba Spectrum Technologies. Microsoft CRM integrates with GP customers, SOP Orders & Invoices. If you use MS CRM Web or Outlook clients - these are just two types of presentation level clients. Microsoft CRM schema sits in MS SQL server database, so if you deploy MS CRM SDK to modify/customize your CRM - both presentation clients will get the custom interface.
Microsoft Great Plains is one of three Microsoft Business Solutions mid-market ERP products. GLPOSTDT = convert(varchar(10), getdate(), 101). DATE1 = convert(varchar(10), getdate(), 101). Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, with offices in Chicago, San Francisco, Los Angeles, San Diego, Phoenix, Houston, Miami, Atlanta, New York, Madrid, Brazil, Moscow ( http. DATE1 = convert(varchar(10), getdate(), 101).
Microsoft Great Plains/Navision/Axapta/Solomon/Microsoft CRM/Small Business Financials ERP, based on MS SQL Server DB platform and all this nice suite is working under Microsoft Windows 2003 Server. Combining Microsoft Business Solutions Great Plains ERP with non-Microsoft Business System or CRM. Microsoft CRM would integrate with Oracle
smoothly. Again in our opinion you'd rather pay for small or moderate customization to budget CRM solution to have work done. Microsoft CRM or SalesLogix would do the job.
He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C. If you have Microsoft Great Plains - you can use MBS CRM-GP integration tool, based on BizTalk. Then, when coding is done and implemented - you may switch to your internal developers to support custom pieces. Microsoft CRM is very innovative from the support side. It means that Microsoft CRM partners tend to go to the nation-wide and international market to sell, implement and support the application.
Our opinion is based on our Microsoft Business Solutions Great Plains, Microsoft CRM sales and marketing campaign to large businesses in the following industries. You should be ready to do presentation over the web session, and close the deal over the phone or skype. IT folks are doing their duties and searching on google, yahoo, msn, altavista. We believe that future ERP system sales will be mostly done to the specialists, not to the top and so, the selling strategy should be adjusted. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http.
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. 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. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft Great Plains, Microsoft CRM, Microsoft RMS customization company, based in Chicago, Los Angeles, San Francisco, San Diego, Boston, New York, Houston, Dallas, Miami, Atlanta, Minneapolis, Seattle, Canada, UK, Australia and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer. You need stored proc if temp tables are required to do intermediate job in your SQL query.
Microsoft Great Plains is now targeting large and midsize businesses and being matured ERP has advanced, but still very simple in use modules and features. Lockbox is Dexterity piece, so it is in the hand of Dexterity Developer, if you need to improve it for your corporation. VBA Modifier and Continuum are also available. Virtually if you have corporate account in any bank - lockbox processing module does the job - because you map lockbox file at your will in Lockbox Maintenance screen. None, Document Number (when you have ACH), Due Date/Oldest Document, Due Date/Oldest Invoice (other than invoices you apply manually), Document Date, Specific Invoices (and you specify them in the list.
Microsoft Great Plains, Microsoft CRM, Navision and Microsoft RMS. When you are small - you can not play this card - your partners will not do business with you in the future. Pay your people and subcontractor - There was popular technique of trying to negotiate down the price and do not pay in time. This game is not good, but it is acceptable in the case of huge corporation. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Colorado, Texas, New York, Georgia and Florida, Canada, UK, Australia, Brazil, Mexico ( http.
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. 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. Create Stored Procedures - when you need parameters to be transferred to the SQL statement - you need stored procedure. You need stored proc if temp tables are required to do intermediate job in your SQL query. Net, Crystal Reports and Microsoft CRM SDK developer.
It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision. This is not supported by MBS technical support - but you can rescue to this technique if you have to get job done. We've described above the options to use when this tool doesn't do the job. But - in real world this is not always true - you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc. MS CRM Customization tool - this is rather end-user tool and we don't describe it here - read the manual.
You have legacy ASP application, where you capture orders from your customers and you want these orders be transferred to the CRM as activity. If you want to capture these emails - you have to do it in Microsoft Exchange event sink. Then this email will not follow into MS CRM (because it doesn't have GUID in the header and so is ignored by CRM Exchange connector. There maybe scenario when you want to capture and analyze in the sink all the outgoing emails - this is even more complex - y. Never create your custom SQL objects (like stored procedure, SQL view, table) in MS CRM database.
|
|