Introducing Acumatica Cloud ERP: 2026R2
Get inspired and gain all the knowledge you need
Recently active
We have a site in the UK who want to lookup postcodes and have the address entered automatically. When a new customer is created they enter the postcode and it displays all the address’s in that postcode. The user will then select the correct address and its updates the relevant fields. Can anyone advise on a solution that will work in the UK.
Hi Acumatica Support Team,We are facing an issue while uploading attachments to a Bill of Material (BOM) using the Acumatica REST API.Scenario:We need to upload a file to the following BOM record: BOM ID: BOM000023 Revision: * File Name: AACOMPUT01.jpg We are using the following API URL for uploading the attachment:http://localhost/AcumaticaQMS26R1/entity/ABPManufacturing/25.100.001/BillOfMaterial/BOM000023/*/files/AACOMPUT01.jpgWhen we execute the API request, we receive the following error:A potentially dangerous Request.Path value was detected from the client (*)Questions: What is the correct REST API URL and HTTP method (PUT) for uploading an attachment when the BOM Revision value is *? Does Acumatica support * as a valid Revision key in the attachment upload URL? Can we use %2A instead of * to avoid the ASP.NET request-path validation error? Is there any alternative supported approach for uploading attachments to a BOM with Revision *? Expected Result:We want to successf
Goal Allow Account Group IDs (ACCGROUP segmented key) of up to 30 characters. Problem On Segmented Keys (CS202000), ACCGROUP shows Max Length = 10. Setting Segment 1 Length to 30 and saving returns: "Error: Updating 'Dimension' record raised at least one error. Please review the errors. The key length is greater than the maximum allowed value." What we have done (customization project FSAcctGroupCD30, published 2026-11-12) 1. Database Scripts > Increase Column Length: PMAccountGroup.GroupCD from String(10) to 30. The Column Length Increase dialog now reports the column as String(30). 2. Data Access > PMAccountGroup.GroupCD: Replace Original attributes, changing only the string attribute to [PXDBString(30, IsUnicode = true, IsKey = true, InputMask = "")] The original attribute had no explicit length. All other attributes (PXDimensionSelector, PXDefault, PXUIField, PXFieldDescription) are unchanged. 3. Published. Max Length on CS202000 for ACCGROUP still shows 10. Findings from
We have been using AD for login to Acumatica for some time. We have several remote users who access Acumatica via the app, using AD login, with no issues. In the past I have been able to log into the system via the app as well as desktop, however now I can just log in via the desktop, not the mobile app. Please note;I can log into the PC web browser from “any” pc just fine using the AD button after entering the URL for the server. I can log in on a mobile device using a browser session and the URL/AD buttons. I can’t log in using the mobile device even though the URL is correct. Open the app, enter the URL, tap next Tap Active Directory Tap my MS account as listed Tap approve a request on my MS auth app Follow the process to enter code for approval Return to the mobile app, which now shows the AD and my ID along with the Verify your identity - your org requires additional sign-in methods to access this resource. I’m only allowed to select Face, Fingerprint, PIN, or security
EnvironmentAcumatica 26.100.0175, Customizations: None (reproduces on a clean instance) Screen: Activity, type Chat (CR306010), new unsaved record User: admin, tenant Company, branch Products WholesaleSteps to reproduceOpen a new Activity (Work Item) on CR306010. Make sure Track Time and Costs is selected and Started On is filled in by default (11/12/2026 3:01 AM) in my case. Click the Completed On date field: im populateing with 11/12/2026, time defaults to 12:00 AM. In the Completed On time field, enter the same time as in Started On (3:01 AM). Value should be <= startdate Actual resultAn error appears: Error: Unhandled exception has occurred, your changes have been rolled back: Insufficient stack to continue executing the program safely. This can happen from having too many functions on the call stack or function on the stack using too much stack space. The entered value is rolled back: the Completed On time returns to 12:00 AM. Trace for the UpdateRecords request (11:01:50 UTC)
Hello all,I have been struggling to create an import scenario where I’d like to delete the existing vendor records from the Non Stock items screen & add a new vendor & set it up as a default.
I've been exploring different approaches to connecting LLMs to Acumatica, particularly around how AI can query ERP data dynamically without requiring administrators to anticipate and configure every possible reporting scenario.With Acumatica's native MCP server in 26R2, administrators can expose selected, published Generic Inquiries as read-only tools for external AI clients. This provides a controlled way for an LLM to retrieve and analyze ERP data while maintaining Acumatica's existing security model.However, there are also MCP-based integration architectures that support natural-language queries across Acumatica modules, execute queries against the ERP through authorized connections, and return results directly to the LLM or as refreshable Excel reports.What interests me is the architectural difference between these approaches, particularly when the AI needs information that hasn't already been modeled in a predefined GI.1. Dynamic querying vs. predefined Generic InquiriesConsider a
Is there a way to restrict what subaccounts can be used based on the account class? We use subaccounts for departmental classification. Like many companies, we do not departmentalize our balance sheet and use 000-000 as our balance sheet class. With that, we do not want any departmental subacounts used on balance sheet accounts and likewise, we do not want the Balance Sheet 000-000 designation used on any P&L accounts. We have to clean this up every month because mistakes will be made.
Is there a way to link an user account to an employee record?I understand that I would need to set the UserID field on the employee's Contact record to the user's PKID value. From Slashdot this was one of the answers:“In addition there is also Employee.UserID that you would want to set equal to the Users.PKID value. The virtual field is populated using that Contact.UserID value but in the RowUpdating handler Acumatica is updating both the Contact and Employee records when Users.ContactID is changed.” Is there any more clarification on this?
I'm curious how others are leveraging Business Events for automation beyond basic email notifications. Have you found any creative use cases that have significantly reduced manual work for your users?This is a follow up to some of my AI posts. Looking for ideas
Goal: Create an appointment via the API.The stock API version 26 seem to allow setting of the appointment start date via the field ActualStartDate. However the End Date and Time can only be set via fields having the _Date and _Time suffixes. The Web Services management UI shows an error that the fields shouldn’t be hooked up this way, even on the default endpoint.Using the default endpoint, I’ve tried setting the date and time in various ways, but it’s not clear what format it accepts, and I’m getting inconsistent results. Timezone errors seem common.I cannot seem to create a custom endpoint. The UI does not appear to allow access to the end date fields, they aren’t in any of the mapped objects (what are those things anyway?), even though they are present in the DAC browser.Currently I can set an Actual Start Date and Duration via the default endpoint. I would have expected this to populate the End Date but it does not. I cannot set the scheduled dates reliably, sometimes it works
Have any versions prior to 2026R2 been updated with the CSV export type for 1099 e-file? This appears to be required by the IRS for filing for tax year 2026. Finance: File 1099 Forms Through the New IRS IRIS System Good news if you file 1099 forms: Acumatica ERP is ready for the IRS’s move away from FIRE. The Internal Revenue Service (IRS) is retiring the FIRE system and replacing it with the modernized Information Returns Intake System (IRIS). The changeover begins in the 2027 filing season (tax year 2026). Starting in Acumatica ERP 2026 R2, the Create E-File process on the Create E-File (AP507500) form generates CSV files formatted for IRIS instead of FIRE for both 1099-MISC and 1099-NEC.
We are using the Acumatica 2026 R1 contract-based REST API (25.200.001) to create Stock Items and configure warehouse-specific Inventory Planning settings.Our goal is to create a stock item with two warehouses configured as follows:Warehouse Source Source Warehouse A001 Manufacturing B004 Transfer A001 The stock item uses the MRP planning method.BackgroundInitially, we attempted to create both warehouse records through StockItem.WarehouseDetails. However, the replenishment source values were being inherited or overwritten, resulting in both warehouses having the same source.We subsequently moved to the dedicated ItemWarehouse REST entity (IN204500 / INItemSiteMaint), using separate PUT requests for each warehouse.We also determined that, for MRP items, the standard ReplenishmentSource and ReplenishmentWarehouse fields do not appear to control the Inventory Planning settings correctly. Instead, the manufacturing-specific fields and their individual override flags must
I have an excel file that has our external payment reference numbers and our acumatica payment reference numbers but I’ve been unable to successfully import these onto a bank deposit. I’ve been using a mash of 2 older import scenarios with varied success. I can create the bank deposit no problem but adding the payment lines is where I fall short. Here is my latest import scenario version. The Action Save line is on the bottom and not showed in the screen shot. XML attached.
Hi all, We upgraded to 2026 R1 (26.101.0225) and started moving screens over to Modern UI. Since then, users whose role has View Only access to an analytical report can no longer run it. Same roles and same access rights as before, and these reports ran fine for them in Classic UI.What we're seeing on an analytical report (RM screen) in Modern UI, by the role's access level on that report:- View Only: the Run Report button is greyed out.- Edit: Run Report can be clicked, but the report fails with "Object reference not set to an instance of an object."- Insert: the report runs normally.- Delete: runs (same as Insert). The Request Profiler shows the Edit failure here:PX.Data.Reports.ReportMaint.FillReportSettings()PX.Data.Reports.ReportMaint.FillReport()PX.Data.Reports.ReportMaint.runReport(PXAdapter) What we've found so far:- In Modern UI the report parameters page runs on ReportMaint with Report as the primary record, and it opens as a new unsaved (draft) record. In Classic, reports on
Whenever I reconcile a fixed asset via the “convert purchases to assets”, it always credits my fixed asset clearing in the month of receipt. I want it to post in the period I put the FA in use. For example, we receive in September, don’t use until November (that’s when I convert purchase to asset), I want it to credit FA Clearing in November since September is closed at that point. Some setting I am missing? The purchasing entries post in the period I indicate it is in use.
Hi Everyone,I’m working on a customization where I need to add an action to the Sales Order line that behaves similar to the standard Add Related Item function. I already have a custom popup and a DAC that stores line-level kit component details. Now I want to extend this by adding the “Add Related Item” functionality inside my custom action.I’m looking for guidance on the correct approach: How can I call or reuse the existing “Add Related Item” logic from my custom action? Is there a way to trigger the same popup and selection logic that Acumatica uses in the standard action? If the standard behavior cannot be reused directly, what is the recommended pattern to rebuild this functionality for a custom grid action. Any examples or references of extending or overriding the Add Related Item action would be helpful. Screenshot to refer : This is my action in grid & I copy same field in action with same attribute but its not working.Thanks in advance for any suggestions or example
Hello everyone,I’m facing a very disturbing issue regarding modern UI. I have a really basic processing screen, to mass update Matrix Items.When trying to access this screen I have the following error : The view [Blank] doesn’t exist. Here are the stack traces : I don’t have this error on my local instance, just on the customer’s one.Error seems to be realted to the note process, I tried so many configuration but I can’t make things work. If I go to “Applay updates”, and press the “Reset Caches” Action, everything MIGHT work, until the next publication. I even tried changing the screenID since there seems to be some corrupted info stored in some cache, but it didn’t solve anything. I don’t understand why at all… Does anyone have any idea? Attached you’ll find : -My graph (as a txt)-The DACs used in the screen. (as a txt).-My Modern UI files and my classic UI files in the customization project. If you need any other information, please ask. Have a great day.
Is there any idea from where system bringing the value for Harmonized Tariff number in Commercial Invoice.
Hi everyone,I'm looking for advice on how to streamline the inventory returns process in MYOB Acumatica.Our client is currently using the Sales Order Returns process. When items are returned, they are received into a designated Returns location and then manually transferred to their correct warehouse locations.Is there a way to configure MYOB Acumatica to automatically direct returned inventory items to their appropriate storage locations during the Sales Order Returns process, rather than having them first go through the Returns location?Ideally, we would like the system to: Automatically assign returned items to their original or designated warehouse locations. Eliminate the need for additional manual inventory transfers. Maintain accurate inventory quantities and location tracking. Are there any standard configurations, default receipt location settings, or warehouse management features that could achieve this?Any suggestions or guidance would be greatly appreciated.Thanks!
Hello, A customer of ours utilizes web endpoints to process data outside the system. One field in particular is an extension on the BAccount DAC that gives legacy IDs for customers. Previously, we connected this to our Invoice entity in our Web Endpoint by adding the Legacy ID as a column in the customer selector on the invoice screen. Seemingly as of 26R1 however, this field no longer shows up in the results when querying Invoices. The field in the UI of the Web endpoint displays as a viable field to be selected (both when adding in the grid and under ‘Populate’ interface) however nothing comes through in the results. The other stock fields from the Customer Selector do work however. Endpoint display:Customer selector on invoice screen:Endpoint Query result (legacy ID should be at arrow): If anyone has any ideas or sees anything we are missing, please let me know. I am aware we could ask the customer to cross query a Customer endpoint for this information, but I want to raise this in
Hello Acumatica Community ,Is it possible to add a Date Range filter to Financial Reports in Acumatica through a customization? I'm trying to enhance financial reporting and would like users to be able to specify a from/To date range before running a report. Has anyone implemented something similar or used a customization approach to make this work? Best Regards,Charles Rohit Rayen
We are receiving the following error when attempting to close a payment link for a sales order:Cannot Change item list when invoice is closedCurrent situation: No payment has been made through the payment link. No shipments have been created for the sales order. Clicking Close Payment Link returns the error above and prevents us from closing the link. We expected to be able to close the payment link even though the order is unpaid and has not been shipped.
Self-hosted 2025 R2, instance under C:\Program Files\Acumatica ERP\xxxx. Publishing projects with Modern UI files fails. I confirmed the cause: the npm process runs under the app pool identity, which has no write permission inside C:\Program Files, so webpack dies instantly with no error at all. Switching the app pool from ApplicationPoolIdentity to LocalSystem fixes it. Granting Modify to the virtual account does not.We publish only once or twice a year and we'd rather not create a dedicated service account on the OS. So what's the right way to handle this?Switch to LocalSystem only during publish and switch back?Reinstall the instance to a non-protected path like C:\Acumatica? is there an official recommendation for the app pool identity and folder permissions when the instance is under C:\Program Files?
Using the Calendar Board (Modern UI - 26R1) seems that if I want to change start/stop time of an appointment, it forces all techs to have the same start/stop. How can I use the calendar board where each staff (tech) is managed individually?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.