Everything Else

I’m editing the email template for Dunning Letters.I want to include a sentence that has the due date for the overdue balance. 14 days from the day the letter is sent=Today()+14 isn’t something that works when I add it into the template’s email body. What’s the trick to get this to work?

We’re using Acumatica’s WMS and we’ve run into an issue with a pick list that was started by one user but not confirmed. The original picker left for the day without completing the pick, and now the pick list is essentially locked—no other users can access it, either through the picking screen or the pack-out stage.Is there a way for a different user (such as a supervisor or another picker) to either take over the pick list or force it into a confirmable state so we can move the order to packing?Any guidance on how to handle in-progress pick lists that are abandoned before confirmation would be appreciated!

What 3rd party Product will you recommend for the user-configurable certificate?

I would like a report showing the invoices for customers by ship to state. 

We recently updated from 24R2 to 25R2. For HIPAA and data security reasons, we need an audit trail on our customer accounts. 24R2 and previous releases, clicking audit history from the AR303000 showed ONLY the audit history for the current client.After the upgrade, the audit history shows audit history in chronological order for all accounts, and only about 2 days worth of audits shows up on the page.Screenshot of current audit history--expanding the history shows field changes for any customer, not just limited to the customer ID.Same customer - audit history from 24R2 (we still have a testDB prebackup). expanding the changes is limited to the customer ID.  O

I received a payment from a Vendor that is a refund for a previous invoice paid.  How do I process this transaction to show that this vendor paid me back?  The refund exceeds any of my invoices and all invoices have already been paid.  So there is no open invoice to apply a credit to.  Need some help.

 Love seeing this on my desktop every day!  (This is a login banner from 26R1).   

I have a publicly traded customer who is looking to track any changes made in settings in Acumatica.  They have asked how to track the last modified date for any report in the system.  When you go to a report form in Acumatica like AR641000, there is no DAC schema provided and you know that the entries on the Report Versions tab must be stored somewhere.  I have two questions:What table in Acumatica is there a list of all the existing reports? What table are the Report Versions entries stored in?Thank you,John 

The Item ID hyperlink on Sales Order and Shipment details cannot open the Stock Item popup window, no response after clicking.But the same Item ID link works fine in AR Invoice screen, can open stock item page normally.Can somebody give some advice?

We have a customer who wants to use multiple virtual warehouses to allocate stock.In reality, all of the items are in the same physical location.If a particular warehouse is selected on the sales order, so in turn the shipment, is it possible to change the warehouse that the item is picked from when using the Automated Warehouse Operations/handheld device? 

Hi Acumatica Community,I’d like to share a resource dedicated to Acumatica in Vietnam:https://acuerp.vn/This is a Vietnamese blog focused on practical Acumatica usage, built to support both businesses and consultants working in a local context.The main goal is straightforward:– Help companies understand how Acumatica fits real operations before implementation– Share hands-on configuration, customization, and deployment experience– Provide practical use cases instead of generic documentationKey highlights:– Content tailored to Vietnamese business environments (finance, distribution, construction, F&B)– Real implementation scenarios from actual projects– Guidance on system setup, workflows, and data structure– Insights into applying Acumatica for cost control and operational efficiencyIn many ERP projects in Vi

Hello all,I am releasing a tool that I created using Claude Code (open source, github). I wasn’t going to download compliance documents one at a time to submit to auditors and vibe coded this tool.  Hope this is useful for someone. Source and pre-built binaries are at : https://github.com/hallboys/AttDown4AcumaticaAttDown4AcumaticaBulk attachment downloader for Acumatica ERP — any entity, any filter, any destination.Acumatica's UI lets you view attachments one record at a time. Auditors, compliance teams, and anyone doing an annual document pull want them in bulk. AttDown4Acumatica walks any contract-based REST entity that exposes Files, pages through matching records, and streams the attachments to local disk, S3, Azure Blob, GCS, or (stubbed) SharePoint. PLEASE READ

Hi, how do I set up an automatic email to go to all customers excluding 1 customer class at the end of the month (on or around the 25th of each month) that provides a reminder of all outstanding invoices that are due at the end of the month and have the system attach the invoices to the email?I’m thinking setting up an automation schedule to prepare statement and another automation schedule to print/email statements. The fact that I need to exclude a customer class, I think I’ll need to create a new statement cycle? Please let me know your thoughts.See example email below:Dear Valued Customer,This is a courtesy email to let you know that your invoice/s will be payable soon. Invoice Number Invoice Date Invoice Due Date Invoice Amount

Even after rebooting my machine, every single time that I try to create a new instance of 26R1, I get these errors and the installer stops:Even if I press OK, I get more log errors:If I press ignore, I just get more of these errors about the other log files that the installer created.Question: how to get past these log errors so I can create a new instance?Here’s the full error:Cant't create the site 26R1 -------------------------------------- Inner Exception: Exception occurred while deploying the site files.  --------------------------------------  Inner Exception:  Exception occurred while backing up the files from 'C:\deployment\sites

I’m attempting to add a parameter to a Dashboard for the Branch.  I will then use that parameter in the widgets for that dashboard.  (Goal is to get a branch-specific dashboard.) When I went to add the parameter, I’m not sure which Schema Object to use to find a field for the branch to use in the parameter.  Ideally, I’d like to have the parameter populated with a value for the Current Branch. Any ideas on this would be greatly appreciated!

Hello all,I have been trying to fetch the GIs from Acumatica and push to Power BI. I installed the Power BI desktop version, created a new API user in Acumatica with admin and OData roles assigned.Selected Get Data → OData option in Power BI:  Entered in the URL:https://Application site domain/odataFYI, Its a multi tenant site. and then clicked on connect, after entering in the password:I tried to login using the “B

Hey, Gang - running into an odd result when creating an access role.  I need to have the Stock Items screen ONLY display the CROSS REFERENCE tab.  As it stands, revoking everything but the Cross Reference tab and a handful of other fields somehow still allows the GENERAL and RELATED ITEMS tabs to be visible - I ONLY want the Cross Reference tab.  Here’s what I didCreated a new role (IN X REF) and only gave access rights to the Stock Items screen in Inventory Next, I gave let the Cross-Reference container inherit the rights of the screen and gave the Inventory Item container the Delete access (this could easily have been View Only, but I had already tested that).

Hello team,How to resolve this error? 

Can customer use Acumatica 2024R2 until June 2026 when this version retired on 5 May 2026 ? Because the expired contract customer will due on 24 June 2026

a case where an auto Sales Order Shipment (SOS) is not being created by the system.Details:Sales Order quantity: 13 Inventory on hand: 15 Qty available for shipping: 15 Inventory exists at XYZ location and has been available since April 10 Inventory is not reserved elsewhereDespite sufficient availability, the SO line goes to Back Order and no auto SOS is created.What conditions would prevent Acumatica from auto‑creating the SOS in this scenario? and when I update manually shipping rule and create shipment , below error pop up. 

I’m working through S110_System_Security_2026R1 and got a bit confused about the wording around “creating a system tenant.”From my understanding, the system tenant is automatically created with the instance and isn’t something we manually create -  we only create non-system tenants.However, the guide says, “when you create a system tenant,” which makes it sound like a manual action.Is there ever a scenario where we actually create a system tenant ourselves? Or should this read.. “when you create a new tenant, you may be signed out after its creation,...”For context, I’m working on a local instance that initially had a single tenant. 

I’m wanting to be able to setup what is a “Shared Mailbox” in Office 365 as a system email account.I’ve found this post that says it is possible but I’m not sure how the authentication would be setup as a shared mailbox doesn’t have a ‘password’ and is accessed via another user logged in who has permission.. How We Process Email Inside of Acumatica: Start to Finish (cs3technology.com) I’m assuming it would have to be POP3 and not IMAP potentially?

I have a business event set up to send an email notification when the Release action is done on inventory receipts. Every time the release is being clicked, it is triggering the business event twice, so duplicate emails are being sent. Why is the event triggering twice?Below is what my business event looks like and the log showing the duplicate triggering. 

Hi all, if I create a customer via the UI or the API the CreatedDateTime is always 5/15/2024.  I would like it to be the actual date.  I have not customized the screen or process at all. Is there a setting for this? Thank you