Develop Customizations

How can I modify the list of Termination Reasons under Employees > Employment History ?

I am embarking on the journey to begin learning the new UI and migrating my customizations to it.I only have VS 2022 installed.  When I was installing Node.js, it shows that it is trying to modify the VS 2019 installer.  There were errors in the Node.js install.  Do I have to do this in VS 2019?  I don’t want to install it if I don’t have to.Has anyone begun this journey?  I have never worked with TypeScript etc..

I’m modifying the pick list to have Qty Orders, Qty already Picked and Qty left to pick. I’m running into issues.=[SOLine.OrderQty] works for Qty Ordered.What fields would I use to show Qty Picked and Qty left to pick?I’ve tried various combinations of things to populate either value and they are coming up blank:=[SOShipLine.OpenOrderQty]=[SOShipLine.OpenQty]=[SOShipline.Qty]=([SOShipline.Qty]-[SOShipLine.OpenQty])=([SOShipline.Qty]-[SOShipLine.OpenOrderQty])=([SOShipline.OrigOrderQty]-[SOShipline.Qty])This is outside of the realm of acumatica support, so hopefully someone has some ideas on what I’m doing wrong. Denis  

Hello, I'm working on a query result that i-m adding conditions and joins in the view delegate and it's working, but I would like to append group by statements on the query, Is there a way to achieve this in the view delegate?

Hello everyone, I created a table with the following script.CREATE TABLE [dbo].[GDLFAVehicleDetails]( [CompanyId] [int] NOT NULL, [AssetId] [int] NOT NULL, [VehicleRegNo] [nvarchar](50) NOT NULL, /***other fields left out***/ CONSTRAINT [PK_GDLFAVehicleDetails] PRIMARY KEY CLUSTERED ( [CompanyId] ASC, [AssetId] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY], CONSTRAINT [IX_GDLFAVehicleDetails_1] UNIQUE NONCLUSTERED ( [VehicleRegNo] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOI needed to make VehicleRegNo to accept only unique valuesso I added Iskey= true on the DAC as shown below;However when I add the Iskey=true value the user input disappears, when I remove it user input does not disappear on the UI and user is able to save the input entered.What could be the issue?  #region VehicleRegNo

Hello All,I have done action override a hundred times but I am facing an issue in Close Action of ServiceOrder that I am not sure why is happening. The problem is the "baseMethod" has a null value and as a result, I get an error that "An unhandled exception has occurred in the function 'MoveNext'. Please see the trace log for more details." Without this piece of customization, it is working just fine. Please note I have other stuff so that I am calling Base1 and Base2 in addition to the Base in my graph extension. Here is the part of the code relevant to the issue. Any help is appreciated.using System.Collections;using System.Collections.Generic;using System.Linq;using PX.Common;using PX.Data;using PX.Objects.FS;namespace Test{ public class MyServiceOrderEntryExt : PXGraphExtension<ServiceOrderEntryWorkflow, ServiceOrderEntryVisibilityRestriction, ServiceOrderEntry> { public static bool IsActive() => true; [PXOverride] public delegate IEnumerable Clo

I added a custom action to the Details grid of the Sales Quotes screen.  It works as expected.If the setup for my module is disabled, I am able to disable the button, but I cannot seem to hide it from view.These are the ASPX changes to add the button.  (added to the top of the form: <px:PXDSCallbackCommand Name="ResetPrice" Visible="false" CommitChanges="true" DependOnGrid="ProductsGrid" /></CallbackCommands> Toolbar button added in the grid seciton: <px:PXToolBarButton Text="Reset Price" Visible="False">    <AutoCallBack Target="ds" Command="ResetPrice">      <Behavior CommitChanges="True" /></AutoCallBack> In the RowSelected, I check if my module is enabled.  If it is not, I try to set the Visibility to false.            if (setup == null || (setup.EnablePricingMarkup == null || setup.EnablePricingMarkup == false) || (setup.UseQuotesOpportunities == null || setup.UseQuotesOpportunities == false))            {                PXUIFieldAttribute.SetVi

HelloI want to override Subaccount field of GLTran when it is generated by Release an payment (APPayment) by the rule: take first 2 parts of existing SubCD then concat with a “ABCD”.For example: if the Subaccount is 000-00000-0000, it should be replace by Subaccount 000-00000-ABCD.And I found that there is a case that I can’t find by calculated SubCD, so I need to create new Sub by calculated SubCD (000-00000-ABCD) then set GLTran.SubID to the created one.How to create new Sub in event RowInserting of GLTran? Is it possible?  p/s: I don’t want to use RowPersisting event because I wonder they could impact the performance when generating a bulk of GLTran but I’m not sure.Thanks

 I had to add new field into SO303000 screen Detail Grid.Field name - Claim Percentage When the above filed is updated or entered amount need to be calculated like below formula. Amount = Amount*(Claim Percentage/100)When add the claim percentage without discount amount, It's calculations are okey. In my case,After I have add the  quantity,unit price and discount amount , the Amount shows below like that. Then,I added the claim percentage. When I add the claim percentage, Discount Amount,Discount percentage and Amount all the fields are changed.Why this is happened and how I resolve this? Below I have attached my claim p field updated event. protected void ARTran_UsrClaimPercentage_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e)    {            var row = (ARTran)e.Row;      ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row);      if(detail.UsrClaimP == null || detail.UsrClaimP == 0){        decimal? val1 =detail.UsrClaimPercentage/100;        decimal? va

I have a custom field that is throwing the following error:Error: An error occurred during processing of the field PD Inches/SQIN: Specified cast is not valid..I have the following  #region UsrPDinches [PXDBInt] [PXUIField(DisplayName="PD Inches/SQIN")] public int? UsrPDinches { get; set; } public abstract class usrPDinches : PX.Data.BQL.BqlInt.Field<usrPDinches> { } #endregionWhat could be causing this issue?Another questtion,This field is on a production order. I can’t find how to disable the field when the production order status is completed. How do I do that?

Hello ,  I want to display green background color to the status field with font color as white in the sales order screen. I Followed Two methods for that, 1)Method 1: By using below code in  this i obtained colour for status value not in the background, i need background colour for the status field and letters are in white colour.             <px:PXDataSource>           <ClientEvents CommandPerformed="changeStatusColor" />       </px:PXDataSource> <script type="text/javascript">        function changeStatusColor(sender, e) {            var edStatus = px_all["ctl00_phF_form_t0_edStatus"];            var edStatusControl = document.getElementById("ctl00_phF_form_t0_edStatus");            if (edStatus && edStatus.value == "H")                edStatusControl.background.color = "#FF0000";            else                edStatusControl.style.color = "#00FF00";        }    </script>Method 2: Using this method, I received no updates to the field. in this ca

I have added a custom action to the Field Service > Appointment scree (FS300200) to Print Service Order. Everything is working fine with it, except it isn’t saving before navigating to the report.Is there a way to get the action to save the record before navigating to the new screen? How it is set up. 

Hi There, I have to print a Box label section depending on the field value entered. If the value entered is 2 then second section in report to print twice, but first section to print only once.can someone please help me?  

Can I Make Report Desainer Grup By Budget Code And Project ID , I will make Summry cost transakasi by Project ID and  Budget Code.This relasion one to many like this picture  And i need a Reprot like this : This a report view , total spending by budget code and spending by Project ID must not be the same this my gruping the report any one can help me ? make a report  

Hi Experts.I want enable field Subaccount in the below image.I try: PXUIFieldAttribute.SetEnabled<APTran.subID>(cache, row, true); and set enable in worflow:but it not work (I try this solution for Sales Orders screen SO301000 and success).Can you help me?Thank everyone so much.

I have a customization that has slowly had much of it moved to another DLL (for house keeping)How all it has left that matters is some Screen modifications (done in the ERP, not in code)Can I somehow combine that with another customization so I don’t need to maintain and publish both of them? I know I can export a GI or a dashboard and import it into something else. What about screen modifications?

I have a customization that generates an error when trying to bring up an opportunity.I get the error:Error: The entry form (ID: CR304000, title: Opportunities) cannot be automated. The view MultipleCustomersView doesn't exist. Or when trying to edit the SCREEN in the customization, I see this variation of the same error: The error (frustratingly) does not trip my debugger, so I don’t know exactly where this is happening.There is a MultipleCustomer class… but I don’t see a MultipleCustomerView anywhere in the C# code/Here’s the class: public class CRMultipleCustomer : IBqlTable { #region MultipleCustomerID [PXDBIdentity(IsKey = true)] public virtual int? MultipleCustomerID { get; set; } public abstract class multipleCustomerID : PX.Data.BQL.BqlInt.Field<multipleCustomerID> { } #endregion #region OpportunityID [PXDBString(15, IsUnicode = true)] [PXUIField(DisplayName = "Opportunity ID")] [PXParent(typeof(Select<

Hello ,I am trying to make performance improvements in Acumatica ERP by minimizing the data processing in the background. What can be the ways by which we can remove data older than 2 years? Not deleting it permanently but it should always remain accessible when required.

I am trying to change the default sort order of the details on Approve Bills for Payment. I’ve read these articles:acumatica - How to use OrderBy in a data view delegate - Stack Overflow acumatica - OrderBy in PXProjection Select does not work - Stack OverflowThe APApproveBills graph has a data view and a data view delegate, but according to the above articles, it seems like the following code should achieve what I need:namespace PX.Objects.AP{ public class APApproveBills_Extension : PXGraphExtension<PX.Objects.AP.APApproveBills> { public override void Initialize() { Base.APDocumentList.OrderByNew<OrderBy<Vendor.acctName.Asc>>(); } }}This does change the sort, but the result is not what I am expecting. Can someone explain why this is happening and/or how to fix it?

I’m creating a new form and it requires selecting a business account. so I have written the Code as follows in the DAC, #region BAccountID        [PXDBInt()]        [PXDefault()]        [PXUIField(DisplayName = "Business Account")]        [PXSelector(typeof(Search<BAccount.bAccountID>),            typeof(BAccount.acctCD),            typeof(BAccount.acctName)        )]    public virtual int? BAccountID { get; set; }    public abstract class bAccountID : PX.Data.BQL.BqlInt.Field<bAccountID> { }    #endregionwhen I’m entering the new record, it raised an error as follows, “Error: Inserting  'Customer Call' record raised at least one error. Please review the errors.”  But when I’m selecting another business account in the same form, I can save the data successfully. However, I can't save the data with the business account I initially chose and it raised an error like “Error: Updating  'Customer Call' record raised at least one error. Please review the errors.”how can I resolve

I have a problem when closing out an opportunity (OpportunityMaint) graph. It is giving the dreaded “Another process has added/updated/deleted the ‘{0}’ record. Your changes will be lost.”In the past I have handled this by simply using:PXTimeStampScope.SetRecordComesFirst(typeof(OpportunityMaint), true);But I can’t figure out how to override the Closed as Won method. In source code, it seems Acumatica is now adding a “workflow” class but extending the OpportunityMaint class:class OpportunityWorkflow : PX.Data.PXGraphExtension<OpportunityMaint>And within that, it defines the options for closing an opportunity:var formOpen = CreateForm("FormOpen", OpenReasons, OpportunityReason.Qualified); var formWon = CreateForm("FormWon", WonReasons); var formLost = CreateForm("FormLost", LostReasons); But I can’t override it. I tried creating this:   [PXOverride]        public void CloseAsWon(PXAdapter adapter, Action<PXAdapter> baseMethod)        {            using (PXTimeStampScope ts =

Hello, We are trying to create some customizations for our self-service portal, however we are not having luck getting the customization screen to load the screens objects. The screens are blank.Anyone had luck customizing self-help portal?  Acumatica 2020 R1Build 20.111.0017  

Hello!Mi instance is 22R2 and until now, conditionally enabling/disabling custom actions had been pretty easy.Usually I just use the SetEnable Method in a RowSelected event… Like this one here that I’m trying to use for a custom action in the SOInvoice screen: protected void _(Events.RowSelected<SOInvoice> e) { SOInvoice row = e.Row; if (row == null) return; itemSearch.SetEnabled(Base.Document.Current.CustomerID == null ? false : true); }The problem that I’m facing right now is that visually, the button remains “Enabled” at all times, while logically the button is disable until the user enters the customer:When the user clicks on the button without entering a Custmer. The condition works and the system display the alert: But the button remains visually enabled and my eye is twitching becouse of this!In the aspx I placed the button inside the actionbar like I have done with many other customizations:<ActionBar> <

Is it possible to send another “follow-up” email from a business event that will be put in the same thread with the original email when sent? I tried reply but it is sending a separate email: 

Hi all, I want to generate “Check form with remittance”(ap641000.rpx) Report Programmatically. But in the usual way, I was unable to do that as it has no key parameters. Schema Builder of the report - Parameters TabI used to do report generation in the following way. But I can not apply this approach here as there are no key parameters here. Is there any alternative approach of doing this?Dictionary<String, String> parameters = new Dictionary<String, String>();parameters["DocType"] = apInvoice.DocType;parameters["RefNbr"] = apInvoice.RefNbr;//Report ProcessingPXReportSettings settings = new PXReportSettings("MA105000");PX.Reports.Controls.Report report = ReportLoader.CheckIfNull(nameof(ReportLoader)).LoadReport("MA105000", null); ReportLoader.InitReportParameters(report, parameters, settings, false);PX.Reports.Data.ReportNode reportNode = ReportDataBinder.CheckIfNull(nameof(ReportDataBinder)).ProcessReportDataBinding(report);byte[] data = PX