Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
Does anyone know if its possible to modify the fields that are searched for autocomplete? The request is to have the Project ID field in time entry to also search by Project Customer Name and also not include inactive projects in the autocomplete of the field. Is this possible?
We are about to upgrade from 2020 R2 Build 20.208.0031 to 2022 R1 Build 22.109.0023. We have noticed that our GIs that are actually on production are not in sync with those that are in our custom code package. This is the result of direct edits on the production site without then bringing those changes into the code package. Our question is whether this will be an issue. More specifically, as we proceed with the upgrade, will the GIs in the code package update/touch/revert the GIs that were previously in the db/site ? Or will it leave them alone and not revert them to the versions that are in the code package? For normal package publishing and unpublishing, this has not been an issue. But since we are doing the upgrade, we want to anticipate and address any issues that may arise.Many thanks in advance.
I have a SQL View that returns data when I run a select statement in SQL Query Analyzer. I get an error that the CustomerLocationID field does not exist when I try to access the DAC.If I remove that field, it works fine. But I need that field.This is the DAC #region SOShipment [Serializable] [PXCacheName("SOShipment SQL View")] public class ICSSOShipmentSQLView : IBqlTable { #region CustomerID [PXDBInt] public virtual int? CustomerID { get; set; } public abstract class customerID : PX.Data.BQL.BqlInt.Field<customerID> { } #endregion #region CustomerLocationID [PXDBInt] public virtual int? CustomerLocationID { get; set; } public abstract class customerLocationID : PX.Data.BQL.BqlInt.Field<customerLocationID> { } #endregion #region ShipmentNbr [PXDBString(15, IsUnicode = true, IsKey = true)] public virtual string ShipmentNbr { get; set; } public abstract class shipmentNbr : PX.Data.BQL.BqlString.Field<shipmentNbr> { } #endregion }This is th
Hello everyone, I have a few custom forms (new screens) and a set of fields on Acumatica’s standard screens. I have two questions:how can I set a screen visibility in the site map based on an enabled/disabled feature from FeaturesSet? I have a set of fields which are repeating on multiple screens. I know I can set their visibility using RowSelected event on each individual screen but I was wondering is there any easier way of setting a group of fields visibility from FeaturesSet or Setup screens rather than doing on each screen?
Hello,Has anyone had any success in getting a selector to work on a custom field added to the mobile application? I have added the field successfully, however, it is giving me a weird dropdown arrow instead of directing me to a selector screen like I would expect (similar to “Employee” field above it).My code:update screen PJ304000 { update container "LaborTimeAndActivities" { fieldsToShow = 7 add field "EquipmentID"{ placeAfter field "Employee" } } }Mobile view:Application View:
Hey all,I have a situation with a document discount that when an Invoice is Copy ‘n Pasted it creates a copy of the discount. I read this article, which is helpful, but I feel I’m missing something because nothing I’ve tried has worked.I’ve set a PXCopyPasteHiddenView in a PXGraphExtension<ARInvoiceEntry> class:[PXCopyPasteHiddenView] public PXSelectJoin<ARInvoiceDiscountDetail, InnerJoin<ARInvoice, On<ARInvoice.docType, Equal<ARInvoiceDiscountDetail.docType>, And<ARInvoice.refNbr, Equal<ARInvoiceDiscountDetail.refNbr>>>» Discounts; I’m wondering if my PXSelect/PXSelectJoin is incorrect and if so what should it be?Thanks all!
Is it possible to revert the long run operation status back to the checkbox instead of the popup that shows up in the upper right? We are on 2022 R1.
I have customized this report but not able to remove this space I have highlighted can anyone please help me here with this ?
I would like to display two fields from the Customer (CST.AR.30.30.00) screen, namely “Customer ID” and “Location ID” in the grid of transactions on the AP.30.40.00 screen. I know I can add fields, but I am not sure how to relate the two screens in the customization project to expose them? I need to be able to select a Customer and Location on the AP Bills and transactions, if possible. I’ve taken some screenshots below for reference.Thanks!
I am making updates to various tables in AR. After making the changes, I want to recalculate customer balances using the ARIntegrityCheck graph. I created the graph instance. My goal is to “check” the box on the customer number I want to recalculate. After I initialize the graph, all of the caches are empty. When you open the screen, the grid is populated with all the customer id’s. I thought that by creating the graph instance, the caches would be populated through the events on the graph.I’ve tried everything I can think of to get the graph “loaded”.As per below, I am trying to get a current record for the customer number I am updating. I set the checkbox to true for Selected and update the current.At the end, I click the Process button using a technique I found on Stackoverflow. I get a PXAction exception because I don’t think there is an “action” on the graph I can call.var arIntegrityCheck = PXGraph.CreateInstance<ARIntegrityCheck>(); //arIntegrityCheck.Load(); //arI
Hello,While working with fBQL or BQL I have often wanted to see what exactly the equivalent SQL statement be. Is there an inbuilt function something like like .ToSQLString() that we can use on a fBQL statement or View that can show us the equivalent SQL. So for example, if I have the following ViewSelectFrom<CSAnswers>.InnerJoin<InventoryItem> .On<InventoryItem.noteID.IsEqual<CSAnswers.refNoteID>>.Where<CSAnswers.attributeID.IsEqual<Use<slots>.AsString> .And<InventoryItem.inventoryID.IsEqual<@P.AsInt>>>.View.Select(cache.Graph, invtID) How can I see the exact SQL that’s generated (including the parameter values in the Where clause)?One option is I can run SQL profiler, but is there anything inbuilt Acumatica SDK/Framework that can help me view the SQL statement while debugging in VS?
Hello All, I’m relatively new to developing Acumatica screens. I am working on a custom processing screen that will update on hold invoices post date to a date the user chooses. This updates invoices uploaded through the system via an API where a custom field was added to have these imports batched together. These batch numbers are stored in a custom table that I load on the processing form to enter the post date and then load invoices and update said post date based off a join with the batch number. I’ve got my DAC created, graph started, and screen created. However, I’ve hit a brick wall as to why the fields are don’t allow me to edit on the custom screen. Screen is just a grid with a process and process all button. See below for my settings, let me know if I can provide additional details outside of below, imagine whatever I’m missing I simply just don’t know to include. The field i’d like to be editable is “PostDate”. Here is a bit of the DAC, from the beginning to PostDate: [Se
I am trying to create a customization to iterate through inventory items to update Prices in a BigCommerce store from a custom field I created called usrAIWHLPrice on an InventoryItem extension. I have created a new screen with a datasource which is based on a query that checks for that field not being null:public SelectFrom<InventoryItem> .Where<InventoryItemExt.usrAIWHLPrice.IsNotNull> .View InvItems;I am still getting to grips with how to do things in Acumatica so decided to just create a simple action as a first step that will create a list of inventoryitems I can iterate through and pull out the information I need. I created a button with an action: public PXAction<InventoryItem> prepareWHLData; [PXButton] [PXUIField(DisplayName = "Prepare WHL Data", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] protected void PrepareWHLData() { PXTrace.WriteInformation("Preparing data..."); var
Hi,We have developed New Customized Scan Screens for ISV in 21R1..Is there any Changes need to do in 22R1 to get Paperless Picking??I found one link that ASPX TypeName need to change.Is there any other additional methods or Classes to change to get Paperless Picking.Can anyone Suggest me on this Please.Thanks.
I want to create a list view like this where I can have add edit icon like this one and have a link like this for editing. But don’t know how to achieve this can anyone please help.
I facing the issue with the unitcost field where datatype is decimal(25,6) and in the DAC, i have used [PXDBDecimal(typeof(Search<CommonSetup.decPlPrcCst>))]. In Company Screen i have set Price/Cost = 4 still its defaulting 6 decimal place. please guide if missed any thing to default from the company set up.
I created an extension to SOCreateShipment, to override the Data View for ‘Orders’. I made this change: public class SOCreateShipment_Extension : PXGraphExtension<SOCreateShipment> { #region Data Views [PXFilterable] public PXFilteredProcessing<SOOrder, SOOrderFilter, Where<True, Equal<True>>, OrderBy<Asc<SOOrder.requestDate>>> Orders; #endregion #region isActive public static bool IsActive() { return true; } #endregion }I wanted only to override the OrderBy for the view, but I was forced to also add a ‘Where’ clause to the PXFilteredProcessing class. Now when I run the program, the OrderBy clause works properly, but the filter for the selected rows is now selecting all rows. The View has a delegate method ‘orders’ that has a more filtered where clause. But, when I debug SOCreateShipment, the ‘orders’ delegate method is never reached. If I remove this extension, the ‘orders’ delegate metho
It looks like there has been a major refactoring of how line splitting works in Acumatica, which is great news because this moves us away from the old kvstore approach, which was not performant at scale.However, there seem to be zero practical examples of how to implement this functionality. For example, let’s say I want to add a field to POReceiptLineSplit, and then pull that field back in a SOSalesOrderLineSplittingExtension. How might I do that?@Dmitrii Naumov Do you think we could get some practical examples of how to work with the new line splitting code? It looks like there have been other requests also for this, which so far have gone unanswered...
Hello,I’m trying to resolve the following issue: custom column added to the grid contains no data.Here are the details.I am trying to customize the Run Service Contract Billing (FS501300) form to add Organization ID column into its Contracts grid.To do that I extended the ContractPeriodToPost DAC for the grid based on the following article: https://blog.zaletskyy.com/post/2020/03/09/post100 .My extension is as following.using PX.Data;using PX.Data.BQL;using PX.Objects.GL;namespace PX.Objects.FS{ public class ContractPeriodToPostExt : PXCacheExtension<ContractPeriodToPost> { public static bool IsActive() => true; #region UsrCompanyID [PXInt] [PXUIField(DisplayName = "Organization ID")] [PXDBScalar(typeof(Search<Branch.organizationID, Where<Branch.branchID, Equal<ContractPeriodToPost.branchID>>>))] public virtual int? UsrCompanyID { get; set; } public abstract class usrCompanyID : BqlInt.Field<usrCompany
I'm building an integration that needs to extract data from an Acumatica record and build a json string. My process for doing this is using an export scenario to define what data gets pulled from the record. Is there any way that I can leverage the logic in SYMappingUtils/SYImportProcessor to pull data? Ideally I want to pass the record and the mapping to a method, and it returns the mapped data/formula evaluations from that record. Below is how I've been able to get a portion of the data, but it doesn't work for most PXSelector fields. It pulls the integer key value and doesn't return the CD value like the export scenario does. Base.Views[objectName].Cache.GetValue(Base.Views[objectName].Cache.Current, fieldName);
In SO Process Orders, I am trying to change the sort sequence for SO’s displayed. The default is by Order number, but I want it sorted by RequestDate instead, when the list is initially displayed. I created a SOCreateShipment extension, and extended the BuildCommandCreateShipment() method: public class SOCreateShipment_Extension : PXGraphExtension<SOCreateShipment> { #region Event Handlers public delegate PXSelectBase<SOOrder> BuildCommandCreateShipmentDelegate(SOOrderFilter filter); [PXOverride] public PXSelectBase<SOOrder> BuildCommandCreateShipment(SOOrderFilter filter, BuildCommandCreateShipmentDelegate baseMethod) { PXTrace.WriteInformation("BuildCommandCreateShipment() started from extension"); // Add Order By Request Date to default view PXSelectBase<SOOrder> extFilter = baseMethod(filter); extFilter.OrderByNew<OrderBy<Asc<SOOrder.requestDate>>>(); string errmsg = "extFilter value is: " + extFilt
I have created an extension of SOCreateShipment, where I redefined the ‘Orders’ Data View. I now want to debug the flow for loading rows into the grid of orders. I am able to define breakpoints in the Extension, and Visual Studio breaks at the requested statements. While debugging, I also opened the base source code for SOCreateShipment, at:C:\Acumatica\MyWebApplication\App_Data\CodeRepository\PX.Objects\SO\SOCreateShipment.csand added needed breakpoints. When I open the website, attach to process, then run the application, it breaks at the statements defined in the Extension, but not the statements in the base code. I reviewed the steps in the Customization Guide, and Acumatica website, but I don’t see clear steps on how to debug the base code. Can you point me to the proper steps?
I’m puzzled over this - hopefully it’s something silly that I’m missing.I have an Action button on SOOrderEntry. The goal is to look through the detail lines on the order, create a record in another graph, update some fields on SOLine and save the order.Each time I call Actions.PressSave from within the CreateJobs method I get the error “The record cannot be saved.” I thought I was doing something wrong so I stripped out all of the code. I’ve tried it on two different Acumatica installations.public static bool IsActive(){ return true;}public PXAction<SOOrder> TestAction;[PXButton(CommitChanges = true)][PXUIField(DisplayName = "Create Test", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Enabled = true)]protected virtual IEnumerable testAction(PXAdapter adapter){ Base.Actions.PressSave(); var graphCopy = Base; PXLongOperation.StartOperation(graphCopy, delegate () { CreateJobs(graphCopy); }); return adapter.Get();}private static void CreateJobs(
Here is the scenario I am trying to accomplish:When an AP invoice is released using the APRelease - ReleaseInvoice process, I want to check each line of the APTran table for the given invoice. If the line item has an AllocationIDUsed code in the UsrAllocationIDUsed field, I want to delete that line and create new ones based on the setup of the custom allocation ID setup.The APTran table is not part of the signature of the ReleaseInvoice process so I don’t have access to it via a cache.My approach is to pass the “doc” into a function and do the allocation there.In order to make updates to the APTran table, I need a graph (I think).In my AllocateLine function, do I create a generic graph for each call to the function? I am pretty sure I can accomplish my goal doing it that way, but I think I might have a performance issue if the invoice has 100 APTran lines and every one of them is allocated. Yes...my customer releases HUNDREDS of AP Invoices every day and each invoice might have 50 t
Hi,I want to execute a custom logic when the user click the Release button, but only if the Release process completes successfully. How I can get the error message from the release process? This is my code. [PXOverride] public IEnumerable Release(PXAdapter adapter, ReleaseDelegate baseMethod) { baseMethod(adapter); _inservice.UpdateItemLocation(Base, itemloc.Cache, AddOrSubstract.Add, Base.transactions.Cache); Base.Save.PressButton(); return adapter.Get(); } Thanks,EV
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.