Free Articles, Free Web Content, Reprint Articles
Thursday, July 18, 2019
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles

Dynamics GP California Partner: FRx Reporting Technical Notes

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  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 folksHealth Fitness Articles, but as real technical consultants.  If you prefer skype: albaspectrum

Source: Free Articles from


Andrew Karasev, Alba Spectrum , 1-866-528-0577  Serving ERP and MRP community since 1994, local service in Chicago, Houston, San Diego, Atlanta, Los Angeles. Information portal:  We serve you USA and Canada nationwide from our SAP Business One call center: California, Illinois, New York, Florida, Minnesota, New Jersey, North and South Carolina, Georgia, Louisiana, Texas, Ontario, Quebec, Washington, Missouri, Iowa, Nebraska, Kansas, Colorado, Nevada, New Mexico, Utah, Arizona, Montana, Oregon, New York, New England. International clients welcome from Australia, New Zealand, Oceania, South Africa, UK, Brazil, Caribbean, Russia, Central America

Home Repair
Home Business
Self Help

Page loaded in 0.038 seconds