Develop Customizations

In Sales Order Entry, the header SOOrder.OrderQty is SumCalc by the SOLine.OrderQty. I changed the SOLine.OrderQty in the SOLine_RowUpdated event by:      cache.SetValueExt<SOLine.orderQty>(row, newValue); The line quantity did change to the new value, but the header SOOrder.OrderQty still keep the old value. I added another statement:     PXUnboundFormulaAttribute.CalcAggregate<SOLine.orderQty>(cache, row);But still no change. Am I missing something? Thanks,

Hello,I try to create a custom PXSelector reference field in my CRCase (Servicetickets). I want to set a SalesOrder SOOrderEntry as reference field with a selector.Exactly like the green box but as new field with SOOrder to select.currently i created a new string field.every attempt to use a PXSelector with SOOrderEntry fails due to not set references. SOOrderEntry does just not exist in this scope.CRCase simply has no region for SoOrderIDBest case would be an automaticly set reference in the corresponding order aswellhow can I add the reference and region for SoOrderID and what would be the best approach? best regards

Hi,How can I put “Not provided” in notification template if the value is empty for the data field in body? 

I have made a custom action that I want to execute when shipment is confirmed.I have tried to extend the workflow and add the new action as auto run true. https://community.acumatica.com/topic/show?tid=10301&fid=288 I have followed above reference.I have also added condition after using True and IsConfirmed which were not executing my method.ConditionWorkflowAny thoughts on this ??

Hi,We have created two custom fields to get invoice numbers. These fields are not visible in the UAT environment but are visible in the production environment.  When I move the field to a different column, this happens.  But these fields remain visible in the Production environment even after we publish this customization project to Production. does anyone know what causes this and how to fix this?Thank you.

My customize code working fine but when we use software more a week, this block of code stop working. But if we restart IIS service, it start working gain. Could you advice how to do it 

Hello, I would like to create a processing screen which will check a group of invoices, if an invoice has a file attached then the files will be added to a zip file. The user will download the zip file. I’ve found a document which explains how to use zip files in Acumatica, link below:https://www.acumatica.com/blog/zipped-up-acumatica-manipulating-files-part-1-zip/It suggests using an object called ZipArchive in the following way using (ZipArchive zip = ZipArchive.CreateFrom(zipStream, false)){ using (MemoryStream fileStream = new MemoryStream()) { fileStream.Seek(0, SeekOrigin.Begin); file.Write(fileStream); fileStream.Seek(0, SeekOrigin.Begin); zip.AddFile(fileName, fileStream.ToArray()); }}I cannot find the ZipArchive type, does anyone know which references and/or ‘using’ statements is required?The article suggests using PX.Common.Std, I have a reference to this file but I still cannot access ZipArchive.Thanks

Good day, everyone.We customized a requisition (RQ302000) screen Ref Nbr. Selector to load data based on a logged in user's user role.The selector worked fine when there were few records, but now we have thousands of records and every field on the screen takes time to update the value because of this custom selector.The code for the custom selector is shown below. What is the best way to avoid this performance problem, and what changes should we make to this custom selector? public class RequisitionEntryRQNbrExt : PXGraphExtension<RQRequisitionEntry> { #region Ref nbr attribute override [PXMergeAttributes(Method = MergeMethod.Append)] [PXRemoveBaseAttribute(typeof(PXSelectorAttribute))] [RQRequisitionRestrictExt] protected virtual void RQRequisition_ReqNbr_CacheAttached(PXCache cache) { } public class RQRequisitionRestrictExt : PXCustomSelectorAttribute { public RQRequisitionRestrictExt()

Hi,I need to know from where and how data is populated to the following attached screen. Can someone please help me out?  Here, Tax Agency is a customized one for me. Thanks.Bhagya

What’s the best practice for adding fields to my own custom table after the customization has been published?Should I create an extension for my own table or can I generate a script to update the table as if the fields had always been there?

Hello Everyone, can anyone found any difference between 2022R2 and 2023R2 Customization. if so can you provide the details...

I am trying to add address fields to the Location selector on the Opportunities screen.I copied the code from Sergey’s blog at https://asiablog.acumatica.com/2015/10/customizing-selector-attributes.htmlFrom the blog, the code is like this: #region CustomerLocationID public abstract class customerLocationID : PX.Data.IBqlField { } [PXMergeAttributesAttribute(Method = MergeMethod.Merge)] [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.Location.locationCD), typeof(PX.Objects.CR.Location.descr), typeof(PX.Objects.CR.Address.addressLine1))] [LocationID(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<Location.isActive, Equal<True>, And<MatchWithBranch<Location.cBranchID>>>>), typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), DescriptionField = typeof(Location.descr), Visibility = PXUIVisibility.SelectorVisible)] public int? CustomerLocationID { get; set;

Hi Team,How I can ignore the standard Validation error during the release Process. Could you please help me on this.  GL Error: Cash account doesn't exist for this branch, account and sub account (PRODWHOLE , 10200, 000FIN) Regards,Ramya Krishna

This should be simple.  I have a custom dialog with some data fields, and an OK button.  I want the OK button to perform a save of the fields as well as other processing.  I’ve tried many things, but so far, my OK button doesn’t perform my associated code.  I defined a new dialog within the page editor.  I added an action button that appears on the menu, and it opens my dialog just fine via button command delegate method and the AskExt() method of the view.  But my OK button just closes the dialog and seemingly does nothing else.  I have tried setting breakpoints after the OK is returned:if (view.AskExt("viewPanel", true) == WebDialogResult.OK){ // other code here, with a breakpoint}else{ // other code here, with a breakpoint{and no breakpoints are hit.  I also set the dialog button’s AutoCallback command to a custom method with a breakpoint.  I tried a method signature of both protected void <method>() that matches a button action delegate and a public IEnumerable <meth

I am trying to open the Inventory Summary screen with a PXRedirect and pass a parameter for the Inventory ID.Dictionary<string, int> parameters = new Dictionary<string, int>();var baseGraph = PXGraph.CreateInstance<InventorySummaryEnq>();//hard coded for testing//14998 = Inventory CD "1007"parameters.Add("InventoryID", 14998);throw new PXRedirectRequiredException(baseGraph, "Inventory Summary", parameters) { Mode = PXBaseRedirectException.WindowMode.Layer };The Mode = part is because I am populating a side panel.  Since I am opening the Inventory Summary screen via Javascript from an SO Line detail, I cannot do this from a standard Side Panel.The Inventory Summary screen opens in the Side Panel, but the Inventory ID field is not being populated.One option to get the data and display it in a side panel using a GI.  But there are over 2000 lines of code in the Inventory Summary graph to calculate the values displayed on that screen.  I don’t think that is an option.Is t

     public PXFilteredProcessingJoin<TSFixedDemand, TSProductionOrdersCreateFilter,         InnerJoin<InventoryItem,     On<InventoryItem.inventoryID, Equal<TSFixedDemand.inventoryID>>, LeftJoin<SOOrder,     On<SOOrder.noteID, Equal<TSFixedDemand.refNoteID>>, LeftJoin<SOLineSplit,     On<SOLineSplit.planID, Equal<TSFixedDemand.planID>>, LeftJoin<SOLine,     On<SOLine.orderType, Equal<SOLineSplit.orderType>,     And<SOLine.orderNbr, Equal<SOLineSplit.orderNbr>,     And<SOLine.lineNbr, Equal<SOLineSplit.lineNbr>>>>, LeftJoin<INItemClass,     On<INItemClass.itemClassID, Equal<InventoryItem.itemClassID>>, LeftJoin<SOOrderType,     On<SOOrderType.orderType, Equal<SOOrder.orderType>>, LeftJoin<TSProdFormulaMTranSplit, On<TSProdFormulaMTranSplit.planID, Equal<TSFixedDemand.planID>>   , LeftJoin<TSProdBOMMtranSplit, On<TSProdBOMMtranSplit.planID, Equal<TS

var openSalesOrders = SelectFrom<SOLine> .InnerJoin<SOOrder>.On<SOLine.orderNbr.IsEqual<SOOrder.orderNbr> .And<SOOrder.orderType.IsEqual<SOLine.orderType>>> .InnerJoin<InventoryItem>.On<SOLine.inventoryID.IsEqual<InventoryItem.inventoryID>> .InnerJoin<INItemClass>.On<InventoryItem.itemClassID.IsEqual<INItemClass.itemClassID>> .Where<INItemClass.itemClassCD.IsEqual<@P.AsString> .And<SOLine.openQty.IsGreater<Zero>> .And<SOLine.operation.IsEqual<@P.AsString>>> .View.Select(this, "811", "I");Is there a way to add a GroupBy to the above query to group and sum all sales order lines by Month & Year?Coming from Python and Django in particular, something similar to Trunc is what I am looking to do.Does BQL offer anything similar?

When I create a generic inquiry, I am able to modify the order of columns in that inquiry. Is this information stored in the database? Thank You,Abhijit

Hi All,I need to add a condition to release from hold to unhold event. Based on the condition need to block transferring to unhold status.Can someone help me to achieve this?ThanksBhagya  

Hello All,I am trying to retrieve data using OData V4 but I get the error in the subject line. Everything is on my local machine and works with OData V3. Any help is appreciated why does V3 work but not V4?

Hi Team,I have upgraded my REST API code from 2022R1 to 2023 R2. As per latest RESTSharp DLL I have modified the code and able to compile. but I’m not getting response for my Asynchronous GET Method.Below is the code and Error message for your reference. Please help me to rectify this issue.Error Message: Object Reference Error.  Regards,Ramya Krishna

The Sales Quotes screen has an option to ‘Convert To Order’. This option pops up the screen below and when you click Create And Review, the system creates a sales order based on the sales quote and uses ‘throw new PXRedirectRequiredException(docgraph, "");’ to direct the user to the sales order screen.Below is the sales orders screen, the important point is that the sales order has not been saved to the database at this point. The user has to click save to persist the info to the database.At the point of saving the sales order I want to create a purchase order (I won’t explain why). It’s important that the purchase order isn’t created unless the sales order is saved. I was going to create a POOrderEntry graph in the RowPersisting event but this results in error PX1045, as shown below. I cannot figure out where I can place my code in the SOEntry graph without the use of an event, which isn’t allowed. I wondered whether the call of PXRedirectRequiredException might provide a method I cou

Hi,Im trying to run tests for acumatica test sdk. I was able to make login into acumatica instance with code but code crashes when I try to open Sales Order screen with OpenScreen function. The issue isOpenQA.Selenium.WebDriverException: 'javascript error: window.__siteMap.Workspaces is not iterable      (Session info: chrome=119.0.6045.105)'

Is it possible to add form-specific descriptions for custom fields added as extensions of existing DAC and custom screens? I can extend the wiki page for an existing screen but it looks like I cannot include a single wiki page as part of the customisation and captions are not linked to a specific field, they just show as part of the page help menu and no question mark is associated to  the custom field.If someone could point me in the right direction it would be appreciated.Thank you  

I try complete bidding screen some can complete and some cannot compete. No error popup or in trace log. How to know log error beside trace log ?