Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Good Morning,is there a way to easily import dozen of Notifcation Templates to replace the Standard Design? As far as i see it is only possible via Import/Export from the XML Files or?
I needed to conditionally disable the Standard Delete Action Button of a grid. Lat say the view associated with the grid is MyView. I can get some of the grid action buttons’ names like the Upload button using something like “MyView$ImportAction”. I need the same for the grid Delete Action Button. So I am trying “MyView$DeleteAction” and “MyView$Delete but seems nothing exists that I can Enable/Disable in the RowSelected event. If that was for the whole grid I could just simply set its Cache.AllowDelete = false but I need only disable on specific lines. Any idea how can I make this work?
hi i’m starting with the courses of development and i have a doubt about the instalation process. in the guide says i can install in windows 10 but only for testing purposes, i want to now how this afect the course or if is not problem for the moment
I want to customize Release process logic on Release AP Documents screen. Although I override the Release logic using ReleaseDelegate method on APInvoiceEntry Graph, the logic is not triggering when I Release AP Documents from Release AP Documents screen. Any idea or suggestion?
Hello colleagues,I want to attach files of Sales Orders when sending Email Notification by Business EventIn my case, I want the file HD_VIE also in attachment.I don’t know if it is possible because it seems like we only could attach report in attachment of email.Please let me know if there is any way to accomplish this requirement in version 2022 R2 I found an similar topic but didn’t get the answer Thanks for your help
Hi,I have requirement to read data from xml file and insert the data into the custom table.This xml file is daily updated into the location.So,I need to automated the process.Anyone can suggest resources or workaround for that.
Hi All,Lately in our test env we have started noticing this random error while updating/inserting to a cache. This is one of the errors, we have noticed similar error with other columns as well, this happens intermittently.If we refresh the page and try again the error goes away. Anything to do with the caches?Unknown column 'ARInvoice.BranchID' in 'field list', at PX.MySql.MySqlDatabaseProvider.throwInvalidColumnName(MySqlException e, IDbCommand cmd) at PX.MySql.MySqlDatabaseProvider.ExecuteReaderInternal(IDbCommand command, CommandBehavior behavior)
Hi,There is a requirement to add custom string list field called Usrdiscountcode in SOLine DAC. I have defined the string list like below.[PXDBString(1000)][PXStringList(new string[] {"A", "B", "C", "D","E","F","G", }, new string[]{"SPRING", "HARVEST","XPT","TESTTIRE","SPECIAL","REBATE","DISCOUNT" })][PXUIField(DisplayName="New Discount Code")]now I need to set the value (ex: SPRING) to a grid level field of the customized screen. For that, I defined an event in the graph extension like this.using System;using PX.Objects;using PX.Data;using PX.Objects.SO;namespace GRIProformaInvoice{ public class APProformaEntry_Extension : PXGraphExtension<GRIProformaInvoice.APProformaEntry> { #region Event Handlers public PXSelect<SOLine> soview; protected void APProformaItemList_RowInserted(PXCache cache, PXRowInsertedEventArgs e) { var row = (APProformaItemList)e.Row; foreach (PXResult<SOLine> result1 in soview.Select()) { SOLine line = resul
I created about 50 different methods that update different tables. The code in them is exactly the same, except the table names and field names are different.I know this is really a C# question, but I am not very good with C#. I’ve looked at the Acumatica repository to try to see how to do it, but I am pretty darn ignorant about how to do it.Below you will see the code that is hard coded with the table and fields. It is the code after the //all this stuff is hard coded comment. I want to create a generic method I can call that would accept the table name and field name as parameters.Here is a signature for what I *think* is what I need to have. At a minimum, I got something to compile.How do I replace the hard coded table names and field names? Is this an easy thing to do?My application works fine with 50 different methods (each having the table name and field name hard coded), but this would make my app more “professional”. public static List<T> TableUpdate<T, TField&g
How do I create a shortcuts for Create Blanket Sales Order on the Sales Order Menu and on the Customers three dots menu? I’m trying to easily go from creating a customer to creating a blanket sales order in a single click.
Hi,I’m using an expression that has a translation in a given screen (say screen A) and an other translation in an other screen (say screen B). In this case, the same neutral value should be translated differently wether we open screen A or screen B.How is it possible to do that using the “Translation Dictionaries” ?Thanks.
Hello, I’m trying to get file info from the UploadFileMaintenance graph using the code below.Unfortunately, the GetFile and GetFileWithNoData methods always returns null for me and I cannot understand why, and I’m out of ideas of try.I’ve added comments to the code to explain what I believe is happening. Can anyone explain what I’m doing wrong please?//create the CABatchEntry graph, find the batch I'm interested in and set the graphs 'current' record to the record I've found.CABatchEntry graph = PXGraph.CreateInstance<CABatchEntry>();PXResultset<CABatch> pXResults = SelectFrom<CABatch>.Where<CABatch.batchNbr.IsEqual<@P.AsString>>.View.Select(new PXGraph(), batchID);graph.Document.Current = (CABatch)pXResults.TopFirst;//create the UploadFileMaintenance graphvar fileUploadGraph = PXGraph.CreateInstance<UploadFileMaintenance>();//get a list of all FileIDs for the current recordvar savedFilesIDs = PXNoteAttribute.GetFileNotes(graph.Document.Cache, graph.
Hi Team,I’m getting Object reference error when inserting to Cache. Though I’m setting InvoiceCust value , exception is thrown stating InvoiceCust is null. Please see the code snippet below. Am doing anything wrong here? XRBContrDet newSchedule = (XRBContrDet)ContractDetails.Cache.CreateCopy((XRBContrDet)OldSchedule); newSchedule.ContractID = NewContract.ContractID; newSchedule.LineNbr = null; newSchedule.NoteID = null; newSchedule.CuryAmount = 0; newSchedule.CuryPrePayBal = 0; newSchedule.InvoiceCust = OldSchedule.InvoiceCust; newSchedule = ContractDetails.Insert(newSchedule); View [PXCopyPasteHiddenFields(new Type[] { typeof(XRBContrDet.manuallyBooked), typeof(XRBContrDet.aRRefNbr), typeof(XRBContrDet.sOOrdNbr) })] public PXSelectJoin<XRBContrDet, LeftJoin<ARInvoice, On<ARInvoice.refNbr, Equal<XRBContrDet.aRRefNbr>>>, Where<XRBContrDet.contractID
Hi Team,PXSelector with same code name not able to select the correct code. If it is having two same code means it will be when we select the second one it will will automatically point to the first one. Please find the selector and image. #region Location [PXDBString(50)] [PXUIField(DisplayName = "Project Location")] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [PXSelector( typeof(Search<ProjectLocation.locationID>), DescriptionField = typeof(ProjectLocation.description), SubstituteKey = typeof(ProjectLocation.locationID))] public virtual string Location { get; set; } public abstract class location : PX.Data.BQL.BqlString.Field<location> { } #endregion Regards,Sakthi
I have a minor change I need to make to the Appointment screen (FS300200).Instead of “Invoice Total” I want the Display text to read: “Appointment Total” (There are other changes I would like to make as well, but this one is the simplest to explain)I have unpublished every other customization. I made a new one with just this change.I pull up the screen: And select the Invoice Total field:I select “Customize Attributes”, replace Original, and make my change:I save it. Everything is fine. Until I publish it, and get this: In case you can’t read the screenshot, the error is: [2023-06-22 15:11:03.238] Building directory '\WebSiteValidationDomain\App_RuntimeCode\'.[2023-06-22 15:11:11.111] \App_RuntimeCode\PX_Objects_FS_FSAppointment_extensions.cs(32): error CS0246: The type or namespace name 'curyBillableLineTotal' could not be found (are you missing a using directive or an assembly reference?)[2023-06-22 15:11:11.111] \App_RuntimeCode\PX_Objects_FS_FSAppointment_extensions.cs(32): error
Hi Leaders,need your help in this by adding in the contract attributes a line that would display the total of all highlighted in yellow below and the total need to display below,kindly please help me for any detailed solution on this Thank you
Hi,I have to add another two more conditions to my custom view.*get sales orders when InventoryItem.itemType == charges or soline.openQty > 0The sql query is something like this to get an idea,Select * from soline lineinnerJoin soorder order on line.orderNbr/ordertype= order.orderNbr/ordertypeleftJoin solinesplit split on line.orderNbr/orderType/lineNbr = split.orderNbr/orderType/lineNbrleftJoin inventoryItem item on line.inventoryId= item.inventoryIdwhere other conditions....and order.status != "Cancelled" and (item.itemType == "Charges" or line.openQty > 0) I tried to apply above condition in the below bql query but it doesn’t look like as what I wanted. so could someone please to help me on this?public PXSelectJoin< SOLine, InnerJoin<SOOrder, On<SOLine.orderNbr, Equal<SOOrder.orderNbr>, And<SOLine.orderType, Equal<SOOrder.orderType>> >, LeftJoin<SOLineSplit, On<SOLine.orderNbr, Equal<SOLineSplit.orderN
I know this is “not possible”. However, Acumatica can do it. Why can’t I?When creating the Sales Demo data starting in 21R2 or so, someone extended AACUSTOMER to a Vendor, then deleted that vendor account. This returned AACUSTOMER back to just a CU. However, it leaves a record in the Vendor table with DeletedDatabaseRecord = 1.I want to programmatically “re-extend” the customer to a vendor again. I can’t. If I try to insert a new record in the Vendor table, it sees it as a duplicate. Also, since it is deleted, I can’t edit the existing “deleted” record.Acumatica has some way to do this. If you use Acumatica to Extend to Vendor for AACUSTOMER, it either 1) permanently deletes the existing vendor record prior to inserting the new record, or 2) it changes the flag on the deleted field to zero. I am guessing it has some way to change the flag.I thought I could try to re-use the business logic to extend the customer to a vendor using the CustMaintenance graph, but that will throw a
I created a customization that creates a view of manufacturing labor data and adds it to the DAC so it can be used in a GI. However, I am getting the following error when I try to release manufacturing transactions. What could cause this?
Hi Team,I have created few side panels in Project screen using my local instance through customization Project “action” properties. But when I publish the same package to server instance, the side panels disappear. May I know how I can rectify this issue. Local Instance: Server Instance: Regards,Ramya Krishna
I’m working through a project and I’ve been looking up code examples here and there.My question is: When do I use the primary view and when do I use the CurrentDocument view?This SO answer shows the creation of a Sales Order and references CurrentDocument but the primary view of SOOrderEntry is Document:SOOrder order = new SOOrder();SOOrderEntry graph = PXGraph.CreateInstance<SOOrderEntry>();order.OrderType = "SO";order = graph.CurrentDocument.Insert(order); order.CustomerID = project.CustomerID;graph.CurrentDocument.Update(order);graph.Actions.PressSave();Whereas this SO answer shows the creation of a Purchase Order and references Document and POOrderEntry.cs has Document (primary view) and CurrentDocument (second view).protected void createPO(){ var graph = PXGraph.CreateInstance<POOrderEntry>(); var order = graph.Document.Insert(new POOrder()); order.OrderType = POOrderType.RegularOrder; // This is the default so not necessary order.OrderDesc =
If the quantity is 0 in any row, a confirmation dialog box will appear, if you click on OK, the value will change, if you click on cancel, the old value will be returned. It will be applied to the entire grid.
Hi All,I want to customize Message field (show some additional information in it) in Pick, Pack and Ship Screen.Is there any way of doing this?
Hi,I have customized a new tab called ‘Discount’ to my custom data entry screen. There are two fields called Discount Amount and discount percentage in the grid as below.When I changed a value of discount percentage, I want to set value to discount amount based on discountable amount just after the field updated. For that I used below code but it get executed when adding a new row.protected void APProformaDiscount_DisctPercent_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (APProformaDiscount)e.Row; APProforma item = APProformas.Current; decimal? amount = (row.DiscountableAmt * row.DisctPercent) / 100; //row.DisctAmt = amount; cache.SetValue<APProformaDiscount.disctAmt>(row, amount); }Even I tried with cache.SetValueExt but it also didn’t work.Note: this is custom graphCan someone help me on this to find a solution please?Thank you.
I added a new field of type PXNoteAttribute to the DAC to enable file attachment.i.e #region NoteID public abstract class noteID : PX.Data.IBqlField { } protected Guid? _NoteID; [PXNote()] public virtual Guid? NoteID { get; set; } #endregionOn testing I got the following error what could be the issue? Kindly assist.Thank you all.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.