Introducing Acumatica Cloud ERP: 2026R2
Get inspired and gain all the knowledge you need
Recently active
Hi, I’m creating a pretty simple new table / DAC to create a validated list of cities for custom usage. This table consists of 2 fields, a CityID (int) identifier and a CityName (string). I want the CityName to be multi-lingual, so based on what I found in documentation, I’m creating it with the [PXDBLocalizableString(50, IsUnicode = true)] attribute. When I try to open a simple grid view screen I get this error “Invalid object name 'UsrCityKvExt'.”The field is displayed and I see the language selector in it, but data can’t be displayed/inserted/updated.When I just use a PXDBString instead, I have no errors, and I can do everything in a single language. This is a snippet of the DAC I’m using for UsrCity (it also has the typical Acumatica system fields CreatedBy, TStamp, etc.) #region CityID [PXDBIdentity(IsKey = true)] [PXUIField(DisplayName = "City ID", Enabled = false)] public virtual int? CityID { get; set; } public abstract class cityID : PX.Data.BQL.BqlInt.Field&l
Hello,We recently started receiving the below warning during our inventory planning runs. We haven’t seen it before and haven’t made any changes to the inventory planning process, so the message surprised us. We’ve reviewed the automation schedule and it seems correct, has anyone encountered anything similar and if so, what was the fix please? We’re currently on 26R1
I have Automation Schedule and in the Automation Schedule History i have empty column. Have any idea why? Automation Schedule working with my custom processing screen
I have a custom field in the header of a screen. I cannot find a way to add the hyperlink button to the field.This was addressed for a grid field here:I’ve added the [PXDBWeblink] to the DAC field, but that does not make the link button show.I think I might have to modify the TS file, but I cannot adapt the code from the above topic.export class CROpportunityHeader_Combined_generated { UsrURL: PXFieldState; Any help would be super appreciated.
Estimated reading time: 15–20 minutesWhile working with Acumatica Report Designer, there are several small things that can save significant time during development and troubleshooting. I thought of sharing some practical tips that might be helpful to other Acumatica developers and consultants.I've compiled some practical tips and lessons learned that may help Acumatica developers, consultants, and report designers save time when building and troubleshooting reports.1. Passing Parameters to a SubreportWhen passing parameters from a main report to a subreport, make sure you verify the parameter mapping carefully.Example: A Sales Order report passes the Order Type and Order Number to a subreport that displays additional order information.Things to verify: Define the required parameters in the subreport's schema. Ensure the parameter names match the names expected by the subreport. Make sure the parameter data types are compatible. In the main report, configure the subreport control'
Hi CommunityMy client has requested that I add the 2 branches in the company to the detailed Trial Balance, to give them a consolidated detailed TB by subaccount. It sounded pretty straight forwtd to me, so I created a new report and added a Brnach column, but I am missing something as all the detail is missing.Can any of you clever people assist please? I have attached the RPS file in DOC format. Please rename the report before you try and open it.You help is much appreciated.Regards
Hi AllIn Acumatica I know there is a setting to warn if an item on an SO does not meet minimum gross profit requirement or it can be set to the minimum required value.What I would like to know is if there is any way to block the order from being processed rather than just giving a warning or to set the price to the minimum value.ThanksAmit
Hi everyone, Does anyone know where the key comes from or is inserted when adding a new file? I am trying to include a new file to a new installed instance(I have no customizations), but still the error is shown. Also I checked the profiler and it is not trying to insert anything, just querying a few tables. Thanks
Hi Everyone,I modified the Transactions for Account (GL633500) report to display additional information by introducing two subreports. The report is displaying the required data correctly; however, I am encountering performance issues.The report runs significantly slower than before, and when generating reports for periods with large volumes of data, the process often fails to complete and returns a session timeout error.I have attached the following reports for reference:GL633500 (main modified report) LCCIPLRef (subreport) POOrdNbr (subreport)Any suggestions or best practices for improving execution time and reducing the likelihood of timeout errors would be greatly appreciated.
Hi all,Two pieces of news for MCP4Acumatica, our open-source (Apache-2.0) MCP server that gives AI assistants governed access to Acumatica:It now runs on Acumatica 2026 R2. It can run Generic Inquiries that take parameters. Until this release it refused them, and the reason is worth knowing even if you never use our server.Acumatica 2026 R2We've been running a second MCP4Acumatica worker against a 2026 R2 sandbox (contract endpoint 26.200.001) alongside our 2025 R2 production one. On 2026 R2 we've exercised the Generic Inquiry tools (listing, describing, running, parameters, filters), entity lookups and searches on the contract API, and the documentation tools answering from the 2026 R2 documentation, release notes included.What went into it:Documentation index for the new docs format. From 2026 R2 the official Markdown documentation ships as one file per help topic; the ingestion script handles that layout since 0.54 (and still builds the older monolithic guides). Exact totals (0.55,
Is there anyone that has come up with a way to split a production order after production has started, manually, that allows for the order to be tied back to the original order for quality compliance?If so, how are you doing it?We are trying to use Acumatica 2026.Example: 100 pc are put into production 7 steps into production we need to split the order due to some issue. 50 will be completed as originally planned and 50 will go through some other process before being shipped to the customer.We need to maintain the history of the entire production order for quality purposes. Even if it requires a custom report and some way to flag the orders to put them together.Using Lots or serial numbers are not an option.
Is there a way to add additional notes for a specific item record and have it print on documents it’s on?Would that be the “Description” tab?
This has been going on for quite some time but it came up again with another client. We experience it regularly when looking for ISV offerings internally and typically just use a Google search over the Acumatica marketplace page. When using the search for a particular product, the Marketplace page rarely provides an accurate result. Here’s an example with an offering that should be there (especially with offerings directly from Acumatica): In this particular case the client was contacted directly and was wanting to research the offering on their own but it did not show up on the marketplace so they were concerned and contacted us.Other examples are when customers simply search for a topic and hit enter: It seems like the search is simply looking at text on the ISV’s feature page instead of having some form of ranked (and managed) keyword priority setup in the marketplace. Even with a basic word search, the results have no reliable ranking and therefore are of little value, forcing the
Hello Community,We need to lock request documents (MR, IR, SR) once they progress to a second or later operation such as PO, GRN, Inventory Issue, Appointment or Service Order.Current behavior: Users can still reopen, cancel or edit quantities after downstream documents exist, and the system sometimes reopens the request automatically after POs are generated or materials are issued.Required behavior:Freeze the request completely once it moves to approval, PO, GRN, issue, appointment or service order. Block reopen, cancel and quantity edits after that point. Prevent automatic reopening after PO generation or stock issue.Question: Does Acumatica have any built-in facility (workflow, automation steps, access rights or a setting) to manage this? If not, what is the recommended approach?
I keep on getting this error below and cannot release a PO receipt for a non-stock item. Both line items are already linked to the PO and Sales Order. Refer to screenshots below. Does anyone know how to resolve this error? Error Message:There are one or multiple lines in the 002436 drop-ship purchase order that are not linked to a sales order. Link all lines in the 002436 drop-ship purchase order first. Screenshot of SO: Screenshot of PO: Screenshot of PO Receipt Error Message Thanks,Frances
System design (I use 2024R2 and will be using 2025R2 soon): Prepare statement process should be triggered for each cycle, and must be completed successfully before going to next steps. Print statements process depends on the prepare process, and can’t be triggered unless the preparation is completed successfully. Current state:I use automatic schedules to run the process overnight because it lengthy process. We run Prepare Statements schedule first, then check the next day whether it is successfully completed and that the statement cycles are available in the “Print Statements” screen. Based in the previous successful schedule, we trigger other schedules to email the statements The question/Desired situation:Is it possible to configure the schedules to run in sequence based on the successful status of the predecessor schedule? i.e. I want the system to use schedule to run the prepare statements, and if this schedule is successfully run, then run the email statements schedule.
Has anyone tried converting the MUI self service portal back to a grid display? The default shows pics and looks like I’m selling T-shirts. My customer sells repair parts like screws...thousands of screws. the classic catalog shows a grid which is waaay more appropriate for this customer. Before I waste a week or two, I’m just wondering if anyone has already tried this. And most importantly, can it even be done? I was able to remove the images, but that is little consolation for the customer.
We are working on a Customization Project and have been assigned the initials DSG for the project.The Screen Editor only allows two characters to be entered but our validation fails with the following.Can you please advise how we can address this? New site map screen names must start with the assigned prefix.SiteMapNode | Billing Accounts | DS131000Custom screens and reports must start with the assigned prefix.: Billing Accounts ScreenID: DS131000 SiteMapNode | Configurations | DS111000Custom screens and reports must start with the assigned prefix.: Configurations ScreenID: DS111000 SiteMapNode | Custom Data | DS121000Custom screens and reports must start with the assigned prefix.: Custom Data ScreenID: DS121000 SiteMapNode | Shipment Details | DS501000Custom screens and reports must start with the assigned prefix.: Shipment Details ScreenID: DS501000
Hello! I have two e-mails stuck in ‘processing’ status that I cannot cancel and re-try even. But emails before and after to those two have been sent successfully. Any idea on how to resolve this? Thank You!
Hello,Order types have a checkbox setting for“Ship Separately” and “Bill Separately”However, I do not see where we can designate this for a customer.We have some customers who want this and some who do not and we need to control it at the customer level.Any thoughts or guidance are appreciated!
Acumatica 2026 R2's built-in MCP server, compared with MCP4Acumatica2026 R2 ships its own MCP server (the MCP Server feature under AI Studio, configured on MCP Servers, SM302100). We maintain MCP4Acumatica, an open-source (Apache-2.0) MCP server for Acumatica that runs on Cloudflare Workers, so we put the two side by side on a 2026 R2 sandbox: same user, same Generic Inquiries, same queries, Claude as the client. Along the way we found a few things about GI OData that matter to anyone using it directly, and we checked those on 2025 R2 as well.Short versionThe built-in server is the easiest way to give an AI client curated GIs — if you license AI Studio. No hosting, parameterized GIs work, and every response carries an exact total with skip/top paging. The MCP Server feature sits in the AI Studio feature group, so it is only available when AI Studio is part of your Acumatica license. It is GI-only, and the model gets no help when a query is wrong. Every failure we triggered came back as
I am trying to update the default supplier on non stock items.The client wants to replace the current default supplier with the new one, rather than add a row.I have been able to achieve this but the last supplier price is not being overwritten. I believe it should be 0 unless stock has been purchased by that supplier in the past. I am not sure what the behaviour of the last supplier price would be here, if it would update in that way.Importing with the below replaces the existing default supplier with the new one but the last supplier price remains the same. I assume it is doing the same if I click in the Supplier Id field on the non stock items suppliers tab and select a new ID. Having tested this, the last supplier price also does not change.The import scenario should need to remove the supplier completely for a new one to be imported correctly?
hello all,I have been trying to access Acumatica outside the server but it triggers the below error:However I’m able to run the same instance on localhostCan some please help me out in this? The Server guys said since it is being handled by IIS they cant do anything.
Hi all, We recently just upgrade to 26R1 and now whenever we try to download email activities as .EML files, they open with a gibberish string such as the one below.Has anyone had this issue? PGh0bWw+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxzdHlsZSB0eXBlPSJ0ZXh0L2NzcyIgc3R5bGU9ImRpc3BsYXk6bm9uZTsiPiBQIHttYXJnaW4tdG9wOjA7bWFyZ2luLWJvdHRvbTowO30gPC9zdHlsZT4NCjwvaGVhZD4NCjxib2R5IGRpcj0ibHRyIj4NCjxkaXYgY2xhc3M9ImVsZW1lbnRUb1Byb29mIiBzdHlsZT0iZm9udC1mYW1pbHk6IENhbGlicmksIEhlbHZldGljYSwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAxMXB0OyBjb2xvcjogcmdiKDAsIDM2LCA4MSk7Ij4NCkhlbGxvLDwvZGl2Pg0KPGRpdiBjbGF
Hello all, I’ve created a GI to drive two separate Business Events (an Email, and a Task). They both work but not nearly as well as I need/would like.Long story short -- I need to trigger a weekly reminder and email. IE, a change made to a record today, November 2, would trigger an email in +7 (November 9), and create a task with a start date of today with an end date of 11/9, with a reminder notification triggering on 11/9.When I make a change to a Business Account (picked up by the business event tied to the GI), an email goes out, and a task is created, but I essentially need this to be done “@Today +7”Any thoughts/ideas? Thanks!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.