Solved

After working on this for 4 full days, I am crying out for help.  I’ve probably published 100 times.  Since I cannot rebuild the pages using the command line (would be great if you could.  Once published, the command line does nothing.)  My project is HUGE and it takes 3 or so minutes to publish.  3 * 100 is a lot of minutes to wait!I created Popup Panels for two screens.  I am able to get the panels to open, and the custom actions for them are firing.  BUT I cannot find any way to get the fields to show in the panels.The code and panels work perfectly in Classic UI.  Strangely, in order to get the menu options to show on one screen I have to manually add the buttons using the @gridConfig({  topBarItems: { code to do it.  Doing that makes some of the default buttons on the grid disappear, so I would like to not use that approach, but desperate times call for desperate measures.In case you wonder, I am hiding the Add Items button and creating my own so that I can add new functionality.I

Sorry for all the MUI panel questions.  I got panel to open and it does fire the custom action for the panel.I have a simple panel on PO301000.  It opens and allows the user to enter a value in a field.  I enter a value in the field and click OK.  The field in the view is a custom PXFilter DAC.In debug, I get the current of the Filter and the field is always null.   In debug, the value is null: This is the HTML and TS <qp-panel id="ChangeLoanView" caption="Change Loan" auto-repaint="true"> <qp-template id="fvChangeLoanView_div0" name="1" qp-collapsible=""> <qp-fieldset id="fsChangeLoanView_lrChangeLoanView_fs" slot="A" view.bind="ChangeLoanView" wg-container="ChangeLoanView_fvChangeLoanViewFields"> <field name="UsrLoan"></field> </qp-fieldset> </qp-template> <footer> <

I work in a furniture business and looking at ways to reduce manual entry of Sales Orders. We have many small sized customers who do not have advance tech ability and often send their order either as a PDF attachment or in the body of an Email.  They are not too interested in EDI.  I’m looking for a system can read these PDF/emails as they are the same format each time and automatically import and create a SO.  Currently only found Artsyl but I’d like to review a few.Does anyone use a system like this already?  I am very interested in you experiences and suggestions.Thanks

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!

Wonder if anyone has started looking into the new Materials Management feature in the Construction edition and if so, any thoughts/feedback on it?It looks like it shows promise but we aren’t going to be using this in a typical construction scenario since we are focused on Custom Engineering projects and simpler/smaller types of transactions where we aren’t using hundreds of materials. Thank you.NOTE for Acumatica, please add a Tag for “Material Management” for posts.

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.

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?

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?

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

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

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 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?

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?

Hi All,Is there an option for us to merge customer cards?Lets say we accidentally created aduplicate card for the same customer and there are  already SOs created for them, is it possible to combine it with an existing customer card?

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

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 

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?

Does anyone know of a way to generate production tickets from MRP for the total quantities that are in demand for an item.  Currently it is showing the same item multiple times and if you generate tickets it will create one by one instead of a sum of the quantity.  If we manually sum the qty and create a work order for that quantity, mrp still shows the demand one by one until it’s complete.  Quite cumbersome to keep on track.  Any suggestions?