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,I think I’m missing something obvious but I’m struggling.I’ve overridden the ConvertQuoteToProject method on Project Quotes (PM304500).The baseMethod is called and this creates a project, I use SelectFrom to get the PMProject object and this contains the data I would expect.Now I want to access the RevenueBudget data but this is returning a null value. Is there a way for me to force Acumatica to load data into this child cache?My code is below, the final if statement always resolves to true because the Cache for RevenueBudget is null.I found the load method which I thought might fill the cache but it didn’t seem to work- graphProjectEntry.RevenueBudget.Cache.Load()public delegate void ConvertQuoteToProjectDelegate(PMQuote row, ConvertToProjectFilter settings); [PXOverride] public void ConvertQuoteToProject(PMQuote row, ConvertToProjectFilter settings, ConvertQuoteToProjectDelegate baseMethod) { baseMethod(row, settings); int? projectID
I have a user table and a grid. I want to ensure that when the user selects a customer in the From Customer field, that customer id is not already in the To Customer column.I’m using the FieldVerifying event on the FromCustomerID field to do the work.This is how I am doing it. Note that the BAccount line is just so that I can populate the error message with something useful to the user in the error message. protected void _(Events.FieldVerifying<ICSMCCustomersToMerge, ICSMCCustomersToMerge.fromCustomerID> e) { if (e.Row == null || e.NewValue == null) return; ICSMCCustomersToMerge row = e.Row; //see if FromCustomer is in the ToCustomer column ICSMCCustomersToMerge check = Details.Search<ICSMCCustomersToMerge.toCustomerID>((int?)e.NewValue); if (check != null) { //get the AcctCD so it can be displayed in the error message BAccount bAccount = SelectFrom<BAccount>.Where<BAccount.bAccountID.IsEqual<@P.AsInt>>.View.Select(this, (int?)e.NewV
Hello, My goal is to create multiple shipments from the SalesOrder SO Workflow, one for each associated warehouse. My first step was to copy over the existing action/function and ensure that it functioned as the original.The below code has been copied and slightly modified to work in an extension. I have disabled the PXLongOperation as well for two reasons, 1) it caused a PX1008 error, 2) is allows easier debugging. The code should be functionally equivalent to the default implantation, however I get the following exception:“Another process has updated the 'SOOrder' record. Your changes will be lost.” at PX.Data.PXAction`1.<Press>d__38.MoveNext() at PX.Data.PXAction`1.PressImpl(Boolean internalCall, Boolean externalCall) at PX.Objects.SO.SOShipmentEntry.CreateShipment(CreateShipmentArgs args) at PX.Objects.PM.MaterialManagement.SOShipmentEntryMaterialExt.CreateShipment(CreateShipmentArgs args, Action`1 baseMethod) at PX.Objects.SO.SOOrderEntry_Extension.CreateShipment(P
Good day all,How can I add a new field from the same data class to the records or what would be the best way to add a new field to an Inquiry screen form a pre-existing data class?For exampe:On the IN407000 screen (Inventory Lot/Serial History) in the Records grid, there are multiple fields with links to diffrent data classes.CustomerI Fields Data Class = PX.Objects.AR.Customer Any links to docuemnts, examples would be great. Thanks so much
Try to update Screen Appointment List to add addressline1 shows error after publish in mobile update screen FS400100 { update container "Appointments" { fieldsToShow = 9 add field "SettingsAddress#AddressLine1"{ displayName = "Address" selectorDisplayFormat = KeyDescription listDisplayFormat = CaptionValue forceIsVisible = True } } }
Hello,I believe the below code should always disable the BasePrice field on the IN202000->PriceCost tab. But it does not. public class NonStockItemMaint_Extension : PXGraphExtension<PX.Objects.IN.NonStockItemMaint> { #region Event Handlers protected virtual void _(Events.RowSelected < InventoryItem> e) { if (e.Row is InventoryItem row) { PXUIFieldAttribute.SetEnabled<InventoryItemCurySettings.basePrice>(e.Cache, row, false); } } }
I have a field in a custom DAC and I created a SQL constraint to ensure it is unique. [FromCustomerID] [int] NOT NULL UNIQUE,Is there a way I can setup this DAC field to enforce this constraint so that it doesn’t require the DB to be hit prior to identifying the value entered in a grid is invalid?This is my DAC field: #region FromCustomerID [Customer(IsKey = true)] [PXUIField(DisplayName = "From Customer")] [PXRestrictor(typeof(Where<BAccount.parentBAccountID, IsNull>), ICSMessages.ChildAccount)] public virtual int? FromCustomerID { get; set; } public abstract class fromCustomerID : PX.Data.BQL.BqlInt.Field<fromCustomerID> { } #endregion
Hello,Trying to update the Lead Source Dropdown with a few additional options.I would think the two following classes would work, but I do not get any UI changes. I think I am missing something simple. public class CRLead_Existing : PXCacheExtension<PX.Objects.CR.CRLead> { public static bool IsActive() => (true); #region Source [PXRemoveBaseAttribute(typeof(CRMSourcesAttribute))] [PXMergeAttributes(Method = MergeMethod.Append)] [PXDBString(1, IsFixed = true)] [GPLeadSource] public string Source { get; set; } #endregion } public class GPLeadSourceAttribute : CRMSourcesAttribute { public const string Email = "E"; public const string Text = "T"; public GPLeadSourceAttribute() { Array.Resize(ref _AllowedValues, _AllowedValues.Length +2); _AllowedValues[_AllowedValues.Length - 2] = Email; _AllowedValues[_AllowedValues.Length - 1] = Text;
I have a processing page to “mass delete” empty customer records. On the processing dialog, it shows the Remaining count as the total count of the records being processed until ALL items have been completed. Then, the Processed count shows all 3 items processed successfully after they are ALL complete.I’m being a bit picky here, but I want the Processed count incremented and the Remaining count decremented after each record is processed.When you click the PROCESS ALL button, this is where it starts out After processing is complete for all 3 records, it shows this: This is an example of my code: public static void DoIt(List<ICSMCCustomersToProcess> custList, bool? deleteCustomer) { foreach (ICSMCCustomersToProcess cust in custList) { try { bool? customerNotDeleted; string errorMessage; var graph = PXGraph.CreateInstance<DeleteCustomers>(); graph.Clear(); graph.DeleteCustomer(cust, out customerNotDeleted, out errorMessage, deleteCustomer, tru
To capture the business card details through the Mobile Apps, do we need to have the feature added to the license?
We are looking to manually enter (ideally import/upload) allocation amounts for a Landed Cost entry. Does anyone know if this is possible?We have been unable to identify a method to enable the field through a Customization Project, or utilize an import scenario to bring in the externally calculated allocation amounts.
Hi,What is the simplest way to programatically create and allocate Lot numbers to an Inventory receipt?I have a customisation that creates an inventory receipt, but it won’t release:Reason for this I believe is that when you go into Line Details you see:If I add the lot number here and click OK, the receipt will release. What I have ascertained so far is that this process touches a lot more tables than you might think, so there is a bit going on. After adding the serial number and clicking OK in the “Line Details” dialog box runningexec SearchAllTables @searchStr='77789'on the SQL database indicates that there are six tables involved:INItemLotSerialINItemPlanINLotSerialStatusINSiteLotSerialINTranINTranSplit I’m pretty sure that adding data into this tables directly via the customization isn’t the right way to go. I have tried to use the inspect cusomisation feature to understand what gets called when the OK button is pressed, but because “Line Details” is a modal dialog box this doesn
Hi. Can anyone assist me on how to add customized tab and grid to an existing screen that will hold a data base on a current reference number and document type. Thank you.
We are trying to add a collection of side panels to the Projects Screen.I am able to connect four of the 6 that have been requested, but the other two are causing an issue.The screen are not available for selection when setting up the side panel. I noticed the Drawing log and Photo Logs screen numbering indicated they are ‘Inquiry” type forms. Any suggestions would be greatly appreciated.
I get JSON data from ECommerce market. Then the product’s fields, such as price, quantity, customer, vendor and etc. must me mapped to Acumatica’s native fields. How does this process work in Acumatica’s original BigCommerce connector?
I’m working on some random stuff and curious how difficult it would be to do the following couple of things as an example from a custom DAC/Graph. I know I could just create inventory batches and post them or AR Invoice Batch, but is there a way to do it without all that overhead? Post an Inventory Transaction, but be able to control/set the COGS side of the transaction Post a Non Inventory Transaction and control both sides of the GL Entries Create an AR Invoice and post it, possibly overriding some of the accounting but having it calculate taxes and run normal invoice emailing and all that logic.What would be the best way to go about doing those three things from a custom set of tables?
Hi,I’m looking for some help on how to resolve the error below:This error occurs on trying to sign into Acumatica/(MYOB). I’m working on a customisation project and everything was fine until I tried to add a selector for FSEquipment. The steps I took to generate the issue were:Add field and selector to DAC Customisation has missing Assembly reference for FS Equipment, so I added that Plus, Added Reference to PX.Objects.FS This is when the problem occurred. Undoing all of the above doesn’t fix the problem. Also I think I added PX.Objects.FS from another build of MYOB which was sitting in the Browse section of the reference manager. Have been through all references and confirmed that they are from the correct version of MYOB.So, how do I Fix the error? Looks like an issue with the login page that is now referencing something it shouldn’t. I can’t get into Acumatica at all so can’t unpublish customization. Any help greatly appreciated as I’ve spent around 4 hours thus far lookin
Hi, A client is looking to have the Branch visible on the Approvals screen.That particular field is not available in the screen editor in the Add Data Fields of the Customization Project.Any advise on how to get that field published?Thank you,Mike
Hello everyone, Acumatica’s standard workflow is missing from the Change order screen. I see there is a KB that shows how this can be fixed but the type of my account doesn’t have access to the page below:https://community.acumatica.com/customization-and-development-72/how-to-resolve-the-issue-when-default-workflows-are-not-shown-on-the-customization-project-editor-4962I tried to remove this screen from the customization project and add it back but the issue still persists. Can someone please help me either by creating a PDF from the above link or if a document is attached sharing here or copy-paste the solution here, please?much appreciated.
I’m doing testing on a custom application in 2021R2. I am trying to delete a customer from the sample database and I am getting this message:I’ve run a sql query against every table that has a field name with ‘%BAccountID%’ and ‘%CustomerID%’ (which was over a hundred). The only place that account ID is referenced is in the Customer, BAccount, Location and a couple other customer setup tables. I can find no records in anything related to Equipment.I’ve tried debugging the Delete process but I cannot find the place in the available code repository where validations are done to check for orphan records, so….does anyone recognize “Equipment” and have any idea what that table might be?
Unable to load files from this location.
Hello all, Is there a way to make in input field that currently takes decimal number to take only a whole number? We have a few fields that are only used to record output quantity and scrap. To reduce errors i would like to remove decimal places as we would never scrap part of something. example We output 16 we scrap 3. Thank for any help you can provide.
I’m trying to conditionally hide a column on the Labor screen (AM301000) and I can’t for the life of me figure out the code. protected void AMBatch_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler){ if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (AMBatch)e.Row; PXUIFieldAttribute.SetVisible<Objects.AM.AMMTran.laborRate>(Base.transactions.Cache, row, false);}However, that generates an error:The entry form (ID: AM301000, title: Labor) cannot be automated. Unable to cast object of type 'PX.Objects.AM.AMBatch' to type 'PX.Objects.AM.AMMTran'.This:PXUIFieldAttribute.SetVisible<Objects.AM.AMMTran.laborRate>(cache, row, false);Does nothing - the field remains visible. I don’t think there is any workflow attached to the form.I’ve tried to access the transactions view but it doesn’t seem to be part of Base. I think that this form is pulling transactions through another layer of extensions.What am I missing?
I want to add a payment method in Acumatica so I add a new customization project for screen AR511000 and CA204000. I also have added some code into this project. When I tried to publish this project, I got this issueValidating Binary FilesPX.Objects.ACH.dll Method signature was changed: System.Void PX.Objects.GL.FinPeriodIDAttribute::.ctor(System.Type) declared in PX.Objects, Version=1.0.0.0, Culture=neutral, PublicKeyToken=nullValidation failed.How can I fix this validation failed issued?
Hi All!I have been trying to figure out how to customize an existing screen to add a tab in the stock item that is the same set up as cross reference tab, but for customer forecasting. I also would need to be able to have a user input field so we can manually input/update/change the customers forecast for that part. Then we would be able to run a report of actual vs. forecast for each item by customer. Any help or input is greatly appreciated, and any other ideas as to how to accomplish this is welcomed as well. Thanks!!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.