Reports and Generic Inquires

I want to add a filter to the report in the report designer. The filter is based on the LastModifiedDate of the AMMTran object. So far, I have tried=DateAdd(Today(),'d',-1) and Today(), but both these filters are not fetching the data correctlyHow do I get the date filter to work?Thank You.

So the request was to add the Recurring Unit Price to the Generic Inquiry for Service Contracts [ScreenID: FS3057PL].   However, when I add the item to the results grid after joining the FSContractPeriodDet Table to the Parent Table: FSServiceContract, I get duplicate line entries on the GI.  I have tried a few things to remedy this and can’t seem to figure it out.  I tried grouping by the Service Contract ID, but it totals the amounts of the lines and that is not correct.  There should only be one line per Service Contract.Here is the GI: Here are the results:  

Hello,We have a GI that shows our Purchasing Dept. what needs to be re-ordered for items.  I’ve been able to create the whole thing and use the Row Style to highlight High Priority items in ‘red’.  They have asked if I could instead just make the color of the values ‘red’ instead of the entire row.  Specifically the Qty. On Hand column.  Picture below. 

Hi, We are trying to print a PDF document, a 2 page Terms & Conditions, after the Order form prints. I have been able to convert the PDF to jpg & embed the jpg in the form. But the T&C prints condensed & does not fil out the page. I am wondering if there is a way to designate a PDF to print or if there is a better way of accomplishing this. Should we store the Doc in the Database rather than the form? Any other ideas? This is a cloud environment (AWS) .Thank you, Bill 

How can a GS1 code be mapped withe the report designer?Do you have any ideas or solutions? Thank you.

Hello all,I have been creating a GI and I am looking to display the below highlighted value out of the other multiple attribute values: Employee Payroll Settings formI have created a join as below: But it displays the value in some other alpha-numeric format: How can I display the correct values?Thanks in advance.

We have a check which was already cleared get voided. I’m trying to figure out how to correct this. My A/P clerk was trying to enter a debit adjustment only and mistakenly voided the original check which was cleared a few months back. Any help on this would be great!

Hello,I am working on a custom AR Aging report in Report designer, going off of the AR Aging Sensitive report, I only want to view invoices that are past due. How can I use an If statement or set a filter to NOT show invoices if they are in the “current” bucket or are not yet due.  

I have  a pivot table that shows the number of orders shipped Last Year vs This Years.I have a column called Month, and another called MonthName. I have the Month column so that the pivot table will show the months in the correct order. I want the MonthName column because it make the pivot table easier to read. Is there a way to “hide” the month column but still use it as the sort for the pivot table?Thank you!

Is there a way to add system generated warnings into an generic inquiry.Example: A customer is past due on payment, and when a new order is entered there is a yellow warning flag next to the customer’s name that reads “The customer’s Days Past Due number of day has been exceeded!”My users have asked if this flag could be added to the Sales Order’s generic inquiry so when they are reviewing open order they can quickly see if there are order that have a warning.  

Hi,I have an urgent question regarding report designer. For keyword digital signing, i have an error in producing general ledger. Error is that - Sign Keyword is not found in the DocumentFor AP, double underscore was used as its value and it worked, for PO, double dash was used and it worked. However, neither worked for GL.Thank you.

I’ve come across a werid scenario from my Accounting team.  It seams that Screen AR3030PL - Customers not have show notes and files in the results grid:But in Screen AP3030PL - Vendors, it does:I can seem to find where these settings exist to fix it back to add those columns to AR3030PL.  Where does this exist since it is a GI and not a Screen?

Is it feasible to print a range of orders in a work order report, which is currently set up on a 1:1 basis? Business users would like the ability to print by ranges, similar to the functionality of Print/Email Orders. However, I'm unsure if this is even possible. Perhaps a subreport could be used to capture the range? I'm still uncertain about how to begin. I have added the parameter to the report, but it is not functioning correctly. 

I have a request for a bar chart  or a pivot table on a dashboard that will show This Years Order Count vs Last Years Order Count by month for a specific customer.I have a Generic Inquiry that Pulls the Customer Name, the Posting Period and the Order Number for last year and this year. When I create a bar chart or a pivot table the data is show sequentially January 2023, February 2023, March 2023…….. December 2023, January 2024, February 2024….. etc.Is there a way to either have a bar chart or pivot table where January 2023 and January 2024 would be side by side, followed by February 2023 and February 2024 and so on.Thank you 

Finding out an issue where the Header on my report does not cover all cells when I export to Excel.  This is my first attempt at updating/adjusting Excel formatting with Report Designer.How do I adjust a group or header to match the total cells on the report?  Or, is there some documentation on the Excel formatting and Report Designer?

I added a Attribute to my Vendors screen (AP303000).  I have that attribute called out in my report.  I have my Report Parameters calling Report.GetFieldSchema('Vendor.APOWNER_Attributes').  I am seeing the filed populate on the Reports Parameters on the screen for report and I an even select the desired result to filter agonist.  But when I pick one of the options and run the report, I still get all values for the Attribute, not the one selected.  Am I doing something wrong, or missing a step. 

Hi Community, I am trying to localize a purchase order print form (report) to Portuguese, it translated as expected but there is one textbook that contains one of the terms and conditions that has failed to translate even after surely translating it in the translation dictionaries as you can see in the first screenshot, is there anyone who has faced a similar problem and resolved it? your feedback will be greatly appreciated.As you can see in the last screenshot, the first two textboxes got translated as expected, apart from the last one.  

Has anyone been able to get .heic files to embed in an Acumatica report? We are using Daily Field Reports in the PM module to capture and communicate field activities.  Part of that is showing, in a concise format, images of what was done during the day.  Everything works great if our field personnel take pictures THROUGH the Acumatica mobile app (saves images as jpg), but sometimes they end up with a picture on their camera roll (HEIC file type) and want to upload it after the fact.  The problem we’ve found is that Acumatica Reports aren’t able to render the image(s) in the report.  I realize that you can just go to the report record and open each image, but it’s much less efficient and doesn’t capture all the value of being able to auto-distribute the information via e-mail. Below you can see that we uploaded 16 photos (our report is built with enough variables to display 8), but photos #3, 6 and 8 are showing that there’s data (by virtue of the created date/time), but the image does

Sharing in case anyone else gets stuck here - I setup a simple business event aimed at triggering an action. Each time I tried to setup the Action Execution I would get an error reading Error: Another process has added the 'ActionExecution' record. Your changes will be lost. After numerous attempts I noticed in the trace log that it also stated Cannot insert duplicate key row in object 'dbo.ActionExecution' with unique index 'ActionExecution_Name'.  which made me finally realized that we had an old Action Execution with the same SubscriberID in a test tenantThis wasn’t obvious, since both the Business event and Action Execution were new and totally unique, but after trying a new name on the subscriber ID I was able to save successfully   

Good morning community,I have been asked on the Transactions for Period report to set up the parameter to be able to search by the last 6 numbers of the subaccount ID. I have tried adding “Left” in the formula and 6 at the end and that is not working on the parameters or the formula field.Any best practices to get this to work? Search parameters   Thank you in advance for any pointers!Thank you,Trisha

When running the AR Aging report for some accounts it works while for some others it doesn’t.  I get this error: 6/4/2024 8:18:56 AM Error:Can't calculate expression node: 'pageHeaderSection2 (PX.Reports.Data.PageSectionNode) dataItem: '.  

HI, I have a client who is asking for this on the Sales Order printed form, SO641010.rpx:*T Total - Set a variable to accumulate the extended price for each line as it is processed with an initial value of 0. Increment value with the extended price for each line as lines are processed. If and when a line with Inventory ID = *T, the form should print the Transaction Description and the variable accumulated value in the extended price column. Reset the variable to 0.I have a variable that is the subtotal of the lines. The problem I am having is printing the variable and when it is getting reset. I have tried various things to get this to work.The Output is clearing the variable prior to the data being printed, see below. Here is a picture of the variable & how it is being reset.    

Hello,Does anyone experienced this issue. The report is looking fine when you hit Run reportHowever, when you click print we are receiving this error: 

Hi all, We’re a global company with 4 different buyer teams. While we have tried to standardize our forms, we’re still finding that some Branches need different information on their forms. For example, the last page of our forms have Ts & Cs need to be different per Branch. What is the best method to identify and use a form per Branch?

All, we have fields for a graphic’s width and height. In the results grid I have a formula to calculate the Square Inches; however, it’s rounding to 0 precision (no decimal places). How do I extend this Square inches calculation to 3 places? =CInt([InventoryItem.UsrCFCHeight] * [InventoryItem.UsrCFCWidth])