Recreating,Dynamics,Historical computer Recreating Dynamics GP PM Historical Trial Balance Report in
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Crystal Reports at the same time are perfect in data export and reformatting. The challenge of Historical Aging reports (both in Accounts Payable and Accounts Receivable modules) is complex business logic, which should be replicated in SQL Stored Procedure - it is very difficult to replicate this procedure without deep exposure to GP technical consulting and certifications in Dexterity and Dex source code programming. At this point we are ready to announce good progress in AP Historical Trial Balance report replication:1.Why Dynamics GP doesn't export Historical Aging report to Excel? This question could be well addressed to Microsoft Business Solutions, as Great Plains Small Business Financials 9.0 or earlier versions was tuned to export this report directly to Excel, and customers, who migrated away from SBF to Microsoft Dynamics GP 10.0 reported disappointment about the lack of this feature in high-end Dynamics 2.What are the challenges in SQL Stored Procedure, which is the base for Historical Trial Balance? Consider several scenarios. First - imagine you had historically Vendor invoice, which you decided to void few days after targeted aging date (in report). This record, when voided will be sent to RM30200 table (as you may know, all PM transactions go there when they are completely applied or in our case voided). If you would try to just do this small business logic passage in Crystal Report data expert wizard - please let us know and we will present you small pocket aquarium as the prize if you have success. Second scenario - PM30200 (History document header), PM30300 (history apply to) tables have various fields with questionable meaning : DOCDATE, DATE1, GLPOSTDT, ApplyToGLPostDate, ApplyFromGLPostDate. In suh situation, if you do not have access to Microsoft Dexterity source code programming - you may decide to give up3.Product versus Solution. If add-on is not ready to be implemented with clear instructions, we think that that product is still in the Solution phase4.Please feel free to call us 1-866-528-0577, [email protected]
Recreating,Dynamics,Historical