Reports and Generic Inquires

Does anyone know why the same report would squash “one cell” text when moved from Sandbox Report Designer to Production? Settings are the same in both --> we can't seem to find line height, that is our only idea where this might be a solution.I was able to edit all other text fields to single lines as it happened in every combined text field. But I don't want to adjust the "bill to" and "ship to" fields because they're formulas. Same goes for the "Description".

Can someone help me with the joinin to get the Approved Employee from this screen ?I want to get the approved employee related to this Refnbr. I tried so many ways but none of it is working.This is the joinin that im currently using in my report schema builder.Also the dac mentioned in the inspect element of the approved employee is hidden. Therefore i am trying to get it through its base dac which is EPEmployee. Also once the record is approved the name and id goes to EPApproval dac. How can i navigate from APPayment to EPEmployee/EPApproval in order to get the approved employee name ? Please help!

Hello, Working on report designer SO643000.rpxI have been looking through a few solutions on the discussion boards about adding the Shipped Qty as well as the Open Order Qty onto the Invoice without duplicating lines or having the whole report error out. None of these solutions have worked for me so far. I have tried the following connections:ARTran-SOOrder  & ARTran-SOLine \\\\SOOrder-SOLine \\\\ARInvoice-SOOrderShipment & SOOrderShipment-SOOrderLine None of these three solutions has worked out. I either get duplicated values or the whole report errors out. Does anyone have more suggestions? Thanks,Megan

but I cannot filter it. I use this : =Report.GetFieldSchema('Contact.ContactID,CustomerID')

I need to load Invoice numbers related to a specific customer. How can i achieve this? I am passing ‘ARInvoice.RefNbr.CustomerID’ in the report designer parameters but no invoice numbers are displayed. Please help!Report Parameters 

Is it possible to put in a condition to not display a text field in the page header section if the results is in the detail section?I have tried different conditions but it only seems to work when I put the condition in the details section, but this results in the text field being added per line. So when I run the report and there are no lines to display currently the heading still displays:  here is an example of when there are lines to display:  

Each time I try to open or create new generic inquiries, I get the message:Value cannot be null.Parameter name: PXCacheNameAttribute Any ideas on how to fix this? 

I have a GI which I would like to show a column with not only the date, but also show two columns with the Year and Month part of the date. I have tried using =CSTR(Year([ARTran.Date]), =CSTR(Month([ARTran.Date]), =Year([ARTran.Date]) (using the formula editor for the last one), but the column, sadly remains empty. I am not using it as a filter, just need the two added columns.

Hello,Created a GI and added all of our data fields.  Inquiry loads perfectly fine.  However, we can’t search the data field “InventoryCD_Description”.  When I try to check the box that says Use in Quick Search, it doesn’t let me.  Any idea why?    

Hello community,Where can I see monthly gross profits for projects? If we dont have any data views created for this, then which fields shall I consider to check the numbers?Thanks.

Hi all,Why can I see the Contact table in the Schema Builder but not in Expression Editor.   I am using the statement notification email template and there are a specific email setup on the customer contact and set in mailing & printing tab So I am trying to send the customer statement to the mail address that I setup on the customer mailing and Printing.  Thank you in advance.Dries  

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