Great,Plains,San,Diego,ISV,Par computer Great Plains San Diego ISV Partner Newsflash: Dexterity Alte
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 ----------------------------------------------------------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
Here, if your case requires Dexterity programming, werecommend you to contract Dynamics GP ISV with Dex programming department,other option, such as altering tables in RW Reports.dic should be somethingthat you could do on your own: 1. Ifyou do not have the table available on the report. Lets assume you would need to see CustomerSummary table info on your SOP Order form for internal company needs and you donot see this table on SOP Blank Order Form. Open Report Writer, Click Tables, pick SOP_HDR_WORK table, Relationshipsand click New, pick secondary table Customer Master Summary, select from dropdown list the only key in Secondary table and pick field from Primary Table Customer Number. Now you can add fieldon the order for your internal review: Year To Date Sales, Customer Balance,Last Payment Date, Last Invoice Amount, etc. All this may help you in defining new table relationships in RW, howeveryou should now expect all the problems to go away, there is a restriction itis very difficult to cross module borders, meaning that it is not easy to linkSales and Purchasing table in the same report without customization in Dexterity 2. Crossingmodule borders. In this method youcreate Dexterity customization, move desired report into your newCustomization, then create function with rw_ prefix. This Dex function could be either nativelywritten in Dexterity Sanscript, or created in MS SQL Server as Function andthen prototyped in Dexterity as rw_* function. At this point, you should package your Dexterity add-on, and integrateit to your Dynamics GP workstation, outside of the scope of this article. Then in GP open ReportWriter, select productto be your custom add-on and modify your report there, rw_ function will beavailable in new calculated field. Thisis not all, now you will need to grant security to this new report, the type ofreport for security purpose is Alternate Modified Report 3. CrystalReports, Microsoft Access, SSRS. Allthese tools could also do the job for you, however you will have to beginbuilding up report from scratches (with some exceptions to SQL Server ReportingServices as some of desired reports could have templates ready there), while inRW you will need just small touches
Great,Plains,San,Diego,ISV,Par