Reports and Generic Inquires

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

Hi everyone,We’re experiencing an issue with one of our GIs where we need to filter for empty lines in a specific column. We’re using the ‘Is Empty?’ filter, but it doesn’t seem to display all the empty lines.For context, we know there should be 10+ empty lines, but only 1 line is being shown.Has anyone else encountered this issue? If so, do you have any suggestions or fixes?

Good afternoon!I wanted to pass along a “How To” for a great/simple (and underutilized) feature in Acumatica Generic Inquiries that allows users to add the functionality to run reports directly from the Generic Inquiry Results grid.In the process below, a report has been added to print PO Receipt Line Labels, on demand, directly from a Generic Inquiry. Please see the following steps. Create the Report (ex. Receipt Labels) Create the Generic Inquiry. Under the “Navigation” tab, add the report and assign the needed “Navigation Parameters” from the GI Results to run the report.  Under the Results Grid tab of the Generic Inquiry, create a new line, and assign the “Navigate To” for the screen added in the step above. (you can also add the “Navigate To” report to an existing field in the report if you prefer) When you run the Generic Inquiry, you will see the hyperlinked option, at the line level, to immediately run the report on demand.  Hope you find this helpful!

Hello! I am trying to create a GI that shows Non-Stock Kit Availability based on the availability of the component items.Where if at least on component item is not available, then when you filter by the kit item, either nothing shows up in the GI or there is a field that display a zero availability of the kit item. This is the formula I am working with: = IIF (Floor((IsNull(  [INSiteStatus.QtyAvail], 0 )  / IIF ([INKitSpecStkDet.DfltCompQty] > 0,[INKitSpecStkDet.DfltCompQty] ,1 ))) < 0 , 0, (Floor((IsNull(  [INSiteStatus1.QtyAvail], 0 )  / IIF ([INKitSpecStkDet.DfltCompQty] > 0,[INKitSpecStkDet.DfltCompQty] ,1 )))))Picture below, because the component items shows zero in the available column, nothing should show up for this kit inventory item.  Does anyone know if this is possible? My formula currently returns zero for all items, any idea on what it should look like? Any suggestions are appreciated!Thank you!

I cannot seem to work out the correct syntax for using “Is In” in a GI condition. For example [ColumnX] is IN (‘ValueA’, ‘ValueB’, ‘ValueC’).For ‘Value 1’ in the GI condition tab I have tried:(‘ValueA’, ‘ValueB’, ‘ValueC’) ‘ValueA’, ‘ValueB’, ‘ValueC’ “ValueA”, “ValueB”, “ValueC” ValueA, ValueB, ValueCI have even tried creating a COMBOBOX parameter and assigning that as the Value.Nothing works, the resultant SQL in the Trace is not want I am expecting and there is nothing returned. Any know what to do?  

I’m reworking the AP check form (AP641000) for a client and for some reason the standard $Paid00 variable is multiplying the payment amount by 10.When $Paid is assigned a new value in the report, it uses “=IIF($LineNbr = 0, Sum([APPrintCheckDetailWithAdjdDoc.AdjdInvtMult]*[APPrintCheckDetailWithAdjdDoc.CuryAdjgAmt]), $Paid00)” which I didn’t change. I know that APPrintCheckDetailWithAdjdDoc.AdjdInvtMult is 10 but I can’t find any documentation about what that field is or how it’s defined. I have voided and recreated this check multiple times so I suspect that may have something to do with it. I unfortunately cannot share the .rpx file because it contains sensitive client information. 

I am trying to create a GI in Acumatica to display all Vendors and the total sum of all PO $ amounts by item. Here is the result I am looking for, but as I investigated each PO and item, the totals are not correct for the Sum of Gross $.Here is what currently exists in the GII also tried using AVG aggregate function and that did not work either. Any suggestions/advice on how to pull the proper amounts?  Thank you!

Dear Sir/Ma’am,Good day.I’m a newbie in Acumatica. Can someone help me where can I find the value of Unreleased Balance and Open Orders Balance in customers, so I can balance my Remaining Credit Limit in Acumatica vs. my manual file. Please see below the sample figure. Thank you. 

Can we group in report designer using the Ref Number (custom column) as BOQ1 Prelim as total of 9 (order qty) and BOQ2-MAIN BUILDING as 4 ? 

We have a Call Sales Report where the address of the customer needs to be on the top showing Address information such as Address1, 2, City, State, PostalCode. I am joining the BAccount with the Address using DefAddressID from the BAccount and AddressID from the Address in the report. I have tried using an Inner, Left, and Right JOIN and keep coming up with “Open server settings” error when using the Address with the BAccount.Error:I know that the first image shows the left join, but I have tried the other ones with the same results. The ultimate goal is to just the the address data for each customer that has been visited or called.

Hi ,I got the desired results by adding variable in detailSection for displaying sum in Pagefooter. However, I added the variable in Pagefooter and placed the variable in Report Footer I am not getting the value. Am I doing anything wrong here. My variable has the properties as Value Expr : Revenue amount + $SumRev  and Rest Expr :InvItem.Item Class Description. Can you please help me understand where I am going wrong?I tried it through sub report still not retrieving the item and its total.In the detail section it is as below:Item          Desc           AmtI1             InvItem1    10000.00I2             InvItem1    10000.00I3             InvItem1      $999.00I4             InvItem2    $10,000.00Further, I need to display in the Report section as:InvItem1    $20,999.00 ($RevenueAmt).  InvItem2    $10,000.00Total:         $30,9999.00. How to achieve this?

We have a subreport that displays the correct values when the parameters are manually put into it. When the subreport is added to the main report with the same parameters, the detail lines are out of wack, as in they repeat themselves several times. The very first item should only have a quantity of three with three LotSerialNbrs but end up repeating as single lines with LotSerialNbrs that didn’t belong to the item(s). Then it was decided to try the report without a subreport, and while it looks nicer, the results are still skewed. I’ve included in the zip file the main report and just in case the subreport. If the main report can show items with the proper quantity and LotSerialNbrs without the subreport, that would be great.