Solved

Hi, In the Modern UI, I added the grid and it is visible, but the Add and Delete options are not appearing. However, these options are available in the Classic UI. Please refer to the screenshot below for reference.Classic UIModern UI  HTML  <template>    <qp-grid modify="#gridImportLocations"></qp-grid>    <field name="UsrKNSPCPOrderImportWarehouse" after="#groupOrder FIELD[name='OrderType']"></field>    <field name="UsrKNSPCPEnableLocationWarehouse" after="#groupOrder"></field>    <qp-grid id="santhosh" view.bind="TaxZonedetails" caption="Tax Zone Mapping" class="framed-section col-12" after="#groupSubstitutionLists"></qp-grid></template>TS import {  PXFieldState,  PXFieldOptions,  PXView,  updateDecorator,  removeDecorator,  featureInstalled,  FeaturesSet,  placeBeforeView,  placeAfterView,  placeBeforeProperty,  placeAfterProperty,  graphInfo,  viewInfo,  gridConfig,  columnConfig,  treeConfig,  controlConfig,  linkCommand

I need to display Purchase Order approved and the last person who approved the PO.In a GI or SQL it is simple to return the data for this as an Aggregated value Max on the ApproveDate. The table relationships: EPApproval Table and link it to POOrder using RefNoteID = POOrder.NoteID.How can this be achieved on the Report designer? Where will the Filter be applied?Retha

Hello,Can you please help me add a custom button on the Payments tab of the Sales Order screen?In which extension should the new button be created?When I try to add it in the Sales Order extension, I get the following error message. 

I 'm working on a customization where I need to allow users to select a DAC (for example Vendor, Contact, Location, etc.) and then dynamically display the list of available fields for that DAC so the selected field can be saved for later processing (similar to a generic Inquiry screen). The DAC is resolved dynamically at runtime, and the requirement is to list all usable fields (including standard DAC fields and extension Usr* fields) without hardcoding them. I tried to find a way by investigating Generic Inquiry screen, but I was unable to find working solution #region FullDACName [PXDBString(255, IsFixed = true, InputMask = "")] [PXUIField(DisplayName = "Full DACName")] [PXStringList( new[] { "PX.Objects.AP.VendorR", "PX.Objects.CR.Location", "PX.Objects.CR.Contact", "PX.Objects.AP.BAccount" }, new[] { "Vendor", "Location", "Contact", "BAccount" } )] public virtual string FullDACName { get; se

Hello everyone,We are encountering an issue with the Shopify connector for Acumatica24R1 regarding the synchronization of Business Customers (B2B). Both Company and Customer entities are active and both in bi-direction. Here’s the scenario:A business customer categorized as an organization is set up in Acumatica, with several contacts and locations. When this business customer was synced to Shopify, a Company was created using the same name as the business customer in Acumatica. All contacts were synced in Shopify as Customers associated with the newly created Company. The locations were also synced successfully, which looks good. During the next sync (in the aforementioned bi-directional direction), several new records were synced under the Customer entity. Upon reviewing the synced customer records, we discovered that the connector had created new Acumatica Customers, categorized as Individuals—one for each contact of the existing Business Customer (Company). This resulted in the dup

Good day,Is there an easy way to change the CRM Activity Email body from HTML to plain text.  I have tried a number of formulas (Html2PlainText) that are not supported by Acumatica. I have all the required fields but they want to body of the email included on the GI.Thoughts?Thank you.​@evangrill 

We created a Purchase Order and tagged it to a Project. A prepayment was then created against the Purchase order and processed completely through check printing. however, the prepayment amount paid to the vendor is not reflecting in the Project Balances or in the Cost Budget.At the moment, the Full PO value is showing as the committed amount in the Cost Budget, which is expected. however, the Prepayment amount itself is not appearing anywhere in the Project balances.I think the Prepayment amount is reflecting to the Project “X”.Could you please confirm, whether any configuration is required, or am I missing any process step to make the prepayment amount reflect correctly in the Project balance or cost budget? 

I have a processing screen with PXFilteredProcessingJoin where the main DAC is Customer with LeftJoin<CustomTable> and LeftJoin<Location>.In the grid I display Location__CPriceClassID field from the joined Location DAC.Problem: When I click the Selected checkbox on a row, the value in Location__CPriceClassID column disappears. It comes back when I click the checkbox again.Here is my view[PXFilterable]public PXFilteredProcessingJoin<Customer, CustomFilter,     LeftJoin<Location, On<Location.locationID, Equal<Customer.defLocationID>>,    LeftJoin<CustomTable, On<CustomTable.customerID, Equal<Customer.bAccountID>>>>,    Where<CustomTable.example, Equal<Current<CustomFilter.example>>,    And<Where<Customer.lastModifiedDateTime, GreaterEqual<CustomTable.LastUpdatedDate>,     Or<CustomTable.LastUpdatedDate, IsNull>>>>> Customers;and delegatepublic virtual IEnumerable customers(){ List<PXResu

One of my clients receives a payroll file with no header records. They can import into Quickbooks by mapping the data field to the column in the excel file. Does Acumatica allow this type of mapping? For example, Column A = Date, Column B = Amount...In the Data Provider or Import Scenario can I specify Column A = Date?

Hi Acumatica, I created a Sales Order with an Order Type of TR, and my requirements is to hide some of my transfer documents to specific users. Is there a way to configure this requirements? Thank you!

Hi,We would like to extend the user inactivity timeout to 8 hours, and we have already updated the setting accordingly.However, users are still being logged out before the expected time. Could you please advise how we can resolve this issue?Thank you.

We have instances where we are issued a credit from a vendor (which is a debit adjustment in Acumatica). We may not use them for future purchases for a long time, so we request a check be issued to us for the outstanding credit. When we receive that check,  can I apply it to the debit adjustment?  

I am probably missing something simple here, but we are struggling with inventory items be auto marked for PO on appointments when when the tech has the item along and there is plenty of inventory available. Only some items do this. Is there a setting in the inventory Item that is affecting this? 

I checked demo sales company assignment map and approval request is the same. but when I active empty company, they are difference. I try with both. but it works only approval. Please guide me  

 ​@lauraj46 Looking for assistance with placement of the attached sub-report within the main report so that all the fields line up within the main report. Still trying to navigate all the data fields accurately, so always welcome to better ideas. I could whip this out easier in even an older version of SSRS.

Hi everyone, I have an issue with creating a popup panel in Modern UI.Below I have attached everything related to this popup. public PXSelect<BZSPFilter> BZSalespersonsDialog; #endregion #region Buttons #region BZViewSalespersons public PXAction<Table> BZViewSalespersons; [PXButton(CommitChanges = true, DisplayOnMainToolbar = false)] [PXUIField(DisplayName = "Salespersons", Enabled = true)] public void bZViewSalespersons() { if (Base.Views[CurrentViewName()].Cache.Current != null) { Base.Views[CurrentViewName()].RequestRefresh(); BZSalespersonsDialog.View.AskExt(true); } } #endregion #region UsrBZSalesperson1 public abstract class usrBZSalesperson1 : BqlInt.Field<usrBZSalesperson1> { } [SalesPerson] [PXUIField(DisplayName = BZFieldNames.SP1)] [PXFormula(typeof(Default<ARInvoice.customerID>)

I am trying to create a GI that lists invoices that need to be printed or emailed to the customer.  The list should be any invoice that doesn’t have the printed or emailed or don’t email button checked.  Basically if any of those are true then it should be pulling them on the inquiry. As you can see below, its still pulling invoices where those columns are checked. It should only be pulling invoices where none of the 3 columns for printed, emailed or don’t email are checked. Its completely ignoring all of the conditions in the last paratheses.  Where am I going wrong with the logic/format on this?  

Hi Everyone,I am trying to add a side panel that will list the details lines of the selected PO in the Commitment Tab of the Project screen, Could anyone have a clue on how to do that? 

Hi, I am working on customization request to add a GI on Service Order Screen where GI parameter is the inventory ID from Service Order Detail tab. I am having problem in mapping the Inventory ID to side panel customization project . The client wants to see the GI ( parameter is Inventory ID) as side pane when they select the row on the Detail tab of the Service Order. So the selection of the row will feed the Inventory Id info to the GI parameter to display the list of info available on the GI related to that Inventory ID.See attached for detail. It will be great help if you can share any info to make it possible via “Customization Project Editor” or via code? 

For a stock item part on the appointment screen, system does not allow using Estimate or Actual quantity that is higher than the quantity on the service order line.I remember seeing the same issue in previous versions but then it was resolved. I now see it again in 2025R2 - Build 25.201.0213.1.Anyone else coming across this and have any ideas how to get around this limitation? Field techs can certainly use more quantity on an appointment than planned on a service order.  

The owner is subject to the S Corp rules for the Greater than 2% shareholder rule. Therefore the company pays 100% of her premium expenses for health, dental, vision, etc.  We have tracked these amounts for the year, and now need to add these to wages as taxable income subject to FICA but not withholding. How do we do that? Is it done through an adjustment?

Hello,I’m trying to create Payment Amount in a Positive Pay CSV file padded on the left to include 11 total characters like this example: I’ve tried several formulas:=PadLeft(CStr([APPayment.OrigDocAmt]),10,'0')=PadLeft(CStr([APPayment.OrigDocAmt]),10.2,'0')=PadLeft(CStr(Round([APPayment.OrigDocAmt],2)),10,'0')=PadLeft(CStr([APPayment.OrigDocAmt]),12,'0')The above formulas produce results that are padded at the left but include 2 extra digits on the right.I thought Acumatica might be using Price/Cost Decimal Places field in Miscellaneous Settings section of Companies screen to set Decimal Places to 4…. however when I temporarily changed this setting from 4 to 2, it made no difference in my Positive Pay GI.  Thank you in advance for your help!Laura

Hello good afternoon communityI am importing customers and vendors through the import scenario, there are approximately 16,000 customers and about 4,000 vendors, many of them are customer/vendor at the same time.When I do this I get an error saying that I cannot have the same customer and vendor ID during the import. These customers/vendors have the same ID. since they are the same.Is there a configuration that allows it? Is there a way to import them by import scenario? because there are about 950 customers/vendors that exist with this condition. I hope you can help me since it is impossible to create them one by one manually.I am driving Acumatica version 2023R2I look forward to your help and thank you in advance.Vanessa.

I’ve come across an issue and want to confirm if I’m missing something in the configuration, or if I’ve found a bug in how Matrix Item creation handles segmented key separators for the new Inventory IDs.As far as I can see, this should be possible but I’m seeing strange behaviour when creating the Matrix Items. The end goal is a 2 segment Inventory ID, that correctly creates Matrix Items with valid Inventory IDs.(The reason I need 2 segments is because the first segment will be Auto-Numbered. I’ve been able to replicate the issue both with and without auto-numbering, so for simplicity I’ll detail below without auto-numbering applied) Expected BehaviourManually created, standalone Stock Items, Non-Stock Items and Template Items, should be created with the first segment populated, and the second segment left blank. Matrix Items should be generated from the Template Item, with the Template ID as the first segment, and the Attribute Value as the second segment. ExampleSegmented KeyInventor

<ClientEvents TabChanging="refreshGrid" /><px:PXJavaScript runat="server" ID="CstJavaScript23" Script="function refreshGrid(){ var custGridTotal = document.getElementById("ctl00_phG_tab_t6_CstFormView8"); if(custGridTotal != null && custGridTotal != undefined){ custGridTotal.object.refresh(); console.log("custGridTotal"); } }" IsStartupScript="True" />I want to convert my JavaScript code to Modern UI TypeScript code. How can I do it? I cannot find any documentation about it. I found @handleEvent in TypeScript, but it does not have TabChanging or many other events that exist in the JavaScript client-side.