Discussion Forums

        public new PXSelectJoin<RQRequisition,        LeftJoinSingleTable<Customer,            On<Customer.bAccountID, Equal<RQRequisition.customerID>>,        LeftJoinSingleTable<Vendor,            On<Vendor.bAccountID, Equal<RQRequisition.vendorID>>>>,        Where2<            Where<Customer.bAccountID, IsNull,                Or<Match<Customer, Current<AccessInfo.userName>>>>,            And2<                Where<Vendor.bAccountID, IsNull,                    Or<Match<Vendor, Current<AccessInfo.userName>>>>,                And<                    Where<                        RQRequisition.status, Equal<RQRequisitionStatus.bidding>,                        Or<RQRequisition.status, Equal<RQRequisitionStatusExt.Revived>,                        Or<RQRequisition.status, Equal<RQRequisitionStatus.closed>,                        Or<RQRequisition.status, Equal<RQR

Hello, we need to help in getting report using API.From screen, when we click on report button, we are executing some logic and then opening up report. So we would like to know how can we achieve this using APIs.

Apologies if this is already covered, I did search and could not find what I am looking for. Our five/six year old MYOB environment has a massive Audit history logs and I can’t find a way to delete on logs based on date and time?  Also, is this recorded for individual Tenants? Can the Audit log cleaning be done via UI or I need some special access to Database?  We have a cloud implementation, is it possible to get access to the database directly?

There is a scenario that I am looking to solve for. Customer puts in CAD shopify order/paid in CAD but I would like that order to get added into Acumatica as a USD order to avoid any currency exchange rounding issues between shopify payout and bank reconcilation.  Any suggestions?

Hello folks,Wanted to see if this was remotely possible.    But i have an import mapping setup that work in the following manner on the SALES ORDER entity in Commerce Connector: As you can see this will look for the “MISC” tag and if it exists it will map the customerID to my “ECOMGUEST” customer.  If FALSE, it maps to the C0000011 customer.  What I would LIKE to occur is that on the FALSE result of the IIF statement that it reverts to actually using the native connectors logic to either use the existing shopify customer or create a new one.  Possible?

Known Issue: The EasyPost platform experienced internet connectivity issues starting early morning 7/23/2026 (first reported 07:57 PDT). Affected all customers using EasyPost's API and related services.Root cause: A connectivity issue at EasyPost's hosting provider affecting network access to their data centers.Resolution: Network connectivity has been fully restored, EasyPost services are operating normally, and system-wide error rates have recovered to normal levels. EasyPost Engineering will continue monitoring for any residual effects.Actions needed: No customer-side action required. We recognize the disruption this has caused and extend our sincere apologies for any inconvenience experienced.

I am setting a P&L that shows month over prior month.  I would like to add a column that shows the amount variance and % variance.  What is the syntax needed in the calculation formula to do the math to subtract one column from another?  

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

All of my Sales Orders in the Details tab show <SPLIT> in the Sched. Shipment Date and are empty when checking Line Details. The Sales Order has a Sched. Shipment date entered in the Shipping tab and the Purchase Order has Promised On date entered. I’m trying to understand why they are always showing <SPLIT> instead of the dates provided?

Hello,I was wondering if anyone knows if there is a resolution for this issue:The following error appears when attempting to create a shipment for an order for which the Sched. Shipment date is greater than the current date.This would be considered a bug to us, as there is no reason you should be prevented from shipping an order earlier than requested.This is a required field that is pre-populated from the SO Requested On field, and results in an additional unnecessary and confusing step of manually altering the scheduled shipment date to the current day before creating the shipment.We are shipping non-stock items, back order allowed, allow negative quantity, but that should not matter.I know this was previously a known issue but we are using 2023 R1 where it was supposedly resolved years ago  TYVM!Kyle

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

in 25R1, what logic is used to archive sales orders?  shipments?  The help doc states that sales orders with a status of complete or canceled will be archived.I ran the archive process on sales orders and shipments.  The majority of the sales orders were archived but I still have sales orders that fall outside of the retention period with the completed status.  The archive process did not archive any of my 20k shipments that fall outside of the retention period.Any insights?

Hi Acumatica Community!I’m releasing Acumatica Knowledge MCP, a free, read-only knowledge server for AI tools that support MCP.It gives AI assistants searchable Acumatica reference context across Help Wiki documentation, DACs and fields, OData entities, Contract-Based REST API entities, and Generic Inquiry XML examples.It does not require an Acumatica tenant connection. It is safe to use because it is read-only and does not write anything back to Acumatica.Setup is simple: add a single MCP URL to any agent or AI tool that supports MCP.Website with connection details and how it works:https://knowledge.acutools.netThis is the first public release, so feedback is very welcome. I’d especially appreciate hearing where the search results are useful, where they miss, and what Acumatica knowledge areas or tools you would like to see added next.I’m also happy to help anyone get it set up or answer questions.  

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