Develop Customizations

Hi All,I’m currently using Acumatica Build 23.112.0032.  We want to disable a operation id thus preventing a employee from being able to scan that operation id.  Is there a way to do so?

Hi All,I have created a custom processing screen and now I need to call the processing method using the process buttons. Can some one help me out?My Processing Classpublic class HMRCVerificationProcess : PXGraph<HMRCVerificationProcess>    {        public PXCancel<HMRCVendorRegisterDetail> Cancel;        public SelectFrom<HMRCVendorRegisterDetail>.Where<HMRCVendorRegisterDetail.excludeverification.IsEqual<False>>.ProcessingView AllVerifiedVendors;        #region Overridden Properties        public override bool IsDirty => false;        #endregion        public HMRCVerificationProcess()        {            AllVerifiedVendors.SetProcessCaption("Run");            AllVerifiedVendors.SetProcessAllCaption("Run All");        }            }My Graph public class HMRCPeriodicVerifyMaint : PXGraph<HMRCPeriodicVerifyMaint>    {        public PXSave<HMRCVendorRegisterDetail> Save;        public PXCancel<HMRCVendorRegisterDetail> Cancel;        //Or

I have REALLY crazy one here.  Our customer works with finance companies who require a separate invoice for each ITEM shipped.  In their current system, they have an option to “split an invoice” into multiple invoices AFTER the invoice from the shipment is created.  CRAZY.In Acumatica, assume I am selling 2 tractors on one Sales Order.  The customer is having the tractors financed by a finance company, so the invoices will go to the Financier.  On the Process Shipments screen, if I Prepare Invoices, it will produce one invoice per shipment.  I know about the Batch checkbox you need to uncheck in the Shipments screen action “createInvoice”.  That helps, but does not do what I need.They do NOT want shipments to be split.  Just the invoices from the shipment.There are 3 things I can come up with to get a single invoice per ITEM on the Sales Order that has been shipped.Before the Sales Order is shipped (at the Sales Order screen where the CREATE SHIPMENT button is available), write code th

I got this error log. I try to find column in my customization but i see only oneSystem.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'UsrAccountName' in table 'dbo.Address' is specified more than once. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32

Hi Team,I added two customized fields to Branch table and created new tab in the company form (CS101500).But those two fields are read only. Can someone please help me out to enable this field.My Screen public sealed class BranchExt : PXCacheExtension<PX.Objects.GL.Branch>    {        public static bool IsActive()        {            return true;        }        #region UsrComUTRNo        [PXDBString(20)]        [PXUIField(DisplayName = "Company UTR No")]        public  string UsrComUTRNo { get; set; }        public abstract class usrComUTRNo : PX.Data.BQL.BqlString.Field<usrComUTRNo> { }        #endregion        #region UsrComAORefNo        [PXDBString(20)]        [PXUIField(DisplayName = "Company AO Ref No")]        public  string UsrComAORefNo { get; set; }        public abstract class usrComAORefNo : PX.Data.BQL.BqlString.Field<usrComAORefNo> { }        #endregion    } ThanksBhagya

Some custom field already update to database already with last customize and I just add one custom field to other customize and publish. but it go to omit one or two in other table.  

Dear Team,I have created a Custom field (UsrContactPhone) on the Cases screen to display the Contact's phone number.I used FieldSelecting Event to do this. The result displayed the value of Custom field (UsrContactPhone) on the Cases screen, but I can't re-enter another value for this field (UsrContactPhone). After entering another value again, the system updates the default value of FieldSelecting Event.How can I change the value of the field after performing FieldSelecting Event or FieldUpdated Event ?Please help me with the solution !Best Regards,NNT==============protected void CRCase_UsrContactPhone_FieldSelecting(PXCache cache, PXFieldSelectingEventArgs e, PXFieldSelecting InvokeBaseHandler)    {      if(InvokeBaseHandler != null)      InvokeBaseHandler(cache, e);      var row = (CRCase)e.Row;            if (row == null)            {                return;            }            Contact contact = PXSelect<Contact,                Where<Contact.contactID, Equal<Required&lt

I’m working on UI tests using Acumatica’s Test SDK which wraps around selenium. There are a number of things that I would like to do which the Test SDK does not seem to provide functionality for. My question is, can I use vanilla Selenium alongside the Test SDK and if so how? Specifically I’m wondering how/if I could go about connecting to the same WebDriver(which to my understanding is how Selenium sends commands to the browser). When I try creating a new WebDriver and using that it ends up creating a new browser window which is not what I’m wanting. Other info Browser : ChromeOS : Windows 10Acumatica Version : 23r2 Here is the sample code I used to create a new WebDriver but like I said it opens in a new window not the window that is already open. var driver = new ChromeDriver("C:\\Projects\\TestSDK_23_105_0016_17\\Chrome"); 

When use PXNonInstantiatedExtension. How to use it ?

My customer would like to add the State field to the Vendor Selector form on the AP BIlls and Adjustments form.I have followed this article https://www.info-sourcing.com/how-to-add-fields-to-acumatica-selector-lookup-no-coding/  but it is not adding the column.Has anyone had any success adding a column to the vendor selector window? 

Hello all,I need to write some codes in “Page_Load”. I have done the coding and it works flawless on browser. But, when I call the same method that results in Page_Load from the “Mobile App”, the Page_Load does not evalue the variables correctly or returns an unexpected value. here is the partial code: public partial class Page_HC509090 : PX.Web.UI.PXPage{ protected void Page_Load(object sender, EventArgs e) { AccessInfo accessInfo = (AccessInfo)this.ds.DataGraph.Caches[typeof(AccessInfo)].Current; int? contactID = PXAccess.GetContactID().GetValueOrDefault(); Guid? userID = CommonServiceLocator.ServiceLocator.Current.GetInstance<ICurrentUserInformationProvider>().GetUserIdOrDefault(); MyDAC myDAC = (MyDAC)this.ds.DataGraph.Caches[typeof(MyDAC)].Current; // Do stuff {}To add a little more context, when from screen A an action button is pressed by a user, some suff happens then using “PXRedirectHelper.TryRedirect()” platform directs the u

Hello all,Does anyone have any idea why I am getting null exception (Subject Line error)? if (fixedDemand != null && Base.FixedDemand != null && Base.FixedDemand.Any()){ PXResult<POFixedDemand> matchingDemand = Base.FixedDemand.Select() .Where(r => r.Record.RefNoteID == fixedDemand.RefNoteID && r.Record.FixedSource == fixedDemand.FixedSource && r.Record.SiteID == fixedDemand.SiteID && r.Record.PlanType == fixedDemand.PlanType && r.Record.PlanID == fixedDemand.PlanID && r.Record.RecordID == fixedDemand.RecordID) .FirstOrDefault();} 

I’m creating SDK tests and I need to select the row by column name and value. However, it throws error “Element is not interactable” when I use this: users.UserRoles.SelectRow("Role Name", "Anonymous"); or this:users.UserRoles.SelectRow(users.UserRoles.Columns.Rolename, "Anonymous");It only works with index: users.UserRoles.SelectRow(10);Could someone please help me out? 

I have a screen with an masterview and some virtual DACs which are filled by data got from API requests. Now i need to be informed of the change of the masterviews current record to refresh the virtual DACs. Is there an event i can use for this purpose?

Hello, I want to run some code when the ‘Line Details’ button is clicked on Purchase Receipts. Overriding the appropriate method seems like the way to go but I’m struggling to get the code to work. This is a screen shot with the button hightlightedThe button calls a method called ShowSplits, this displays a SmartPanel. I want to do something when the SmartPanel closes. Unfortunately this method is in an extension (POReceiptLineSplittingExtension) so I’ve tried to define the extensions in the class definition for my extension. My code looks like thispublic class POReceiptLineSplittingExtension_Extension : PXGraphExtension<POReceiptLineSplittingExtension, LineSplittingExtension<POReceiptEntry, POReceipt, POReceiptLine, POReceiptLineSplit>, POReceiptEntry>{ public delegate IEnumerable ShowSplitsDelegate(PXAdapter adapter); [PXOverride] public IEnumerable ShowSplits(PXAdapter adapter, ShowSplitsDelegate baseMethod) { var ret = baseMethod(adapter); //Do Something return ret;

Hi Team,I'm trying override the "Release" action on "Sales Price Worksheets" Screen, since i need to insert the newly customized field value on "Sales Price" screen. Usually i execute the base method and then insert the values. but here the main problem is i couldn't find any relationship between "ARPriceWorksheetDetail" and "ARSalesPrice"Please let me know how i can handle this situation.      Regards,Ramya Krishna

 This is the parameters and conditions I have created. But its not filter data.<gifilter LineNbr="3" IsActive="1" Name="PeriodTo" FieldName="PMTimeActivity.weekID" DataType="string" DisplayName="To Date" IsExpression="1" ColSpan="1" Required="1" />         <gifilter LineNbr="2" IsActive="1" Name="PeriodFrom" FieldName="PMTimeActivity.weekID" DataType="string" DisplayName="From Date" IsExpression="1" ColSpan="1" Required="1" />         <gifilter LineNbr="1" IsActive="1" Name="EmployeeID" FieldName="EPEmployee.acctCD" DataType="string" DisplayName="Employee Name" IsExpression="1" ColSpan="1" Required="1" /> <giwhere LineNbr="2" IsActive="1" DataFieldName="PMTimeActivity.weekID" Condition="B" IsExpression="0" Value1="[PeriodFrom]" Value2="[PeriodTo]" Operation="A" />        <giwhere LineNbr="1" IsActive="1" DataFieldName="EPEmployee.acctCD" Condition="E" IsExpression="0" Value1="[EmployeeID]" Operation="A" />

Hi Team,We are working with an upgrade project. we have upgraded our project from Build (22.124.0015) to Build: 23.204.0031. After upgrade, while we are trying to open the sales order screen getting the following error. Can you please review below details and suggest the best possible way to fix that. Thank you in Advance!

Does anyone know how to load external url image to Acumatica Form?I added an URL as User-Defined Fields in SOLine. I want to create a new form for the SOLine that can display the image of the URL, foe eample SOLine.UsrImageUrl = https://designerimages.artifi.net/UserPhoto/0e8a78b2-eea3-475e-b38c-b3ea2b606926/Customize/Standard/5f2142de-766c-44a0-8f32-0b447de9f6e2.png. The new form will display the image of the URL when an SOLine is selected. Then I want to add this new form as a side panel of Sales Order Entry screen. So when user click an order line, the side panel will display the image of the line. 

Hi All,In my graph there are two custom buttons called Test1 and Test2. Initially I need to disable Test2 button and based on the condition in Test1 button need to Enable the Test2 button.Here is my sample codepublic PXAction<HMRCVendorRegisterDetail> Test1;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Button 1", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]protected virtual IEnumerable test1(PXAdapter adapter){    if(x == 1)    {        Test2 button need to setEnable true here    }    else    {        Test2 button need to setEnable false here    }    return adapter.Get();}public PXAction<HMRCVendorRegisterDetail> Test2;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Button 2", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)]protected virtual IEnumerable test2(PXAdapter adapter){    return adapter.Get();    }Can someone help me out?Thanks

Does anyone know where Acumatica stores the values of Dashboard Widgets when using the Refresh Data setting? For example, take the Orders to Ship Widget pictured here with a value of 12  I have the Refresh Data value set to Every Day which means that Acumatica should only refresh the value once a day  In order to do that, I would think that Acumatica stores the value of 12 somewhere, but I’m not sure where it gets stored.

Hello, good evening everyone. I have developed a smart panel that generates an Accounts Payable (AP) bill from an email. However, i have encountered an issue with inserting an AP transaction when we link it to a Purchase Order or subcontract. The system displays the error message shown in the picture. Is there a specific insertion method in Acumatica for handling this scenario?  Thank you very much for the support, any help is received

Hi All,Is there a way to setup workflow for a Custom screen? At the moment don’t see a Workflow option in the Customization editor for the screen. 

I’ve created data provider, it’s using the built in Excel Provider type, it is used by an Import Scenario.It has various setting and mappings, as shown below.I can add the import scenario to my customisation package, but how can I add the Data Provider?

Hi All,My grid columns are changing abnormally when I open the relevant form. Grid columns are not in the same order as screen editor shows. Also when previewing changes also working fine. Can someone please help me out?Preview changes also fineBut actual run timeThanks