Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Item Detail List will ...
Microsoft Dynamics GP (Archived)

Item Detail List will not print

(0) ShareShare
ReportReport
Posted on by Harold Worby 1,331

Running GP2010SP3 With Windows 2008R2 and 2003R2 terminal servers and Windows 7 Fat Clients.

When you try the print the report from the the Item Maintenance window or the Inventory Reports window we receive the following Error

Error Message:
Inconsistent restriction/sort expression Please add the 
following restriction "D05443 Free on Boar = D05443 Free 
on Boar"

There is no Modified version of this report so I generated one and received the same error, remove the modified report and still get the error.

Removed file REPORTS.DIC and the report runs.

Re-Import the Package file with no reference to the report and the error returns.

I Verified that there is no referenct to the report in the Package file, and no modified report is listed.

 

 

*This post is locked for comments

  • Harold Worby Profile Picture
    Harold Worby 1,331 on at
    RE: Item Detail List will not print

    10. How do you print a report ffom Report Writer????

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Item Detail List will not print

    In that the report runs fine without the reports dictionary, screams modified report. Here’s what comes to mind to troubleshoot. You might try it after each step. I don't mean to make you angry, I do see that you've been down some of these roads already. You might do Step three and then jump down to eleven:

    1. Try in from a different workstation as a different user

    2. Try it against Fabrikam logged in as ‘sa’

    3. Run the system utility Reconcile on the Security Assignement Alternate/Modified Operations.

    4. Look at your Dynamics.set file to make sure you are looking at the correct reports dictionary.

    5. Remove all (even 3rd party) reports dictionaries from your installation.

    6. Print the report to screen and select to Modify current report.

    7. Carefully record the name of the report – lots of the reports have similar looking names. This one has ‘Detailed Item List’ and ‘Detailed Item List by Site’. (I know you already did this - but I had to include it for others)

    8. Open the Sort and Restrictions windows and make sure they are blank

    9. Check the tables, you should have the following:

    Item Master

    - Item Quantity Master

    - Item Vendor Master*

    --PM Vendor Master File

    10.Try to print the report from within the Report Writer screen - you don't have to switch back to dynamics.

    11. Import the reports from the old dictionary one-by-one and try to print the report after each import. This procedure will identify which one is creating the error. If you’ve got too many reports to go one-by-one, do them a handful at a time. Use the Import button on the Report Writer window itself, not package files. You don't need to switch back to Dynamics since you can print the report from the RW window itself.

    Let us know what you find.

    Kind regards,

    Leslie

  • Harold Worby Profile Picture
    Harold Worby 1,331 on at
    RE: Item Detail List will not print

    Re-read the posting. This report is NOT modified, there are others that are.

    The report is not listed in Report Writer as modified.

    There is no reference to this report in the package file

    The reports that ARE modified work.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Item Detail List will not print

    Do you know what modifications were made to this report? If you do not know or do not need them, then drop the report completely. Otherwise, insert the report back in from scratch and start the modifications again.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,401 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans