Skip to main content
Solved

Change Default Report


Forum|alt.badge.img
  • Jr Varsity II
  • 32 replies

I found several other people asking this question, but none of the workarounds work for my situation. I have one report I want to use as the default for several Mailing IDs. I want to set the same Report ID for Mailing ID ‘SO INVOICE’, ‘SALES ORDER’, and ‘QUOTE’ to replace the default report used in the Sales Orders > Print Sales Order and Email Sales Order actions, the Sales Quote > Print Quote and Email Quote actions, and the Sales Orders > Invoices > Print Invoice and Email Invoice actions. 

So far I have tried to change the SO Invoice report. I set it in Sales Order Preferences > Mailing & Printing: 

I also set it on customer classes so the customer on the sample sales order I am testing with shows it should use the new template:

But when I use any action I can to print the sales order, I still get SO.64.10.10 as the report:

Are there more places I could assign the report ID? Does anyone have a working example of this?

I’ve seen workarounds like:

  1. Change the new report to use the old report’s number (I want to replace 3 reports with 1 and this defeats the purpose)
  2. Do something with Automation Steps (no longer available in 24R2)
  3. Create a wrapper report under the old name and embed the report you really want as a subreport (this causes the report to all land on one very tall page)

Thanks for reading.

Best answer by OlaAyanlaja62

Hi ​@PBSA 

A workaround is not touch anything in the SO Preferences (restore this back to the default Report), this is the original problem. You should leave the old Report ID in the SO Preferences but override this value only in the Customer Class / Customer screen.

 

Let me explain the algorithm in more detail, this will additionally help to understand how it currently works.

 

When the user presses the "Send Email" action, the module configuration is searched by the hardcoded SO643000 value. In this step, you will get the line from the Mailing tab of the SO Preferences screen.

Next, the real (Customer-specific) configuration is searched by using this already-found line from the SO Preferences screen. In this step, you will get the line from the Mailing tab of the Customer Class / Customer screen with the overridden Report ID.

 

View original
Did this topic help you find an answer to your question?

8 replies

bwhite49
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 77 replies
  • March 16, 2025

You can set the mailing defaults through SO Preferences, customer class, and also on the customer.

You might need to update every customer to the correct report ID.

What you did is enough to override the email template, but report ID seems to be applied on each customer

 


Forum|alt.badge.img

Hi ​@PBSA,

Go to Report Definitions (SM208000) and set the custom report ID for each Mailing ID under the Mailing Settings tab. Then, open Report Designer and check the Report Versions to ensure everything is correct.

Hope this helps


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 32 replies
  • March 17, 2025

Hi ​@Ankita Tayana,

I opened SM208000, but for me that is the Generic Inquiry profile screen.

I searched the site map for “Report Definitions” and that came up under CS206000, but that only lists financial reports not Report Designer reports - unless I’m misunderstanding it.

Either way, I don’t see a Mailing Settings tab in either screen.


  • Acumatica Employee
  • 8 replies
  • Answer
  • March 17, 2025

Hi ​@PBSA 

A workaround is not touch anything in the SO Preferences (restore this back to the default Report), this is the original problem. You should leave the old Report ID in the SO Preferences but override this value only in the Customer Class / Customer screen.

 

Let me explain the algorithm in more detail, this will additionally help to understand how it currently works.

 

When the user presses the "Send Email" action, the module configuration is searched by the hardcoded SO643000 value. In this step, you will get the line from the Mailing tab of the SO Preferences screen.

Next, the real (Customer-specific) configuration is searched by using this already-found line from the SO Preferences screen. In this step, you will get the line from the Mailing tab of the Customer Class / Customer screen with the overridden Report ID.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 32 replies
  • March 17, 2025

@bwhite49 Thank you for the suggestion. The customer I am testing with already showed the correct report in their Mailing & Printing settings (from the customer class being configured), but I went back to the customer class settings and set that back to the default report (SO.64.10.10) and then back into the customer itself and set the custom report there so it would mark the ‘Overridde’ checkbox on the customer:

Then I went to the test Sales Order and chose the ‘Print Sales Order’ button and I still got SO.64.10.10:

Is this what you meant by applying the custom report on the customer?


bwhite49
Pro I
Forum|alt.badge.img+1
  • Pro I
  • 77 replies
  • March 17, 2025

Yes, but the change you made should only have an effect on the “email sales order” action. The “print sales order action” is different.

Do you need to change the print action? This would require a small customization to modify that action or to create a new action that prints the correct form. 

Also, if you are emailing directly from the report, there is a change in report designer that needs to be done to map to the correct mailing ID. Your changes on the customer will not impact the action of emailing directly from the report - this is a report update to modify the mailing ID/subject/email body.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 32 replies
  • March 17, 2025

@OlaAyanlaja62 This was really helpful information, thank you! I was able to get my installation to use my custom report for Sales Orders and SO Invoice by setting the Sales Order Preferences Mailing setting back to the default report and then setting my custom report on the Customer Class Mailing setting.

I tried to do the same for the CRQUOTE mailing ID on Business Account Classes and in Customer Marketing Preferences, but that did not work. 

Do you have any idea why this would work differently for the CRQUOTE mailing ID?


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 32 replies
  • March 17, 2025

@bwhite49 Changing the report ID for the SALES ORDER mailing ID on the Customer Class (and leaving it as default on the Sales Order Preferences) did change the report used by both the Sales Order > Print Sales Order and Sales Order > Email Sales Order actions. I did find your comments about the mailing behavior coming from the Report Designer rather than the Mailing Settings to be true though when using the Print action. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings