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 get stock items which are checked by custom checkbox using $Filter parameter.
Hi,Need to know how to clear existing error and warning messages in the UI. As per my screen example, I set some exception messages based on the logics inside the Verify Vendor Button event. So, I need to clear the existing validation error once it’s filled correctly. Thanks
I want to add the item class on in the Catalog grid in the portal. I want to add custom filters to the screen.Populating the field with a rowselected or initializing wont work because I need to filter the value. I have try adding the field in a extension file but the field keeps giving back 0 as the value, any idea what I could be doing wrong?namespace SP.Objects.IN{ public class InventoryLinesExt : PXCacheExtension<InventoryLines> { // Here i tried adding a new field to link with the current line inventoryID #region UsrCustomField [PXInt] [PXUIField(DisplayName = "Item Class")] [PXDefault(typeof(Search< InventoryItem.itemClassID, Where<InventoryItem.inventoryID, Equal<Current<InventoryLines.inventoryID>>>>))] public virtual int UsrItemClass { get; set; } public abstract class usrCustomField : PX.Data.BQL.BqlInt.Field<usrCustomField> { } #endregion // her
Im trying to click on a simple command button on the SOOrder screen that sets another bound boolean field on the form. The comman button seems to fire but I cant seem to get the checkbox boolean field to set and update the database? Please help!! PXAction logic after clikcing ASSEMBLE KITS REQUEST (exception gets thrown “Request Sent”) public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<PX.Objects.SO.SOOrder> UsrKitsAssembleReq; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Assemble Kits Request")] public virtual IEnumerable usrKitsAssembleReq(PXAdapter adapter) { SOOrderExt1 soOrderExt = Base.Document.Current.GetExtension<SOOrderExt1>(); Base.Document.Cache.AllowUpdate = true; Base.Transactions.Cache.AllowUpdate = true; soOrderExt.UsrKitsAssembleReq = true; throw new PXException("Reques
How can I turn on File Attachments Drag and Drop functionality on custom Data Entry Documents(Header)?
Hi All, I have created a projected DAC as follows. [Serializable] [PXCacheName("ProjectedSOLines")] [PXProjection( typeof(Select2<SOLine, InnerJoin<SOOrder, On<SOLine.orderType, Equal<SOOrder.orderType>, And<SOLine.orderNbr, Equal<SOOrder.orderNbr>>>>>), Persistent = true)] public partial class ProjectedSOLines : IBqlTable { public abstract class orderNbr : PX.Data.BQL.BqlString.Field<orderNbr> { } [PXDBString(15, IsKey = true, IsUnicode = true, InputMask = ">CCCCCCCCCCCCCCC", BqlField = typeof(SOOrder.orderNbr))] [PXSelector(typeof(SOOrder.orderNbr))] [PXUIField(DisplayName = "Order Nbr.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)] //Other attributes like PXSelector public virtual String OrderNbr { get; set; } #region Status public abstract class status : PX.Data.BQL.BqlString.Field<status> { } [PXDBString(1, IsFixed = true, BqlFiel
Hi everyone,I have been assigned to create a new order type for Purchase Orders screen and do use a custom numbering attribute for a certain type.So when I created a new numbering sequence and the necessary code below, but when I try to select a vendor from the selector I get this error:the code looks like this:for the POSetup’s DAC Extension: for the new numbering Sequence:And for the POOrder Extension: For the POOrderTypeExtension: For the CustomNumberingPOAttribute:So if you guys can possibly point out something that I might have been missing, I would really appreciate it. Looking forward to reviews from the amazing community.
Hello All,If I am not mistaken, Acumatica introduced “IsInSubselect” & “IsNotInSubselect” with FBQL which is the Equivalent of “IN” and “NOT IN” of SQL. When we use these two functions it is translated to SQL correctly but they have a deadly flaw. This flaw impacts the whole result and when you expect to have thousands of records you get NONE. Look at the two below SQL queries (just logic, do not think what a stupid query). Please note I can NOT use Join//#1SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT DefPOAddressID FROM BAccount WHERE DefPOAddressID IS NULL)//#2SELECT * FROM Vendor WHERE BAccountID NOT IN (SELECT ISNULL(DefPOAddressID, 0) FROM BAccount WHERE DefPOAddressID IS NULL) Both queries are instructing SQL to return all vendors which do not have DefPOAddressID but the first query returns none while the second one in my case over 2,000 and this is what I expect to get. The only difference is the ISNULL wrapping. Acumatica translates its queries to the first one so I
I’m trying to update an attribute value on appointments in Postman but the value will not update.Here is my PUT request:{{acuBaseUrl}}/Appointment?$filter=ServiceOrderType eq 'PM' and AppointmentNbr eq 'SV001280-1'&$expand=Attributes&$select=AppointmentNbr,Attributes/Attribute,Attributes/ValueHere is the body:{ "ServiceOrderType": { "value": "PM" }, "AppointmentNbr": { "value": "SV001280-1" }, "Attributes": [ { "AttributeID": {"value": "Is Inspection Complete?"}, "Value": {"value": true} } ]}I’m not sure what else needs to be done. I’ve also tried using the Attribute ID of INSPECTED but it still won’t update. I’m using the Default/22.200.001 endpoint.
As the title states, I am new to Acumatica.Where is the DACs documentation? I can’t find anything about BAccount, BAccount2, etc. In the same DAC extension, can I reference a different field in the selector query? For example, the user selects a customer and then I want to populate another field with that customer’s projects. Is it best practice to put each customization in its own “project”, i.e. I have a customization the SO screen and another for the PO screen. Should all customizations for the same screen be in the same “project”?
Hello everyone,I added the Shipments screen to the mobile app. There are only a few fields that we need in the mobile app. All of the fields show up in the app except Tracking URL. Here is the code: add screen SO302000 { add container "ShipmentSummary" { add field "ShipmentNbr" add field "Status" add field "Customer" add field "Location" add field "ShipmentDate" add field "Description" add field "Packages#BoxID" { special = AllowEdit } add field "Packages#TrackingNumber" add field "Packages#Carrier" add field "Packages#TrackingUrl" add recordAction "Save" { behavior = Save } add recordAction "Cancel" { behavior = Cancel } add recordAction "ConfirmShipmentAction" attachments { } }}Again, all fields show up except Tracking URL. I also tried changing the name to TrackURL and that didn’t work either. Any ideas?
Hi community, I’m trying to find a way to create a user on Acumatica using a Client REST API but I don’t find an endpoint for Users. I had an idea to created a generic inquiry pulling the SM.User table that contains all the user fields and information such as login, password, employee associated to the login credentials, etc. and created an Endpoint in the Web Service to get the information and it works to get the users. But what I’m intending to do is not just get the info, I want to create new users and modify the users information. Is any other way I can do this? Please see one example of the User Generic Inquiry: This is an example of the Web service endpoint that is connected to the Generic Inquiry. Latest, See how the if I use Postman to get the information, it works to pull data, but I want to find the way to push data to create or update. Thanks in advance for all your responses.
My apologies, I thought I solved this issue, but turns out only partially solved. I’ve created a new post with the full details. I would delete this original post, but don’t see how to.
Hello all!I’m looking into limiting the scope of transaction being evaluated by the Prepare Replenishment screen, Screen ID : IN508000. We’re doing this because we often have orders that are entered into the system well in advance, like 6 months or more in advance. This results in us storing product in a warehouse for months until the order comes to be Shipped, not reasonable. We would like the system to only look ahead one week from the current date of the preparation.I’m also learning how to create my own customization projects and think I’ve found the place and figured out the necessary changes, yet to be confirmed… Diving in head first ( note that I’m open to other options here ) I believe I need to extend the Business Logic ( a Graph Extension? ) for PC.Objects.IN.INReplenishmentItemCreate I’ve found two bql statements that I believe need to be modified…the first one from…PXFilteredProcessingJoin<INReplenishmentItem, INReplenishmentFilter, LeftJoin<INItemClass, On<INR
I have create duplicate screen using Purchase Order screen, everything work well but i am not able to change the error messages. How to change ‘Purchase Order instead of my screen name. Thanks,Arun.
Hi Team,In my screen there is a PXSelector control, Once I fill the relevant information and press the Save button or after save Press the Add new record button, that PXSelector values are not refresh. It only changes after manually refresh the web page by browser refresh button.Can someone help me out?UIDAC Field [PXUIField(DisplayName = "Vendor", Required = true)][PXDBInt] [PXSelector(typeof(Search2<BAccount.bAccountID, LeftJoin<HMRCVendorRegisterDetail, On<BAccount.bAccountID, Equal<HMRCVendorRegisterDetail.bAccountID>>>, Where<BAccount.type, Equal<BAccountType.vendorType>,And <HMRCVendorRegisterDetail.bAccountID, IsNull>>>),typeof(BAccount.acctCD),typeof(BAccount.acctName),SubstituteKey = typeof(BAccount.acctCD),DescriptionField = typeof(BAccount.acctName))][PXCheckUnique(typeof(HMRCVendorRegisterDetail.bAccountID))][PXDBDefault(PersistingCheck =PXPersistingCheck.NullOrBlank)]public virtual int? BAccountID { get; set; }public abstrac
I am new to Acumatica customization and have a Graph extension of the Sales order screen. I want to be able to read the latest currency rate when i click a custom action button.public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<SOOrder> addItems; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Add License Items", Enabled = true)] protected virtual IEnumerable AddItems(PXAdapter adapter) { var rowCount = Base.Transactions.Select().Count; var curInfoID = Base.Document.Current.CuryInfoID; var curRate = ????I want to create a variable of currency rate everytime the document currency is change
I’m trying to use the PutFile method (https://help-2020r2.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=591def3d-5fe5-42c1-bb35-cfe5b4c77f6f)I am using version 23.109.0023 and here is my code: public async Task HandleAsync(WebhookContext context, CancellationToken cancellation) { using (var scope = GetAdminScope()) { try { if (context.Request.Method == HttpMethod.Post.Method) { using (var result = new JsonTextReader(context.Request.CreateTextReader())) { if (result.Read()) { JsonSerializer serializer = new JsonSerializer(); ObjectJSON test = serializer.Deserialize<ObjectJSON>(result); var bytes = Convert.FromBase64String(test.Value); StreamContent
Hi i cannot work out what i am missing. I want a warning not a stop message when an AP Bill is created/updated if the Total value is 0. It works but i cannot save the Bill with a zero as the error keeps presenting on save. I have tried Row Inserted but that triggers to early. public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { #region Event Handlers protected void APInvoice_RowPersisted(PXCache cache, PXRowPersistedEventArgs e, PXRowPersisted InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (APInvoice)e.Row; if (row !=null && row.CuryLineTotal == 0) { throw new PXSetPropertyException("The document total is zero", PXErrorLevel.Warning); } }
I have 2 custom fields, Customer and Project, that are required. The second field is a selector that is dependent on the value that is in the first field.Customer Field: [PXDBInt] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [PXUIField(DisplayName = "Customer", Required = true)] [PXSelector(typeof(SearchFor<Customer.bAccountID> .In<SelectFrom<Customer> .InnerJoin<BAccount2> .On<Customer.bAccountID.IsEqual<BAccount2.bAccountID>>>), new Type[] { typeof(Customer.bAccountID), typeof(BAccount2.acctName) }, DescriptionField = typeof(BAccount2.acctName))] public int? UsrMOSCustomerID { get; set; } public abstract class usrMOSCustomerID : BqlInt.Field<usrMOSCustomerID> { }Project Field: [PXDBString] [PXD
Good day, I have a custom field to indicate if a voided payment is type non-sufficient fund, if it is, when I press release in the voided payment, I have to create a debit memo and redirect from the payment and applications screen to the invoice and memos screen. The problem is that if I try to redirect the screen, the voided payment does not release and does not save either, because the RedirectException interrups the process. Do you have any idea how can I make the transition from one screen to another having the voided payment released? invMemo.Actions.PressSave();throw new PXRedirectRequiredException(invMemo, true, "Invoice"); } return Base.release.Press(adapter); public virtual IEnumerable Release(PXAdapter adapter) { ARPayment row = Base.Document.Current; ARRegisterExt rowExt = PXCache<ARRegister>.GetExtension<ARRegisterExt>(row); var invMemo = PXGraph.CreateInstance<ARInvoiceEntry>();
Hi, I have a refresh problem with a container Link.When I open the container (PIPELINE & CRM) the first time, the values are good, if I go to another customer, the container (PIPELINE & CRM) takes over the data from the previous customer. When I add a record to the container the screen updates good. The screen works perffectly in the ERPThanks Xavier… Sorry for my english langage so poor ;) update screen AR303000 { update container "CustomerSummary" { add recordAction "save" update layout "CustomerHeader" { remove field "CustomerSummaryBalance#PrepaymentBalance" remove field "CustomerSummaryBalance#Balance" remove field "CustomerStatus" add field "CustomerSummary#PanierCumulé" add field "CustomerSummary#Sleeping" add field "CustomerSummary#Provenance" {forceIsDisabled = False} } update layout "OtherTab" { displayName = "CRM" add containerLink "PIPELINE" add containerLink "CRM" add container
I would like update the screen AR30300.When I open a customer, The field is disable, in the ERP, we can update the fieldThanks Xavier
@Naveen Boga solved this problem for me before on the SO Lines gridHowever, that was to enable native fields. I’m using the same logic to try to enable two custom fields on the GL entry details, but I am unable to make them editable.I’ve added what I think is the necessary code and changes to the workflow. namespace PX.Objects.GL{ public class JournalEntry_Extension : PXGraphExtension<PX.Objects.GL.JournalEntry> { #region Event Handlers protected void GLTran_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (GLTran)e.Row; if (row != null) { //Allowing caches to update with below code Base.BatchModule.Cache.AllowUpdate = true; Base.GLTranModuleBatNbr.Cache.AllowUpdate = true; GLTranExt glExt = PXCache<GLTran>.GetExtension<GLTranExt>(row); PXUIFieldAttribute.SetEnabled<GLTranExt.usrLoan&
Hello everyone!My apologies but I need your help again...I tried to debug the native code but couldn't run it on Acumatica 23R1. I'm wondering... Could you tell me if I'll need a new setup please?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.