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 sr

Hello, I am required to initiate an approval process for Cash Transactions.However, I do not want the approval process to apply when the Cash Transaction originates from the Process Bank Transactions form, as those transactions are released by default without manual intervention.Is there a way to identify the origin of a Cash Transaction and bypass the approval process when it has been created through the Process Bank Transactions form?Thank YouAmanda 

We have a payment made in 2026 (application date 2026 also) but it was posted in 2025. We accidentally adjusted it to match a 2025 invoice that was reclassified and now we can't adjust it to the correct 2025 invoice in Acumatica to ensure the reporting is correct.

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 l

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: 

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, Investmen

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 p

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 helpi

Using V2021 R2.  When I try to send an AR invoice via email (in the invoice screen under Printing and Emailing or from the Print Invoices and Memos screen), I get the error message.  I can print to screen and then send to email from the print screen.What setting am I missing?

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 t

I’m getting the below error when trying to Close a Production Order: Error: Updating 'Production Item Split' record raised at least one error. Please review the errors.Specify the quantity greater than 0.    Which screen/section should I review to find the split line with 0 quantity? What is the recommended fix for old production orders where the split record has 0 qty (update split, clear allocation, add a completion, etc.)?

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?

Does anyone have any suggestions for a catch weight scale that integrates with Acumatica easily?  This use case specifically is for a butcher shop.

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" })

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="upd