Reports and Generic Inquires

hello everyone, I was trying to create a report with two different date ranges to compare the values, for example, if I chose a date range from  01-2018 to 03-2018 it would bring me the values from this range and from last year like 01-2017 and 03-2017 and I was wandering if I can add a check box when I check it (true) some filters will appear to choose the second date rangethank youthis is the standard report I want to compare values like the report in RM00CG00  

We are rolling our the contract management module and noticed there really aren’t any reports or inquiries out there. Has anyone developed reports/inquiries for contracts they’d be willing to share?Thanks!

How can pass list of values to a single parameter in the report designer   

Hello, I am trying to add the Customer Order Nbr to my Shipment GI. I have added the table and included the correct item in the Results Grid. However, nothing is populating in the GI. Any idea as  to why?  

I am trying to set Dashboards for various users in our company.  Is there a good video training or KB article that would be helpful? 

Hello,    We previously enabled system locales/multiple languages.  Now, the inventoryitem.descr looks like right and proper in the GI screen like below:   However, when I am trying to use it in the email template, it is displayed with extra information.  [{en:YIHAI\ 15x1000g\ Seasoned Chili Oil}]    You know, we don’t need the {}，[]  and en： kind of things   How can I make it just look the same as in the Screen.

We’d like to use the results form different GIs for one report, is this possible? How?

Hellowhen I try to recover the field [InventoryItem. Body] and change the option convert HTML into text and the option can splits to true, it doesn't move to the second page so it always removes some lines and I want to know if report designer has a limit on how many lines can print from InventoryItem. Body THANK YOU

Looking for help from GI experts! It is very difficult to distinguish between open service orders that have appointments scheduled for the future and open service orders that have appointments that have past or no appointments at all. (In this case, appointment needed = false). I’m creating a custom GI called “Appointments on Open Service Orders” that shows me if there are future appointments for a service order or not. This appears to work--I can identify if there are no future appointments, therefore triggering review.The only issue is it doesn’t show me open service orders that have no appointment at all. Generally, if the service order is open, no appointments are created and appt needed = false, it’s because there is nothing in the Details tab (to trigger appt needed). I can’t figure out how to create a way to catch this (because there are no appointments and no details, so what do you use for GI?).So, I have two questions: Does anybody know how to “catch” open service orders with

Hello，     For the SO643000.rpx, we are using Acumatica original logic to display the Date and Due date as below:         It shows properly when print the invoice on the screen directly.          However, when we are using “Notification template” to attach this report and email it to customers.      It shows 2 and 3 instead of Feb and Mar,      Which we does not understand.    because the rpx is exactly the same one      Can somebody help me?      

Hello everyone, Is it possible to print items with zero quantities on a pick list? I am trying to get some non-stock items that have a distinct item description that act as line comments for the sales order. For example, I will have 10 lines of stock items with quantities and then 2 lines of non-stock items that act as description placeholders for the order itself, however they are at an order quantity of zero.  I have tried to play around with the visibleexpr and simple iif statements to no avail. If anyone can point me in the right direction on this one that would be great.

Hello,We are implementing time card in a client who does NOT use project, and finding that just basic time card reporting seems to be lacking. Has anyone created time card reports or inquiries they would be willing to share? Thanks! 

I’m setting up some Generic Inquiries that are exposed via OData for ingestion into a data warehouse.Some of the GIs are comprised of data from multiple tables (Customer + Address, for instance).In order to implement an incremental load strategy, I include a computed data field for Last Modified DateTime that looks like this:=Max([Table1.LastModifiedDateTime],[Table2.LastModifiedDateTime],etc,etc)But when I try to filter on that via an OData query such as this (where the actual date/time is filled in based on a previously captured value)$filter=ModifiedOn gt datetime'yyyy-mm-dd hh:mm:ss' I get an error messageError while copying content to a stream. Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. However, if I include all of the LastModifiedDateTime values in the GI, I can successfully query data with a filter such as$filter=LastMod1 gt datetime'yyyy-mm-dd hh:mm:ss' or LastMod2 gt datetime'yyyy-mm-dd hh:mm:ss' or ... or

I am having issue when using attributes for project tasksnot allow default value. this is different compare with attributes in Case or other screens When sorting by attribute in one Generic inquiry, it generates the error. I then tested a GI with cases, it allows sorting on attribute there. 

Does anyone know how to display a boolean field as a checkbox on a report?

Does anyone know if this Use Master Calendar checkbox on the Report Definitions (CS206000) screen does anything? I have a Company where the Financial Period ID 11-2020 is mapped to the Master Calendar Period ID 02-2021 in the Company Financial Calendar (GL201100) screen: If I make an entry for $60 to period 11-2020: Then I create a report with the Use Master Calendar checkbox unchecked, the $60 appears when I run the report for period 11-2020 which is what I would expect: Then I check the Use Master Calendar checkbox and relaunch the report. But I get the same $60 result in period 11-2020. I was expecting it to be empty because I was expecting to have to run the report for period 02-2021 to see the $60. But when I run the report for period 02-2021, it’s empty which is not what I was expecting. It makes me wonder if the Use Master Calendar checkbox actually does anything or maybe it just got added to the screen with the functionality coming in a future version. I did my testing in Acuma

Does anyone have a clever way to use a Parameter in a Generic Inquiry to generate a HAVING clause in SQL right after the GROUP BY clause? It generates a WHERE clause which doesn't allow me to work with the aggregation results.I can do an on-the-fly filter, but I was hoping to use a Parameter.

Hello,      We serve chain stores, and they are requiring a report every month like below:The cell value is the weekly usage of that single store      store 1,2,3 is served by branch 1, store 4,5,6 is served by branch 2, store 7,8 is served by branch 3        Yes, this report can be done, if we run an inquiry by branch. And manually merge the data together to each colored section in excel.        But my colleague is tired of doing the merge again and again.       Is there a way to help him fill in the excel more quickly?         I am thinking of “Pivot Table”or        the “Excel Sync function”  from different GI data sources, the problem is excel sync can not be parameterized.       or “the report designer”,  the problem is the layout        Which way do you think is the best way to fulfill my need？ Or Can my need be fulfilled?       Please advise. Thank you. 

Hello,         I need your help. Previously I thought it is easy, but Now I did not find out a solution.As we know, the 0 shipment line would not turns into ARTran.So we might meet a situation like Shipline                                  ARTrana                                                     bb                                                     cc                                                      d                                                          eline d and e is added by Advanced Direct Invoice Function. So they only have invoice#, no shipment#line a is shipped 0, so it did not turn into ARtran.My need is to display on the Printed out Paper invoice with all lines: although a is with 0 qty.likeabcdeI previously thought is a full join can get this done.But my problem is, if we are printing Invoice, we normally only know Ref# and Type.If I apply the Invoice ref# as the where condition,The line a will still be disappeared,  Because  a.ref is null.What should I do? Can a

Hello，    I put the sub report in the group header align to left, and set its text align to left         But when I run , the sub report will still show in the middle of the master report          Is there a way I can make the sub report to align left?

Hello Everyone, Just want to find out if we can specify a reprot template that can be used according to assigned role? e.g. when a Billing person runs a Sales Order report to be printed, it does not include the logo etc as they will be printing on a ‘pre-printed’ form and would only need the specific details like the item, price, tax etc. But if a Salesperson print the same Sales Order, it will printed everything including the logo etc. Thank you guys in advance. Kind regards,Mrivera69

When we send an email from our Shipment screen (SO302000) using Actions>Email Shipment, the emails that get generated are almost identical to the Notification Template it must be using (ID: ShipmentConfirmationNotification), except there is one line inserted “Track your shipment at [Tracking Link]”.  Unfortunately, that [Tracking Link] placeholder doesn’t use the tracking number to populate. I can’t determine where it is getting this change to the template.  It is the only Notification Template related to Shipping at all.  There are no changes in the customer’s Mailing Settings or the Sales Order Preferences Mailing Settings.  I’d like to delete that line, but can’t find it, plus you cannot alter the email before processing it. We are running 2020 R1 build 20.106.0005 with the Manufacturing Edition. Any help would be great!  Thanks!

I can retrieve data from the POLandedCostSplit table in the database: But I can’t find a Data Access Class that will allow me to retrieve the POLandedCostSplit data: I need to retrieve the data using a Generic Inquiry and I’m trying to avoid having to create a SQL View.Does anyone have any ideas?

Does anyone what the difference is between the N and O LayerType values in the INCostStatus Data Access Class (DAC)?I’m also wondering if there are any possible values other than N and O.INCostStatus is the DAC that stores inventory costing layers and it’s used in the Inventory Valuation (IN615500) report.

Hi, so i am new to ACM report designer.  I am creating a report of payroll for our vendor, where every detail(job) done by the vendor is listed. Which includes job date, start time, finish time  and different payment for the same job(officer pay, city fee, car fee).ReportNow my report is grouped by job ID. And the information about the different payment is pull out a DAC called” APTran”, where the are stored in a table like below. But not all job includes all 3 form of payments .Some only have officer pay, some have officer pay and city fee and some have all three(and they are always stored in city fees, car fees, officer pay- in this order).There is a field called inventory id ,which includes the three payment method class. To get the officer pay information in the report row i used =Last(IIF([APTran.InventoryID]='OFFICERPAY',[APTran.LineAmt],Null))Since its always the last one in the table. *“LineAmt” is for the Amount field. To get the city fee i used=First(IIF([APTran.InventoryID]=