Develop Customizations

Currently, we are displaying imagery in the SO Line items from image files that are uploaded into Acumatica. However, this is causing a great deal of performance issues and we are trying to figure out how to instead load these images from an external CDN HTTPS URL so that we can avoid all Acumatica related calls and server processing to display these images. In this scenario, we would be calling an AWS Cloudfront CDN URL that is completely separate from the Acumatica server.Does anyone have any advise as to how to best handle?

In Acumatica 2021r2, is it possible to hide/show Action buttons in the main toolbar based on conditions within the selected state? (I’m willing to use the Workflow Editor or by custom code, if that is possible.)Example scenario for Shipment Entry screen (SO302000):When the active state is Confirmed, I want to duplicate the Print Labels action as a button in the main toolbar, but only if labels haven't already been printed. The labelsPrinted boolean in the SOShipment DAC can be used for the conditional. But it does not appear that you can associate a conditional with the Duplicate on Toolbar checkbox.I still need to retain Print Labels as an option in the More (...) menu regardless of the labelsPrinted boolean within the same Confirmed state. It's possible labels need to be reprinted, but I don't want to give the action the same prominence in the toolbar if they have already been printed once.Can anyone point me in the right direction?

In Acumatica 2021R2, the long running process message is more visible and prominent. This is a welcome change. It was difficult to detect the small red and green icon in previous versions.In 21R2, the only way I’ve found to remove/hide this overlay is to click the close icon "X".I'd like to hide the success overlay via code after a specific event, for example, so the end user doesn’t have to manually click the “X” icon. Is there any way to hide or change this overlay programmatically? 

hi, i want to ask, what event handler can used to auto update otomatic value field after click order number ?Example :  after click this in GI field “Available Shipment” will auto update value “3” (formula: Quantity - kuota pengiriman)Thanks.

I am trying to grab the Default Warehouse field in Stock Items screen and insert it to BOM Material grid (Warehouse) as shown below: I tried overriding the field but failed to get the desired result by inserting the code is as shown below:using PX.Data.ReferentialIntegrity.Attributes;using PX.Objects.CM;using System.Collections;using PX.Data;using PX.Objects.IN;using System;using System.Collections.Generic;using System.Linq;using PX.Objects.AM.Attributes;using PX.Common;using PX.Objects.CS;using PX.Data.WorkflowAPI;using PX.Objects;using PX.Objects.AM;namespace PX.Objects.AM{ public class BOMMaint_Extension : PXGraphExtension<BOMMaint> { #region Event Handlers [PXDefault(typeof(Search<InventoryItemCurySettings.dfltSiteID, Where<InventoryItem.inventoryID, Equal<Current<AMBomMatl.inventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)] public abstract class siteID : PX.Data.BQL.BqlInt.Field<siteID> { } protected Int32? _Sit

Acumatica 2021R2MySQL 8.0(tested on 5.7 as well) When publishing this code, it publishes successfully but the database field doesn’t get created. What am I doing wrong?using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AM.Attributes;using PX.Objects.AM;using PX.Objects.IN;using PX.Objects;using System.Collections.Generic;using System;using PX.Objects.EP;using PX.Data.BQL;using PX.Objects.CS;namespace PX.Objects.AM{  public class AMWCExt : PXCacheExtension<AMWC>    {        //only enable this class if manufacturing is enabled        public static bool IsActive() { return PXAccess.FeatureInstalled<FeaturesSet.manufacturing>(); }        //WorkcenterEmployee field        #region UsrWorkcenterEmployee        //the acumatica database type is PXDBInt        [PXDBInt()]        //set the UI display name        [PXUIField(DisplayName = "Employee ID")]        //set the default value        [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]        //the

Hello, I’m attempting to mark the “Owner” field from the Financial Details > Assigned To, on the Bill and Adjustments screen in Accounts Payables required. I’ve created a customization project and tried a few different methods without any luck so far.First just a simple customization to set the “Required” property to True. Unfortunately I can still save and remove hold without the system flagging the issue. Also not getting a red asterisk next to the field. Next I added the owner field just underneath vendor as a new field. Set to true and still no luck. Lastly added the field to the “Fields” section in the tree for the customized screen but had no affect.  Guessing I’m missing a step, but not turning up to much in my google searches. Anyone have any ideas what I’ve missed? Thanks - Adam

Hi good night. I have a problem. I need to re-calculate the values ​​of the “Accumulated amount” column every time I make a change in any column of the grid (specially the colum TotalAmount). re-calculated de values and show in the grid.The business rule for the “Accumulated total amount” column is as follows:sum current row + previous row. (in the first row the previous row is zero).the result that I would expectI used this code in the row_updated event but it doesn't work as I expect. (This code is in the Row_Updated Event//In this code for each interaction 1 is added so if I have a grid with 4 rows in AccumulatedAmount //it should look like: 1,2,3,4 but it doesn't work int cont = 0; foreach (CEEstimateAddOn soLine in this.viewCEEstimateAddOn.Select()) { cont+=1; soLine.AccumulatedAmount = cont; }with the code above only the “edited/active” row show the result. and not in all rows as I needCould you please help me.

I am upgrading someone else’s code that is old.  When using Constant<string> or Constant<string[]> I get a warning that the syntax is obsolete.I fixed two of the classes, but I cannot figure out how to fix this onepublic class IDs : Constant<string[]>I was able to change Contant<string> in the “Open” class and the “Closed” class by using PX.Data.BQL.BqlString.Constant<Open> and PX.Data.BQL.BqlString.Constant<Closed>I just don’t know what the syntax is for changing Constant<string[]>. Here is the source code     public class FDSpecStatusAttribute : PXStringListAttribute    {        #region Constants        //public class Open : Constant<string>        public class Open : PX.Data.BQL.BqlString.Constant<Open>        {            public const string VALUE = "O";            public const string DISPLAY_NAME = "Open";            public Open() : base(Open.VALUE) { }        }        //public class Closed : Constant<string>        publi

I have a graph with a form that has two columns with one field each.One has hiphen in its DisplayName which causes the lable to be wrapped. As you can see the lables take different space, though the LableWith is set equally for both columns. <px:PXSelector LabelWidth="70" Width="120" runat="server" ID="CstPXTextEdit19" DataField="ShipFrom" ></px:PXSelector><px:PXSelector LabelWidth="70" Width="120" runat="server" ID="CstPXTextEdit20" DataField="ShipTo" ></px:PXSelector> What can I do to get a proper alignment?

when I create a custom screen by default I can enter only 2 digits after the decimal point how I can modify this parameter so that we have 3 digits after the decimal point

How can we open and have the values of the fields of a dialog box ?

Does anyone know how to add more space between 2 fields in a merge layout rule?  See from the screenshot below the add new button is being cutoff by the status field.  I have tried to adjust many properties but can’t seem to get the order type to overlap with the status field.  Thanks in advance.  

HelloRequirement: To Add Pop-up Notes from Customer Screen based on customer, to the Sales Order screen Pop-Up Note: window(in Enter Record Note not a separate window).I was able to add the Add PopUp note using Merge but I need to make it true and get the PopUp note from the Customer screen to my Note WindowI am getting a separate Window with the PopUp Note, I don’t want it.My Code looks like:SOOrderExt #region NoteID        [PXUniqueNote(            DescriptionField = typeof(SOOrder.customerID),            Selector = typeof(Search<BAccount.acctCD, Where<BAccount.bAccountID, Equal<SOOrder.customerID>>>),            ActivitiesCountByParent = true,            ShowInReferenceSelector = true,            PopupTextEnabled = true)]        public  Guid? NoteID        {            get;            set;        }        public new abstract class noteID : PX.Data.BQL.BqlGuid.Field<noteID> { }                #endregion Graph Extension:  public class SOOrderEntry_Extension : P

Hello Acumatica Friends :)  I have a question regarding the Update Inventory in Shipement. We want to do it with code for specific shipments (say a condition on the Customer ID)  Is this possible ? I know we tried this function (soShipmentGraph.UpdateIN.PressButton ()) It changes the shipement status but the inventory is not updated. We don’t have the 2 step-transfer (IN3040PL). In desperate need for help; plzzzz Thank you. 

Hello,I am encountering a problem when using up or dow key in grid line it doesn’t trigger any event that i can use to launch my code Fyi : Commitchange = TrueThanks for your feedback.

I have created one selector custom field in Customers screen and managed to grab Reason Code information using the code below:public class BAccountExt : PXCacheExtension<PX.Objects.CR.BAccount> { #region UsrReasonCode [PXDBString(CS.ReasonCode.reasonCodeID.Length, IsUnicode = true)] [PXUIField(DisplayName="Reason Code")] [PXSelector(typeof(Search<CS.ReasonCode.reasonCodeID, Where<CS.ReasonCode.usage, Equal<ReasonCodeUsages.sales>, Or<ReasonCode.usage, Equal<ReasonCodeUsages.issue>>>>), DescriptionField = typeof(ReasonCode.descr), CacheGlobal = true)] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] public virtual string UsrReasonCode { get; set; } public abstract class usrReasonCode : PX.Data.BQL.BqlString.Field<usrReasonCode> { } #endregion }} How can I grab the value set in the Customers screen and make it a default value in Sales Order screen. I have tried replacing the Reason C

I have a weird behavior, I try to simulate the click on the button "Update the stock" of the expedition by code I am using this function: soShipmentGraph.UpdateIN.PressButton ();It appears that everything is working correctly, the shipment goes to "integrated" status or there is no transfer created.Unlike if I manually click on the button, I have the transfer. 

I need to override a piece of Acumatica’s Approval process that wipe outs the approval log when a document is put “On hold”. Not sure why Acumatica approval engine violates internal controls and clears the approval history log. The piece of the code that prevents from approving a rejected document is in EP\Descriptor\Attributes.cs as follows:        public virtual void Reset(SourceAssign source)        {            foreach (EPApproval item in this._History.SelectMulti(GetSourceNoteID(source)))                this.Cache.Delete(item);        } 

Hi,I need to insert 300+ (or more, depending on the # of batches selected) rows of records on grid but the time it consumes is way too long, it takes 10 mins to insert 298 rows, but as I tweaked the code, I was able to lessen it to 8 minutes.AddProperty Action - This is where I add records to the grid.public PXAction<REMeterReading> AddProperty; [PXUIField(DisplayName = REMessages.AddProperty)] [PXButton()] public IEnumerable addProperty(PXAdapter adapter) { ClearDetails(); if (Filter.AskExt() == WebDialogResult.OK) { string[] floors = Filter.Current.Floors.Split(',').Select(_ => _.Trim()).ToArray(); REMeterReading document = MeterReading.Current; List<REProperty> properties = GetMeterReadingProperties(propertyClassID: document.PropertyClassID, rateID: document.RateID,

The weird thing is that I was typing “SQL to Acumatica Number Fields Multiplied by 24 or 40” into Google and it autocompleted right after I started typing “multiplied” but then there were no fruitful results.So, we’re on-premise SQL hosted Acumatica 2021 R1 and I’m attempting to make a Pivot Table run faster by doing the query, main filtering, and calculations on SQL in a View that I have on a Customization as a DAC Table (generated from database) and a Database Script. Everything runs great except for the actual numbers. They are fine when I look at the View in SQL Server Management Studio and there are the same number of rows for the SQL View and the Generic Inquiry on the View in Acumatica, but all of the values of the decimal and integer columns are coming into Acumatica as Number columns multiplied by 24 or 40. Admittedly, this is my first DAC and Customization Project but I’ve checked three different DAC tutorials (the one in the official customization manual and two others by th

 I have created one custom field each in Sales Orders screen and in Add SO Line dialog box in Invoices screen to display the value of Tariff Code in Stock Items screen. I managed to display them using the code below:public class SOLineExt : PXCacheExtension<PX.Objects.SO.SOLine>{ #region UsrTariffCode [PXDBString(30)] [PXUIField(DisplayName = "Tariff Code", Enabled = false)] [PXFormula(typeof(Selector<SOLine.inventoryID,InventoryItem.hSTariffCode>))] public virtual string UsrTariffCode { get; set; } public abstract class usrTariffCode : PX.Data.BQL.BqlString.Field<usrTariffCode> { } #endregion} public class SOLineForDirectInvoiceExt : PXCacheExtension<PX.Objects.SO.DAC.Projections.SOLineForDirectInvoice>{ #region UsrTariffCode [PXDBString(50, BqlField = typeof(SOLineExt.usrTariffCode))] [PXUIField(DisplayName = "Tariff Code", Enabled = false)] public virtual string UsrTariffCode { get; set; } public abstract class usrTariff

I'm working on a new Acumatica screen for our company that will require some javascript code to retrieve and display a map object (from ESRI).This code requires an external .js file that can be programmatically loaded. Everything works fine if I use a blank HTML page to test this.The problem I have is that when I try using the same code from inside the Acumatica screen, it doesn't load this required external file, and therefore the code does not work properly.I attempted to load the full .js file along with my code, but it returned the following error:error CS8095: Length of String constant exceeds current memory limit. Try splitting the string into multiple constants.I haven't tried splitting this file into multiple strings (as the error message suggests), because I want to make sure there isn't a cleaner and more professional, direct/right way to do this.Is it possible to manually import this external .js file into our Acumatica instance, so I can point to it instead? (in case it mak

If I get requests from users at my company to make customization changes to their homepage (i.e. add tiles) what roles would I need to be assigned and how would I go about making the changes to their account?

We have custom attributes created. if the attribute contains more than 10 times, the autocomplete works correct, just not for the attribute with 10 items or less after upgraded the system to 21R1. For example, we have language attribute with 3 valueitems,  E, F, S,  when type those letter into the box, item won’t be auto selected like before.