Reports and Generic Inquires

How can I use the most recent currency rate for a calculation in a GI. The currency rates are constantly being updates so when the field is pulled in a GI it is pulling all the effective rates instead of just the most recent one. Has anyone had experience with this/been able to use just the most recent currency exchange rate? 

How to get OData in Client Timezone through Generic Inquiry??In a databse it is store in UTC

I want to Show Date in GI as it is show in Production order detail1. Production Order Detail  In DAC i will use   But in GI it is showing  which is show in GI so i will solve it and show 2:30 which is correct But in Postman it is showing wrong  

Currently we are experiencing an issue in Acumatica - Power BI Integration for a Single tenant of a multi tenant instance. The issue is as follows. Please check the below screenshot.There are 2 tenants in this instance as  Test and Company. The connection for both tenants worked fine until recently. Now only for the Company tenant this above error is getting appeared. I examined all the GIs that have exposed via OData. In every GI there was no any field named DateCreated. There are no any significant difference in between these two tenants.  So can i know what's wrong with this Company tenant that cause this error.    

Hi, As per the screenshot I need to change the sales value to the number value. It should be all numbers instead of 512.43K.Ex : 512.43K = 512,430        5.33 M =  53,300,000   

hi, I am working on a report. I have passed Parameter name “Items” which is attach with inventoryitems. When I am selecting Items in parameter and running reports its duplicating the grids two time (as shown in picture below) .In the QTY column i want user to select the QTY from parameter. that must be from 1-100. Is there any way to do that? If yes please guide me on this.  I wa unable to see my tables after creating relation between customer and address so I make relation of these tables like this as shown in picture is this causing the issue? I dont want to join Inventory table with any other. but without relation it was added but not shown.     

Hello,Does anyone know if it is possible to set the scale of a Acumatica widget chart? For example want the Y axis scale to be 0-100.  Thank you,Kage

Following a recent upgrade into V2023R2, it has been reported to me that the Tree Control available at the top of the Report Viewer form, for those reports created with the Acumatica Report Designer, no longer navigates to the first report page associated with a grouped entry selected from within the Tree, instead simply refreshing the display of the report and repositioning its currently displayed page back to page #1. After researching this further, it appears as though this is a consistent behavior across all of the Report Designer based reports within a given V2023R2 instance, and has continued to behave in this manner for those reports being ran within V2024R1 instances as well, including brand new “clean” installs.Has anyone else experienced this behavior with the Report Viewer Tree control after completing an upgrade into V2023R2 / V2024R1, or after having performed a brand new “clean” install using any of the builds available for this pair of major versions? Thanks in advance f

Hi All, I am trying to create a bill of lading. So I have created a report in which I have passed one parameter of customer_id which will be selected by user before running report. and i want that selected customer to be printed in report under shipment heading. But it’s not printing the complete address not even the name of the customer. Can anyone please guide me or help me I am new to Acumatica Report Designer ? I have attach screen shots and RPX file. I have created the relation of customer with address dac but its shows me error  

Hello all,How can I add a visible expression for localization. I have 2 images. One is in english & other in German. I am looking to add a visible expression that when the Locale = English and my first image should be display and when Locale = German then my second image should be displayed.

Hello, guys. How can I modify this report screen? For example, I want to add a button. Is this possible at all?  

Hello,I have a custom report which uses the InventoryItem dac and i want to sort it by the UsrReportLine custom field which is in the InventoryItem dac and it is a nvarchar type. I have applied the sorting but the sorting doesn’t seem to be working properly.This is the report outcome. But the sorting doesn’t workRelationshipSort conditionI have also attached the rpx file below. Please if anyone could check and let me know i would greatly appreciate it! Thanks.

 Hello, I would like to create an email template SM204003 with logos that link to a page. I save the logo in Haufe and then insert it via Insert -> Image.If I were to send the email now, the logo would appear in the email as it should be.However, as soon as I add a link to the logo, so that clicking on it redirects the user, the HTML code changes in such a way that when sending an email, the image is also attached as a file.  HTML without linking <td style="text-align: center; padding: 18pt 0cm 18pt 15pt;"><img src="https://Kundenname.haufe-x360.app/Frames/GetFile.ashx?cache=yes&file=Benachrichtigungsvorlage (61)\Kundenname_logo_positiv.png" objtype="attached" data-convert="view" embedded="true" title="Benachrichtigungsvorlage (61)\Kundenname_logo_positiv.png" width="200" height="70"></td> HTML with linking  <td width="125" valign="top" style="width: 93.75pt; border-top: none; border-bottom: none; border-left: none; border-right: 1pt solid rgb(251, 99, 3); b

How do I fix the GI for Appointments? I would like to restore this GI to it’s “out-of-the-box” configuration. Thank you!

Hello,Running into a strange issue and wondering if anyone else has seen it. One of my users, when he types content into the pop-up Email window, if he moves that window around afterward, the text will be cleared entirely. This behavior is new and only occurs for one user. He is on Windows 11 and using the latest release of Google Chrome. Thank you

How can i add a value for Specific warehouse Qty in report?For Ex:- There is one customized Report for which client needs to display warehouse , Location Qty but when i go to Inventory summary that location is coming for specific Item number not for every Stock Item.So for ex there is one Stock Item which display the Value for Location A - 550 Stocks and Location B - i need to show which displays as - 330 as QuarantineSo i need to display the 330 Value which displayed for Quarantine only.  

We recently upgraded the version to 2023 R2 and when running a report we get the following error:has anyone had something similar happen to them?

Is there A report or DAC that can show a detailed transactional cost analysis of an item? it should show the unit cost per piece, by PO receipt, including and excluding landed costs.Please let me know. 

I’ve tried joining on Shipment and its line split, as well as via INTran and INTranSplit.I wrote a query to pull some relevant data. It is later filtered from ARTran details in SO643000.trans    ARDocType    ARRefNbr    POReceiptNbr    RefNbr    SOOrderNbr    SOShipmentNbr    Split    LotSerialNbrINTran    INV    AR012036    PR002026    005940    SO007464    PR002026    INTranSplit    INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    SRF000005INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    SRF000006INTran    INV    AR012035    NULL    005939    SO007463    005039    INTranSplit    20230307 The top one is what I have in the ARTran. The bottom three are what actually have the serials for the invoice in question. It doesn’t have serials, and I can’t find a single ID in common.The test case I have is here. It has serialized items on the invoice, but getting them is the problem. Any help is appreciated.

There is a customized field named "New Discount Code" in the Details section of the invoice. There is a requirement to get the summation of this new "New Discount Code" discount amount with the Discount amount in the Discount tab to the Invoice report. Please check the attachments. Can I know if is it possible?Discounts in details sectionDiscounts in discounts tabI have tried some ways by creating a sub-report. But the expected outcome was not coming. I joined the two tables as follows. Please check the below attachment.Table Joining in report designerAnd grouped by the [ARInvoiceDiscountDetail.DiscountID]. The output of the sub report as follows.Sub report outputLeft side of the report shows the discounts in the details section and right side shows the discounts in the discounts tab. But the discount named “SPRING” is missing in the above report. So can I know if is there another way to get the summation of these discounts into the report discount code vise separately?

in a report when I do few calculations always, I got incorrect values, I have posted another question in the community. Link is below. Error in Calculations of simple formular in ReportsI guess this occurred due to the variable is not reset correctly. So how to use this reset option, please provide few examples. 

I create a Report related to Project transactions; Following is a dummy implementation of that. I create two separate reports to calculate Income and Expenses, then embedded two reports in main report and calculated difference between income and expense. when i print the Income value and Expense value in the main report it printed some value. but when i calculate the difference using same variables it gives unexpected values.ResultReport design: Report designFormular: = $MonthlyExpenseRp_totalExpenses - $MonthlyIncomeRp_totalIncomei tried different formulars like,= CInt($MonthlyExpenseRp_totalExpenses) - CInt($MonthlyIncomeRp_totalIncome)but any of them did not works

In this report if i select the document type as “Credit Memo” and a Ref Nbr related to that and run this report, I want to output a different report(Credit Note Report) that has the same parameters as this. If i select “Invoice” doc type then i want this report(Sales Invoice Report) it self to output. Is that possible to do ? If so then how ?Thank you in advance! 

Hello Acumatica Team,I am wondering how we can attach emails sent from the system to a purchase order as an activity. In the notification template, there is an "Attach as activity" checkbox, but it doesn't seem to add the sent email to the purchase order. How can we achieve this?This email is supposed to get sent once a purchase order needs approval from another person, so it is not connected to a report.Greetings

Hello Acumatica Community,We occasionally encounter an issue where a line break causes the text in the second line to start indented, with the first letter beginning further to the right. Is there a formula or method to prevent this from happening, as the break seems to be made before a space? See Line 2