Articles, tagged with "table structure", page 1
Crystal Reports for SQL Based ERP Systems: SAP Business One, Microsoft Dynamics
SQL Server opens new horizons in Crystal Reports design and deployment. Here you can separate the report presentation from data selection layer. Instead of linking tables directly in CR you can now create SQL View or Stored Procedure and test their resu...
Dynamics AX Initial Data Import Phase and Exporting Historical Transactions from Great Plains
Data conversion especially historical documents move from one ERP system to another is something not recommended but sometimes required. In Axapta such migration technology as Excel Import is popular and you may consider doing it internally without appea...
SEO Norway-Focal Suggestions For Optimizing Your web page's Positioning
Practically all website owners are seeking ways to get better outcome from their web sites. They would like to enhance their website's position and get better rankings in serps. This quest for improved results, known as search engine placement, can be...
Dynamics AX Converting Data from Great Plains Dynamics and Older DOS Version
Both former Axapta and former Great Plains are now members of Microsoft Dynamics ERP family. However at this time, July 2011, there seems to be no migration tool to move your data from GP to AX. Probably the easiest and user friendly tool in AX to migra...
HTML Table Elements and SEO The Complete HTML Reference Guide for SEO
Lets analyze the HTML table elements from a Search Engine Optimization perspective. According to W3< those elements are: , , , , , , , , and .Their purpose is to structure tabular data within your web documents. As mentioned in many of my previous artic...
An Overview Of The Objects Present In Access To Help Access Experts
Microsoft access is modern software that helps access programmers in creating tables, queries, forms and reports easily. The advanced technology enables you to connect all prepared data together with macros. Access also has an advanced data manipulation s...
SQL SERVER Change Order of Column In Database Tables
One question I received quite often. How to change the order of the column in database table? It happens many times table with few columns is already created. After a while there is need to add new column to the previously existing table. Sometime it make...
Tables in Dynamics GP: Where to Find, Categories, Linking in Reports and SQL Queries
Former Great Plains has special naming convention for its tables and the names are not self-explanatory, as this application was designed in earlier 1990th, where multiple competing DB platforms often used alphanumeric conventions. We would like to walk ...
Dynamics GP Customer Email Information
If you are programming integration to this Corporate ERP application as developer you may pose legitimate question about where customer email record is stored. If you know how access table structure via user interface, the first natural way is to guess t...
Supporting Dynamics GP, Great Plains and GPA for DOS versions
If you feel that others Microsoft Dynamics resellers are not willing to talk to you due to the fact that you are on outdated Corporate ERP version, the help is available. In fact, some GP partners specialize in old version support, customization, reporti...
Dynamics GP Transition to Microsoft Management Reporter and Comparison with FRx
With the introduction of Management Report for Microsoft Dynamics ERP in 2010 the traditional financial reporting tool FRx was deemphasized and recommended to be replaced by MMR. We tried several migration and we would like to share our impression and cu...
MS SQL Recovery Made Easy with Software from DiskInternals
MS SQL Recovery is a complete solution for recovering data from MS SQL databases. In a single package, the tool combines some powerful recovery algorithms allowing database administrators to easily recover damaged or deleted MS SQL databases as well as co...
How to Restore SQL Database from .bak Script?
SQL Server has files saved with .mdf extension. These files are so valuable that losing them cannot be compromised. However, there is possibility of losing them as SQL can lead to corruption owing to various uninvited reasons like unexpected application s...
Dynamics GP Programming - Where to Start
If you are happy with your new Corporate ERP system implementation, which might be categorized as phase one, the next phase is probably about some custom features. How about the idea to change field names and their positions, maybe add new fields on the ...
Dynamics GP Projects: or How to Customize my Corporate ERP
Microsoft Dynamics GP is usually sold and implemented through Dynamics GP VAR channel. When your new Corporate ERP system is implemented and you are now in production phase, entering transactions, printing reports from Great Plains, there is less support...