Learn
Learn
Support
Support
Product
Community
Partners

Community
Discussion ForumsFinancials 1321 Distribution 1323 Manufacturing447 Construction423 CRM75 Field Service188 Retail-Commerce343 Payroll163 Low Code | No Code Customizations or Integrations114 Develop Customizations1896 Develop Integrations with Web Services | APIs399 Other Developer Topics100 ISV Solutions 107 Configuration and Installation 582 Reports and Generic Inquires 1271 Import and Export Scenarios 496 System Health and Performance 106 Community site discussions170 Community Introductions72 Everything Else 589
News & AnnouncementsAcumatica News & Updates93 Events & Meet-ups122 Developer Newsletter 19 Newsletter 33

Create topic
Login

Community
Discussion Forums

Discussion Forums

Get inspired and gain all the knowledge you need

10188 Topics

Most views

Recently active Most replies Newest first

shawnhutsko5Freshman I

posted in Everything Else

Error code- 503 5.5.1 Bad sequence of commands

What does the error code mean and how do you fix it? It’s showing up when you click on an email under time and expenses, all emails, failed emails tab. One of the emails is our own internal user so I know that email is valid and the sending email account does not show it in sent items so it does not look like an issue with the email client.

2 years ago

ray20Captain II

posted in Distribution

What is the quickest way to get "end of Day" or "end of month" inventory balance.

Hello, I know we are having “Inventory Balance” report (IN615000) and “Historical Inventory Balance” report (IN616000). However, Inventory balance report is something like real-time balance, it displays the balance at the time of the report running. History inventory balance can only display the beginning and ending balance of selected periods. If my requirement is to record and display the entire warehouse’s inventory balance of each day for the coming week, like from Monday to Sunday. What is the quickest/simplest way to do it. All I can think out of is to set a schedule that run “Inventory Balance” on 00:01 every day, and sent this record out as email. And in the final day, I merge them into one excel. This is a workable way, but could it be better?

1 month ago

Doug JohnsonAcumatica VP, Product Management

posted in Financials

1099-MISC and 1099-NEC updates for Tax Year 2021

For tax year 2021, the IRS made minor changes to the 1099-MISC and 1099-NEC forms. Details of the changes can be found on the IRS website. Acumatica will implement these changes in upcoming versions of the software to assist with customer 1099 filings. There are 3 changes that impact Acumatica.Form 1099-NEC sizing. Acumatica will reduce the height of the form to match IRS changes. Form 1099-MISC, box 11. New use for box 11 includes any reporting under section 6050R, regarding cash payments for the purchase of fish for resale purposes, from a individual or corporation who is engaged in catching fish. Form 1099-NEC, box 2. Payers may use either box 2 on Form 1099-NEC or box 7 on Form 1099-MISC to report any sales totaling $5,000 or more of consumer products for resale, on buy-sell, deposit-commission, or any other basis.1099 Paper Forms:Changes to the 1099 Paper forms are currently available in the following builds of Acumatica:2021 R2 Update 3 Hotfix 1 (21.203.0030) and later 2021 R1 Up

1 year ago

Naveen BogaCaptain II

posted in Configuration and Installation

Outlook - System Email Account Setup Failed

Hello Everyone,We are facing an issue while conguring Outlook email account but getting error “The mail receive has failed. NO LOGIN failed.”.We have given valid credentials and other parameters but still getting this issue. Can anyone help me on this? Please find the screenshots for reference.

2 months ago

lauraj46Captain II

posted in Reports and Generic Inquires

Creating a GI or report parameter to filter a datetime field by date AND time

Recently we had the requirement to create a Generic Inquiry and Report with parameters to filter on a date range using both date AND time to account for multiple labor shifts. I could not identify a schema field that included a time component, so I created two additional string parameters for the time components. I then parsed the time parameter and added the corresponding number of minutes to adjust the start and end dates in the GI/Report condition. I also had to make an adjustment for UTC, which works differently between the GI and the Report. GI search screen:Condition on the GI:It seems a bit hacky, but it does do the trick. Has anyone else encountered this requirement and possibly found an easier method to provide the functionality?

7 months ago

ggillFreshman I

asked in Develop Customizations

How to change default value for a field on a form?

Hello all, How would I go about changing the default value in the customization project for a specific field on a form? I though it would be under this section, but I haven’t had any luck so far.

2 years ago

davordobFreshman I

asked in Configuration and Installation

NoahSemi-Pro I

asked in Import and Export Scenarios

Import Scenario: How to find and delete a row on the Stock Item>Cross-Reference screen

I have a need to delete the Global cross-reference for many Stock Items in our system in order to get our Printed Forms to use the correct customer or vendor cross-reference (all cross-references appear in the Alternate ID field on the Sales Order and I can’t figure out how to get Report Designer to determine which is which without bringing tons of DACs). I need to delete those Global one’s at the bottom. Super simple to do manually. I have an Excel sheet data provider with all the Stock ID’s, Aternate ID, and Alternate Type. I’ve tried Keys, Custom Keys with @@ format, Line Number tricks. The documentation says after finding the record with a key (tried both <Key: AlternateID> and <Key:AlternateType>), the summary Target Object must be selected to use the Action: Delete. Unfortunately with most of the scenarios I’ve tried there isn’t a useful error message either. Anyone have any tips on how to accomplish this. I think a method that works would be useful in the futu

2 years ago

MFerat91

asked in Configuration and Installation

Screens did not load in Google Chrome, Version 91

After login, the user only gets a spinning wheel and cannot access any screens to use the system.This issue was reported also for Google Chrome, version 76/77, and to proceed to work I had to set Disabled on Enable lazy frame loading (chrome://flags/). But this flag does not exist on the new version of Google Chrome.I mention that this issue I found on the Acumatica version 17.212.0020.

1 year ago

Omar GhaziAcumatica Moderator

posted in Develop Integrations with Web Services | APIs

Microsoft Teams Integration Ready for Managed Availability! Searching for Customers

UPDATE: March 3, 2023Thank you to our partners and customers who signed up to try our Teams integration customization and provide feedback! As announced during the Summit 2023 Keynote session, Microsoft Teams integration will be available as part of the core product starting 2023 R1 as part of our new Experimental Features. We have made a lot of great improvements both in the integration as well as its usability. Yet we are just beginning.We will be ending the Managed Availability Program for Teams integration for any new requests. This means that if you were a partner or customer as part of the program, you can continue using the integration as a customization that was provided. However, support, ongoing maintenance, and support for future versions will no longer be available from April 4, 2023. We will continue to monitor this community site as well as our interaction with customers and partners to collect ideas and feedback to help improve our Microsoft Teams Integration (core).Sinc

6 days ago

parameshFreshman I

posted in Develop Integrations with Web Services | APIs

API Login Limit Error for REST API Calls with Access Token

Hello Friends,I’m new to Acumatica and I’m trying to integrate with Acumatica using Contract based REST APIs using OAuth. We have a L1 tier license.I generate the OAuth Access Token first, and then reuse it to call Acumatica APIs. But I often run into “API Login Limit” errors when I try to create Invoices through APIs. I’m confused because I’m not really trying to login and just trying to create Invoices and read customers. And since I’m using OAuth, I only login once and generate an access token, and use it in all subsequent calls.[PXException: API Login Limit]PX.LicensePolicy.PXLicensePolicy.CheckApiUsersLimits() +2479PX.Web.PXApplication.Application_PostAcquireRequestState(Object sender, EventArgs e) +9System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94 Can you please help me un

1 year ago

ray20Captain II

asked in Develop Customizations

How to enable the user defined fields even when the whole document is completed?

Hello, I like Acumatica’s user defined fields feature, I can add fields without writing code.But these fileds are disabled when the shipment is completed, while I’d like to keep it being enabled. Is there a way to do it? I’ve found a similar question above, but as I checked, I can not find the “UDF” in automation steps. So I can not enable it. Is there any other way to do it?

3 months ago

aaghaeiCaptain II

asked in Develop Customizations

Error 403 Forbidden: The request was a legal request, but the server is refusing to respond to it. Unlike a 401 Unauthorized response, authenticating will make no difference.

Hello All,I am trying to retrieve data using OData V4 but I get the error in the subject line. Everything is on my local machine and works with OData V3. Any help is appreciated why does V3 work but not V4?

6 months ago

KurtBauerJr Varsity III

asked in Develop Customizations

Unable to publish from customization project editor

We have a development environment that has many instances of Acumatica installed and in the past week or two publishing from the customization project editor no longer works. The log window at the bottom opens and nothing is logged. There is a warning in the windows application log for ASP.NET.4.0.30319.0. I have included the details at the bottom. This is happening for all 20+ versions of Acumatica installed in any application pool. There is a workaround to update any changes through the editor, but then publish from the customization projects list screen (SM204505).Thanks,Kurt Bauer Event Log DetailsEvent code: 3005 Event message: An unhandled exception has occurred. Event time: 10/15/2020 8:42:56 AM Event time (UTC): 10/15/2020 12:42:56 PM Event ID: 908185df7ee84a46bd4210f5c030eb43 Event sequence: 15 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/ROOT/XXXXXXX-2-132472393165235242 Trust level: Full Application Virtua

2 years ago

ray20Captain II

asked in Import and Export Scenarios

Can Acumatica working with SFTP client in automation.

Hello, Our vendor is requiring us send files which are exported from Acumatica to them by SFTP in daily basis. Yes, this can be done manually, I can export the file to my local computer and then I use a SFTP client to send the file. However, I am wondering can this be done in an automation way? Thanks in advance.

1 year ago

mrivera67Freshman I

asked in Distribution

how to update unit cost manually

hello everyone! can someone show me how to update unit cost manually for an inventory item? thanks in advance,mrivera67

1 year ago

jchavezFreshman II

asked in Develop Integrations with Web Services | APIs

Connecting To Authorization Endpoint - OAuth Authorization Flow

Hi,I’m trying to test Acumatica’s OAuth Authorization flow using Postman. I need to implement an API that will generally be called from a website (our customer portal) and return some information from our company’s Acumatica via OData.I followed the steps in the I300 Web Services course: https://openuni.acumatica.com/courses/integration/i300-web-services-basic-data-retrieval/as well as in the reference documents: https://help-2021r1.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=2930d2f7-e081-4d0e-8879-93907ce82607I am able to use the Resource Owner Password Credentials flow successfully, but we need to implement the Authorization flow, using a client_id + client_secret approach.I already created a Client in the Connected Applications screen, and set the flow to Authorization Code.Please correct me if I’m wrong: I understand that every time this API will be called, it will need to first request an authorization code from (GET) https://<Acumatica ERP instance URL>/identity/connect

1 year ago

jlowry40Freshman I

posted in Develop Customizations

Looking for customization on attaching files to an invoice notification

Has anyone created a customization to automatically attach files to an invoice? We need a solution where we can attached service order reports to SO invoices upon emailing. Someone submitted an idea on this matter 2 years ago, with several upvotes, but Acumatica hasn't acted on this yet.

4 months ago

suemackeown13Jr Varsity II

asked in Reports and Generic Inquires

OData feed - DataSource Error in Power BI

When accessing a GI through OData in PowerBi or Excel, I get the following error message:DataSource.Error: We couldn't parse OData response result. Error: Unexpected end of file has occurred. The following elements are not closed: feed. Line 6, position 120.Details: DataSourceKind=ODataDoes anyone know what this means, and how this can be solved?

17 days ago

larrylySemi-Pro II

asked in Develop Customizations

How to use PXDefault to set default value for a new field?

Hi all,I want to add a new field to the SO that the value is from the customer’s buying group. The buying group is under the Attributes. I tried to use PXDefault to search the attribute’s value. But I have a problem is I need to use fixed attribute ID. The value is not linked with the buying group value. I need to save the value to the database at that moment. Because the buying group value may changed later. Does any one knows how to do it ? Thanks.

1 year ago

TravisFreshman II

asked in Everything Else

Trouble Setting Up a System Email Account

I have 2 tenants in our Acumatica install (single server). Test and Live. On our Test tenant I was able to get a System Email account added, setup and working perfect. However on our Live tenant, after mirroring the settings exactly like the account on the Test tenant, after clicking the [TEST] button, it just spins, and the Elapsed Time just keeps counting.I've triple checked the system email account settings, everything matches.Some notes:The spinner "Press to abort", does nothing.System Management -> System Monitor does show the running process. However the ABORT button does nothing. Also, if I click [Active Threads], it shows this error in the modal that pops up: User: xxxScreen: ~/pages/sm/sm204002.aspxCommand: checkEMailAccountTime, sec: 750at System.Net.UnsafeNclNativeMethods.OSSOCK.recv(IntPtr socketHandle, Byte* pinnedBuffer, Int32 len, SocketFlags socketFlags)at System.Net.UnsafeNclNativeMethods.OSSOCK.recv(IntPtr socketHandle, Byte* pinnedBuffer, Int32 len, SocketFlags so

2 years ago

saikiranb36Freshman II

asked in Develop Customizations

Error "Could not get dependencies for project reference"

Hi,Though I have added all the references and dll to the customization project and solution, I am getting the below error. Thanks,

2 years ago

josh.fischerAcumatica Product Manager

published in Retail-Commerce

Amazon Integration - Information and Managed Availability Sign-upF.A.Q.

Updated 3/21/22 The following information answers many of the common questions about Acumatica’s Amazon Connector and our Managed Availability Program.At the bottom we provide a link to sign up for managed availability. This does not commit you to anything. Only let’s us know you’re interested and we’ll grant you access to additional information.General InformationThe Acumatica Amazon Connector works with 22R2 and beyond The solution focuses on order management and recording Amazon Fees It supports FBA and MFN (FBM) merchants Feel free to post questions or comments to this article and we’ll do our best to answer quickly and incorporate your questions into the content.What is Managed Availability?This is a program Acumatica utilizes when releasing a new and rather large/important new feature. It’s very similar to a beta program or a pre-release program. Our goal is for our team to work closely with the Acumatica Partner and Merchant on the project. We go through discovery together, dete

167327

10 days ago

Page 1 / 408

Badge winners

palboreshas earned the badge Easy talker
rwhetsell77has earned the badge Easy talker
marilizevanzylhas earned the badge Easy talker
lawsonthas earned the badge Easy talker
Atiqhas earned the badge Easy talker

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Social Login

Login to the community

Social Login

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

About Acumatica ERP system

Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.

Privacy Policy
Terms of Use
GDPR
SLA
Support
Report an Outage