|
FRX for Microsoft Great Plains: advanced techniques - Excel, Cash Flow, Consolidation
By Andrew Karasev
Microsoft Great Plains
has multiple reporting options: Report Writer, Crystal Reports, SQL Server
Reporting services, but the most popular tool for financial reporting is still
(and remains) FRx. If you are Controller - you probably use FRx reports on the
weekly basis and have a need in advanced options. FRx was available for all the
major Great Plains versions, MS SQL Server, MSDE, Ctree, Pervasive SQL/Btrieve
database platforms. In this small article we would like to give you highlights
on FRx reporting.
Cash Flow.
By one reason or another we find customers who are complaining about their
current Microsoft Business Solutions partner - more specifically that
consultants are not capable to design Cash Flow report . They easily design
P&L, Balance Sheet, but not Cash Flow. We would like to give you our opinion
that Cash Flow just needs good understanding of P&L and Balance Sheet accruals
and in FRx you can create cash flow from P&L with adjustments on non-cash
accruals from BS - this is well described in Accounting textbooks as Cash Flow
indirect method.
Excel.
This is very typical problem. When business is small or midsize - and it owns
several legal entities/companies - the small entities might have no accounting
application, but Excel tables (or QuickBooks that exports to Excel). In this
situation you should consider building consolidated reports in FRx, pulling
info from Multiple Great Plains companies and Excel. You should use link menu
item for the Column in Row Format and have it as GL+Worksheet (Excel or Lotus
1-2-3) or External Worksheet. GL+Worksheet is the easiest - you specify your
Excel file and worksheet in this form [C:MyExcel.XSL]P&L in Worksheet File
Name and then you should understand the syntax in the Row layout - such
identifiers as CPO (Column Period Offset) or RPO (Row Period Offset). These
identifiers help you when you have either column with your fiscal periods (say
twelve months) or row and want to adjust your report to the period
automatically - click on Report Date - you will see Base Period - this base
Period should be the offset amount - horizontal (CPO) or vertical (RPO)
Consolidation.
This topic is usually self explanatory, however you should know the classic
accounting consolidation principles - such as inter companies consolidation
accounts (exclude them from your consolidated report).
Technical
Issues/Service Packs. Well - FRx
has to deal with multiple accounting applications and this leads to reasonably
high number of bugs in its releases. Good example is - in initial FRx 6.5
when you use (C=D10+D12)/CPO - you get 0 or blank instead or YDT or Current
summary. As a persistent GP support specialist for your company you should
login into customer source and check for the latest FRx service pack and
issues fixed in this patch
Happy designing! if you
want us to do the job - give us a call 1-866-528-0577!
help@albaspectrum.com About the Author Andrew Karasev is Chief
Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains,
Microsoft CRM customization company, serving clients in Chicago, California,
New York, Texas, Florida, Georgia and having locations in multiple states and
internationally (
http://www.albaspectrum.com ), he is Dexterity, SQL, C#.Net, Crystal Reports
and Microsoft CRM SDK developer.
Article Source: http://www.simplysearch4it.com/article/1756.html
If you wish to add the above article to your website or newsletters then please include the "Article Source: http://www.simplysearch4it.com/article/1756.html" as shown above and make it hyperlinked. |
Some other articles by Andrew Karasev | SAP Business One Implementation for Multinational Companies with subsidiaries in Brazil SAP B1 has over 200 installations in Brazil at this time and the number of new customers is growing. In this article we would like to recommend SAP BO as ERP system for ...
SAP Business One in Illinois: implementation, upgrade, customization, integration Chicago metropolitan area and downstate Illinois might be characterized as mid-west distribution place. This means that we see large number of diversified mid-size businesses, engaged in light assembly, ...
SAP Business One Chicago Market Review, plus customization, integration & data conversion SAP B1 is becoming more popular in the USA, increases number of implementation each year substantially. Originally designed by one of the Israel software development companies, ...
Microsoft Dynamics GP Office Stack Integration advances – Microsoft Great Plains Dynamics GP is on the way of Microsoft Dynamics or former Microsoft Project Green advances. Great Plains Dexterity is still a core of ...
eConnect and Microsoft Dexterity: Dynamics GP development tools comparison notes This article is dedicated to Microsoft Great Plains eCommerce and web software development primarily, plus Microsoft Dynamics GP customization, integration, data conversion and reporting. As software programmer you should know where one customization ...
Microsoft Dynamics GP Dexterity Customization Microsoft Great Plains software development, customizations, reporting. Microsoft Dexterity programming as reliable alternative to newer technologies and platforms, such as .Net, C# and VB MS Visual Studio development, eConnect, XML: Web Services.
Alba Spectrum ...
|
|
| |