Skip to main content

Attaching Acumatica Report to Menu Through Automation Steps

In world of distribution you may need more reports, let's say your team decides to add a new report for Return/RMA orders, same format as SO and ability to print directly from Acumatica screens, so as an IT manager you would jump into driving seat and copy an existing Sales order report and rename the new report as RM641010 and using report designer make cosmetic changes and publish to Acumatica reports.

How do I attach a report to existing screen and Menu options? 
Follow these easy 3 steps, you can attach an existing report to menu option through Automation steps, that's right if you always wondered what can I do with Automation steps, this is a perfect example for it.

Step 1: Navigate to System --> Automation --> Automation Steps, from that screen select the Screen ID by drilling down to Sales Order screen

Step 2: Now let's identify the step we need our automation, we need this for a new order type called "RM" Return Order (RMA) and you want to show the option to print only when it's RM and the status of this order is "Open"
Step 2a: From the Step Id drop down select the option "RM Open" which indicates when user select order type as RM and the status is Open then do the following automations

Step 3: Click on the Action tab as shown in the screenshot below, add a new line and from the drop down options select "Report" from the options and tab over, give it a menu name "Print RMA" and click save.
Now click the button "Fill  with Values" while the row being highlighted and in the field name enter @reportID and tab over to enter the report value as "RM.64.10.10" the screen ID and click close.

That's it you have attached an existing report to Sales Order screen, and when the conditions is met this report menu option is exposed or enabled, so users can run the report seamlessly from sales order screen.

If you need Acumatica Customizations or development projects reach out to InfoSourcing, Acumatica Certified Partner




Comments

Popular posts from this blog

Acumatica JewelShop - JCK Las Vegas Convention for Jewelry Business

Acumatica JewelShop , new plugin for Jewelry wholesale business and custom jewelry manufacturers. Visit us at JCK LAS VEGAS - Booth B50042 | May 31 to Jun 2nd. SANDS EXPO & THE VENETIAN LAS VEGAS, NV https://lasvegas.jckonline.com/ Visit our website for product information  Visit our website for more information about Acumatica JewelShop

Acumatica Snapshots - Uploading and restoring large files

In Acumatica ERP, you can create company snapshots containing your company’s full or partial data. Snapshots that can be saved locally in the same database, or at a specified location. You can import and restore snapshot to another company, in this case test company, it's pretty handy tool very useful during implementations, customization and support/troubleshooting while you work with data. You will occasionally run into few technical issues with snapshots, the newer version now needs you to keep all users logged out and in maintenance mode to take snapshot, link to blog article here. Today we are going to discuss how to export and import snapshots which are larger in file size of above 1GB, this is not a limitation from Acumatica and more to do with constraint and default value set in IIS (Internet Information Server). IIS by default allows uploading of a file size of 1GB and it limits the upload process and it can be tweaked to upload upto 4 GB file size and that's

Acumatica User Defined Fields/Values - UDF using attributes in 2018 R2

In 2018 R2 version Acumatica introduced new feature called "User Defined fields" in short UDF's. These fields allow users to configure existing document screens to capture custom data per document basis. New features like this really helps partner/customer to configure business workflow process, this capability built on a framework can now enhance existing documents like Sales order, purchase order or other document to collect custom data at transaction level using attributes. For more information on which documents/screens you can collect UDF's refer to Acumatica help  In this example I have created few custom data that we would like to accept in our Print industry, this works pretty well with our Acumatica plugin PrintShop for Screen printing and embroidery companies, as business do accept different type of data and allows us to do minimal customizations. If your accepting custom data related to art work, then you can create those attributes ahead of