Develop Customizations

As shown in the above screenshot, I want to get the total of the “Line Volume” in the detail section and show in the field of Total Volume in the header level. This Line Volume is a newly added customized field in to the ARTran DAC. Relevant code for the Line Volume as follows.  Guys, If you can give me a guidance, it is highly appreciated. 

I have created a location selector under “Component and Warranties” grid in Equipment Screen (FS205000).The selector is working fine, location is also getting selected and saved into db. but when the focus is removed from the selector field, I can’t see the value. below is my code and screenshots attached :  #region UsrXDLocation        [PXDBInt]        [PXUIField(DisplayName = "Location")]        [PXSelector(typeof(Search<Location.locationID,Where<Location.bAccountID, Equal<Current<FSEquipment.customerID>>>>),             DescriptionField = typeof(Location.descr), SubstituteKey = typeof(Location.locationCD), Filterable = true)]        public virtual int? UsrXDLocation { get; set; }        public abstract class usrXDLocation : PX.Data.BQL.BqlInt.Field<usrXDLocation> { }#endregion This code is under FSEquipmentComponentExt.This screenshot is when the field is on focus :  This screenshot is when the field is out of focus :   Thanks and Regards

What’s the best way to add an index to an existing table that’s a third-party table?It’s a table with an auto-increment field as it’s primary key (along with CompanyID). But when I look at the underlying views, the code is querying the table using non-indexed fields. I don’t have time, at the moment, to reach out to the third-party to suggest that they add a key to make the lookups faster mostly because I won’t have time to integrate any patch from them into my code base at this point even if they agree.So I was thinking of adding a non-unique key on the fields that I see the view using.Should I just add a SQL script to my customization project to add the index if it isn’t already in place?Or is there a more official way that I should do this?

I have a customer that I cannot publish ANY customizations for. (This is on my development server.)I have 12 different customers running on this server. All of them are fine. However, when I try to publish ant customizations for one particular customer, I get errors.Here is the process:I backup the customer’s database using SQL Server Backup and restore it to my local SQL Server. I create a new Application Instance using AcumaticaConfig.exe, attaching it to an existing database (done in step 1) I start up the application in IIS I go to the customizations page, and of course all customizations are unpublished I try to publish ANY of them -- even the Acumatica Github Customizations (eg PXLineCostForAccrue) -- ANYTHING, and I get this error:[2023-08-24 19:01:46.663] Compiled projects: PXLineCostForAccrue[07.17.23][2023-08-24 19:01:46.720] Validation started.[2023-08-24 19:01:46.766] Microsoft.WindowsAzure.Storage.StorageException: The remote server returned an error: (403) Forbidden. ---&

Hello,I have 2 extensions fields on the Project page. One is a checked box and the other is a date field. I am trying to set it up so that when the checkbox is checked, the current date is populated into the date field. When the checkbox is cleared, I want the date field to be cleared as well. I have this functionality working on another form but it is custom tables and not extensions. Here is my code protected void _(Events.FieldUpdated<ContractExtDS.usrInstalled> e) {        var row = e.Row;         //I don’t think that it is getting past this line, but I can’t figure it out           if(!(bool)(e.Cache.GetValueExt<ContractExtDS.usrInstalled>(row)))        {          e.Cache.SetValueExt<ContractExtDS.usrInstallationCompletedDate>(row, DateTime.Now);        }        else        {          e.Cache.SetValueExt<ContractExtDS.usrInstallationCompletedDate>(row, null);        }}

I want to create a custom field using the [Inventory] attribute so that I get the selector and it is all sorted out for me.  I don’t want it to be PXDBInt.  I want it to be a virtual field of type PXInt.        #region UsrModEquipTempID        [Inventory]        [PXUIField(DisplayName = "Model Equipment")]        public int? UsrModEquipTempID { get; set; }        public abstract class usrModEquipTempID : PX.Data.BQL.BqlInt.Field<usrModEquipTempID> { }        #endregionIf I put [PXInt], it causes a compiler error.  How can I do that?  

Hello,I have an action that I would like to run as a process on a sales order. It’s really an ‘initialize’ action where I can do some validation while I save it. I have simplified the code to the base where I’m still getting the same behavior. Ultimately, I want to persist the record before I do any processing due to the way the system caches data on the tables/items I’m running calcs on. Can anyone tell me why when I execute this action (before initially saving) the system redirects me to a blank sales order? In order to find it again, I have to press the “Last” button to get back into it.  public PXAction<SOOrder> Test; [PXProcessButton(CommitChanges = true, Category = "Processing", Connotation = PX.Data.WorkflowAPI.ActionConnotation.Success)] [PXUIField(DisplayName = "Test")] protected IEnumerable test(PXAdapter adapter) { Base.Save.Press(); return adapter.Get(); }Alternatively, if I save manually before pressing th

It show me like this when reload “ Incorrect syntax near ')' ”. I think my code is correctly but…here it is, please advice me[PXSelector(typeof(Search2<InventoryItem.inventoryID,LeftJoin<InventoryItem,On<InventoryItem.inventoryID,Equal<INItemCategory.inventoryID>>>,Where<INItemCategory.inventoryID.IsNull>>))]        protected virtual void _(Events.CacheAttached<INItemCategory.inventoryID> e)        { // Empty method        }

Hi,I have a simple processing screen displaying records in a grid. Above the grid, I have some action buttons.What I want to doI'd like to change dynamically the accessibility of one of thses action buttons : if the selected record in the grid has some specific characteristics, the button is enabled, otherwise, it is disabled.The problem  to solveMy problem is to catch the fact that a new row is selected in the grid : the RowSelected event is not invoked in this case.Some technical detailsThe declaration of the graph :public class EapActivityProcess : PXGraph<EapActivityProcess>The declaration of the view        public SelectFrom<EAPActivity>            .OrderBy<Desc<EAPActivity.lastChangeDate>>            .View.ReadOnly ActivityView;This is the view used in the grid :Anybody knows if it is possible ?

Hi, In the Sales Orders screen, after clicking ‘Add Items’, as shown in the second image below, a client is wanting the Warehouse field to be set to ‘MAIN’ in the dialog box shown in the third image below. The code I currently have set up doesn’t seem to work. I am using the FieldDefaulting event but would I need to combine this event with another one, like RowSelected, to pass the value through? Let me know if I can provide any other information. Kind regards,Andrew protected void SOSiteStatusFilter_SiteID_FieldDefaulting(PXCache cache, PXFieldDefaultingEventArgs e) { if (e.Row == null) return; SOSiteStatusFilter row = (SOSiteStatusFilter)e.Row; INSite site = PXSelectReadonly<INSite, Where<INSite.siteID, Equal<Required<INSite.siteID>>>>.Select(Base, "MAIN"); row.SiteID = site?.SiteID; } 

Hello Acumatica Community,i am trying to add the attributes of a stock item to the PO Line in the Details TabThese Attributes:For my problem i found this post: I thought i could transfer that to the PO and add the inventory attributes to the Details Tab. After 2 very long days and suffering i no longer know what to do. I would like you to take a look into the code of my customization. I added a new custom field in POLine which i believe later stores the value of the specific attribute. But i am not sure if i correctly defined which attribute to show.Here is my Code for the DAC Extension of POLine:using PX.Common;using PX.Data.BQL;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.CM.Extensions;using PX.Objects.Common.Bql;using PX.Objects.Common.Discount.Attributes;using PX.Objects.Common.Discount;using PX.Objects.Common;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.IN.Matrix.Interfaces;using PX.Objects.IN;usin

I’m still new to programming in Acumatica, so I may have gotten several things wrong here, but I’m trying to get a single value to be returned from this BQL statement which should be the sum of a specific customer’s invoices for the current year for the price of goods only. I’m getting a highlighted error in Visual Studio that says that the entire BQL statement is a type that is not valid in the given context. I’m also not sure if the Convert.ToDecimal function will work with an ARInvoice.curyGoodsTotal object. namespace PX.Objects.AR{ public class DateYearStart : PX.Data.BQL.BqlDateTime.Constant<DateYearStart> { public DateYearStart() : base(new DateTime(DateTime.Today.Year, 1, 1)) { } } public class DocTypeString : PX.Data.BQL.BqlString.Constant<DocTypeString> { public DocTypeString() : base("INV") { } } public class CustomerMaint_Extension : PXGraphExtension<PX.Objects.AR.CustomerMain

In the following BQL Fluent statement, I am selecting a record from the POVendorInventory table.In the table, the record has a NULL in the SubItemID field.  When there is a NULL in that field, this returns no record even though my parameter “reg.SubItemID’ is passing a NULL.That field is part of a unique index.  My select statement is making sure that if a record already exists with the key fields, it does not add a duplicate.POVendorInventory test = SelectFrom<POVendorInventory>                    .Where<POVendorInventory.vendorID.IsEqual<@P.AsInt>                        .And<POVendorInventory.inventoryID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.purchaseUnit.IsEqual<@P.AsString>>                        .And<POVendorInventory.vendorLocationID.IsEqual<@P.AsInt>>                        .And<POVendorInventory.subItemID.IsEqual<@P.AsInt>>>                    .View.Select(graph, bAccountTo.BAccountID,

Looking for Acumatica configuration partners that know the ins and outs of Acumatica and are timely and responsive.

Hi All, I have previously asked this question for an AR Invoice in a different approach. But I was unable to resolve it using the replies of that question because of some issues(Release method is not triggering when we process invoices from a process screen).However, Now I want to attach a report pdf to files section of an AP Invoice through Release AP Documents screen. I tried to override Release action in APPaymentEntry graph. But it is not triggering when releasing invoices through Release AP Documents screen. Then I tried the below code snippet & it is triggering for each AP Invoice. There are no errors in the code. But file is not attaching as expected. Below is my code.Acumatica Version : 21.213using System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Text;using PX.Common;using PX.Data;using PX.Data.DependencyInjection;using PX.Data.WorkflowAPI;using PX.LicensePolicy;using PX.Objects.Common;using PX.Objects.Common.Extensions;using P

Hi All, I want to show all records associated with any Account when Account Filter field is null in Account Details Screen. Otherwise it should work as usual. How can I achieve this? Thanks

I’m attempting to override the ReleaseFromHold action on the POOrderEntry graph, I need to add my own validation before the baseMethod is called.I created the delegate using the following code, but I receive the error message below.I’ve been able to override other action on this same graph using this method, is there something unique about the ReleaseFromHold action?  public delegate IEnumerable ReleaseFromHoldDelegate(PXAdapter adapter); [PXOverride] protected IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod) { return adapter.Get(); } 8/18/2023 2:46:05 PM Error:Attempt by method 'Wrapper.PX.Objects.PO.Cst_POOrderEntry.ReleaseFromHoldGeneratedWrapper(PX.Objects.PO.POOrderEntry, PX.Data.PXAdapter)' to access method 'PX.Objects.PO.POOrderEntry_Ext.ReleaseFromHold(PX.Data.PXAdapter, ReleaseFromHoldDelegate)' failed.   at Wrapper.PX.Objects.PO.Cst_POOrderEntry.ReleaseFromHoldGeneratedWrapper(POOrderEntry g, PXAda

Good day,I have several questions about buttons.I am trying to establish a sequence when creating customer locations, in the customer locations screen when a user selects a customer and is going to add a new location, it has to press the button, so it automatically assigns the number for the sequence. If I Define the action with PXButton in the graph extension, it creates a button in the toolbar and when pressed it does the sequence, but it places it in the wrong spot.First picture shows the button in the toolbar and on the top left corner the value.I am specifying in the code that I want the value in the LocationCD field but is not working.Then if I define the action with PXLookupButton(DisplayOnMainToolbar = false) there is no button in the toolbar which is good, but when I create a button control in the aspx the Command attribute doesn't seem to work. I can't link the code in the graph with the aspx. I did a debug and when I press the button it does nothing. And finally, I want the

Tôi muốn tạo mới report và chỉnh sữa báo cáo trên Acu phải làm như thế nào I want to create a new report and edit the report on Acu, how to do it?

Hello every one,I have done a payment integration on AcuPos. when the payment is processed succefully, the provider send back a payment reference.I have configured the payment reference to be pushed to the database directly upon being receive.Now, the user have to refresh the browser tab for the reference to reflect from the database to the UI.see below; is there a way I can refresh the specific field or the column or the tab so that the database value can reflect on the user interface without the user having to refresh the entire tab.Kindly assist.any kind of response will be appreciated.Thank you, great community!

Where does the data  such as ‘Qty on Hand’, ‘Available’ and ‘Available for Shipping’ come from and is there a way to highlight the verbiage if something is below a certain amount?

Hi,Is it possible to hide a screen from the workspaces where it is displayed if a given feature is not enabled ?To describe my situation, I have a graph A and its extension B.    public class A: PXGraph<A>    {        public SelectFrom<EAPInvoice>.Where<True.IsEqual<False>>.View emptyView;    }    public class B: PXGraphExtension<B>    {        #region Properties        public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.myFeature>();         ...    }A screen has been created using graph A and has been added to the “Payable” workspace. It uses fields from a DAC that also depend on the feature.    public class MyDAC: IBqlTable    {        public static bool IsActive() => PXAccess.FeatureInstalled<FeaturesSetExt.myFeature>();…}When “myFeature” is disabled from CS100000, none of fields from the DAC are displayed ; that’s OK. However, the screen is always available in the “Payable” workspace whereas I’d like it not being

 Good day, I have 2 custom fields on the purchase receipt line and in Bills and adjustment line, I want those fields in the Dialog of the ADD PO RECEIPT LINE button in the Bills and adjustment screen, retrieve the information and apply it on the Bills and adjustment line.I can release the purchase receipt but I can't get the data in the Bills and adjustment.I have a projection override and my events in a graph extension of the Bills and adjustment screen, to retrieve the information, I use the POReceiptLine DAC but I don't know why I am having the error Invalid Object Name POReceiptLineS everytime I want to Enter AP Bill. It seems POReceiptLineS is a DAC but I don't see where I need to reference it. public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { [PXProjection(typeof(Select<POReceiptLineAdd>))] public partial class POReceiptLineAddOverride : POReceiptLineAdd { #region UsrTicketSupplier [PXDBString

Good day,I have 2 custom fields on the purchase receipt line and in Bills and adjustment line, I want those fields in the Dialog of the ADD PO RECEIPT LINE button in the Bills and adjustment screen, retrieve the information and apply it on the Bills and adjustment line.I can release the purchase receipt, but I can't get the data in the Bills and adjustment.I have a projection override and my events in a graph extension of the Bills and adjustment screen, to retrieve the information, when my DAC override inherits from POReceiptLineAdd I am having the error Invalid Object Name POReceiptLineS everytime I want to Enter AP Bill. POReceiptLineAdd inherits from POReceiptLineS and when my DAC inherits from it the warning error disappears but the ADD PO RECEIPT LINE button does nothing.   public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { [PXProjection(typeof(Select<POReceiptLineAdd>))] public partial class POReceiptLineAddOverr

I'm having trouble with this way of saving the data in Acumatica inside an async method for some reason when I call the method and try to save the current data it always takes the last company in the database. I mean loses the current context.I have a site in 22R2 with 2 company: Database: I have this code: Asynchrony method    public async Task SaveAsync(DeviceLicenseData? data)        {                    if (data == null || string.IsNullOrEmpty(data.AccessToken))             {                await ResetAsync();                return;            }             SaveToAcumatica(data);        }  Method to save in Database  public void SaveToAcumatica (DeviceLicenseData data)        {             License.Current = License.Search<License.fRServerId>(data.DeviceId);            License.Cache.AllowUpdate = true;             var frlicense = License.Current ?? new License();              frlicense.FRServerId = data?.DeviceId ?? default;            frlicense.FRHubServerName = data?.ServerN