Introducing Acumatica Cloud ERP: 2026R2
Technical discussions focused on Customizations for developers. See Low Code | No Code Forum for non-technical discussions
Recently active
In the code I’m trying to Extend InventoryItem DAC to include the AlternateID from INItemXRef I created a customization project, and added the required code, the new field showing in the InventoryItem fields,Code: public class InventoryItemExt : PXCacheExtension<InventoryItem> { #region CustomAlternateID [PXString(50, IsUnicode = true)] [PXUIField(DisplayName = "GTIN/EAN/UPC/ISBN")] [PXSelector( typeof(Search<INItemXRef.alternateID, Where<INItemXRef.inventoryID, Equal<Current<InventoryItem.inventoryID>>, And<INItemXRef.alternateType, Equal<INAlternateType.gIN>>>>), typeof(INItemXRef.alternateID), SubstituteKey = typeof(INItemXRef.alternateID))] public virtual string CustomAlternateID { get; set; } public abstract class customAlternateID : PX.Data.BQL.BqlString.Field<customAlternateID> { } #endregi
I have custom fields setup on DAC extensions for our sales orders and invoices. I am trying to update our SOShipmentEntry graph to copy the custom field from the Sales Order to the Invoice that is being created. I haven’t added many custom fields to Invoices so I used the customization UI to create the new field. That new field ended up being added to an extension on ARRegister. In the customization I’m working on we already have an InvoiceShipment Delegate setup that is responsible for copying an Address Line 4 for both Billing and Shipping addresses. This delegate does exactly what it should and has been working for a long time. I’ve found a number of other posts here covering a similar concept from the SOOrderEntry side of things but so far haven’t found something that works when invoices are created from SOShipmentEntry. Given that we’re already successfully copying Address Line 4 to the addresses on invoices, I didn’t think I’d have a big problem making this work.My proble
Hello, and Happy New Year to everyone!I hope this message finds you well. I’m reaching out for assistance with a configuration issue in the Mobile application.I’ve made the Payments and Applications (AR302000) screen visible in the Mobile app, and it appears correctly. However, after filling out the information in the header section, I’m unable to add details in the “Documents to Apply” tab. Note.- The Invoices and memos screen (AR301000) also became visible in Mobile App.I’ve already enabled the “Insert” option in the “Documents to Apply” container, but it doesn’t seem to work. Essentially, the customer needs to be able to add invoices to be paid within the mobile app.Could someone guide me on what additional configuration is needed to insert the corresponding details and enable customer payments through the mobile application?Thank you very much for your help!Regards!
Hi everyone!, I’m in trouble, because I tried to make a selector field but it doesn’t work, I checked the field in WSDL schema. The field is Product in WSDL schema<s:element minOccurs="0" maxOccurs="1" name="Product" type="tns:Field"/>and the selector definition in the DAC is Product add field "Product"{ selectorDisplayFormat = KeyDescription pickerType = Searchable weight = 2 selector { add field "ProductID" add field "Description" } placeAfter field "Acepted" }But I can't show that the field is searchable as the following field, but Owner field isn’t a grid control and my field is it. Any help would be appreciated.!Thanks
why i am seeing this error on these parameters in generic inquiry also no display of text
Hello, I’d like to change the sort order of scanned items the Pick Pack Ship screen on 2022R1. I have asked a similar question previously in the 'mobile development' group and was able to update the sort order on 2021R1, however, the coding of the Pick Pack Ship screen on 2022R1 has changed substantially and the method I used previously no longer works.I’d like to reorder the ‘picked’ view, let’s say by Description.I believe the picked view is in the PXObjects\SO\WMS\Modes\PickMode.cs file in the code CodeRepository.The picked view and delegate are shown below, and it’s a relatively simple definition.public class Logic : ScanExtension {#region Viewspublic SelectFrom<SOShipLineSplit>.InnerJoin<SOShipLine>.On<SOShipLineSplit.FK.ShipmentLine>. OrderBy< SOShipLineSplit.shipmentNbr.Asc, SOShipLineSplit.isUnassigned.Desc, SOShipLineSplit.lineNbr.Asc>. View Picked; protected virtual IEnumerable picked() { var delegateResult = new PXDelegateResu
In the Inventory Summary screen(IN401000), only warehouses/locations with available quantity or on-hand quantity for an item are displayed in the grid section. Warehouses with zero quantity are not listed.We have added some custom fields to the grid for calculating sales amounts, and we need to display these calculations for all warehouses, regardless of whether they have any quantity available.However, we are unable to determine the logic that restricts warehouses with zero quantity from appearing in the results. There are some aggregate methods applied to the "Site" and "Location" fields. We’ve attempted to modify the logic but have not achieved the desired outcome.Could anyone provide suggestions or guidance on what might be needed to display all warehouses for an item in the Inventory Summary screen? Thank you in advance for your help!
We are looking to integrate several platforms together via dataverse. Has anyone had success with building a customization that allows acumatica to write/receive data from dataverse? For context we want to use Dataverse to update Projects between our PM software and Acumatica, query tracking tables and change logs, send transactional/operational emails via schemas, and use various BI tools.
Hi Team, I need to remove “other” folder in the Acumatica mobile app, but I am unable to find a solution or any option for this. Could you please assist us on how to remove it? Regards,Sagar
I am trying to create a form/screen that will allow for the updating of INLocation records. A very basic form. It starts at the first record, and allows the user to move PREV or NEXT. They can change a couple of fields, or delete the record. I have it sort of working. The form runs correctly, drawing in the first record as expected.But when I hit NEXT or PREV, it is not updating the information on the screen (even tho it is correctly moving to the next or prev record in the data. I confirmed that using breakpoints and examining the data.)This is my current ASPX:<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormView.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="IN900100.aspx.cs" Inherits="Page_IN900100" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormView.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="AS
I have installed training instance - SmartFix_T290 and following “Modern UI Development: Building of the Source Code” course.On step 3. Use Windows PowerShell or a similar program to run the following command in the FrontendSources folder.npm run getmodulesreceive error message Starting 'i_controls outlook-plugin'...[11:37:54] 'i_controls outlook-plugin' errored after 5.49 ms[11:37:54] Error: spawn EINVAL at ChildProcess.spawn (node:internal/child_process:421:11) at spawn (node:child_process:753:9)Use local instance with http: request.Outlook-pugin can only be used on https. Any idea how to fix this problem?
I have a customization that when it was published one layout column was repeated. This did not happen locally, or in a sandbox instance. See the screenshot of the project below. This duplication is causing the screen to present the SO Screen incorrectly.Can I just delete the column in the project and republish?What could have caused this duplication?TIA
Is there a way to programmatically confirm an action in a dialogue pop-up from a custom screen in such a way that it actually uses the answer? I have a scenario where a user clicks a 'cancel' action on a custom form, and a linked production order should be canceled. However, canceling the production order causes a dialogue box to pop-up with the message,"Are you sure you want to cancel the production order?”I can click ‘Yes’, but somehow due to the way the system runs the code again after receiving the dialogue answer, the answer is not retained when the action is called programmatically from a different screen. The box just pops up again after clicking ‘yes’, and I get stuck in an infinite loop.Does that make sense? I don’t really care whether or not the dialogue box opens, but one way or another, I want the production order to be canceled. Regards,
Build 23.212.0024We have a custom processing screen which makes use of a delegate to perform a union of various records into a single processing list; as described here https://asiablog.acumatica.com/2015/11/union-selects-in-bql.html . This processing screen is used to poll remote API for status updates.I mention the delegate method of performing a union as we originally thought that might be the reason for our issues, however we now don’t believe that’s the case.This processing screen works fine when used manually; any success, warning or errors are correctly reported to the UI.We can using a schedule to automate this processing screen on local development machines and the number of processed rows is correctly reported in the history (greater than 0). Since the automation works locally I presume the configuration of our processing screen is correct. We have read a number of discussions on this matter but none seem to show similar behaviours. We are using the “Process All” action. We a
Hi Team,I have increased the invoice number length from 15 to 30. It accepts a Reference Number greater than 15 characters, but when I attempt to save, it returns an error: “AR Error: Document with this Invoice Nbr. already exists.” Please find the attached screenshot for your reference.Your assistance in resolving this issue would be highly appreciated.Thank you in advance.Best regards,Sagar Gadge
Hi Experts,I am upgrading a customization to Acumatica 2024 R1. The same customization code worked perfectly in the previous version, but after the upgrade, I am encountering the following error when trying to save:A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2024-12-26T12:39:04; IncidentID: 01ee5a5c-d4d4-43e4-86dd-7a4225f40541; Name: Aggregate Validation: PX.Objects.PO.POLine+baseReceivedQty. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.Here is the relevant customization code on POReceiptEntry graph:namespace PX.Objects.PO{ // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public class POReceiptEntry_Extension : PXGraphExtension<POReceiptEntry> { #region Event Handlers protected void POReceiptLine_RowUpdated(PXCache cache, PXRowUpdatedEve
On sales order screen suppose so item is kit item then I wants to show kit details (child item) in popup In Non stock item we created one item with Is Kit field = true. I added tool bar button<px:PXToolBarButton Text="View Kit Details" CommandName="ViewKitDetails" PopupPanel="spKitDetails" />It is visible on customization screen editor.But not on screen.Panel Details:<px:PXSmartPanel ID="spKitDetails" runat="server" Width="600px" Height="400px" Caption="Kit Details"> <px:PXFormView ID="formKitDetails" runat="server" DataSourceID="ds"> <Template> <px:PXGrid ID="gridKitComponents" runat="server" DataSourceID="ds"> <Levels> <px:PXGridLevel DataMember="KitComponents"> <Columns> <px:PXGridColumn DataField="InventoryID" /> <px:PXGridColumn DataField="Descr" /> <px:PXGridColumn DataField="Qty" /> <px:PXGridColumn DataField="QtyOnHand" /> </Columns> <
I have created a “Process Blanket Lines” Button on the Process Order pageI want to click the “Process Blanket Lines” button to display the Show Processing Dialog like so: to monitor code behavior in function GenerateNewLineItems. However when I click Process Blank Lines it still doesn't show the Processing Dialog.Here is my code: using System;using System.Collections;using System.Collections.Generic;using PX.Data;using PX.Objects.CN.Subcontracts.AP.CacheExtensions;using PX.Objects.SO;public class SOCreateShipment_Extension : PXGraphExtension<PX.Objects.SO.SOCreateShipment>{ public PXAction<SOOrderFilter> processCustomization; [PXProcessButton(CommitChanges = true)] [PXUIField(DisplayName = "Process Blanket Lines", Visible = true)] protected virtual IEnumerable ProcessCustomization(PXAdapter adapter) { SOOrderFilter filter = Base.Filter.Current as SOOrderFilter; if (filter != null && filter.Action == "SO301000$addBlanketLine") {
HiConsidering there is no out of the box row level restriction group for cases, how do you manage that?Let say the HR open a case for a layoff of a person. We don’t want to have this case accessible of every one.Thanks!
Hi Community Followers, Can we create side panel for the Inventory planning display screen? I tried but there is not option for side panel and customer is in 24R1 version.
Is it possible to change a custom user-defined field to utilize an auto-numbering sequence?For example, I have the following user-defined fields:Receipt Selector:Acknowledgement Receipt Collection ReceiptThen I have another user-defined field:Ref. Number: An auto-number generated based on the selected receipt.
Something has changed with my site maps or with access rights. On some customization projects in the details I only see “SCREENS” in the left navigation. When I add a new project then save a Screen all navigation items besides “SCREENS” disappear. Any ideas as to why?Here is before save: And, immediately after saving:
Remove WMSHEADER Table in 2024 R1 - What is the replacement of this table?
I added some custom columns to SOOrder in a customization project (under Database scripts) and they’ve been created in my database correctly in the SOOrder table. I’m also able to view/modify these columns in the PXCachExtension with my C# code. However, when I run a SQL query in SOOrder on these new columns, they always return as NULL.Question: How do I save updates to these new fields in the database?I’ve tried the following without luck: Base.Document.Update(Base.Document.Current); Base.Document.Cache.Update(Base.Document.Current);
Hi I want to modify the Parent Lot/ Serial Nbr to only show selector records where the value is greater than 0 in remaining quantity.I’ve tried to modify the selector using this approach below and it does not filter as expected.[PXSelector( typeof(Search<INLotSerialStatus.lotSerialNbr, Where<INLotSerialStatus.qtyOnHand, Greater<decimal0>>>),Any help would be appreciated, thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.