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,I have created custom project and task selector fields on the request screen.Currently, the selector displays all tasks, but I want it to display only the tasks related to the selected project in the task lookup.Please assist me in resolving this issue.Below is the code. #region UsrProject [PXString(255)] [PXUIField(DisplayName = "Project", Visibility = PXUIVisibility.SelectorVisible)] [PXSelector(typeof(Search2<PMProject.contractCD, LeftJoin<Customer, On<Customer.bAccountID, Equal<PMProject.customerID>>, LeftJoin<ContractBillingSchedule, On<ContractBillingSchedule.contractID, Equal<PMProject.contractID>>>>, Where<PMProject.baseType, Equal<CTPRType.project>, And<PMProject.nonProject, Equal<False>, And<PMProject.status, Equal<ProjectStatus.active>>>>>), typeof(PMProject.contractCD), typeof(PMProject.description), typeof(PMProject.customerID), typeof(PMPro
I created a custom screen (Screen 1) with a custom DAC, which includes a grid.There is another custom data entry screen (Screen 2) used to input parameters. I want to display all the parameters entered in Screen 2 within the grid of Screen 1 and allow users to enter and save the corresponding values for those parameters.I tried this, but currently, I have to select each parameter individually to add it to the grid. Instead, I want all the parameters to automatically display in the grid of Screen 1 when the user navigates to that screen.How to do this?Any detailed instructions, tips, or code snippets would be greatly appreciated. Thank you!
Use CaseIt might be necessary to override the Convert To Order action in the Sales Quotes and Opportunities screens to modify a logic of copying or to copy a line custom field value from a Sales Quote or Opportunity lines to Sales Order lines. SolutionCreate Sales Order action is present in both Opportunities and Sales Quotes screen. And it has been separated logically to a different class CRCreateSalesOrder and is being extended and utilized from both OpportunityMaint and QuoteMaint. In this article, we will understand how CRCreateSalesOrder extension can be extended to create sales order. Overriding Copy Sales Quote code to Sales Order In this example, we are trying to extend CRCreateSalesOrderExt graph extension of the QuoteMaint graph in order to fill PO Source = Drop Ship in Sales Order lines where the corresponding Sales Quote line has Mark for PO checked (by default, PO Source is filled as Purchase to Order in a sales order line in this case)The below code adds RowUpdated event
I am trying to create a new processing screen which only shows sales orders with specific criteria.I have the following at the moment which works and allows me to process sales orders to assign the current user as owner. This is the start of a more complex process but I just need to get the basics working currently: using System;using PX.Data;using PX.Objects.SO;using PX.Data.BQL.Fluent;using PX.TM;namespace PPCustomOrderProcess{ public class AIProcessOrdersCust : PXGraph<AIProcessOrdersCust> { public class wOOrderType: PX.Data.Constant<string> { public wOOrderType() : base("WO") { } } public class paymentMethodAFFIRM: PX.Data.Constant<string> { public paymentMethodAFFIRM() : base("AFFIRM") { } } public class paymentMethodAFTERPAY: PX.Data.Constant<string> { public paymentMethodAFTERPAY() : base("AFTERPAY") { } } public class paymentMethodPAYPAL: PX.Data.Constant<string> { public paymentMethodPAYPAL() : base("PAYP
I’ve created a custom header/detail screen to help us with physical inventory review and reconciliation. Physical Inventory is always on a tight timeline, and we really need to somehow be able to have multiple users working on the same document simultaneously.Obviously they still shouldn’t be allowed to modify the same detail records at the same time, but I want to allow both to access and update different lines of the same detail document at the same time. Is there any way possible to do this? I appreciate any ideas.
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.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.