Released on: 3, April 2007
, Author: Alba Spectrum Group
, Audience: Computers related
Microsoft Great Plains Dynamics GP is SQL driven applicationand SQL scripting should be good support for Finance department in analyzing theirfinancial positions, especially when you have cash flow responsible subdivisionswithin your company. Similar job can be done in such tools as FRx, Crystal Reports,however it is often too difficult to produce new FRx report, and it is too quick torun select scripts against your GL. Plus SQL has advantage of joining GL with SOP,POP, IV and produce aggregated queries for specific set of posted transactions. Inthis small article we will show you how to produce Balance sheet for accountsegment.
LetÂ's assume you have subdivisions, each of them has individual second segment onaccount. Following statement aggregates Debit-Credit summary for this segment (1001in the sample below):
select b.ACTNUMBR_1+ ' '+ b.ACTNUMBR_2, sum(DEBITAMT) - sum (CRDTAMNT)from GL20000 ajoin GL00100 b on a.ACTINDX
Source: Express-Press-Release.com
Related downloads
Integrate everything to Microsoft CRM. Scheduled imports/exports and synchronizations. The only tool you need in your Microsoft CRM Implementation project. Free download and Try!
Likeoffice dll is written for developers of .Net or VB6 who work with Microsoft Reporting Services. The dll file allows you to easily export any report to pdf format.
Manage your lists, prints address labels and works with post mail. You can use different databases to create personalized post mailing and direct mail campaigns, to customize all fields and keep notes of important customer information.
Likeoffice dll is written for developers of .Net or VB6 who work with Microsoft Reporting Services. The dll file allows you to easily export any report to pdf format.
ARKIIS is a powerful reporting tool for Microsoft IIS Administrators (4.0 / 5.x / 6.0)
Admin Report Kit for Windows Enterprise (ARKWE) is a powerful reporting solution for the Microsoft Windows Network. ARKWE collects configuration information about Windows domains & servers, users/groups, policies, events, services, etc.
myDBR is an innovative web based reporting solution for MySQL and Microsoft SQL Server with support for latest smartphones (Android, iPhone, and Symbian). myDBR reporting solution brings unparalleled speed of authoring even the most complex reports.
FactotumNOW IAS Reporting imports IAS/RRAS (Microsoft VPN) log files through an engine that can be installed onto the VPN/IAS server. IAS (Microsoft® Internet Authentication Service) statistics are then updated automatically every two minutes.
ARKES) is a powerful Microsoft Exchange Server reporting tool for System Administrators & IT Managers. ARKES assists in monitoring and tracking information about Exchange objects for efficient server administration and configuration reporting.
Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports.
Get RSS updates on latest computer technology and software related press releases 
You are welcome to include these headlines in your own pages. If you want to find out how to parse this RSS file please read our tutorial
How to parse RSS feeds with PHP.
