Discussion Forums

Hello Experts, I am facing one issue in business event i need to trigger mail from labor or move screen once create and edit inspection datasheet button is pressed.1.Have taken type as trigger by action, but unable to trigger mail from this event .2.Create and Edit Inspection datasheet button is QC user defined custom button. 

A parent BOM has been configured with input material which has a separate BOM both BOMs are active but when I create orders for subassembly, the orders are not generating. Currently using Acumatica build version 24.104.0008.

Hello All , Is there any way to highlight only certain words inside a grid cell as shown in the screenshot .I have tried putting direct html <strong style=\"background:yellow\">DANIEL</strong> like this.But it did not work . And all other ways it changes the whole cell background colour or font colour . Not for specific word .Any help would be appreciated .Thank you 

I have a GI and want to include the adjdLineNbr field from the APAdjust table, however the column won’t show on the GI. It does have the exclamation point over the field and says “This field will not be displayed for the current user because the user has insufficient access rights or the required feature is disabled.” But I am logged in with the admin account. I’ve taken a snapshot of their tenant and imported it into a local test environment and I am able to add and see the field in a GI even though that error message remains.Can anyone think of any reason why it wouldn’t work in the Acumatica hosted instance?

Hi, I need some assistance on editing my Stock Item GI to track the # of FG that are currently allocated.I was able to add these in the image below but I can’t seem to get a table to work.  

I have a custom user role that is not allowing the users to send emails for RFI’s or Submittals. I have added delete privileges to this role under Hidden->Email Activity but I still get the following error when attempting to send emails. You have insufficient rights to access the object (PJ661000). Is there a way to set object permission by using the object ID?

Hi community,I'm customizing a report in Acumatica Report Designer. I have grouped the data by SOOrder.CustomerID because each customer can have multiple orders. Inside the group, I'm calculating the total order value per customer using =Sum(SOOrder.OrderTotal) and then multiplying it by a tax rate to get a field called "Order Value."Now, I want to sort the report lines (i.e., each grouped customer section) in descending order based on the total order value per customer.I tried adding SOOrder.OrderTotal to the sorting section, but it only sorts the individual orders, not the grouped result. Is there a way to sort the groups (customers) by their summed order total?Any thoughts or suggestions would be appreciated.Thank you!

I have created an extension for  ARRegister DAC as bellow.  public class ARRegisterExt : PXCacheExtension<PX.Objects.AR.ARRegister> { #region Activation public static bool IsActive() { return true; } #endregion #region UsrLinksoftARInvoiceNumber [PXDBString(50)] [PXUIField(DisplayName = "Linksoft AR Invoice Number")] public virtual string UsrLinksoftARInvoiceNumber { get; set; } public abstract class usrLinksoftARInvoiceNumber : PX.Data.BQL.BqlString.Field<usrLinksoftARInvoiceNumber> { } #endregion }In the ARPaymentEntry extension I have add an event as below  protected void _(Events.FieldUpdated<ARAdjust, ARAdjustExt.usrLinksoftARInvoiceNumber> e) { ARAdjust row = e.Row; var ext = e.Cache.GetExtension<ARAdjustExt>(row); if (ext?.UsrLinksoftARInvoiceNumber == null) return; //ARRegister arRegister

Hi community,I'm customizing the ARPaymentEntry screen in Acumatica and encountering an issue where a custom field update event doesn't fetch the matching RefNbr from ARRegister even though the data exists in the database.I’ve added two custom fields using DAC extensions:public class ARRegisterExt : PXCacheExtension<PX.Objects.AR.ARRegister> {         #region UsrLinksoftARInvoiceNumber     [PXDBString(50)]     [PXUIField(DisplayName = "Linksoft AR Invoice Number")]     public virtual string UsrLinksoftARInvoiceNumber { get; set; }     public abstract class usrLinksoftARInvoiceNumber :         PX.Data.BQL.BqlString.Field<usrLinksoftARInvoiceNumber> { }     #endregion }This field stores an external invoice number (e.g., from a third-party system like Linksoft). It’s saved directly in the ARRegister(ARInvoice) table and visible on invoices.public class ARAdjustExt : PXCacheExtension<PX.Objects.AR.ARAdjust>{    #region Activation    public static bool IsActive()    {     

In AP Bills and Adjustments, the AP Viewer default Role does not have the ability to reassign the Approver if the Approval Map is designed to allow for it. AP Clerk can do this. I reviewed the Security but can’t determine what allows the field to be modified. Currently, the AP Viewer gets the pop up window for the approval but can’t select a New Approver. I gave AP Viewer Edit access to Bills and Adjustments>>Approvals. I also played with some of the Approver ID fields in different sections.Appreciate any help, Chris

I made a report for the Opportunity screen and named it CR303002. The report by itself runs well, I can select the opportunity and it will process it correctly. I want to add it as a custom action on the screen but the navigation parameters are not available: Has anyone faced something like this before? Thank you!

As described in the blog post below, I’m exposing a Generic Inquiry (GI) to be retrieved by an external system via the REST API. We are using OAuth2 authentication with grant_type=password and scope=api.As shown in the blog post, I’m sending a PUT request to Acumatica with a {} in the request body.https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/ Could you please clarify whether it is necessary to call a logout after performing the PUT request?     

Up until this morning, I was able to add user-defined fields to the opportunities screen without any issues but when I try to add a UDF to the screen, I get an error stating ‘Index was outside the bounds of the array’. I will post a screenshot of the stack trace.Any advice would be appreciated!

I am trying to setup Sales Order Notification Email templates to use information from the Mailing & Printing tab of the customer record as well as the Sales order.All the email information was scrubbed from the report, and the report directed to SalesOrderNotification template. This worked correctly.The Template has a message body, To fields set, From fields pulling from the Contact associated with the Sales order correctly.However, i was wanting to use the Customer record Mailing & Printing settings to populate the CC field. I cannot get the email template to pull information from here at all. I tried both Add recipients and Overwrite.Nothing ever populates in the CC field.I tried looking in the list of “Screen Fields” in the email template itself, but found nothing that makes this connection.What have I missed in this process?

Hi, I’ve created a smart panel containing a grid and an OK and Cancel button. You select a row on the grid, then hit OK and the selected item is added to a sales order. It looks like this:Whilst it all works fine, I would like to improve it a little by allowing the user to double click on a row and not have to press the OK button. This would be similar to using a PXSelector where you only need to double click on the row to select it, as shown belowI’m hoping it’s just a property against the grid but I cannot find one.Any ideas?

Hi, Have been battling with an issue with an override to ReleaseFromHold in POOrder Entry.  What I am needing to do is make an API call on another Acumatica Instance to create a Sales order that is linked to the Purchase OrderCode is below: The method ReleaseIntercompany is not the problem.  I have the same issue even if the call is commented out such that the code becomes:  I have narrowed this down to the presence of the Base.Save.Press().  This is required because if ReleaseFromHold is pressed before the order is saved, then the OrderNbr of the PO is not known and I want to send this in the API to create the Sales Order in the other tenant to store the value in a custom field.What happens, when the PO is released with the code above is that the user is left with a form that looks like:All the fields in the header are blank.  The order has saved, and has been released as you can exit and go back in and all the data is there.I’m thinking that I could just right a custom action that ca

Hey guys,I'm trying to attach files from the Invoices and Memos screen to emails when using the bulk send email feature from AR508000.I added custom code to attach files when sending emails from the CRSMEmailActivity screen, and it works correctly in that context. However, when sending emails in bulk — or when sending without opening the CRSMEmailActivity screen — the files are not being attached.Could you please assist?Thanks in advance!  

The total cost on the on the purchase receipt is not taking in to consideration the line discount of an item. For example 10 items  @ 10 less 20% line discount will come to 80.The total cost on the PR shows 100 instead of 80. The total cost is helpful tocompare the receipt with the vendor invoice totals.  

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Idea Management UpdatesGreat News - we've made it easier for you to track your ideas. We've simplified how we categorize them - so now there are fewer, clearer options. That means you'll be able to see exactly where your suggestions stand. Django Dunn - Acumatica Community Featured Member for June 2025Meet Django Dunn our Acumatica Community Featured Member for June 2025. It’s great to have you as part of the Acumatica Community ​@Django! Acumatica User GroupsNew! Michigan Acumatica User Group, Northern New England Acumatica User Group, NorCal Acumatica User Group Request to join today!All Acumatica User Groups How to Answer Questions on Acumatica Community - We need ev

Hello Everyone,In the recent Modern UI update, we added custom grids to the Stock Item Attributes tab. While the grids have been successfully added, they are currently displaying in the All tabs of the Stock Item screen instead of the intended tab. We have implemented the code changes in the HTML and TypeScript extension files. Please review the changes and suggest a solution.Please find the screenshots for reference:Screenshot 1:Screenshot 2:HTML: <template>        <field after="#fsColumnA-StockItem [name='Descr']" name="UsrEnableSiteID"></field>        <qp-template id="temp-Enable">            <div id="div-SiteContainer" class="grid-container">                <div data-bind="grid: LableSite">                    <qp-grid id="gridAnswers-LabelMangement" view.bind="LableSite" caption="Label Management" wg-container="LableSites_PXGridItemLabels"></qp-grid>                </div>            </div>                       <div id=

When attempting to release a group of project transactions I get a “IN Error: Unit conversion is missing” error. In this particular group of transaction there are about 30 transactions. I’ve looked at the UOM and Conversion rules where applicable and don’t see anything out of the ordinary. When I look at the trace I see what is shown below. Is there a way to track this error to a particular inventory item?    Error 2025-06-13 01:04:22 UTC    Category: Trace  Message: IN Error: Unit conversion is missing.  Stack Trace: PX.Objects.IN.PXUnitConversionException: IN Error: Unit conversion is missing. at PX.Objects.IN.INUnitAttribute.Convert(PXCache sender, Nullable`1 InventoryID, String FromUnit, Decimal value, Nullable`1 baseValue, INPrecision prec, Boolean ViceVersa) at PX.Objects.IN.INUnitAttribute.Convert(PXCache sender, Nullable`1 InventoryID, String FromUnit, Decimal value, INPrecision prec, Boolean ViceVersa) at PX.Objects.

Hi, I am doing a GI and I meet a issue from getting the data field of PO receipt and In-Transit quantity. Is there any other table can get the value of them? because it show object invalid when I use [InventorySummaryEnquiryResult] to get the value. 

I believe that the base product of 24R2 can do this already, I just need to figure out the menu path to get to this. Thank you. 

Customer needs to link their Open Bills with Sub Contact . How to upload "Open AR Documents " linked with "Sub Contract " in migration mode.? Any idea ?

 I am currently working through Lesson 3.1: Setting Up Intercompany Sales from the F300 Intercompany Transactions (2025 R1) course. According to the training materials, when configuring Accounts Payable Preferences, I should be able to select "Vendor Location" in the Use Intercompany Expense Account From field.However, in the system, this option does not appear. Instead, I only see "Vendor" and "Inventory Item" as available selections.Could you please clarify whether the documentation needs to be updated or if there are additional settings required to enable the "Vendor Location" option?Thank you for your guidance and support.