Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hi Experts,I added a UDF “selected” in the package line as below, so that I can select the packages I want. I also enable this UDF in the code and disable others in the workflow.If I just publish my project, it works well. But if another customization project which extends the shipment screen is published, all the fields in the package can be edited. I’m looking for another way to fix this problem. Do you have any idea? Thanks,Frank
The Void ReleaseDocProc(PX.Objects.GL.JournalEntry, PX.Objects.IN.INRegister, ReleaseDocProcDelegate) method in the PX.Objects.IN.INReleaseProcess_Extension graph extension is marked as [PXOverride], but its signature is not compatible with the original method.
I am working in the Customization Project Editor. I went in and added on the Customer Screen a new custom field usrDate_Of_Loss. I think its BAccountExt.usr_Date_Of_Loss. I added it to the customer. I also added a usrDateOfLoss to the invoice ARRegisterExt.usrDateOfLoss I believe is what it is called. I also added the Default code and the Formula attributes where the custom field is declared in the Customization Project Editor. I am adding it to the Attributes section, I put in bold below: [PXDBDate][PXUIField(DisplayName="Date Of Loss")][PXDefault(typeof(Search<BAccountExt.usrDate_Of_Loss , Where<Customer.CustomerID, Equal<Current<ARInvoice.CustomerID>>>>), PersistingCheck = PXPersistingCheck.Nothing)][PXFormula(typeof(Default<ARInvoice.CustomerID>))] It is looking up I hope that custom field from Customer to put in the Invoice DateofLoss Field. The error on validation is: \App_RuntimeCode\PX_Objects_AR_ARRegister_extensions
I need to maintain existing unit price when recalculate the price in sales order screen.I created a table to maintain the price History.table name - XXSOPriceHistorySOOrderEntry extension query public PXAction<SOOrder> recalculateDiscountsAction; [PXUIField(DisplayName = "Recalculate Prices", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton(CommitChanges = true, DisplayOnMainToolbar = false)] public virtual IEnumerable RecalculateDiscountsAction(PXAdapter adapter) { SOOrder order = Base.Document.Current; order.OrderDesc = "Testing1"; XXSOPriceHistoryEntry sOPriceEntry = PXGraph.CreateInstance<XXSOPriceHistoryEntry>(); XXSOPriceHistory toBeInserted = new XXSOPriceHistory(); toBeInserted.LineNbr=1; toBeInserted.OrderNbr="SO1000"; toBeInserted.InventoryID = 1435; toBeInserted = XXSOPriceHistoryData.Insert(toBeInserted); //sOPriceEntry.Save.Press(); return B
Hello Everyone,I’m busy with some customizations of the Sales Order Workflow. The new flow needs to go from On-Hold to Open and from Open I’ve added an action but this action needs to do 2 checks to either put the sales order on Credit Hold if the Customer’s limit is exceeded or if it is satisfied progress to the new state called Dispatch and then from there create the shipment.So far I’ve got the workflow to work for the customer with the satisfied limit but I can’t get the system to put the Sales Order on credit Hold if the limit is exceeded. Any ideas from someone where I might have gone wrong?
I have created custom field for Bills and Adjustments screen to approve the AP Bill. So then after I set the field to the Approve map as belows. but it didn't work for me.Anyone know what else should I do to work for this. I used acumatica version 22 R1.
I want to add a counter which suggests how many times a pick list was printed. Which is the best DAC to use over her. According to me it should be SOPickingWorksheet. Please correct me if I am wrong and help me.
Hello everyone,I'd need to display the first PDF file linked to current AP invoice in the AP301000 screen. Is it possible to do that using side panels ? Thx.
Is there a way to add in a custom Function (C#) into a Generic Inquiry. I remember reading a blog post at a time where this was explained but I cant find it or this is not possible anymore.any guides or post about this will be helpfulthanks
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.