Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
how to fetch field values from tables for acu loan
Hello all,I was wondering does Acumatica have any function that can be used in its DAC properties settings to dynamically return the index of a Character in String something like IndexOf or LastIndexOf?For example typeof(Substring<DAC.Field, Zero, IndexOfChar>) I can have it in get/set but I need it in the properties.
Apologies this is a long one.Customizations added:Custom field added via ARTranExt for field “SomeField” of type string Custom field added via ARRegisterExt for field “SomeFieldChanged” of type boolean Custom action “EnableSomeField” added on the Action menuWhat I’m trying to achieve:When a user opens an existing invoice, ARTranExt.SomeField must not be editable When the user clicks the EnableSomeField action, only SomeField must become editable. I set a property calleld “editMode” to true When the user selects an ARTran row, in Event.RowSelected<ARTran>, I check if editMode is true, and if yes, enable ARTranExt.SomeField In Events.RowUpdated<ARTran>, I check if currentRow.SomeField == oldRow.SomeField, and if not, I set ARRegisterExt.SomeFieldChanged to trueThe code:public class ARInvoiceEntry_Extension : PXGraphExtension<ARInvoiceEntry> { private bool editMode = false; public override void Initialize() { base.Initialize();
Hi, I am completely new to Acumatica. My company is looking at integrating its shipping solution with Acumatica. I am currently researching Acumatica and the process, web service endpoints, form customization, etc., but I am struggling with the concept and steps to follow if you’d like to develop a solution for the Acumatica marketplace.How does this process work?Note: I already setup a local development environment that is fully functioning.Thank you in advance.
Hi,I have created a new custom field called LineCtr (Line Counter) to the PMTask DAC, and I want the value that a user enters in this field to appear in the LineCntr field that is in the PMRevenueBudget column called LineCntr (Line Counter).In the Projects screen, the custom field I have created is in the Tasks tab, and the field I want to update is in the Revenue Budget tab. Below is an example of how the custom field would be used. And this is the Revenue Budget tab: In the Revenue Budget tab, the Project Task is added via a selector. Currently, my custom field is displayed as a column in the selector so that the user can be sure what number they are going to be adding to the LineCntr column. As shown below, this is how the selector will look: What I would like to happen is, when a user selects a row from this selector, the LineCtr column that is shown in the selector above should be added to the LineCntr column that can be seen in the Revenue Budget tab.What I am having trouble fi
HI, When I try to add a SOLine Item having a Non-Inventored item through customization. I am getting Error: Trandate cannot be emptyWhile debugging the code Trandate has value in the SOLine row. What may be the reason for this issue? at PX.Data.PXDBDefaultAttribute.RowPersisting(PXCache sender, PXRowPersistingEventArgs e) at PX.Data.PXCache.OnRowPersisting(Object item, PXDBOperation operation) at PX.Data.PXCache`1.PersistUpdated(Object row, Boolean bypassInterceptor) at PX.Data.PXCache`1.Persist(PXDBOperation operation) at PX.Data.PXGraph.Persist(Type cacheType, PXDBOperation operation) at PX.Data.PXGraph.Persist() at PX.Objects.SO.SOOrderEntry.PersistImpl() at PX.Objects.SO.SOOrderEntry.Persist() at PX.Objects.Extensions.ProcessAffectedEntitiesInPrimaryGraphBase`4.Persist(Action basePersist) at PX.Objects.Extensions.ProcessAffectedEntitiesInPrimaryGraphBase`4.Persist(Action basePersist) at PX.Objects.Extensions.PaymentProfile.PaymentProfileGraph`2.Persist(Action
Does Acumatica have a generic table that contains:A Key - a String A Value - also a String, with an expanded value for the key, to be used in any way that is appropriate A value type - optional, identifies the value has a format of String, Decimal, Date, etcI would add custom entries to this table, as an alternative to creating a new table to store simple values that can be retrieved based on a user-defined key.Thank you,Randy
Hay guys, I had a great shipping API customisation which was working, however it stopped working. I went to debug and this method of accessing the packages doesn’t work anymore. Any advice? PXResult<SOPackageDetailEx> pack = Base.Packages.Select(); When I query pack I get zero pack’s even though I can see them in the database. So I tried the below: SOShipmentEntry shipGraph = Base as SOShipmentEntry;var pack = PXSelect<SOPackageDetailEx, Where<SOPackageDetailEx.shipmentNbr, Equal<Current<SOShipment.shipmentNbr>>>>.Select(shipGraph); I am still getting zero packs returned from pack.Please help, I don’t know how to code this any other way.
How can we add a screen for example FS300300 Calendar Board to the mobile App. This does not have a normal form tab or grid in its view. But it contains a different UI. Is it possible to add mobile screens for such screens ?
Dear Team,Is it possible to prevent update of Notes and files if the transaction is in released status.
Long story short: I’ve created a graph extension of the CustomerMaint graph. The extension adds a button to the attributes tab that instantiates a custom graph which changes the value of one of the attributes. Upon completion, I want the attributes grid to refresh and show the updated value, however I’ve tried…Base.Answers.View.RequestRefresh();and Base.Answers.View.Clear();Base.Answers.View.RequestRefresh();… but the grid will not refresh.The logic successfully changes the value and clicking the refresh button on the grid shows me exactly what I want, but I don’t know how to call that Refresh in the code or trigger it in the ASPX. Any Ideas?
Hi,I’m new for the acumetica developments. We need to develop new screen same as the sales order screen.We install the acumetica ERP.Can u suggest what I do for the next.We have confusion about how to start development.Looking for your answers.Thanks
Hi everyone,Need to set a default warehouse for specific types of order in the form below.Kindly assist
Customers of Field Service need to be able to schedule estimate/measurement appointments and provide their prospects with a quote. To accomplish this, and minimize the errors and clicks, I have added an action to the appointment screen to create an opportunity. It works perfectly in the UI and I can field update the opportunity with the customer id, contact info and a UDF to be populated with the service order nbr for linkage. My main issue is that it is not redirecting in the mobile app and I am out of ideas on how to make this work. I am not a developer but am very dangerous in no code workflow/customizations.I have tried several combinations of various parameters and window modes. When I click on the action in mobile it looks very much like it would like to redirect to Opp screen but it never does. Help?? :-) Just for fun I tried adding these to no avail. What’s weird is that when I looked at the XML I expected to see a line referring to the action NEWOPP since it is showing
hello Linkies,I had developed a UI of a new tab for the stock items screen in one of my instances, where it had been working fine. But not after publishing it successfully in other instance it is throwing the below mentioned error: Please let me know why is this issue getting triggered and how to resolve this.
Hello!I’m developing a custom form with an action that inserts an SOOrder.But the data is not in base currency. So I need that the SOOrder screen calculates the corresponding currency rate according to date, customer, currency rate type as normally does when an user captures a sale.But when I insert through code the SOOrder, the currency rate is always 1.00.How to insert the currencyInfo in a new SOOrder when created from code?
I am trying to create unit tests for a graph extension that I’ve developed for ARInvoiceEntry. The business logic depends on the cash account used. So we query the database for the cash account to get all the fields of the CashAccount DAC and its DAC extension. Then depending on the values of the field in CashAccount, the logic will set values in ARRegister. I am stuck on how to set up the ARInvoiceEntry graph to start unit testing the logic. I assume that because unit tests don’t use the database, we cannot test logic which use BQL queries or logic which access the database such as [DAC].PK.Find(). Is this the case or am I wrong? Is there a way to either:1. Create unit tests for logic which query the database.2. Create code which is unit testable (Maybe best practices would be to always check the cache? So code would be unit-testable as long as we know how to fill the cache.)Thanks for the help, it is greatly appreciated.
Hi Everyone,I have a request here to add the print button,scenario - If i have the below appointment list then print button should be enabled. If not then print button should be disabled. I want to insert the print button here, kindly pour your inputs and suggestions here.
Hello Everyone, Hi @aaghaei I want to add a custom field in Customer Location screen(AR303020) as below so i added as preferred Techand the data should picked from Customer screen(AR303000), attribute TAB.The newly added column Preferred Tech (either as Text or Dropdown) should hold the data of AttributeID field(with Value if its contain).Kindly advise how to proceed further.
Hello Everyone,I have an Extension that I would like to Activate based on the Value from the FeaturesSet. I have added a DAC Ext to the FeaturesSet “HCLSMFeaturesSet.usrHCLEnhancedApproval” but when I try to get its value whether or not it is true always returns false even when I know for sure it is true (I checked both DB and Enable Feature screen). Any thought why?public class HCLAPInvoiceEntry : PXGraphExtension<APInvoiceEntry>{ public static bool IsActive() { //Either return PXAccess.FeatureInstalled<HCLSMFeaturesSet.usrHCLEnhancedApproval>(); //Or return PXAccess.FeatureInstalled(typeof(HCLSMFeaturesSet.usrHCLEnhancedApproval).Name); }}
BackgroundWe hoped to upgrade from 2021 R1 to 2021 R2 last year, but other projects pushed the upgrade back when we ran into upgrade issues on the workflow. However, I did preliminary work on the upgrade to get complete the development for testing with very little difficulty on the code side. Since we ran into trouble with our UI based customization project for the new workflow engine, we focused on reworking our workflows to be coded in Visual Studio and never made it to the rollout of 2021 R2. (This is important to know as it means the problem did not exist in upgrading from 2021 R1 to R2.)Getting an ErrorThe time has come for us to upgrade to 2022 R1 (22.102.0054), and I ran into a rather peculiar problem. While we do not use Payroll in Acumatica, I kept getting errors preventing publishing my customization project due to a problem with Payroll.By going into the customization project and selecting Show Active Extensions on the Extension Library menu, the errors (or something ver
Hello all,I need to check in a graph an Action Name exist so I loop through the actions but I am unable to get the Action name. Can someone help me out here?for (int actionID = 0; actionID < Base.Actions.Count; actionID++){ string actionName = Base.Actions[actionID].ToString(); if (actionName == "MyButton") { //Do Stuff }}
Hi all,I want to show up a message when shipment(SO302000) loaded. Which event should I use? All events fired by some actions. I can’t find any like document loaded event.
Hi,I have to get Account Id ,Transaction Description from APTran Table and adjusted amount from ApAdjust Table for my Payment Voucher Report.I need to join ApPayment Table , APAdjust Table and ApTran Table.1st I joined ApPayment Table(column - RefNbr) and ApAdjust Table(column-AdjgRefNbr) below like that. Then I joined ApAdjust Table(column - AdjdRefNbr) and ApTran (column-RefNbr)Table below like that.But,After adding 2nd join report designer show below error. If we remove the second join error is gone. Can you give the solution for this issue.Thanks
BackgroundRecently I was trying to do an export on Sales Orders that excluded all Detail Inventory lines that have the Type “Non-Stock”. I attempted many times to get this simple code below to work.Each time failed, but I noticed the Type field was not included in the Details line on Sales Orders. So, I tested it on a field that was already in the details section, Warehouse.After doing this export I noticed all the records I wanted excluded were gone. My assumption is the Type field needs to be included in the Details line on Sales Order to have it be excluded from the export. So, I attempted to add the Type field to the existing Details section through the Project Editor. Here’s where my issue comes up. ProblemI have no idea how to add an already existing field from another location onto the Tab > Details > Grid: Transactions page for Sales Orders. I have attempted adding the field via the SO301000 > Fields tab, however, it comes back with an error stating the data does not h
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.