Reports and Generic Inquires

Hi Everyone,I am trying to add a side panel that will list the details lines of the selected PO in the Commitment Tab of the Project screen, Could anyone have a clue on how to do that? 

Hello all,Can you help me in building up the logic in coloring the rows of a GI where if the Date is due in the next 2 days it should turn the row as orange.I have applied the logic as below:Date<=Today()+2, ‘orange’ where upon running the GI it throws the error for system cannot convert +2 system.int. How to resolve this?

Can I generate bulk invoices for tenants where the standard item, such as the rental fee, is already pre-filled?

I need some guidance on how to go about to create a GI on weekly FLSA reporting for OBBBA compliance purposes. Unfortunately our company does not have the payroll module included in our package so using that one is not available for us. The logic should be pretty straightforward; If EE works > 40 hours per week then take OT & DT hours X Effective rate X .50 to get qualified OT amount. If anyone has made this GI or has tips on how to achieve this it would be greatly appreciated. 

Hello, does anyone know how we can reprint EFT remittances?

Hello, I created a new form in Acumatica and I’m trying to publish it for use. I saw a guide on using the Site Map to publish it but then there are further steps that I’m not sure of. Does anyone have a 5th grade level explanation on publishing a brand new form? I saved the .RPX file so I can upload it as well.Brent

Hi Acumatica Community,We have a request from our UK users regarding mandatory EU legislation: two statements need to be added to the Commercial Invoice for two different customers. As far as I understand, these statements are not tied to the customer record nor to the customer location.What would be the most elegant way to handle this in Acumatica? Would it be feasible to implement this by creating attributes, or is there a better approach?Any guidance or best practices would be greatly appreciated.Thank you!

I have grouped the report by Type. Now I need to calculate a value in a new column that depends on data from both Type records (e.g., Type = I and Type = E). The calculation should use values from both Types within the same group and display the result. Is this achievable in an Acumatica report?

Hello Acumatica CommunityI am working on a GI for AP Aging that gets exported to Excel. The PO Number is a requirement for this GI, but there is a something causing duplicate records. Example: This is by quick filter for the Reference Number of one billIdeally, this would only be one line in this GI. Here are the GI detailsThe duplicates are only occurring with AP documents with more than 1 line items. Please advise on how I can remove the duplicate records.Thanks!

Hello! I currently have a GI that shows all sales within a certain time period. However I am noticing that credits are showing as a positive number. I saw a few ways that you can turn them into negative but my report is built off of ARTran fields. Is there a formula I can use for this? Here are my current fields in the “Results Grid” tab 

Hi.I would like ask why my report is not working anymore in the new update, especially the groupheadersection1 (header for district) and groupheadersection1 (header for area). Here are some of the formula i used and the parameters and filters i’ve setup.Thank you. 

Hi all! We have a generic inquiry showing the sum of all cases per customer.The GI shows zero if the customer has no cases and shows the sum of all their cases if the customer does have any. All if working well here.What we want is to have date parameters, where if the customer during the selected date range have cases, then show the sum of those cases during that period. If not, then show zero. So, regardless of the date range, all customers should always be listed in the GI, only the number of cases should change.The problem right now is that if I select a date range, the GI only lists customers if they have cases created during that period. Customers with zero case created during that period will not show. We want the GI to always list all customers and show zero if there are no cases during the selected period instead of not showing the customer at all. Any thoughts on this? Thanks!

Regards,I would like to know if there is a possibility to formulate the visible expr to show a Contains condition.I'm looking for a way to only present me with the information when the ARInvoice.DocDesc Contains 'End-Period Plus contract' since it is the way in which I can filter the inroversion and it shows it correctly Because if I condition it by Equals it doesn't show me the information I'm looking for 

I have InventoryItemBody in the report.How can I configure the field so that it retains its formatting when printed?Thank you. 

Hello, I have added a barcode to Worksheet Picklists to show the barcode for the lot/serial number. However, this is viable even if there is no lot/serial number for the line item (although this barcode is not usable). I saw on another post to set the value under the Visible Expr in report designer, but I am failing to write the correct expression. Does anyone have any idea how to accomplish this?  

Hi, I found the error"Column 'INLocationStatusByCostCenter.InventoryID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."when creating an inquiry INLocationStatus when adding the formula=IIf( [INLocationStatus.LocationID] = [INItemSite.DfltShipLocationID], Max( [INLocationStatus.QtyAvail]) - IIf( [INItemPlan.PlanQty] = Null, 0, [INItemPlan.PlanQty]), 0)The following is the result grid that I madewith the following additional conditions 

Hi everyone, I need to find or create a report that shows me the AP Vendors banking information, Bank Account and Routing Numbers. I’m struggling to add those “fields” to an existing GI we have. I understand the Payment Instructions Information is entered in a Grid, but how can I report on that information by vendor?GI created for us attached - only shows Bank Name Thanks!

Hello all,Does anyone know why a report would be missing from our menu even though it is in the site map AND I can access it with report designer? See below.  

I would like to inquire whether someone could advise me on how to use an existing Generic Inquiry so that the results can be sent automatically on a daily basis to specific email addresses.I have attempted to configure this using Automation Schedules and an Email Template; however, I have not been successful.Thank you in advance for your assistance.

Does anyone perhaps have an idea how to set up a Generic Inquiry that would be sent automatically on a daily basis to specific recipients via email and would include information about Sales Orders—specifically when the ship date was changed, what the previous ship date was, what the updated ship date is, and who made the change?Please note that Audit History is enabled for Sales Orders.

Where can you find live, hands-on training for GIs and dashboards?

I have a pivot table that shows units sold and sales $. When I click the hyperlink value for units or dollars, I get an error message saying ‘Invalid Column Name’ and it then references one of the columns in my data source - which is a Generic Inquiry.What I’m trying to see is if I can customize where these hyperlinks link to - and create my own drilldown tab. I’ve looked around on this community and prior questions like this have either no answer or mentioned you can’t customize the hyperlinks.Hoping things have changed since and maybe there’s a solution?thanks all!Joseph

Hi there, For any GI results page like the stock Sales Order screen (SO3010PL), why do some fields allow you to filter by checking or unchecking specific values like the Status column does……while other fields like Order Type only list generic operators and prompt you for a filter value?What determines this distinction? Is this something that is editable such that we could make the Order Type field filterable in the same way as the Status field is? Thanks! Jon HunsickerJones School Supply

I’m trying to pull one character out of the PMProject.ContractCD field in Report Designer.  Using this expression...=Substring(CStr([PMProject.ContractCD]), 5, 1)...a “0” is always shown no matter what number is in the numeric 8 position field.  This expression DOES work in a GI, however, and pulls the correct digit.  How can I get this to work in Report Designer?   

I have this GI that is looking at SO Lines. I am wanting to restrict which SO Line is showed based on the site ID. I heard (correct me if I am wrong) that if I can filter via the relations table, the GI can run faster (vs using the conditions tab or creating filters in the user facing GI). But I can’t seem to make it work. I’ve tried every variation I know (hence lines 2 and 3 are different in the child field. If creating this filter in the conditions tab will the direction I should go, then I don’t even need to link the SOLine and INSite tables.