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... Read >
Author: akarasev

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... Read >
Author: akarasev

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... Read >
Author: franfaoapo

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... Read >
Author: akarasev

HTML Table Elements and SEO – The Complete HTML Reference Guide for SEO

Let’s 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... Read >
Author: artsubpsm

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... Read >
Author: Schew Maker

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... Read >
Author: Sqlserver22

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 ... Read >
Author: akarasev

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... Read >
Author: akarasev

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... Read >
Author: akarasev

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... Read >
Author: akarasev

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... Read >
Author: James Cooper

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... Read >
Author: nestor anderson

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 ... Read >
Author: akarasev

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... Read >
Author: akarasev

User published content is licensed under a Creative Commons Attribution-NoDerivs 3.0 Unported License