Recently active topics

I am creating a Payment/Prepayment through the Acumatica Contract-Based REST API and applying it to a Sales Order using the OrdersToApply detail.The same API payload structure works for several Sales Orders, but it fails for some specific orders with the following error:An error occurred during processing of the field Order Nbr.:The order cannot be applied, the specified combination of the order type and order number cannot be found in the system.Sample request structure:{ "CashAccount": { "value": "XXXXX" }, "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "CXXXXXXXXXXX" }, "Description": { "value": "Shopify Payment XXXXX" }, "Hold": { "value": false }, "OrdersToApply": [ { "AppliedToOrder": { "value": 69.08 }, "OrderNbr": { "value": "ES88832" }, "OrderType": { "value": "ES" } } ], "PaymentAmount": { "value": 69.08 }, "PaymentMethod": { "value": "SHOPPAY" }, "PaymentRef": { "val

In assignment and approval screen of Requests cannot find field status but on screen ui I can see the status field.  

Hello Guys, Im new in Rest Api connections, i need to connect from Postman to Acumatica Endpoints, but i dont know how to configure the connection, boyd, etc from the side of Postman.In acumatica the endpoint is USPS.25.200.001  and i need to get some tables like:ww_ZZ_Analytica_AliasTable_AH  Etc My question is whats is teh config from the side of Postman

I am trying to update the Billing tab email on the Customers screen AR303000 using an Import Scenario.Goal:Update Customers → Billing → Bill-To Info → Email for existing customers. The Billing → Bill-To Info Override checkbox is already checked on the customer.Test customer:Customer ID / AcctCD: 18907What works:I created an Export Scenario on Customers AR303000 and successfully exported the field:Billing → Bill-To Info → EmailThe export correctly returns the current Billing email for customer 18907, so the field path appears to be correct. Import file:AcctCD = 18907Primary Contact Email = XYZ@123.comImport Scenario:Screen Name: CustomersProvider: Excel providerProvider Object: TemplateI have tested mappings such as:Customer Summary → Customer ID = AcctCDBilling → Bill-To Info → Override = ='True'Billing → Bill-To Info → Email = Primary Contact Email Prepare works and shows the one row correctly, but Import fails with:“1 items have not been processed successfully. View name: BAccount.” 

Hi Acumatica Community,I created an Import scenario for 1-Step Transfer but encountered an error.is there a mapping that I need to include to proceed?Thank you!

When trying to import Expense Receipts, I keep getting this error message but I’m not sure what is erroring. Looking at the import scenario, it looks like its pulling the information correctly but it doesn't like something about the claimdetails. Any advice? 

Hello all,How can I define sorting conditions for cost codes with segments. I tried to define as:    Still no impact.

Hi SirWe would like to know what mean of production variance.As we do a disassembly transaction and notice that system auto generate “ production variance” May  i know what is this for? Please refer to the below.If based on below journal , does it mean the production variance 21.44 is reduce the inventory value as the double entry is credit account code14720 inventory.  

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 - Customizing Acumatica Without A Developer II: Vibe Coding With Copilot - May 27, 2026Have you needed to customize something in Acumatica but didn’t feel comfortable doing so? This session builds on Customizing Acumatica Without A Developer session 1 (that covers how to utilize the low-code/no-code capabilities of Acumatica).  If you’re comfortable with Acumatica low-code/no-code options and ready for more, it’s time to get more self-sufficient with Acumatica's advanced customization capabilities that allow you to tailor Acumatica specifically for your organization.RSVP HERE Acumatica User GroupsNew! Indiana Acumatica User Group, NorCal Acum

Hi Acumatica People, I am trying to upgrade a non-production environment to 2026 R1 from 2025 R1. I have historically commented out section in the web config file associated with running RabbitMQ. I downloaded the msi, builds.acumatica.com - /builds/, and kicked-off the installation and it worked.It starts the configuration wizard and I select “Upgrade” and I receive this dialog box:   Then I receive a RabbitMQ configuration dialog box. “Choose whether the system will automatically set up RabbitMQ on the current servoer or if you will provide connection settings to connect to an existing instance.” I opted to “Set up RabbitMQ on this server automatically” It tells me that it is unable to connect to RabbitMQ and that I should try an existing RabbitMQ instance. I would prefer to setup RabbitMQ on the server automatically, using a service account for “Acumatica things”. How do I do this?

I am running into a scenario where I could really use the ability to segment approvals by a particular subaccount segment. 6 years ago Acumatica marked this idea as ‘unlikely’ to implement’. (see: “Approval maps: when subaccount is used as a condition, allow user to specify a segment value, not just the whole subaccount.”)I tried masking the segments with question marks and blanks, but the bill wouldn’t read either one. ‘???-???-100’ and  ‘   -   -100’To accomplish what I need to do, I would have to hardcode almost 75 different subaccounts into the conditions. (will import, but still - not very nice for long term maintenance).Is there a limit to the number of conditions in a particular rule of an approval map? 

Hi everyone,We order things from vendors sometimes direct from overseas or from domestic locations. An item could have different pricing based on where we are ordering it from. e.g. Overseas is $10 USD, Domestic stock from US is $15 USD…Is there a way to keep both sets of pricing for each item in the system without creating a separate vendor?Thank youJoseph

I wanted to help out if anyone was having an issue with slowness after an upgrade to 25R2.  I have two instances that both have the same issue (support tickets 482453 & 482455).Check your system monitor and look for failed Automation Scheduler exceptions.  Look at the details and see what schedule is causing it.  For us it’s Cross-Selling ML Generation.  We disabled it manually and seems to have resolved the slowness.  What I believe is happening is in the AUSchedule DAC, the AbortCntr field is a smallint data type which is a range of -32768 and 32768.  What I think is happening is it's maxed out at 32768 (failures) already and trying to add a failure to it which I think is causing a buffer overflow and it doesn’t know what to do so it’s causing the system to slow down.   We can see in AUSchedule that the AbortCntr is set to 32767.  I have manually disabled the automation schedule for it.  Notice that the new “Max consecutive aborted executions” checkbox of “Do not deactivate” is c

Hi Connections, I’ve a query related to expiry date control in Acumatica. Every inventory is specified as lot/serial and has an expiry date. As a result, based on that approach, expired items should not be processed. Is there any evidence that an item was expired at the time of shipment/transfer? Either Warning Message/ Allow / Don’t Allow Setups.,  I couldn't find any settings that would help me control this concern.  Hope you guys can help me on this topic. Thanks Ram 

I have created a Bill using PUT /Bill REST API endpoint and it created below data, the process also includes releasing the bill but I am encountering a “The document is out of balance” error. It seems the bill header total figures were not calculated correctly. For this bill, I created its own PO and PO Receipt with vendor’s Allow AP Bill Before Receipt unticked (3way match)On second screenshot, I checked the PO Receipt linked to the Bill and based on the Billing tab, it shows Billed Amount as 550 which is correct and matched with the Bill line’s Amount. I am not sure what needs to be added on the payload when calling /Bill API endpoint but when I used UI to create Bill from PO receipt, I don’t encounter the “The document is out of balance” error.Thanks! 

Is there a way to email AIA invoices similar to how the Proforma can be automatically sent?

How do I find a GI’s screen ID from the name of the GI.I’m using OData to get information from GIs into my external application, but I’d like to provide a link back into Acumatica to the GI in question.  Unfortunately, the OData meta-data doesn’t include the screen ID.  I’m trying to find the cross-reference of GI screen names to the IDs but have not had luck. I had assumed that GIDesign + GINavigationScreen would have worked, but some GIs that are Exposed Via OData don’t have rows in GINavigationScreen.   

Hi All,I need some help with regards to bringing the amounts from a proforma Invoice to a main report.I have attached the zip file for the main report(PM652500.rpx) and the subreport. (PM652500CI.rpx)I have the below parameters on the main report.   Below is the external parameter for the sub report.   Parameters on the subreport   My problem is, I can’t figure out how to populate the amounts for [PMProformaLineWithPrevious.CuryLineTotal] on the main report which on the below column. 

Help us shape the future of AP automation!We are currently working on three-way matching improvements and have a prototype we'd like users who work with vendor invoices to test and provide feedback on. This capability aims to eliminate vendor bill discrepancies and protect your organization from overpayments, audit risk, and unauthorized vendor billing. With automatic matching, a simple interface to review mismatches, and smooth integration with Acumatica approval workflows, your AP team gets the control and visibility that modern finance teams need. No more relying on custom generic inquiries or manual workarounds.Be a part of our Acumatica Labs Program to test this prototype and help shape the final solution!If you're interested in participating, please complete this short questionnaire. Update: questionnaire is closed for now. Thank you!We are looking for up to 10 customers to join the program, which will run over the next 2–3 months. We will get back to you within 5 business days t

Hi everyone,We’re delighted to announce this Community Mentoring session with @Neil Cantral!Business Events for Order ManagementA brief overview of Acumatica Business Events, how they are used to manage orders in a B2B distribution company, and a Q&A.Neil: I’m a leader in the PNW Acumatica Users Group and the Director of IT for Wilmar LLC, a B2B distributor of automotive tools trading under brands like Performance Tool. My Acumatica journey started in 2016 and I’m always happy to talk and share my experience with the platform. My focus over the years has been rooted in the Distribution module with a lot of experience in inventory allocations, reporting, third-party WMS, and customization.Community Mentoring sessions are approximately 30 minutes and limited to small groups (10-12) of members with one of our power users who is an expert on a topic. If this session is one you feel will help you in your journey with Acumatica, please let us know in the comments below. We’ll be selectin

Hi, please help me fix my import scenario in AR Import Invoice, I need it to work to be able to upload with multiple lines or inventory id.Here is my import scenarios XML.

Hello Team!I have a customization for the Release AP Documents form that adds a couple of fields to the grid (Cash Account and Cash Discount Date).On classic UI the column filter works ok for the Cash Account. But with modern UI, the search field of the filter wont list the available cash accounts: This is my custom TS extension:import { PXFieldState, columnConfig, GridColumnDisplayMode} from "client-controls";import { AP501000, APRegister } from "src/screens/AP/AP501000/AP501000";export interface AP501000_CBAPReleaseImproved_generated extends AP501000 {}export class AP501000_CBAPReleaseImproved_generated {}export interface APRegister_CBAPReleaseImproved_generated extends APRegister {}export class APRegister_CBAPReleaseImproved_generated { @columnConfig({ allowFilter: true, width: 100, visible: true, allowUpdate: false, hideViewLink: true, displayMode: GridColumnDisplayMode.Both }) APInvoice__PayAccountID: PXFieldState; @columnConfig({ width: 100, visible: true }) APInvoice__Dis

I was doing some work in a column set and noticed validation errored when I tried to use @EndPeriod in a caption column. Running the report, it still generated correctly using @EndPeriod. I noticed on Row Sets, you can still select report parameters from the Formula window. DPL standard Column Set from Acumatica: DPL standard Row Set from Acumatica:   We just upgraded to 2026R1 but I noticed the same in a 2025R2 environment with the modern UI. Switching the column set back to Classic UI, the parameters validated correctly. 

I have a customer that is using Plaid to as their provider for bank feeds. There is a column in the file labeled check number with the check number in the field. The check number is not appearing in the when the bank feed is processed. I attempted to map that field but when I did that, the customer received the error “object reference not set to an instance of the object. 

I’m excited to share these Three AMAZING new features that our wonderful JAMIS Prime Development Team has instore for ALL JAMIS Prime 9.0 Customers.AI Assistant, Copilot, Machine Learning for JAMIS Mobile App• AI AssistantJAMIS Prime now includes an embedded AI Assistant designed to help users answer questions, build Generic Inquiries, and support help/documentation requests using natural language prompts. The goal is to automate up to 80% of the inquiry-building process, with future enhancements planned for business events and dashboard creation.Additional AI capabilities include:Integration with Model Context Protocol (MCP), allowing secure connections to external tools, databases, and systems such as Outlook and Salesforce. FedRAMP compliance enhancements to ensure operational data remains secure and access is governed by user permissions. Anomaly detection in accounting processes and the ability to explain system calculations and features directly within Prime. Future roadmap enhan