Reports and Generic Inquires

Things I learned as an Acumatica noob.As a brand new to Acumatica developer, the thought of creating and modifying reports was terrifying to me.  But with a deep breath and fingers crossed I made the leap and have learned so much, including to not only have more faith in myself, but also in the world that is Acumatica.  Report creation and modification doesn’t have to be scary.  Acumatica Report Designer provides everything you need to modify or create a new report.  In this post, I’ll be sharing a few tips that I learned while modifying my first report. To begin, I installed a local instance of Acumatica, along with report designer.  This allows me to work with my reports locally before publishing into either my test or production environments.  Additionally, having a local install gave me access to one very important piece used for report aesthetics and consistency, namely the TemplateReport.rpx file.   Often, I will be tasked with modifying an existing Acumatica report to meet a cer

I have created attributes on stock items which I would like to display on the production ticket. When creating a GI, I can pull this information from this field InventoryItem.INVENTTYPE_Attributes. But on the report designer, this field is not available. How do I pull the attribute field through report designer? Do I need to create a table relation with CSAnswers through Schema Builder?

Hello,I am struggling to get the DateAdd function to work on my conditions. I am able to get it to work in the results grid and in the report designer but for some reason, it is not working on the conditions. Below are some screenshots.Today = June 29th, 2023Screenshot 1: ConditionsScreenshot 2: Result GridScreenshot 3: GI ResultsThank you,KT

I'm trying to create a simple GI to display vendor contact information. I've connected the PX.Objects.AP.VendorR table to the PX.Objects.CR.Contact table and related them by bAccountID field.I'm able to get the results I'm looking for, however I've added the "IsPrimary" field to the results so users can see which contact is the primary one for that vendor account and it does not appear to be working correctly. In the GI results that field is displaying a False result (unchecked box) for all contacts, even those designated as the Primary contact in the Vendor.Any thoughts as to how to fix this?

Good morning..I am wondering if there is a report or inquiry I can run. The data I’m wanting to pull is customer along with a word of item description that has been sold to this customer. For example, we have customer ABC and we have sold them FLAGS. We want to search by item description that has the word “flag” in it being sold to the customer. We get such items from more than one vendor, so it may not be one specific inventory ID.Any help is greatly apprectiated!

A client has a GI with a vendor parameter. When you click on the dropdown it also shows all the users as they also have a baccountid. I need to be able to put a condition on the parameter as putting in a normal condition in the conditions tab only affects the resulting data.The relations is this: Parameter: In the dropdown on the GI they need to only see from where the vendors start, in this case the naming convention all start with V-, where as the ones above are all employees.Would this require customization?

I have a client that sends a lot of Automatic Reports thru Device Hub. All of these reports are assigned to different printers and users. These are print Jobs they don’t want to see a preview and print right away, like labels and other forms after an action, like SAVE. Any other report new or not, prints the Acumatica way, using the web browser, which means a Print Preview, selecting a printer and so on, no DH required.These dedicated reports and users to specific to printers are high maintenance, but works and my client is happy. The downside is that the reports that are married to this setup, must be maintained and all  reports must have a printer/user assigned.  Now we have one user (new employee) that does not see the need to waste paper or print every single time. I assigned the report to a PDF printer but it created issues with DH and would halt all other print jobs until Cancel or a File name was given. He needs to save, not print and move on...not even a preview.Solution: I dow

Dear ALL,When I export a report with image to an excel file. The image on the report was not exported to the excel file.For example: Report SO.30.10.00 with image (Acumatica logo) as shown below. Please help me with this case !Best Regards,NNT    

Working on an audit request for list of Inventory Purchases for a specified period. Originally I was just pulling purchase receipts but that does not include any capitalized freight expense in the inventory through Landed Costs. Meaning, if we buy an item for $10 and it costs $2 to ship to us we recognize the inventory at $12. using Purchase Receipts only returns the $10 of the purchase not the $2 in freight expense. Is there a better report that will show me the total inventory cost Purchase + Landed Cost?

In this report I have added the sub report and I want to add the page break after the details section after every subreport. It appears that it is fetching all the data correctly if I set the page break to none for the details section without any page break. If any page break is added it fetches only the first record. Can anyone help here to solve this thing.Thanks.

ARM report export to excel/pdf function not working for certain branches.  I am able to export to excel/pdf for some branches but not all.  I have already restarted application and that did not work. 

I would like to create my own generic inquiry that links the RelationGroup table to the Users table - I’m guessing that there is an intermediate table that I haven’t found yet.  The goal is to have a generic inquiry that gives me all the restriction groups that the users belong to.  If you have managed to do this, I would be grateful if you could share some insights!

Hi all,We have a CIA/Proforma customer and want to print an invoice with a specific sales order line. It’s a blanket order and would like to print one invoice for 50% up front, then the second line for the final half.Could I modify this screen to print a specific sales order line? 

I am trying to use business event to schedule delivery email. After following the process of creating a GI, adding the notification template, linking a business event, and scheduling the automation schedule, the emails are still not being sent out, and it’s not executing. Has anyone encountered this issue before or knows how to go about solving it?    

I am trying to run an Odata V4 query but have not been able to get it to workThis simple query works fine:"URL/odata/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true" But when i add the v4 part, it does not yield any results."URL/odataV4/Tenant/IN-StockItem?$filter=substringof('TestItem', InventoryID) eq true"Is the above V4 syntax wrong?Is there something that needs to be enabled in order for Odata V4 to work?I ensured the user has the ODatav4 User ( Access to data exposed via OData v4) role assigned.  

Hello all,My GI for Purchase receipts is currently doubling the Qty and the Amount. I am unsure how to correct that issue. Attached is the GI in questions. Any feedback would be helpful. Thankyou

Does anyone know of a report that shows how much of something we have ordered over a large period of time? Looking to see what are most used material is and average cost we are spending on it. **Not sure if this makes a difference, but most of our orders are drop ships, so this wouldn’t be reflected through our inventory.  

I am trying to add the SOLine linked AMProdOrdID to SO641010. According to the DAC Schema Browser, this is within SOLine table. But, it’s not showing up in the available fields in report designer.Anyone have any ideas?

I have created a business event and it is working fine. Now I want to attach my custom report in the mail that is triggered by the business event. I added it as an attachment and provided the required parameters but it is not generating exact report. Some details are missing. If i generate the same report on the report screen it is working fine.  

I have attached a static form to our PO that will print with the PO on vendors that we purchase ingredients from. I created a page break on the group footer and the PO prints on the first page and the static form prints on the 2nd page but the page 1 of 1 footer in printing on the 2nd page but not the first page. And when I add multiple lines to the PO to push the PO to print on a second page Acumatioca renders 10 pages and my static form prints on several pages. I have attache images for review, and my Report Designer settings for the footers. My end goal is to print the PO first and the static form letter last, as well as adding multiple lines to push the PO to a 2nd page to only print a 2 page PO and the 3rd page is my static form. Please check out my report designer setting to see what I need to change to make this work. PO page 1 and Static form page 2Page 1 of ? should print at the bottom of every page. I do not need the page count on the static form.Top image capture of the firs

see this is my sample. total amount is 3,350,000.00. but visible expr condition row amount also add to subtotal.

Hello,I am adding a parameter to a working GI.I check the box “From Schema” on the parameter.There ARE records and values for this field and I show them on the output.If I set a default value on the parameter it works for the default.I simply cannot select a value for my parameter from the database which is the whole purpose of “From Schema”.Any thoughts? 

Does anyone have any ideas on how to add backordered items to an Invoice? These would be zero dollar lines for visibility purposes only.We have the Add Zero Lines for Items Not in Stock checkbox checked on the Sales Orders Preferences (SO101000) screen so we get the following behavior: 1. Create a Sales Order where the first 2 lines are available, but the 3rd line is not available: 2. Create a Shipment and all three lines are carried onto the Shipment, even though the 3rd line is not shipped: 3. Create an Invoice and only the first two lines are carried over. The 3rd line disappears since it didn’t ship: 

Can I know if there is a way to print data in detail section inside a grid in a report like in the below image?Expecting grid format in the report detail section 

I’m attempting to add a new Vendor via the REST API. I receive the error:DiscTakenAcctID: 'Cash Discount Account' cannot be emptyThis is a required field located under the GL Accounts tab. However, the field does not appear when getting the list of Vendors via the REST API. How should the JSON be structured to include this field when adding a new Vendor via the REST API?