Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

Omar GhaziAcumatica Moderator

UPS Authentication and API Changes

⚠️ Update Dec 11, 2023: The OAuth 2.0 and new API changes have been rolled out to Acumatica starting with 2023 R1 Update 13 and 2023 R2 Update 4. Configuration steps for using the new API and OAuth 2.0 will be available in the Acumatica help files soon. In the meantime, follow this link to the UPS Rest Configuration guide. UPS recently published an announcement and how connection is established to their API. Partners or customer may have received the following notification. Acumatica is aware of this. Development work to address this change is being prioritized to address it in second-half of 2023.The changes impact the Acumatica direct UPS integration in 2 ways:New OAuth 2.0 for authentication. Since UPS is not issuing API access keys beginning June 5, 2023, which is how Acumatica performs authentication today, new customers or those in the process of implementation are immediately affected. The current workaround is to use our carrier aggregator integrations such as EasyPost or ShipE

134032

24 minutes ago

Patrick ChenJr Varsity II

Develop Customizations

Quickly Generate Access Rights via TSQL

Hello allFor those that don’t know, the security setup has changed with Acumatica 2024R1. When installing a customization for the first time, it is now required that Access Rights to your custom screens be specifically stated otherwise they will not be available to any user/role.“If an administrative user adds a new site map node directly on the Site Map (SM200520) form, the system will automatically set the form’s access rights to Revoked for all user roles. Then the user should grant access to this form to particular user roles on the Access Rights by Screen (SM201020) form.”Our product has over 140 pages and I needed to create an Access Right for each one. While I could have added each one manually, I chose to create the xml for the project.xml via a TSQL script and paste the result into my customization. While I probably didn’t save much actual time, perhaps I can save some for you! Below find my quick and dirty script. You may need to customize the script in the following way

26 minutes ago

Rmak0501Freshman I

Reports and Generic Inquires

Change field setting

Hi,In report “Account Details”, it only allow to run a single Account each time. I want to run a range of account, just like Period. I try to work on customization but not successful. Could some one help me on that?Thank you.Raymond

1 hour ago

FRANKDSWK91Freshman I

Financials

SO Error: The document is out of the balance for Build 23.113.0042

Hi, I’m wondering why I’m getting an saying SO Error: The document is out of the balance in the Bills and Adjustments screen. I’m not sure on what to do to fix this error.

1 hour ago

edsonvelez64Jr Varsity III

Community site discussions

How to PersistInserted in the LocationStatusAccumulator accumulator?

Hi, I'm trying to remove the validation when the user create an inventory adjustment in negative when the QtyOnHand is negative. I edited the ThrowNegativeQtyException method to remove validation when the transaction is an adjustment in the INReleaseProcess graph, But also the validation exists in the LocationStatusAccumulator class. How to override the PersistInserted method in the LocationStatusAccumulator class to remove the validation? Thanks,EV

2 hours ago

bihalivan15Freshman I

Develop Customizations

How to call WebDialogResult multiple times in a loop?

I call WebDialogResult multiple times in a loop.However, this window is displayed only once:(My code:foreach (DateTime dateTime in dateTimeList) { WebDialogResult result = PaymentCalendar.Ask(ActionsMessages.Warning, PXMessages.LocalizeFormatNoPrefix(textMessage), MessageButtons.YesNo, MessageIcon.Warning, true); if (result != WebDialogResult.Yes) continue; } } Help me please

2 hours ago

pauldubuque13Acumatica Employee

Manufacturing

Tooling Maintenance Tracking

Tool Maintenance TrackingDo you need to track tool maintenance? And I do mean Tool Maintenance not Machine maintenance, that is a different animal. I spent years working at a stamping manufacturer where tool maintenance was always a challenge. In my case, I am talking about sharpening a tooling die set. The tools were usually built for a certain life span – so many parts or hits before they needed to be sharpened or replaced. The type of steel and whether inserts were used in the tool, what material you were stamping, size and type of press were all factors.The problem:Sharpening the die takes time and cost money. It’s a hidden cost, while expected it was usually not well managed. To make matters worse, if the customer ordered more parts, we had no idea how much life was left in the tool without physically inspecting the tool, and we had thousands of tools. So, we would take the order and absorb the unexpected costs and delays.The solution:I came up with a method of at least att

2 hours ago

Chris HackettAcumatica Community Manager

Community site discussions

Ask a Question, Get an Answer - April 15 - April 19, 2024 - Need extra help this week!

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 Announcing our New Acumatica Referral Program to Reward our Community for ReferralsWe are excited to launch our Acumatica Referral Program. We believe this creates a win-win for all parties, including referrers, referees, and the greater Acumatica community. Please learn more about our Acumatica Referral Program at referral.acumatica.com. Upcoming April and May 2024 Acumatica User Group Meetups How to Answer Questions on Acumatica Community - We need everyone’s help!Active Participation is needed from every Community user; everyone can provide valuable input using their individual skills and interests. When more people participate, all members benefit - - we need dive

3 hours ago

eudescoelho29Semi-Pro I

Develop Integrations with Web Services | APIs

Endpoint for a Custom table

Hello Developers,I am relatively new in Acumatica REST API development.I have an interesting case where I need to manipulate data of a custom table which was created by a Customisation Project.Based on what I have learned so far, I would need to create a DAC for the custom table and then create a form or Generic Inquiry to access that table. Then I could add a custom endpoint based on this new form or GI .I am not sure if this will work, but I would like to hear from your experience about accessing custom tables. Any contribution is appreciated.

3 hours ago

smartinez

System Health and Performance

Product Availability sync error

We have this error on an items product availability in Sync history. It is not translating the inventory to the Shopify store and we can’t seem to figure out why. Has anyone had this issue and fixed it? “The record has been assigned the Deleted status because it is related to an item that is missing, excluded from synchronization, or configured to not track quantity.:

4 hours ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1733 topics
5746 Replies

Distribution

1679 topics
6479 Replies

Manufacturing

594 topics
2225 Replies

Construction

568 topics
1913 Replies

CRM

155 topics
451 Replies

Field Service

275 topics
916 Replies

Retail

451 topics
1988 Replies

Payroll

213 topics
702 Replies

Low Code | No Code Customizations or Integrations

219 topics
793 Replies

Develop Customizations

2362 topics
9598 Replies

Develop Integrations with Web Services | APIs

560 topics
2299 Replies

ISV Solutions

120 topics
488 Replies

Configuration and Installation

749 topics
2724 Replies

Reports and Generic Inquires

1725 topics
6715 Replies

Import and Export Scenarios

662 topics
2732 Replies

System Health and Performance

132 topics
478 Replies

Community site discussions

227 topics
420 Replies

Community Introductions

95 topics
281 Replies

Everything Else

712 topics
2358 Replies

News & Announcements

Acumatica News & Updates

110 topics
155 Replies

Events & Meet-ups

132 topics
83 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

Rmak0501Freshman I

Reports and Generic Inquires

Change field setting

1 hour ago

edsonvelez64Jr Varsity III

Community site discussions

How can I automatically reject new Cases submitted by a Contact who is not enabled as a Portal User?

We have a set number of Users who have permission to log into our Portal per client. In this example, let’s say we have Company X with User A, User B, and User C. Only these three Users can log into the Portal to submit tickets. They can also email our Support email address to submit a new Case. Unfortunately, this also means that anyone emailing our Support can submit tickets despite whether or not they are set up in the Portal. Does anyone have any suggestions on how to automatically reject Cases submitted by individuals who are not configured as Users? I’m sure we could create a Business Event but I’m not sure what conditions we would need. Any help is appreciated!

6 hours ago

jamestJr Varsity III

Reports and Generic Inquires

Power BI Connection

Hello all, Quick question. Can Power BI only connect to Generic Inquiries? Or is there a way to connect to the instance directly like you would a SQL Server connection? We’re on a cloud instance. Thanks!

7 hours ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Create new DAC and put data Using Rest API

Hi All, I need to create new DAC and dump data into new DAC using Rest API. I know how to code and put data but I am stuck in few questions like If I started new creating new DAC do i need to define new fields in that and save data accordingly and Also how can i access that DAC using API? is there any blog that can give similar idea.

7 hours ago

woodyg84Jr Varsity III

CRM

Incoming junk email could not get deleted

Showing “An invalid character was found in the mail header: ','.

8 hours ago

New to the community?

Get Started HERE and be sure toIntroduce Yourself

Acumatica User Groups

Educational Resources

Community Library

Blogs

What you may have missed in the Acumatica Community! March, 2024

User leaderboard

Show full leaderboard

Acumatica employee leaderboard

Show full leaderboard

Badge winners

AndreasKleinfeld72has earned the badge Manufacturing expert
leppleyhas earned the badge Easy talker

Show all badges

Acumatica Community

New to the community?

User leaderboard

Acumatica employee leaderboard

Badge winners

Events Calendar

Latest Articles

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded