web
You’re offline. This is a read only version of the page.
close
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 / Finance | Project Operations, Human Resources, ... / How To Remove Custom D...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How To Remove Custom Designs from Print Management?

(0) ShareShare
ReportReport
Posted on by Momochi 1,036

Greetings dears !

I have created multiple designs for free text invoice and populated the PrintMgmtReportFormat.

But now I want to remove all unwanted designs that I created.

How can I remove only the custom designs from the print management?

I have seen a field called "System" in PrintMgmtReportFormat table, which I think it should indicate that this is a custom report if its value is 0 or a system standard report if the value is 1.

so I tried to do a select statement like the following:

select * from PrintMgmtReportFormat where DOCUMENTTYPE = 4

And the result was showing me all free text invoices report design names and my custom report design names but what confused me is that some of my custom report designs have the "System" field with the value of 1.

Not all of them have System field value with 0.

So I got confused.

How can I write a delete statement that will only remove my custom reports names only?

Any advice is appreciated.

Thanks in advance !

I have the same question (0)
  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Momochi,

    Did you enter the values into the table using a SQL query? or did you use the print management classes to populate the table?

  • Momochi Profile Picture
    Momochi 1,036 on at

    I used the method populate() of [ExtensionOf(classStr(PrintMgmtReportFormatPopulator))]

  • Suggested answer
    Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Did you remove the unwanted designs already? If you have done that and select the correct design in print management, the rest of the designs in PrintMgmtReportFormat table should have DocumentType set to 0.

    You can then delete the records which have DocumentType set to 0.

  • Momochi Profile Picture
    Momochi 1,036 on at

    Hi Gunjan,

    DocumentType indicates the type of report like "Free text invoice" or "Sales Invoice" or "Purchase invoice"...etc.

    I believe you meant another field?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,423 on at

    Hi Momochi,

    I tried with a customization I did and for the obsolete values, it set the DocumentType field value to 0. I am assuming you are doing this on your Dev environment.

    You can follow the same steps and check if the DocumentType field is getting set to 0 for the obsolete report designs.

  • Momochi Profile Picture
    Momochi 1,036 on at

    Hi Gunjan,

    The PrintMgmtReportFormat.DocumentType value is 4 for all of my report designs.

    Which indicates that it's a free text invoice report design.

    There is a field called PrintMgmtReportFormat.System which has a value of 0 or 1.

    Maybe this is the field which you are referring to?

  • Suggested answer
    Momochi Profile Picture
    Momochi 1,036 on at

    Well, the solution I have reached is that I have created a custom form with a simple list pattern that contains a grid and an action pane and quick fiilter,

    then added the PrintMgmtReportFormat as a datasource and made it across company (it will get the records of all legal entities).

    Then using this custom form I can select all the designs I want to delete and then delete them. using the delete button on the action pane.

    It's not a very technical solution but gets the job done haha 

  • Suggested answer
    Rahul Namdev Profile Picture
    Rahul Namdev 5 on at

    Dear All,

    i am sharing my thought what i am trying if you want you can try this

    first run this query in SQL

    select * from PrintMgmtReportFormat

    then you will get list of all reports with document type No.

    you can find you report document no for example PurchPackingSlip.Report document No. is 8

    now  run this query

    select * from PrintMgmtReportFormat where DOCUMENTTYPE = 8

    now you will get all reports including your customize report, after this select that particular report which yoou want to delete and copy RECID No of that report and run this bellow query in SQL.

    DELETE From PrintMgmtReportFormat where RECID = 68719485167

    that's it !

    Your Custom Design will delete.

    Regards - Rahul  

  • Suggested answer
    Bharani Preetham Peraka Profile Picture
    Bharani Preetham Pe... 3,634 Moderator on at

    You can try 2 things.

    First you can go to that table in the backend using SSMS and check those records and give a SQL query to delete only those records.

    Secondly you can open table browser and delete the records which you need to delete.

    But if you actually remove that code which is adding these unwanted designs to print mgmt, i believe it will delete those records also after build and sync. No need to delete it manually.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 663 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 540 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 348 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans