Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

How to Apply the modificatons did in reports

Posted on by 570

We have using GP 9 and GP 10. In GP 10 there was an option in setup "Alternate/Modified Forms and Report.

But in GP 9 not have this option.

In GP 9 how to apply the modification i did in Report.

I would change some modification in sales invoice  (SOP Blank invoice form) But after did the modification again getting the same old format. What i want to do to get the modified report i did.

if i can get the same option in GP 10 " Alternate/Modified Forms and Report" in GP 9 Also.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: How to Apply the modificatons did in reports

    Hi Jenny. Thanks for the compliment.

    Are you using Terminal Services to access GP (ie do you launch remote desktop before launching GP?)...or is GP installed on your desktop?

    If the SOP entry process is 'locking' perhaps there is a custom trigger running that is causing an error. Do you know if your partner (or a developer internally) has modified the SOP entry window in any way? Maybe there is a trigger that fires when you click post or sve...that updates a custom table or something?

    When you open SOP Transaction Entry...are there any full stops / periods on eithre side of the window name?

    Is there any pattern to the documents that are causing the system to lock?...ie are they all to a particular customer, or are you entering any additional data (say, in the SOP User Defined Fields) that you are not adding to other transactions that do not cause the system to lock.

    Are you posting these SOP document immediately, or are you saving them to a batch?

    What happens exactly when the system locks? Do you get any error messages? or does the window just not refresh ... and you eventully have to reboo, or what.

    The locking could be a any one of number of issues.

    If you do a debtor enquiry, or a sales document enquiry, is there any speed issue...or does the system lock?

    Best regards,

    Ian.

  • Jenny Peter Profile Picture
    Jenny Peter 570 on at
    Re: Re: Re: Re: How to Apply the modificatons did in reports

     

    Thanks for your advice.Now its working ,"You are Grate"

    The main problem now i am facing is that "My sales transaction window always locking". I created a new user id and start to enter the transaction in sales . i posted 3 or 4 sales invoice after its again locked. Actualy whats the real reason for this problem, for this problem i can't work properly.I your company no body can't know how to delete the locked document from the database files.

    Please told me why its happning always. The problem is only when i try to post in sales invoices. In purchase there was not at all any problem. In the sales invoice the quantity was not fullfled properly, it willa reason for this problem.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: How to Apply the modificatons did in reports

    Hi Jenny, there could be any number of reasons for getting this error. But the problem lies wthin the report itself. Somewhere you have added / modified a field that is causing the problem, or you removed a field from the report that a calculated field is referencing.

    If you created any calculated fields, check the expressions in these, you're looking for 'field not found' text. You may have used a field in the expression, and then removed the field from the report.

    Then, look at each of the standard GP calculated fields created for this report...and you are also looking for problems in the expression.

    Did you create any custom sorts on the report?

    Did you add any tables to the report?

    You should also look at the face of the report and see if there are any unusual fields.

    What report did you modify? You could always delete the modified report, insert the unmodified version and try and modify it again. Don't delete any of the standard fields on the report this time, just make them invisible.

    If you don't get anywhere with this, email me your reports.dic and I will take a look.

     Best regards,

     

  • Jenny Peter Profile Picture
    Jenny Peter 570 on at
    Re: Re: How to Apply the modificatons did in reports

    i tried to the way you say. But now its not opening the window and display an error message " UN Defined symbol ['Not Found']

  • Jenny Peter Profile Picture
    Jenny Peter 570 on at
    Re: Re: How to Apply the modificatons did in reports

     

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: How to Apply the modificatons did in reports

    Hi Jenny,

    I don't have GP 9 installed...so I am working from memory...

    If you can't find any of the windows / fields below..then maybe I'm describing for version 8...but let me know anyway...someone out there has version 9 installed and can tell you the steps.

    To give yourself access to a modified report, click on Set-up >> System >> Security.

    If you are asked do you want to open Advanced Security, say no...and just open the standard security.

    1. In the User ID field, select the user you want to grant access for this modified report to.
    2. In the Company ID Field, select the relevant company
    3. In the Product ID Field, select Dynamics GP (or whatever product ID field is relevant)
    4. Then select the Type (Modified Reports)
    5. The select the Series (Sales or purchasing or inventory etc etc)
    6. The list of modified reports available will be displayed. Double click the one you want to grant access to ( so that there is an asterisk beside the report title)
    7. Click save.

    Hope this helps. If not, post again.

     Best regards,

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans