Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
#region UsrAccount[Account(DisplayName = "Account", BqlField = typeof(INTranExt.usrAccount), Visibility = PXUIVisibility.Visible, Filterable = false, DescriptionField = typeof(Account.description), Required = false, AvoidControlAccounts = true)]public virtual int? UsrAccount { get; set; }public abstract class usrAccount : PX.Data.BQL.BqlInt.Field<usrAccount> { }#endregionI have created a custom field with Account attribute.Account attribute has this default warning in place. I have added FieldVerifying on the my custom field. But this warning seems to override my error message. How can I show my error over this default warning I am not able to figure this out.Can anyone share some suggestions.Thanks.
Hi,I’m new to acumatica. I customized a new screen with formtab template. Inside my tab I customized a grid. This time I want to add “Add order” button which is used to pop-up a new window (smart Panel) including all the purchase orders which are available in the POOrder DAC and select and insert into the grid when click on each order. below screenshots for the reference. the gridI have created the smart panel so far. But I need to add the values of smart panel into the grid. Can someone suggest me the way to do this or provide me any guidence resource.thank You.
Hi,I’m new to acumatica. I have a customized screen. There is a button with an action which opens a pop-up window. In this pop-up window I have loaded data from both POOrder DAC and POLine DAC. To load data , I created a view using SelectFrom attribute .But when I try to add data from the pop-up window to the grid of my customized form, I’m getting below error. 'Unable to cast object of type 'PX.Objects.PO.POOrder' to type 'PX.Data.PXResult`2[PX.Objects.PO.POOrder,PX.Objects.PO.POLine]'. Can someone help me to solve this issue please?Thank you.see the below code for reference.namespace GRIProformaInvoice.Extension{ public class APProformaEntry_Extension : PXGraphExtension<APProformaEntry> { public SelectFrom<POOrder>.InnerJoin<POLine>. On<POLine.orderNbr.IsEqual<POOrder.orderNbr>>.View POrdersView; public PXAction<APProforma> MyAction; [PXUIField(DisplayName = "Add Purchase", MapEnableRights = PXCacheRights.Selec
Hi, I have a newly created screen including a form and grid. I have modified a button to pop-up a window which consists data of POOrder and POLine tables. To load data from these two tables, I have defined a view like below.public SelectFrom<POLine> .InnerJoin<POOrder>.On<POLine.orderNbr.IsEqual<POOrder.orderNbr> .And<POLine.orderType.IsEqual<POOrder.orderType>>> .View POrdersView;I want to add some values from this smart panel to my custom grid in the screen. After adding the values to the grid, when I try to save to the database, I’m getting below error. There is no field called ‘OrderDate’ in my DAC for the grid, but both POOrder and POline have ‘OrderDate’. Even I don’t try to update records in these two tables, How can I get this error? Does someone have an idea on how to solve this?thank you
Hi,I’m customizing a new screen, In my screen I have a grid with some fields taken from my customized DAC. I modified some fields with Enabled=false property because I don’t need to allow edit those fields from the UI. below example for the reference.#region Ponbr [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Sales Order Number", Enabled = false)] public virtual string Ponbr { get; set; } public abstract class ponbr : PX.Data.BQL.BqlString.Field<ponbr> { } #endregion #region POLineNbr [PXDBInt()] [PXUIField(DisplayName = "Sales Order Line Number", Enabled = false)] public virtual int? POLineNbr { get; set; } public abstract class pOLineNbr : PX.Data.BQL.BqlInt.Field<pOLineNbr> { } #endregion But after adding them, I’m unable to change the width of these columns in the grid as required. Before modifying them , I had changed the width property in layout properties of these fiel
Hi,Can we get report export as the XML one in the acumatica? Thanks & Regards
Hello,I'd like to modify slightly the snanning workflow of the IN301020 form.The initial worklow is the following one :1°) Scan the barcode of the warehouse,2°) Scan the barcode of the location,3°) Scan the bar code of the item,4°) Scan the lot / serial number5°) Create the corresponding receipt in the confirm state.This work fine but let's imagine you have to scan hundred of objects of exactly the same item type. For each of theses objects, you have to scan the barcode of the item and then the serial number.If we were able to scan once the barcode of the item at the beginning of our scan session, and then only the barcode of the serial numbers, we would save both time and effort.I have tried to change the workflow so that, after receipt creation (step 5), we come back to step 4 : "Scan the lot / serial number" and not to step 3 : "Scan the bar code of the item".Unfortunately, even with the informations found in the documentation, the code I have written doesn't work and lead to a stac
Hi Folks,I’ve tried to attachment pin on the Bills and Adjustment screen ID AP301000 for the mobile app using below customization code, but it didn’t work after publishing customization, so some one help me on this ?
I’m trying to set an attribute invisible using this line of code : var row = (SOLine)e.Row; if(row != null){ var rowExtension = row.GetExtension<Objects.SO.SOLineExt>(); PXUIFieldAttribute.SetVisible<rowExtension.UsrStkDispEntrp>(cache,row,false); } but i’m getting this error : 'rowExtension' is a variable but is used like a type thanks.
How do you get a custom field to only show dependant on an earlier field choice? The scenario:On the Activity page CR306010, you can currently choose different activity types, such as phone call or note. We would like to add a custom field so that the custom field shows up when Phone Call is chosen. This Custom Field would be called Call Type, and have drop-down options such as Cold Call, Pricing Call, Customer Sevice Call etc.Then we are planning with that data to be able to see what type of phone calls are being made. So the question is, if we add a custom field, how can we get it to show only when the Type Field is filled with the Phone Call option? Trust this makes sense.
Hi all,I am trying to use a Selector functionality to choose a Case ID when I am filling the grid on Employee Time Activities, but this field is disabled to edit in that grid.Following is the attributes customized CaseCD existing field[PXDBString(15, IsUnicode = true, IsKey = true, InputMask = ">CCCCCCCCCCCCCCC")][PXDefault()][PXUIField(DisplayName = "Case ID", Visibility = PXUIVisibility.SelectorVisible)][PXSelector(typeof(Search2<CRCase.caseCD,LeftJoin<BAccount, On<BAccount.bAccountID, Equal<CRCase.customerID>>>, Where<BAccount.bAccountID, IsNull, Or<Match<BAccount, Current<AccessInfo.userName>>>>,OrderBy<Desc<CRCase.caseCD>>>),typeof(CRCase.caseCD),typeof(CRCase.subject),typeof(CRCase.status),typeof(CRCase.priority),typeof(CRCase.severity),typeof(CRCase.caseClassID),typeof(CRCase.isActive),typeof(BAccount.acctName))] I know that is possible to fill this information using the Cases form (CR306000) in the Activities tab, b
Hi,I developed a custom screen as below.As you can see in the above screen shot, I have already saved some records to the database for the above mentioned reference number. After adding and saving record to the database as above, i need to keep the all fillable fields as non editable.I tried to accomplish this task by putting the following event handler.protected void APProforma_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (APProforma)e.Row; APProforma item = SelectFrom<APProforma>.Where<APProforma.refNbr.IsEqual<APProforma.refNbr>>.View.Select(this, row.RefNbr); if (item.RefNbr != null) { //row.Currency = item.RefNbr; APProformas.AllowInsert = false; APProformas.AllowSelect = false; APProformas.AllowDelete = false; APProformas.AllowUpdate = false; APProformaItems.AllowInsert = fals
I need to make some fields like Promise On Date, POLine Quantity editable when the Purchase Order is on the specific Purchase Order status is Open.How can I achieve this ??Thanks
Hello Everyone,I’m publishing POS on my ERP but the publication is not reaching the final stage.It’s reaching this stage as shown below and does not proceed from there. If I reload the page, I get this error(The session has expired. Please reload the page.) and the customization is shown as published on customization project screen.But this causes POS to misbehave and be erroneous.Kindly assist for it is urgentThank you all
I have added a new custom field that allows user to select an account. For that I have used existing Account attribute.[Account(DisplayName = "Account", BqlField = typeof(INTranExt.usrAccount), Visibility = PXUIVisibility.Visible, Filterable = false, DescriptionField = typeof(Account.description), Required = false, AvoidControlAccounts = true)] public virtual int? UsrAccount { get; set; } public abstract class usrAccount : PX.Data.BQL.BqlInt.Field<usrAccount> { }I have a field validating event on this field. When it returns an error is shows the AccountID instead of the AccountCD. How can is solve that. Can anyone please provide an insight here.
Hello,In Sales order form, I would need to override the “Insert row” standard action but I'm struggling to find the way to do this.Does anyone have a suggestion about this ?Thanks.
Hey Everyone,I got the following error on publishing POS (2021 R2)(2021.206) on my ERP (2021.203). What could be the issue?Kindly assist.I will appreciate for your kindness.Thanks.
Hello Everyone, I couldn’t find POS that integrate well with my Acumatica ERP, I tried to publish and use the available POS version but all of them were erroneous.Errors I came across>(After processing pos order printing does not occur, payment status left open after processing, Reprint receipt not working etc)Must the POS version rhyme with Acumatica ERP? My Acumatica build is ;The available POS builds are; Kindly assist.Thank you
Hi Everyone,When we are converting the Sale Quote to Sales Order, we are updating few custom fields and implemented with the below logic it is working fine, but when we have same line items and could not able to identify the unique line and values are not copying from Sales Quote to Sales Order.can anyone help me with this?I know that As I comparing only Inventory ID, then I’m seeing this issue but is there any field that we can identify uniquely? public class QuoteMaintExt : PXGraphExtension<QuoteMaint.CRCreateSalesOrderExt, QuoteMaint> { public static bool IsActive() => true; [PXOverride] public IEnumerable createSalesOrder(PXAdapter adapter, Func<PXAdapter, IEnumerable> baseMethod) { PXGraph.InstanceCreated.AddHandler(delegate (SOOrderEntry graph) { graph.RowUpdated.AddHandler<SOLine>(delegate (PXCache sender, PXRowUpdatedEventArgs e) { SOLine objSOLine = e.Row as SOLine;
Hello Community,In my “Page_Load” sometimes I use Grid Control RowDataBound to manipulate the grids layout as followsPX.Web.UI.PXGrid gridWithStyle = (PX.Web.UI.PXGrid)ControlHelper.FindControl("grid", page);if (gridWithStyle != null){ gridWithStyle.RowDataBound += (object grdsender, PXGridRowEventArgs erdb) => { var grdRow = erdb.Row; //Do Stuff }}I have come across a situation where I need to do the same for “Form” control. I tried to replicate the same logic from Grid and modify it for Form but couldn’t make it work. This is what I have done but I have a problem with the commented part for “DataBound” as follows.PX.Web.UI.PXFormView formWithStyle = (PX.Web.UI.PXFormView)ControlHelper.FindControl("form", page);if (formWithStyle != null){ formWithStyle.DataBound += (object frmsender, EventArgs erdb) => { // how? var frmRow = erdb.Row; //Do Stuff }}Any help is appreciated how can I make this work?
Hi Team, I have created customization project & created new tab which is working fine in development environment but when i publish to Server instance tab missing other customization like adding field change name create new screen all working only new added tab in existing screen missing. My local Instance DevelopmentPublished Server instance Any solution for this issue ThanksArun.
i have code like this and this my pxselectpublic PXSelect<ITDeliveryPlanning.ITDeliveryPlanning, Where<ITDeliveryPlanning.ITDeliveryPlanning.orderNbr, Equal<Current<TransDeliveryPlanningDAC.orderNbr>>, And<ITDeliveryPlanning.ITDeliveryPlanning.lineNbr, Equal<Current<TransDeliveryPlanningDAC.lineNbr>>, And<ITDeliveryPlanning.ITDeliveryPlanning.lineReceiptNbr, IsNull>>>> ItemsPlanning; why cant update the feild ?i got error like this Please Help Me
throw new PXSetPropertyException(Messages.Test);I have added the above code in FieldVerifying event of my custom field.This does raise an error. But the new selected value is assigned to the field. Can anyone see what wrong I am doing here.
I need to gather data from across all tenants of the instance to allow certain users. One use case is to allow an authorized user to search Stock Items across all tenants. While I’m open to suggestions on how to do this without creating a SQL view to bypass the CompanyID injection into the SQL statements, I’m trying to leverage PXLoginScope for a method I’m testing. While admin@Company works when logged into Company, it throws an error when my current tenant is not “Company”.I am trying to use PXLoginScope to read all the data as admin and return the results to the end user.I found an example of using it, and I have the same problem no matter my approach.using (new PXLoginScope(string.IsNullOrEmpty(companyId) ? "admin" : ("admin@" + companyId), PXAccess.GetAdministratorRoles()))using (new PXLoginScope(string.IsNullOrEmpty(companyId) ? "admin" : ("admin@" + companyId), Array.Empty<string>()))using (new PXLoginScope("admin@" + companyId))What I find particularly interest
Hello Ppl,I want to display the Total recurring Amount from service contract screen and to display them in Run Service Contract Billing .I am trying to customize the Run Service Contract Billing form to add Total recurring Amount column into the grid.I tried to extend the ContractPeriodDetails DAC for the grid , then added custom field in Screen Editor, I added UsrTotalRecurringPr (Total Recurring Price) control of type decimal to the Grid but am not getting the result.I understand I’m missing/ doing something wrong, kindly correct me here.public class ContractPeriodDetailExt : PXCacheExtension<ContractPeriodToPost> { public static bool IsActive() => true; #region UsrTotalRecurringPr [PXDecimal] [PXUIField(DisplayName = "Total Recurring Price")] [PXUnboundDefault(typeof(Search<FSContractPeriodDet.recurringTotalPrice, Where<FSContractPeriodDet.recurringTotalPrice, Equal<Current<ContractPeriodToPost.refNbr>>>>))]
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.