Dynamics AX Data Cleansing and How to Plan Historical Transactions Migration from Legacy Accounting

December 22, 2017 by  | Leave a Comment Filed under: Computer 

There are several technologies and tools in AX to help you with data conversion.  We should mention Excel Import, .DAT, SQL Server Integration Services, AIF web services and of course manual data entry. It is not really recommended to do large scale data conversion and restrict this (read on...)



SAP Business One Data Migration Service Exporting Historical Documents from Great Plains

December 22, 2017 by  | Leave a Comment Filed under: Computer 

Data Conversion phase should be taken seriously as it is one of the most popular reasons for Corporate ERP implementation project to fail. It is recommended to do testing and final data import into Business One in Data Transfer Workbench where you first have to work out CSV templates (read on...)

Microsoft Dynamics GP Historical Year Reopening Notes

December 17, 2017 by  | Leave a Comment Filed under: Computer 

If your organization deploys Dynamics GP or its older versions, known as Great Plains Dynamics, eEnteprise on Microsoft SQL Server and you have the need to reopen historical year, here are some highlights for you. Historical year reopening could be required if you need to do (read on...)

Microsoft Dynamics GP SQL Scripting – Historical Aged AP Trial Balance Example

December 17, 2017 by  | Leave a Comment Filed under: Computer 

In this small technical article we will give SQL script to build up something like Crystal Report or even now becoming popular SRS (MS SQL Server Reporting Services) report.  You can envelop this script into SQL stored procedure Prior to the nice time when you will be looking and (read on...)

Recreating Dynamics GP PM Historical Trial Balance Report in Crystal

December 17, 2017 by  | Leave a Comment Filed under: Computer 

We already released several small publications, where the progress of business logic replication was reported.  As you may already realized – Great Plains Report Writer print outs are sort of difficult to export to Excel. Crystal Reports at the same time are perfect in data (read on...)

Dynamics GP Historical Journal Entry or Posting into the Closed Year

December 17, 2017 by  | Leave a Comment Filed under: Computer 

In Microsoft Dynamics GP in General Ledger you can only enable posting transactions into historical year, but only to the most recently closed one Sometimes you may end up in the situation, when you have to redo multiple GL related transaction batches, one of the examples might be (read on...)

SAP Business One Migrating Historical Data from Legacy Accounting ApplicationData conversion project

December 17, 2017 by  | Leave a Comment Filed under: Computer 

Data conversion project might be neglected in its planning phase and this fact might lead to implementation going over budget and even the desire to seek for second opinion. Let’s review general recommendation of data migration theory for Corporate ERP application and some practical (read on...)

Dynamics GP AP Historical Trial Balance Recreation in Crystal Report

December 17, 2017 by  | Leave a Comment Filed under: Computer 

From time to time you can hear Microsoft Dynamics GP users complains about Report Writer reports inflexibility, especially when you are trying to export something like GL Trial Balance or AP Historical Trial Balance report.  Report Writer is Great Plains Dexterity coded module and its text file (read on...)