AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Report De...
Adding custom repor...
 
Notifications
Clear all

Questions Adding custom report to AP30.10.00 (AP Bills and Adjustments )screen

 
Acumatica Report Designer
Last Post by Paul Palmer 4 years ago
14 Posts
6 Users
4 Reactions
5,942 Views
RSS
Jean Slusher
Posts: 16
 Jean Slusher
Topic starter
June 26, 2018 2:48 pm
(@jslusherut)
Eminent Member
Joined: 5 years ago

Acumatica has confirmed that you cannot use automation steps to add a custom report to the drop down reports menu on the AP30.10.00 screen.  Do you have any ideas on how to do a customization in order to get a custom report added to the reports drop down on that screen?


13 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
June 26, 2018 11:48 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Is it specific to that screen only? I know that you can do it for other screens. You just can't control what parameters get passed to the report.

However, I'm pretty sure that I heard them mention something about the ability to pass parameters during the recent xRP Summit Roadmap session.

My notes from that session:
https://www.augforums.com/product-platform-roadmap-xrp-summit-2018/


Reply
Jean Slusher
 Jean Slusher
(@jslusherut)
Joined: 5 years ago

Eminent Member
Posts: 16
June 27, 2018 9:50 am
Reply toTim RodmanTim Rodman

It is specific to that screen that I have found so far.  You can use the automation steps on the invoice entry (AR30.10.00), SO entry (SO30.10.00), PO entry (PO30.10.00) to add a custom report to the drop down, but on the AP entry form (AP30.10.00) you cannot.  I wanted to see if anyone had successfully created a customization to get a custom report on the drop down in that screen and if so how they went about doing it.  


Reply
AhmedBahar
 AhmedBahar
(@ahmedbahar)
Joined: 6 years ago

Eminent Member
Posts: 29
October 24, 2018 5:38 pm
Reply toTim RodmanTim Rodman

Tim, did we ever have a guide to to pass a specific (custom) field to the report?

I see that it is hard-coded into the graph but wondering how to go about tweaking the customization?

This guide kind of goes into it but wasn't generalized enough to apply it to sales orders:

http://asiablog.acumatica.com/2017/08/adding-new-report-button-on-invoices.html


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
June 27, 2018 9:44 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Ah, figures. I've also had trouble with Automation Steps on that screen. I guess it makes sense, it was probably one of the original screens in Acumatica since Accounts Payable is one of the first modules to get coded in any ERP system.

You might try StackOverflow for help with a customization since that area is monitored by developers.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 26, 2018 8:07 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Thanks Ahmed for the link. I think that's the answer to Jean's question. Just needs to be applied to the AP screen.

About the parameters, I agree with you, sure seems like the parameters section in the 4th screenshot would be the key to getting it to work. But it's a little too much C# for me to handle unfortunately.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
September 3, 2019 11:42 am
(@timrodman)
Famed Member
Joined: 10 years ago

In Acumatica 2019 R1 you can now do this with a Customization Project:

You can even control the Display Name, the Window Mode which controls how the report opens (Same Tab, New Tab, and Pop-Up Window), and what parameters get passed to the report which is pretty cool:

After publishing the Customization Project, you'll see the custom report. In my example, clicking the report will open it in a new tab and pass TAXILLINOI to the Vendor parameter:


Reply
Jean Slusher
Posts: 16
 Jean Slusher
Topic starter
September 4, 2019 10:29 am
(@jslusherut)
Eminent Member
Joined: 5 years ago

This is great to see.  Looking forward to trying it out.


Reply
Tim Rodman reacted
sblumenthal
Posts: 3
 sblumenthal
June 17, 2020 6:07 pm
(@sblumenthal)
New Member
Joined: 5 years ago

Has anyone scene when adding a report via the Customizations the Parameter Name does not become available?  It shows up on a couple of our reports, but not all the reports that we are linking.  Very weird.

Thank you!


Reply
KDYoung
 KDYoung
(@kdyoung)
Joined: 6 years ago

Eminent Member
Posts: 26
July 30, 2020 2:52 pm
Reply tosblumenthalsblumenthal

@sblumenthal - yes I have seen this at a client.  I have not been able to figure out why.  For the few reports I just told the client they'd need to run from the module menu.  But very annoying!


Reply
sblumenthal
 sblumenthal
(@sblumenthal)
Joined: 5 years ago

New Member
Posts: 3
July 30, 2020 2:58 pm
Reply toKDYoungKDYoung
sblumenthal

@kdyoung We actually figured it out.  It has to do with permissions on the report.  We basically had to give the report full rights for all users and once we did that it worked fine.  We reported this to Acumatica.


Reply
KDYoung
 KDYoung
(@kdyoung)
Joined: 6 years ago

Eminent Member
Posts: 26
July 31, 2020 11:53 am
Reply tosblumenthalsblumenthal
KDYoung
sblumenthal

@sblumenthal - Full rights for ALL users?  That is odd!  What is even more odd is that for us it wasn't all reports - just some seemingly random.  I will try that out.

 

Thanks!


Reply
KDYoung
Posts: 26
 KDYoung
August 1, 2020 9:34 pm
(@kdyoung)
Eminent Member
Joined: 6 years ago

@sblumenthal - FYI - In our case all I had to do was give rights to the Administrator role.  Once I did that the parameters were available.


Reply
Adam Brunner and Tim Rodman reacted
Paul Palmer
Posts: 3
 Paul Palmer
June 10, 2021 9:17 pm
(@paul-palmer)
Active Member
Joined: 5 years ago

Hi Guys, is this customisation still an option in the later versions ? 

i don't get the main properties like in the above example that @Tim shows  

image

Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 23 Online
  • 2,405 Members
Our newest member: Brittany Bartman
Latest Post: Importing Acumatica User Roles / User Security Permissions from Excel
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×