Discussion Forums

How to override Receipt Nbr in adjustment for stock without receipt 

Are dialog box workflow actions supposed to be unavailable to an import scenario? I was hoping to automate a field update the field/dialog box via import scenario, but the action is unavailable in the import scenario. Workflow actions usually show up in an import scenario, so I was surprised to see this limitation.  

Hello, I was wondering if Acumatica had an email response time tracking feature where we could pull data on how quickly customer service reps our emailing clients. The system it would tie into is outlook. Does anyone know if Acumatica has a feature like this?

General Information:Microsoft has announced the end of support for their Bing Maps tool on June 30, 2025. If you currently have a Bing Map Key, it will continue working until June 2025. Microsoft has discontinued issuing Bing Map Keys to new users as of July 1, 2024. Microsoft recommends Bing Map users register to use the Azure Map tool.Issue:Acumatica Field Services supports Bing Maps in our various map views tied to the calendar.  These include Appointment History on Map, Staff Appointments on Map, Routes on Map and Staff Routes on Map.Acumatica introduced support for Azure Maps in the 2023R2 update 17 release, which was made available for customers in October 2024. This support will cascade into 2024R1 update 14 and 2024R2 update 3 per our normal development roll-up p

Hi, how do I change this Inventory ID selector to Location ID instead? Thanks 

I’d like to get a feedback on my Open source project of performance comparison of three databases: MS SQL, MySQL and PostgreSQL for 26 R1 preview. I’d like to hear how deep is my analysis, what else can be added or removed? And of course if that is worthy of attention. 

When any user creates PO and status of PO change to open, I want to automate notification email to Finance Workgroup when PO status open. To all member in finance workgroup. Please help me.

Hi everyone, I have an issue when trying to add a fourth column to the form. I can't align the 3rd and 4th columns with the others.Here is my HTML <qp-template modify="#form-Receipt" id="form-Receipt" name="14-17-17" class="equal-height" qp-collapsible wg-container="document_form"></qp-template> <template remove="#fsColumnC-Receipt"> </template> <template modify="#form-Receipt"> <qp-template id="fsColumnC-Receipt" after="#fsColumnB-Receipt" slot="C" view.bind="Document" name="1-1" class="equal-height"> <qp-fieldset id="fsColumnC-Receipt-Original" view.bind="Document" class="highlights-section" slot="A"> <field name="OrderQty" pinned="true"></field> <field name="ControlQty" pinned="true"></field> <field name="UnbilledQty" pinned="true"></field>

Is that possible to integrate Azure maps in address provider of 2024 R1 Acumatica?

I am creating a purchase order approval workflow for a client. They previously used Purchase Requests with an approval workflow and are wanting to replace this with Purchase Order approvals.Their Request Approval Workflow conditions are based off Department and $ amount.  Currently it is not possible to setup Purchase Order workflows in the same way, as the Department Entity is not available.Can we add the department field to the Purchase Order header and add the department entity to the Purchase Order workflow?Additionally we would probably get the Purchase Order department field to default to the PO Owner (employee’s) department but they could select any department, as it

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

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 am working on the Calendar Board (FS300300) Classic UI screen in Acumatica 24R2.This screen seems to be different from other screens because it does not support customization through Graph or DAC extensions, and the behavior of the screen is controlled mainly by the following page files: FS300300.aspx FS300300.aspx.cs These files are part of the website source, and they are not compiled into the customization DLL. Because of this, when changes are made in these files, they work locally in the website, but they are not included in the customization package, and we cannot deploy them to another instance.Also, this screen does not appear to have a Graph that can be extended, so the usual approach using Graph/DAC extensions cannot be used here.I would like to know the correct and supported approach for this scenario.Questions:

Hi,I couldn’t find a complete guide on how to create a GI that used Audit History, so I wanted to share my success with creating one, in case it helps someone out there looking for something similar. Our business scenario is that we would like to create a report that lists all of the changes made to suppliers’ bank accounts as a control. To do this, we created a GI that listed all the changes made to the “Account Number” field within the “Payment” tab of the AP303000 form. Note: We already had the audit history functionality enabled for the field: To do this, a join was done on the AuditHistory table and AP.Vendor tables. Because the AuditHistory table on

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[] { "V

Customer is asking to export various Acumatica entities to Salesforce using the Acumatica Data Provider.  Working with Acumatica support, we were led to believe that it was possible and that you could define the Salesforce schema objects in the data provider based on the exposed Salesforce API.  I thought we would start their first request.  Map Customers to Salesforce Accounts.  The Salesforce data provider is connected and the fill schema fields works.  The customer is using the modern UI.I created a new Export Scenario for Customers to Accounts.  On most of my initial attempts to update a single account, I kept getting an error that multiple accounts found where account = ‘’.  When I added a mapping for the Acumatica customer number to export to the Account ID field, I received the error filter error: select id from account where accountID = ‘0000002’.  Then I put the Salesforce account ID in the External Reference field of the customer and now I get 

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.

I got a couple issues with the Shopify Connector, specifically the customer location sync.At random it will create more than one location for the customer in Acumatica.  It will activate one and deactivate the other.  Since upgrading to 2025R2 we have every day one or two orders where it will fail to import due to "property set method not found". What we found is that it means that the location is not active. When you go to it in Acumatica, you cannot activate it either. You need to create an additional location, make that the default, then you can go back to the other location and activate it.  In addition I found today that when I look at audit history for any customer, it will show me a bunch of location changes for different customers, different random locations. I don't know what these mean and why they're showing up on another customer that's not even connected to our Shopify store.  

I’m trying to ship a sales order via the REST API.  This involves…Creating the shipment record Updating the quantities on the shipment Confirming the shipment Updating INThe actual quantity to ship comes from our internal custom WMS site, outside of and integrated with Acumatica.  Typically, the SO line item will have a linked Production Order.  When recording multiple Move transaction on the Prod order, the resulting Shipment will have multiple lines for the same item.  We rarely ever ship exact.  Depending on how production was recorded whether we had some extra pieces in stock already, the actual quantity to ship will frequently be different than the quantity ordered or allocated or produced.Admittedly, I don’t fully understand how the “allocated” calculations fit into all of this, or how they are determined based on quantity ordered and production quantities.  No matter what I try via the API, I run into the error

We upgraded from 25R1 to 25R2 and the add-in for classic Outlook 365 stopped working.  I reviewed help and it seems there are some updated steps for registering the Acumatica instance in Entra.  Under the Expose an API section, we need to add an Application ID in the format of api://<fully-qualified-domain-name>/<app-id>.  We are on SaaS - what do we use as the fully-qualified-domain-name?  Entra does not accept mycompany.acumatica.com since its not verified.  I can’t verify it since I can’t add it to my DNS.  Any insight?

We are about a year into using ACM and are still refining our reporting specifically around product availability.We take at once and future orders(a year or more sometimes) and our planning department is trying to get a shortage report based on a inputted time fence. We allocate inventory to orders 60 days out. We are trying to write a report to see where were are short of inventory in a 90 day window and a 120 day window. Short is defined as a)total on hand inventory, less hard orders b)total on hand inventory less hard order and forecasts. I was going to create a GI based on item time fence to net out the appropriate elements from PX.Objects.AM.AMRPPlan. This seems cumbersome, how are other doing this?  

Greetings, Community Members. We want to inform you that we are actively developing updates for Acumatica’s Exchange Sync software in response to upcoming changes Microsoft has scheduled for Fall 2026. Our goal is to ensure continued compatibility and a seamless experience for our customers. This change is driven by a Microsoft deprecation of legacy components that Exchange Sync relies on. Microsoft now requires migration to newer versions of their software, and Acumatica version 26R1 is being specifically designed to align with these updated requirements.  We are also actively evaluating options to support this change in a prior release of Acumatica. We expect to share more detailed information within the next couple of weeks. Rest assured, we will continue to provide regular updates and support resources as the Microsoft deadline approaches. If you have any questions or need assi

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 

Hi Team,In Acumatica, on the Journal Transactions screen, there is a Customer/Vendor field that is currently disabled. I have enabled this field, and I want it to work the same way as the Vendor field in Bills and Adjustments.In that screen, if a vendor has a branch restriction, the vendor does not appear in the selector when working in a different branch. I want the Customer/Vendor field in Journal Transactions to follow the same behavior.I have tried several code approaches, but I am still not getting the expected result. Does anyone know how to correctly apply branch restriction to this field so that the selector only shows vendors/customers allowed for the current branch?Any guidance or solution would be appreciated.Thank you.  #region ReferenceID          [PXDBInt()]        [PXSelector(typeof(Search<BAccountR.bAcco