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 Team,We would like to implement the following feature.When entering a customer into the Case screen => If that customer has had previous Cases, the system automatically adds rows of the previous Cases in “RELATED CASES” TAB and are arranged in CreatedDateTime of Cases. I created Event RowInserted but haven't achieved results yet.Please advise how to do this. Note: Acumatica Version 2020R1 Best Regatrds,NNT //////////////////////////////////////////////////////namespace PX.Objects.CR{ public class CRCaseMaint_Extension : PXGraphExtension<CRCaseMaint> { #region Event Handlers protected void CRCaseReference_RowInserted(PXCache cache, PXRowInsertedEventArgs e, PXRowInserted InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (CRCaseReference)e.Row; if (row == null) { return; } CRCase rRCa = Base.Case.Current; CRCase cRCase = PXSelect<CRCase,
Hi All,Need to clear the data view in the graph in the beginning. Currently following view returns data from the table. But I need to remove coming data from the view and show the grid empty(As per attached image).public SelectFrom<HMRCVendorRegisterDetail>.View VendorRegisterDetail_X;Can someone help me out?Thanks
Hi,I need to trim a part from the string in my report field.This is my report I need to show ST2-MATERIAL HANDLING -GST value as MATERIAL HANDLINGand ST2-AGRICULTURE PNEUMATI -GRN as AGRICULTURE PNEUMATI How can i do from the report designer in acumatica
I have a few processing screens that I’ve created recently that I just noticed recently don’t update their progress until the processing is completely finished. For example, if I process 25 records, the progress bar will spin indeterminately with 25 ‘remaining’ until it has completely finished, and then all 25 will be ‘processed’.This does not strike me as being normal behavior, but I wanted to check in to see if anyone else has experienced this or if I am doing something wrong. I am working with 22.209
Hi,I added the user defied field (UsrFlag) in the POLine table, I've extended the Endpoint to add the custom field. How I can pass the user defied field to the PurchaseOrderDetail class using the Custom property? Thanks,Ev
Hi,Previously I asked similar question in this topic and I was provided by this linkHowever that is not what I needMy aim is to call an external code which consists of html, css and javascript which will show a new dialog windowFor example : user presses some button, after that my new method in my visual studio customization project is called and I need to call new Acumatica window which will depict this html, css and javascript viewHow can I achieve this ?
an error occured while importing data into table i swill back up data but this erorr , why ?,can help me , what this problem ?thanks
I know I just asked a similar question recently, but I am still having an issue. I really need to be able to use a dynamic value in the PXSelectBase command.In this code, I am overriding a PXSelectBase command. (public delegate PXSelectBase GetShipmentsSelectCommandDelegate(SOShipmentFilter filter);) One of my overrides works, but the one with the GroupBy / Having clause fails.This one works. Note that the And is pulling from the ICSProcShipPref.QtyLessThan field in my custom table. If I change the value in the table, the result set comes back as I would expect. This allows me to use a dynamic amount to be selected based on the value in the table at run time (not have to use a constant). cmd = new SelectFrom<SOShipment>. InnerJoin<INSite>.On<SOShipment.FK.Site>. InnerJoin<Customer>.On<SOShipment.customerID.IsEqual<Customer.bAccountID>>.SingleTableOnly. InnerJoin<SOOrderShipment>.On<SOOrderShipment.shipmentNbr.IsEqual<SOShipment.shipm
Hello all, I have come across a special need that requires changing of “Time” field in EP317000. The graph is EPWeeklyCrewTimeEntry, the DAC is EPActivityApprove (driven from PMTimeActivity) and the field in question is Date. This is one of those fields that has DateTime value but in the UI Date part and Time Part are displayed in two different columns of the grid. Out of the box, these two fields carry a DisplayName of the “Date” and the “Time” that absolutely makes sense. But for a very good business case reason, we need to change the “Time” column DisplayName to “Hours”. When I look at the field property on the UI the platform assigns “Date_Time” name to the “Time” column but in reality, such a field does not exist at all. So the question is how can I change the name of a field that does not exist in DAC. Just to be clear I am not referring to bound and unbound properties. The “Date_Time” is a made up column name that does not exist in DAC. I need to 1) change the DisplayName presum
HiI’d like to create a new Mailing ID but I could not find the screen where these records are managed. Is this possible? (they can be selected via the Customers screen, on the Mailing & Printing tab) I did find the table used to store the Mailing ID records: NotificationSetup. The existing records were created by screen SM209900, but I couldn’t load this screen via the UI.Have experimented by adding a record manually to NotifiationSetup via a DB script, seems to work but not sure if this is a recommended approach.My other option is to override an existing Mailing ID, which is my Plan B at this stage. ThanksJames
Default length for value field is 255 in CSANSWERS table. We are getting cast error after we extend DAC to 500. Since the field is shared with different control types. So what could I do to extent the field length to allow longer text for Text type attribute? Thanks.
Hi all,Previously I have asked a similar question on this. In DataSource of the page in Customization Project Editor, setting the PageLoadBehavior to ‘GoLastRecord’ solved this issue only when using Web Application.But when we use mobile application it is still showing the list of records instead of last record.Is there any way to add this behavior to Mobile application as well? Thanks
I will need to do this in four different Graphs, but let’s start with the most common one: Sales Orders.When entering an InvertoryID in Sales Order Detail (SOLine) Acumatica does a search inside VendorID --using the InventoryCD as well as Inventory Description-- as they enter the item: My customer has two more fields they would like to also search on. But these fields do not exist in the default InventoryItem DAC. There is a post on StackOverflow that describes how to add columns to the search (I think) ...public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry>{ public override void Initialize() { base.Initialize(); //for InventoryID lookup CR.CRAttributesFieldAttribute.Activate(Base.Caches[typeof(InventoryItem)]); PXSelectorAttribute.SetColumns(Base.Caches[typeof(SOLine)], "InventoryID", new string[] { "InventoryCD", "Descr", "itemClassID", "Color_ATTRIBUTES" }, new string[] { "InventoryCD", "Descr", "itemClassID"
Hi, i have created a Methord that Pulls Soline items, i want to throw Error for certain conditions in that methord, How can we Achive that?
I list of item show in PXSmartPanel grid panel, the navigation can move next or previous when i don’t selected item. When selected item and click move next or move previous, the navigation disable like above image. Please advice me what’s i missing ?
Good day every one,In my customization I have extended the KitAssemblyEntry (KitAssemblyEntry_Extension) and added an event handler to the release action: [PXOverride] public PXAction<INKitRegister> release; [PXProcessButton(CommitChanges = true)] [PXUIField(DisplayName = Messages.Release, MapEnableRights = PXCacheRights.Update, MapViewRights = PXCacheRights.Update)] public virtual IEnumerable Release(PXAdapter adapter) { //Base.Document.Ask("Application date does not equal to Business date, do you really want to release payment?", MessageButtons.OK); INKitRegister kitRegister = (INKitRegister)Base.Caches[typeof(INKitRegister)].Current; InventoryItem inventoryItem = PXSelect<InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>.Select(Base, kitRegister.KitInventoryID); inventoryItem.Descr = "Update from Kit Assembly"; // Update t
Does anyone know if it would be possible to create a tab on a document (sales order) where the entire tab is an iframe displaying an external website?Any example customization/code would be appreciated if you have an idea on this. Thank you!
Hello, the following code works in version 22.215.0056 but it doesn’t work in version 23.105.0016UploadFileMaintenance upload = PXGraph.CreateInstance<UploadFileMaintenance>();NoteDoc doc = upload.Select<NoteDoc>().First(x => x.NoteID == fromNoteID);if (doc == null) return; //no file attached - exitGuid g = ToGuid(doc.FileID); //this just converts guid? to guidPX.SM.FileInfo sourceFile = upload.GetFile(g);In the older version upload.the GetFile method works and returns the details of the file to the sourceFile variable. In the new version the GetFile method always returns null. I’ve checked the guid and the file I would like to access does exist in the UploadFile table. Is there a new way to access files in the newer versions for Acumatica?ThanksSteve
Hello everyone!, I hope you are fine.It's me again and I wish you could help me. I need to know if I can create a projection with a query table and save values in its fields in the other table. Can you help me solve this question?
Hi All,In my custom screen has a PXGrid which is empty in the beginning. After I add new record and press the Verify Vendors button (Some validation is added) then another new empty row added to the grid automatically. Can someone help me out to avoid this scenario?Following is my custom screens and button click event.Before the click event After the click event Button click event public PXAction<HMRCVendorRegisterDetail> VerifyVendors; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Verify Vendors", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = false)] protected virtual IEnumerable verifyVendors(PXAdapter adapter) { foreach (HMRCVendorRegisterDetail vendorRegisterDetail in VendorRegisterDetail.Select()) { if(vendorRegisterDetail.UsrSelect == false) { VendorRegisterDetail.Cache.RaiseException
Usually we are directed to Add new record when we navigate to specific screen in Acumatica. But I want to redirect user to last record when user initially navigate to that screen.Also, please note that this is a new screenIs there any way to do this?
Hello Community,I have been trying to add a Contact selector field in the Stock Items (IN202500) but looks like there’s something I am missing here. Can anyone guide me out what else I am missing here?Code Attribute:[PXDBInt][PXUIField(DisplayName = "Contact", Visibility = PXUIVisibility.SelectorVisible)][PXSelector(typeof(Search<CRContact.contactID>), new Type[] { typeof(CRContact.contactID), typeof(CRContact.fullName), typeof(CRContact.email) }, SubstituteKey = typeof(CRContact.contactID), DescriptionField = typeof(CRContact.fullName), CacheGlobal = true)]
I am overriding the Process Shipments screen by adding a custom filter. For testing, I created a “Five” class and if I put Five instead of @P.AsInt, it works great. In the PXSelectBase command, I am able to put @P.AsInt in the statement, but I don’t know how to pass in my value. How do I pass in the value to the @P?This is the “Five” class which returns an integer 5. public class Five : PX.Data.BQL.BqlInt.Constant<Five> { public Five() : base(ICSConstants.Five) { } }This is the command I am overriding cmd = new SelectFrom<SOShipment>. InnerJoin<INSite>.On<SOShipment.FK.Site>. InnerJoin<Customer>.On<SOShipment.customerID.IsEqual<Customer.bAccountID>>.SingleTableOnly. LeftJoin<Carrier>.On<SOShipment.FK.Carrier>.
Hi, I have created some custom fields in the Invoices and Memos screen, and in the report designer, I can see that they appear in the ARInvoiceExt table, as shown below. However, when I go to include one of these in the report, nothing seems to appear. I also tried joining the ARInvoiceExt table to the ARInvoice table by RefNbr but that didn’t seem to help either. The custom fields on the right of the image below are what I am trying to pull through: What is the best way for me to get these custom fields to pull through in the report? Kind regards,Andrew
I want to calculate TotalKHR field include with tax amount. so how to calculate tax from tax category.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.