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’m using PXReportRequiredException to open up a report from a button on a screen. I would like to open the report to the where the user can enter the parameters instead of the preview. I don’t want to pass the parameters to the report because it doesn’t make sense in this context.Is there a way to do that?
Hi i’m trying to add address details in report , in english version the details are as expected but when i try to print it in french verson the format is changing.This is in english This is in french here is the code i used for it. =IIf([RemitContact.FullName]<>null,[RemitContact.FullName], iif([Vendor.AcctName]<>null,[Vendor.AcctName] , '')) +'{br}'+IIf([VendorAddress.AddressLine1]<>null,[VendorAddress.AddressLine1] + '{br}','')+IIf([VendorAddress.AddressLine2]<>null,[VendorAddress.AddressLine2] +'{br}','')+IIf([VendorAddress.AddressLine3]<>null,[VendorAddress.AddressLine3]+'{br}','')+IIf([VendorAddress.City]<>null, [VendorAddress.City]+' ', '')+IIf([VendorAddress.State]<>null, [VendorAddress.State]+' ','')+IIf([VendorAddress.PostalCode]<>null, [VendorAddress.PostalCode],'')+IIf([VendorAddress.City]<>null OR [VendorAddress.State]<>null OR [VendorAddress.PostalCode]<>null,'{br}','') +IIf([VendorAddress.CountryID]<
Is there any possibility to add Nuget packages to Acumatica Customization project?
Hi!I need to track the receipt number of an item that was selected for a sale. This means, track the receipt number related to an item that was submitted in a sales order/invoice.In this post, the logic for table The logic behind Table INReceiptStatus and INCostStatus | Community (acumatica.com) was explained. So, Im thinking that this could help me to track it but Im guessing that there is another table intermediary between the purchase and the sales.Does someone know which table could be? Thanks.
Hello Community,I’m trying to update the Unit Price field when I update the Quantity but it is not working but the same code is working in the Sales Orders screen. Not sure why it is not working in the Sales Quotes screen. Below is the simple code I’m using but still not working, can anyone review and help on this? public class QuoteMaintExt : PXGraphExtension<QuoteMaint> { public static bool IsActive() => true; protected virtual void CROpportunityProducts_Quantity_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseMethod) { InvokeBaseMethod?.Invoke(cache, e); CROpportunityProducts row = e.Row as CROpportunityProducts; if (row != null) { cache.SetValueExt<CROpportunityProducts.curyUnitPrice>(row, 10m); } } }
Hello Guys, i have a view that requires an inventoryid to be passedi need to pass the id in the rowselected then show the new records returned from the view in the screenso, i need to show the currentInventorySalesHistory variable in the screenanyhelp?
Hi, I need to add a smart panel when clicked on my Add Purchase button. The smart panel should include all the Purchase Orders inside a grid which are currently available in the database. So I created a graph extension of my parent Graph APProformaEntry and also a DAC extension of px.objects.po.POOrder standard DAC called POOrderExtension to define new fields if I need to add. But for now I didn’t add any new fields to the DAC Extension except the main key .below screenshots show the code for the reference.Graph ExtensionDAC ExtensionIn the customization project editor, inside the dialogs, I added a pop-up panel and passed POrdersView which is previously defined view in the graph extension , as the Key. Now the issue is when I preview my changes before publish, it shows me the following error.I have no idea about this error, even I have not defined any new fields or changed the data type of the main key OrderNbr, in my DAC extension, this error is happening continuously. Have I done s
hello,i was upgrading my website from version 6 to version 20 R1i faced an error when preparing invoice from the job orderwhen i try to skip it this error appears in the insert method
Hello, I am currently trying to add a smart panel that just shows other orders a customer has placed. I used this vlog as a guide: https://www.acumatica.com/blog/vlog-changing-an-acumatica-po-number-with-a-smart-panel-and-custom-action/It got me most of the way there. Currently I have the dialog box popping up and I am able to close it. In the code I can see that I am pulling all orders that a customer has made. However, the grid in the dialog box only shows one item in it and I am not exactly sure why that would be. I thought it might be related to this other forum post: But since I am seeing something in my grid, I think I am making a different mistake. namespace PX.Objects.SO { // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class SOOrderEntry_Extension : PXGraphExtension<SOOrderEntry> { public PXFilter<MSCustomerOrderDac> MSCustomerViewForm; //This is used as the key for the dialog box
I have found recently that a couple of newly created customisation projects seem to have disappeared from the Publish Customisation screen. I was wanting to make a change to one of them but I couldn't find the project anywhere.On the login screen, I can see which customisations are published, including the two projects that have disappeared, which I have highlighted. The changes in those projects are still working, which is great, but if something was to go wrong or I needed to change the functionality, then I wouldn't be able to find it.Here is the login screen with the publish projects highlighted. And here is the publish customisation screen which is sorted by all published customisations. As you can see, the two highlighted projects are missing. Do you know if there is a reason why they would be hidden, and if there is a way to make them appear in this screen again?Thanks for any assistance on this.
Hello Community,I was wondering if is there a way to retrieve only the values of a single table based on the conditions from other tables. Something equivalent to SQLSELECT TableA.* /*ONLY I want TableA*/FROM TableA INNER JOIN TableB ON TableA_BID = TableB_BID /*Join TableA & TableB - One-to-one Relation in my case*/WHERE TableB_CID IN (SELECT TableC_CID FROM TableC WHERE TableC_CD = 'MyCondition') /*Filter Result Based on TableC*/ I know I can join tables and apply conditions in the WHERE statement, (for Example if I Join APInvoice with APTran) but the problem is when I join tables I will have the redundant APInvoice per APTran line and I want to avoid it also I do not want the APTran fields. I also know I can perform GroupBy but it is a headache and in my opinion, a dumb way to approach it. I only want to return a single table and its records that meet the criteria from other tables without redundancy caused by joining with other tables.
Hello, I have added two views to the PMTaskEntry, all works except when I try and delete the PMTask via the UI. I get the following exception.Collection was modified; enumeration operation may not execute. at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource) at System.Collections.Generic.List`1.Enumerator.MoveNextRare() at PX.Web.UI.PXCallbackManager.GetCallbackResultInternal(PXCallbackResultMethod resultMethod)I think it has to do with the views trying to refresh while the row is being deleted, but I am not sure.I appreciate the help, thanks in advance. public class PMTaskEntry_Ext : PXGraphExtension<PX.Objects.PM.ProjectTaskEntry> { public static bool IsActive() => (true); #region Cost Budget //[PXFilterable(new Type[] { })] [PXDependToCache(typeof(PMTask))] public PXSelect<PMCostBudget, Where<PMCostBudget.projectID, Equal<Current<PMTask.projectID>>, And<
I need to override the accountattribute so that it accepts inactive accounts, how do I do this, currently the restrictors I want to remove….. [PXDBInt] [PXInt] [PXRestrictorAttribute(typeof(Where<Account.active, Equal<True>>), "Account is inactive.", new[] { })] [PXRestrictorAttribute(typeof(Where<Where<Current<GLSetup.ytdNetIncAccountID>, IsNull, Or<Account.accountID, NotEqual<Current<GLSetup.ytdNetIncAccountID>>>>>), "YTD Net Income Account cannot be used in this context.", new[] { })] [PXUIField(DisplayName = "Account", Visibility = PXUIVisibility.Visible, FieldClass = "ACCOUNT")] public class AccountAttribute : AcctSubAttribute, IPXFieldVerifyingSubscriber, IPXRowPersistingSubscriber { public const string DimensionName = "ACCOUNT"; public AccountAttribute();
I have added UDF’s to the Employee Time Card screen. The screen is fine on the web site.I’ve added these fields to the Mobile App. One of the selectors works without adding anything extra to the xml. The other 3 look exactly the same as far as the DAC is setup. I cannot understand why one works and the other 3 do not. I’ve gone through other posts for possible solutions. None of them are working. If the UDF’s contain data, they display fine on the mobile app. You just cannot lookup a value in those selectors.Here is a screenshot of the screen for a new entry. Note that the WG Task field allows me to lookup a value. The other 3 with a red X do not do anything.Also, the Workgroup field is a standard Acumatica field (not UDF) that I added to the app. It is a lookup field on the web site, but not on the mobile app. Just to show that the UDF’s are mapping correctly, here is a Detail that shows values when there is data in the fields (entered via the web site):Here is the DAC fiel
I am looking to build a customization to export shipment header and line detail information to an XML file. I can do this easily within SQL using the XML writing shortcut, but I’m curious whether I can do something similar within Acumatica to generate the same file. There are a few things I shortcut below, such as contact info is not in the header of the shipment, but this is close to the format I am looking to export.SELECT ship.ShipmentNbr AS [@ShipmentNbr], ship.Customer As [@CustomerID], ship.CustomerName As [@CustomerName], ship.ShipmentDate As [@ShipDate], ship.CompanyName As [@ShipToName], ship.Phone1 As [@Phone1], ship.Fax As [@Fax], ship.Email As [@Email], ship.Location As [@Location], ship.LocationName As [@LocationName], ship.WarehouseID As [@WarehouseID], ship.WarehouseName As [@WarehouseName], ship.TotalShipmentQty As [@TotalShipmentQty], ship.ShippedWeight As [@ShippedWeight], ship.ShipVia As [@ShipVia], ship.AddressLine1 As [@AddressLine1], ship.AddressLine2 As [@Addres
I would like to check if Credit Memos or Prepayments exists when loading an Invoice. How programmatically incorrect is it to query the database on RowSelected? (I know you’re not supposed to make changes in RowSelected).
Hey ! Since fews days, system doesn’t allow me to add any new field on the CT Contract DAC.During validation, compilation is running an error : ‘Column name invalid’.I tried to use a shorter name ,try to unpublished all and to republished but same result. I can add any field on other DAC (Baccoutn, etc) except this one. Have you ever face the same error ? Thank for any help ! :) Cecile
We have used the strings collection feature to localize our side panels titles. Unfortunately, if some of them appear correctly translated, some others don't, depending of the environment where this version is deployed. Maybe we didn't used the right way to do that.Does anyone knows how to proceed ?Thanks.
Hi, all. I’m currently working on custom processing form which uses a filter. However whenever I select entries and change the filter, the entries I selected remain selected. Is there an event handler needed to clear the selected fields or should it automatically clear all selected fields when the filter is updated? Here are some screenshots and initialization of the view. public SelectFrom<ARPayment>. Where<ARPayment.docType.IsEqual<ARDocType.payment> .And<ARPayment.status.IsEqual<ARDocStatus.balanced>.Or<ARPayment.status.IsEqual<ARDocStatus.closed>>.Or<ARPayment.status.IsEqual<ARDocStatus.open>>> .And<ARPayment.status.IsLessEqual<GiroCheckToProcessFilter.action.FromCurrent>> .And<ARPayment.voided.IsNotEqual<True>> .And<ARPayment.paymentMethodID.IsEqual<PaymentMethodConstant.check>.Or<ARPayment.paymentMethodID.Is
Hello everyone,Have a nice day.Now, I can’t open server Report designer of Acumatica system on Localhost; Can anyone guide me or have something they used similar for this kind of scenario.Thank you
Hi, Does anyone know how to detect a grid click so that a value can be populated. The scenario I have is how to efficiently enter data into a tally sheet:This is what I would like to accomplish:User enters number of rows in the form header (for the above example 16) 16 rows automatically appear in the grid beneath the header with the layer prepopulated 1 to 16 The user keys the 8 in the first cell, row 1 They then are able to just mouse click all the cells in the grid that should be 8 next, the user keys the 9 in the second cell row 2 and goes through the same click to populate process.I know how to do all of the above except detect the mouse click and then populate the last value keyed (step d). Any ideas.Some of the tally sheets have lots of 3 and 4 digit numbers with high levels of commonality so the whole user keying experience is rather horrendous. Also, what about Optical Character Recognition (OCR) for a tally sheet that looks like the above? Anyone done anything along those
I don’t have an actual issue/error here. I am just seeking advice on an alternative way to accomplish my goal.In my Merge Tools application, you can merge customers and vendors (at this time...I hope to add other merge options later). However, I want to prevent a user from merging vendors and customers simultaneously as this will surely cause errors as common tables are being modified by both processes in transactions and I don’t want changes from one process overwriting changes from the other process.Each merge process has it’s own screen. I currently have it so that you cannot process a merge unless the users are locked out.The merge buttons are disabled unless the system is locked out. Here they are enabled as I have the Lockout turned on.To prevent a user from performing merges on more than one option, I may need to create a screen to do something similar to the Apply Updates screen. I am thinking of creating a form that the user can select the current merge process being perfo
Hello,I was upgrading my website from version 6 to version 20R1 after upgrading i got this error in the customization project. what is this constructor takes?
Hello expers,I don’t know if it is possible to create a Multiple Selector?In case it is impossible. Is there any workaround to achieve this goal?I found an article https://asiablog.acumatica.com/2018/01/multi-select-selector.html but it doesn’t work.Thank you for your sharing. Regards,Khoi
Hello Community,Does anyone have any experience with mass downloading attachments from Acumatica? I have done a little bit of digging and seems “UploadFileInq” is the graph that manages the files/attachments and the “GetFile” action handles single file downloading. The issue I am facing is I do not see the real implementation code for the graph just declaring the views, filters, actions, and handlers. For example, I see the “GetFile” action but I do not see its method code. Or I see “FilesFilter_RowUpdated” handler but I do not see any code in it but for sure there should be because when we change the filter parameters the result grid changes. Or I can not see any Files select statement tied to the current value of the filters.I was wondering if this is one of those graphs Acumatica doesn’t like to be accessible for customizations! Any thought or direction to the right path is greatly appreciated.Ideally, I would like to open “File Download” dialog once to get the download path and dow
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.