Dynamics,California,Partner,FR computer Dynamics GP California Partner: FRx Reporting Technical Note
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
This small publication should give you some highlights onhow to do automatic mass modification for such FRx building blocks as RowFormats. Please, note that FRx itselfdoesn't validate on the design phase if account or natural segment code existsin Great Plains GL Account Master file or not, so our method is notcompromising FRx metadata consistency: 1. SpecificationSet file in Sysdata folder. If you arecreating FRx catalogs in Default specification set, they are likely stored in FRxRpts.f32file. Extension of this file might be abit misleading, but it is in fact Microsoft Access Database file, however it isencrypted (MS Access password retrieval is outside of the scope here, take yourown research). All FRx Catalogs (reports),Column Layouts, Row Formats, Reporting Trees are stored in this database asrecords in respected tables. Forexample, 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 yourFRx exercise review AcctSetMaster table, where you should be able to see allthe account sets, if you deploy these constructions on FRx Row Format 2. RowFormat mass modification. If you wouldlike to quickly remap huge FRx report to the company with similar accountformat, but with different portions of Natural Segment or Full Account - youshould be able to do this in the tables, mentioned in paragraph #1 3. MicrosoftAccess Lock files. These are with MDLextension. If you are working with Massmodification of FRx specification set, you should avoid FRx users to be loggedin. If you are generic programmer andnot FRx user, the simplest way to understand if somebody is using FRx is tolook at Sysdata folder if any MDL file is there. 4. Forthe rest of us, who are not programmers, but rather Dynamics GP and FRxFinancial Reporting users. FRx has linksto several major Corporate ERP applications, among them Dynamics GP GreatPlains, Solomon Dynamics SL, Axapta Dynamics AX, Epicor, Navision DynamicsNAV. FRx has links to General Ledgermodule, where it respects Historical, Open and Work Transactions, the detailsof these transactions are available if you allow it on FRx report as drilldowns. FRx reporting tree allows you toconsolidate multiple companies, plus you can consolidate Excel worksheets onyour FRx report, in the case when your Corporate ERP for foreign country is notFRx compliant - good example is SAP Business One driven Branch in Brazil, whereSB1 is localize and Dynamics GP is not 5. Howto get help? Please, feel free to callus: 1-866-528-0577, outside of USA: 1-630-961-5918 or email [email protected] We are verytechnical and real Dynamics GP Dexterity, SAP Business One SDK programminggurus. We have Great Plains SoftwareDevelopment Factory and could support unlimited Dynamics GP Customization andProgramming needs. Plus we speakEnglish, Chinese, Spanish, Portuguese, Russian, and not only as native speakingsales folks, but as real technical consultants. If you prefer skype: albaspectrum
Dynamics,California,Partner,FR