Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writer Error
Microsoft Dynamics GP (Archived)

Report Writer Error

(0) ShareShare
ReportReport
Posted on by Sunil Chhabra 1,930

I modifed the W2 report in the Report Writer.

I removed some of the fields from the layout as they were not needed. The report was working fine - until I made one last change to the layout. At no time I modified or deleted any of the Calculated fields. Now when I try access the report GP Crashes

If I try to export the package - I get an error Calc Field ' UpperAddress1' references a non-existent' calc field.   Again I did not delete any fields  - but merely removed them from the layout.

Now the problem is I cannot access this report in the report writer as GP crashes.  Is there any way to recover this as i spent a few hours lining up all the fields.

Thanks

 

*This post is locked for comments

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    Re: Report Writer Error

    Yes actually these were w2's so we used the 4 up laser forms.

    On the other hand I do not have any issue with the lining up of the 1099 forms.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Report Writer Error

    Sunil,

    Did you change the form type to 'Single Feed'? The default is '1 wide - Continuous'. It's the same thing with Forms 1099. Anybody have an Okidata printer laying around?

    Kind regards,

    Leslie

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    Re: Report Writer Error

    Leslie thanks for your response. I have recreated the reported and just moved the fields that are not needed on the corner of the page.  On another note, I do have the year end tax update installed and purchased the forms from Deluxe Item TF5211, and their web site indicated it was for GP. With the exception of employer address - no other field lined up  - some were slightly off, while others were completely off.  

    Thanks

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Report Writer Error

    Hi Sunil,

    I have not had any problems with the w-2 line ups. Did you load the year-end update, often it includes tweaks to the W-2 and 1099 reports.

    You mentioned "I removed some of the fields from the layout as they were not needed. ", sometimes the calculated fields are based on other calculated fields. If they are not needed, I recommend they be made invisible vs being removed. Deleting the fields from the layout is good enough to generate the error, deleting the field from the field list is not the control.

    Note to self, never delete fields from the layout, just make them invisible.

    Kind regards,

    Leslie

  • Sunil Chhabra Profile Picture
    Sunil Chhabra 1,930 on at
    Re: Report Writer Error

    Francisco - Happy New Year.

    sorrry but I already tried it - it crashes my gp. No idea why the report got corrupted. I had it lined up properly - then I had to add one more field for box 12 - saved it and printed it again - no problem. Went back and fine tuned the alignment of couple more fields. Then tried to run the report- GP crashed. Try to open the report in GP report writer - gp crashes. Try to export the report - can't do it because there are ciruclar formulas in the calc fields. Looks like I have to invest another few hours lining up the boxes - I have to expect it when you dealing with a report writer that was written in Dark Ages - pure piece of Junk.

    You would think that as part of the year end maintenance they would update the w2 report so prints already lined up on the forms - but oh well.  Thanks for your assistance though!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Report Writer Error

    The fastest way is to rename your current REPORTS.DIC, then open GP again, go to report writer, this process will recreate the REPORTS.DIC to a new one, then once in rreport writer, click reports, on the reports window, click the import button, this will allow you to copy all the customized reports into this new REPORTS.DIC and compare what you may be missing

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans