Discussion Forums

We use serial tracked products that sometimes get consumed into other internal orders but sometimes get sold as is to the customer. We are having a hard time finding a way to get a list of serial tracked items that have neither been consumed into other orders nor sold to the customer. Any guidance of how to best pull together this information into a GI that employees can check against? I’m thinking probably some combination of ARTran and AMMTran info

If I understand correctly, in a SaaS environment, I cannot use a backup I download from the Backup Access Service to restore my production tenant.  I need to pay separately to have Acumatica restore from backup?

Hello!What is the best practice for invoicing a deposit within a project? I have tested using VAT tax prepayment invoicing, which seems to work somewhat, although it is cumbersome, and was not developed for using in projects.Thanks! 

 Hello Everyone,I am trying to clean up some tax issues that arose on the last payroll paybatch we ran after a recent upgrade. Specifically there are a few taxes that have appeared on a recent payroll payrun that were not there before the upgrade. In one case I had the NV ER SUTA SC show up. We caught it on the payroll liabilities bills run. In another case I have New Mexico Workers Comp showing up as a tax on a few employees paychecks as well. We upgraded to 2021R2 21.213.0038.What is the fool-proof way to make sure they do not appear on the paychecks next time? Is it to de-select all the “required” checkboxes and set the rates to 0.00 on the right panel? Then update/assign taxes to employees?Why would New Mexico Workers Comp show up as a tax? Is there a setting in Deduction Codes or Workers Comp Codes? 

Hi,I’m trying to hide zero values in report through condition but there is a value difference when I run the report.Could you please me to hide values through visbile expression. I tried some condition but it is showing true or false.Please below image and RPX file  

Is there any reason the Application Period would not be the same month as the Application Date on checks? On Prepare Payments screen the Application Period matches the Application Date (users do not manually change this field) but once processed it changes in some cases

   I’m trying to set an Automation Schedule for the Recalculate Customer Balances mass-process screen. The client hasn’t locked any periods, so the filter defaults to the first period in the system.In 24R1 I could use the Relative checkbox to adjust the period. In 25R1 Acumatica got rid of the box and says the date-relative options can be used, but I can’t enter @PeriodEnd in the Filters to Apply tab.Is it a permissions thing or roles?Release Notes2024R1 Auto. Schedule2025R2 Automation Schedule 

Hi, a lot of our prospects and customers use FieldWire for the Field operations and especially for Plan management. The application is pretty advanced and I don’t think that we have an ISV that could replace it and most of them want to keep the application. Am I wrong does Acumatica have an ISV that can compete with FieldWire ?  If not, does any has any experience with integration FieldWire to Acumatica ?

How can I change the selector in the Customer Number field so that it searches by Customer CD, Customer Name, and Telephone number as well? How can I do this?

Hi Team,I need to override the Email Quote button on the Sales Order screen to change the default From and To email addresses.How can I properly override this action in a Graph Extension and update these fields? Thanks in advance!

Excited to have signed up with Acumatica at the end of last year and now be embarking on our transformation journey, with planned Go Live later this year and early next for our two key divisions. I work for Tower Supplies, a global distributor of workwear, uniform, PPE and janitorial products and related services, based in the UK.I’m keen to connect with other users, especially those based in the UK, if someone can point me to a UK specific area, if there is one, and we also have some open vacancies in our project team if someone can point me to a job board, if there is one.Looking forward to the support across the community as I’ve heard good things!Thanks all.

It's great that we have such a vibrant Acumatica community to get quick answers to questions and gain product knowledge! We have very active members jumping in to help others out all the time. The goal of the community is to respond to every member’s question so that no one goes away "empty handed".Connect, Learn, Share Acumatica Community Webinar - Coffee & Code - Coffee & Code: Acuminator Version 4 - February 20, 2026We hope you had a great time at Summit. There were lots of exciting new products announced and I can’t wait to get my hands on them. To help you out, we have a new version of Acuminator that wa

Hi, good day!Does anyone know about outbound IP whitelisting on Acumatica server? Can someone please share their knowledge about this.Thank you so much!

Hi, how can I assign a cost to an item that is sold by the sales team on a sales order but is not purchased through our purchasing process?For example, we resell an employee’s day rate when they work on-site at a customer location. Currently, because there is no associated purchase transaction, the system records the sale as 100% profit, which is not an accurate reflection of the true margin.Could you advise on the correct approach to ensure the cost is properly captured and reflected in margin reporting?

Expand below for Table of Contents.Overview Getting Started  Capabilities and Limitations  Technical Architecture and Security  Troubleshooting and Best Practices    Acumatica 2025 R2 introduces AI Automation with AI Studio as an Experimental Feature, a secure and c

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

Hey guys, I found a place to assign a vendor specific PO report. however the dropdown list is not showing my custom report that i uploaded via Report designer. Also overrride box is greyed out. how do I solve this?  

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? 

Hello,We have a customer that uses ‘locations’ to ship to the various stores under the main customer umbrella. We noticed that the sales person would need to be added to each individual location for them to be attached to it. However, when we do this, it duplicates the customer in its entirety. I have seen in my research about duplication verification, but that is not on my enable / disable list.  I’ve also read that this may not be possible yet (i may have been looking at an old post.) Has anyone else experienced this issue and possibly know a fix?

Hello,We need the freight cost that is defined on a dropship PO to be linked back to the sales order. We need the freight cost to be tracked and passed from the vendor back to the customer in order to track profitability for the freight line on the sales order. If we do not have the ability to track freight cost, then all we are getting on the sales order is the freight price which throws off profitability.  Tracking dropship freight cost to a sales order invoice. Here is a dropship purchase order. I added line 002, Freight Charge, onto the PO at a $50 cost. This is the cost the vendor is charging us for freight. This line is linked to the sales order. We would like this cost reflected on the sales order that is linked to the dropship purchase order for profitability purposes.   Here

When I try to release an issue (IN302000), I get PXLockViolationException error:Question: does the tstamp in each ARTran row in the database need to match the PXCache somehow?  Which object in the cache do I need to look for?

I wanted to take a minute to share this with the community. If you have the following feature enabled on Microsoft Edge, it breaks the ability for Acumatica to export to excel ( the little excel buttons on every grid in the system ) if you are using Modern UI. Disable it and you can export to excel again.  

We built this GI in 2024. it was just last week found out that some of the data is repeating itself. Either in a negative or different date  

Our bank is requesting that we add an additional value to the NACHA export file. I have made the spot on the file export, but I can’t figure out how to get the data into the export scenario. The value we want to add is APInvoice.InvoiceNbr. I see the export scenario has this APPaymentList source object, but how do I know what is on that or modify to add additional data?Appreciate the help.

Hi Community,I’m working with the Inventory Valuation report (IN615500) in Acumatica and I need to filter the report by a date range.In my report schema, the main table used is INCostStatus, and it only contains fields like: InventoryID CostSiteID QtyOnHand TotalCost ReceiptDate There is no transaction date or financial period field available in this dataset.My requirement is to:Filter the Inventory Valuation report based on a selected date (for example, valuation as of a specific date or between a date range).I’m considering adding a parameter and filtering using:INCostStatus.ReceiptDateBut I’m not sure if this is the correct approach for inventory valuation in Acumatica, or if there is a standard/recommended way (such as using financial periods or another table).