Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
I’m attempting to extend the out of the box functionality for Prepayment validation to RM behaviour order types. It currently only works for SO behaviour order types. So far I have overridden the CreatePaymentExt.GetRequiredPrepaymentEnabled function and I’ve overridden the PXFormula attribute for the SOOrder.PrepaymentReqPct field.That part is working fine, but I’m now hung up on the the following two functions that are implemented as extension methods on the SOOrder DAC class. public static void SatisfyPrepaymentRequirements(this SOOrder order, PXGraph graph) { if (order == null || !(order.Behavior == "SO") || !(order.ARDocType != "UND") || order.Completed != false || order.PrepaymentReqSatisfied != false) { return; } graph.LiteUpdate(order, delegate (ValueSetter<SOOrder> _) { _.Set((SOOrder o) => o.PrepaymentReqSatisfied, true); }); PXEntityEventBase<SOOrder>.Container<SOOrder.Events>
I have a custom field that I created in my IN.InventoryItem table that looks like this:Previously I have this as 3 fields when I created it, published, and everything worked as expected. I went back today to add a 4th field (EF in the first string, EFOY Trailer in the second string) Published the customization, but only get the original 3 options. I tired to publish with clean up, but still did not get the expected results. Any ideas on what I did wrong, or what step I am missing?
Problem Statement Attribute Adjuster Old Approach vs Attribute AdjusterHi Community,This post is dedicated to Attribute Adjuster which is a useful Acumatica helper that allows you to more elegantly adjust attribute's state in runtime. Problem Statement A lot of business logic in Acumatica is implemented in attributes. Sometimes, the state of attribute should be adjusted in runtime, for example, in the graph row selected event like this:protected virtual void _(Events.RowSelected<MyDac> e){ PXUIFieldAttribute.SetVisible<MyDac.balance>(e.Cache, e.Row, e.Row.Balance > 0);}The old approach used by Acumatica attributes to allow developers to adjust their state at runtime was to declare a static method in the attribute. Such methods frequently have very similar implementation. Here is an example:public class PXSomeAttribute : PXEventSubscriberAttribute{ public bool Flag{ get; set; } public static void SetFlag<TField>(PXCache cache, object row, bool newFlagValue)
Hello,I am encountering an issue with the display of a foreign key in my Data Access Class (DAC) within Acumatica. Despite following the documentation and ensuring that the relationships and configurations are correctly set, the foreign key does not appear in the DAC UI.Brewery DAC :using System;using PX.Data;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data.BQL.Fluent;namespace Assainissement{ [PXCacheName("Brewery")] public class Brewery : IBqlTable { [PXDBIdentity(IsKey = true)] public virtual int? BreweryID { get; set; } public abstract class breweryID : PX.Data.BQL.BqlInt.Field<breweryID> { } [PXDBString(50, IsUnicode = true)] [PXUIField(DisplayName = "Name")] public virtual string Name { get; set; } public abstract class name : PX.Data.BQL.BqlString.Field<name> { } [PXDBBool] [PXDefault(true)] [PXUIField(DisplayName = "State")] public virtual bool? State { get; set; }
Good morning all,Why is the kit line detail form always disabled,Can you help with setting this so that I can use the KIT LINE DETAIL FORMThanks
A client has a requirement to keep track of vendor quotes by attaching them to bidding responses, which currently isn’t enabled in Acumatica. I’ve found this existing idea on the subject Attach files to bidding responses screen but since it has limited support at this time, I don’t expect it to be on the radar to get added to the product in the short term.If I create a customization to add the necessary standard fields to the RQBidding database table and DAC for notes & attachments, will this create a potential danger/conflict if the feature eventually gets added to the main product?
Another developer asked this question, but there was no answer to the question in terms of actually overriding the AddNew action on a grid.When I click AddNew on the grid, I want to default a value in one of the grid fields based on a value in a filter. When you click AddNew, it adds a blank row. I don’t see any event that is being fired when you click that button. As such, I think the only thing I can do is to override the AddNew action and populate the value in the override.As suggested in the above mentioned post, the suggestion is to use RowInserting. That event does not fire when you click the AddNew button. It fires when you leave the row.This is a custom form, not an extension. This is my code. In debug, the breakpoint on TEST is not hit. [PXOverride] public PXAction<ICSFSSScheduleLine> AddNew; [PXUIField(DisplayName = "Add New", Enabled = true)] [PXButton(DisplayOnMainToolbar = false)] public void addNew() { var
EDIT: partially fixed the issue - see my next post for the “new” issue.I have a 3 digit fixed length field on my grid. I want to ensure that the value entered is 3 characters exactly.I used a PXUIVerify to ensure the length of the value in the field is 3 characters.#region Lower[PXDBString(3, IsFixed = true, IsKey = true, InputMask = "###")][PXUIField(DisplayName = "Lower")][PXUIVerify(typeof(Where<Length<ICSFSSScheduleLine.lower>, Less<Length3>>), PXErrorLevel.Error, ICSMessages.ZipIsNotANumber, typeof(string))]public virtual string Lower { get; set; }public abstract class lower : PX.Data.BQL.BqlString.Field<lower> { }#endregionHere is the definition for “Length3”: public static class ICSConstants { public const int Length3 = 3; } public class Length3 : PX.Data.BQL.BqlInt.Constant<Length3> { public Length3() : base(ICSConstants.Length3) { } }If you enter 010 (which is valid), you still get an error:I could try
I have a custom form and I want to do filtering on the View. I’ve had a similar issue in the past which I resolved on this previous post: I’m following the same principles in my code here, but I am getting an error.In my override, my BqlCommand is EXACTLY the same as the original view select statement. I was just ensuring that the code would work before making any changes to the BqlCommand.public SelectFrom<ICSFSSScheduleLine> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<ICSFSSSchedule.scheduleID.FromCurrent>> .OrderBy<Asc<ICSFSSScheduleLine.lower>, Asc<ICSFSSScheduleLine.upper>, Asc<ICSFSSScheduleLine.cutoffDate>> .View DetailsView;protected virtual IEnumerable detailsView(){ ICSFSSSchedule currentRecord = ScheduleView.Current; BqlCommand query; //plan to do stuff here to change the query based on other factors query = new SelectFrom<ICSFSSScheduleLine> .Where<ICSFSSScheduleLine.scheduleID.IsEqual<ICSFSSSchedule.scheduleID.FromC
This is almost a duplicate of this post https://community.acumatica.com/develop-customizations-288/make-certain-fields-editable-based-on-po-status-15192I’ve tried the suggestions on that post but it is not resolving my issue.I am trying to make two fields editable when the SO is CLOSED. I’ve modified the Workflow as follows:I added code as well:namespace PX.Objects.SO{ public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { #region Event Handlers protected void SOLine_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected baseHandler) { baseHandler?.Invoke(cache, e); var row = (SOLine)e.Row; PXUIFieldAttribute.SetEnabled<FSxSOLine.sDSelected>(cache, row, true); PXUIFieldAttribute.SetEnabled<SOLine.requestDate>(cache, row, true); } #endregion }}The fields are still not editable.I am thinking that the update cache option for the SO Lines is disabled for a closed order. If that is th
I need to create a processing screen. Are there any blogs or articles regarding that?
Created a simple customization to add Principal employee and PO number to a project in 23R2, customization work without any issue until upgrade.After upgrade in Sandbox, there is an error message. \App_RuntimeCode\PX_Objects_CT_Contract_extensions.cs(35): error CS0246: The type or namespace name 'EPEmployee' could not be found (are you missing a using directive or an assembly reference?)I have come at this several different ways, and just create new error messages. I feel that I am missing something very obvious.
I created string type attribute and used on Purchase Orders screen.AttributesUDF Fields on Purchase Orders ScreenRequirement: I want to display this on Bills and Adjustment screen.A.) Able to do: We can easily add on ADD PO popup.B.) Query: But not able to find any way to display on ADD PO LINE popup or on Details GridADD PO | ADD PO LINE | DETAILS gridFyi, On Details screen PO Number field is present.PO Number is Present on Bills and Adjustment details grid.Requirement is very simple. UDF fields on POOrder should be displayed on various other place.
We need to populate warehouse location on purchase receipt screen.[LocationAvail(typeof(POReceiptLine.inventoryID), typeof(POReceiptLine.subItemID), typeof(POReceiptLine.costCenterID), typeof(POReceiptLine.siteID), typeof(POReceiptLine.tranType), typeof(POReceiptLine.invtMult), DisplayName = "To Location ID", BqlTable = typeof(PX.Objects.PO.POReceipt))]public virtual int? UsrTransferDestLocID { get; set; } public abstract class usrTransferDestLocID : PX.Data.BQL.BqlInt.Field<usrTransferDestLocID> { }I added source code.On purchase receipts screen when we click “+” button it gives an error.Error Message: UsrTransferDestLocID is our custom field.
Hello Everyone,I want to override the submit action on the Project Quote screen to add custom logic for data validation. However, the Project Quote graph and its extensions do not contain this action code for overriding.The submit action is defined in the EPApprovalActionExtensionPersistentRequired generic class, which is an approval view in the Project Quote graph.How can I override this action to add my custom logic? Thanks
this is what I show action to mobile. Do I need anywhere else ?
I added an unbound string field to the PM Budget screen. The goal is to present the “PONUMBER” attribute which is tied to a Project Task.The problem is that my field is showing the same value in the grid for all rows. I think my PXDBScalar search is not correct, but I don’t know why.This is the DAC extensionusing PX.Data;using PX.Objects.CS;using SmartRide;namespace PX.Objects.PM{ // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public sealed class SmartPMBudgetExt : PXCacheExtension<PX.Objects.PM.PMBudget> { #region UsrPONumberAttribute [PXString(255, IsUnicode = true)] [PXUIField(DisplayName = "PO Number", Enabled = false)] [PXDBScalar(typeof(Search2<CSAnswers.value, InnerJoin<PMTask, On<PMTask.noteID, Equal<CSAnswers.refNoteID>>, InnerJoin<PMBudget, On<PMBudget.projectTaskID, Equal<PMTask.taskID>, And<PMTask.projectID, Equal<PMBudget.projectID>>>>>, Wh
Trying to override InvoiceOrder and InvoiceCreated on SOInvoiceEntry to copy a value from source SO to invoice. The client could create invoices from order entry or shipment so I want to make sure it gets copied no matter what so therefore trying to do this without overriding PrepareInvoice action.This is what I have so far on SOInvoiceEntry graph extension: public delegate void InvoiceOrderDelegate(InvoiceOrderArgs args); [PXOverride] public virtual void InvoiceOrder(InvoiceOrderArgs args) { //Code before Base.InvoiceOrder(args); //Code after InvoiceCreated(Base.Document.Current, args); } [PXOverride] public virtual void InvoiceCreated(ARInvoice invoice, InvoiceOrderArgs args) { // Base.InvoiceCreated(invoice, args); ARRegisterExt registerExt = PXCache<ARRegister>.GetExtension<ARRegisterExt>(invoice); SOOrderExt orderExt = PXCache<SOOrder
I’m trying to override the GetRequiredPrepaymentEnabled method on the CreatePaymentExt graph extension.I’ve multiple methods, but have not been able to get it to work so far. Heres a screenshot showing ,my latest attempt.
Hello,How can I programmatically pass data to the Additional Filtering tab in a report?”The columns highlighted in the screenshot are as follows:”Is there any sample code or any screen like this in base screens?Thanks.
my pxselector like this: [PXSelector(typeof (Search<ARDeliveryHeader.refNbr>), new System.Type[] {typeof (ARDeliveryHeader.timeDeliver), typeof (ARDeliveryHeader.stauts), typeof (ARDeliveryHeader.deliver)})] and data access class like this[PXDBTime(DisplayMask = "t", UseTimeZone = false)][PXUIField(DisplayName = "Time Deliver")]public DateTime? TimeDeliver { get; set; }
this is my code in open opportunity screen. I can get on screen but it doesn’t save until change value in ui. if I don’t change any value on screen and leave the screen, the data is gone
Overview IsActive Purpose and Usage Scenarios IsActive Performance Improvements New DAC Fields New Graph Event Handlers, Actions and Views Overrides of Existing Graph Members Acuminator Support for IsActive Method PX1016 Diagnostic PX1056 Diagnostic Code Map Support Constantly Active Extensions Disabling Graph Extensions Hierarchy IsActiveForGraph MethodHi everyone,In this post I will attempt to explain why and when IsActive method is needed in DAC and graph extensions, and how it can simplify the developer's life and improves performance of your code. The post is largely based on the articles from Acumatica Help Portal: IsActive in graph extensions: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=cd70b408-b389-4bd8-8502-3d9c12b11112 IsActive in DAC extensions: https://help.acumatica.com/Help?ScreenId=ShowWiki&pageid=9ca4cca5-a46c-4dda-af09-8cb8b0793c34Overview Let's start with a short reminder of what the IsActive method is. It is a special public static method
Hello all, I have a scenario that I need to override a method which is used inside a Transaction Scope in the loop. Assume the method I am going to override is public virtual GLTran TheMethod(Batch batch){ //Do stuff return tran;}The way the method is called is public virtual void TheReleaseDoc(JournalEntry je){ // Some loops and stuff here foreach (Something) { // Do more stuff GLTran tran = TheMethod(je.BatchModule.Current); je.GLTranModuleBatNbr.Insert(tran); } // More loops and stuff here}I know I can initiate a new graph instance or use EntityHelper and then from the created graph instance access the viewes or methods BUT what I need is to access the same instance of the graph “je” from “TheMethod” to insert a copy of the “je.BatchModule.Current” and “je.GLTranModuleBatNbr.Insert(tran)” from inside “TheMethod”.Is it possible to access a data record current instance of Cache and Graph? If yes, how can I do that?
Hi We have requirement to insert the record in the Multiple Production Clock Entry screen from the other custom action. When i try to create the clock entry we are getting the below issue.Here is the code i tried to insert the record, could you please help me.public PXAction<POClockINFilter> ClockIN; [PXUIField(DisplayName = "Clock IN", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton(CommitChanges = true)] public virtual IEnumerable clockIN(PXAdapter adapter) { MultipleProductionClockEntry ProdClockEntrtyGraph = PXGraph.CreateInstance<MultipleProductionClockEntry>(); AMClockItem aMClockItem = (AMClockItem)ProdClockEntrtyGraph.Document.Cache.Insert(); aMClockItem.EmployeeID = 2892; AMClockTran newTran = (AMClockTran)ProdClockEntrtyGraph.Transactions.Cache.Insert(); newTran.ProdOrdID = "AM000048"; newTran.OperationID = 2; ProdClockE
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.