Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
I am attempting to setup autonumbering on a key field by hardcoding the sequence ID in a constant. When the form displays, it is just showing SELECT in the field.Here is the DAC code: public class ProjectOrderNumbering : PX.Data.BQL.BqlString.Constant<ProjectOrderNumbering> { public ProjectOrderNumbering() : base("TESTPROJECTS") { } // "TESTPROJECTS" is the sequence ID } #region ProjectID [PXDBString(15, IsKey = true, IsUnicode = true)] [PXUIField(DisplayName = "Project ID")] [PXDefault] [AutoNumber(typeof(ProjectOrderNumbering), typeof(AccessInfo.businessDate))] //[PXSelector(typeof(S1CProject.projectID), typeof(AccessInfo.businessDate))] Is it possible to use constants for the sequence id, or does it have to go through a setup screen as shown in T220?
I modified the TS script and Html code of AR302000 in the local development environment. I don’t know how to publish these changes to other environments? Do you know?
Hello,Is it possible to require the user to enter a vendor to create a stock item?When creating new stock items, we want the vendor tab to have at least one vendor entered to allow the item to be saved.I do not see a way that this would be possible without creating a customization to the system.
Is it possible to link the new Project screen Project Group to approval mapping for invoices and memos? We have a situation where we need to set-up a specific approval workflow for annual invoices and doing this with Attributes on the project linked to a project type does not seem possible. Having a project group could be a solution but not sure if this can link to approval mapping. Is this possible?
Attempting to convert a sales quote to a sales order and I’m running into a blocker when trying to call DoCreateSalesOrder saying that I need to pass in a document of type CRCreateSalesOrder.DocumentHere’s what I have so far:var quoteGraph = PXGraph.CreateInstance<QuoteMaint>();var soGraph = PXGraph.CreateInstance<SOOrderEntry>();var quote = quoteGraph.Quote.Search<CRQuote.quoteNbr>(quoteNbr, opportunityId) .RowCast<CRQuote>().First();var filter = new CreateSalesOrderFilter{ OrderType = "SO", MakeQuotePrimary = false};var filterExt = filter.GetExtension<CRCreateSalesOrderFilterExt>();filterExt.AMCopyConfigurations = true;var quoteGraphExt = quoteGraph.GetExtension<QuoteMaint.CRCreateSalesOrderExt>();quoteGraphExt.DoCreateSalesOrder(soGraph, quote, filter);Appropriate any help or insight!
Adding a parameter to the Leads (CR3010PL) GI for OwnerID which defaults to “@me” works beautifully on desktop, but on mobile the parameter selector isn’t showing (the filter is technically working, because the leads are indeed filtered). This means that on mobile there isn’t a way to display all the leads, which is why I would love to use that selector.I know that we could use a shared filter, but the request is that “All Records” be filtered by default.I followed the steps outlined in this post (https://stackoverflow.com/questions/48670213/generic-inquiry-in-acumatica-mobile-app), but unfortunately the `Filter_` container isn’t displaying on the app after a publish.Commands:update screen CR3010PL { type = FilterListScreen add container "Filter_" { placeBefore container "Result" add field "OwnerID" }}Result: add screen CR3010PL { type = FilterListScreen add container "Filter_" { add field "OwnerID" } add container "Result" { fieldsToShow = 4 listActionsToExpand =
Hello community. Working through a customization project and I am having issues locating an SO using a search in a custom processing screen. In my code below my primary DAC is SOLine. I am using values from there in a foreach statement to then load the SO in an SOOrderEntry graph. However, it is not returning the SO record. Is there a better way to go about this code? The code returns “Object reference not set to an instance of an object” on the final line below when testing. Thanks,Adam
Dear Members,I have duplicate Purchase Order screen with some extra logic based on client request. Now i have request to add user defined field with Required Check true. but its not working in duplicate screen unless i add the same attribute in PO standard screen. advise how to fix this issue.Thanks,Arun
Hi I have implemented copying some custom fields from sales order header to the shipment header screen which works as expected. Now I need some custom field values copied from sales order line to the shipment line screen, I’ve implemented the below but I get the error below. using System;using System.Linq;using System.Collections;using System.Collections.Generic;using System.Collections.Immutable;using System.Runtime.Serialization;using System.Text;using System.Threading;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Data.WorkflowAPI;using PX.Common;using PX.Objects.AR;using PX.Objects.CM;using PX.Objects.CR;using PX.Objects.CS;using PX.Objects.EP;using PX.Objects.GL;using PX.Objects.IN;using PX.SM;using PX.Objects.IN.DAC.Accumulators;using PX.Objects.IN.Overrides.INDocumentRelease;using POLineType = PX.Objects.PO.POLineType;using POReceiptLine = PX.Objects.PO.POReceiptLine;using PX.CarrierService;using PX.Data.DependencyInjection;using PX.LicensePolicy;using PX.Obje
Good day, I have a situation in Checks and Payments screen with my custom fields, I need these fields to be available even after the release of the document, I have tried with events, overriding the persist method, and overriding the release, but nothing is working and the fields always become readonly, I would appreciate suggestions to solve this. Here I am adding examples of how I am trying to enable the fields with the events or overriding the Release. public class APPaymentEntry_Extension : PXGraphExtension<PX.Objects.AP.APPaymentEntry> {protected virtual void _(Events.FieldUpdated<APPayment.status> e) { if (e.Row != null) { PXUIFieldAttribute.SetEnabled<APRegisterExt.usrChkMailDate>(e.Cache, e.Row, true); PXUIFieldAttribute.SetEnabled<APRegisterExt.usrChkPickupDate>(e.Cache, e.Row, true); } }public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride]
Good day, In a customisation package I have to buttons on the Invoices & Memos (AR301000) screen - these buttons generate a report and attaches it as a file to the invoice or memo. This is the code to generate a PDF which works perfectly. #region Action Button - Export PDF Reportpublic PXAction<ARInvoice> ExportReport;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Export PDF Report", Enabled = true)]protected void exportReport(){// Report ParamentersDictionary<String, String> parameters = new Dictionary<String, String>();parameters["ARInvoice.DocType"] = Base.Document.Current.DocType;parameters["ARInvoice.RefNbr"] = Base.Document.Current.RefNbr;var filename = Base.Document.Current.DocType + "_" + Base.Document.Current.RefNbr;// Report ProcessingReport _report = ReportLoader.LoadReport("AR641000", null);ReportLoader.InitDefaultReportParameters(_report, parameters);// Read Reportbyte[] data = null;using (StreamManager streamMgr = new StreamManager()){Repo
I am trying to get a custom field to update whenever the stock item attributes are updated, but I can’t find a way to make this work.If base the row updated event on InventoryItem, it will update if other stock item fields are updated, but that doesn’t include the attributes.If I base the row updated event on CSAnswers, then that does nothing.Does anyone have any insight?public class InventoryItemMaint_Extension : PXGraphExtension<PX.Objects.IN.InventoryItemMaint>{ protected void _(Events.RowUpdated<InventoryItem> e) { var invRow = base.Base.Item.Current; var invCache = base.Base.Item.Cache; var extension = invCache.GetExtension<InventoryItemExt>(invRow); if (invRow != null && invCache != null && extension != null) { var widthState = (PXStringState)invCache.GetValueExt(invRow, "WIDTH_Attributes"); var heightState = (PXStringState)invCache.GetValueExt(invRow, "HEIGHT_Attributes");
I have 3 actions on a custom form. I set the IsLockedOnToolbar to true. public PXAction<ICSFSSSchedule> DeleteScheduleDetails; [PXUIField(DisplayName = "Delete Schedule Details", Enabled = true, MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton(IsLockedOnToolbar = true, Category = "Other", CommitChanges = true)] public void deleteScheduleDetails() This was addressed in the following topic, but the solution there does not fix my issue.All of my actions show in the title bar of the screen:I have reset the caches, restarted the application but the menu items still show.I want them to appear in the More (ellipse) menu.In the project editor, the items are in the correct category. Do I need to “instantiate” the More menu somehow since this is a custom form and there are no default action items?
Good day, I need to pass values from a custom field in APTran in Bills and Adjustment at the moment when the Bill is released and the Journal Transaction is created, I need to pass the values to GLTran to a custom field, but when I use the Actions.PressSave I get a null error, Object reference not set to an instance of an object. I can't find which is the value I am missing or which another field appears as null and is required, I compared between the null fields on cache and the fields in the database that say that are required, but all the fields that appear as null are allowed to be null so I can't find the problem.I would appreciate some assistance please.public class APInvoiceEntry_Extension : PXGraphExtension<PX.Objects.AP.APInvoiceEntry> { #region Event Handlers public delegate IEnumerable ReleaseDelegate(PXAdapter adapter); [PXOverride] public virtual IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { var
Hello,I created a Related Documents Tab in my custom screen Similar to Relations Tab in Opportunities screen.I added Transfers in Type Column, But Data is not retrieving from Transfers screen.Pls refer below screenshot.Is there any sample code for this or where I need to add code for this?Please suggest any solution for this.
There is a new requirement to establish a connection between Sales Orders (SO301000) and Bills and Adjustments (AP301000). I attempted to add two custom fields for order type and order number in the Bills and Adjustments (AP301000) form to retrieve sales order types and sales order numbers in the database, allowing the user to select them. Using this new custom column, which stores the sales order numbers, we can establish the connection. However, this did not produce the intended result. Is this the correct approach to create a connection between these two forms? Any guidance or detailed steps on how to implement this would be greatly appreciated.
Hi EveryoneThe warning message, "NTE Value Exceeded. Do you want to process it?", appears repeatedly in the Appointment form whenever "OK" is clicked. This occurs when attempting to save an appointment that was created from a Service Order form.We need assistance in preventing the warning from being shown multiple times during the save process.Could you please assist for us.
After running the Full Resynchronization for Salesforce Integration for Contacts. I have not been able to view the Import or Export Scenarios. Upon selecting the scenario, it returns this error: An item with the same key has already been added. I have some customizations but none that touch the Contacts screen, however I have tried to unpublish them, same issue, and publish them with cleanup still same issue. Here is the trace log that goes with it. I have tried creating a new Scenario and I get the same error but at the mapping levelHere is the trace that goes with that error Thanks for any guidance!
I am new to this topic and I would like to know what is the easiest way to update the information in this column. I have followed some tutorials but in the end I only get this error
Our client has a specific requirement to set the Shipping Address to the Branch Address for Purchase Orders that are of the Type = Project Drop Ship. Currently, users are manually overriding the Ship To Address for these types of Orders and they have asked us to code it such that if the type of the Purchase Order is Project Drop Ship, then to set the Ship To Address equal to the Branch Address from the OTHER tab of the PO. The following code does what we need it do; however, upon clicking save an error is generated. The error is:Error: Inserting ‘PO Shipping Address’ record raised at least one error. Please review the errors. Error: ‘RevisionID’ cannot be empty.The following code does what it needs to do, but for the error when saving:protected void POOrder_ProjectID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler){ if(InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (POOrder)e.Row; var po_branchID = row.BranchID; var
I need some help here on finding a right way to do this.I had originally asked this question about awaiting the completion of a long running operation. That question was answered, but it didn't solve the issue. I have a custom action that opens a Smart Panel to capture some data from the user, which is then passed into a long running operation to fetch physical inventory count data from Zoho and update the INPIReview document.This all works. However, when processing the import, an important step is to record any items that were counted in Zoho, that do not exist on the Physical Inventory Review document so the user can be alerted that some additional items were counted.There won’t be many items, so we simply opted to write the details of those extra items to trace, and then notify the user with a dialogue box warning them that extra items were counted and they need to review the trace log. This also works - kind of.After clicking “OK” on the dialogue box that pops up, the original Smar
Here is my use-case: a user changes a drop-down value (UsrShipStatus)I need that value to update another field (UsrDfltWarehouse), this field will then create a dialogue box where I need to select “OK”This then calls the function private void setWarehouses(POOrder row).Below is the code in use here, I’m just lost on how to even interact with a dialogue box, or if I even need to (see comments below). public class POOrderEntry_Extension:PXGraphExtension<POOrderEntry> { protected void POOrder_UsrShipStatus_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { if (InvokeBaseHandler != null) InvokeBaseHandler(cache, e); var row = (POOrder)e.Row; if (row == null) return; POOrderExt pOOrderExt = cache.GetExtension<POOrderExt>((object)row); if (pOOrderExt.UsrShipStatus == "POE") { const string CUSTOMER_TYPE = "C"; /* PORT LB - Port Long Beach */ const int PORT_
I have a Projection DAC (HCLEPEmployeeTraining) that only has 3 bound fields (EmployeeID, CourseID, ExpiryDate). What I would like to do is to show the EmployeeID in Rows, value of the CourseID as Columns and ExpiryDate as value in the intersection of EmployeeID and CourseID. This is a Grid and not a PivotTable but basically, I am making a PivotTable from these three columns. I am not using Acumatica’s Pivot Table because I have further developments on this screen. So far, I have added the CourseIDs as Columns dynamically to my grid.See below screenshot from the Screen columns dynamically are added in my Graph Constructor and Code-behind the Page.Init.Also, I have written a view Delegate that loops through the existing records and sets the Dynamically Created Columns values from the ExpiryDate. See the below Delegate: protected IEnumerable HCLemployeeTraining() { List<HCLEPEmployeeTraining> result = new List<HCLEPEmployeeTraining>(); PXRe
Hi, there are a few options for defining the format of a lot number but I need to try and extend the options. The screen shot below shows a date based setup. This leads to a lot number like 2408In the INLotSerClass table on the database you can see the format, which is : {0:yy}{0:dd}I want to add a new option called DayOfYear, there are a few challenges to getting this into the UI but if this worked I might end up with a format like {0:yy}{0:w} and this would provide a lot number like 24221w isn’t a valid datetime formatting string so I would need to adjust the Acumatica code. In the Acumatica source code in class Attribute.cs I can see that GetNextNumber is how the format is translated into a value to create a lot number. The code is below.public static string GetNextNumber(PXCache sender, INLotSerClass lsClass, ILotSerNumVal lotSerNum){ string numval = new string('0', GetNumberLength(lotSerNum)); return string.Format(lsClass.LotSerFormatStr, sender.Graph.Accessinfo.BusinessDate, numv
Hello Everyone, we are trying to associate Credit Memo with sales order, I have created an SO extension graph and in persist inserting the credit memo details based on the order total, with this approach if we are creating an order manually and saving, the implementation is working as expected. But when any order is synced from BigCommerce, it is not updating as expected and we observed discrepancies in Credit Memo applied to order total and balance amount.public class KNBCBRSOOrderEntryExt : PXGraphExtension<SOOrderEntry> { public static bool IsActive() { return true; } #region Views public PXSelect<Customer> CustomerUpdate; #endregion public delegate void PersistDelegate(); [PXOverride] public void Persist(PersistDelegate del) { del(); List<ARInvoice> curyDocBalList = PXSelect<ARInvoice, Where<ARInvoice.docType, Equal<ARDocType.creditMemo>,
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.