Microsoft Dynamics GP reporting tools include FRx, SSRS, ReportWriter, Analytical Reporting, plus third party tools, such as Crystal Reports, Excel, Microsoft Access. If you need training on creating and maintaining Balance Sheet, Profit and Loss Statement, please review FRx user guide or our articles on the subject.
This small publication should give you some highlights on how to do automatic mass modification for such FRx building blocks as Row Formats. Please, note that FRx itself doesn't validate on the design phase if account or natural segment code exists in Great Plains GL Account Master file or not, so our method is not compromising FRx metadata consistency:
1. Specification Set file in Sysdata folder. If you are creating FRx catalogs in Default specification set, they are likely stored in FRxRpts.f32 file. Extension of this file might be a bit misleading, but it is in fact Microsoft Access Database file, however it is encrypted (MS Access password retrieval is outside of the scope here, take your own research). All FRx Catalogs (reports), Column Layouts, Row Formats, Reporting Trees are stored in this database as records in respected tables. For example, if you would like to change specific Row Format, review these tables: Row_Master, Row_Detail, Row_Link_Control, Row_Link_Detail. If you would like to go even further in your FRx exercise review AcctSetMaster table, where you should be able to see all the account sets, if you deploy these constructions on FRx Row Format
2. Row Format mass modification. If you would like to quickly remap huge FRx report to the company with similar account format, but with different portions of Natural Segment or Full Account - you should be able to do this in the tables, mentioned in paragraph #1
3. Microsoft Access Lock files. These are with MDL extension. If you are working with Mass modification of FRx specification set, you should avoid FRx users to be logged in. If you are generic programmer and not FRx user, the simplest way to understand if somebody is using FRx is to look at Sysdata folder if any MDL file is there.
4. For the rest of us, who are not programmers, but rather Dynamics GP and FRx Financial Reporting users. FRx has links to several major Corporate ERP applications, among them Dynamics GP Great Plains, Solomon Dynamics SL, Axapta Dynamics AX, Epicor, Navision Dynamics NAV. FRx has links to General Ledger module, where it respects Historical, Open and Work Transactions, the details of these transactions are available if you allow it on FRx report as drill downs. FRx reporting tree allows you to consolidate multiple companies, plus you can consolidate Excel worksheets on your FRx report, in the case when your Corporate ERP for foreign country is not FRx compliant - good example is SAP Business One driven Branch in Brazil, where SB1 is localize and Dynamics GP is not
5. How to get help? Please, feel free to call us: 1-866-528-0577, outside of USA: 1-630-961-5918 or email us help@albaspectrum.com We are very technical and real Dynamics GP Dexterity, SAP Business One SDK programming gurus. We have Great Plains Software Development Factory and could support unlimited Dynamics GP Customization and Programming needs. Plus we speak English, Chinese, Spanish, Portuguese, Russian, and not only as native speaking sales folks, but as real technical consultants. If you prefer skype: albaspectrum
Dexterity Customization for Dynamics GP Evaluation Level Paper
When you are developer it is always a good idea to read technical manuals. But if you was just assigned to the IT team to decide if Dexterity is the right tool to customize your ERP application then first you need something which is in style of ‘easy reading papers’ or FAQ
Planning Dynamics GP Customization in Large Corporation
If you are reading this page then chances are high that you were not able to find ISV add-on and need customization project. Let’s talk about planning, quality assurance and future event such as version updates.
Dynamics GP Invoice Logo Attributed to Specific Company or Crossing the Borders of Three SOP Forms
Initial Great Plains Dynamics architecture had three SOP Invoice forms: Long, Short and Blank. Modern GP is popular in scenarios where you have more than three companies under one business entity umbrella
