Develop Customizations

Hello everyone! I have a question, I recently had to update my custom code, but I saw that the PXLongOperation.SetCurrentItem method was removed in Acuamtica 2023 R1. Does anyone know what I'll have to do or if the method has another implementation?Any help would be appreciated :) Thank you so much for your attention!

Hello All,I am adding a restrictor to ProjectID as follows:[PXRestrictor( typeof(Where<PMProject.defaultBranchID.IsInSubselect<SelectFrom<PX.SM.UserPreferences> .Where<PX.SM.UserPreferences.userID.IsEqual<AccessInfo.userID.FromCurrent>> .SearchFor<PX.SM.UserPreferences.defBranchID>>>), "Invalid Project")]The Selector works fine and shows the desired list but when I select a project from the list which is valid, the field does not hold the value and it clears it out. I checked the SQL query for the Selector and it is fine as well and returns the desired ResultSet. Any idea what is happening on the interface? 

Hi guys!,I have a question. I am using the check and payment module, at launch I make GL insert a new line in addition to the existing one, and I have customized the GL screen and within it. I am using the public void Persist(PersistDelegate baseMethod) method and adding code to insert a new line in the GL details.However, when I put the interrupt point I see that it enters many times.Could you please tell me which event or method should I use and which is efficient?.         public delegate void PersistDelegate();        [PXOverride]        public void Persist(PersistDelegate baseMethod)        {            Batch batch = Base.BatchModule.Current;            GLTran gL = Base.GLTranModuleBatNbr.Current;            CurrencyInfo curren = Base.currencyinfo.Current;             string TBienServ = string.Empty; decimal? detra = 0m; decimal? changetype = 0;            if (batch != null && batch.AutoReverseCopy == false && batch.OrigBatchNbr == null)            {               

 Hi, I have spent a few hours trying to work out how to programmatically add lines to Bills and adjustments and get the totals and taxes to correctly calculate on the header.  The below shows a bill where the single line for $150 has been added programmatically.   Note that the totals in the header are all Zero.  The below is what a manually keyed bill looks like with the same record (ie the answer I’m trying to get to)A few comments on the first screen shot where the line has been programmatically added:The totals in the header appear to be incrementally calculating.  For example if I change the price on the line from $150 to $160, the total shows the net difference from the original line addedThere is no Tax detailIf I manually add a record here the taxes appear in the header correctly calculated (but the Detail Total and Balance is still incorrect)I have tried programmatically adding record into APTaxTran before and after APTran but thus far have been unable to get the Bill to funct

I need to show an error message when unit price is 0  in sales order line details.User can upload the sales order line details from excel into sales order screen and according to the inventory item unit price is automatically capture from arsales form.I add fieldverifing event below like that.protected void SOLine_CuryUnitPrice_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e, PXFieldVerifying baseMethod) { SOLine row = e.Row as SOLine; if (row.CuryUnitPrice == 0) { throw new PXSetPropertyException("Unit Price should not be 0"); } }After uploading so line from excel ,If condition is true or false error message is shown. 

Hi,I have a third party rest api to get bank details. When calling the API it response is json format.I need to add response details into my sales order screen.In SOOrderEntry Graph extension I have created a action and calling the API below like that.public PXAction<SOOrder> MyAction; [PXUIField(DisplayName = "ADD ORDER", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton(CommitChanges = true)] public virtual IEnumerable myAction(PXAdapter adapter) { var URL = "https://sandbox.corporate-api.hsbc.com/mock/v2/transactions"; var httpRequest = (HttpWebRequest)WebRequest.Create(URL); httpRequest.Method = "POST"; httpRequest.ContentLength = 0; var httpResponse = (HttpWebResponse)httpRequest.GetResponse(); SOOrder order = Base.Document.Current; order.OrderDesc = httpResponse.StatusCode.ToString(); return adapter.Get(); }When

On my processing page, I have a filter to select based on an inventory item.It is working and selecting rows for my grid using this BQL public PXFilteredProcessingJoin<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>, Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>, And<SOLine.completed, Equal<False>, And<SOLine.openQty, Greater<decimal0>, And<SOOrder.status, Equal<SOOrderStatus.open>>>>>> SOLinesToUpdate;I want to add OrderBy so that the lines are displayed in order by Sales Order Nbr, Line Nbr.This is the BQL I cannot get to compile public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>, Where<SOLine.inventoryID, Equal<RecordsToProcessFilter.inventoryID.FromCurrent>, And<SOLine.completed, Equal<False&g

Hi,I need to add new field name as ‘Claim Percentage’ into sales order invoice screen. And when the claim Percentage is entered Invoice Amount need to be calculated like below formula.amount = unit price * qty * (claim Percentage/100)I have add fieldUpdated event into SOInvoiceEntry screen. protected void ARTran_UsrClaimPercentage_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (ARTran)e.Row; ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row); decimal? val1 =detail.UsrClaimPercentage/100; decimal? val = row.CuryTranAmt*val1; row.CuryTranAmt = val; // cache.SetValueExt<ARTran.curyTranAmt>(row, val); }When adding the claim Percentage at 1st time formula is working properly.But, after that when changing the same field Amount calculation is wrong.1st change 2nd change for same row same field.Amount need to 25   Why This is happened? 

Hi all, I want to show detail lines horizontally in a report. How can I do it.  

This comes up from time to time. Acumatica will throw an error (popping up an error box). It is usually on the "MoveNext" command, but it sometimes happens in other events. But when I attach VS2022 to the IIS app, it never throws an error inside of my debugger, so I can't see where the problem is.This is the latest example of this...First this is the C# Extension code:public class OpportunityMaint_Extension : PXGraphExtension<OpportunityMaint>{ internal CurrentCostingInfo currentCostingInfo = null; public static bool IsActive() { return true; } protected virtual void _(Events.RowSelecting<CROpportunity> e, PXRowSelecting InvokeBaseHandler) { if (e.Row == null) return; var row = e.Row as CROpportunity; if (UseMarkupInsteadOfMargin == null || !UseMarkupInsteadOfMargin.HasValue) UseMarkupInsteadOfMargin = false; SetDisplayFor_MarkUpOrMargin("CROpportunity", UseMarkupInsteadOfMargin, e.Cache);

 I am trying to add currency conversion from base to selected currency but cant seem to put the pieces together. I am able to save the base currency but the conversions is not working. What am I missing? The DACclass GTItems {         #region CuryInfoID        [PXDBLong]        [CurrencyInfo]        public virtual long? CuryInfoID { get; set; }        public abstract class curyInfoID : PX.Data.BQL.BqlLong.Field<curyInfoID> { }        #endregion        #region ItemAmt        [PXDBBaseCury]        [PXDefault(TypeCode.Decimal, "0.0")]        public virtual Decimal? ItemAmt { get; set; }        public abstract class ItemAmt : PX.Data.BQL.BqlDecimal.Field<ItemAmt> { }        #endregion        #region CuryItemAmt        [PXUIField(DisplayName = "Item Amount", Enabled = false, Visibility = PXUIVisibility.Visible)]        [PXDBCurrency(typeof(curyInfoID), typeof(ItemAmt))]        [PXDefault(TypeCode.Decimal, "0.0")]        public virtual Decimal? CuryItemAmt { get; set; }        pu

Hi all,I want to attach a report pdf to files section of an invoice. I tried the below code snippet. It works for a single invoice only. But when we process multiple invoices from Process Invoices screen, file is attaching only for first invoice. For other invoices, file is not attaching.Any idea about fixing this?public delegate IEnumerable ReleaseDelegate(PXAdapter adapter);[PXOverride]public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod){ foreach(ARInvoice invoice in adapter.Get<ARInvoice>()) { //Report Paramenters Dictionary<String, String> parameters = new Dictionary<String, String>(); parameters["ARInvoice.DocType"] = invoice.DocType; parameters["ARInvoice.RefNbr"] = invoice.RefNbr; PXReportSettings settings = new PXReportSettings("AR641000"); //Report Processing PX.Reports.Controls.Report report = ReportLoader.CheckIfNull(nameof(ReportLoader)).LoadReport("AR641000", null); ReportL

Hi,I have a custom description field sitting in the Projects screen that is replacing the original Description field. This is because I needed the field to support a larger amount of characters for reports and I wasn’t able to achieve the correct result with the original description field sinc the reports would grab the original length the Description field rather than the new length. Back to the main issue, when invoices are generated, the Transaction Description is grabbing content from the original Description field, but I would like this to come from the new custom description field I created. I have tried something like the below to achieve this, but I can’t seem to get it working. I am trying to match an invoice line from the grid with the relevant project task in the Projects screen so that I can transfer the the content from the custom field to the invoice field. What would you recommend to achieve this? I should note that this customisation is be published against the Invoices

Hi,There is a requirement which is to remove quote type  ‘sales quote’ and show only ‘project quote’ in the create new quote pop-up screen when clicked on create quote button of opportunities. Screenshot is attached for the reference.show only the ‘project quote’Could this be done using customization project editor?Thank you.

I have created a custom bool field on SOOrder.   #region UsrFreightRecovered [PXDBBool] [PXUIField(DisplayName = "Freight Recovered")] [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)] public bool? UsrFreightRecovered { get; set; } public abstract class usrFreightRecovered : PX.Data.BQL.BqlBool.Field<usrFreightRecovered> { } #endregionThis field indicates that freight charges are to be handled in a non-standard way. I need to present the fact that the custom field is true on the invoice header. From reading here, and attempting to code this, it seems that I have to pass the value to ARTran. The field needs to be immutable on the invoice, so I added it as a non-persisted string. I want to mark the value as true in the invoice header if any ARTran line has the value as true.I am at a loss at this point. I have no idea how to access the the Order Nbr field for each detail line in order to look up the custom field val

Hello Everyone!So I am getting this error in the Sales Order Entry Screen, S0301000 Now regarding the customization mentioned here, This is the Previous Version:  and after deciding to do some refactoring I decided to move this DAC away from PurchaseOrders to a new customization HSCatQuota, with the following DAC:HSCatQuotaAlso I removed the dac and the associated graphs in PurchaseOrders, after the refactoring.  Now I added the dependencies to the previous PurchaseOrders customization using the add from dependency, from the bin, I can build the solution but can’t create a new Sales Order. Is there something I might be missing, during these step?I even checked in my other customizations ,and nowhere is the PurchaseOrders namespace being used. Thanks,Jugraj  

Hi there, I have tried the steps shown here to attempt passing the value of the custom fields from Requisitions over to the custom fields in Purchase Orders screen when Create Orders button is clicked. However, the custom fields in the created Purchase Order remain blank. Below is the DAC for both RQRequisitionLine and POLine:RQRequisitionLine [PXDBString(50)] [PXUIField(DisplayName = "Tax Purpose")] public virtual string UsrTaxPurpose { get; set; } public abstract class usrTaxPurpose : PX.Data.BQL.BqlString.Field<usrTaxPurpose> { } #endregion #region UsrProjectNo [PXDBString(50)] [PXUIField(DisplayName = "Project No")] public virtual string UsrProjectNo { get; set; } public abstract class usrProjectNo : PX.Data.BQL.BqlString.Field<usrProjectNo> { } #endregion #region UsrCategory [PXDBString(50)] [PXUIField(DisplayName = "Category")] public virtual string UsrCategory { g

We are trying to a a new data field to a shipping line to capture a unique product number other than serial number at time of shipment.  We add to the grid, and receive this error when publishing.  Can anyone assist?  What do we need to look for to correct this error?[2023-06-30 17:21:13.830] \App_RuntimeCode\PX_Objects_SO_SOShipLineSplit_extensions.cs(1): error CS0246: The type or namespace name 'Data' could not be found (are you missing a using directive or an assembly reference?)

I need to customize the Lead's “Convert to Opportunity” Action (convertToOpportunityAll) to map the Lead Class to the Opportunity Class and then als the related attributes.I’m trying to create a LeadMaint Graph Extension in a Customization project in 2022 R2.Problems:1. When I try to Inspect the Element for the convertToOpportunityAll Action Button and click ACTIONS and choose CUSTOMIZE BUSINESS LOGIC it creates a Code file like this:using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.AR;using PX.Objects.CR.Extensions.CRDuplicateEntities;using PX.Objects.CR.Extensions.SideBySideComparison;using PX.Objects.CR.Extensions.SideBySideComparison.Merge;using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Threading.Tasks;using PX.Objects;using PX.Objects.CR;namespace PX.Objects.CR{  public class LeadMaint_Extension : PXGraphExtension<PX.Objects.CR.LeadMaint>  {    #region Event Handlers    #endregion  }}but when I click OVER

I am trying to add Vendor Class to AP.30.10.PL - but I am getting no values to appear in the column after I have added to the RESULTS tab.I have tried JOINs from APInvoice.BAccount to DACs: BAccount, VendorR, and Vendor to get the column to populate; but I have had no success.Any guidance on what I am missing?Thank you in advance for any tips.   

I have a custom maintenance screen that has a form and a grid.  The form is attached to one table (ICSPricingHeader table).  When I insert a record in the grid, I want to default the PriceClassID field in the grid (ICSPricingINItemClass) to default to the value in the header table.  In the screen below, I am showng the PriceClassID on the grid just so I can verify the value in the field is populated.When I click the plus sign, the PriceClassID is not being filled in.  If I try to save the record, I get a “you didn’t provide a priceclassid” error.In my child table DAC, I have the following code that I think should be putting the Price Class ID from the top of the form into the table (cache). #region PriceClassID [PXDBString(10, IsUnicode = true, IsKey = true)] [PXDefault(typeof(ICSPricingHeader.priceClassID.FromCurrent))] public virtual string PriceClassID { get; set; } public abstract class priceClassID : PX.Data.BQL.BqlString.Field<priceClassID> { } #endregionThe PXDefault

I have added custom fields in the opportunity Details TAB.I need to propagate those custom fields to the Quotes screen when Opportunity is converted to Quote.How can we achieve that by overriding the Action ?Thanks

Hi,How I can override the CorrectInvoice action from the Correction graph extension?I’m using this code, but the page give me an error.public class Test : Correction { public static bool IsActive() { return true; } public override void Initialize() { base.Initialize(); } public override IEnumerable CorrectInvoice(PXAdapter adapter) { return base.CorrectInvoice(adapter); } }Error[ArgumentNullException: Value cannot be null.Parameter name: key] System.ThrowHelper.ThrowArgumentNullException(ExceptionArgument argument) +52 System.Collections.Generic.Dictionary`2.FindEntry(TKey key) +14244583 System.Collections.Generic.Dictionary`2.TryGetValue(TKey key, TValue& value) +21 PX.Web.UI.WebApi.Services.QPToolBarDataProvider.GetActionsSource(PXGraph graph, Boolean isPopupOn, Boolean popupInline, IScreenCommandsCustomInfo screenCommandsCustomInfo) +1495 PX.Web.UI.PXBaseDataSource.Get

Hi Team,In version 2020R2 we have override the “ActionDelegate” method in SOShipmentEntry Graph. Now we are upgarding to version 2022R2. I could see this method is available in the latest.Could you please let me know how i can resolve this. Regards,Ramya Krishna

Hi All, Can you help to figure out why the option - Publish to multiple tenants is not enabled?I can’t find any permission issue that would set it off. When I publish from one tenant some changes like the ones on the screen is added to other tenants as well. Basically other tenants do get a half baked customisation. As a workaround I exported and imported the same customisation to all tenants and published individually. Is this okay to do? I also have one variable value that needs to be changed in Production tenant only. So I am thinking to change that value in production customisation and publish in production.  Am I doing this right or can there be any implications?  Thank you very much!