Reports and Generic Inquires

Does anyone know a workaround to populate the current or last WeekID (EPTimeCard.WeekID) in a parameter on a GI.  I have a few use cases for this and in order to use the GI’s for Dashboards I need this filter to be applied.   As a workaround I know I can use weekstart as its a field on EPTimeCard but this is less user friendly as users would be able to pick dates other than week start dates from the dropdown. For example you can use @today or  @weekstart-1 for a specific date field but I have been unable to figure out the logic to do this for a WeekID if its even posable. Thanks in advance for any suggestions.   Attached is a GI I’m using to show missing timecards.

Hello,I m a new user of Acumatica,  I would ask the other more experimented users, is there some way to retrieve data from the cloud database down to Excel like I was used to do with my MS SQL Server database, via Power Query fonctions (I had of course the Server address, username and password to be authorized to get in) ? thank you very much. Cai

I’m trying to access attachment contents over OData so I can pull Stock Item images into Excel. I tried PX.SM.UploadFileRevision and PX.SM.UploadFileWithData, but the UploadFileRevision.BlobData column doesn’t appear in either a Generic Inquiry or in the OData feed. Does anyone have any ideas on how I can access the raw file attachment contents? Note in these screenshots that there are 5 columns in the Generic Inquiry, but only 4 columns appear in the results: 

Good day, I modified a check form (AP641000), and everything looks good, when printing more than 1 check, the View PDF or View HTML shows the correct data on the preview of the PX.ReportViewer.axd. But, when you print the checks using the PRINT button, ** I edit this part, as I get the margins to work, but not the first page *** the starting the second page, the margin for the second and third page will move up, but the first page margins (seems to be the top margin) will not match the other pages, is about a row down, not even that much, but is notisable.  Have any had any experience with this? The customer is printing on an HP printer and I have an HP printer and can replicate the issue, but cant seems to find a solution for it.

I have been trying to figure out if this functionality is possible in Report Designer. I have a report with a grouping of items. I am trying to add an image that spans however many rows are in that group, but currently if I add a pictureBox to the section, it will repeat for X number of rows in the group and also add additional whitespace for each row. Is it possible to have an image (pictureBox) span multiple detail rows/groups in report designer? I have seen a previous example using a vertical line that spans down the entire length of the report by using the “bring to top” option, but trying to recreate this using a panel with a picturebox included has been unsuccessful. I’ve also attempted using a panel, line, and/or pictureBox with a background embedded image set, but that did not work either.   

Does anyone know of a way to show the applied payment total (including prepayments) on the SO Invoice printed form report (SO643000.rpx)?  The field appears on the SO303000 screen and the total is correct, however that field (ARInvoice.CuryPaymentTotal) is not available to choose in the Report Designer.  It seems like this would be a common requirement, so hopefully we are just missing something obvious here.  This is for 2020 R2.  Thanks in advance! 

helloi tried to join batch and account which is not possible so i have to pass by gltran to get one field to filter with it branch.status  my problem now is that each line is duplicated many times i know the problem is with the join between LegalGneralBalance and GlTranI tried to join with Account and i tried to group the result with AccountID Or AccountCD but i got the same results 

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.