Discussion Forums

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?

PaycomConnector — Paycom ↔ Acumatica Integration================================================Hi all,I've built a native Acumatica customization that integrates Paycom HR/Payroll with Acumatica 2025R2, and I'm gauging interest from the community before polishing it up for wider release.What it does------------   Employee sync — Bulk + per-employee API sync from Paycom. Creates/updates EPEmployee records with compensation, contact info, supervisors, departments, and GL codes. Automatic user login creation.   Reference data sync — Labor items, earning codes, tax codes, projects, tasks, and locations pulled from Paycom categories.   Labor cost import — Drag-and-drop CSV import from Paycom labor cost exports. Smart resolution of Paycom codes to Acumatica references. Custom cost engine preserves Paycom rates through time card submit/release.   Real-time webhooks — Inbound webhook receiver with HMAC signature validation, deduplication, and debouncing for live HR event processing.   Audit l

For classic ui we can define parameters in the site map that automatically gets filled in for example:~/Pages/MQ/MQPS4010.aspx?SourceID=ProdOrderDetthis automatically select ProdOrdDet for the SourceID when a user clicks that specific site map, and we can have multiple site maps for the same screen with different SourceIDs specified. I tried the same logic for modern ui using this:~/Scripts/Screens/MQPS4010.html?SourceID=ProdOrderDethowever, the screen opens with no SourceID selected. What would be the syntax for modernUI screens?

Do you know what DAC SOShipLineSplit is for and what triggers its population (UOM issue)? I am trying to understand the difference between shipline and shiplinesplit.As an example:Product XX has a base unit of EA and Sales Unit of BOX (5 EA in a BOX). Units are marked as divisible.  PO is EA (so we can’t change the base unit) We raise a SO for  XX: Quantity: 1 BOX Shipping transaction shows XX. Quantity 1 BOX ,the sales unit. On the Picklist form (report) the UOM is set as “=IsNull([SOShipLineSplit.UOM],[SOShipLine.UOM])”.  [I think this is standard]The picklist shows XX with Qty 5 EA to pick (not 1 BOX)(as Shipline.UOM = BOX but ShipLineSplit.UOM = EA) While this is the correct number of base units, we want the picker to send out an unopened box, not 5 individual products and we get mistakes when a shipper (manual picking) sends out 5 Boxes! QuestionsWe did not and don’t expect to ship less than a box (so never 3 EA) so why is ShipLineSplit populated?  Can I safely update the report t

Hello,Can someone guide me on how to set up a numbering sequence for Business Accounts? Thank you.

We have two separate companies setup and users are assigned to one or the other. Company A is associated with Warehouse A and Company B is associated with Warehouse B and restriction groups further prevent users from seeing the other company warehouse. However, when using the Next List button in Pick, Pack, Ship, the system attempts to assign open Pick Lists regardless of the warehouse. When it tried to assign a Pick List associated with a warehouse the user doesn’t have access to it throws an error: ‘The ###### pick list has been skipped because of an error. See the trace for details.’ There are no errors in the trace log. Essentially the user has to keep hitting next list and triggering an error until they get to a valid Pick List. Has anyone else experienced this issue/know of a resolution?Actual Error on Scanner 

A few years ago, I wrote about Creating Acumatica DAC Extension Tables — a clean alternative to dumping custom fields directly into standard Acumatica tables. If you haven't read that post, the short version is: a DAC Extension Table is a separate SQL table that Acumatica automatically joins to a standard table like SOShipment. Your custom fields live in that extension table, keeping the standard table clean and your customization nicely isolated.That post covered the backend C# side: the DAC definition, the PXTable attribute, and the SQL table structure. What I didn't cover — because it wasn't relevant at the time — is what you need to do on the frontend when your Acumatica instance uses the Modern UI.This article picks up where that one left off and walks through the TypeScript and HTML changes needed to surface extension table fields on a Modern UI page.A Quick Refresher on Modern UI Page StructureModern UI forms are defined in TypeScript and HTML files rather than ASPX. For a given

Can anyone tell me what the formula $AdditionsInPeriod or $DisposalInPeriod in a FA report means? I assume it means the total additions or disposals for the period but I am not familiar with the prefix $.The report I am working on seems fine but the totals do not balance. I am trying to understand the field content so I can correct the totals.Many thanks in advance. 

Hi all,I'd like to clarify some fundamentals about how event handlers work in Acumatica, specifically around naming conventions and method discovery. I have a few basic questions:1. How exactly does Acumatica's framework discover and invoke event handlers under the hood? Is it purely reflection-based at graph initialization, looking for specific naming/signature patterns, or is there more to it?2. Is naming a method in the classic convention (e.g., CustSalesPeople_RowInserting) sufficient on its own for Acumatica to recognize and call it? 3. Would an arbitrary/non-standard name like _RowInserted (as opposed to the generic handler's required bare underscore _) be recognized as a valid event handler by the framework? My understanding is no - it would compile fine as a regular method but never actually be invoked, since it doesn't match either the classic DAC_EventType pattern or the generic _ pattern. Can someone confirm this is correct?I'm trying to nail down the exact rules here since

Our bank offers a product from FIS (a common vendor for the banking industry) called Integrated Payables. We send them a file that contains a line with the recipient’s name, address, and optionally their routing and account number and a list of invoices we are paying.This tool simplifies payments by automatically converting to ACH, mailed paper check, or virtual credit card using the information they keep on file. This is basically an automated version of a consumer “Bill Pay” service that most banks offer.This tool expects to receive data in a CSV-like format, but unfortunately it is not a direct CSV export or NACHA file so I’m struggling on where to start with an export scenario. Additionally, I would like to avoid having a customization developed if there’s any way to do this natively or with an ISV soluition that already exists.There are 3 classifications of lines:Summary field that contains the information about the account we are paying FROM. This is largely static and always at

We added a user defined field "return reason" on SO Invoice, and set it as required for the Credit Memo type, to require users to select a reason for creating the credit memo.There is no problem for manually created credit memos. But when users use the invoice correction function, when releasing the new invoice, the system will automatically create a credit memo to offset the previous incorrect invoice. Since this action runs in the backend, the credit memo cannot be created, which also causes the new correction invoice cannot be released.I have thought of setting a default value for the return reason. But in this case, users will most likely forget to change it to the real value when manually creating credit memos. When we did not set this field as required before, we already found that many users forgot to select it.Is there any good solution for this?

This post is being made as I could not find any resources on here for this error, and this is how I resolved the problem.I was getting “Service could not fulfill request” errors on the home screen of the Mobile Application immediately after upgrading to 26R1.Turning on Request Profiled keyed me into the exception that was being thrown on the server side (shown below).The fix:  My Global Assembly Cache had an older version of Newtonsoft.Json.dll.  I removed that assembly from the GAC, did an IISREST and the error went away.   Method not found: 'Void Newtonsoft.Json.Linq.JToken.WriteTo(Newtonsoft.Json.JsonWriter)'.Stack Trace:at PX.Data.PXFirstChanceExceptionLogger.ProfilerFirstChanceException(Object o, FirstChanceExceptionEventArgs args)at PX.Api.Mobile.Services.Routing.UriMetaConverter.WriteJson(JsonWriter writer, UriMeta value, JsonSerializer serializer)at Newtonsoft.Json.JsonConverter1.WriteJson(JsonWriter writer, Object value, JsonSerializer serializer) at Newtonsoft.Json.Serializ

Hello,We'd like to know if Acumatica offers any rebate functionality that fits the following scenario:We purchase products from certain vendors who offer rebates on specific products when those products are sold to specific customers. These rebates can be either a percentage of cost or a fixed dollar amount, depending on the vendor agreement.The issue we're running into is that Acumatica calculates margin on sales orders using the item's Average Cost, which doesn't reflect these rebates.For example: if a vendor offers a 2% rebate on a product when sold to a particular customer, and that product's average cost is $10, we'd want the cost reflected on the sales order (and resulting transaction) to be $9.80 for that customer, not $10. Our sales price and margin should then be calculated based on that rebate-adjusted cost, not the standard average cost.We're not looking to change the item's actual Average Cost record, we just want to have the order/transaction use the rebate-adjusted cost f

I would like to modify the styles for the popup window on the AR302000 page.however, after multiple attempts, it doesn't seem to be taking effect. Is something wrong? -AR302000--extensions---AR302000_CustomCss.html---AR302000_CustomCss.css--AR302000.html--AR302000.ts AR302000_CustomCss.html:<template>    <require from="./AR302000_CustomCss.css" /></template> AR302000_CustomCss.css:#paymentDialog .qp-resizable {  height: 85vh;}.aabbcc {  height: 72vh;}.top-bar-cont{  background-color: red;}

Hello Acumatica Community,I'm excited to invite a limited number of Acumatica customers to participate in an exclusive Acumatica Customer Program designed to demonstrate how predictive AI decision intelligence can help executive leadership and project teams improve project outcomes.This exclusive program is being offered by TrueProject for Acumatica customers and is proudly sponsored by Acumatica Chief Product Officer Jon Pollock.As a participant, your organization will receive a complimentary 30-day evaluation of TrueProject with no cost, no commitment, and minimal to no IT involvement.During the evaluation, you'll experience how predictive AI can help your organization:Gain an objective, AI-driven assessment of the health and success likelihood of your active projects. Identify project risks weeks earlier than traditional reporting methods, providing more time to take corrective action. Receive practical AI recommendations to improve project outcomes before issues become critical. Pr

Hello Acumatica Community,I'm excited to invite a limited number of Acumatica customers to participate in an exclusive Acumatica Customer Program designed to demonstrate how predictive AI decision intelligence can help executive leadership and project teams improve project outcomes.This exclusive program is being offered by TrueProject for Acumatica customers and is proudly sponsored by Acumatica Chief Product Officer Jon Pollock.As a participant, your organization will receive a complimentary 30-day evaluation of TrueProject with no cost, no commitment, and minimal to no IT involvement.During the evaluation, you'll experience how predictive AI can help your organization:Gain an objective, AI-driven assessment of the health and success likelihood of your active projects. Identify project risks weeks earlier than traditional reporting methods, providing more time to take corrective action. Receive practical AI recommendations to improve project outcomes before issues become critical. Pr

Hi,I’m trying to hide zero values in report through condition but there is a value difference when I run the report.Could you please me to hide values through visbile expression. I tried some condition but it is showing true or false.Please below image and RPX file  

Hi Team,I have one processing screen, using which I am creating customer, then order using the created customer and then payment for the created order in the same process.There is an inconsistent error “The item CustomerID is not found (restricted:False,external:True,value:xyz)” is coming at the time of payment creation. The strange thing here is the Customer is there in the system and Order is also created using the same customer but at the time of payment creation getting this error and that too not the case with all the records. As, for some of the records the flow is working fine from customer creation to order to payment.Can anyone suggest something about the possible cause and resolution of this please. Thanks in advance!

We are attempting to upgrade from 24R2 to the 26R1 release of Acumatica, and one of the changes in this release or the previous one is that the Kit Assembly Component Splits looks to prevent the line from defaulting the location for parts with serial numbers that are user-entered on receipt. public class INComponentLineSplittingExtension : LineSplittingExtension<KitAssemblyEntry, INKitRegister, INComponentTran, INComponentTranSplit>{ protected override void SetUnassignedQty(INComponentTran line, decimal detailsBaseQty, bool allowNegative) { base.SetUnassignedQty(line, detailsBaseQty, allowNegative); UpdateUnassignedLine(line); } protected virtual void UpdateUnassignedLine(INComponentTran line) { if ((line.UnassignedQty ?? 0) == 0 || line.TranType != INTranType.Assembly) return; if (line.LocationID != null line.LocationID = null; if (line.LotSerialNbr != null) line.LotSerialNbr = null; if (li

I’m trying to find a specific data class mentioned in this guide: link, however, I can’t find ARPaymentEntry.LoadOptions. Is this a outdated Item class, or does it go by a different name?

I had a customization project error in our sandbox.Ever since the error occurred, I can’t publish or unpublish anything without getting another error prompt during compilation.[2026-07-09 11:16:04.284] Removing previous Modern UI files[2026-07-09 11:16:14.321] Error while deleting screen info folderHow would I go about fixing this?Acumatica 2025 R2, Build 25.201.0213

<template> <qp-template id="Document_PXLayoutRule1_div0" name="1-1-1" > <qp-fieldset id="Document_CstPXLayoutRule21_fs" wg-container="Document_form" view.bind="Document" slot="A"> <field name="WPickingNbr"></field> <field name="SiteID"></field> <field name="CreateTransfer"></field> <field name="Description"></field> </qp-fieldset> <qp-fieldset id="Document_CstPXLayoutRule22_fs" wg-container="Document_form" view.bind="Document" slot="B"> <field name="ShipDate_Date"></field> <field name="Time"></field> <field name="TransferNbr"> <qp-field control-state.bind="Document.TransferReleased"></qp-field> </field> </qp-fieldset> </qp-template> <qp-tabbar id="Tab"> <qp-tab id="TabDetails" caption="Details"&gt

I have a dozen fields on a form that have cascading PXFormulas to calculate other field values automatically. For example:Base PriceCommission RateCommission Value (PXFormula of [Base Price] times [Commission Rate]House Comm. Split RateHouse Commission (PXFormula of [Base Price] times [House Comm. Split Rate])Everything calculates correctly when the record is saved but Classic UI updates these fields right away.The post below also talks about this but the solution there was to change all of the PXFormulas to  PXDBScalars but I’m not sure that this is appropriate as I’m storing all of these values.Is there something I need to write in the .ts file to trigger the PXFormulas or do I need to make each field use PXFieldState<PXFieldOptions.CommitChanges> and write out all of the formulas in Updated events?

When worked with acumatica old version, clicked button “Update Customization Project” never show the message above. I just raise the question here to clarify the features. Do you guy know it ?