Discussion Forums

Hi AllI’ve noticed that since upgrading to 25R1, everytime I look at an audit history there are a mismatch in the times. The summary section at the top will show the correct time for my timezone and the detail section will show the UTC time (I am in a UTC -4 timezone). Has anyone else experinced this and is there a way to have this corrected, please?See screenshot below for reference.ThanksAmitSummary section show correct time to match timezone (UTC-4), detail section shows UTC Time 

I have a sporadic issue in WMS Receive and Put AwayOccasionally when a PO is number is scanned the screen shows a receipt has been create but the lines from the PO do not populate on the screen as expected.We are unable to determine the situation / status where this occurs vs does not occur Have you seen this issue ?  

Hello, I have added a barcode to Worksheet Picklists to show the barcode for the lot/serial number. However, this is viable even if there is no lot/serial number for the line item (although this barcode is not usable). I saw on another post to set the value under the Visible Expr in report designer, but I am failing to write the correct expression. Does anyone have any idea how to accomplish this?  

Hi, I found the error"Column 'INLocationStatusByCostCenter.InventoryID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."when creating an inquiry INLocationStatus when adding the formula=IIf( [INLocationStatus.LocationID] = [INItemSite.DfltShipLocationID], Max( [INLocationStatus.QtyAvail]) - IIf( [INItemPlan.PlanQty] = Null, 0, [INItemPlan.PlanQty]), 0)The following is the result grid that I madewith the following additional conditions 

Hi Team, When I publish the package in 2025R2 i am getting following file path issue. System.Exception: An error occurred while copying files to the temp directory ---> System.IO.PathTooLongException: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. at System.IO.PathHelper.GetFullPathName() at System.IO.Path.LegacyNormalizePath(String path, Boolean fullCheck, Int32 maxPathLength, Boolean expandShortPaths) at System.IO.Path.GetFullPathInternal(String path) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) at Customization.CstSyncWebsiteFolder.SyncDir(String src, String dest) at Customization.CstSyncWebsiteFolder.SyncDir(String src, String dest) at Customization.CstSyncWebsiteFolder.SyncDir(String src, String dest) at Customization.CstSyncWebsiteFolder.SyncDir(String src, String dest) at Customizatio

Hi Community,We are working with a customer where the AuditHistory table has grown significantly (currently around 387 GB), and we are evaluating cleanup and retention options.Background: The client wants to reduce database size and improve manageability. Similar cleanup work was performed several years ago for this same customer. Client Requirements: Separate Financial audit logs from CRM audit logs. Remove all CRM audit logs. Retain only the last 7 years of Financial audit logs. Information received from Acumatica Support: Financial and CRM audit logs are stored together in the same AuditHistory table. There are no built-in retention settings for specific audit log types.     Questions: Has anyone implemented a workaround or customization to separate Financial vs CRM audit logs? Any best practices for managing large AuditHistory tables in similar scenarios? Any insights or recommendations would be greatly appreciated.Thanks in advance!

Hope this is okay to post here. I co-host a podcast called The ABCs of ERP & Beyond with Nirav Shah (an Acumatica VAR at AdCirrus ERP). We've been publishing episodes every two weeks since early 2023, and Acumatica features heavily throughout.We cover things like:Real go-live experiences and implementation war stories Acumatica Summit recaps and new release breakdowns Practical how-tos and demos within Acumatica Broader ERP topics that apply regardless of platform — from project team structure to go-live riskWe try to keep it honest and practitioner-focused rather than vendor-y. No fluff, no sales pitch — just two people who work in and around ERP talking through real scenarios.If any of that sounds useful, you can find us here:Apple Podcasts: https://podcasts.apple.com/gb/podcast/the-abcs-of-erp-beyond/id1663062815 Spotify: https://open.spotify.com/show/3Zc1CkSRfSGwJSDS7vLcD3 YouTube: https://www.youtube.com/@theabcsoferpbeyondHappy to answer any questions — and always open to top

David EichnerGrew up in the Pacific NW and went to UW in Seattle on a Navy ROTC scholarship where I majored in Business Administration.  After graduation, I attended Navy Nuclear Engineering training as a young naval officer and then served on a ballistic missile submarine stationed in Charleston SC for 4 years. After leaving the Navy, I returned to the Seattle area and finished an accounting degree at night while working in payroll and HR at several organizations. Obtained my CPA license while working at a CPA firm in Tacoma WA and then founded ICAN Software Solutions as a VAR for Microsoft Dynamics GP in 1999.  Taught myself to code in the early 2000’s and wrote a number of add-in products for Dynamics GP that my firm still sells today.  Shifted our focus to Acumatica in 2012 and migrated many GP clients to Acumatica over the last 14 years.  Today, I lead a team focused on Acumatica customization for products we sell in the channel (AddressVerify, VendorApprovals, InvestmentAssets, e

My name is Mike Gifford, and I am the Director of Product Innovation at Crestwood Associates, where I lead our ISV products team and customer-facing development teams. I’ve been with Crestwood for nearly 11 years and have worked with Acumatica for about 13 years.I’ve spent roughly 30 years in the ERP space, starting my career working with Solomon, followed by time with Microsoft Dynamics GP and NAV, before ultimately settling into Acumatica for the long haul. I’ve thoroughly enjoyed Acumatica’s evolution—both from a technical innovation standpoint and the continued expansion of depth and capability within the product.My wife, Wendi, and I live in DeLand, Florida—about an hour north of Orlando—with our two dogs and cat. We love spending time on the water, whether that’s cruising rivers, relaxing at a sandbar, or heading offshore in search of fish. We’re also adjusting to the empty‑nest phase of life as our kids have graduated and are gradually making their way off the payroll.Being in F

My name is Kandy Beatty, and I am an experienced Acumatica Consultant with more than twelve years of ERP, finance, and distribution expertise. My professional foundation was built during nearly nine years of Active Duty in the United States Navy, where I served as a Logistics Specialist. The skills I developed in supply chain management, operational efficiency, and problem‑solving continue to guide my work today.Throughout my consulting career, I’ve implemented Acumatica across a wide range of industries—from beauty supply and recycling companies to farms and service-based businesses. I enjoy helping organizations streamline processes, solve challenges, and get the most out of their ERP investment.I am also an active contributor to the Acumatica Community, engaging daily to answer questions, share insights, and learn from others. Watching the community grow has been incredibly rewarding, and I’m proud to be a four‑time Acumatica MVP, recognized for my dedication to helping both users a

Is it possible to only allow certain roles to post with a specific Task? We want certain users to only be able to post using Task ‘80’ in our system for example.

the date contained in the rate table.  When taking this date in consideration; is this looking at the transaction date (date from timecard) or the system date like here 3/3/2026.   I created rate table with effective date 2/2/2026 and in our test system when I posted timecards with dates prior to 2/2---1/1,½,1/3 etc. it still applied the new rate.  There wasn’t a preexisting rate either.    

Hello, I am requesting assistance on an AP issue that is currently preventing us from closing the month.For background, we recently transitioned from our old accounting software to Acumatica. During the migration phase, I processed several checks outside of the old accounting system. I tracked paid invoices manually in Excel and issued checks accordingly. Once we fully transitioned into Acumatica, I began entering backlog payables, clearing checks, and processing current activity. During this process, I inadvertently issued a check to a vendor for an invoice that had already been paid during the migration period. In January, we received a refund check from the vendor indicating that the December payment was a duplicate. The original invoice was paid in November, and the duplicate payment was processed in December. The November invoice and check have already been properly cleared. My question is: what is the correct way to clear the duplicate check in Acumatica without inflating the ven

Hi, i need help to set up company with 3 subsidiaries in 3 different countries. Therefore we will need 4 different base currencies, but 1 consolidated base currency for the group (USD). The 3 subsidiaries must also be able to report in their local base currency on day to day operations, including local taxes. 

I want to raise the question here. Can we run npm build in local development in folder FrontendSources and add build file to production? Like this How can we include the build file to my customization ui file. Because when I browse from file or moder ui file I cannot see it. But in file I can see development file in screen folders. Please guide me. 

In the Classic screen, I use an action to highlight (change the row color of) records in the grid based on the value of the UsrFRCanShip field. When I click the action, the row colors update as expected (see the screenshot below).   After migrating the screen using the conversion tools:  The screen loads correctly in Modern UI, but the action no longer applies the row coloring in the grid.  Could you please advise how to implement this grid row coloring behavior in Modern UI? 

in which module (construction, finance, AP, System Mgmt) can find the permission to grant user the ability to change the system date ---the 3/3/2026 below 

We have a few blends of product that need to sit in the tank overnight to finish processing.  Our shift is M-TH 6:00am - 4:30pm.  The tank (machine) shows the same schedule, but we have machine time on the BOM as 16 hours.  The APS module is scheduling it over 2 - 3 days depending on the start time.  Our employees do not need to be present for the processing to take place once ingredients are placed in the tank.  If I change the machine shift to 24/7, it still will not calculate appropriately.  If I change the work center to have the 24/7 shift, it schedules around the clock.  I have tried to use queue time and finish time as well, but they are not yielding appropriate results either.  Essentially, I need 1-2 hours of shift time and the remaining is processing time overnight, then the tank can be emptied the following morning, cleaned and reused.  Is it possible to replicate this scenario on a BOM & in the APS module?

Hi everyone,I am implementing custom row highlighting in Acumatica 25R2 Modern UI for the Process Orders (SO501000) screen. I am using CustomEventType.GetRowCss to apply different background colors based on a custom field UsrFRCanShip (Red for No, Green for Yes, Yellow for Partial).The issue: While the colors apply correctly to most rows, the currently selected or focused row (the one with the > indicator) loses the custom color and shows the default light-blue selection style of the Modern UI.I have tried using !important in my CSS, but the platform's internal selection styles seem to have higher specificity or are applied to a layer that overrides the td background-color during the "Active" or "Selected" state.TypeScript (SO501000.ts):@handleEvent(CustomEventType.GetRowCss, { view: "Orders" })getOrdersRowCss(args: any) {    const row = args?.selector?.row;    this._injectStyles();    if (!row) return '';    const val = row.UsrFRCanShip?.value;    if (val === 'N' || val === 'No') r

I can see the “+” symbol but it’s disabled which doesn’t make sense since I added the Mode (AllowAddNew).  I can add rows in SQL and they show up fine but I can’t edit the values or add new rows in the new customized screen.Question: do I need to create an Action bar to create rows or edit existing rows?I defined my HTML like this…<%@ Page Language="C#" MasterPageFile="~/MasterPages/ListView.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="IN400628.aspx.cs" Inherits="Page_IN400628" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/ListView.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server">    <px:PXDataSource SkinID="Primary" ID="ds" runat="server" Visible="True" Width="100%"        TypeName="updateInventory.INItemClassRulesSetupMaint" PrimaryView="Records"         >        <CallbackCommands>            <px:PXDSCallbackCommand Name="Save" CommitChanges="True" ></px:PXDSCallbackCommand> 

Hi everyone, I need to find or create a report that shows me the AP Vendors banking information, Bank Account and Routing Numbers. I’m struggling to add those “fields” to an existing GI we have. I understand the Payment Instructions Information is entered in a Grid, but how can I report on that information by vendor?GI created for us attached - only shows Bank Name Thanks!

Hi All,We are trying to enable the audit history on the Sales prices screen AR202000.  We have it configured but when opening the audit history from the screen’s tools menu, nothing happens visually but when trying to navigate after, the site is slow and unresponsive until you close the browser window and reopen.  Does anyone have any insight as to what the issue might be? 

 Hi everyone,I’m now trying to do some modifications to the original screen without directly change it. I have defined a lot actions in the Graph ext, and I can see those actions if I choose to directly add the action definition in original ts file, but I need to keep those changes separately for further update. I tried to declare a new export class in an extension ts file and let it extends from the origin export class, but it did not work and I just can not see the action button here. Please let know if my idea is feasible or not? If it is feasible, how should I correct my code ? Screenshots about my current Code:Original Grid setting(Shipment Package):If I add my action on above class, it will shows in the Grid toolbar as expected:But if I choose to add my action in a new extension ts file in the extension folder of this screen like below, this button will not show up: 

Hi Everyone.Currently I encounter error while. executing my custom button name “Create TP Number”. and here my sample code.public static void CreateTPNumber(PMQuoteMaint pMQuoteMaint){ using (var ts = new PXTransactionScope()) { PXResultset<CROpportunityProducts> pXResultsetCROpportunityProducts = pMQuoteMaint.Products.Select(); PXResultset<PMQuoteTask> pXResultsetPMQuoteTask = pMQuoteMaint.Tasks.Select(); List<CROpportunityProducts> cROpportunityProductsDuplicate = pXResultsetCROpportunityProducts .RowCast<CROpportunityProducts>() .GroupBy(x => new { x.InventoryID, x.TaskCD }).Where(g => g.Count() > 1) .SelectMany(g => g) .ToList(); if (cROpportunityProductsDuplicate.Count() > 0) { foreach (CROpportunityProducts pMQuoteTask in cROpportunityProductsDuplicate) { InventoryItem pXResultInventoryItem = SelectFrom<InventoryItem&g

Hello!  We recently went live with Acumatica and are using the Acumatica Payments.  The embedded help information says that for a payment link to be automatically sent with an invoice a Processing Center must be selected.  - First screenshot I can’t find a way to default this processing center to ACuPay (or something that’s not blank).  Is there a way to do this or does our Billing Specialist have to populate this for each invoice?  - Second screenshot