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 have a customization that requires a sub-folder which has includes files in it and the sub-folder is in the Pages folder of the web site. It is Pages\AK.Ok. No problems there.HOWEVER, if I select UNPUBLISH ALL from the Customization Projects, Acumatica deletes that Pages\AK folder completely. Which causes a the customization to fail if you try to PUBLISH (all) from the Customization Projects screen. I then have to re-copy that entire sub-folder back over, (and remember to do so), before selecting PUBLISH.The question is this : Is there a way to tell Acumatica to NOT delete customization folders in the Pages sub-folder when you UNPUBLISH ALL?
Hi Team,We would like to implement the following feature.When entering a customer on the Case screen => If that customer has had previous Cases => the system automatically add previous historical Cases of the same customer on the "RELATED CASES" TAB and those historical cases 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.Curre
I want to add more selections to the Customer Status dropdown list in the Customer screen. (see screenshot below), which I am certain I can do with customization and PXString list. The question I have is this : Will I cause any issues by adding more selections to this dropdown list?NOTE : The selections I want to add are literally just various versions of Credit Hold. Like Credit Hold - Cash only, kind of option.
Hello. I want to read values from a user created dropdown field. In my customization project i want to write the code to read values from a dropdown which is in purchase order screen. how can i do it ? Thanks in advance!
Hello I’m hoping someone can point me in the right direction on this. I’m trying to create templates in a new environment that will pre-populate Accounts ans Sub Accounts based on the Template Selected. We are using Payroll and 2023R1. The fields:PMProject.BenefitExpenseAcctID PMProject.BenefitExpenseSubID PMProject.EarningsAcctID PMProject.EarningsSubID PMProject.TaxExpenseAcctID PMProject.TaxExpenseSubIDAre all available on the form but not populating when I select the Template. I have customized the Project Properties but when I unpublished the customization's it is still not working. In ProjectEntry.cs I did find a section that seems to be listing the items to copy but I’m not sure how to add things to it. Any help would be great I have tried to follow other examples of people working with this but nothing seems to work. Below is the code from the Handler. public virtual void DefaultFromTemplateProjectSettings(PMProject prj, PMProject templ) { prj.Description = templ.Desc
Hi Team,In the project screen, specifically in the Revenue Budget tab, I've included a custom field named "Revenue Task." I want this custom field to display values from the Task ID field in the Task tab. The current selector setup shows the value, but it only appears after saving the project. However, I need the selector value in the custom field to display before the project is saved.Here is my code: public class PMBudgetExt : PXCacheExtension<PX.Objects.PM.PMBudget> { #region UsrRevenueTask[PXDBInt][PXUIField(DisplayName = "Revenue Task")][PXSelector( typeof(Search<PMTask.taskID, Where<PMTask.projectID, Equal<Current<PMRevenueBudget.projectID>>>>), typeof(PMTask.taskCD), typeof(PMTask.description), SubstituteKey = typeof(PMTask.taskID))][PXFormula(typeof(Default<PMRevenueBudget.projectID>))]public virtual int? UsrRevenueTask { get; set; }public abstract class usrRevenueTask : PX.Data.BQL.BqlInt.Field<usrRevenueTask> {
The customer asked me to add the Qty Avail to the Storage Summary inquiry grid. Seems simple enough. I pulled the value from the INLocationStatus table. However, that value doesn’t necessarily match the Qty Avail in the Inventory Allocation Details screen (“IAD”). On the IAD screen, it takes into account Plan additions and Plan Deductions to get the Qty Avail value. The IAD screen has a relatively HUGE set of filters and BQL selects to get the value shown on that screen. I looked at the InventoryAllocDetEnq graph where Qty Avail is calculated for IAD. It is very complicated.Since I would have to do that big set of selects/filters/calculations for EACH line selected on the Storage Summary screen, it will definitely have a big performance hit as the Storage Summary screen can return thousands of records as this customer has many thousands of inventory items.I used the RowSelected event to pull the QtyAvail from INLocationStatus as it is a simple select from one table. Surprisingly
Hi,I have run into an issue where the Billing Period dropdown highlighted at the bottom of the image is not updated by the template selector at the top of the image.In that template, the Billing Period dropdown value has been set to ‘On Demand’, but it still shows as ‘Monthly’ as shown below. This problem doesn’t occur when I create a new record from the screen above as it gives me an empty record, so selecting the template updates the Billing Period dropdown correctly.It occurs when I create a new row from the screen shown below as it gives me a screen with some fields already filled, as shown below this first image.Creating a new row from main Projects screen Template is greyed out and Billing Period dropdown is still showing the value ‘Month’ As you can see in the image above, the template dropdown at the top is greyed out and parts of the form have already been filled in.Is there a way to make sure the Billing Period field is always grabbing whetever was set in the template, if a t
I’ve added a new field to the Lot/Serial Nbr selector field. Problem is that the width of the selector screen remains the same. In order to see the new field the user has to scroll to the right. I’ve highlighted the scroll bar on the screen shot below.Is there a way to change the width of the popup screen so that I can ensure my field appears?I’ve tried updating a few of the screen properties but these appear to affect the field on the base grid rather than the popup. I also had a look at PXSelector attribute but none of the properties look very promising.
I am trying to attach a file one specific report to the shipment record when the shipment is confirmed. Can anyone here help me with the flow on how to do this with a customization. Thanks
This is a custom-made screen and by clicking the “PRINT REPORT” button a custom made report can be executed. But now when click the “PRINT REPORT” the above message popups as in the above screenshot. Can I know how to troubleshoot this?
Is there a way to customize/add data on this shipping label?
Dear Team,How to enable “Create Sales Order” and “Create Invoice” features in Opportunies screen ? Note: Acumatica Version 2020 R1 Best Regards,NNT
Hello all, I have come across a wierd situation. In my extension to “EPWeeklyCrewTimeEntry” screen “EP307100” I simply want to rename one of existing grid columns to match with my import excel file column name. So I have added a CacheAtached event that works fine. Column is renamed, user does normal data entry, saves and so on. The problem I am facing surfaces itself when I use “Upload” button to import from Excel. The uploads works as meant to work and imports all data correctly BUT at the end shows a dialog saying “Unable to cast object of type 'PX.Objects.CR.BAccount' to type 'PX.Objects.EP.EPEmployee'”. If I click OK I still can save the imported data without any issue but after spending couple of hours, I can’t seem to figure out why this errors is thrown at the end when everything is imported correctly. If I comment the event code I do not receive this error. I have tried both old and new syntax, tried Append, Merge and even Replace the attributes and on all of them I get the sam
FYI, self taught, have a lot of python backgfround and now trying to learn C# with Acumatica. So I have a a PXFilter View and I have populated it with some data from the T100 Acumatica local installation. When I debug I can the information is in it but one row of data is under the Current folder and the rest of the rows are in the Inserted folder. Here is a screenshot. For some reason when I pass it to the FormGrid on the UI only the row from the Current folder shows. See here. Here is a screenshot of the Customization showing I have the CombinedView set as the datamember for the grid. Does anyone know what I am doing wrong and why the rest of the rows are not populating? --UPDATE--I just found a different spot in the View that has the same Current folder with same data. I am not sure what this is used for as it is outside of the cache.
Hello, I want to display a pop up message when the quantity is entered on a sales order line if a condition is met. I have the following:protected virtual void _(Events.FieldUpdated<SOLine, SOLine.orderQty> e){ SOLine row = (SOLine)e.Row; if (row == null) return; if (row.Qty > 10000) { WebDialogResult res = Base.Document.Ask("Warning", "This is a large order", MessageButtons.OK); }}This works, as shown below. I enter a sales order and the message appears. The problem is that the message also appears when a Sales Quote as converted to a Sales Order.This makes sense since the SOOrderEntry is used to perform the convertion. Is there any way to check whether the UI is being used to enter the sales order, or to check which graph has called the SOOrderEntry graph? Thanks
Hello everyone,I have created a tab called fulfillment, I need it to display Normal Purchase Orders and the corresponding purchase receipts that fulfilled the blanket order. I have tried to find any data or fields I could use to link the tables in order to get the required output. But haven't found enough to enable achievement.could anyone be having an idea on how I go along to achieve this?kindly assist.Any kind of response will be highly appreciated
I would like to enable / disable the command button below ASSEMBLE KITS REQUEST based on the checkbox Auto Assemble Kits (UsrAutoAssembleKits). The command button is linked to an action and working correctly thanks to @Naveen Boga.. I assume its connected with the Field_Updated event. the ID for the command button is CMD3namespace PX.Objects.SO{ public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { public PXAction<PX.Objects.SO.SOOrder> UsrKitsAssembleReq; [PXButton(CommitChanges = true)] [PXUIField(DisplayName = "Assemble Kits Request")] public virtual IEnumerable usrKitsAssembleReq(PXAdapter adapter) { if (Base.Document.Current != null) { SOOrderExt soOrderExt = Base.Document.Current?.GetExtension<SOOrderExt>(); SOOrder soOrder = (SOOrder)Base.Caches[typeof(SOOrder)].Current; if(soOrder.OrderNbr.Contains("NEW") == false){
Should user-defined fields be created using a customization project or just adding them directly into Acumatica is fine? I have not setup a customization project before but I have heard that creating customizations within a customization project is recommended since you can apply and unapply with the upgrades. I am trying to consider if there will be any issues with upgrading and user-defined fields.
Hi,I want to create a JSON body when user clicking the REMOVE HOLD in PO Screen.public IEnumerable ReleaseFromHold(PXAdapter adapter, ReleaseFromHoldDelegate baseMethod){ RootObject obj = new RootObject(); obj.OrderNbr = order.OrderNbr?.ToString(); obj.PromisedOn = order.ExpectedDate?.ToString(); obj.Status = order.Status?.ToString(); foreach (PXResult<POLine> result in polineIntview.Select()){ POLine line = result; Details detail = new Details(); detail.Amount = line.CuryExtCost?.ToString(); detail.CustomerOrderNbr = SOOrder.PK.Find(Base,"SO",line.SOOrderNbr).CustomerOrderNbr?.ToString(); detail.DiscountAmount = line.CuryDiscAmt?.ToString(); detail.DiscountPercent = line.DiscPct?.ToString(); if (obj.Details == null) obj.Details = new List<Details>(); obj.Details.Add(detail);
When i publish my customization to print labels from the shipment screen and publish to multiple tenants, The forms show on the screen in both tenants as expected. However they will only show in the actions web services for the main tenant. But are missing from the other tenant Any idea what is cause this … this is keeping me from showing the forms on the mobile for the other tenants .
Hi,I am trying to add a new custom checkbox field as a grid column in the Process Shipments screen called UsrRequiresInvoices, and this custom field resides in the BAccountExt DAC. I imagine I would need to create a custom DataView that pulls in this field, but I wasn’t sure if I needed to structure it in a certain way to ensure the Process Shipments screen still functions as expected. The image below shows how the custom field is currently sitting in the Customers screen. The reason for this field is to identify customers that only want the final shipment invoice to be sent to them without receiving a Shipment Confirmation beforehand. If it is possible to add this custom field as a column via a custom DataView, what would be the best way to structure it? Let me know if I can provide any further information on this. Kind regards,Andrew
Hi,I’m wanting to extend SOInvoiceFilter on Process Invoice and Memos (SO505000) to enable filtering on Customer Class. Have made a start and think I’m mainly on the right track but have a problem I can’t quite crack. Think the answer to this should be relatively simple.So far, I have extended SOInvoiceFilter as shown below to add a selector for Customer Class: Have added the new Customer Class selector to the Form with Commit Changes = TrueHave extended the graph: The above is all the changes I have made so far. What is happening is on changing any of the fields in the filter, I get: I think that the issue must be that BQL in the graph extension is not correct, but I can’t spot the issue.Any help would be greatly appreciated. Also, I’m not 100% sure on what other steps will be required to get the extended filter to work on the grid so any pointers on that would also be helpful. My thinking was I would need to override GetInvoices() so that it returns records based on the SOInvoic
Hi guysHow do I add import and export functions to my customized screen tool bar on clipboardas shown in the shot thanks.
Hello,We are working with the WMS functionality and the message text shows the KEY (CD value) which is useless if you don’t have intelligent numbering. If we are trying to get away from paper (true paperless) we need the ability to expose both the KEY and the Description of the stock item in the message shown on the main screen of WMS on mobile. It looks like there are two options-Try to figure out how to update the message to show KEY - Description. I don’t know how much effort this would be but I imagine a lot since there are a lot of different strings that get created in the message box. Find the current pick line (I believe this corresponds to the WantedLineNbr on the ScanHeader DAC) and then retrieve the inventory id on the SOPickerListEntry and expose to the header to show as a new field on the mobile header.I have done some tinkering on the dev side and realized that the WMS was apparently rewritten recently and so a lot of the attributes/fields/functionality I’m looking to inte
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.