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 on the Opportunities screen that overrides the Persist() method.Basically the code is iterating the Products.Cache.Cached collection and checking if a particular inventory item is added and also calculating the total amount of the the extended price.If the item does not exist a new line is added and populated with a calculation using the total.This is all working very well, but i've noticed an issue where the Products.Cache.Cached collection contains values from previously loaded records.For example if I have an opportunity loaded on screen with 3 lines with a total of $500, and I select the add new record toolbar button. Once i enter the required fields on the new record and save. The total of 500 is being pulled from the previous opportunity and my new line is added based on the total 500 when it should be 0 because no lines have been added to the new opportunity.Any idea why the cache is not clearing when adding a new record. Any way I can work around it.Tha
I want to change the color of the action to pink “print pick list” in Shipments screen. Version is 2022.112.0018. There are no conditions for the action. Just like “confirm shipment”, it should have a color.Also, I need to get the “print pick list” action before “confirm shipment” action.
I am very new to customizations in Acumatica. I was wondering if it’s possible to only display certain values in a selector. For example, I would only like to display 3 out of the 9 possible values below as we would like to deprecate some of them. I’m assuming this has to be done with changes to the code, maybe a graph extension, but I have not made customizations through code changes before so I’m not sure how to approach this. If anyone has some example code for something similar, I would greatly appreciate it.
I have an API that returns a PDF file in the content is there a way that i can make a button that consumes this api and return the file in the browser to be downloaded ?the PDF file is big so i will need to await it
I have been able to add a custom field to SO301000. I am struggling with how to show/hide the custom field based on the Order Type field. I tried to create an event handler based on the RowSelected event. But, I failed. My edit hid the field always, and left the label visible always.Can anyone point me in the right direction?
Hello everyone,I have tried to make the attachment field mandatory but was unable to.I need to make it mandatory once the user approve the requisition. Kindly assist Thank you for continuous support.Any kind of response is always highly appreciated.
I received good advice about how I could create a custom field to display the total hours for each day of the week in the time card screen. As you can see below, I thought I got it to work properly; however, I keep running into an error message: Error: An error occurred during processing of the field Sat: Specified cast is not valid.. Mon Field:[PXTimeList] [PXDBInt][PXFormula(null, typeof(SumCalc<EPTimeCardExt.usrMondayTotal>))][PXUIField(DisplayName = "Mon")]Monday Hours:[PXInt][PXTimeList(30, 335, ExclusiveValues = false)][PXUIField(DisplayName = "Monday Hours", Enabled = false)]Also tried PXDBInt for Monday hours.Could I be getting this error message because how Time spent field is being calculated is the following?[PXInt][PXTimeList][PXDependsOnFields(typeof(mon), typeof(tue), typeof(wed), typeof(thu), typeof(fri), typeof(sat), typeof(sun))][PXUIField(DisplayName = "Time Spent", Enabled = false)]Not the biggest issue if I can’t get this to work, just wanted to add som
Hi all,I have a field updated event for soorder invoices screen Artran qty field which is used to get line weight by multiplying item weight and qty as below.public PXSelect<InventoryItem> dataview; protected void ARTran_Qty_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (ARTran)e.Row; ARTranExt detail = PXCache<ARTran>.GetExtension<ARTranExt>(row); foreach (PXResult<InventoryItem> result in dataview.Select()){ InventoryItem item = result; if(item.InventoryID == row.InventoryID) { detail.UsrItemWeight = item.BaseItemWeight; decimal? LineWeight = row.Qty * detail.UsrItemWeight; detail.UsrLineWeight = LineWeight; } } }usrLineweight is the custom field for Line Weight in details level of invoices screen. The line weight should be calculated just after qty field is updated. But it’s only working in the time when adding a new row. How can I solve t
Hi Team,I have simple report with two parameters, one field is the standard field(TimecardCD) and the other is the customized field(YTLApprover). I’m directly send the value for the approver from the Report screen directly. But not show why acumatica change the value to null.Can you please help me on this. Regards,Ramya Krishna
Hello, I’ve added 2 new buttons to a custom grid. An up arrow and a down arrow. I would like to be able to move row items up and down the grid. The sequence controls the order in which the sites/warehouses are checked in my code. A screen shot is above. The arrows button are highlighted. I have a field called ‘OrderNumber’ which stores the sequence of the items.The RETAIL site is selected in the grid and I will press the Up Arrow button. ..After pressing the up arrow button, my code has changed the values in the Order Number field, and the Save button is now available. But the grid has not been refreshed. If I click on the refresh button nothing happens. If I click on the Save button…....the page and data is refreshed and the grid is reordered. The view which provides data to the grid looks like thispublic SelectFrom<PinnSitePriority> .Where<PinnSitePriority.siteid.IsEqual<INSite.siteID.FromCurrent>>.OrderBy<PinnSitePriority.orderNumber.Asc>.View vie
Hi all,we have 3 tenants in our erp instance as below.Company (prod) uat2 test instanceout of these three, company tenant is being used as the production while other two tenants for testing purposes. Normally, We do our customizations into uat2 tenant, after testing and if it is ok, we publish the customizations into multiple tenants from uat2 to be applied them in the other tenants as well. We have done some customizations recently only for the uat2 tenant, but never published it to other tenants. However, without publishing from uat2 to all tenants, some of customizations have been applied in the company tenant as well. The issue is how it can be happened without giving ‘publish into multiple tenants’ from uat2? Can someone provide me a solution on this?Thank you.
Hi everyone,Just recently learned how to customize projects in Acumatica. Have done a few things successfully; however, I’m currently stumped on summing time fields in acumatica. Currently trying to have a Total Mon,tues,wed,thurs,friday field displayed in the timecard screen.I tried using the following PXFormula attribute to sum the hours in Mon field and place it into Monday total.What I used:[PXTimeList] [PXDBInt][PXFormula(typeof(SumCalc<EPTimeCardExt.usrMondayTotal>))][PXUIField(DisplayName = "Mon")]I tried using this and well it completely broke the timecard screen. I tried this out based off what I saw online, but clearly I did something wrong.On acumatica web page there is the following:[PXFormula( null, typeof(SumCalc<Document.totalCost>))]public virtual Decimal? ExtPrice { get; set; }public abstract class extPrice : PX.Data.BQL.BqlDecimal.Field<extPrice> { }} This was used to calculate total cost so I’m not sure if I should have used the PXFormu
Hello, I have created a custom grid which stores a list of warehouses. I have a requirement to perform a couple of checks. 1. The warehouse in the list cannot be the same as the selected warehouse. 2. A warehouse shouldn’t be entered into the list twice. I’ve added these checks onto the RowSelected event, everything appears to work fine, the red cross appears on the row with the problem and on the tab. I’ve used this code to raise the error:e.Cache.RaiseExceptionHandling<PinnSitePriority.prioritySiteID>(e.Row, inSite.SiteCD, new PXSetPropertyException(errDuplicateWarehouse, PXErrorLevel.RowError));When I click the Save button I see the following:This is exactly what I want. However, if I click into another row and the editing icon appears and then I click on the Save button... Acumatica doesn’t display the message - it ignores the errors reported on the grid and Saves the data, the Save button become disabled. Can anyone explain what is happening? I had expected that saving woul
I have been through the Training T400 and T410, but I cannot get this to work in my own application. I have looked at some of the related topics on here, and in StackOverflow, and nothing I try seems to work.I have a custom action that I have added to FS300200. This will call out to an external web application to allow a form to be filled out, which will eventually generate a PDF that gets attached to the appointment.This works fine from within the Web Page: In the custom DLL, the source code looks like this:#region XForm Button public PXAction<FSAppointment> asgExtForms; [PXUIField(DisplayName = "DoorForm", MapEnableRights = PXCacheRights.Select)] [PXButton] public virtual void ASGExtForms() { var allCaches = Base.Caches.Caches; /************************************************ * Code builds fuill url based on what is found in cache ************************************************/ string fullURL = "SOME VALUE BASED ON CACHE"
I have upgraded my local instance of Acumatica to match our production version via the web interface of the instance.Now, when I try to launch locally from the Configuration Wizard, I get an error To work with '[instance name]' instance, you should use newer version of the configuration wizard.I have downloaded the version of the installer that I need. But, I do not see how to upgrade. Can anyone give me the steps to take? I don’t want to cause problems with my current Acumatica instance setup/installation?
I am trying to retrieve the Acumatica Instance ID from within code as part of a licensing validation/restriction type verification. This would be for version 22R1 and newer. Thanks !!
After ticking the Outside process checkbox, I wanted to display only the vendors who registered in the selected inventory item(Stock item> Vendors) on the vendor lookup. Is there anyone who did this kind of customization?
I created a custom field with values for a drop down. Now I want to change the options for the dropdown. I want to remove 2 of the first ones and add 1.I was able to show the different values in the dropdown. But on the generic inquiry, the field is empty. Any help is appreciated.Thanks,Dominic
Hello everyone,I want make AFE number mandatory only when the approver workgroup is “AFE APPROVAL” I have tried to get that value in that field in the specified DAC but I’m getting no response on the UI. kindly assist.All responses will be highly appreciated.
Good day, I would like to use the same report designer report in both the AR Print/Email Invoice that I just revised in SO Print Invoice.I basically want the user to have the same report used in the Print Forms area. Hate have to redo it. Report version is here Sales Orders I need also here: Your assistance would be greatly appreciated.Thank youEvan
I’m attempting to add a new custom table / dac into the PO Entry screen.The new DAC is tied to POLine and it can be a one to many relationship.I have PXParent and PXLineNbr attributes defined in the custom DAC and have the appropriate dac fields marked as IsKey = True. I have a vew declared, and when I insert into the view the key fields are defaulted from the selected PO Line as they should be.When I debug, I can see the records in the cache in the Inserted collection.When I call the Base.Save.Press(), nothing is persisted to my custom table.No errors are generated, and the inserted record still shows in the cache inserted collection.I’m hoping I’m missing something simple, any ideas? View declaration public PXSelect<AHSPOLineNonConf, Where<AHSPOLineNonConf.orderType, Equal<Current<POLine.orderType>>, And<AHSPOLineNonConf.orderNbr, Equal<Current<POLine.orderNbr>>, And<AHSPOLineNonConf.lineNbr, Equal<Current<POLin
Hi, I need to create a custom table and data need to inserted from excel. Excel sheet need to get from drive location and excel data need to be uploaded into my custom table. Excel is replaced daily into the drive.So, Data import activity need to be scheduled. How to archive above both scenarios or give the workaround for archiving it.
Dear ALL,Please help to fix Error CS0234 The type or namespace name 'Fluent' does not exist in the namespace 'PX.Data.BQL' (are you missing an assembly reference?) in Visual Studio.Best Regards,NNT
Screen modifying: Print Production Orders (AM511000) - in version 22R2Overall Goal: Pass Report ID from custom selector to be used in the print report process instead of reportID off line item.Issue: custom field returns null instead of selected value I have created a custom selector that lists Report IDs from the AM module on the Print Production Orders form, and I have modified the BuildReportRequiredException method so that I can pass the selected Report ID through to be printed for any processed records. However my custom field in the ProductionOrderPrintProcessFilterExt DAC extension is returning a null value every time instead of the selected value.Note: I’ve even tried creating a simple text field within the DAC extension and that also returns null when trying to process the record instead of the value entered. Graph Extension: namespace PX.Objects.AM{ [PXProtectedAccess] public class ProductionOrderPrintProcess_Extension : PXGraphExtension<PX.Objects.AM.ProductionOrde
Is there any way to within a GI using the IIF command to do the following?I wrote a GI to pull all of the SO’s of a certain customer along with the associated invoices created from the SOShipments. No problem. See attached screen shot below for an example.What I would like to do is set the “Sales Order Total” to be 0.00 if there are more than one associated invoice numbers.The pseudo code logic statement would be something like this:IIF (‘Order Nbr’.row-1 = ‘Order Nbr’.row), ‘Sales Order Total’=0, ‘Sales Order Total’)Using this type of logic then the second line in the example screen shot below would be “0.00”, while the first row would be “14,283.93”. (Ideally that value would be set to NULL, so that no value at all appears there...but that may be even greater wishful thinking.)Is something like that even possible to do in an Acumatica GI? In some ways, yes, I trying to create a ‘group by’ function inside of the GI.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.