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 added a URL field to the Sales Order Details tab and it works correctlyIs there a way i can hide the URL itself as some of them will be very long and instead just display an image or the word URL in the column so the column width can be kept small. If the user clicks on this then it will take them to the embedded URL
Hi, I get the following error when created a Sales Order and not sure how to resolve this. “An error occurred during processing of the field InventoryID: Invalid mask specified in segment 1 for Combine Sales Sub. From..”Can you, please, help
Hey guys, So whenever I try to add an inventory ID to a sales order - I get the following error: Error: An error occurred during processing of the field InventoryID: CS Error: Invalid mask specified in segment 1 for Combine Sales Sub. From.. But I can use the inventory in AR no problem - can someone help with this
Good day,I need to build PXSelector BQL to get all vendors for current sales order. Something likePXSelector(typeof(Search2<Vendor.bAccountID, InnerJoin<PO.POVendorInventory, On<PO.POVendorInventory.vendorID, Equal<Vendor.bAccountID> , And<PO.POVendorInventory.inventoryID, In<SOLine.inventoryID>>>>>)
I have created a screen showing records on grid, I have also created a redirection to invoices and memos screen which is working perfectly from web. however from my acuamtica application it is not working.see below Acumatica ASPX <%@ Page Language="C#" MasterPageFile="~/MasterPages/FormDetail.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="SO302110.aspx.cs" Inherits="Page_SO302110" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormDetail.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server"> <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%" TypeName="GDLOrderCustomization.DeliveryMasterMaint" PrimaryView="deliveryMaster" > <CallbackCommands> </CallbackCommands> </px:PXDataSource></asp:Content><asp:Content ID="cont2" ContentPlaceHolderID="phF" Runat="Server"> <px:PXFormView ID="form" runat="server" DataSourceID="ds" DataMemb
I have a requirement to calculate taxes based on Ext. Cost instead of the Amount of bill’s lines. If I go to Taxes tab and change the taxable amount of the tax transaction the tax amount, bill tax total and bill balance are updated accordingly.I’m trying to implement this behaviour programmatically. I can change the taxable amount (setting APTaxTran.CuryTaxableAmt value) but the other figures are not updated. I tried to fire RaiseFieldUpdated for different fields but no luck.Any pointer very welcome or any alternative solution to achieve this.Thank you
Hello Everyone,I need to add “REQUEST DETAILS” button on acumatica mobile app as shown below but it is not defined on the WSDL.Have tried my ways but not going through, How can I achieve this? Please assist. Thank you all in advanceAny kind of response will be highly appreciated.
Hi,I want to use PXOrderedSelect for multiple view but the view which I have created are of single table.So, is there any way that I can use PXOrderedSelect for multiple view for a single table .Here primary is different but table is same for all view.Also, can you tell me if PXOrderedSelect can be use instead of PXSelectJoin and if not than what I can use in place of PXSelectJoin so that I can perform drag and drop functionality of PXOrderedSelect .I am using PXOrderedSelect for drag and drop and using it in place of PXSelect. Thanks,Dhruv
I am able to add a project task to an existing project using an API. How can I add multiple tasks using the same API? Is this possible? What is the syntax?
Hi Team,I know this is pretty abnormal question to ask. But I have to raise this and need a solution. In my screen I have a grid. Based on the current selected vendor history data is coming to the grid. Data is loading correctly but when I mouse click or hover on the grid, grid data disappeared. Once I refresh the screen data filling based on the vendor. After mouse click or hover on the grid. (Cleared the grid data). public SelectFrom<HMRCVendorRegisterDetailHistory>. Where<HMRCVendorRegisterDetailHistory.bAccountID. IsEqual<HMRCVendorRegisterDetail.bAccountID.FromCurrent>>.View.ReadOnly SavedVendorRegisterDetail;HMRCVendorRegisterDetailHistory = History table.Also In my graph no refresh event included. Can someone help me out to solve this?ThankBhagya
Hello everyone,I had some fields that I needed to rename to comply with Acumatica’s Prefix Validation Standard.I Unpublished the customization The fields are renamed in SQL Database and now have the new names. Custom Scheme fields are updated accordingly in the customization project The DAC is updated accordingly in my C# project and any dependent events as well. ASPX DataFields are updated accordingly in the customization project The Project is compiled and the project is updated with the modified dll and published without any error.When I look into the CstPublished folder and open the customized screen, I see the new names are in the file, and NONE of the names which are raising errors exist. But when I try to open the Project screen and I get the invalid column error. For testing when I add any of the columns to the SQL DB, the error gets resolved. Long story short I do not have these fields that the system is picking on them neither in my C# project nor pages aspx but somehow the s
Hello Everyone, When the Business account is selected on the opportunity screen, the 'SHIP-TO Address' panel address fields on the shipping tab will be updated with business account address.We will, however, create an Opportunity without a business account and add the address by clicking the override address checkbox. The business account will then be assigned to the opportunity later.Even if the override address checkbox is ticked, Acumatica will override the currently available address with the selected business account address.We wanted to restrict this functionality such that the address from the business account is not updated if the override address checkbox is ticked.The "OpportunityAddressID" field of the CROpportunity DAC handles this logic with the "CROpportunityAddressAttribute" class, which is inherited from the "CRAddressAttribute" and "AddressAttribute" classes.We tried to change/override the methods in these classes, however we were unable to access already entered data
I have a new project which is always great! The customer wants to run a bunch of validations on a Sales Order when it is being saved. None of the validations will prevent the saving of an invoice. The result of the validations will simply set some values in some User Defined Fields on the Sales Order.Since I am not doing validations that will produce any exceptions, I am not sure where in the process I would run these validations (i.e., in a method, override an action or process etc.).I can dig into the Acumatica code but before I start that process, I would love a recommendation as to the best approach to do this. FYI, I cannot debug the Acumatica code as I cannot seem to get my breakpoints to hit. I added the bin folder to the symbols to load in the debug options, but it still doesn’t work. That’s another topic, but since I cannot get debugging to work on Acumatica pdb’s, it is hard to determine where I should inject my code. I haven’t been able to get debugging of Acumatica c
I set up a business event to a customer screen, but I do not see how to add it to inventory (IN.20.25.00).Is there any setting to make stock-item screen available for business event?
Enabled Disabled User Defined Fields on Shipment screen when Status is closed.Whether it is possible or not?I am checked with workflows but its not working.
Hello! I am trying to add a selector attribute to the detail line section of the Purchase Order screen but am having some trouble. I figured out how to add the new field, however I am unsure of how to link the attribute to it. This is as far as I have gotten. Can someone please tell me what I need to do next? Also, when I try to save the Control as “Selector” it reverts back to “TextEdit” so not sure I am taking the correct steps.
Hi all, I have customized report and I wanted to attach it using notification template which is triggered by a Business event and Generic inquiry. But the issue is I am getting error saying “Object reference not set to an instance of an object”. Business Event HistoryBut when I’m running report in usual way it is generating without any issue. Also I can generate that report programmatically from code side as well. I tried passing fixed parameters and passing parameters through the GI as well in notification template. however, it is not working and it always gives above error message. what can be the issue here?
when setting up a customer currently there is one “Notes” section can a second or even a third notes section be added. In our old system we had multiple notes one for contract information one for delivery information and one for common purchased items. we had no limit to the number of notes we could add. You just chose the one you needed by the title.I only see one “notes” in Acumatica can a second be added so we don’t have to scroll the only Notes to find the one that will answer a question about the customer needs.
I added an unbound custom field to the Orders grid on the Process Shipments screen.I want to set a value in the custom field by overriding the Orders view. I used the post from Sergey on how to do this (https://asiablog.acumatica.com/2016/06/using-pxview-in-dataview-delegate.html).In debug I am seeing that the result set has records. When the foreach fires, I get an exception. This is the block of code I am taken to when the error occurs. This may not really be an error, but I thought I’d show it in case it does matter. This error on the screen:In the graph, this is the actual line for the Orders view:public PXFilteredProcessing<SOShipment, SOShipmentFilter> Orders;I tried putting SOShipmentFilter in the foreach but that causes a cast error too. Sergey’s example shows the foreach containing all the DACS in the original View so I tried that too. foreach (PXResult<SOShipment, SOShipmentFilter> row in result) Since the result set only shows SOShipment records, it looks lik
Hello Everyone,We have a requirement like add a new custom field in the Incoming Documents screen i.e. Purchase Order Nbr and when we upload the file and click on the Recognize action we need to read the Purchase Order field value from uploaded document and show it in the custom field.Can anyone help me on this to achieve this requirement?
Hi, I am looking for a solution where I have a Boolean value on the user, the value will state if all the warehoused should be available for the user when selecting the warehouse for the current branch.if the bool is true then we I want to only show the current rows branch's warehouses and not all the warehouses in the system. but if the bool is false I don't want the where clause to be part of the PXRestrictor. I cant control a PXRestrictor with a bool and this is the problem i don't always want to apply the where clause to the look up field. Current Code #region SiteID [PXMergeAttributes(Method = MergeMethod.Append)] [PXRestrictor(typeof(Where<INSite.branchID, Equal<Current<SOLine.branchID>>>), "", typeof(INSite.siteID))] public int? SiteID { get; set; } #endregion I have a bool on the same DAC usrWarehouseLock and if this is true then apply the current PXRestrictor and is false ignore and just continue with the normal functionality. Any help will be amazi
I am trying to make the Description field on the Journal Transactions screen required, but only if the entry is being created on the Journal Transactions screen. I don’t want to stop sub ledgers from posting entries if no description is provided. For example, if someone creates a payables invoice without a description, I don’t want to cause the transaction to not post to the GL if the payables transaction does not have a description.I added the red asterisk to the field. Obviously, that doesn’t make the field required, but just shows that it is required.Here is the event I am firing to try to make this happen: public class JournalEntry_Extension : PXGraphExtension<JournalEntry> { protected void _RowUpdating(Events.RowUpdating<Batch> e) { var row = (Batch)e.Row; if (row == null) return; if (row.Module == “GL”) { if (row.Description == null) { //throw new PXSet
I am upgrading a customer to 2022 R2.There is a customization (not written by me) that I am bringing forward as part of that.This customization extends a graph called: EPEventEnqWhich seems to be in the using PX.Objects.EP namespace.It referenced a screen ID: EP404100 which looks like this:The issue is none of this seems to be available in 2022 R2. Does anyone know where this got moved to? Or did it just get removed?
I’ve added some custom fields to the Company editing screen inside Configuration that I need to access in a graph extension and a custom service class. The fields were created as a DAC extension on Organization. These fields are used to store company specific URLs to third party APIs.The thing I’d like help with is coming up with a way to get to the current organization without hard coding the OrganizationCD into my FBQL query. This is what is working for me currently: var organization = SelectFrom<Organization> .Where<Organization.organizationCD.IsEqual<@P.AsString>> .View .Select(Base, "MY_ORGANIZATION_CD") .RowCast<Organization>() .FirstOrDefault(); Is there a better way to do this without using MY_ORGANIZATION_CD as a string? Originally, I was hoping I could use the CompanyID from PXInstanceHelper.CurrentCompany but IntelliSense suggests it isn’t possible to query for records using the CompanyID column. Ideally, I’d like somethi
Hello,I am trying to implement a scalar custom field within the Kit Assembly page. The target functionality of this field is to select a boolean value from a custom table. I have implemented this field on various other pages but copying over that code to this page has not worked out for me.The following code is an example field I implemented on the Purchase Order page. This field is functioning as intended.[PXBool][PXUIField(DisplayName = "Is Cool", Enabled = false)][PXDBScalar(typeof(Search<MyTable.isCool, Where<MyTable.docNbr, Equal<POOrder.orderNbr>, And<MyTable.docType, Equal<MyConstants.PurchDocType>>>>))]public virtual bool? IsCool{ get; set; }public abstract class isCool: Data.BQL.BqlBool.Field<isCool> { }I used the Purchase Order example field as a template for the Kit Assembly page, making sure to update the WHERE filters, however the field does not seem to select data from my custom table and never contains a true value.[PXBool][PXUIField(D
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.