Reports and Generic Inquires

Hi, We have report called inventory edit details, which has different parameter. For one of the parameter field in the zoom screen we want to hide a column from the users, can anyone suggest is it feasible or not and how can we achieve this?Refer the below screenshot where highlighted column needs to be hide from the users.  

Team,I am trying to inlcude the Bill Description as part of the AP641000 check with Remittance in Acumatica, the only way I found to do the relation is to do a APPayment related to APAdjust and the APAdjust to the APInvoice to get the Bill Description. In this report, I used the BillType variable to now host the APInvoice.DocDesc, on a check with 3 bills paid, the remmirance DocDesc is correct for the first two lines, but not the third line. I hope somebody could check the report and let me know if I am missing something.  report is on the zip attachment Thank you.

The time is passed as a string. which includes date and time. i need to make a filter where i can filter the data by time.E.g. “1/3/2025 4:49:34 PM”. Any idea? 

I cannot get “is in” to work as a realtionship condition in my inquiries.Running: Acumatica 2024 R1Build 24.102.0053 Here is the relationship in the editor: Here is the TranDesc on the Adjustment (INRegister): Added costing for receipt 018261 component XS29347-C-POT and FG S29347-CWhat I REALLY wanted was to ask if the Receipt Nbr AND Item Number are in the description. That failed, even though they are there. So I tried using the generic string “costing” and I still can’t get the data to link. Am I mis-using “is in” or something?

Hello all,I have extended a DAC in a customization project to add on 2 new fields; however, they are not showing up in Report Designer for me to pull onto a report. I have tried refreshing the schema and applying it to all, but still no luck. Any suggestions? Thanks!

Hello all,I have two issues with a generic inquiry I’ve written. I’ve tried (and mostly succeeded) to make an expanded Sales Order GI that includes information on the associated production orders.First issue: I created a margin % column in the result grid, and it calculates properly but when I attempt to sort the column ascending/descending, I get a divide by 0 error:=Round(CDbl(([SOLine.CuryLineAmt]-[AMProdItem.WIPTotal]) / [SOLine.CuryLineAmt]) * 100, 2)I also have the same issue with the markup result I created:=Round(CDbl([SOLine.CuryLineAmt]/[AMProdItem.WIPTotal]),2)I’m assuming it’s because there are a few orders with a 0 value and I can’t divide by 0… is there a way to include a IIF in my expression above to exclude any 0 values?A bigger issue -- duplicate results. After making a few additional table joins/relations in the GI, I now have multiple duplicate sales orders in my results.If a sales order has one sales order line, that SO should appear once (ex. line 1). If a sales or

Hi,I am trying to develop a GI that shows me the main product along with its BOM and also shows the total inventory I have of each component in all warehouses.I can't get it but when I apply a filter I automatically receive the message.Can someone help me?The main GI is Purchase Planning Report. 

I need to pass the selected combo-box parameter to be  printed on the report .For e.g. if i select 123 on below i need to print that selected value (123) on the report.  

How to use Modulus (mod) expression in report designer?

Help! We added the second parameter today to fix the Approval GI (My approvals) filter because people could not see their subordinates expense reports because we made a change to the approval map for expense reports. That was this morning. Now this afternoon leaders are saying that they cannot see their Purchase Orders. The purchase order approval hierarchy is based on workgroup. Simple logic would say we have an OR statement. If we uncheck the second line, then the leaders can see their Pos. Very annoying. Any advice?   

Hello,I am having trouble with one of my reports that compares balance sheet accounts for the current financial period vs. prior financial period. The issue I’m running into is the the prior current period formula isn’t calculating to the last day of the prior month. It only seems like it happens when the current month has 30 days and the previous month had 31 days. Any help would be sincerely appreciated!! This is the formula that we are using:Financial Period for 11/2024Financial Period 10/2024Regards,Brandon McIlhargey

I’m try to add a user defined field to the production order page, so our employees can enter certain data on Production Orders. However, under the customization tab, I don’t see the option for user defined fields like in Sales Orders. Is user defined fields an option in POs, and if so, how can it be activated?

Testing of this GI in our sandbox prior to upgrade to 2024R2 on 12/19 went fine. We had version 5 loaded 12/30. I do not believe anyone attempted to view this GI after our initial upgrade, so don’t know if it’s an initial upgrade issue, or related to V5.The error message when I attempt to view the GI is that the field [OwnerID] cannot be determined. Owner (I presume) is coming from PMProject.ownerID in my results grid, which appears to be valid. Additionally, field PMBudget.ActualAmount has a yellow warning that the user has insufficient rights or the feature has been disabled. Attempting to pull the GI via Velixo, just says the report is not found. I’ve spent a few hours doing research and do see where there have been some changes to the access rights, so I granted access … but I have admin rights, so this shouldn’t have been a problem for me, which suggests that isn’t the issue. I do know that some fields have been renamed/changed/removed, but this doesn’t seem to be the case here. I

Hi,I have a Business Event that is sending an email via Email Template with attachment originated by a GI.I have set up "Mailing and Printing" for the Email Template on Account Payable Preferences, a Vendor Class and specific vendors.I would like the email sent to the emails specified for the MailingID for the Email Template but no email is generated. Emails are generated only if I specify a "To" in the email template. It looks like it is not supported by Acumatica as both guides below clearly state to "Specify an email address".Guide1Guide2Am I missing something?I don't really want to include NotificationSource and NotificationRecipient tables to the GI and mimic Acumatica logic for MailingID to not risk missing something and future proofing it...especially if I'm using the template specified in the MailingID... I cannot send the report directly via the report screen as the requirement is to send the report to a list of vendors at once.I explored the possibility to trigger the email t

Is there a way to make the Date Rounding “Weeks” have a format that displays the beginning date of that week?  For example, instead of showing “2024 W52”, I’d like to show “12/23/2024” (which is the date for Monday of W52).  

Hello,Is it possible to access the next record in an inquiry? For example, I am build a generic inquiry to show where items are production orders and I want to get the next work center from the AMBomOper DAC. Is this possible? Thanks,

Hi,I’m looking to create a GI that will list inventory transfers with their Release Dates. I don’t see a field in the INRegister table that stores the release date. What would be the way to get this date on a GI? Thank you!

When running the Sales Order Details by Customer report, we receive the following error:Does anyone have any ideas on what the problem may be and how we can fix it? Thank you!

In the SOShipLine table, there is a field used on the Shipments screen called OrigOrderQty.  I want to use that field on a pick-list report that can be printed for each shipment.  When I try to add this field, it’s not available.  The SOShipLine DAC shows the field as being available, but it’s not found on the table in REPORT DESIGNER.  Why is that?  

Does anyone have any ideas on how to configure Page Footer only appear on last page? I have set the behaviour to Print on Last Page as “TRUE”. However, when the report are more than 3 pages long, the footer shows up on the succeeding pages except for the first page. Below is the screenshot of my report designer configuration for the Page Footer section. Thank you in advance for any help. Anne Samson

Hello,I created a Group Header Section of a report in report designer. I’m trying to group the report by a unique value. Everything is working fine with the grouping except for the way it prints. Each time the Group Header Section has a different group, the report prints the group at the top of the page.  Group 1 prints on page 1. You can see there is plenty of space to print the next group below group 1 but the system skips the space and puts the next group on its own page.   Group 2 prints on page 2.  I want to print Group 2 below Group 1 and not on a new page. Is there a way to accomplish this? Here are my settings of the group section.   

I’m trying to create a report with sub reports, however despite my best effort, massive space shows up between the values. This is how I design the report.But it comes out looking like this.The 100 value is being drawn from this supreport.I’m honestly not sure where all the excess space is coming from, but it is making it hard to make a concise report. Is there a way to fix this?

Hi all, How do I access the link I posted to acumatica without having an acumatica account to log in. I have successfully attached the link to the email, but I don't know how to let people outside access itThanks in advanced

Hi Team, Can some help in showing some examples how to modify a Production ticket that once printed will also print a PDF file attached to the releviant BOM ie Part Drawing!I understand the BOM Schema needs to be included in the Production Ticket Form, but how to link it to the BOM.

I have developed a custom report which display data related to CashAccount. I need to sort the Cash Account according to the alphabetical order of the [CashAccount.Descr] field. But it is do not works as expected. I have added a grouping according to the CashAccountID. I tried changing the sorting field with few other data fields. But nothing works as expected