I Advice - Computers and Technology

Microsoft Great Plains was designed as Dexterity application in earlier 1990th. At this time ReportWriter was the platform-independent Dexterity ba

According to USFDA, a combination product is one composed of any combination of a drug and device; biological product and device; drug and biological product

sed GP module and as we see through about 15 years – it still is an does the job. Of course, there are others reporting tool: Crystal Reports, Micr

; or drug, device, and biological product and fixed dose combination would include two or more combinations of drug.

Examples of combination products may in

soft SQL Server Reporting Services or SRS. In this small article we will try to give you additional tips on Report Writer:

• Trivia. REPORTS.DIC

lude drug-coated devices, drugs packaged with delivery devices in medical kits, and drugs and devices packaged separately but intended to be used together.

– this dictionary stores all your so-called modified reports for main dictionary DYNAMICS.DIC. If you install third party dex application or create

here is enormous increase in the number of combination products entering the market in the recent years. Combination products have proven advantages but fixe

your own customization – ReportWriter will be given the option to modify third-party or your custom reports. Consider storing Reports.dic in centra

d dose combinations are still in the process of convincing regulatory authority on their advantages over the single ingredient formulations.

Combination pro

location, on your file server for example and modify Dynamics.set file – specifying the path to this central dictionary

• Dexterity security realm

ucts have become life saving products for the pharmaceutical companies who doesn’t have many innovative molecules in their product pipeline and have been inc

The nice thing about ReportWriter report is the fact that you control report access via GP security. Compare to Crystal Reports – here you base y

easingly used in the product life cycle management. Even the companies having product patents are trying to extend their product life cycle through the combi

ur report (as a good practice) on SQL Stored Procedure or SQL view – which means that you use SQL Server security. Just to remind – GP security sys

nation products and maximize the revenues. But the companies involved in this practice are overlooking that they are burdening the patients both economically

em is stored in Dynamics database and it translates into SQL Server security - in SQL you can not directly use GP userid – due to the fact that use

and physically. They need to rightly judge the benefits of the combination products and they have to even look at the risks involved when combining the produ

password (which you use to login GP) is encrypted in SQL

• Simple data export tool. Besides GP SmartList or Explorer, you can simply create Repor

ts. Some of the combination products were well accepted by physicians while others suffered. Companies involved in development of combination products are fi

Writer custom report, base it on the table you need and add the fields from the above table – run this custom report and data is ready to be saved

ding difficulty in defining their combination products and facing various challenges from selecting a combination to marketing it.

Following aspects would a

into text file

• Popular Customized reports. SOP Invoice Long form if one of the most modified. Here you typically place your company logo, chang

dd to the challenges in developing combination products:

Which markets to tap where the combination products can do fairly well?
Which combination prod

address format, add comments. The second customization candidate is Purchase Order. The reason you use custom report writer reports is simple – y

cts are meaningful and rational?
Which therapeutic categories to select?
Which Combinations can address unmet needs of the patients?
Do combin

u like to print Invoice or PO from SOP Entry or POP entry forms directly, rather than launch Crystal Report and provide invoice number as a paramete

tions increase the patient compliance?
What would be the developing cost?
How to tackle the risks encountered during combination product developmen

• Version Upgrade. In most of the cases upgrade works fine. However, assuming we are upgrading GP custom reports – sometimes you need help. Whe

t?

As combination products don't fit into the traditional categories of drugs, medical devices, or biological products, the USFDA is in the process of devel

GP report in new version uses different calculated fields – you will need to analyze calculated fields of the old report and compare them to the on

ping new procedures for reviewing their safety, efficacy and quality.

Professional from academic institutions, pharmaceutical industries, health care indust

for new one and make changes.

• SRS & Crystal Reports. We often hear questions – which tool should we use, or even more direct – should we walk a

y and representatives from various regulatory agencies are working out to design the regulatory requirements for manufacture and sale of combination products

ay from all our Crystal Reports and redesign them in SRS? The answer is – probably you should wait, when SRS will be better integrated into GP mode

.

As there is an increasing trend of the combination products companies manufacturing such products should be able to tackle the problems involved in the de

. From the reporting tool power aspect – both CR and SRS require good SQL base query design, so data manipulation logic is typically out of the sco

elopment. They need to be wiser in analyzing the market trends and the regulatory requirements.

Companies that provide selfless information through particip

e (sql view or stored procedure) – the rest of the reporting job – list query results and group them by certain criteria – both tools are good in it

tion in industry events and feedback to regulatory authorities would be able to face the challenges and will be successful in developing combination products

HTTP = HTML link (for blogs, profiles,phorums):
<a href="http://www.iadvice.org.ua/article/177815/iadvice-ReportWriter-Microsoft-Dynamics-GP-Technical-Highlights.html">ReportWriter- Microsoft Dynamics GP Technical Highlights</a>

BB link (for phorums):
[url=http://www.iadvice.org.ua/article/177815/iadvice-ReportWriter-Microsoft-Dynamics-GP-Technical-Highlights.html]ReportWriter- Microsoft Dynamics GP Technical Highlights[/url]

Superachievers approach each situation from a different point of view. They focus on the outcome in each situation. This type of thinking separates the best from the rest. Focus on outcomes and improve your career.

Finding the best place to purchase your merchandise is of paramount importance to the small business owner. Sometimes the items that you want to sell in your store are hard to find at reasonable prices.

What a nice thing to hear that you've joined one of the most heralded and lucrative work-at-home businesses in the world - the online affiliate program. It's even heart-warming that you've settled for telecom affiliate program. Once again, accept my sweet congratulations!

Tags

Links

I Advice - ReportWriter- Microsoft Dynamics GP Technical Highlights

Related Articles: