 Category :: Software Articles |
Author :: Andrew Karasev  |
| |
| Article Title :: How to Upgrade Dexterity Customization - Tips for IT Manager |
| |
| If you have Microsoft Great Plains and support it for your company and have light or heavy Great Plains customization, written in Dexterity – you need to know your options in upgrading Great Plains or migrating it from ctree/Pervasive to MS SQL/MSDE.
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. Today it is legacy and Microsoft Business Solutions is phasing Dexterity out.
(read full article) |
| |
 |  |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: SQL: Querying Microsoft Great Plains - Overview for Database Administrator/Developer |
| |
| Looks like Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary and runtime), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations. There are several reporting tools available and you definitely need to know which one to use for different types of reports.
If you are (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: Upgrading Great Plains Dexterity Customization - switching to new technologies: SQL, Crystal, eConne |
| |
| 1. Replace Dexterity cursor with SQL Stored Procedure
Dexterity was designed as multiplatform technology (primarily Btrieve, Ctree, SQL Server, potentially Oracle). Dexterity data retrieving mechanism is based on Range start, Range End, Get First and Get Next clauses. It is in fact similar, however a little bit slower to cursors in Transact SQL. Long ranges in Dexterity are good candidates for replacement by SQL stored procedures with update clause.
For example, consider to replace following Dexterity code: (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: John Kleb |
| |
| Article Title :: Microsoft Navision Customization Upgrade - Tips For Programmer/IT Specialist |
| |
| Currently Microsoft Business Solutions is on the way of creating so-called suites: Microsoft Financials, Microsoft Distributions, Microsoft HR, Microsoft Manufacturing. It is very difficult to say which product will be the core of which suite, but the best guess is this: Microsoft Great Plains - Microsoft Financials and probably Distribution/Supply Chain Management and HR, Solomon - Microsoft Project or Professional Services, Navision - Microsoft Manufacturing. If you have Microsoft Business Solutions Navision and support it for your company then you need to know some technical details about Navision version upgrade and what is going on behind the scenes, which options do you have in ca (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair - Overview For DBA's |
| |
| Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary DYNAMICS.DIC and runtime DYNAMICS.EXE), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.If you are database administrator who is supporting the version on Pervasive SQL.2000/Ctree – read this and yo (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators |
| |
| How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix:
Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'.Pervasive SQL/Ctree - if you have more than one user registered you can delete the user from GP: System->User Activity->Delete User. If you like to work on the file level - ask all the users to log off. On the server, where you (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Robert Horowitz |
| |
| Article Title :: Microsoft Navision Customization and Reporting - Tips For Programmer/IT Specialist |
| |
|
C/SIDE (Client/Server Integrated Development Environment) - The core of Navision is the C/SIDE. C/SIDE is the foundation for all the business management functionality of Navision. It is made up of five building blocks, called object types, which are used to create the application. These five object types are shared throughout Navision to create every application area, and give it a unified, consistent interface. This powerful language allows for the internal construction of new business logic and sophisticated reporting. Because of the internal nature of modifications it’s highly recommended that you develop all your code in “processing only” report objects and call (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Greg Lietz - |
| |
| Article Title :: Home Wireless Network Security Issues |
| |
| Running a business from home has its advantages, including no commute, a more accommodating work schedule, fresh coffee and home-cooked meals at any time you want.
But running a business from home using a home wireless local area network (WLAN) with your computer may lead to thievery of confidential information and hacker or virus penetration unless proper actions are taken. As WLANs send information back and forth over radio waves, someone with the right type of receiver in your immediate area could be picking up the transmission, thus acquiring access to your computer.
Here is a list of things that you should consider as a result of implementing a home wireless ne (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: Crystal Reports For Microsoft RMS - Overview For Developer/Report Designer |
| |
| If you are software developer or database administrator - we would like to give you the clues on Crystal Report creation for Microsoft RMS
Database: Microsoft SQL Server or MSDE - this means that you can deploy native SQL driver for connection or use ODBC for flexibility. Tables Structure – it is extremely self-explanatory: Customer, Transaction (invoices, returns, layaways and others), TransactionAmount, Cashier, Tender to give you examples Links - Usually master table has ID column and Transaction-related table links by [Entity]ID column: Transaction.CustomerID=Customer.ID to give the idea. This query will give you c (read full article) |
| |
| |
| |
| Category :: Software Articles |
Author :: Andrew Karasev |
| |
| Article Title :: Great Plains Customization Upgrade- Overview For CIO/IT Director |
| |
| Around the same time Microsoft made its move with .Net introduction and tried to gain portion of cheaper databases market: Pervasive SQL/Btrieve, Ctree/Faircom - and launched free MSDE database program. General direction for all its accounting systems was chosen - Microsoft announced future releases of so called Microsoft suites: Microsoft Financial, Microsoft HR, Microsoft Logistics, Microsoft Manufacturing to name a few. However Microsoft did not announce which product (Great Plains, Solomon or Navision) will become the base or will be transformed into each specific suite. Al these suites will be integrated into web-based Microsoft Business PortalThis move, probably wise in t (read full article) |
| |
| |
| |
| |
| Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 [59] 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 Next |
Article Categories
