by: Vladimira Sikorova.
If your answer is “yes“ to any of these questions, I recommend you to go on reading this article.Let's imagine you work with let's say three databases. Whenever you feel the need to connect to the database and execute SQL code, you w...
by: Adam Sturo.
System tables are the groups of table that helps sql server to track the information regarding users, databases, tables, replications tasks and so many task and also helps in sql query just like insert query, delete sql query, update sql ...
by: Andrew Karasev.
Microsoft Business Solutions stakes on Microsoft Great Plains as main Accounting/ERP application for US market. At the same time it seems to be staking on Navision in Europe and has Axapta as high end large corporation market competitor t...
by: Andrew Karasev.
Prior to the nice time when you will be looking and analyzing SQL script itself, it is good idea to give you some highlights on the join we utilize here. ?We have to unionize GP open and history PM tables.? In Great Plains the posting lo...
by: Andrew Karasev.
Microsoft SQL Server is the leader for inexpensive and middle size SQL solutions. Plus it is now capable to serve large enterprise on Microsoft Windows platform. Crystal Reports is the most flexible tool on the market and it has market r...
by: Andrew Karasev.
As IT person you may or may not have a lot of GP architecture knowledge, this is why we would like here to orient you in this subject of transferring.? We would like to stress here, that this routine of transfer typically is something th...
by: Andrew Karasev.
Data querying. Microsoft Great Plains has decent ReportWriter, which allows users to create and modify existing reports, however the recommended tool, and you will soon understand that if you need really challenging reports (Sales ...
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...
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...
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...
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...
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<...
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...
by: Robert Horowitz.
Microsoft Business Solutions promotes Navision (former Attain) on US market as excellent manufacturing applications (formerly it was promoting Great Plains). Navision is available on its native (solid rock and recommended databse) and Mic...
by: Robert Horowitz.
Microsoft Business Solutions Navision serves both European and American megamarkets. It was originally written by Denmark-based Navision Software in its own proprietary language C/SIDE (Client/Server Integrated Development Environment). ...
