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 All,Need to know how to identify error lines( Exception included) in RowPersisting event.This is my sample screen. Thanks
I have a simple SelectFrom where I am getting all of the AMBomMatl items (joining them with the Operation and BomItem tables) who’s ItemClassID equals ‘811’, but for some reason I am not getting any results. When I look through the var object results I only noticethe ‘Single row was requested’ error which to be honest I don’t know what it means.I have been following this documentation but with no luck. I have done other SelectFrom’s before with success but not this for some reason. Any ideas?
I am trying to add a grid to store values to my custom DAC on Projects screen. But I am not able to add a new row. When I try to add new row the row is added momentarily and then just vanishes. I checked the trace and it is showing this exception. ComplianceDocuments view is available in the Acumatica code. My Custom DAC codeusing System;using PX.Data;namespace MyCust{ [Serializable] [PXCacheName("MyDAC")] public class MyDAC : IBqlTable { #region ProjectID [PXDBInt(IsKey = true)] [PXUIField(DisplayName = "Project ID")] public virtual int? ProjectID { get; set; } public abstract class projectID : PX.Data.BQL.BqlInt.Field<projectID> { } #endregion #region Id [PXDBIdentity(IsKey = true)] public virtual int? Id { get; set; } public abstract class id : PX.Data.BQL.BqlInt.Field<id> { } #endregion #region CreatedDateTime [PXDBCreatedDateTime()] public virtual DateTime? CreatedDateTime { get; set; } public abstract class createdDate
Dear Team,How to upload images to the Acumatica Site folder without without having to copy images directly to the Acumatica Application Server.For example: upload an image to AcumaticaSite/Icons/image.png The purpose is to get the image for PictureBox in Report Designer. Best Regards,NNT
I just spent an hour and a half troubleshooting an issue with a persisted string field defaulting to zero (0) and not allowing updates to it.It seems there was an issue with column name ‘Notes’.There is nothing detailed here about ‘Notes’ being a reserved column name; only ‘NoteID’. Is this a bug in 22.209.0029?
Please check the above screenshot. Can i know how to extract this currency effective date for the above invoice? it is unable to inspect.
Hi Guys,We manufacture doors, windows, and panels.Recently i have been adding fields to fully transition all our operations to Acumatica and the SO form has become quite wide and hard to navigate with the various different columns needed.To overcome this I have been trying to add additional tabs which are in essence replicas of the details tab but called ‘Panel’, ‘Doors’, ‘Windows’.To start I am just trying doors and I the details tab is essential in this as a master for all items.Below is the code i have for the door tab, i keep getting the error CS1031: Type expected and I do not know where I am going wrong.Any advice is Greatly appreciated!!!Aleksusing System;using System.Collections;using System.Collections.Generic;using System.Diagnostics;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Objects.AP;using PX.Objects.AR;using PX.Objects.CA;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.DR;using PX.Objects.EP;using PX.Objects.GL;
Hi there, I want to create a GI that shows all set emails along with a column for the number of attachments. It’s looking like I need to join the email table to NoteDoc, but it doesn’t look like this is just a PK relationship. Can anyone guide me on how to set up that join or redirect me to the correct kind of join?Once joined, I think I can just do a count on NoteDoc to find the tally. Is that correct?
I have a object that needs to be unique using a three-part key of ColumnA (int), ColumnB (DateTime), ColumnC (DateTime). I understand that the row passed to FieldValidating and FieldUpdating do not contain actual row values, just the .NewValue for the field. I’d *like* to make the error occur on the last change to the row which causes the duplicate, but I’m not seeing a way to do this. What is the preferred way to do Multi-Field Cross-Row Validation?
In screen Prepare Replenishment when pressing process this error Another process has added the 'INReplenishmentOrder' record. Please try again appears I have no customization at this screen.
Hi guys,Hope you’re all doing well,I have created a customisation to SO workflows and added a couple new statuses, Customer approved- triggered by pressing an action; In Production - triggered by creating production orders; Purchased - triggered by creating a purchase order.The issue i am having is that the create production orders screen PO505000 does not show any lines in the customised status of Customer Approved but when in Open status it does show the lines marked for PO.I have looked into the Data Access in PO505000 but couldn’t find anything, is there anything that I am missing/doing wrong?Any advice would be greatly appreciated!!!Aleks
Hello,A bit of a weird one here. I have created a new custom screen that is essentially an inquiry. I have complex parameters that I need to default which is why I am going this direction in lieu of generic inquiry. Anyway, I cannot get it to be found in selector when trying to add it as a dashboard widget. I have a feeling that there is a view or filter attribute that I am missing. I looked at Project Transaction Details (PM.40.10.00) and Commitments (PM.30.60.00) screens for reference, to no avail. I have a feeling it is something small that I am missing. Very simplified code below (I have not set where clause to interact with filter): public class BlyCommInq : PXGraph<BlyCommInq> { public PXFilter<BlyCommFilter> Filter; public PXCancel<BlyCommFilter> Cancel; public PXSelect<BlyComm> BlyCommView; [PXHidden] public class BlyCommFilter : IBqlTable { #region Year ... #endregion
Hi Team,Need to know how to save only selected rows records only. Can someone help me out? Thanks
Dear Team,I tried changing the DisplayName of the Contact field on the Case screen by doing it on “Customize Attributes”. But it didn't work.[PXUIField(DisplayName = "Contact", Visibility = PXUIVisibility.Visible)]Change to [PXUIField(DisplayName = "Contact Person")] Please help me the solution ! Note: Acumatica Version 2020 R1 Best Regards,NNT
Hi All,Need to know how to get the currently logged CompanyID and BAccountID in the graph extension.Can someone help me out?ThanksBhagya
I created a graph from another graph like the one belowSOOrderEntry docgraph = PXGraph.CreateInstance<SOOrderEntry>();but I couldn't insert the data below for the 2022 R2 versionvar relation = docgraph.Relations.Insert();So how can I insert data to the Relations tab in the sales order screen in the 2022 R2 version? It's working in 21 R1 but it's missing in 2022 R2.Do you happen to know anything about this?
I’m surprised this question has not been raised before, but I couldn’t find anything.Acumatica seems to be very limited in its ability to customize the same workflow in more than one package, especially with the visual editor. (I have managed to do this in code by creating a secondary graph extension of the original graph extension that modified workflow.) This is a HUGE problem because workflow is now so integral in creating actions that a high percentage of packages I’m writing require some modification to workflow. It is NOT a satisfactory answer to say “put all the workflow in one package” as this is simply impossible given the breadth of workflow changes that some packages have (I’m looking at you ISVs).Please tell me I’m missing something simple.
I am not able to add the default actions to the new grid I have added not sure what is the issue here.I need to add Add, Refresh and Delete actions in this grid. Please see the ASPX code for the reference
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 checking the ‘CRCase’ table on the SQL Database, the Custom field (UsrContactPhone) value is NULL.I think the problem is the return value ‘e.ReturnValue’ is not okay but I don't have a solution yet.I would like data of the Custom field to be saved to the SQL Database.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<Requ
Hi Team, I want to display only values in the labor item field selector where the earning type is selected as 'BILLABLE' on the summary tab of the 'Employee Time Card' screen. I have written the code for this, but it's not working. Kindly provide me with a solution so that I can achieve this. #region LabourItemID public new abstract class labourItemID : PX.Data.BQL.BqlInt.Field<labourItemID> { } [PMLaborItem(typeof(projectID), typeof(earningType), typeof(Select<EPEmployee, Where<EPEmployee.bAccountID, Equal<Null>>>))] [PXSelector(typeof(Search<InventoryItem.inventoryID, Where<InventoryItem.itemClassID, In2<Search<INItemClass.itemClassID, Where <INItemClass.itemClassCD, Equal<Current<EPTimeCardSummaryWithInfo.earningType>>>>>, And<CustomerClassAttr.EarningType, Equal<Current<EPTimeCardSummaryWithInfo.earningType&g
Dear Team,On the Cases screen. After selecting Business Account -> the Business Account box it will display: 'Account ID' - 'Account Name' How to display only 'Account ID' after selecting Business Account ? Note: Acumatica Version: 2020R1 Best Regards,NNT
As shown in the above screenshot i have inserted a new field named Claim Percentage for the ARTran. After enter the values for the Quantity and Unit Price fields the Ext.Price should be calculated based on that two fields. Then If a value is entered to the Claim Percentage the Ext.Price should be updated as “Qty*UnitPrice*Claim Percenatge”. This is the my expected scenario.In order to achieve this i have used a event handler in SOInvoiceEntry as shown in below.public virtual void ARTran_RowUpdated(PXCache sender, PXRowUpdatedEventArgs e) { ARTran row = (ARTran)e.Row; if (row != null && row.Qty != null && row.CuryUnitPrice != null) { ARTranExt tranExt = PXCache<ARTran>.GetExtension<ARTranExt>(row); if (tranExt != null && tranExt.UsrClaimPercentage != null) { decimal claimExtPrice = (decimal)(row.Qty * row.CuryUnitPrice * (tranExt.UsrClaimPercentage / 100)); sender.S
I have a client who wants to add cross tabs to the approve for payment screen to be able to see details about a bill without needing to click into the details, to see details about a purchase order the invoice is applied against, and to add a few more cross tabs to show project related details related to the vendor and the invoice. cross tabs do not appear to be able to be added to processing screens via no code customizations. Does anyone have experience adding this type of data to one of these screens?
I need to get all role names that are selected for the particular user. So that I could check if they’re correct.Here is the code I wrote but it didn’t work:users.UserRoles.Columns.Rolename.GetValues().Where(users.UserRoles.Columns.Selected, users.UserRoles.Columns.Selected.Equals(true), x => x.(it doesn’t find anything here)); Could someone please help me out?
Hello All,Does anyone know how programmatically we can tap (click} on special controls in the Mobile App? For example, when a field is decorated with “EmailSend” instead of a user tapping on mail icon, how do we programmatically tap like the user is doing it? In the below code, I will see a mail icon so I want to tap on it from an action button instead of the user doing that. update screen XX000000{ update container "MyContainer" { update field "MyField" { special = EmailSend } }}
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.