Reports and Generic Inquires

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 

Is it possible to display the discounts created by line level discounts from the sales order on either of the invoice printed documents?

Hello all,Trying to build something based on a concept from a great session at Summit 2024 - open to any ideas on this.Goal: Capture the value(s) from fields presented in a workflow dialog box and present them in a generic inquiry.I created the dialog box within a custom Case workflow in Acumatica CRM. The dialog box has 3 different prompts, all of which I would like to capture.The mission is to join that dialog box info with the PX.Objects.CR.CRCase DAC. I believe this is possible based on @Doug Johnson ‘s session :) but I can’t seem to find details on how to configure this when I check the documentation, but I might be looking in the wrong spots. Investigation so far:If I try to inspect the element (1) upon launching the dialog box I see that the business logic is part of CRCaseMaint. But if I attempt to (2) View Data Access Class Source ….   I get crickets:  So, if they’re not here, where can I find them, and then join them to the Case in a Generic Inquiry?Thank you for any input.Ar

Hello - Does anyone know how I can get this field to show up on a GI? It is on the Customer screen under the Billing tab. It seems when the “Override” box is checked, that it will not appear. However if there is a value there and the box is not checked, it will. I am not sure why some are checked and some aren’t either? Maybe an update changed this? Note - this information does typically come from an API connection to a separate system.. not sure if that plays a part.. any help would be appreciated!  

Hi,We are attempting to expose customer specific files on an Acumatica portal via a Generic Inquiry. We already have one that exposes common files associated with the customer using the @me condition which works file.  These files are associated with a property and have the “Is Public” option checked in the file Maintenance screen. We are linking the usual suspects: Contact → Customer → NoteDoc → UploadFile → UploadFileRevision We are adding the files on the customer screen.  When the GI runs in Acumatica, and the @me disabled, we can see the files. In the portal, with and without the @me enabled, we cannot see any files.  We also checked and unchecked the “Is Public” checkbox, without success.  We also attempted to add the files to the customers associated business account, replacing in the GI the customer table with the Business Account table, also with no successes. What are we missing?   

I have a customer that has multiple tenants, and I wrote a SQL view to view all of the users across all of those tenants for administrative purposes.I would like to add a Navigation to pull up the full screen User (SM201010), as a Side Panel link.  However, two things are stopping me. I can setup a relation to pull these data and display it by linking in the PX.SM.Users to a Key in the SQL View. However, I can only pull the users data from the “active browser tenant”. In the SQL view I do store the CompanyID for all the users over all of the tenants, but I do not know of any way to pass that value to the Navigation link so that I can pull any user information from across all of the tenants, unless I have changed the browser into that tenant as a session.Is there any way to pass the CompanyID over to that navigation link?(and I can accept the answer of “NO”. LOL)

Like the title says, I am trying to create a GI that shows all late shipments, whos orders didnt contain any shipments prior. This may be too much to ask for. I am new to GI’s and am trying to figure this all out. Any direction towards if statements within GI’s would be helpful and any help on this particular question would also be appreciated. Thank you! Attached is the GI I have been working with.

Hi Good Friday! I am trying to pull the UNIT of measure conversion details into GI. I am able to generate the GI as needed however I identified every stock item showing false even SKU does not have unit of conversion.For example Below SKU has no Unit of conversion  Another SKU has conversionsit shows two time in GI  During my Observation every SKU has one record saving in DB, How can get the exact records with out showing dummy information

Hello all,I have the below Po order details & the result in PO Order report:The Inventory IDs are same for all, but have modifications made in the Line description column PO Order report PO641000When we compare the above screenshots we see that the Line description are not on the same line number as in the PO screen (PO301000). So I am looking to print the descriptions & details in the same way as they are entered in Line level in PO Order.How can I achieve this?I tried the below in report designer, but still no changes, Thanks.