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

This appears to be a bug unless someone can help explain what is happening (and possibly how to avoid) I am attempting to add a 2nd UOM for a group of items purchased from our default vendor. Typically we might buy an item in a 100 unit case but the default vendor offers the same item in a 200 unit case as well.  When I add the new UOM on the Vendors tab of the Stock Item and click save, the new UOM will be listed with the original one and only the old UOM will have the Default (for Vendor IsDefault) checkbox checked. However, if you refresh the page you will discover that neither row has the default checkbox selected!The item no longer has a default vendor?! How? and why?  If you try to add the new UOM from Vendor Inventory (PO201000), you get an error “An attempt was made to add a duplicate entry.” even though that page is capable of displaying and editing multiple entries Is there an easier way to load this data without removing default vendors from our items? 

Hi,One user experienced a popup error stating “PXSerialChart is not defined” in the system. This issue is intermittent and occurs inconsistently in different forms. However, once the user clicks OK, the error disappears and the screen continues to work normally. What could be the reason for this? Thanks! 

The only way I can get the changes to the MUI screen is to modify the files in the development section in VS, then update the MUI files in the project editor and publish the project.I thought I could update the MUI screen by executing this statement in Terminal, but it doesn’t make the changes:If this worked, it would save me hours in testing.  Publishing the entire project takes forever compared to running the command line to build the screen.Also, my popup wasn’t showing the fields.  I published, restarted the app, reset caches, MANY times.  I kept changing the TS and HTML, but the fields were not showing.  Suddenly, they are showing.  I literally spent 5 hours trying things, republishing resetting everything and it didn’t show the fields.  Is there some steps I am not taking after publishing the project to get the MUI code to display properly?  I’ve been losing my mind over this.    

Hello,When purchasing a permanent sandbox from Acumatica, will it be fine if the storage is less than production? I would think yes because that is the case for the free upgrade sandbox. Adding sandbox storage to match production adds significant cost and takes us out of our price range. Thanks!

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.  

I’m creating an Import Scenario for the Purchase Request screen (PO.30.20.00).I’m having difficulty adding an individual PO line (other than the first PO line) using the ADD PO LINE button (found under the DETAILS tab).  It seems like the 2nd line never gets properly selected thus, by default, the first line remains selected.How do I add a PO line other than the first one?Here is are my steps (in two screenshots):  

Hi! Has anyone implemented vendor consignment before? I’m trying to setup a vendor consignment warehouse at $0 because we don’t want there to be a financial impact until the inventory is used. I’ve looked at Doug’s article below but was wondering whether this can be done without having to setup a different branch/company. Any ideas?https://www.acumatica.com/blog/how-to-implement-consigned-inventory-part-2/

Trying to re-publish customisation as I am missing endpoint in copied Tenants.  Was hoping the missing endpoints will get created during the republish of customisation.  I am getting the following error.  Any idea what access level I need for my user. 

HelloMy client has 2 DH running, same server, 2 different users. Each DH connects to one URL- they have 2 nodesBoth DH connect with same user name to same Tenant.This works just fine, except that when we update printer drivers, restart server and for other unknown reasons, both DH loses the printer’s size configuration causing a major disaster in 8 locations that work 24hrs. a day.We have managed to download the printer file configuration and when this happens, we load it again, but we need to know if this is a known issue or if we can get someone from DH support to help. We are getting calls in the middle of the night because DH loses this.This is the setup we have for both DH:    This is where we have the issue-DH Printers tab:  they have 63 printers and when the Paper Size that was saved before disappears, we have to go into both DH and fix each and everyone of them.This not only causes chaos among all users in all 8 locations, while we fix this, the DH is stopped and no one can pri

We are trying to find a solution to alert users that we have shelf-life inventory that is nearing expiration date. Is anyone using the MAX SHELF LIFE field on the Stock Item under the Inventory Planning tab? If so, how does it work? If there are other processes that people are using, I’d love to hear them. We want to be more proactive with identifying product nearing it life span.  Thanks! 

When performing a mass multi‑level cost roll, Acumatica doesn't recalculate bill levels for manufactured items from other branches or update their costs in the receiving branch’s assembly. It simply uses the existing standard cost.As a workaround, the mass cost roll process must be run twice. The first run does not pull the most recent standard cost from the sending branch, resulting in an inaccurate assembly cost in the receiving branch. The second run then captures the correct sending‑branch cost and updates the assembly cost appropriately.Can the cost roll process be corrected instead of repeating the mass cost roll process?

Hello all,How can we record loan (liability) against a project in acumatica? So the project will first start with construction which will be funded from loan - as a liability and not income. Then once the project is about to be closed, it is open to be sold out - so the interested prospect pays the deposit for the project which is also a liability and when the prospect signs off the deal, he’s converted to the customer and then the invoice is generated for that project.How can we handle the same in Acumatica? Since its project with 2 accounts - Loan & customer.

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.&

Publishing works correctly on the Customization Projects List page,but an error occurs on the Customization Project Detail page. 

I’m trying to ship a sales order via the REST API.  This involves…Creating the shipment record Updating the quantities on the shipment Confirming the shipment Updating INThe actual quantity to ship comes from our internal custom WMS site, outside of and integrated with Acumatica.  Typically, the SO line item will have a linked Production Order.  When recording multiple Move transaction on the Prod order, the resulting Shipment will have multiple lines for the same item.  We rarely ever ship exact.  Depending on how production was recorded whether we had some extra pieces in stock already, the actual quantity to ship will frequently be different than the quantity ordered or allocated or produced.Admittedly, I don’t fully understand how the “allocated” calculations fit into all of this, or how they are determined based on quantity ordered and production quantities.  No matter what I try via the API, I run into the error of “quantity shipped is greater than the quantity allocated” when tr

We use Sales Order (SO) Invoices for all our Field Service invoices.  Our SO Invoice has its own report design, which is different from that of an AR Invoice.  The invoices for Service Contracts ONLY use the AR Invoice report. Because we have several companies, we cannot modify the AR Invoice report to meet our service company’s specific needs.  I have submitted a case to Acumatica.  We are told that Service Contracts only use AR Invoices.  To use the Sales Order Invoice, a customization is needed.  This makes no sense to us.  We should be able to use our SO Invoices to bill a Service Contract.  We believe this should be an out-of-the-box feature.Does anyone have recommendations for using the SO Invoice for Service Contract Billing?

I have setup an approval process for PPV (purchase price variance) in AP Bills.  I’m testing this and no Approval record is getting created: And the Bill is as follows: No approval has been created even though there is a 500 PPV.  Am I missing something?

Hello Team,I currently have an Import Scenario that imports Opportunities successfully.The Opportunity is created correctly with the relevant contact information, and the Business Account is also created through the same Import Scenario. However, I am unable to map the Business Account Name correctly.Has anyone created a similar Import Scenario where an Opportunity, Contact, and Business Account are created together using the same import process?I would appreciate it if you could share a sample Import Scenario or provide guidance on how the Business Account Name should be mapped. Regards

Hello all,How can I generate MRP consolidated out of all demands under a single row?

Looking for AP automation in Acumatica:Automatically capture vendor invoices from email/PDF Auto-match invoices send by vendor to POs/bills in Acumatica system Only flag for manual review if price variance exceeds tolerance Auto-send payment batches to bank after matchingWe only need the above core functions—no extra or complicated features required.We’re wondering:Is there a native Acumatica solution for this, or recommended third-party integrations? Our biggest challenge: some of our item IDs are different from vendor item IDs (only descriptions are similar). How does AP automation handle matching the correct line items in this case?Any advice or experience would be appreciated. Thanks

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?

I am developing a GI where I need to change pricing of items on sales orders based on customer price classes. For example: If a customer has a customer price class of CUSTOMER, I need to reference the price of an item associated with COMPCUSTOMER. COMPCUSTOMER will never be a customer price class that we actually designated to a customer, but it’s more of a reference.  I’ve been trying to create a reference GI for my main GI to use but because you can’t use formula fields as relation link I’m a little stuck. 

Hello all,The Completed qty is still 0 even after releasing Move transaction:  

Client has different companies in their tenant.  They would like when downloading the financial reports (balance sheet, Income Statement, etc.)  it exports the file name as Balance Sheet - <Company ID> - 01.31.2026.pdf (the financial period pulled through on the selection page.  Right now it downloads as Balance Sheet (2026-03-19).pdf which is the day the report was ran even though they only pulled as of January 31, 2026.Is there a way to change this?  I know we can change via Report Designer for non ARM reports.