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 do I unpublish all customizations via Postman? I am a newb to the Postman platform (just installed it), but I have broken my instance, all screens come up blank, and need to unpublish via Postman if possible. If someone could send me a screenshot/walkthrough of what I’m needing, I’d be super appreciative!
[PXDBInt] [PXRestrictor(typeof(Where<InventoryItem.itemType, Equal<INItemTypes.nonStockItem>>), "Non-Stock Only")] [PXSelector(typeof(Search<InventoryItem.inventoryID>),typeof(InventoryItem.inventoryCD),SubstituteKey = typeof(InventoryItem.inventoryCD),DescriptionField =typeof(InventoryItem.descr))] [PXUIField(DisplayName = "Item ID")] public virtual int? UsrItemID { get; set; } public abstract class usrItemID : PX.Data.BQL.BqlInt.Field<usrItemID> { }I should show Item ID
Bakground:I have a business need that requires tracking and storing changes made to Projects Cost Projection which is way beyond the Acumatic’s out-of-box features and functionality. I tried to customize Acumatica’s out-of-box screen but the changes where too much and also I faced screen crashing almost every other time loading the screen or making changes as it was very very very slow . So I decided to create a brand new screen. The performance of this new screen is much better than out-of-box customized one but still is not satisfactory from my perspective. Below I have attached the screenshot of the new screen. On a side note there are more columns in the screen and about 450 Lines in the Parent Grid: Business Logic:As you can see the screen has 3 major DataViews. From Top I will call them here “Form”, “Parent Grid” and “Child Grid”. The “Parent Grid” is all read-only values and all of them are Bound fields stored in DB. When User wants a New Projection either copies one of the pre
Hi, Need to know how to show an error or warning message on grid row. Can someone help me out?Here is my sample codepublic PXAction<HMRCVendorRegisterDetail> VerifyVendors; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Verify Vendors", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)] protected virtual IEnumerable verifyVendors(PXAdapter adapter) { foreach (HMRCVendorRegisterDetail vendorRegisterDetail in VendorRegisterDetail.Select()) { if(vendorRegisterDetail.UsrSelect == false) { //Need to show a error message on paricular row } else { //Logic } } return adapter.Get(); }Thanks
Hi all,In Payments and applications screen, I want to load corresponding invoices automatically when we updating customer. Although it should work as default, it is not working.Is there any configuration that I should do to enable this? or Can I do that using a customization? Any idea on this?
Hi all,I have defined a key field in my newly created DAC as follows#region RefNbr [PXDBIdentity(IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] public virtual int? RefNbr{ get; set; } public abstract class refNbr: PX.Data.BQL.BqlInt.Field<refNbr> { }#endregion This is how I defined it in DB ScriptRefNbr INT NOT NULL AUTO_INCREMENT UNIQUE, In my Screen it shows Like this initially before record is saved. But After it is saved it shows the actual RefNbr like (1,2,3….) How can I stop showing this as a negative value. Can I show that as <New> instead of this negative value before saving the record. Thanks
I am trying to change the “Create Appointment” button on the Service Order screen so it opens up in a new window instead of the current. Is there a way I can only override part of the action?
Hi Team,Can someone tell me how to show Error/Warning message box?Here is my codeprotected void HMRCAPIConfigDetail_Active_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (HMRCAPIConfigDetail)e.Row; var activeAPIConfigs = ActiveAPIConfigs; if(activeAPIConfigs != null) { row.Active = false; throw new PXException(Messages.APIActiveErrorMessage); } }Thanks
Hi Team,How to pass customized field values from Sales Header to shipment Header?Currently I overrided “CreateShipmentFromSchedules” to pass the customized field values from Sales Line to Shipment. But i cannot find a way to pass the values for headers.Could you please help me on this.Regards,Ramya
Hi Team,Need to know how to enable or disable specific field based on the another field value. Can someone help me? Here is my codeprotected void _(Events.FieldUpdated<HMRCVendorRegisterDetail, HMRCVendorRegisterDetail.verifiedTypeID> e) { HMRCVendorRegisterDetail row = e.Row; if (row == null) return; if (e.OldValue != e.NewValue) { if (row.VerifiedTypeID.Equals("M")) { row.VerificationNote = "Manual Verified By " + PXAccess.GetUserName() + " On :" + DateTime.Now.ToString(); //row.VerifiedDate Need to Enable/Disable this field } } }
Does a Fluent BQL equivalent exist for the STRING_AGG function in SQL Server? I am writing a query over a one-to-many relationship and would like to see a string column from the `many` table concatenated with commas. Similar to how Customization Projects can display multiple Screen Names in a single cell. Does any one know the best practice for achieving this?
How do i go about creating an html file that can be accessed from another script?
Dear Team, Please help us with the following situation.We will warranty equipment products for customers with our products sold. The product is only warranted if the customer's product Serial number matches the Serial number of the Acumatica system that stores Serial data when sold.We save the Serial number when products are Receipted/Issued through the field "Lot/Serial Nbr." on the Acumatica system.When customers bring the device in for warranty service. We need to first check the Serial number on the "Case" screen. We've created new fields on the "Case" screen as below to do this. The results we expect are depicted as shown below: 1/. On the Case screen. When entering the Serial number in the UsrSerialNbr(Serial Check) field => press Enter. If Serial number is found in PX.Objects.SO.SOShipLine => The fields (InventoryID, Inventory Description, ShipDate, OrderNbr) will display the corresponding data taken from DAC SOShipLine.2/. Conversely, If the Serial number is not found in
Dear Team, When creating a new CASE or opening a CASE, the default TAB is "DETAILS". How to change default TAB to "ATTRIBUTES" ? Best Regards,NNT
[PXOverride] protected virtual IEnumerable ConfirmShipmentAction(PXAdapter adapter) { this.Base.confirmShipmentAction.Press(adapter); return adapter.Get(); } I have written this code in my Graph extension to override the Base action but I get this error as soon as i click action button on the screen. And after that the shipment is confirmed. Attempt by method 'Wrapper.PX.Objects.SO.Cst_SOShipmentEntry.ConfirmShipmentActionGeneratedWrapper(PX.Objects.SO.SOShipmentEntry, PX.Data.PXAdapter)' to access method 'MyCust.Acumatica.SOShipmentEntryExt.ConfirmShipmentAction(PX.Data.PXAdapter)' failed.
I was asked to restrict results of the Add Item button of the SOOrderEntry screen to only non-stock items and stock items associated to the current branch, filtering out items of other branches that are not extended to the current branch.My PXProjection inherits from SOSiteStatusSelected and uses PXSubstitute to utilize my select instead of the one in the base projection. This seems to work well, except when I apply a filter to the Warehouse (Site ID) column in the dialog’s grid. Other columns seem to work fine, but not Warehouse. I get the following error: This is because filtering the result grid injects the following into the underlying SQL statement which obviously won’t work because the projection’s class isn’t in the database. AND ((SELECT TOP (1) [INSiteExt].[siteCD] FROM [INSite] AS [INSiteExt] WHERE ([INSiteExt].[CompanyID] = 4) AND ([INSiteExt].[BranchID] IS NULL OR ([INSiteExt].[BranchID] IN (75, 79, 78, 80, 81, 82))) AND [INSiteExt].[SiteID] = [SOSiteStatus
Hello,I want to enable the button “Enter AP Bill” which associate with action CreateAPInvoice on Purchase Orders screenby implementing Event handler Row_Selected as following:protected void POOrder_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (POOrder)e.Row; if (row != null) { if (row.Status == POOrderStatus.Hold) { Base.createAPInvoice.SetEnabled(true); } } }but it doesn’t working.Do you have any suggestion?
Hello,I have been adding fields to the INUnits table to better fit our needs, and so far it seems to be exactly what we need. I followed the example from this link: https://www.acumatica.com/blog/creating-acumatica-dac-extension-tables/. However I have ran into issue relating to copy and pasting.When I try and copy this SKU to make a new one this happens It makes sense that the key cannot be NULL, but why is it trying to insert the extension table row before the main row exists?Regardless, its not the end of the world to me if I am unable to bring over all of the UOMs, so I added this code to the graph extension based on this example: https://stackoverflow.com/questions/56261490/hiding-custom-fields-in-copy-past-optionPXViewName(Messages.InventoryUnitConversions)]PXImport(typeof(INUnit))]PXCopyPasteHiddenView]public PXSelect<INUnit, Where<INUnit.inventoryID, Equal<Current<InventoryItem.inventoryID>>>> itemunits;And am met with this when I copy and paste:This
Hello all, I hope you’re having a great day! I have added a customisation to add some fields to our Business account screen so we can more easily identify top end users etc etc. After publishing the customisation I have had an undesired effect where in the data fields aren’t displaying the same as they were in the customisation project editor, please see below for reference:I have also put a photo of how it is laid out in the customisation project editor:Not sure if the different icon for the first column means anything? Any advice on this will be greatly appreciated!! Many thanks in advance, Aleks
Hello,Im trying to build GI with ARInvoice being linked to SalesOrder. I tried to use InvoiceNbr in both but no luck. How can I do it?
Hi Team,Need know how to write bql query with order by and where part. Can someone help me?My Sample[PXFilterable] public SelectFrom<HMRCVendorRegisterDetail>.OrderBy<Desc<HMRCVendorRegisterDetail.validTo>>.Where<HMRCVendorFilter.bAccountID.FromCurrent.IsNull.Or<HMRCVendorRegisterDetail.bAccountID.IsEqual<HMRCVendorFilter.bAccountID.FromCurrent>>>.View.ReadOnly DetailsView;
Currently in Acumatica, when you are trying to receive an item with serial numbers from a 2 step transfer, the document already comes with the serial numbers from the original transfer.I’ve tried to remove them from the Cache objects and views y different ways but ultimately it doesn’t work. Is there a way to clear or remove all line details records when the Transfer number is selected? This way the user validates the physical serial number and enters it in the system. Here is my code with all the ways I’ve tried. Any help will be much appreciated. protected void INRegister_TransferNbr_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (INRegister)e.Row; // this.Base.Caches<PX.Objects.IN.INTranSplit>().Clear(); //this.Base.Caches<PX.Objects.IN.INCostStatus>().Clear(); // this.Base.Caches<PX.Objects.IN.Overrides.INDocumentRelease.ItemLotSerial>().Clear(); //this.Base.Caches<PX.Objects.IN
This is 2022 R2 : Build 22.215.0056I am having all kinds of weird things happening in the data of the Sales Demo that I do not understand.Issue #1: (With No Customizations Published) When I look in the database file (Using SQL Manager) I see that there is a stock inventory Item named: “GoPro” But when I search for it in the IIS Application, it is not found: Issue #2I have extended the DAC for InventoryItem to add a field: UsrASGDescX -- it is an extended description field. I would like to also search by this field in Inventory Lookup on Sales Order. This is the definition of my field in the DAC: #region UsrASGDescX [PXString] [PXUIField(DisplayName = "Extended Description")] public virtual string UsrASGDescX { get; set; } public abstract class usrASGDescX : PX.Data.BQL.BqlString.Field<usrASGDescX> { } #endregionI have created a GI which allows me to see the extended data fields:I go to the inventory Item AALEGO500 -- since I can see it in the SQL Server AND the IIS
Hi Team,In the 22R1 version, we utilized the SOOrder.CCCardNumber fields in our reports to display Card Number details. However, these fields have been removed in the 23R1 version, leading to an "Invalid column" issue.Is there an alternative solution available?Thanks in advance.
Hi,In the Projects screen, a client is wanting to have the description field from the Tasks tab to be copied across to the ‘Task Description’ custom field in the Revenue and Cost Budget tabs. I have code set up from a previous request that copied over the Task ID column to these tabs, so I am just needing to add some additional logic to this code, but I am not sure how to achieve this. The comments in the code starting with ‘ATTEMPT:’ show where I was adding in the logic to try and achieve this. It publishes without any issues, but then when I try it out in the Projects screen, I get the error shown in the image below about an incorrect extension being requested. What would you recommend for my next attempt? Kind regards,Andrew protected void PMTask_UsrLineCtr_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (PMTask)e.Row; PMTaskExt rowExt = row.GetExtension<PMTaskExt>(); // ATTEMPT: Grabbing the DAC extension for the PMRevenueBudget and PMCost
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.