Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

ray20Captain II

Seeking the best strategy for upgrading from the legacy version to the latest version

Hello, We have been Acumatica PCS users for 8 years. Our business runs almost 24/7 (7×24 hours). To ensure stability and reliability, we chose to stay on the 2021 R2 version.However, Acumatica now requires us to upgrade from the end-of-life version. Otherwise, we will be charged a Retired Version Premium. We are currently deployed on Windows Server 2016 + SQL Server 2016. Unfortunately, 2024 R2 does not support two third-party applications.We must upgrade to Windows Server 2019/2022 + SQL Server 2019/2022.Can someone advise the best strategy for this full upgrade? Here’s our proposed plan:Provision a new server with Windows Server 2019 + SQL Server 2019. Back up the database from the old server and restore it to the new server’s database. Use the ERP Upgrade Wizard to perform a phased upgrade: 2021 R2 → 2023 R1 → 2024 R2. Then thoroughly test all functionalities and customizations. This process may take at least one week. If testing is successful, repeat Steps 2–3 (e.g., using

12 minutes ago

lucasdnd

Configuration and Installation

Fail to connect SFTP SSH to FLEX : "Permission denied (publickey)" when using OpenSSH key pair

Hi everyone,I'm currently trying to connect a FLEX synchronization scenario to a secure SFTP server. The SFTP server has been configured to use OpenSSH public/private key authentication.I followed the official documentation carefully: https://help.acumatica.com/(W(14))/Wiki/ShowWiki.aspx?pageid=d9555f46-0a48-4059-8082-decc6b8e3652 However, when I try to establish the connection, I get the following error message:Permission denied (publickey) FYI : The SFTP user does not have a password (only key-based access) but FLEX seems to hash the password even when the password field is left empty, which might be causing the authentication to fail.

1 hour ago

GwenEkamba

Everything Else

Error: Insufficient stack to continue executing the program safely, what could be the fix?

Hello Everyone 🤗, Happy Friday! and hope all is well. I am trying to approve a time off request but I see the Insufficient stack error: I also see it when I try to enter my time in the Activities tab for a project. This occurred after we upgraded to 2024 R2. I tried to reset the caches and restart the website but nothing, what could resolve this error?. Thank you again

391

1 hour ago

tuan755Freshman I

Develop Customizations

SQL DAC View disappears every time customized project is republished

Hi all,I created some custom DAC views from sql for GI. When I publish the project for the first time, the tables still appear normally. But when I publish the next times for other projects, the tables in GI will disappear. I checked on the database and the views are still there but not appearing on GI.This is my sql code in the database script This is the code I let the system automatically createDo I need to adjust the initialization code for the above scripts? Or do I need to do something else ?

How to Transfer Allocated Inventory to Production Location?

We often allocate input materials to a Production Order ahead of time — but the materials are in a different location than the production site.Once allocated, Acumatica won’t let us transfer the materials to the correct location because the inventory is locked.Our current workaround is to: Unallocate from the Production Order Transfer the inventory Reallocate it again This feels messy and inefficient.Our VAR suggested we just consume from the original location and physically move the material — but we’re not comfortable doing that due to compliance concerns.Has anyone run into this?Is there a way to transfer allocated inventory while keeping the link to the Production Order?Appreciate any ideas!

131

1 hour ago

bobbytherbsFreshman I

Financials

Step by Step How To for Bank Corrections

A Customer sent a check and we recorded the payment for $200. The check was deposited to the bank and a Bank Deposit in Acumatica which included the $200 check was created. A few days later the bank came back with a correction stating the check was written for $20 not $200. We voided the $200 payment then created a $20 payment and created a corresponding Bank Deposit. Is there a step we are missing? The original deposit with the $200 payment is still equal to the original deposit we created so our bank rec is off by $180. Please help me identify what step is missing

101

5 hours ago

acheesmanFreshman I

Construction

Project Tasks - Is there a way we could have 5000 task lines?

Are there any solutions out there that would allow for upwards of 5000 task lines on a project? We realize there are limitations based on tiers, but we are getting stopped when we upload a certain number of rows to populate a cost budget. Are we misunderstanding the line upload limitation as an upload is the same as a “commercial transaction”?Or is there a way to do Parent Projects and Subprojects? Are there any solutions out there that would tackle that? Would love to hear anyone’s ideas. Thank you!

505

5 hours ago

shane62Freshman I

Reports and Generic Inquires

How to keep a dollar figure together in one line in forms

Sometimes, a dollar figure such as $123.45 included in line description might be split into two lines after the “.”, i.e.The first line looks like: some description $123.The second line looks like: 45 more descriptionSetting the option CanSplit to False partially solves it but introduces another similar issue that a dollar figure such as $1,234.56 might be split into two lines after the comma, i.e.The first line looks like: some description $1,The second line looks like: 234.56 more descriptionIs there anyway to always keep the dollar figure together in one line?

364

6 hours ago

nboiniFreshman I

Reports and Generic Inquires

Prepayment Usage report

Is there a report that I can run to see the Prepayment usage. Our customers would like to know where the prepayment applications with the details like Invoice Ref Nbr, inventory item, quantity and amount at invoice line level. -Thank you,Nalini

141

7 hours ago

fosterjeff01Freshman II

Configuration and Installation

Modify Two Factor Authentication SMS?

Currently when users request to send an SMS for the two factor authentication code (if they app or other options aren’t available), it send the code only, with nothing else. Is there a way to modify the SMS message sent so that it includes something like “Your code is XXXXXX” or similar so devices like MacOS and iOS know to offer it to enter into the browser for you rather than needing to type it manually?

10 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

2448 topics

Distribution

2336 topics

Manufacturing

861 topics

Construction

820 topics

CRM

279 topics

Field Service

375 topics

Retail

557 topics

Payroll

267 topics

Professional Services

16 topics

Low Code | No Code Customizations or Integrations

400 topics

Develop Customizations

3221 topics

Develop Integrations with Web Services | APIs

826 topics

ISV Solutions

147 topics

Configuration and Installation

1021 topics

Reports and Generic Inquires

2449 topics

Import and Export Scenarios

925 topics

System Health and Performance

164 topics

Community site discussions

354 topics

Community Introductions

99 topics

Everything Else

971 topics

Technology Partners and Customers

Forum for Acumatica technology partners and customers to collaborate on their unique products

MYOB User Discussions

27 topics

JAMIS Prime User Discussions

6 topics

News & Announcements

Get the latest on our community & company!

Acumatica News & Updates

142 topics

Events & Meet-ups

154 topics

Developer Newsletter

19 topics

56 topics

ray20Captain II

Configuration and Installation

Seeking the best strategy for upgrading from the legacy version to the latest version

12 minutes ago

lucasdnd

Configuration and Installation

Fail to connect SFTP SSH to FLEX : "Permission denied (publickey)" when using OpenSSH key pair

1 hour ago

GwenEkamba

Everything Else

Error: Insufficient stack to continue executing the program safely, what could be the fix?

391

1 hour ago

tuan755Freshman I

Develop Customizations

SQL DAC View disappears every time customized project is republished

How to Transfer Allocated Inventory to Production Location?

131

1 hour ago

bobbytherbsFreshman I

Financials

Step by Step How To for Bank Corrections

101

5 hours ago

acheesmanFreshman I

Construction

Project Tasks - Is there a way we could have 5000 task lines?

505

5 hours ago

shane62Freshman I

Reports and Generic Inquires

How to keep a dollar figure together in one line in forms

364

6 hours ago

nboiniFreshman I

Reports and Generic Inquires

Prepayment Usage report

141

7 hours ago

fosterjeff01Freshman II

Configuration and Installation

Modify Two Factor Authentication SMS?

10 hours ago

New to the community?

Get Started HERE be sure toIntroduce Yourself and reach your Community ManagerChris Hackett

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! April, 2025

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

Ankita Tayanahas earned the badge Financials expert
ranjithduraisamy72has earned the badge Manufacturing expert

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded