Microsoft Dynamics GP SQL Reporting: overview for consultant
by: Andrew Karasev.
Plus SQL has advantage of joining GL with SOP, POP, IV and produce aggregated queries for specific set of posted transactions. In this small article we will show you how to produce Balance sheet for account segment.Let’s assume y...
Microsoft GP SQL Scripting: repairing lot number
by: Andrew Karasev.
Below we would like to give you brief excurse to lot number tracking and provide fixing scripts:Item Lot Number Master table, IV00300. This table gets record when lot is received at the specific date, please familiarize yourself wi...
Microsoft Great Plains SQL Reporting and data fixing
by: Andrew Karasev.
This is beginner level SQL scripting article for DB Administrator, Programmer, IT Specialist Our and Microsoft Business Solutions goal here is to educate database administrator, programmer, software developer to enable them support Micro...
Microsoft Retail Management System (RMS) SQL Customization
by: Andrew Karasev.
Microsoft RMS Architecture and data flow. As it is POS automation application, it assumes that all the POS transactions are originated at the store. The mechanism used is worksheets. When store is closed – Headquarter...
SQL scripts for Project Accounting - Microsoft Great Plains
by: Andrew Karasev.
The first script transfers salesperson and sales territory from Customer master file to Project master tableupdate PA01101set SLPRSNID=b.SLPRSNID,SALSTERR=b.SALSTERRfromPA01101 ajoin RM00101 b on a.CUSTNMBR=b.CUSTNMBRwhere a.SLPRSNID<...
CRM Integration with third party SQL Applications
by: Andrew Karasev.
Microsoft CRM – Client Relationship Management package from Microsoft Business Solutions was initially designed to be customizable with Microsoft Visual Studio.Net and one of its programming languages – C#.Net or VB.Net. You can use A...
Microsoft Great Plains on Ctree
by: Andrew Karasev.
As you probably know, when Microsoft purchased Great Plains Software – the whole strategy for Great Plains Dynamics/eEnterprise line was changed. Initial GPS strategy was to maintain DB platform independence – via it’s C-written eng...
Custom Emailing for Microsoft Great Plains Dynamics Gp: Sql Mail
by: Andrew Karasev.
For Microsoft Dynamics GP ERP you can deploy Business Portal and BP module - Electronic Document Delivery, however it is not available for GP Business Ready product line, where you have to go for custom solution. In this small article we...
Microsoft CRM Development
by: Andrew Karasev. Microsoft CRM is new player on the CRM software market. The whole conception behind CRM seems to be different. In case of traditional CRM software (Siebel, Oracle) - the application was designed with platform independence in mind. Microsoft...
Microsoft Great Plains Dynamics
by: Andrew Karasev.
Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then it was Great Plains Dynamics were available on Pervasive SQL.2000 or Btrieve. I am confident that majority of database admini...
Microsoft Dynamics GP Autoposting server
by: Andrew Karasev.
This is actually architectural restriction of Microsoft Dynamics GP, former Great Plains Dynamics Dexterity: work documents must be reviewed by GP operator and manually posted through GP interface. These facts had Alba Spectrum dev...
Microsoft Dynamics GP, New Windows Server
by: Andrew Karasev.
Our approach will be to give you architecture understanding, so you could make your decision knowing the options and technical reasons.? You should be familiar with such concepts as Microsoft SQL Server and its versions: 7.0, 2000, 2005,...
What Are The Benefits Of Using Microsoft Exchange Server?
by: Amy Nutt.
Microsoft Exchange Server is software product designed to make emailing faster and more efficient. As email is now a critical function in the business environment and a great deal of business is now conducted by email, many companies are ...
What Are The Benefits Of Using Microsoft Sharepoint Server?
by: Amy Nutt.
One of the most popular software packages for businesses today is Microsoft SharePoint Server. Microsoft SharePoint Server is a very popular program for businesses, because it helps to improve business processes without the requirement of...
Microsoft Office Sharepoint Server
by: Synapse India.
What is Microsoft Office Sharepoint Server?Microsoft Office Sharepoint Server is a kind of an enterprise information portal. It acts as a common framework for activities including document management. The specific features of this advance...
