Discussion Forums

Community Search is currently not working. Gainsight Support has been notified. There is no ETA on a fix currently. This post will be updated when more information is available. Apologies for any inconvenience this may cause. 

Acumatica recently forced all companies to use the EZPost shipping integration who were using the native WorldShip and Stamps.com integrations, but this integration is currently down. Any update on what happened and when this will be fixed?None of our sites using this integration can ship right now.  

Hi everyone,I'm working on a PXProjection that joins a parent table with a child table using a LEFT JOIN.The relationship is one-to-many:One parent record can have multiple child records. Some parent records may have no child records at all.The projection itself works as expected, but I'm unsure how the DAC keys should be defined.The child table has a key field that is part of the projection's key. When there is no matching child record because of the LEFT JOIN, that key is NULL. However, a key field in a DAC cannot be null What is the recommended approach for defining keys in this type of projection?Should only the parent table's key fields be marked with IsKey = true? Is there a best practice for projections that include optional child records? How do you handle one-to-many relationships where the child record may not exist?I'd appreciate any guidance or examples. Thanks!

Open the report that you need to modify in the Report Designer (see more about the report designer here https://openuni.acumatica.com/courses/reporting/s150-reporting-report-designer/) Open File → Build Schema… menu and make sure the CCPayLink table is added to the report   Go to Relationships Tab and Left Join CCPayLink to ARInvoice or SOOrder based on PayLinkID   Add new Picture Box control to the report and configure it the following way: VisibleExpr: =[CCPayLink.Url]<>null BarcodeType: QRCode Source: Barcode Value: =[CCPayLink.Url]   Configure the size and position of the barcode. Add a new textbox and configure it the following way:Value “Click Here To Pay!” or any other label Navigate Url: =[CCPayLink.Url] Visible Expr: =[CCPayLink.Url]<>nullSave the report back to the server!Done! You now have a report with a barcode and a link that navigates customer to the pay link!  Troubleshooting:If you’ve configured the code and it still does not show up (or rather show up as

Hello, I am required to assign the owner of the Business Account based on the Sales Territory of the Business Account.  I tried using the Assignment map adding the sales territory as a condition, but it seems not Working.  Is this condition being available within the standard? Thank YouAmanda 

        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

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