Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi, There is and GI Tax-AR TCS RMS Wholesaler. When i active the artra.invenotry id and inventoryitem.inventory id its giving me below error.Can any one guide me please. I have tried solution but did not work.
I have a custom field that interacts with a query to count the number of production order materials with negative quantity requirements. We are using this to indicate byproducts. Here is the DAC for the custom field: Here is the code for ProdMaint:namespace PX.Objects.AM{ public class ProdMaint_Extension : PXGraphExtension<PX.Objects.AM.ProdMaint> { public PXSelect<AMProdMatl, Where<AMProdMatl.orderType, Equal<Current<AMProdItem.orderType>>, And<AMProdMatl.prodOrdID, Equal<Current<AMProdItem.prodOrdID>>>>> ProdMaterials; #region Event Handlers protected void _(Events.RowSelected<AMProdItem> e) { AMProdItem row = e.Row; if (row == null) return; AMProdItem prodItem = (AMProdItem)Base.ProdMaintRecords.Current; var amProdItemExtVar = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(prodItem); var inventoryIDletters = ""; foreach (AMProdMatl material in ProdMaterials.Select()) {
In 24R1, I created a new project. When I open the project in the editor, the tree on the left looks normal. As soon as I add the PO301000 screen, the tree is almost empty.I reset caches, restarted the app, recycled the app pool in IIS. I deleted the project and started over, same thing happens. Any ideas?
Hello guys,i tried to create a Multiselect Combo Box but it not working, hope u can help me.[PXDBString(500)][PXStringList(new string[] { "E1", "E2", "M", "U" }, new string[] { "elektr. Sicherheit", "EMV", "Material", "Umweltsimulation" },MultiSelect = true)][PXUIField(DisplayName = "Bereich")]
Hi Expert.I added 2 field this screen FA303000Base locgic: if change value field Department and more.. then tab “Locations” insert a row into FALocationHistory table.Now I want 2 field Warehouse and Location change value => insert new row into FALocationHistory table (behavior same field Department).I try many solutions and overried base code but The system is still not working properly. protected virtual void FixedAsset_RowUpdating(PXCache sender, PXRowUpdatingEventArgs e) { var newAsset = e.NewRow as FixedAsset; var oldAsset = e.Row as FixedAsset; if (newAsset == null) return; if (this.WillAccountsBeChanged(newAsset, oldAsset, out int? faAccID, out int? faSubID, out int? accDeprAccID, out int? accDeprSubID) && FAInnerStateDescriptor.IsAcquired(newAsset.AssetID, this) && !FAInnerStateDescriptor.WillBeTransferred(newAsset.AssetID, this) ) { if (As
Hello everyone, I am sure we all have events we would want to run once per screen load, unfortunately, we do not have a ScreenLoaded event or anything of that sort. To overcome this you can create a non-persisted bool.#region TrueFalsepublic abstract class trueFalse : BqlBool.Field<trueFalse> { }[PXBool][PXUIField(Display Name ="True/False", Enabled = false, Visible = false)]public virtual bool? TrueFalse { get; set; }#endregionThen you can control the value of this with a RowSelected event handlerprotected virtual void _(Events.RowSelected<YourDAC> e){ YourDAC row = e.Row; if(row == null) return; if(row.TrueFalse != true) { row.TrueFalse = true; } else return;}This field value will hold until the screen is refreshed, however, when it is refreshed it will trigger the RowSelected handler again and set the value to true. You could also update the field value within the handler that executes your logic, in this case my non-persisted bool is UsrCreditHold and use an i
I’m trying to add a dialog to several existing pages. I would like #include an *.inc file to reduce the time to build the screen. I haven’t found a way to get the #include to stick on an existing page.Has anyone done it?
My modern UI screen was running on 25R1 version 25.093.0036, After update the Acumatica version 25.100.0054 and build Modern UI screen getting error “An item with the same key has already been added.” anyone has any idea on this
Hello, I’ve added a check box to a grid and used the AllowCheckAll option to create a check box in the column header to allow all options to be checked. As shown in the post below.It worked BUT the column header caption disappears. Very often a check box is used in a processing screen, and the first field in the grid, so not having a caption isn’t a big deal. In my case, the checkbox isn’t at the start of the grid, it’s half way through. Without a caption it’s difficult for users to understand what the field is for. Is there any way to make the system display a caption and a check all box?
Hello Community, I am working on a customization to add a custom user field with a character hard coded as the first character in the string and would like it to not be selectable\overwritable. So essentially it would look like “T” on the screen and start at data entry after that character. Currently I have below. Is there a property I could set to start the text entry at position 2? #region UsrTNo[PXDBString(3)][PXDefault(typeof(T), PersistingCheck = PXPersistingCheck.Nothing)]public virtual string UsrTNo { get; set; }public abstract class usrTNo : PX.Data.BQL.BqlString.Field<usrTNo> { }#endregionpublic class T : PX.Data.BQL.BqlString.Constant<T>{ public T() : base("T") { }}Thanks!
How to get the latest value from the Database.I have created a Database where the record is always updating. So I always want to get the latest record. Clearing Cache is not workingBase.Document.Cache.Clear();Base.Document.Cache.ClearQueryCache();e.Cache.Clear();e.Cache.ClearQueryCache(); using PXSelect is alway providing the Cached Value PXSelect<TableName, Where<TableName.bAccountID, Equal<Required<TableName.bAccountID>>, And<TableName.inventoryID, Equal<Required<TableName.inventoryID>>, And<TableName.startDate, LessEqual<Required<TableName.startDate>>, And<TableName.endDate, GreaterEqual<Required<TableName.endDate>>
I am working on the a Customization Project, where are I have create a new screen in which Inventory and available quantity to order is mentioned.Only Available quantity is allowed to order. Problem:-When multiple orders are placed at the same time from different instances, the order are getting resolved parallelly due to which the initial quantity available to order are getting conveyed to all the orders, which is incorrectAll the orders should have been resolved in a queue. Please help me to resolve this issue
In Employee Time Activity screen (EP307000) we can select project and project task in grid area.Now we need to restrict project task selection base on login user’s roll.In other word if login user have XYZ role then he can able to view only those task which contains “Labor” word in it. So, basically PXSelector should be dynamic.
I want to combine the below the Statement into a single one as it contains the same Where Condition and Column Update<TableName> .Set<TableName.OrderNbr.EqualTo<@P.AsString>> .Where<TableName.id.IsEqual<@P.AsInt>> .Update(Base, new object[] { orderNbr, Account.Id }); Update<TableName>.Set<TableName.Review.EqualTo<@P.AsBool>>.Where<IAAccountAllocation.id.IsEqual<@P.AsInt>>.Update(Base, new object[] { 1, Account.Id });
Hi, I have a customisation that is attempting to prevent duplicate lot numbers from being scanned on the mobile App (IN301020) and Receipts (IN301000) INReceiptEntry is overriden to throw an exception whenever:There is a lot number already persisted to the database, or The Lot number already exists on the unpersisted receipt.Condition a. works as required. The screen shot below shows the outcome of attempting to scan lot # 1234 which already exists in the database.The error message is in the header, and this is visible when using the mobile App.However condition b. behaves differently, 1234z doesn’t exist in the database. On fist scan it gets added.No problem there. However when scanned again, the error messaging is appearing on the line, instead of the header.The issue I have is that this error messing isn’t visible on the Mobile App. What I’m looking to acheive is to have an error message display on the header when condition b. ocurrs.In terms of the cusomisation, there is a Fe
I have view which is used with 2 grids on different tabs and showing different columns, like view have total 12 column, first tab grid show 7 columns, second grid show 5 columns.we are doing same, in classic UI, where we define grid in aspx, but in modern UI we do not have option to define the grid, how can achieve this case.Grid1 Grid2 Modern UI <qp-tab id="tab_0" caption="LOT/SERIAL DETAILS"> <qp-grid id="lotNumbersGrid1" view.bind="BatchLotDetails"></qp-grid> </qp-tab> <qp-tab id="tab_3" caption="LOT/SERIAL DETAILS"> <qp-grid id="lotNumbersGrid2" view.bind="BatchLotDetails"></qp-grid> </qp-tab>
Hi I have created 2 selectors in material wizard 1 screen (AM300010) as belowIf the selector gives one record after putting the production number in the filter it should automatically press the Select All button.How can I achieve this, I have tried using Base.Actions["SelectAll"].Press(); but i get the error:System.NullReferenceExceptionMessage: Object reference not set to an instance of an object.using System;using PX.Data;using System.Collections.Generic;using PX.Objects.CS;using System.Collections;using System.Linq;using PX.Objects.IN;using PX.Objects.AM.Attributes;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class MatlWizard1_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard1> { #region Event Handlers protected void AMProdItem_Selected_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated baseHandler) {baseHandler?.Invoke(cache, e); var row = (AMProdItem)e.Row; if (row.Selected == true) // Only i
Hello Community,I need to add two nearly identical actions to the move screen. Each one points to a specific printer. I am then going to have a business event execute the action. I am having issues with getting both to show up. I have tried a few different ways to make it work and they arent both posting. Only one will post. i tried separate customization projects (with different names) and i tried putting them both in the same project but only one will be available. Could someone tell me what i need to do so that both will show up? Code is below. Any help would be greatly appreciated. Im pretty sure its something simple that i am just overlooking.using PX.Data;using PX.Objects.CS;using PX.Objects.AM.Attributes;using System;using System.Collections.Generic;using System.Collections;using PX.Objects;using PX.Objects.AM;using System.Threading;using PX.SM;namespace PX.Objects.AM{ public class MoveEntry_Extension2 : PXGraphExtension<PX.Objects.AM.MoveEntry> { #region E
I have a custom action on the Sales Orders screen. If the order is a Quote and it has been saved, the user can click my custom action button and it will create a Quote PDF and attach it to the current record. The customer uses Acumatica ESign.The next step is to get the user over to the ESign screen. I’ve tried two ways to do it. Redirecting the user to the File Maintenance screen and populate it with the Quote file. From there they could click the ESIGN button. Redirect the user directly to the ESign screen. The 2nd option is preferred. After the PDF is attached to the record on the Sales Orders screen, you CAN click Files at the top of the screen, then click the Edit link on the Files dialog. That will take you to the File Maintenance screen where you can click ESIGN. My customer want a “one click” operation. That is why option 2 is preferred. But if that cannot be done, I will take option 1.At the end of my “Create PDF Quote” action, I have the following code to create an i
Hello all,Can anyone let me know how can I add branch ID column in the Release Time Cards screen? The Employee Time Cards screen doesnt have a branch ID. So how can I add the same in the Release Time Cards screen?Thanks.
Hello. Having an odd one with AutoNumbering. Below is the Numbering Sequence, the New Number Symbol is <NEW> like others. The custom screen is below. When I click add, the Car ID is set to ‘NEW’ not ‘<NEW>’.There are also 2 spaces before the value NEW.If I enter car details and click save, the auto numbering works. The DAC is below[Serializable][PXCacheName("PinnCar")]public class PinnCar : IBqlTable{ #region Carid [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Car ID", Visibility = PXUIVisibility.SelectorVisible)] [PXSelector(typeof(PinnCar.carid), typeof(PinnCar.carid), typeof(PinnCar.make), typeof(PinnCar.model))] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [AutoNumber(typeof(INSetupExt.usrCarNumberingSequence), typeof(PinnCar.createdDateTime))] public virtual string Carid { get; set; } public abstract class carid : PX.Data.BQL.BqlString.Field<carid> { } #endregion //make, model and reg field //Acumatica fields.}The graph code is very s
Hi everyone, it's me again and I want to know if anyone had this problem before.The following situation is … I need to change background color in a field using a validation method in my graph extension but I don't know how to do it. In the past you could change the color of a button using JavaScript, but it would be helpful to know if it's possible using VS.Any help will be of great help.Thank you for reading. 😎
Hello-I’ve created a custom screen where auto numbering is used. When I access the screen I get the following message. The DAC for the AutoNumber field is below.[Serializable][PXCacheName("PinnATWDW1")]public class PinnATWDW1 : IBqlTable{ #region RefNbr [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] [PXSelector(typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.refNbr), typeof(PinnATWDW1.hMRCWarehouse), typeof(PinnATWDW1.period))] [PXDefault(PersistingCheck = PXPersistingCheck.NullOrBlank)] [AutoNumber(typeof(PinnATWDSetup.w1NumberingSequence), typeof(PinnATWDW1.createdDateTime))] public virtual string RefNbr { get; set; } public abstract class refNbr : PX.Data.BQL.BqlString.Field<refNbr> { } #endregion ...other fields...It has a child table, the DAC for the key fields are below. [Serializable][PXCacheName("PinnATWDW1Line")]public class PinnATWDW1Line : IBqlTable{ #region RefNbr [PXDBString(15, IsKey = true)] [PXUIField(DisplayName = "Ref Nbr")] [PXDBDefault(ty
I have a report created in Report Designer (an .rpx file) within Acumatica 2023 R1.I would like to ask:Is it possible to export an .rpx report directly to a CSV Excel file?is CSV export is supported,
StateColumn property of PXToolBarButton, it disable the custom action button on grid header based on assign field value true/false, in Modern UI is there any substitute code or solution
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.