Reports and Generic Inquires

Hi,I created a custom Payment/Receipt report, but the Payment Reference Number parameter is not working. I’ve attached the report .rpx file and a screenshot for reference.Could someone please advise what might be causing this and how to resolve it?   Thanks 

Hello, We’re experiencing an issue in Acumatica...When i go to Receivables > Customer Statements > Run Report., the PDF toolbar used to show Print, Send, and Export buttons. But now the Send button is missing. Has anyone else run into this or know a quick way to fix this? Been trying to figure this out for hours 

I have a dashboard with a scorecard tile that gives an invoice total for the current year. It is set up with parameters for date so that if the user onlys want to see the invoices for February, they can choose the appropriate dates on the dashboard. Then there is another scorecard that gives the invoice total for the previous year to date. It also has parameters so that the user can choose the dates and compare invoice total to to the same month last year for example. I have added a trend tile and it updates based on the salesperson selected, but does not update based on the dates selected, so that if the dashboard user selects February of 2022 and February of 2023, the trend tile still displays the trend for all of 2022 to all of 2023. Is there a way to configure the trend tile to also consider the dates selected by the user of the dashboard and give a trend for February 2022 to February 2023 if that is what the user has selected? I have selected last year as the period to compare.  

After the update my GI is not found. Can get help. I try locating it in the site map but It,s not there.  

We use the realtime sync to push new sales orders from Shopify into Acumatica when they are placed. We do not export sales orders from Acumatica back to Shopify.This works great, but the Shopify connector is also syncing orders back into Acumatica whenever the order is updated in Shopify.This is a big issue because the re-sync of orders overriding our changes to sales orders made during order processing in Acumatica.Here's an example:An order was placed and sent to Acumatica at ~8:40am Our rep processed the order in Acumatica and made changes to the order. After, they merged the account on the order in Shopify with a dupe. This change to the Shopify order made the connector see that the order was updated in Shopify and re-synced the order at 11:59 AM. This re-sync of  the order wiped out the changes that we made to the order in Acumatica after it had already been shipped.We need the connector to do the initial sync of new Shopify orders, but NEVER update the order in Acumatica again.I’

I am trying to create a report where I want to filter Receipt numbers based on the Vendor.I attempted to use the following expression:=Report.GetFieldSchema('POReceipt.ReceiptNbr,VendorID')But this is not working - the lookup does not return the expected receipt numbers for the selected vendor.My goal is to allow users to select a VendorID first, and then the ReceiptNbr dropdown should only show receipts that belong to that vendor.Has anyone implemented this kind of dependency between parameters (Vendor → ReceiptNbr).Any guidance would be appreciated.

We are having issues tracking manual price changes on sales order lines. The business has removed the ability to manual price change from most staff but if we had proper visibility its likely we could give the access back to select staff members which would solve alot of problems created by removal of the function. There are genuine reasons why we need to manually price something and what i’d like to be able to do is exclude manual price changes by specific people from appearing in a GI. I am using a sales order by line report then using various filters to work through the data to remove lines that are ok (some of this is SO created by vs SO Line added by and if its been added by someone who is allowed to manually price it can be excluded) but I'm left with lots of lines that on face value look like they have had a manual price change but when I go into the audit trails the line has been modified by an approved person. Does anyone have a GI built or could share what needs done to allow

Not sure how this has been vetted but significant issue with report.  It will show invoices and payments for voided vouchers instead of either excluding them from the report or showing zero in the invoice and payment column.  This is when you use the summary level and is very disappointing and incorrect way to show the data. 

Hello - We are creating a generic inquiry to be able to search for Freight values by vendor and/or property, and want to be able to have the system generate the Total Freight amount depending on the filters the user selects. We have experimented with adding the ‘Sum’ to the Aggregate Function column for the Data Field usrTotalFreight, but that does not seem to be generating anything. Am I missing a step? Attached is the GI for reference as well. Thank you!!  

I’m struggling with a problem.  Whenever our Internal Sales Order (repurposed the regular SO form) goes to a page 2, we lose Order No, Order Date and Customer ID value.I am running it with the parameters for a single invoice.  Thoughts?Page 1Page 2  

We started looking at Dataself recently.  We have been doing a “roll your own” data warehouse for reporting with PowerBI, and it’s been painful.  The PowerBI side is great, but we’re working with our MSP who has some knowledge of ETL and data warehousing, but no knowledge of Acumatica dataWe have a Dataself demo later this week, but I’m curious about the communities thoughts.

Hey Team,I made a nice little dashboard for the storemen to reference. Then i noticed it wasn;t showing for them, it just shows padlocks. I’ve tried all of the access by … Rights/user/role - But cannot seem to make it visable for them. I essentially use one GI for the whole dashboard. AttachedCan anyone shed some light, i can;t see why they wouldn’t be able to see this data given they have full use of the salesorder/shipments area.   

Our Purchasing Department has put notes in each line of a test Purchase Order. When using CTRL+Alt the Inspect Element shows that the field is POLine.Transactions, but, in the Report Designer POLine.Transactions does not appear and there are not child alias’ by the same name. I have been through every Note field that the Report Designer has in the tables that come with PO641000 and none of them has the data that was put into the Note fields.

Hi All! I had a good question that came to me today and it would be nice if this is possible with Generic Inquiry advanced filters. Is it possible to change what fields get displayed on each of the tabs that’s created using advanced filters? For example, in the screenshot below, on All Records, I would like to see all the fields that are currently here. But on the Complete Orders tab, I would like to only display certain fields. I know there is Column Configurator, but it seems like the column configurator setting applies to the whole GI, not individual tabs.  Thanks!

I have a GI that outputs SOOrder information.In the GI settings I use two date fields to do SO Created Date is between two dates. If I enter 9/11 and 9/15, sales orders created from 9/11 through 9/14 are returned, when I would expect SO's from 9/11 to 9/15 to be returned.If I do the same filtering using the column header in the report, I enter 9/11 and 9/15, sales orders created from 9/11 through 9/15 are returned, as expected.I believe the 'between' in the GI is broken. 

Hi everyone,I am facing an issue with a customized ARInvoice report (Report Designer) in Haufe X360/Acumatica.When a prepayment invoice (DocType = PP) is applied to a regular invoice, the tax section in the main report shows multiple tax lines.Example: Net amount: 30.00 € Tax (19%): 5.70 € However, in the tax section I get three lines: +5.70 (invoice tax) +5.70 (tax from prepayment) –5.70 (adjustment/correction line from prepayment application) The totals are technically correct, but for the customer it looks confusing because the VAT/Tax is printed three times (see attached screenshot). What I tried so far: Added a VisibleExpr in the tax section, e.g.:   =IIf([ARInvoice.DocType] <> 'PP', True, False) → Unfortunately this did not solve the issue, the duplicate tax lines are still there. Checked if the issue is coming from the subreport → but it actually happens in the main report. It looks like the tax section is pulling from both ARInvoiceTax and the adjustments (ARAd

I’d like to do a GI to show quantity available of stock items that is filtered by a vendor ID who has a cross-reference number for that stock item. I’ve identified the data lives in these tables but am not having luck getting the results: I either get 30k plus rows where it shows the same stock items many times over or errors that indicate my joins are off. I’m not an SQL expert unfortunately and hoping this is something that can actually be accomplished with a GI instead of custom dev.  See below for my tables, joins, and filter.   

Hello,Currently working on a formula for our stock items for our eCommerce site. We are wanting to update the title based on the picklist field called Visibility on the eCommerce tab. When it’s set to Invisible, the title should be updated to DELETE, else set the title as the Web Title attribute.IIf( [StockItem -> Custom.ItemSettings.Visibility] = 'I', 'DELETE', [StockItem -> Attributes.Web Title] )The issue we are running into is that regardless of how we set it, the formula is evaluating to TRUE and updating title to DELETE. Not sure if I’m missing something. Thanks!

Has anyone successfully created a GI based off of other GI’s as the data source? I am able to add them as data sources no problem, but I am getting “Object reference not set to an instance of an object” error when trying to join the sources. I’ve checked to make sure the fields are existent in the database on the DACs I am joining. I am joining on inventory ID from both generic inquiries. Any advice or further documentation on best practices when joining two inquiries? 

I am trying to add a $ sign to my GI. I saw this formula “ =’$’ + CStr([ARTran.CuryTranAmt]) ” in the community but there is one challenge with it. It resulted in 4 decimal places. I’ve tried a lot of formulas to reduce it to 2 decimal places per my company requirement but its not working. Is there any way to make this work.ChatGPT gave me this instructions to apply but for some reason I can't find the properties to apply the Data Type = Decimal. and format Format = $#,##0.00. 

Hi everyone,I’ve encountered an issue with invoice printing in Acumatica. For invoices that contain multiple analysis keys (subaccounts), only one key is currently printed on the invoice.I would like to display all analysis keys that appear on the invoice, separated by commas (e.g., 10, 20).The challenge is that the Report Designer doesn’t support loops or iterative logic, so a manually written expression would have to check and concatenate each line individually. This quickly becomes impractical for invoices with many lines.Has anyone found a reliable way to display all analysis keys for an invoice in a single field on the report? Any guidance or workarounds would be greatly appreciated.Thank you in advance!  

Hello 🙂, my issue is that due to reverse charge (i.e., input/output VAT handling), the line items appear twice on the document.I want to create a filter in the Report Designer to correct this duplication.Does anyone have an idea how I could solve this problem?Below are a few images that illustrate the issue.   

Hello everyone,I’m facing an issue with the Sales Order (LA) report/form where some line items are unexpectedly shown twice, even though the underlying data looks correct. I suspect the problem is related to how the SOLine and SOTax tables are joined or how the data is grouped in the report.I’ve tried adjusting the joins (like using a LEFT JOIN between SOLine and SOTax) and filtering tax records, but so far without success. Removing the SOTax join causes errors or missing data in the report.My goal is to display each line item only once, while still showing the correct tax information, so that invoices and shipment documents don’t have duplicate lines. If anyone has any ideas or could help me troubleshoot and resolve this, I would really appreciate it!Thanks so much!Pantea  

Hello everyone,I'm trying to display the Opportunity ID on the invoice form (Report Designer). To do this, I created the following join structure in the schema:ARInvoice(NoteID) → CRRelation(RefNoteID)CRRelation(TargetNoteID) → CROpportunity(NoteID)Unfortunately, the Opportunity ID still does not appear on the report.I also tried using SOOrder instead of ARInvoice, but then the line items are shown twice (I’ve tried all possible join options).Does anyone have a tip on how I should proceed?Best regards,Pantea

Has anyone had the need to display or pull the value of an entity’s sequence in the group? Specifically, I have customer that uses Customer Statements heavily and prints via an offsite 3rd party company. Their vendors printing requirements include specifying the customers print sequence as part of a sorting QR code in the bottom right hand corner. For example: 1st customer = 2 page statement / (starts on page 1)  / Sequence # 1 2nd customer = 3 page statement / (starts on page 3) / Sequence # 2 3rd customer = 1 page statement / (starts on page 6) / Sequence # 3I have gotten all other four parts of the QR code to pull, but the sequence number has been eluding me. My latest iteration is displaying everything else correctly, but the sequence part which is finally displaying unique numbers, seems completely random otherwise? =Concat( 0 ,[PageIndex], 0,[PageCount],Count( [ARStatement.StatementCustomerID] ), [@JobID])Any thoughts on how to accomplish this?