Import a Report into Dynamics GP without Corrupting the Reports.dic File

[av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-g8zfzo’]
[av_heading heading=’Import a Report into Dynamics GP without Corrupting the Reports.dic File’ tag=’h1′ link_apply=” link=’manually,http://’ link_target=” style=’blockquote classic-quote’ size=” subheading_active=’subheading_below’ subheading_size=’15’ margin=” margin_sync=’true’ padding=’10’ color=” custom_font=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-lab872mo’ id=” custom_class=” admin_preview_bg=”]
Mike Scalamogna, Director of Dynamics 365 explains how to avoid the risk of corrupting the imported file
[/av_heading]
[/av_one_full]

[av_one_full first min_height=” vertical_alignment=’av-align-top’ space=” margin=’0px’ margin_sync=’true’ row_boxshadow_color=” row_boxshadow_width=’10’ link=” linktarget=” link_hover=” title_attr=” alt_attr=” padding=’0px’ padding_sync=’true’ highlight_size=’1.1′ border=” border_color=” radius=’0px’ radius_sync=’true’ column_boxshadow_color=” column_boxshadow_width=’10’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” attachment=” attachment_size=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-acrhes’ id=” custom_class=”]

[av_image src=’https://nmq52a.p3cdn1.secureserver.net/wp-content/uploads/2022/11/Import-Report-into-GP-without-Corrupting-File.jpg’ attachment=’18100′ attachment_size=’full’ align=’center’ styling=” hover=” link=’manually,https://opalbiz.com/microsoft-dynamics/’ target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ copyright=” animation=’no-animation’ av_uid=’av-l962e6bj’ id=” custom_class=” admin_preview_bg=”][/av_image]

[av_hr class=’default’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” av_uid=’av-s6gtpj’]

[av_textblock size=” font_color=” color=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-l0mifgvu’ id=” custom_class=” admin_preview_bg=’rgb(255, 255, 255)’]
When you have a custom Report Writer report that you would like to import into Dynamics GP, you run the risk of corrupting the reports.dic file if users are logged in to the system. There is a way to get around this. Do not use the Customization Maintenance screen. Instead, launch Report Writer and user the “Import” function within Report Writer. I have a modified report that I would like to import, pictured below: 

I now want to import this report into the production reports dictionary.

1. Locate the reports dictionary you are going to be importing a report into and take a backup of it. I normally just use windows explorer to copy/paste a backup:

Report Writer 2

2. Take a copy of the reports dictionary where your modified report is saved. In this case, I saved that reports.dic file on my desktop:

Report Writer 3

3. Log in to the GP client that is connected to the reports dictionary that you want to import your custom report into.

4. Launch Report Writer (press ALT + F9)

5. Click “Reports”

Report Writer 4

6. Click “Import”

Report Writer 5

7. In the “Source Dictionary” field, locate the .dic file that has your custom report in it.

Report Writer 6

8. You will see your custom report in the list on the left hand side of the screen.

9. Click on the report, then click “Insert”

Report Writer 7

10. If the report already has been modified and you are overwriting previous modifications you would click “Yes”

Report Writer 8

11. Click “Import”

Report Writer 9

12. The “Reports to Import” list will be blank. The report is now imported and the dictionary is not corrupted.

13. Click “Close”

Report Writer 10

14. Click “File”, then “Microsoft Dynamics GP” to browse back to GP:

Report Writer 11

That’s it!

If you have any questions about this process, Dynamics GP, or other Dynamics products, reach out to our Dynamics team at Opal Business Solutions. We’re always happy to help.
[/av_textblock]

[av_hr class=’invisible’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-l8t8n0fb’ id=” custom_class=” admin_preview_bg=”]

[av_button label=’Learn More’ link=’manually,https://opalbiz.com/microsoft-dynamics/’ link_target=’_blank’ size=’x-large’ position=’center’ label_display=” title_attr=” icon_select=’no’ icon=’ue800′ font=’entypo-fontello’ color=’theme-color’ custom_bg=’#444444′ custom_font=’#ffffff’ av_uid=’av-jiak8jn0′ id=” custom_class=” admin_preview_bg=”]

[av_hr class=’default’ height=’50’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’ av_uid=’av-l8t8n0fb’ id=” custom_class=” admin_preview_bg=”]

[/av_one_full][av_one_full first min_height=” vertical_alignment=” space=” custom_margin=” margin=’0px’ link=” linktarget=” link_hover=” padding=’0px’ border=” border_color=” radius=’0px’ background=’bg_color’ background_color=” background_gradient_color1=” background_gradient_color2=” background_gradient_direction=’vertical’ src=” background_position=’top left’ background_repeat=’no-repeat’ animation=” mobile_breaking=” mobile_display=” av_uid=’av-g8zfzo’]
[av_heading heading=’TALK TO OUR TEAM‘ tag=’h2′ link_apply=” link=’manually,http://’ link_target=” style=’blockquote modern-quote modern-centered’ size=” subheading_active=” subheading_size=’15’ margin=” padding=’10’ color=” custom_font=” custom_class=” id=” admin_preview_bg=” av-desktop-hide=” av-medium-hide=” av-small-hide=” av-mini-hide=” av-medium-font-size-title=” av-small-font-size-title=” av-mini-font-size-title=” av-medium-font-size=” av-small-font-size=” av-mini-font-size=” av_uid=’av-1d5n3bb’]
What is Microsoft Power Automate? How does it fit into the Power Platform? Find all the answers here.
[/av_heading]

[av_contact email=’jhess@opalbiz.com, chorta@opalbiz.com, sales@opalbiz.com’ from_email=” title=” heading_tag=” heading_class=” button=’Submit Request’ on_send=” sent=’Thank you! Our team will be in touch ASAP’ link=’page,18′ subject=’Import a Report Writer Report into Dynamics GP Blog’ autoresponder_email=’chorta@opalbiz.com’ autorespond=” captcha=’active’ captcha_theme=’light’ captcha_size=’normal’ captcha_score=’0.5′ hide_labels=’aviaTBhide_labels’ form_align=” color=” av_uid=’av-iz45j’ id=” custom_class=” aria_label=” admin_preview_bg=’rgb(255, 255, 255)’]
[av_contact_field label=’First & Last Name’ type=’text’ options=” check=” width=” av_uid=’av-vqltj’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’E-Mail’ type=’text’ options=” check=’is_email’ width=” av_uid=’av-1bcbprc’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’Company’ type=’text’ options=” check=’is_empty’ width=’element_half’ av_uid=’av-ilp4n’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’Phone’ type=’text’ options=” check=’is_phone’ width=’element_half’ av_uid=’av-g4sif’ multi_select=” av_contact_preselect=”][/av_contact_field]
[av_contact_field label=’I’m interested in…’ type=’select’ options=’Dynamics GP, Dynamics Products, Microsoft Products, Other’ check=” width=” av_uid=’av-203zbb’][/av_contact_field]
[/av_contact]
[/av_one_full]

Related News