| ; Excel, Cash Flow, Consolidation | | | | FRx, pulling info from Multiple Great Plains companies |
| | | | and Excel. You should use link menu item for the |
| Microsoft Great Plains has multiple reporting options: | | | | Column in Row Format and have it as |
| Report Writer, Crystal Reports, SQL Server | | | | GL+Worksheet (Excel or Lotus 1-2-3) or External |
| Reporting services, but the most popular tool for | | | | Worksheet. GL+Worksheet is the easiest — |
| financial reporting is still (and remains) FRx. | | | | you specify your Excel file and worksheet in this |
| Microsoft Great Plains has multiple reporting options: | | | | form [C:MyExcel.XSL]P&L in Worksheet File |
| Report Writer, Crystal Reports, SQL Server | | | | Name and then you should understand the syntax in |
| Reporting services, but the most popular tool for | | | | the Row layout — such identifiers as CPO |
| financial reporting is still (and remains) FRx. If you are | | | | (Column Period Offset) or RPO (Row Period Offset). |
| Controller — you probably use FRx reports on | | | | These identifiers help you when you have either |
| the weekly basis and have a need in advanced | | | | column with your fiscal periods (say twelve months) |
| options. FRx was available for all the major Great | | | | or row and want to adjust your report to the period |
| Plains versions, MS SQL Server, MSDE, Ctree, | | | | automatically — click on Report Date — |
| Pervasive SQL/Btrieve database platforms. In this | | | | you will see Base Period — this base Period |
| small article we would like to give you highlights on | | | | should be the offset amount — horizontal |
| FRx reporting. | | | | (CPO) or vertical (RPO) |
| - Cash Flow. By one reason or another we find | | | | - Consolidation. This topic is usually self explanatory, |
| customers who are complaining about their current | | | | however you should know the classic accounting |
| Microsoft Business Solutions partner — more | | | | consolidation principles — such as inter |
| specifically that consultants are not capable to design | | | | companies consolidation accounts (exclude them from |
| Cash Flow report . They easily design P&L, | | | | your consolidated report). |
| Balance Sheet, but not Cash Flow. We would like to | | | | - Technical Issues/Service Packs. Well — FRx |
| give you our opinion that Cash Flow just needs good | | | | has to deal with multiple accounting applications and |
| understanding of P&L and Balance Sheet | | | | this leads to reasonably high number of bugs in its |
| accruals and in FRx you can create cash flow from | | | | releases. Good example is — in initial FRx 6.5 |
| P&L with adjustments on non-cash accruals | | | | when you use (C=D10+D12)/CPO — you get |
| from BS — this is well described in Accounting | | | | 0 or blank instead or YDT or Current summary. As a |
| textbooks as Cash Flow indirect method. | | | | persistent GP support specialist for your company |
| - Excel. This is very typical problem. When business is | | | | you should login into customer source and check for |
| small or midsize — and it owns several legal | | | | the latest FRx service pack and issues fixed in this |
| entities/companies — the small entities might | | | | patch |
| have no accounting application, but Excel tables (or | | | | Happy designing! if you want us to do the job - give |
| QuickBooks that exports to Excel). In this situation | | | | us a call 1-866-528-0577! |
| you should consider building consolidated reports in | | | | |