Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Is there any official or unofficial details about compatibility with Visual Studio 2022 for customization development and integration? Any issues with developers using it now that it is released?
We have a project that will require some UI capabilities that just don’t appear to be possible with the current Acumatica toolset. I know I could do what I need with some telerik or other third party html5 controls or even asp.net controls. Is there any way to incorporate those into an Acumatica screen and use javascript or even the code behind to push/pull data into and out of the controls?
I am trying to add the Employees last name to the payroll Possessing screen so I can sort the payments by this field. I have tried to follow some instructions to get this done but can not get my code extension to process. Can someone take a look at it and tell me what I am doing wrong.using PX.Data.BQL.Fluent;using PX.Data.EP;using PX.Data.CR;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.AP;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.PR;using PX.Objects.CR;using PX.Objects;using System.Collections.Generic;using System;namespace PX.Objects.PR{ public class PRPaymentExt : PXCacheExtension<PX.Objects.PR.PRPayment> { #region UsrLastname [PXDBString(255)][PXUIField(DisplayName="Last Name")][PXFormula(typeof(Selector<PRPayment.EmployeeID, Contact.bAccountID>))][PXSelector(typeof(Search<Contact.bAccountID>), SubstituteKey = typeof(Contact.LastName)))]
I have added a custom Action Button “CustomApprove” that I press it through an event handler. This action button then displys a SmartP Panel “RoutingPanelDialogData” with OK/Cancel buttons. When user clicks on OK, I expect the method resume from the point displayed the smart panel but when I trace doesn’t hit this point at all. Can some advise what Im doing wrong?Here is my Event Handler: protected void EPApproval_RowInserted(PXCache cache, PXRowInsertedEventArgs e) //, PXRowInserted InvokeBaseHandler) { //InvokeBaseHandler?.Invoke(cache, e); APInvoice document = Base.Document.Current; EPApproval approval = e.Row as EPApproval; EPApproval approvalPrev = PXSelect<EPApproval, Where<EPApproval.refNoteID, Equal<Required<EPApproval.refNoteID>>, And<EPApproval.status, NotEqual<Required<EPApproval.status>>, And<EPApproval.approvalID
Hi Guys, Hope you are doing great.Could you please assist me on the below one:I am saving FSServiceContract record noteID value in Agreements table - RefNoteID field for reference purpose. While constructing the DataView to get the matched records infromation from the Agreements (this DataView present inside the FSServiceContractExt Graph), I am unable to get the “FromCurrent” option.Below one is the my DataView: public SelectFrom<Agreements>. Where<Agreements.refNoteid.IsEqual<FSServiceContract.noteID.FromCurrent>>. View Agreements; → Unable to get “FromCurrent” in the above DataView.Note: The noteID was defined like the below inside the FSServiceContract class. public abstract class noteID : IBqlField, IBqlOperand { protected noteID(); } Thanks in Advance.Moulali Shaik.
Hi there, I have a DAC called VendorAccountMapping and tried to the field of AP Account in Bills and Adjustments screen via this code: public class APInvoiceEntry_Extension : PXGraphExtension<APInvoiceEntry> { //protected void APInvoice_VendorID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) protected void _(Events.FieldUpdated<APInvoice, APInvoice.vendorID> e) { APInvoice row = (APInvoice)e.Row; VendorAccountMapping vendorAccountMapping = SelectFrom<VendorAccountMapping>.Where<VendorAccountMapping.vendorID.IsEqual<@P.AsInt>.And<VendorAccountMapping.branchID.IsEqual<@P.AsInt>>>.View.Select(this.Base, row.VendorID, row.BranchID); if (vendorAccountMapping != null) { row.APAccountID = vendorAccountMapping.APAcctID; } } } Weirdly enough, the above piece of code does not work but I have tried the similar piece of code as shown below for
Hi guys How can I find roots of insert data fields in HTML editor Like Notification Template form.If not able to find existing screen roots.let me know how to add /arrange DataFields in Insert button of HTML Editor in my screen.I found graph(SMNotificationMaint) name but its content is not visible Thank you all
In 2021R1, I added a button to the Details grid in Bills and Adjustments. Everything is working great. I just cannot get the button to be greyed out when the other buttons are greyed out.I can disable it so it will display a dialog that it is disabled if someone clicks it, but it just looks bad that it appears to be available. This code fires and enables/disables the button correctly, but I cannot change the visibility of it.I suspect this might be something to do with a workflow on this screen? However, in my installation of 2021R1, the workflow for this screen is not editable. You can’t even create a new workflow. I don’t even know if that would solve this for me, but either way, I’d like to grey out that button when it is not applicable.Thanks!Joe
Hi there, I am trying to insert the Calculated column onto Calculate Depreciation screen and the Calculated Depreciation field should be populated based on To Period upon processing the action Calculate Only. However, in Customization Project Editor, the fields are being listed as such they are static fields With that said, does anyone knows on how to make the field dynamically change relative to the To Period filter?
On an inquiry I am creating (not a GI), as a data view is populating lines into a grid, if a comparison test is performed with columns in the row, under certain conditions I would like to highlight a column with a warning error. So, when the grid of rows is initially displayed, there may be one or more rows that would have this warning error. I tried using event handlers, but this is not really an even that occurs in the traditional sense (RowUpdating, FieldVerifying, etc).Is there a way to do this?
Hi,I’m new to the forum, and I’m hoping someone can help. I need to make an adjustment on PO receipt for goods received. The wrong quantities were switched, so I need to adjust those entries. I went into the PO receipts and hit the return tab. I made the necessary changes, but I get this error code below when I try to save changes. Your help will be greatly appreciated.
Path name access error (attached) when specifying path to the Customization\T190\SourceFiles\PhoneRepairShop per developer course T190 page 12.
In the current clock entry screen (AM315000) you can only “Clock In” and Clock Out” by Employee ID. There is a Save button however it seems to be disabled. vvvvvv See Below vvvvv Basically I would like to change this so that I could use this as more of a data entry screen and enable the save and insert transaction buttons. vvvv See Below vvvvAny thoughts on how to accomplish this with out deep customizations?
My goal is to update the Percent field to be the calculated value based on the weight divided by the total of all weights. So, if I change the weight on line one to 3, I want the percent for both lines to be updated to 50%.I’m just looking for a general approach to do this. The only way I would know to do it is to use the field updated event or the row updated event to trigger a call to cycle through all the records, get the total weight, then cycle through the records again and update the percent field on it.Any suggestions greatly appreciated.
Hey Everyone, The other day I created a GI to fetch all Payments done by Invoice and I think I achieved what I wanted. However, when I try to create a connection via oData on PowerBI I get the following error: DataSource.Error: We couldn't parse OData response result. Error: Unexpected end of file while parsing Name has occurred. Line 31, position 19.Details: DataSourceKind=OData on Acumatica I can view the Inquiry and even export via Excel, I just don’t seem to be able to connect to Excel or PowerBI via oData. Has anyone experienced this before? Please see below some snapshots of the Inquiry. Tables Relationships ConditionsGrid Or if anyone could suggest a better way of grabbing all payments done within the month (including credit card and cash). Sorry, I’m very new to this :) Thank you so much!!Brian SIlva
Hello gang, I have the below select in one of my methods. When there is data that meets the conditions, it works fine but when there is no data with this conditions I get an error “Sequence contains no element”. How can I prevent system from raising error. I’m checking this select result later in my code whether is null or not. EPApproval ownerApproval = PXSelect<EPApproval, Where<EPApproval.refNoteID, Equal<Required<APInvoice.noteID>>, And<EPApproval.ownerID, Equal<Required<AccessInfo.contactID>>, And<EPApproval.status, Equal<EPStatuses.pending>>>>, OrderBy<Asc<EPApproval.approvalID>>> .Select(this.Base, this.Base.Document.Current.NoteID, PXAccess.GetContactID().Value, EPStatuses.Pending).First();
I have a Customization Project that I moved to the Extension Library, to work with it in Visual Studio. Development is completed, and now I want to Export the Project Package, to install it on another system. I see that the state of the Graph source does not reflect all the changes I made in Visual Studio. How do I refresh the Code files in the project to match what is in the Extension Library?
I have an odd issue with my customization projects, where first publish will have the customization show up, but any changes to the code and then re-publishing will *sometimes* cause the customization to vanish. Version is 2020 R2, build 20.208.0031, using a local test installation. I have 2 customization projects, one with SQL views (5 DACs total), another with Attribute lookups (5 total) used for reporting. The code for the SQL views is the default code Acumatica generates, with the addition of adding the key field. Occasionally I need to make a small change to the SQL views and I edit the code to re-add one of the views. However, sometimes when I republish they just don’t show back up under generic inquiry or in the report design schema. I delete and re-add, sometimes this will fix it, sometimes it doesn’t. I receive no errors when publishing the project and get the message about the website being updated. Exiting and the page refreshes showing each of my projects published, but sti
I am working on a custom project. I created a custom field using the “NameValuePair” storage type and added to the Customer data entry screen. I initially published the customization and wasn’t sure it was what I wanted, so I removed it from the project. I later realized that it is what i wanted, so I went to add it back in. However, I now get an error message and I cannot get past it. I also get an error when I try and open that screen in my project. The error is: “An item with the same key has already been added. The customization project must be published before the screen can be edited.” I have published it without error and I still cannot edit the screen anymore. I have to revert back to a VMWare snapshot to recover.Where does this this data get saved in the DB? Is there a table I need to access and manually clear out?
The Customization Guide states that when Publishing a Customization Project, the related .cs files are copied to the Website’s App_RuntimeCode directory. This never happens. I am forced to manually copy the .cs files. Is there a setting somewhere to control this?
I have customized Acumatica’s Cost Projection Screen (PM305000) as follow It basically have added a second grid to “Revision Log” as child to “Projection Line” grid to keep the history of changes on projection lines. Also I have customized Acumatica’s standard copy paste function to copy the “Revision Log” to the new projection revisions. The method code is as follow: protected virtual void CreateNewProjectionWithLog(PMCostProjection original, PMCostProjectionCopyDialogInfo info) { PMCostProjection newDoc = new PMCostProjection(); newDoc.ProjectID = original.ProjectID; newDoc.ClassID = original.ClassID; newDoc.Description = original.Description; newDoc.RevisionID = info.RevisionID; CostProjectionEntry target = PXGraph.CreateInstance<CostProjectionEntry>(); target.Clear(); target.SelectTimeStamp(); newDoc = target.Document.Insert(newDoc); foreach (PMCostProj
Hi all,This is a custom screen with a custom DAC and table. I keep getting an error after I have inserted a row on a custom field. Error: An error occurred during processing of the field RawMaterial: Result set index too big..I have a few decimal fields on the DAC:#region LabourQty [PXDBDecimal()] [PXDefault(TypeCode.Decimal,"0.0")] [PXUIField(DisplayName = "LabourQty", Enabled = false)] public virtual Decimal? LabourQty { get; set; } public abstract class labourQty : PX.Data.BQL.BqlDecimal.Field<labourQty> { }#endregion#region RawMaterial [PXDBDecimal()] [PXDefault(TypeCode.Decimal,"0.0")] [PXUIField(DisplayName = "RawMaterial", Enabled = false)] public virtual Decimal? RawMaterial { get; set; } public abstract class rawMaterial : PX.Data.BQL.BqlDecimal.Field<rawMaterial> { }#endregionBut for some reason I only get the error on the RawMaterial field every time after a row is inserted.The actual value is either 0.00 or 1.0 which wouldn’t normally throw such an exception. I
Hello,Can we import/dump the SQL table data from SQL DB backup file through the Acumatica screen. If yes, could you please me know how can we acheive this? Best Regards,Naveen B
Our production team users scanners to move production on the shop floor.Scan Move is the only feature enabled on the scanners at this time. This feature doesn’t show the user the quantity ordered or quantity remaining. Is there a way to include this information on the scanner when the user is moving a production order? My goal is to eliminate reporting the wrong quantity, but still allow over issue because this does happen.Does anyone have any suggestions to help me with this?
Hello - On a sales order you can tick a sales order line as ‘Mark for Production’, then use the ‘Create Production Orders’ action to create production orders.What is the best way, in code, to get from SOLine to the production details, such as ‘Production Nbr’?The production info isn’t available from the main SOLine object so I’m thinking that I need to access a graph extension. I tried this:var rowExt = PXCache<SOLine>.GetExtension<SOOrderEntryAMExtension>(soLine);but this cannot be compiled due to a type conversion issue. I’m not sure that SOOrderEntryAMExtension is actually a graph at all. Does anyone know if there is a way to get the ‘Production Nbr’ from an SOLine object?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.