Discussion Forums

I didn’t see a place to post the little gotchas that can turn into time eating development cycles so I thought I’d start it.Today I had an issue with a screen that needed severe orthodontic work.It was supposed to look like this:As it turns out, the issue was an “empty” qp-fieldset that I was having an issue with. When I removed the comment tags, the screen rendered properly instead of every following field from being placed into that “empty” fieldset. <qp-template id="formTPCommissionsSetup" name="17-17-14"> <div id="colSetTPCommSetupA" slot="A"> <qp-fieldset id="fldSetTPCommSetupA" view.bind="CurrentDocument"> <!-- <field name="CurrentDocument.SalesPersonID_description"></field> --> </qp-fieldset> </div> <div id="colSetTPCommSetupB" slot="B"> <qp-fieldset id="fldSetTPCommSetupB" view.bind="CurrentDocument"> <field name="CurrentDocument.UsrTPCommRateClass"></field> </qp-fieldset> &l

We have a client who is live on BigCommerce and wants to import their existing stock item catalog into Acumatica first to get Stock items set up and the External ID links established, then switch the sync direction to Export with Acumatica as the master going forward. Has anyone done this before? What's the recommended way to manage this? can we map item class using a custom field from BC to Acumatica to match it to the correct item class using import mapping? And once you flip to Export, does the connector pick up the existing External ID links and update the BC products cleanly without creating duplicates? 

Does anyone know if this functionality has been improved?This is an operational situation we see, both planned an unplanned, where we want to be able to link demand from an existing Service Order to an existing Purchase Order.This is in order to account for changes/mistakes after the original purchase order was created from the demand and also we need to be able to take advantage of purchase requirements for vendors such as minimum order qty, total order amount, free shipping, etc.Our purchasing is not centralized and many people do their own purchasing as needed.There should be a way to link to demand from transactions that haven’t been purchased yet to existing purchase orders.One way would be to identify an Existing Purchase Order on the Create Purchase Orders screen before the processing happens.Another option is to have the ability to set the PO Detail Line Line Type to Goods for SO or Goods for FS and be able to lookup and set the Sales Order or Service Order detail line.Another

So far, here are the ones supported. There could be more. Would request the community to update this list.Authorize.net (native) APS PayPal PayFlow Braintree WorldPay eBiz AcuCharge (Vantage Card) PayPal Request for Money (not a payment gateway, but a way to send email to customer and get money via their PayPal account) === Administrator Note, added July 22, 2026 ===Acumatica Payments is the focus of Acumatica internal development. This was launched in 2023 R2 and works in the USA and Canada. There is also an option for UK customers to utilize Stripe.

We have a requirement to restrict the release of SOs and Invoices linked to a Project: Current behavior: The system allows releasing SOs/Invoices even if the customer is different from the Project's customer. Our requirement: We want to block the release if the customer on the SO/Invoice does not match the Project's customer. The system should only allow releasing when the document customer is the same as the Project customer. Is there a way or setup to apply this rule to our system?

I’m trying to customize a grid with dynamic columns, the number of columns are based on how many items it has on Attributes screen (CS205000). Here are the samples, Sample 1 Sample 2 I have the code in EntryMatrix_RowSelected event which will try to hide a column(s) based on certain condition I tried using this code, but it didn’t work,PXUIFieldAttribute.SetVisibility(sender, "Extra Small", PXUIVisibility.Invisible);PXUIFieldAttribute.SetVisible(sender, "Extra Small", false); I can’t also use this since it has no direct DAC attribute,PXUIFieldAttribute.SetVisibility<DAC.attribute>(sender, null, PXUIVisibility.Invisible);PXUIFieldAttribute.SetVisible<DAC.attribute>(sender, null, false); Is there other way to hide column(s) maybe by name or index?

I have a lot of customers who choose a different payroll provider because Acumatica does not have an HR module, is there any plan to add one in the near future.  

Hello:We’re looking at the feasibility of converting to modern UI in production when it leaves the Beta.I’ve ran into several interesting things, but one that feels concerning in the long run.  It is common in our custom code to have DAC’s with properties decorated as the following example: [PXFormula(typeof(Selector<MyCustomClass.vendorID, Vendor.acctName>))]In classic UI, these formulas are calculated correctly as soon as the DAC is exantlated (as expected?).However, in modern UI, the above PXFormula is never calculated (verified with a break point put on an explicit setter).  This was a bit of a surprise as we were tending to approach the UI as being two different display layers - ‘views’ - built on top of the underlying model and controller.  Is this a bug?​​​​ If not a bug is the construction we are using deprecated or invalid and only working unintentionally? is there a property in the PXFormula that would make this work? If not can you suggest an alternative approach?We se

​Hello everyone,I’m having the following problem: I’m trying to convert a Classic UI screen into Modern UI and 3 of the buttons are not getting hidden for some reason but there’s a try that my colleague tried doing a while ago and the buttons are working as expected there but I’m unable to recreate them for some reason using the automatically converted screen into Modern UI. The buttons I’m having that issue are “Confirm, Generate and Change Order” also another thing I noticed is that we cant reuse the Transactions variable because if we do, the Subcontracts grid is not being automatically loaded on page refresh or load.The version of Acumatica I’m working with is 2025 R2. Here’s the automatically generated source code: I’ll have to paste the source code into pastebin since the source code is a bit too long and the post cannot be createdthe HTML filethe TS file that contains the viewinfoand the actual views TS file now the files from my colleague:The HTML filethe TS file Now the C# cod

We are having an issue attempting to partially ship an SO line linked to a partially completed production order.  Work order/SO quantity is 100, we have 50 complete.  Selecting the SO line shows 50 on hand/ available / available for shipping, but none allocated.  Line details shows the below, which looks strange from what I recall in the past.  This hasn’t been an issue in the past but we recently upgraded to 25.201.0213.2 and this isn’t something we do often so wondering if it is a bug or some obscure setting that now needs to be changed.  Any guidance would be appreciated.  Thanks,Dan

I got a couple issues with the Shopify Connector, specifically the customer location sync.At random it will create more than one location for the customer in Acumatica.  It will activate one and deactivate the other.  Since upgrading to 2025R2 we have every day one or two orders where it will fail to import due to "property set method not found". What we found is that it means that the location is not active. When you go to it in Acumatica, you cannot activate it either. You need to create an additional location, make that the default, then you can go back to the other location and activate it.  In addition I found today that when I look at audit history for any customer, it will show me a bunch of location changes for different customers, different random locations. I don't know what these mean and why they're showing up on another customer that's not even connected to our Shopify store.   

Hi, In GST Pending Recognition report below, there is an Unrecognized Tax Total. This is a standard report in Acumatica.How do I get the 2 headers  (Taxable Amt and Tax Amt) total just like how Unrecognized Tax Total is? Based on the screenshot below, it totals per Tax ID (i.e., G1SALESINCGST).I’ve tried using formulas such as =Sum(Max([SVATConversionHistExt.TaxAmt])) but that doesn’t work. It gives me wrong totals. I’ve tried variables too - doesn’t work either.  

Hello,We are getting an error when trying to approve clock entries, :The clock entry cannot be approved because a labor transaction with the NNN number has already been created for this clock entry.These clock entries are time applied to production orders.I thought that clock entries didn’t go into a batch until they were approved. Is that correct?How can I get past this error?

Hi, I am trying to import AP bills. The AP Bills are tied to a PO Receipt. As well as the vendor, I have the PO number & PO Receipt Line number. I am having an issue with trying to select the Add PO Receipt Line in the Scenario. The Document is being created but nothing else is happening.(If in migration mode, you cannot use the Add PO Receipt button) Does anyone have any solutions/ideas for getting this to work?Thank you in advance!Bill 

Hello everyone! Acumatica Project&Construction team is planning to implement a new functionality - Prepayment for projects. I saw it was discussed and requested on the community several times:Prepayments to show on a project | CommunityConstruction Customer Prepayment | Community Could you please share with me how do you need to recognize the taxes for AR deposit on project? and when do you need recognize taxes? What is your setup for taxes for deposit on project? Could you please describe your business case when you need deposit on project? How do you request deposit for project? How do you process deposit got for project?  What is important for you when you work with prepayments on project?Thank you in advance for your answers!Have a good day!

Below is the import scenario I am trying to use to get our fixed assets into Acumatica.  When I run the import by scenario, it shows that the records processed, but nothing appears in the fixed assets form. 

In my case, I’m customizing SO301000 and enabling the import button on the Detail grid with the following:@gridConfig({ actionsConfig: { import: {hidden: false}, }})But, this seems to replace the settings that the base screen is using including: syncPosition: trueHow to I merge my configuration instead of replacing the existing gridConfig settings?

25R2 Manufacturers: If you have any non-base UOM Materials called out in In Process Production Orders, take a look at Inventory Allocation Details.  You may find that the system is not recognizing that demand, potentially causing Inventory Planning errors.Any manufacturers out there experiencing this?Development acknowledged it as a bug, but we’re the lone reporters at this point: AC-377609.

I'm looking for a way to manage a tenant's configuration as code — declarative files in a git repo I can review in a pull request, version, and re-apply to rebuild a tenant reproducibly.By "configuration" I mean setup data, not customization code: enabled features, company/branch structure, chart of accounts, ledgers, GL preferences, currencies, credit terms, financial calendars, and the like.The workflow I want is basically infrastructure-as-code — capture a tenant's setup into source files, edit them in git, apply to another tenant, then diff to catch drift.Customization Projects cover code but not this setup data. Snapshots are reproducible but are whole-database blobs — not human-readable or diffable in a PR. The REST API can push data, but it's a building block, not a desired-state workflow.Is there an existing tool or established pattern for this — a community tool, an ISV product, or something people have built in-house? Curious how others handle it.Thanks!

Hello,I am currently working on the integration between Acumatica and Microsoft Teams, and I would like to know how to configure a Business Event to automatically mention a specific user or group in Teams. The goal is for the notification to appear in a Teams channel with the the specific user or groups being tagged (e.g., @username), for example the new owner of a Ticket.Is there a way to set this up using the native Teams integration in Acumatica? If so, could you provide the steps or any relevant examples?Thank you for your help!

My FA team report the different about sub account of Credit Memo and Oriinal Invoice.they using Invoice Correction to generate that Memo. i have  try to identify, and i found that subaccount for the Memo same with  SO Subaccount  for the Original invoice.Is there any configuration that needs to be done so that the Credit memo subaccount is the same as the Original Invoice subaccount? thanks for helping me.

Please confirm - when using a Trigger by Schedule you can NOT select screen by shared filter as you can By Record Change ???   

I’m trying to programatically created Sales Shipments: given a despatch message from the third-party warehouse, I locate the sales order and then use CreateShipmentIssue to construct the shipment.This works fine when I run the action as a user. But fails every time when running as a Process via the automation scheduler.My code simplifies to:orderGraph.Clear();orderGraph.Document.Current = PXSelect<SOOrder,Where<SOOrder.orderNbr,Equal<Required<SOOrder.orderNbr>>>>.Select(orderGraph, orderNbr);PXAdapter adapter = new PXAdapter(PXView.Dummy.For<SOOrder>(orderGraph)) { AllowRedirect = false, MassProcess = false };var orders = orderGraph.CreateShipmentIssue(adapter, receivedItem.ShippedDate, siteID, DateTime.UtcNow);The error is:PX.Data.PXRowPersistingException: Error: 'CuryID' cannot be empty.   at PX.Data.PXDefaultAttribute.RowPersisting(PXCache sender, PXRowPersistingEventArgs e)   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.&

hello,I am using Resource owner password flow to get Acumatica token.I am encountering an intermittent issue across all environments, including Production.When we receive an application for processing, we call the Acumatica Get Customer endpoint using a valid authentication token. Occasionally (approximately once a day or every other day), the request fails because the response cannot be deserialized. Our application expects a JSON response, but instead receives an HTML page, as shown below. We cache the authentication token and validate it each time it is retrieved from the cache. Token validation is based on the Date header returned in the token generation response to ensure the token has not expired. Could you help us determine why the API is intermittently returning HTML instead of the expected JSON response, despite the token being valid?Tokens:return html response : LqGoqJP-MvG2Q44kKI_QEq0PqziBlrWXnInucaZS9w0return Json (Valid): IPLN2zlT8ui3GzGoySRC2M5nyz0Xa-StJ3cup25MAncif (resp

Hi,I’m getting an error on my import scenario to import purchase orders. It will import the first order but then I get the error ‘The system failed to commit the transaction row. Any help would be greatly appreciated