Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Ive created a PXProjection DAC and Im just trying to multiple a field by a constant (for now). The PXFormula field of DfltCompQtyCalc keeps returning null no matter what I try? It works when I remove the Multiply<> operator. Also if I just define the PXFormula<index1>.. I get a list of 2’s so the constant is fine also? Why cant I multiply the two!! using System;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data.WorkflowAPI;using PX.Objects.CM;using PX.Objects.Common.Attributes;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN;using PX.Objects.PO;using PX.Objects.SO;namespace AutoKitAssembly{ [Serializable] [PXCacheName("KitAssy_Sub2")] [PXProjection(typeof(Select2<INKitSpecStkDet, InnerJoin<KitAssy_Sub1,On<INKitSpecStkDet.kitInventoryID,Equal<KitAssy_Sub1.kitInventoryID>,And<INKitSpecStkDet.revisionID,Equal<KitAssy_Sub1.revisionID>>>>
Hello Community,Any idea how can I redirect the user to Acumatica’s landing page (Home ScreenID=00000000)?
Tenants Overview Multi-Tenancy and Customizations Multi-Tenancy and Set of Active Features IsActive method Features.xml File Custom Feature Checks DACs, Graphs and Extensions in Multi-Tenant InstanceThis post describes how DACs, Graphs and DAC/Graph extensions are applied to Acumatica sites with multiple tenants. The article attempts to answer when and why the code behavior depends on the tenant. Different factors are considered:Location of the code - is it Acumatica source code or customization. Presence of the IsActive method in DAC/Graph extension. Features.xml file. Custom checks for the feature switch in the business logic.It is easy to reason about instances with a single active tenant. There is no need to worry how the data is shared between active tenants, which entities will be available to which tenants. The things become more complex for multi tenant instances, especially, when the customizations are involved. This is why this article will focus on multi tenant instances
When we try to open/print the Sales Orders or Shipment confirmations, the website throws the following two errors. They both seem to be related to the same issue, but I’m not sure where to fix this issue. Any advice on how to fix?Error Log for Shipment ConfirmationError Log for Sales Orders
public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate baseMethod) { try { if (Base.Document.Current != null) { ARRegisterExt aRInvoiceExt = PXCache<ARRegister>.GetExtension<ARRegisterExt>(Base.Document.Current); if (aRInvoiceExt != null) { if (aRInvoiceExt.UsrWingAmount == null || aRInvoiceExt.UsrWingAmount != Base.Document.Current.CuryOrigDocAmt) { aRInvoiceExt.UsrWingAmount = Base.Document.Current.CuryOrigDocAmt; //Generation http url var client = new RestClient(); string imageUrl = "https://material.angular.io/assets/img/examples/shiba2.jpg"; var request = new RestRequest(imageUrl, Method.GET); by
When entering a Barcode value in the Inventory ID field on the Issues (IN302000) screen, the error raised:i tried to do a customization to add that feature by adding the AlternateID and the CrossItemAttribute using this code: public class INIssueEntryExtension : PXGraphExtension<PX.Objects.IN.INIssueEntry>{ [PXMergeAttributes(Method = MergeMethod.Append)] [CrossItem(Filterable = true, BqlField = typeof(INTran.inventoryID))] [PXDimensionSelector(InventoryAttribute.DimensionName, typeof(Search2<InventoryItem.inventoryID, LeftJoin<INItemXRef, On<INItemXRef.inventoryID, Equal<InventoryItem.inventoryID>>>>), typeof(InventoryItem.inventoryCD), typeof(INItemXRef.alternateID), typeof(InventoryItem.descr))] [PXUIField(DisplayName = "Inventory or Alternate ID")] protected virtual void _(Events.CacheAttached<INTran.inventoryID> e) { }}The AlternateID column succssefully appea
I'm working on a custom script to automatically update the external ID and description of an employee after the record is inserted into the Data Maps table for Type "Employees."I created a simple Inserted event to test the trigger, but I'm encountering an error.using System;using PX.Objects;using PX.Data;namespace MYOB.AdvancedLive.People.Objects.PP{ public class MPTimesheetDataMapMaint_Extension : PXGraphExtension<MYOB.AdvancedLive.People.Objects.PP.MPTimesheetDataMapMaint> { protected void DataMap_RowInserted(PXCache sender, PXRowInsertedEventArgs e) { PXTrace.WriteInformation("DataMap_RowInsertedevent triggered."); var datamap = e.Row; if (datamap == null) return; } }}
I’m trying to add a button to the Sales Orders list - S301000PL. I’ve defined the action in a Graph Extension and see it available as a ‘Graph Action’ on the Customization Project screen (SCREENS → SO301000 > Actions). The action is available on the drop-down panel on SO3010PL alongside the standard options.Clicking the action gives the error “At least one record hasn’t been processed”Trace gives:Autofac.Core.Registration.ComponentNotRegisteredExceptionThe requested service 'PX.Data.DacDescriptorGeneration.IDacDescriptorProvider' has not been registered. To avoid this exception, either register a component to provide the service, check for service registration using IsRegistered(), or use the ResolveOptional() method to resolve an optional dependencyI have set a breakpoint within the action handler, but it doesn’t get hit.The action is defined by this code: public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public override void I
On expense receipt screen we need customization.We need to add Customer and Customer Name for mobile app.(We can easily add Customer Name for web).But for mobile app. How can we add additional field.Original Acumatica Code:[PXDBInt][PXUIField(DisplayName = "Project/Contract")][PXDimensionSelector(ContractAttribute.DimensionName,typeof(Search2<Contract.contractID, LeftJoin<EPEmployeeContract,On<EPEmployeeContract.contractID, Equal<Contract.contractID>,And<EPEmployeeContract.employeeID, Equal<Current2<employeeID>>>>>, Where<Contract.isActive, Equal<True>, And<Contract.isCompleted, Equal<False>, And<Where<Contract.nonProject, Equal<True>, Or2<Where<Contract.baseType, Equal<CTPRType.contract>, And<FeatureInstalled<FeaturesSet.contractManagement>>>, Or<Contract.baseType, Equal<CTPRType.project>, And2<Where<Contract.visibleInEA, Equal<True>>, And2<Feat
I have created a custom screen which contains two grids in separate tabs. one grid is a read only grid. while other grid allows to CRUD operations. In this grid I use fully custom DAC. when I trying to insert data, even when insert correct values (not null) for each column sometimes it gives “cannot insert values to columns since null”. Even I set values after clicking save button it inserts an empty row as above.DAC:using System;using PX.Data;namespace EMPPlanningToolR4N5{ [Serializable] [PXCacheName("PTFillerReelWidths")] public class PTFillerReelWidths : IBqlTable { #region Width [PXDBInt(IsKey = true)] [PXUIField(DisplayName = "Width")] [PXDefault(0)] public virtual int? Width { get; set; } public abstract class width : PX.Data.BQL.BqlInt.Field<width> { } #endregion #region PaperTypeID [PXDBString(2, IsKey = true, IsFixed = true, InputMask = "")] [PXUIField(DisplayName = "Paper Type ID")] [PXDefault("##")] [PXSelector(typeof(PTPaperTyp
I have two custom fields Absolute Variance Quantity for rows and Total Absolute Variance Quantity in the header. I can get these fields to update via PI Review and Scan and Count just fine, but when I do an action such as Set Not Entered To Zero, the custom header field won’t update.Here, the only value that got send to the custom header field was the first line (21), but the header field should be close to 101,772Here is my code for the field definitions and this screen:INPIHeaderExt.usrTotalAbsVarQty[PXDBQuantity][PXDefault(TypeCode.Decimal, "0.00")][PXUIField(DisplayName = "Total Absolute Variance Qty.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]INPIDetailExt.usrAbsVarQty[PXDBQuantity()][PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)][PXFormula(null, typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )] Code Editor: INPIReview (Physical Inventory Review)using System;using System.Collections;using System.Collections.Generic;using System.L
Hi,In Live Instance,For a Grid(Form-Tabs screen) I am Trying to add around 30 lines.Up to 28 lines Data got Entered..When we are trying to Enter 29th line Getting Below ErrorThe Page was not displayed Because the Request Entity is too large. In our Local Instances we are not getting this type of Issue.What are the changes need to do to Solve this in Live Instance?How can I replicate this Issue in Local to debug the code?Thanks,Giri.
Hello, I can update an inventory item with the code below. I’m not suggesting it’s the best way but it works, the description is updated and saved to the database.public SelectFrom<InventoryItem>.View InventoryItemView;public PXAction<InventoryItem> UpdateItem;[PXButton][PXUIField(DisplayName = "Update Item")]public virtual IEnumerable updateItem(PXAdapter adapter){ List<InventoryItem> l = InventoryItemView.Select().RowCast<InventoryItem>().ToList<InventoryItem>(); InventoryItemView.Current = l.First(); InventoryItemView.Current.Descr = String.Concat(InventoryItemView.Current.Descr, "X"); InventoryItemView.UpdateCurrent(); InventoryItemView.Cache.Persist(PXDBOperation.Update); return adapter.Get();}Using the same method I can update a sales order line.public SelectFrom<SOLine>.View SOLineUpdateView;public PXAction<InventoryItem> UpdateSOLine;[PXButton][PXUIField(DisplayName = "Update SOLine")]public virtual IEnumerable updateSOLine(PXAdapter a
Hi Community,If I have edited a customization project, but I did not re-publish it back to the server, is there a way to export/ revert back to the original customization project published in a tenant? I made changes I wish to undo that are not in the server because I did not publish it after making changes. When I re-open the current existing project, the changes I don’t want are in the project. Thanks,RJ
HI All, I have a processing form built on the graph below, and so far, I can’t for the life of me get the Processing buttons to show. I’m wondering if this is due to the processing form running on a DAC with the PX Hidden attribute - have never tried this before, or am I missing something else? There is a View Delegate involved which takes data from a MASCCommissionDetail DAC which is persisted to the Database, and summarizes the data into a List of MASCProcessDetail. The form is shown below. This works exactly as required (except that there is no Process/Process All buttons visible)The MASCProcessDetail DAC is marked with the PXHidden attribute: Essentially what I’m trying to do, isSummarise all the data in MASCCommissionDetail into MASCProcessDetail. There is a many to one relationship between MASCCommissionDetail (many) and MASCProcess Detail (one), and when the processing form runs create one record in APInvoice for each MASCProcessDetail record. (I know how to do this part
Hello!I’m trying to edit a report, but when I clicked on the “Edit report” button instead of downloading, it just sends me to a screen called “report definitions”Can I get some help? Really appreciate your answers, thanks
Hi Everyone,I’m creating a processing form to process SOLines based on some functionality, a part of the code is to set the Line note for each SOLine. i tried joining the SOLine to Note table on NoteID. and tried a second way to update the Note table on the database: var note = PXSelect<Note, Where<Note.noteID, Equal<Required<Note.noteID>>>> .Select(graph, soLine.NoteID) .FirstOrDefault()?.GetItem<Note>();var lineNoteText = "...........";note.NoteText = lineNoteText;a “Null Object reference” raised for the note variable. so i thought to use the seconde one: PXDatabase.Update<Note>( new PXDataFieldAssign<Note.noteText>(lineNoteText), new PXDataFieldRestrict<Note.noteID>(soLine.NoteID) );none of them worked…any thoughts?
When referencing an email address in a notification message, is it possible to use a mailto: link in the message? If I use mailto: in a link in the richtext visual mode, it prepends an http:// in front of it when saved. If I edit as html, it removes the mailto: when saved.
I have 2 Field Attribute Custom: Name and Short Description (using customization Project).On the Import Scenarios page, I added the mapping to 2 Fields Name and Short DescriptionAt Data providers I also added 2 fieldsHowever, I use Import by Scenario to import my items into stock items.Then the Import items successfully but the two Field Attribute Custom are Name and Short Description it is null. I don't know if I was wrong or where the config was missing? But my Attribute Custom Fields cannot set Value?
Is there a simple way I can display the default vendor remit-to address to show on the bills and payments screen? I’ve checked and the RemittanceAddress view does not appear in the Data View dropdown under Add Data Fields tab in screen editor.
Hello Community, I was looking for a way to default the shipment quantity to 0 when creating the “Create Shipment” button on Sales Order or from the Process Orders screen. I thought I could just extend the “CreateShipment” method to accomplish this but not having much luck. See below for the code I have. Is there possibly a setting in Acumatica for this I missed or an issue with the code below? public delegate void CreateShipmentDelegate(CreateShipmentArgs args); [PXOverride] public void CreateShipment(CreateShipmentArgs args, CreateShipmentDelegate baseMethod) { // Call the original method to ensure default behavior baseMethod(args); Base.Transactions.Current.BaseQty = 0; Base.Transactions.Current.Qty = 0; Base.Transactions.Current.ShippedQty = 0; Base.Transactions.Current.BaseShippedQty = 0; Base.splits.Current.Qty = 0; Base.splits.Current.BaseQty = 0; Base.Transact
For one of our projects, we set a single value to be selected from a box. However the box is still defaulting to one of the old value that we removed. I’m trying to have it default to the constant defined below, but everything I’ve tried either hasn’t worked or crashed the customization. Any way to set a default value for this box?public class custClass : PX.Data.BQL.BqlString.Constant<custClass>{ public custClass() : base("SB") { }}[PXDBString(2, IsKey = true, IsFixed = true, InputMask=">aa")][PXDefault(SOOrderTypeConstants.SalesOrder, typeof(SOSetup.defaultOrderType))] [PXSelector(typeof(Search2<SOOrderType.orderType, InnerJoin<SOOrderTypeOperation, On2<SOOrderTypeOperation.FK.OrderType, And<SOOrderTypeOperation.operation, Equal<SOOrderType.defaultOperation>>>>, Where<FeatureInstalled<FeaturesSet.inventory>.Or<SOOrderType.behavior.IsNotEqual<SOBehavior.bL>>>>))] [PXRestrictor(typeof(
Good day,In Bills and adjustments I added a custom field in which I want that if it has any value it is considered for the calculation of the cash discount, at first I thought it could work to add the field into Terms since in another project I did something similar and it worked, but now it doesn't do anything, and in the Business logic I can't find a method or event that has the specific formula or instruction to calculate the cash discount when doing a prepayment.Is it possible to override the cash discount calculation? public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry>{ [PXNonInstantiatedExtension] public class AP_APInvoice_ExistingColumn : PXCacheExtension<PX.Objects.AP.APInvoice> { #region TermsID [PXMergeAttributes(Method = MergeMethod.Merge)] [PXUIField(DisplayName = "Terms", Visibility = PXUIVisibility.Visible)] [APTermsSelector] [Terms(typeof(APInvoice.docDate),
I’m trying to turn OrderType from a selector of every order type to just certain order types for our customer portal. I’ve been trying to change it to ComboBox since those options can be changed, but every time I save the Screen Editor, it goes back to Selector. What would be the best way to go about this?OrderType
We would like to create a customization that takes the output of a given screen (let’s assume sales quote or estimate) and have it export a customized excel spreadsheet with that information.In our use case, we need to have several tabs in the exported file pre-defined (sort of like a template) and on one of the tabs the data from the screen being exported needs to be formatted a particular way (sor of like a stylesheet).I had thought about using a report as an intermediate step (where you have a little bit more control over the excel export) but I’m unaware of a way to have that result in multiple tabs. (incidentally, is there a way to “style” the exported cells from a report?)Thanks
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.