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,Could anyone let me know the procedure to add “Activity” Tab in a new screen. Regards,Ramya
Hi,iam pulling SOLines items in a new grid using Soline view, but i Dont need all the SOLines and i need to apply a filter, How can i modify my view to acheive that? any help is greatly Appriciated Thanks in Advance
We had a fairly complex workflow defined via the GUI in Customization Projects, but the last upgrade gave us a lot of errors trying to upgrade the workflows for custom screens. The recommendation was to move from GUI based workflow to Code based workflow, so I’ve been learning about writing custom workflows via code in Visual Studio and even wrote a series of blog posts on my personal blog to share my “one step at a time” learning approach for the basics of coded workflows.Although almost all of our workflows have been converted to code, one challenge still stands in the way. Auto-Run Actions. We have 2 actions (1 per screen on 2 different screens) that need to run automatically under a specific condition. We had them working in the GUI version, but I cannot find how to code this in the workflow. The only examples in the code repository are for InitializeState, but “copy cat” programming isn’t giving me any results on this one.GUI versionThe action called is defined as PXAction i
I have a custom unbound field on the Kit Specifications grid UsrQtyOnHand. public class INKitSpecStkDetExtCummings : PXCacheExtension<PX.Objects.IN.INKitSpecStkDet> { #region UsrQtyOnHand [PXDecimal] [PXUIField(DisplayName = "Qty On Hand", Enabled = false)] [PXDefault(typeof(Search<INItemStats.qtyOnHand, Where<INItemStats.inventoryID, Equal<Current<INKitSpecStkDet.compInventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)] [PXFormula(typeof(Sum<INItemStats.qtyOnHand>))] public virtual Decimal? UsrQtyOnHand { get; set; } public abstract class usrQtyOnHand : PX.Data.BQL.BqlDecimal.Field<usrQtyOnHand> { } #endregion }I want to go to the INItemStats table and pull the QtyOnHand value for the current inventory id on the grid line.I can do it in the row selected handler, but I don’t know why my PXDefault is not working.I added a PXFormula but that didn’t hel
I published customization in a production tenant, assuming it would add the new screens to the test tenant also. It did not, so attempted to publish in test tenant. I got the error below:I then unpublished in the first tenant, then tried publishing in test. Same error. I found this: acumatica - Error when attempting to Publish Customizations (Cannot access the uploaded file) - Stack OverflowI located the missing file within the customization, but I don’t understand what the above post means by “remove file link reference”. Nothing I’ve tried works. I tried deleting the file itself and re-uploading, but it says invalid file type. Then I found this: How to resolve the 'Cannot access the uploaded file' error on publishing a customization project | Community (acumatica.com)Tried and didn’t work. I’m sure the missing file I found is the problem, but I can’t figure out how to fix it. Anyone know?
Hi, I created a new form and add a grid control. I added all necessary fields but when I try to use the column header filter and click the enter key, the grid refresh but do not filter the grid. If click the ok button, the grid filter successfully. How I can fix it?In other Acumatica windows works well. thanks,EV
I’m having trouble figuring out the code to allow me to modify the workflow of preventing a field from becoming disabled at shipment confirmation. The field I want to allow edit’s is ISPSUCC128 Here is the code I’m attempting to use but I’m getting a validation error public class SOShipmentEntryExt : PXGraphExtension<SOShipmentEntry> { protected virtual void SOShipment_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler) { InvokeBaseHandler?.Invoke(cache, e); SOShipment row = e.Row as SOShipment; if (row != null) { Base.Document.Cache.AllowUpdate = true; PXUIFieldAttribute.SetEnabled<SOPackageDetailEx.ISPSUCC128>(cache, row, true); } } } Thanks,Justin
I have extension code like this #region StateID [PXDBString(50, IsKey = true, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "State ID")] [PXDBDefault(typeof(State.stateID))] [PXParent(typeof(SelectFrom<State>. Where<State.stateID. IsEqual<District.stateID.FromCurrent>>))] public virtual string StateID { get; set; } public abstract class stateID : PX.Data.BQL.BqlString.Field<stateID> { } #endregion and in other custom field, I want to select district from state but in district, I cannot filter it by state field. What am I missing ? #region UsrDistrict [PXDBString(50)] [PXUIField(DisplayName="District")] [PXSelector(typeof(Search<District.districtID,Where<District.stateID,Equal<Current<State.stateID>>>>), typeof(District.districtID), typeof(District.name), DescriptionField = typeof(District.name))] public virtual string UsrDistrict {
I try to customize by using pxsplitcontainer, everything working fine but only delete in second grid not show save action <px:PXSplitContainer runat="server" SplitterPosition="250" ID="splitConditions" Orientation="Horizontal"> <AutoSize Enabled="true" Container="Window" /> <Template1> <px:PXGrid runat="server" ID="grid11" Height="150px" SkinID="DetailsInTab" Width="100%" SyncPosition="True" Caption="Province"> <AutoSize Enabled="True" MinHeight="150" /> <Levels> <px:PXGridLevel DataMember="CountryStates"> <Columns> <px:PXGridColumn DataField="StateID" Width="200px" AllowShowHide="False" /> <px:PXGridColumn DataField="Name" Width="350px" AllowShowHide="False" /> <px:PXGridColumn DataField="SalesTerritoryID" LinkCommand="<stub>" Width="100" CommitChanges="true" /> <px:PXGridColumn DataField="S
Dear ALL,How to change the format of date fields on screens to: DD/MM/YYYY Is there any way to change the format of date fields on all screens in the simplest way? Best Regards,NNT
Has anyone successfully added an existing screen not normally in the mobile application using the new Mobile Workspaces Screen? Prior to go-live we had added the SOShipment screen SO.30.20.00 to the app to allow the shipping team to upload photos of outbound pallets to the shipment. This worked beautifully until the upgrade but the screen is now not showing in the drop down to add to the list of items on the WAREHOUSEMANAGEMENT workspace. I can’t find anything in the help about what to do if the screen does not show in this list.There is no error in publishing the page via the customization package.Any help/advice on what to try next is greatly appreciated
I have a question related to an issue with SO Line Details Allocated flag. After the receipt is released for an SO line linked to PO, the Allocated flag is automatically set in the SO Line Details but unchecking and checking the Allocate flag again result in error, though the Allow Negative Quantity flag is set on the Item Class of the SO line Item and the “Ship in Full if Negative Quantity Is Allowed” flag is set on the Order Type:Have anyone faced this issue? I would like to note that the issue happens only if the Item Available Qty is negative.
Hi,I need to change what displays on the SO screen when selected a Location. By default, it isLocationCD - Descr We want to change it to LocationCD - AddressLine1I can add the field easy enough in the Selector, but how can I add it to the DescriptionField ? If I change it toDescriptionField = typeof(Address.addressLine1),It just shows the locationCD on screen. I realize it is from a different DAC, so I guess the question is how do I get the info from the other DAC? Thanks in advance. [PXCustomizeSelectorColumns( typeof(PX.Objects.CR.Location.locationCD), typeof(PX.Objects.CR.Location.descr), typeof(PX.Objects.CR.Address.addressLine1))][LocationActive(typeof(Where<Location.bAccountID, Equal<Current<SOOrder.customerID>>, And<MatchWithBranch<Location.cBranchID>>>), typeof(InnerJoin<Address, On<Location.defAddressID, Equal<Address.addressID>>>), De
Hi,I created a custom processing screen and is working as expected. I configured an schedule and is running fine, but in the Automation Schedule History window the total records always is zero.For the DAC I’m using an SQL View. public class NewWindow : PXGraph<NewWindow >{ public override bool IsDirty => false; public PXFilter<Filter> filter; public PXCancel<Filter> Cancel; [PXFilterable] public PXFilteredProcessing< ShipmentToProcess,Filter, Where<ShipmentToProcess.processflag,Equal<Current<Filter.processflag>>>> Document; public NewWindow () { Document.SetProcessCaption(PX.Objects.IN.Messages.Process); Document.SetProcessAllCaption(PX.Objects.IN.Messages.ProcessAll); } public void _(Events.RowSelected<Filter> e) { IUtilService serv = new UtilService();//inside this method I set the PxProcessing<class>.SetError or Info ... Document.SetProcessDelegate
I have had something similar to this happen before, and I really want to know what is causing it.Here is the scenario. I made some changes to our base customization package. It has NO MOBILE customization in it at all (and never has).We publish it to two different customers. (We’ll call them Customer Lucky and Customer Unlucky.)At Customer Unlucky, the appointment header on the mobile app loses it Total Appointment Total field. At Customer Lucky’s the appointment screen on the mobile app was fine.They both had a separate Mobile Application Customization, that was identical (it added a button to the Appointment screen). Unpublishing this customization made no difference. Both were running the same version of the Web software and the same version of the Mobile software.WHAT IN THE WORLD IS GOING ON HERE???I was able to create a customization for Customer Unlucky, and add the Appointment Balance field back on to the screen, so there was a workaround. But I want to know why such a thing c
I want to join a table (EPEmployees) twice to get employee and supervisor info and based on the user logged in I want to show either only an employees customers or the supervisors customers + the employees that report to them. This is what I have tried among a couple other ways:public SelectFrom<Customer> .LeftJoin<Address> .On<Address.addressID.IsEqual<Customer.defAddressID>> .LeftJoin<CustSalesPeople> .On<Customer.bAccountID.IsEqual<CustSalesPeople.bAccountID>> .LeftJoin<SalesPerson> .On<CustSalesPeople.salesPersonID.IsEqual<SalesPerson.salesPersonID>> .LeftJoin<Users> .On<SalesPerson.descr.IsEqual<Users.email>> .LeftJoin<EPEmployee> .On<Users.pKID.IsEqual<EPEmployee.userID>> .LeftJoin<Supervisors> .On<EPEmployee.supervisorID.IsEqual<Supervisors.bAccountID>> .Where< Brackets
Hello,I am trying to embed a webpage into a tab item on an existing screen but it is not working. I am trying two different ways based on some code snippets I found. The first, utilizes standard containers and redirect exceptions (Redirect Option). The code gets validated but every time I go to check the output, I get the following: I checked to ensure that the website is iFrame compatible and it is so I am not sure why I am getting this if it has worked for others. Below is my code, very simple.. using System;using PX.Data;namespace SampleiFrame{ public class SampleIFrame : PXGraph<SampleIFrame> { public SampleIFrame() { throw new Exception("Redirect:https://**WEBSITE**.com$target=main"); } }}The other option is to just modify the aspx directly since I don’t need any standard containers. I followed the following code (ASPX Option). I haven’t been able to make this work in the validation stage because every time I update the aspx and
I’m trying to generate wrapper classes using ClassGenerator.exe and running it as a CLI tool with the config file.I’m getting the following error as soon as executable starts:C:\Users\abaranov\Documents\Work\_AcumaticaSoftware\TestSDK_22_211_0034_35\ClassGenerator>ClassGenerator.exeWrapper generation has started, please wait. It may take up to 5 minutes for the first wrapper to be successfully generated.Process FAILED - so301000System.Exception: Unable to get screen so301000 with url /CstDesigner/abaranov_PCBCustomizations/so301000.aspx ---> System.Exception: Exception of type System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.; StackTrace: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: This method cannot be called during the application's pre-start initialization phase.Configuration file ClassGenerator.exe.config:<?xml version="
Hi Acumatica People,I am working on a field updated event handler associated with the base order quantity associated with the sales orders lines.I am a newbie to Acumatica development (took the t190 course) and I want to check the value of an extension column (for specific item classes we will utilize the value in a custom column). Here is a condensed version of my problem code: ------------------------------ public class SOOrderEntryExt : PXGraphExtension<PX.Objects.SO.SOOrderEntry>{ #region Event Handlers protected void _(Events.FieldUpdated<SOLine, SOLine.baseOrderQty> e) { if (e != null) { SOLine row = (SOLine)e.Row; SOLineExt soLineExt = PXCache<SOLine>.GetExtension<SOLineExt>(row);------------------------------I want to view the value in the custom column and throw an exception on the base order quantity column under certain conditions.I am using PXTrace.WriteInformation calls to check what is going on a
Hi, I have this problem that has been driving me nuts for the last 3 hours. This is something that I have done before without issue. Here is the problem.I want to show a grid as a tab on the Customer Maintenance screen (AR303000) with the data sourced from a view.There is a view called PortfolioCustomerVW, which for an example account (717) gives the following:There are 2,318 records in the data set above and the InventoryCD column is unique. The total number of records in the views without any filters (eg on BAccountID) is in excess of 20 million and the results are sourced from multiple tables which is why I have gone for a view (for speed and performance)I have a DAC for the above which has all the fields aside from CompanyIDAnd, a graph extensionThe issue as follows:In the grid, we have multiple records for the same item. The below shows InventoryCD ZWL004-W20 replicated many times. I exported the grid out to Excel and saw 2,318 rows of the same item code (ie. the number of
Hi, I’m creating the following records via the appropriate graphs: purchase orders, sales orders, and purchase requisitions. But things are not working as I hoped/expected. I thought the idea of using graphs to create records was that you would benefit from features added to the graph, for example if you select a customer, the graph would automatically set the currency for you. This doesn’t seem to be happening consistently and I’m wondering if I’ve misunderstood something fundamental to Acumatica development. My test system has a base currency for GBP First, I created a test customer called CUST001 and a test vendor VEND001. These both use USD currency.Next, I created records in the Acumatica UI. For a sales order I enter the customer and press save. The location and currency have been defaulted. The purchase is the same, except I use VEND001. The purchase requisition follows the same idea. I enter the customer as CUST001 and the currency is automatically set to USD.Finally, I’ve used
in 2023r1 i created a customization that is supposed to print a custom report when an order’s status changes to open. I have a PXAutoAction setup in the code and it is displaying correctly. I added the action to a new workflow that extends the SO Workflow. In the open state I added the new action with the Auto run allow set to true and the auto-run condition set to True.The action does not seem to be running. I added some information trace statements to see if they would show up in the trace, they did not.Any advice or steps that you can provide will be appreciated.
I create a user defined field UsrMarkupPct in PMCostBudget. How can I user this field in the Allocation Rules formula?I tried Amount Formula = =[PMTran.Amount] * (1 +[PMBudget.UsrMarkupPct] / 100)But it doesn’t work.
I do customization on Release of Check and Payment with the goal:When the exchange of currency change, the amount of gain (or loss) will be link to an account Gain mean: the additional revenue which come from the rate of currency → link to account 635 Loss mean: the money we loss because of rate of currency → link to account 515 This amount of money will be tracked in Project informationFor example: I have a Check and Payment Record as following: The cross rate is 26.000 (which is higher than the exchange currency in Bill and Adjustment) Then release this one will generate a GL transaction as following: Note: there is a row for Account 635 which include information from APBill and APPayment → this is what I customize Post GL Transaction: As a result, there is a Project Transactions generated This cost will be tracked in Project Cost Budget However, When I turn on Auto Post on Release, There is no Project Transaction being generated. It leads to the cost isn’t statistical
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.