Discussion Forums

Every time I try to search a customer or phone number with the universal search, I receive an error message. We have tried restarting the full-text search, cleared the cache, processed all in the rebuild full-text entity index, rebuilt a new database for my site, upgraded to the most recent version, and applied a new license. The problem still persists. 

I have two custom fields Absolute Variance Quantity for rows and Total Absolute Variance Quantity in the header. I can get these fields to update via PI Review and Scan and Count just fine, but when I do an action such as Set Not Entered To Zero, the custom header field won’t update.Here, the only value that got send to the custom header field was the first line (21), but the header field should be close to 101,772Here is my code for the field definitions and this screen:INPIHeaderExt.usrTotalAbsVarQty[PXDBQuantity][PXDefault(TypeCode.Decimal, "0.00")][PXUIField(DisplayName = "Total Absolute Variance Qty.", Visibility = PXUIVisibility.SelectorVisible, Enabled = false)]INPIDetailExt.usrAbsVarQty[PXDBQuantity()][PXUIField(DisplayName="Absolute Variance Quantity", Enabled = false)][PXFormula(null, typeof(SumCalc<INPIHeaderExt.usrTotalAbsVarQty>) )] Code Editor: INPIReview (Physical Inventory Review)using System;using System.Collections;using System.Collections.Generic;using System.L

My name is Zoltan Febert, I work for Net at Work as a Senior Software Developer. I started working with Acumatica ERP in 2019 and joined the company in 2022.Being a member of the Acumatica community is a real pleasure, and I truly like helping other developers in reaching their objectives.I was born in Hungary and I began programming in high school. After university, I joined a group of young engineers who were rewriting pharmaceutical software for Windows that was based on MS-DOS, which is how I first became involved with ERP systems. Since then, I have worked in a variety of businesses, but ERP systems have always been a part of my experience.My family and I moved to Manitoba, Canada, in 2015. We enjoy hiking, riding, swimming, and running in the outdoors when we're not working.When I'm not on the trails or in front of a screen, I like to discover new places, read about the past, and find decent coffee. In addition to enjoying the cuisines of home, my family and I have a strong appre

I am Manikanta Dhulipudi, Customer Experience Supervisor at NetAtWork India.Since joining the Acumatica ecosystem in 2021 as an Implementation Consultant, I have had the privilege of contributing to the community and growing alongside it. Transitioning into my current role has been an enriching experience, allowing me to leverage my expertise to enhance customer experiences. I am truly honored to have been recognized with the Acumatica MVP Award for the third time. I deeply appreciate the opportunities the community has provided for learning and professional growth.Beyond my professional endeavors, I am fortunate to have the unwavering support of my wife, Viharika. Our daughter, Medhasvi Saanvi, who recently started school, brings immense joy to my life. In my free time, I enjoy playing cricket, spending quality time with my cousins and friends, and cherishing moments with my daughter and my brother’s children, Snigdha and Parish.I would also like to extend my sincere gratitude to my f

For example, M &T Bank as bank name is rejected when entering data.  A developer can change the regular expression to “fix” this but will this cause issues with banks?

I have a customer with a credit balance on their account. They have called requesting we issue them a check for this amount, to bring their account with us to a zero balance.  How do I do this?

I am trying to pull a report for my client that shows all activities for Journal Entries including the workflow entries. I have already mapped in generic inquiries the audit history to GL Batch and EP Approval using the combinedkey, but I noticed the rejection in the Audit history has a GLBatch combinedkey and not a EPApproval Approval ID. This indicates that the record is only recorded in the audit history table and doesn’t have any corresponding entries in EPApproval.Is there anywhere in the system that the rejection reason is recorded and kept after the JE has been approved or deleted? The system is version Build 24.111.0011.Thanks!

I was often asked by customers for an easy way to have an opportunity journey that reflects how it has progressed over time.By using some custom fields, notes and business events, I’ve managed to give them a friendlier version rather that checking the audits.Here’s an image that shows the results:Basically it shows changes on some selected status fields for the opportunity, the person who made them and the time stamp. Also, I added a optional icon that highlights the relevance of the change.This allows the user to get a good idea of how things have progressed in a way that’s easy to undesstand.If anyone is interested in implementing something like this, please let me know so that I can expand on this note.

Is it possible to remove a report completely from Acumatica if it was saved to the server by using the command “Save to Server” in Report Designer.I tried searching for the reports in the Acumatica folders including ReportsDefault but coming up empty.I assume it is located somewhere in the database. Much thanks

Hi, I have a report generated from the report generator. How do I add this new report to the Inventory menu group? Thanks,

Hi folks!I'm Yuri Karpenko, the Founder and CEO of PUGET DIGITAL - an e-commerce agency and system integrator for the Acumatica ecosystem.It's a great privilege to be an Acumatica MVP and serve the community by sharing my knowledge and some tricks in Acumatica, Shopify, BigCommerce, or in the way they are connected.I've been in Acumatica space since 2019, in different roles, starting as a support consultant, then implementation consultant, SME for Retail Edition, and finally as a leader of a digital agency that caters to Acumatica clients and works with Acumatica VARs.I take pride in the high quality of work that we deliver to our clients and their customers. As a Christian, I believe that everything exists for the glory of God, and my work is one of many areas where I try to achieve that goal - glorify God by serving others.Aside from work, I am a father of 3 and a husband of the one and only. My hobbies are my kids' activities: competitive swimming, artistic and rhythmic gymnastics;

Hi,In Live Instance,For a Grid(Form-Tabs screen) I am  Trying to add around 30 lines.Up to 28 lines Data got Entered..When we are trying to Enter 29th line Getting Below ErrorThe Page was not displayed Because the Request Entity is too large. In our Local Instances we are not getting this type of Issue.What are the changes need to do to Solve this in Live Instance?How can I replicate this Issue in Local to debug the code?Thanks,Giri. 

I’m Brian Stevens, a developer on Acumatica ERP since 2018 after two decades of supporting a legacy ERP.  Having participated in seven, I am a huge advocate for the annual hackathon that kicks off summit every year.  I worked for an Acumatica customer until early 2024 when I joined Nuvei and entered the ISV landscape.  My duties as an Acumatica customer spanned not only development, but also training and implementation which gave me valuable perspective as the end user.  Now I use that perspective to consider the user experience for customizations supporting our payment solutions.At the 2025 Hackathon, my team created the Acumatica 3D Photo Booth.  Upload a normal photo of a person to a sales order and click a simple button on the sales order screen.  Then walk over to the Creality 3D printer, ensure the print bed is clear, and print the file that has been deposited on the printer.  A few minutes later, see the person in the normal photo as a 3D miniature.I have a wife and 2 sons.  Whe

I'm Neil Cantral, Director of IT at Wilmar Performance Tool (a B2B distributor of automotive tools and equipment).I've been working with Acumatica since 2016, focusing on customization, automation, and reporting — basically anything that helps streamline processes. I’m also big on EDI and WMS. Along the way, I’ve been named an Acumatica MVP three times and was honored as Acumatica Distribution Customer of the Year in 2024. I am also one of the leaders of the Pacific Northwest User Group and a member of the Distribution CAB.I love connecting with others in the community, sharing knowledge and experiences online and in-person has been critical to my success over the years.  Always happy to chat — let’s connect!Even outside of work I'm always building something. I almost always have a model or prop I'm working on when I'm not tinkering with my aquarium or a strategy game.  ​@Neil Cantral Moderator notes:MVP profiles are closed to comments in order to provide the respective MVP with a page

Hi! My name is Iqra Harrison, and I’m a Senior Business Consultant (recently promoted to Director of Chaos) at Protelo Inc. I embrace this title both professionally and personally.  Whether I’m finding innovative solutions to business problems or orchestrating harmless office pranks (like hiding 200+ tiny ducks around our Folsom office), I love making memorable moments that bring people together.My journey to becoming an Acumatica MVP started as an end-user leading an implementation which gave me firsthand insight into business challenges and operations. That experience, combined with my background in accounting across multiple industries, sharpened my ability to solve problems imaginatively and communicate complex ideas effectively. Transitioning into consulting, I quickly earned my Acumatica certifications and continued leading complex implementations and successful upgrades. I was able to focus on helping clients leverage native features and automation, avoiding costly customization

I have a list of BoMs and their revisions that I would like to archive. Seems PRETTY straight forward but I keep getting a “Document” error during my import. Error: 241 items have not been processed successfully. View name: Documents.

We want to integrate the maps with Acumatica to display the order coordinates based on shipping addresses. Our goal is to sequence the orders according to the shortest route and visually represent them with numbered stops on the map. We would appreciate any insights on how to achieve this efficiently.

Could anyone provide a screenshot of a Row Set Import Scenario for ARM Reports? I am just a little confused on how the Data Source portion works. We normally just setup the reports manually, but this is our first customer who has several hundred lines per report so we would much rather import the bulk. The Data Sources will be “Start Account”, “End Account”, “Start Sub”, and “End Sub”. 

I have a ACH Payment Business Event going and I need a way to show multiple RefNbr (Invoice)on the Notification Template Email that goes out. Single Invoice Paid in a Batch Payments I have no problem it when I select Multiple Invoices.What is the formula to show multiple invoices on a email notification for ACH Payment?Here is what I am working withA ((Document.PaymentMethodID)) Payment has been made by ADMAR Construction Equipment & Supplies.Payment Reference Number: ((Document.RefNbr))Payment Date: ((Document.RefNbr.DocDate))Payment Amount: ((Document.CuryOrigDocAmt)) Vendor Ref: ((Adjustments_print.AdjdRefNbr))   ← this works with 1 invoice in a batch and shows the Invoice Ref # we need to showI tried this below but it breaks the Business Event.<foreach view="APPost"> ((APPost.SourceRefNbr)) - ((APPost.SourceRefNbr)) </foreach>Anyhow if anyone has any ideas that would be great. Thank you 

Is there any latest help document how to integrate Okta with Acumatica.

I am trying to add location and qty in location to Historical Inventory Valuation Report - IN617000, but I have some location that doesn’t select ‘ cost seperate’. So, I get trouble to show both because with such as location that no cost seperate - the field ‘costsiteid’ show the ‘siteid’ instead of ’locationid’. I get trouble in join 3 tables including: INitemsitehist ( Location & Qty), INitemcosthist (Beg. Cost, End. Cost) and INitemcosthistbyPeriod(LastActivitiesPeriod)Case 2 

Hi Everyone,I am currently working on a Generic Inquiry to display stock items along with their quantities on hand across all warehouse locations. I have managed to achieve the desired results by grouping the data using “InventoryItem.InventoryCD” to eliminate duplicates. However, I face a challenge when I attempt to use the GI in a business event that is meant to inactivate items once the quantity on hand reaches zero. The business event works correctly when I remove the grouping from the GI. Can anyone suggest a solution for this issue? I have attached the GI for your reference. 

Hello,I am trying to limit the available values for an attribute based on a value selected for another attribute.Eg: If user select TOYOTA in the Make Attribute, the Model attribute shows only the models for TOYOTAIs there a way to achieve this?

What do I do with outstanding deposits in ACU?  I don’t see it addressed in the cash mgmt pdf’s.

When emailing invoices through the ‘Print Invoices and Memos’ screen, the invoices get marked as ‘Emailed’ even if the process encounters errors and the emails do not send.The emailed status should only be updated to ‘Emailed’ once the email is successfully sent and not when the process errors out.