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 added UDFs to the EP305000 screen in the Details Tab. You can see here that the data is saving to the DB as expected. (Customer, MEP ID, Advisor ID, Product Line ID)I want to take the data after the hyphen in the Customer number field and put it into the Plan ID UDF.When I added the fields, it created a DAC Extension in PMTimeActivity.In the Project Editor, if I choose to add a handler on the Field Updated event for the Customer field, It creates a graph Extension as here:So, the DAC extension is as follows as public class PMTimeActivityExt : PXCacheExtension<PX.Objects.CR.PMTimeActivity>but the graph extension is public class TimeCardMaint_Extension : PXGraphExtension<TimeCardMaint>This obviously won’t compile as the cache is not PMTimeActivity, but rather it is EPTimecardDetail.PMTimeActivityExt myExt = PXCache<EPTimecardDetail>.GetExtension<PMTimeActivityExt>(row);How can I get a reference to the DAC Extension when the cache is different from what the grap
I would like the ability to drag and drop sales order item objects from an external website into Acumatica. Acumatica appears to support some drag and drop functionality for files (https://www.augforums.com/forums/everything-else/drag-and-drop-files-into-acumatica-directly-from-outlook/).I would like to use the same kind of browser API to drag sales order line items from an external interface into a sales order. Is there any programmatic access to the drag and drop functionality in Acumatica? This is also related to copy/paste functionality as well I think. Thanks, Jonathan
Hello!I’ve made some modifications to the Inventory Lookup smart panel in the Sales Order Screen.I added a new grid with a Split panel like this:The left grid shows the available attributes for the selected ItemClassID so that the users can search inventory items by it’s attributes.The “Search” button on the top of the attributes Grid, goes through the filtered Item list and gets the list of items that matches the user’s attribute selection.The problem is that I can’t update the right grid with the list of items.The Callbackcommand in the aspx is the following:<px:PXDSCallbackCommand Name="AttributeSearch" DependOnGrid="Attributes" Visible="False" />The button:<ActionBar> <CustomItems> <px:PXToolBarButton Text="Search" CommandName="AttributeSearch" DependOnGrid="Attributes" Visible=""> <AutoCallBack Command="AttributeSearch" Target="ds" /> </px:PXToolBarButton> </CustomItems></ActionBar>In the graph I try to
Hello experts,I want to add field FullName of DefBillContactID to selector of CustomerID I use the following code but it doesn’t work. [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.BAccountR.acctCD), typeof(PX.Objects.CR.BAccountR.acctName), typeof(PX.Objects.CR.Address.addressLine1), typeof(PX.Objects.CR.Address.addressLine2), typeof(PX.Objects.CR.Address.postalCode), typeof(PX.Objects.AR.CustomerAttribute.Contact.phone1), typeof(PX.Objects.CR.Address.city), typeof(PX.Objects.CR.Address.countryID), typeof(PX.Objects.AR.CustomerAttribute.Location.taxRegistrationID), typeof(PX.Objects.AR.Customer.curyID), typeof(PX.Objects.AR.CustomerAttribute.Contact.attention), typeof(PX.Objects.AR.Customer.customerClassID), typeof(PX.Objects.AR.Customer.status), typeof(PX.Objects.AR.Customer.defBillContactID), typeof(PX.Objects
Hi,I have added the below dropdown in the customer location screen(AR303020) and the dropdown should have the sales Rep names from Salesperson screen.drop down should contain the below list.DAC name is SalesPerson, can someone help how to write the code for this.
Hello,To solve a performance issue, I need to get VendorID list from this query :select distinct (VendorID)from APPayment, APRegisterwhereAPPayment.doctype='PPM'and status='N' -- Statut ouvert'and APPayment.RefNbr = APRegister.RefNbrand APPayment.DocType = APRegister.DocTypeTo comply Acumatica, I guess I have to use a DAC to do that. In a way, this DAC would we be a kind of reduced version of the APPayment DAC in which I just would need to embbed the following fields an not the other ones :- DocType,- VendorID,- StatusHence the title of this topic. Is it possible to do that in Acumatica ?
I am following T400 course guide lines and it requires me to open this GI. DB-SalesActivities DB Sales Activities (GI000023). But i cannot find it in my system. Maybe I have to enable some features can anyone help me here please.
Hi, I need to add a field value in the customers form to my custom form. I tried using field selecting to achieve this but no value is populated to the custom form.custom form field needed to populatevalue needed from customer formprotected void NCPMCustomerMaster_Outstanding_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e) { NCPMCustomerMaster row = (NCPMCustomerMaster)e.Row; if (row != null) { Customer customerObj = PXSelect<Customer, Where<Customer.acctCD, Equal<Required<Customer.acctCD>>>>.Select(this, row.CustomerIntType); if (customerObj != null) { row.Outstanding = customerObj.Balance; } } }
I have renamed a screen via the site map, and that works fine for the main site. However, on mobile it does not update the page or the menu button, how would I make this change? Thanks
Hi I am trying to add the selector field and customized selector field for InventoryID selector in SOLine for mobile application.selector field customized selector field I tried to add the fields but I do not find these fields in under Details ComplexType in WSDL for SalesOrder.How can I add these fields to the mobile application.
I implemented in 22R1 this easy solution posted by Sharif Ahammad https://www.acumatica.com/blog/extending-attribute-searches-in-acumatica/.It works. However, when I try to filter by attributes I get the following error: I guess it has something to do with the null attribute values. Has anybody fixed this issue?
Helo, I want to ask about PXLongOperation.So I have 2 DataView, MasterView (tis view i use to input filter and parameeter)DetailsView (main view to show the data)Then I have genearte button to insert the data that I already processed to the DetailsView based on MasterView (parameter view). But the data not saved yet, just inserted to DetailsView.After that I have code to override persist like this below.But when this persist completed. The data on the MasterView is gone/blank. What I want is the data stil on MasterView still there, becouse the user will be generate again with the same parametersSo my idea is to set MasterView.Current = dataParam;but previously the dataParam is already is set from MasterView.Currentpublic override void Persist() { try { PXLongOperation.StartOperation(this, delegate () { base.Persist(); System.Threading.Thread.Sleep(TimeSpan.FromSeconds(5));
Hi all,I want to customize following view to filter SOOrders with Open Status. How can I do that?public PXSelectJoin<SOOrder,LeftJoin<Users, On<Users.pKID, Equal<SOOrder.createdByID>>, LeftJoin<SOOrderType, On<SOOrderType.orderType, Equal<SOOrder.orderType>>, LeftJoin<PX.Objects.GL.Branch, On<PX.Objects.GL.Branch.branchID, Equal<SOOrder.branchID>>, LeftJoin<Organization, On<Organization.organizationID, Equal<PX.Objects.GL.Branch.organizationID>, Or<Organization.organizationID, IsNull>>, LeftJoin<PortalSetup, On2<Where<PortalSetup.restrictByOrganizationID, IsNull, Or<Organization.organizationID, Equal<PortalSetup.restrictByOrganizationID>>>, And<Where<PortalSetup.restrictByBranchID, IsNull, Or<PX.Objects.GL.Branch.branchID, Equal<PortalSetup.restrictByBranchID>>>>>>>>>>, Where2<MatchWithBAccount<SOOr
I’m trying to override a data view used in Stock Items and Non-Stock Items screens, and in the abstract InventoryItemMaintBase graph class -- the view named itemxrefrecord that is used in the Cross-Reference tab grid. The view, like most in this base class, uses FbqlSelect and SelectFromBase instead of just SelectFrom (see definition below). This graph class seems to be the only one in the framework that uses this syntax for some reason (at least that’s what I’ve seen from a quick code search).public FbqlSelect<SelectFromBase<INItemXRef, TypeArrayOf<IFbqlJoin>.Empty>.Where<PX.Data.ReferentialIntegrity.Attributes.KeysRelation<PX.Data.ReferentialIntegrity.Attributes.Field<INItemXRef.inventoryID>.IsRelatedTo<InventoryItem.inventoryID>.AsSimpleKey.WithTablesOf<InventoryItem, INItemXRef>, InventoryItem, INItemXRef>.SameAsCurrent>, INItemXRef>.View itemxrefrecords;This syntax uses a lot of keywords that would take a long time to decipher enou
Hello,I am trying to add the customer class to the GL301000 Journal transaction form. As you can see from the code, I have created a DAC extension for GLTran, I have also added a database column to the GLTran table called “UsrMissionCustomerClassID” as an int. So, Currently I am just trying to get the refenceID to show up.So far I have been unable to get anything to show up, and when I run the debugger in Visual Studiovalue is always set to null. I have read through the T series dev guides but I am unsure what to apply to this DAC extension.Any guidance would be greatly appreciated!Thank you in advance.namespace PX.Objects.GL{ public class GLTranExt : PXCacheExtension<PX.Objects.GL.GLTran> { public abstract class usrMissionCustomerClassID : PX.Data.BQL.BqlInt.Field<usrMissionCustomerClassID> { } public Int32? _UsrMissionCustomerClassID; [PXDBInt()] [PXUIField(DisplayName = "Customer Account Class", Enabled = false)] [PXSelector(typeof(
When a user does not enter a serial number on the Support Entry screen of the portal, I want to popup a dialog box. I can set an error on the field, but the user won’t see the message unless they mouse over the red x. I want them to get a popup with instructions to make it clearer to the user.The popup works. But it keeps getting called in a loop if I put e.Cancel = true in the event.If I use Sender.RaiseExeptionHandling, the screen functions properly and if you mouse over the error on the field, it shows my information properly.If I remove the e.Cancel = true;, the popup occurs once, but the record is still saved...that’s not good.(DAC shown below...I think that is the issue) protected virtual void CRCase_RowPersisting(PXCache sender, PXRowPersistingEventArgs e) { if (e.Row == null) { return; } CRCase caseRow = (CRCase)e.Row; CRCaseSSGPortalExt cRCaseExt = PXCache<CRCase>.GetExtension<CRCas
I am using the following code in the Kit Assembly screen which works without errors. This is based on an answer to a question someone asked that Naveen Boga answered some time ago: try { IN.INKitRegisterExt iNKitRegisterExt = PXCache<IN.INKitRegister>.GetExtension<INKitRegisterExt>(row); decimal? unitCostTotal = Base.Components.Select().FirstTableItems.ToList().Select(x => x.UnitCost).Sum(); int? itemCount = Base.Components.Select().FirstTableItems.ToList().Count; cache.SetValueExt<INKitRegisterExt.usrAIUnitCostTotal>(row, unitCostTotal); cache.SetValueExt<INKitRegisterExt.usrAIItemCount>(row, itemCount); } catch (Exception error) { PXTrace.WriteInformation(error); }the two custom fields I created are populated correctly. If I try to apply the same logic to the Kit Specifications screen:try { INKitSpecHdrExt iNKitSpecHdrExt = PXCache<INKitSpecHdr>.GetExtension<INKitSpecHdrExt
hello everyone. How can I conditionally set the Pay button to not be visible when I select a specific payment method.
Anybody have any ideas on how this field (CTaxZoneID) can be populated based on certain conditions on the customer or customer location screen?I’ve tried managing this through the workflow engine, but the necessary fields from the DefAddress or DefLocationAddress tables are not available when trying to customize AR303000 or AR303020.Can field updates be based off a GI like in Business Events?
Hi All, I want to change the default filter of this screen (quick filters) to “Pending Approval”. Currently the default is “On Hold”. How can I do this?
Hi, I want to reorder the mobile app menu( put some existing items to the top of the main menu etc.) How do I do that?
I have a generic graph extension that I would like to get the extensions dynamically. For example I want dynamically get “TGraph” & “_” & “Extension”. The TGraph is dynamic based on the base graph but the extension is fixed.
Does anyone know if the customer portal has (or best way to accomplish if not) a searchable knowledge-base? Our customer would like to enable the portal for their customers and have the customers be able to search and retrieve solutions to common questions. Maybe a wiki accomplishes this?
Hi!I’m trying to get the Attributes per ItemClassId to place them on a grid in the look up dialog box (Sales Order screen)Like this: I’m using the CSAttributeGroupList method:public PXFilter<SOSiteStatusFilter> ItemSearchClass;{[PXViewName("Attributes")]CSAttributeGroupList<INItemClass, SOSiteStatusFilter> Attributes;public PXFilter<SOSiteStatusFilter> ItemSearchClass;[PXViewName("Attributes")]CSAttributeGroupList<INItemClass, SOSiteStatusFilter> Attributes;}However, It doesn’t bring any results.
I have recently noticed that two records dealing with two differents PaymentMethodID in our PaymentMethod table have the save NoteID value.I'm new in the Acumatica's world but it seems to me that a given NoteID value should be unique in its tenant.I have decided to change the NoteID value of one of my conflicting records but to do so, I have to check before for potential uses of this value in other tables. Am I exhaustive if I search for the value to be changed in all tables having a NoteID column or can NoteID values be also used in columns having an other name ?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.