Discussion Forums

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Acumatica Community Webinar - Acumatica × Power Automate: Export Cases and ActivitiesAcumatica × Power Automate: Export Cases and Activities (with JSON parsing)Learn a fast, repeatable way to pull Acumatica Cases and their Activities

Expand below for Table of Contents:Overview Getting Started Anomaly Detection Mechanics Features and Capabilities Additional Troubleshooting Known Limits and Tips  OverviewIn Acumatica 2024 R2, we released a feature to detect anomalies to identify unusual numeric patterns in Generic Inquiries (GIs). It helps you spot data errors, process exceptions, and outliers that may indicate business issues.

This is my mappingThis is the errorHere is the GICan anyone look at this and tell me what these ultimately means? Feels like I am close to something but need help. Do I need to map more for validation? 

Report DesignerI have this issue with Picking Report, the first two items get duplicated when I'm running the report designer.

I like how I can click the VIEW HISTORY button on the Automation Schedules (SM205020) screen to see when the Automation Schedule ran, how many records were processed, if there were any errors, etc.But I’d also like to know how long the Automation Schedule took to run. Something like an Execution Completed column with a Date / Timestamp would be nice.I’m trying to find out how long my Automation Schedules are taking. Some of them might only take 5 minutes, while others might run for over an hour. It’s important to know if some Automation Schedules are overlapping each other because sometimes you want to make sure that a certain Automation Schedule finishes before another certain Automation Schedule starts.Does anyone know if there is a way to find how long an Automation Schedule ran for?  

Looking to add a Generic Inquiry to the customer portal which shows any open projects associated with the business account of the user currently logged into the portal. Adding the GI itself to the portal is easy however, I am unable to find a way to construct a filter that would look at the currently logged in users associated business account. I tried using the AccessInfo table in the GI however this was unsuccessful. Has anyone attempted something like this with the Customer Portal and a GI? 

Hi,I have a client who needs to report GST in Canada on the Sales and Purchases side. However, they have multiple AP or AR line items under one invoice that could include GST and Non-GST items. I am having issues how to reflect both GST and Non-GST amounts on the Tax Details or Tax Summary reports under % Taxes in Acumatica. Here is an example of the Reporting Group I have setup on the Purchases (AP) side.  I have also created two separate tax zones for GST and GST Exempt here are print screen of those:   What am I doing w

When my users are trying to upload Unit Cost from the file upload the data is not being uploaded.Unit Price works fine and I have noticed on the Columns mapping screen that Unit Price appears twice under Property name (Unit Price) which works and (UnitPrice) which does not. For Unit Cost I only have (UnitCost) listed and not (Unit Cost). I cannot find which Import Scenario fixes this. I have tried amending “Import Opportunites from Excel” scenario to add Unit Cost but it still does not appear in the mapping screen.

Hello everyone, I have a FieldUpdated handler for SOOrder.ShipVia which works fine, but upon saving, Acumatica throws the error ‘Another process has updated the ‘SOAddress’ record. if (e.Row.ShipVia == "W" && oldValue != "W"){ INSite site = INSite.PK.Find(Base, order.DefaultSiteID); if (site != null) { Address siteAddr = Address.PK.Find(Base, site.AddressID); if (siteAddr != null) { SOShippingAddress address = Base.Shipping_Address.Current = Base.Shipping_Address.Select(); if (address != null) { address.OverrideAddress = true; Base.Shipping_Address.Update(address); address = Base.Shipping_Address.Current; address.AddressLine1 = siteAddr.AddressLine1; address.AddressLine2 = siteAddr.AddressLin

I would like to grouped sales by parent/child in generic inquiry to use in a dashboard table. Can someone help with this?

Hello Everyone, I am trying to add watermark in paid invoices, Text box is working fine but i want watermark. I tried everything not getting the results. Please Help!

I have Header Filters for grid. I need to add Project Task field – Allow selection of more than one Project Task.How I can do this?

In this topic, I’d like to share with the community an approach I used to filter data by multiple values.It’s nothing groundbreaking, but I thought it might be useful for someone who runs into a similar scenario.Let’s say we need to create a new screen that displays all employees, where we can filter results by Department and Labor Item (with the ability to select multiple values).The final result looks like this:Modern UIClassic UIImplementationTo implement this, we need to declare the filter fields as follows:using PX.Data;using PX.Data.BQL;using P

I have a simple GI that displays custom, Commission Paystub records for the logged in user. I created shared filters for “This Week”, “Last Week”, etc. to filter those by date range.I exposed the GI to mobile.It works as expected, on web and on mobile.However, I created a dashboard with a KPI widget that uses the “This Week” shared filter from the above-mentioned GI to sum and display the total commission for the current week.I exposed this dashboard to mobile and it also works as expected until the user taps on the KPI to open the supporting GI. The data for the “This Week” filter displays as expected but when the user switches to a different tab the GI data does not refresh. For example, if the “This Week” filter displayed 10 records, then the “This Month” filter will display the same 10 records, but no more. Any other filter that has a date range that encompasses the records initially displayed on KPI, will display those reco

We have a few prepayments stuck in “Pending Processing.” They can’t be voided or validated.I’ve already tried disabling the “Enable Integrated CC Processing” box and then attempting to void, but no luck.We’re on Acumatica 24R1, so official support won’t assist. Furthermore, the transactions originated in Authorize.net, and the Acumatica team says they no longer support auth.net. Has anyone found a way to void or clear these transactions?Hopefully once we upgrade in a couple of months, Acumatica support will be more flexible — but I need to get these cleaned up in the meantime.Thanks in advance! Error when trying to validate: 

after NPM Build Command on Extension Screen Changes are not reflected on UI

I went through the process of creating the customization project and then added AP.APAdjust.  I clicked on Selector Columns and then added APAdjust__vendorID and APPayment__extRefNbr.I saved the changes and published the customization but when viewing the selector within the detail grid of AP503000 I did not see the columns that I added.Just in case, I also replaced the attributes of the APAdjust VendorID column from[Vendor(Visibility = PXUIVisibility.Visible, Visible = false)][PXDBDefault(typeof(APPayment.vendorID))]to[Vendor(Visibility = PXUIVisibility.Visible, Visible = true)][PXDBDefault(typeof(APPayment.vendorID))]but that didn’t have the desired effect.What did I miss?

I’m trying to make this report portrait, however, this report always seems to produce landscape. It seems like there may be extra stuff to the right. What can I do to change the layout of the report?

Hi All. I have a report that I exported in Excel, but the pageHeaders/groupHeaders sections are cut off. They should be extended far right up to the last column. How it looks in:  Excel exported (not OK) - How to extend to the right?: Report designer (OK): System generated report (OK): 

For security reasons, I need to export a specifically formatted .csv file to a bank via sftp. I have a GI that populates when the payments are generated with a specific payment method (but before release). I then have automation schedules that process the export scenario to populate the file, then a separate one on the File Synchronization screen to synch the file(s).This process works and the bank gets the file. BUT, the synch is set on a schedule and submits empty files when no payables are run and I can’t seem to get the business event to trigger export when the file is updated with new/incremental data.Any ideas?

Hello -Has anyone had experience changing an origination value for a Fixed Asset after it has been in service for months? We have an asset that was entered with the wrong origination value and need to be changed, but has also already been depreciating. What would be the best way to go about changing this? Thanks

Hi, I created a new tax zone for specific location. All seems to be ok except orders are showing error message -Tax not up to date and tax is not calculating. Rate is not transfering to order section under TAXES, even though each tax is properly configured with proper %. It happens to exempt and taxable customers. items are set up as taxable. Any ideas? 

This might be a long shot, but I am trying to create an Import Scenario to mass update stock items with Quality Control Plans. Which is part of the QMS Module.  I keep getting an error message because the system says it needs a Test or else it can’t save. When manually adding a Plan to a stock item, once the plan is selected, all tests are added as well, automatically.  It seems, either that automation does not exist when using an import scenario, or the system is trying to validate before that test loads and throws up the error.  So I added more steps to manually add the Test right after adding the Plan. But I get an even bigger error: Error: 'Item Class' cannot be empty. Error: 'Tax Category' cannot be empty. Error: 'Base Unit' cannot be empty. Error: 'Sales Unit' cannot be empty. Error: 'Purchase Unit' cannot be empty. Error: 'Posting Class' cannot be empty. Error: 'Lot/Serial Class' cannot be empty.

We noticed that in Acumatica, the Customer field on a Project can still be changed even after the project is active and has existing transactions or invoices.From an accounting and audit standpoint, this appears risky because the existing AR invoices remain linked to the original customer, while new invoices would go to the updated customer — which can lead to inconsistent reporting and billing.I just wanted to confirm — is there a specific business scenario or setup where this behavior is intentional, or am I missing something in the configuration that should prevent changing the customer once transactions exist?If it is intentional, could you please clarify Acumatica’s recommended best practice for handling situations where a project’s customer needs to be changed after billing has started (for example, whether the preferred approach is to close the old project and create a new one under the new customer)?