Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Hello Community,in CRCase there is a field called “Priority” it uses the CRCasePriorityAttribute to get its values from a PXStringList. Now I want to values to be stored into the DB by a DAC.I created the DAC and I also tried building a DAC Extension on CRCase.However it seems it doesn’t work.So far the Extension looks like this:public class CRCaseExt : PXCacheExtension<PX.Objects.CR.CRCase> { #region Priority [PXDBString(1, IsFixed = true)] [PXDefault('M')] [PXUIField(DisplayName = "Priority")] [PXSelector( typeof(Search<CRCaseMyPriority.priorityId>), typeof(CRCaseMyPriority.priorityId), typeof(CRCaseMyPriority.priorityValue), typeof(CRCaseMyPriority.sortOrder), DescriptionField = typeof(CRCaseMyPriority.priorityValue) )] public virtual String Priority { get; set; } #endregion }When I publis this the DropDownList of the Priority gets empty and no values are there to select.The DB however is populated and also the
Hello, could you provide some guidance on how to maintain the status of a sales order as 'open' even after we've issued the invoice? This specifically applies to orders containing special items. I've already included a checkbox labeled 'Is Special Item' on the sales order screen, and I thought it might assist in achieving this situation.The rationale behind keeping the order in an 'open' status is to allow it to be marked as 'complete' only when the order associated with a purchase order (PO) has arrived at the warehouse.
Hi, i have Created a form and grid in a popup of action methrod. i have added a selector to the form and when i select a value from selector, grid gets triggered and its working fine, now i want to add another selector and that selector should trigger the same grid, any help is highly appreciatedThanks in advance
I wish to display a smart panel showing some fields of a custom DAC but I'm faced to an issue I don’t succeed to understand : none of the fields in the smart panel is editable whereas I'd like the user to be able to modifiy some of them.Note : The action calling the smart panel is invoked using the 'LinkCommand' attribute from one of the column of the grid.Has anyone an idea about what’s going wrong ?ThxHere is my code snippet :1) The DAC EAPInvoiceSee embedded file EAPInvoice.cs.Below, the declaration of one of the field I’d like to be updatable. [PXDBInt()] [PXUIField(DisplayName = "Branch", Visibility = PXUIVisibility.Visible)] [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [PXSelector(typeof(Search<Branch.branchID>), typeof(Branch.acctName), SubstituteKey = typeof(Branch.acctName))] public virtual Int32? BranchID {get; set;} #endregion2) The view as declared in the BLCpublic SelectFrom<EAPInvoice>
I created a Processing screen. The grid is populated with SO Lines based on the filter. In the grid of items being processed, the Order Number is visible:When processing is complete, the Order Number is not displayed in the results screen:I added the SO number in the Message as a workaround, but I don’t know why the SO number is not showing in the results screen.I also noticed that as soon as I click PROCESS ALL, the grid is refreshed and the SO Number and Customer info is cleared from the grid during the processing.This is the select that shows the data in the grid. [PXFilterable] public PXFilteredProcessingJoinOrderBy<SOLine, RecordsToProcessFilter, InnerJoin<SOOrder, On<SOOrder.orderType, Equal<SOLine.orderType>, And<SOOrder.orderNbr, Equal<SOLine.orderNbr>>>>, OrderBy<Asc<SOLine.orderNbr, Asc<SOLine.lineNbr>>>> SOLinesToUpdate;The primary table has to be SOLine as that is what is being processed in the delegate: public S
Error: An error occurred during processing of the field RefNbr: Error: 'RefNbr' cannot be found in the system. Stack Trace: PX.Data.PXSetPropertyException: Error: '[RefNbr]' cannot be found in the system. at PX.Data.PXSelectorAttribute.throwNoItem(String[] restricted, Boolean external, Object value) at PX.Data.PXSelectorAttribute.Verify(PXCache sender, PXFieldVerifyingEventArgs e, Object& item) at PX.Data.PXSelectorAttribute.FieldVerifying(PXCache sender, PXFieldVerifyingEventArgs e) at PX.Data.PXCache.OnFieldVerifying(String name, Object row, Object& newValue, Boolean externalCall) at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, IDictionary values, PXCacheOperation operation, Boolean externalCall) at PX.Data.PXCache`1.FillWithValues(TNode item, TNode copy, IDictionary values, PXCacheOperation operation, Boolean externalCall) at PX.Data.PXCache`1.Update(IDictionary keys, IDictionary values) at PX.Data.PXGraph.ExecuteUpdate(String viewName, IDictionary k
Hello everyone, My apology for the lengthy question here but it needed to provide all pieces of the information someone might need to help.Also I have checked out these links:https://stackoverflow.com/questions/49264233/how-to-create-master-detail-grids-in-acumaticaand https://asiablog.acumatica.com/2019/04/grids-master-detail-relationship.htmlI am having a hard time understanding why deleting one record in the Parent Grid, deletes ALL records from the Child Grid instead of deleting only the records tied to that parent record. I have created a new screen made of Form-MasterGrid-ChildGrid. See the attached screenshot please.When I navigate in the Form the Master Grid refreshes correctly and when I navigate in the Master Grid, the Child Grid refreshes correctly as well. The only problem I am facing is when I delete a record from the Master Grid, the system instead of deleting only the deleted Master Record children, deletes ALL records in the Child Grid.Here are my partial DACs (Key Fiel
how to check two DAC values is equal in acumatica using if condition? ex: If the preferred warehouse is not matched between the sales order and transfer, it should not allow me to key the transfer ref no in the sales order line,Likewise, the SOnbr should not show in the transfer record eitherIf the preferred warehouse is not matched between the sales order and transfer, it should not allow me to key the transfer ref no in the sales order line,Likewise, the SOnbr should not show in the transfer record either
Hi Everyone, I’m currently customizing the ProjectEntry graph where I added a custom table to the tab. In my custom table, I have defined a date field, where I declared a default date [PXDefault(typeof(AccessInfo.businessDate))], but when I create a new empty project, I want to fill the date field with current date. Can anyone help me how to implement this? #Custom field from a custom table#region IBqlTable [PXDefault(typeof(AccessInfo.businessDate))] [PXDBDate()] [PXUIField(DisplayName = "Date MOB Promised", Required = true)] public virtual DateTime? DateMobPromised { get; set; } public abstract class dateMobPromised : PX.Data.BQL.BqlDateTime.Field<dateMobPromised> { } #endregion #region Data Viewpublic SelectFrom<ProjectCustomFields>. Where<ProjectCustomFields.contractID.IsEqual<PMProject.contractID.FromCurrent>>.View MyProjectCustomFields;#endregion I have tried to override the Initialize method but still no luck.public PXSelect<P
I have a created a custom field which I want to use to track when the item sales categories have changed. See image below:I added code to field verifying:protected void INItemCategory_CategoryID_FieldVerifying(PXCache cache, PXFieldVerifyingEventArgs e, PXFieldVerifying InvokeBaseHandler) { if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (INItemCategory)e.Row; if (row == null) return; PXTrace.WriteInformation("Set BC Updated"); // Update the BC Updated field to false try { InventoryItem inventoryItem = PXSelect< InventoryItem, Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>> >>.Select(Base, ((PX.Objects.IN.INItemCategory)cache.Current).InventoryID); if (inventoryItem != null) { PXTrace.WriteInformation("InventoryItem found" + inventoryItem.InventoryID); } InventoryItemExt invItemExt = PXCache<I
I use this code to create poRQRequestEntry_Extension.CreatePO(requisition);It didn’t create po from that extension and in 2018R1 this function working properly but in 22R2 it’s not working. and no error no result of create
my code like but the po is still hold. so how to invoke remove hold action in code POOrderEntry instance2 = PXGraph.CreateInstance<POOrderEntry>(); instance2.Document.Current = (PX.Objects.PO.POOrder) instance2.Document.Search<PX.Objects.PO.POOrder.orderType, PX.Objects.PO.POOrder.orderNbr>((object) field0, (object) field1); instance2.Document.Current.Hold = new bool?(false); instance2.Document.Update(instance2.Document.Current); instance2.Save.Press();
I’m working on the following process graph:When debugging, the prepay.Record registers as null, despite the prepay having a single complete record of the invPrepayList resultset. Visual studio does not flag the application of the result.record.fields to the new rec fields as an error. It simply runs as though the record is null. Can anyone tell me what I am missing?
. Invoice To Cancel Invoice Action to show this error How To slove this error ?public delegate void PersistDelegate(); [PXOverride] public void Persist(Action del) { if (Base.Document.Cache.GetStatus((object)Base.Document.Current) == PXEntryStatus.Inserted) { if (Base.Document.Current != null) { ARTran objARTran = Base.Transactions.Select().FirstTableItems.ToList().FirstOrDefault(); if (objARTran != null) { SOOrder objSOOrder = SOOrder.PK.Find(Base, objARTran.SOOrderType, objARTran.SOOrderNbr); if (objSOOrder != null) { SOOrderExt soOrderExt = objSOOrder.GetExtension<SOOrderExt>(); ARInvoiceExt invoiceExt = Base.Document.Current.GetExtension<ARInvoiceExt>(); invoiceExt.UsrCommentQuote = soOrderExt.U
Hi Team,I need to make changes in the selector of the 'Labor Items' field in the 'Employee Time Card' screen's details tab, based on the earning type I am selecting. Kindly assist me in how I can customize this. Please find attached images. If the earning type = RG, then Labor Items displayed should not include those that begin with X. If Earning Type <> "RG, the Labor Items displayed should be only whose that begin with X. We will wait for your response.RegardsSagar
I have a sales order with a pre-payment on it. The pre-payment has a balance meaning that the Applied to Order value is less than the value of the pre-payment and less than the value of the order.In my case I have a detail line on the sales order that is increasing in value and I would like to bump up the Applied to Order value accordingly.However, when I try to do this via code, I get an error: Entry must be less or equal to $X. $X is always the value of the Applied to Order amount.Is there something that I’m missing that I need to do to the order so that I can change the SOAdjust record?public PXAction<SOOrder> TestPreAuthEdit;[PXButton(CommitChanges = true, IsLockedOnToolbar = true, Category = "")][PXUIField(DisplayName = "Test Pre Auth Edit", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = true)]public virtual IEnumerable testPreAuthEdit(PXAdapter adapter){ SOOrder order = Base.Document.Current; foreach (SOLine line in Base.Transacti
I am unable to open Modules in Acumatica.After login system will continuously processing and processing nothing after that showing and can’t even display modules as well.Need help , Thanks in advance.
Friends, I’ve posted this question before, but unfortunately, the solutions to the first question are not an optionI am trying to extend a customer to a vendor or a vendor to a customer programmatically. I want to get my application certified for the marketplace. However, SQL Views are forbidden. SO, my current solution will prevent me from getting a certification.Here is the issue. There does not seem to be a way within C# and the available DACs to retrieve a deleted customer or vendor record. If I try to extend a customer to be a vendor programmatically, when I add the vendor account, it errors because Acumatica sees it as a duplicate.I need to be able to determine if a vendor account is in the db with a DeletedDatabaseRecord = 1 if it is there and of a deleted status, change it to no longer deleted.If I cannot find a way to extend a customer to a previously deleted vendor without using SQL Views, I kind of screwed.
I was looking to add some functionality to the Generic Inquiry (SM208000) form but it does not display it’s BLC or DAC in the source code viewer. The Screen ASPX displays just fine.Wondering if that’s intentional since it’s core functionality.
I am working on customizing the Acumatica Mobile app. I have the sales order on the app. Now I want to be able to search the sales orders by scanning a barcode. On the screen which displays all the records, is there a way to add the option to scan a barcode to the input box?Thanks in advance.
We’re looking to implement calendaring / scheduling screens that allow end users to get a greater understanding of staff and employee resource usage over time. We are aware of the existing calendaring and scheduling screens which are limited to service orders and appointments. We’d like to be able to view general activities and events in the same view as booked appointments. In addition to the data sourced locally from Acumatica we would also be looking to integrate external data sources such as Outlook (365).I’m aware this topic and related topics surrounding scheduling have reached the stage of “Gathering Feedback”. We may need to implement something in the near future and probably cannot wait for the ideas to reach a major release.My immediate question is regarding the built-in “Bryntum” libraries that are currently used to provide the scheduling and calendaring views. It appears Acumatica have a general license for this to allow those libraries to be redistributed.Can a developer c
Hi, i have added a Custom UDF for SOLine on Sales order screen, everything works fine, but when i apply a filter to that feild it doesnot work, any help will be greatly appriciatedthank you
Hi all, I’m trying to accomplish this here from a previous post of mine:Basically, I want the Shipping Tab > FOB Point dropdown menu to default to the value “Clarkdale”. We only have two FOB Points defined in our preferences -- Origin and Clarkdale.So I added [PXDefault(CLARKDALE)] to a customization project, appending to the original menu settings: Saved and then attempted to publish. I received this Validation failed error:Help! I’ve only done a few customizations before and have never edit menus so I’m doing something very wrong, lol! Thank you!
Greetings,I am currently working on my first proper customization and have some trouble with field values.The plan is to include another fourth addressline in addition to the already existing three addresslines, not only in the Customer-Data but also for use in invoices and other forms.I went ahead and wrote these two Extensions:AddressExtension:using PX.CS.Contracts.Interfaces;using PX.Data.ReferentialIntegrity.Attributes;using PX.Data;using PX.Objects.Common.Bql;using PX.Objects.CR.MassProcess;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects;using System.Collections.Generic;using System.Diagnostics;using System;namespace PX.Objects.CR{ public class AddressExt : PXCacheExtension<PX.Objects.CR.Address> { #region UsrAdressLine4 [PXDBString(50)] [PXUIField(DisplayName="Adresszeile 4")] public virtual string UsrAdressLine4 { get; set; } public abstract class usrAdressLine4 : PX.Data.BQL.BqlString.Field<usrAdressLine4> { } #endregion }} ARAddressExt
Hi all,I would like to do similar to what is done here:What I would like to do differently is to remove to of the default values, “Organic Search” and “Campaign”. When I select those values, however, I can’t uncheck Active or hit x to delete.Is there any way to delete an out of the box combo value?Thanks!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.