Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

dguildFreshman I

Change ID Import Scenario off by one line item

I’m trying to change all of my Non-Stock Item Inventory ID Numbers to have “NS-” in front of them. When I run my Import Scenario the first inventory Item does not get changed at all. The second inventory item gets renamed with the New Inventory ID I had for the FIRST item. All subsequent items get similarly renamed with the next Inventory ID in the Data Provider - all off by one record. Any ideas?

5 minutes ago

ashleybJr Varsity III

Import and Export Scenarios

Remove Hold in Mass on Import Scenario

Hello - I am just trying to create an import scenario to remove the hold from AP bills in mass. Below is my import scenario that I cannot get to work. Can someone tell me if I am doing something wrong?

9 minutes ago

jwarrenVarsity I

Reports and Generic Inquires

Help with Business Event

I have set up a business event to perform the following:Auto mark items on the Prod Detail as Backflush On or Backflush Off based on an Attribute at the stock item level. Triggered by a Production Attribute (Attribute ID = PURCHVER) being checked off.My issue is that the Business Event only runs when there is one single item on the Prod Detail (and on GI), for some reason the system is not recognizing the business event when there are multiple items on the GI. See below. Business Event - Triggered based on Record Inserted of GI below Generic Inquiry - List of Material on Prod Detail with Prod Attribute as TrueImport Scenario is simply set up to mark the lines as Backflush on or off which I can confirm is working fine. In the list above, AM003535 was recognized and processed without issue. But all other orders do not get recognized in Business Event History when I toggle between the attribute PURCHVER True and False. In theory, each time I mark the attribute as False it falls of the lis

34 minutes ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Invalid Client Access token using Resource owner Pass

I am trying to get the access token using attach code but it shows error of “Invalid Client”. Error: Connected Application:

1 hour ago

osutherinFreshman I

Financials

Bank Feeds in Test Environment

We have a test environment that we regularly copy data into from our live company. However, each time we do copy this data, it pulls over the bank feed connections and then creates a System Constraint error for exceeding the number of bank feeds allowed by our license. Ideally, we could just delete these bank feeds in the test environment but when I attempt to do that, I get the following error: The bank feed service (path: 0/plaid/item/remove) returned the following server error: BadRequest I have gone as far as deleting the feeds in the live database before copying it to the test environment, but the issue that this causes is reconnecting them in the live database- transactions start to get duplicated and it becomes a hassle when matching/processing bank transactions. Has anyone run into this issue and have a solution?

1 hour ago

daniellepazFreshman II

Financials

Adding User Field to Master Financial Calendar

I need to add a column to the grid of Master Financial Calendar.I managed to add it but it doesn’t update even if I save it. I checked the table FinPeriod in the database and confirmed that the value is not saved. I already created an Extension Class for both FinPeriod and MasterFinPeriod.namespace PX.Objects.GL.FinPeriods.TableDefinition{ // Acuminator disable once PX1016 ExtensionDoesNotDeclareIsActiveMethod extension should be constantly active public sealed class FinPeriodExt : PXCacheExtension<PX.Objects.GL.FinPeriods.TableDefinition.FinPeriod> { #region UsrIsFiscalYear [PXDBBool] [PXUIField(DisplayName = "Is Fiscal Year")] [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)] public bool? UsrIsFiscalYear { get; set; } public abstract class usrIsFiscalYear : PX.Data.BQL.BqlBool.Field<usrIsFiscalYear> { } #endregion #region UsrQuarter [PXDBInt()] [PXUIField(DisplayName = "Quarter"

1 hour ago

josbornFreshman I

Distribution

SO Completed Without All Items Shipping

Hello,I have a SO with 22 lines that all ship at different times. I have shipped Line 1, but once I did that Acumatica ‘Completed’ the SO. My intent was to leave the SO open until all items have shipped. My questions are:Why did it close the SO without shipping complete? Can I reopen this SO so I can get the ‘Create Shipment’ prompt again?Thanks!

1 hour ago

jsudakFreshman II

Import and Export Scenarios

How do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file??

How do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file?

1 hour ago

claudematherne24Freshman I

Manufacturing

Update standard cost is overriding Warehouse Item Details

I am having the following issue:I have a item that is manufactured with a BOM in one Warehouse, but purchased in another. At the item Warehouse Details for the item, in the Warehouse where we purchase the item, I have the replenishment set to Purchase, no BOM attached in Manufacturing tab, and override stand cost checked. I go in and update pending based on that Warehouse and everything works as expected. But then, when I go and update my BOM for that item, and process Cost Roll and Update Pending, the Warehouse Item Detail cost if overridden. This causes us to have to remember to go back and reupdate the cost at the Purchase Warehouse. Am I doing something incorrect, or just misunderstanding how the process should be working?

1 hour ago

Omar GhaziAcumatica Moderator

Acumatica News & Updates

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

149236

1 hour ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1773 topics
5834 Replies

Distribution

1717 topics
6577 Replies

Manufacturing

603 topics
2269 Replies

Construction

581 topics
1947 Replies

CRM

161 topics
482 Replies

Field Service

284 topics
930 Replies

Retail

454 topics
2005 Replies

Payroll

213 topics
719 Replies

Low Code | No Code Customizations or Integrations

224 topics
814 Replies

Develop Customizations

2397 topics
9683 Replies

Develop Integrations with Web Services | APIs

583 topics
2392 Replies

ISV Solutions

120 topics
494 Replies

Configuration and Installation

762 topics
2783 Replies

Reports and Generic Inquires

1758 topics
6805 Replies

Import and Export Scenarios

678 topics
2783 Replies

System Health and Performance

133 topics
482 Replies

Community site discussions

230 topics
433 Replies

Community Introductions

95 topics
281 Replies

Everything Else

722 topics
2387 Replies

News & Announcements

Acumatica News & Updates

110 topics
163 Replies

Events & Meet-ups

136 topics
85 Replies

Developer Newsletter

19 topics
0 Replies

43 topics
0 Replies

dguildFreshman I

Import and Export Scenarios

Change ID Import Scenario off by one line item

5 minutes ago

tahayabaliFreshman I

Develop Integrations with Web Services | APIs

Invalid Client Access token using Resource owner Pass

I am trying to get the access token using attach code but it shows error of “Invalid Client”. Error: Connected Application:

1 hour ago

osutherinFreshman I

Financials

Bank Feeds in Test Environment

1 hour ago

jsudakFreshman II

Import and Export Scenarios

How do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file??

How do I create an Import Scenario to add the customer's Credit Limit to their Financial Credit Verification Rules from a spreadsheet file?

1 hour ago

claudematherne24Freshman I

Manufacturing

Update standard cost is overriding Warehouse Item Details

1 hour ago

amitr70Freshman I

A data corruption state has been detected - SoLine.

While creating sales order and adding line items in so line i am encountering this error. Below is the screenshot of the error. I am not able to find out the actual cause of the error. Please help.Details : Name: Aggregate Validation: PX.Objects.SO.SOOrder+orderQty. Below is screenshot.We already upgraded within R2, both 206 and 209 but still issue remains there. Please help how to debug this issue as in my code there’s no exception throwing. Let me know if there’s any specific settings or locations to look out for.

2 hours ago

Eddier47Freshman I

Field Service

System Down Recovery Plan

Recently our Acumatica site was down for a full day of work. We are service based and have techs out in the field all day. With the site down we were unable to access appointments and eventually we had to send all techs home.This triggered us to realize we need a Disaster Recovery Plan. I wanted to see what others have done to make sure you can still function if your Acumatica site goes down?

2 hours ago

trenton78Freshman I

Distribution

Multiple Notes "Error" - Causes Notes to be Hidden

We recently came across an error when working in the Orders module. We have a Pop-Up note active for Customer A. When we create an SO order for Customer A, the Pop-Up note appears, passing along vital information. We also have a Pop-Up note configured for an Inventory ID - #5000.When Customer A is purchasing Inventory ID #5000, it attempts to pull up and show both Pop-Up notes simultaneously. This is giving an “error”, which keeps the user from viewing either note. Is there a way to have both notes show?The scenario more specifically this occurs with, is when you are converting a Quote to an SO using the “Copy Order” button.

2 hours ago

tinhtran

Financials

Duplicated Fixed Assets Purchases

Hello!We had credits in Fixed Asset Clearing and duplicated Fixed Assets for these credits. (Fixed Assets created in Feb 2024, and the credits posted to Fixed Asset Clearing in April 2024).How do we fix these errors?We were wondering if we should reverse the duplicated Fixed Assets to offset the credits in the Fixed Assets Clearing Account. We just want to make sure it happens in the current month, not affect the prior Financial months that we booked. Thank you so much for your help!

2 hours ago

dmerrillFreshman I

Distribution

How to Handle Overstock Locations

In our warehouse our lower shelves are Forward Pick locations and upper shelves are Reserve Stock. We keep a supply of all inventory in the Forward Pick locations but any overstock that won’t fit below will go to the Reserve Stock locations. Both location types have their respective inventory marked Include in Qty Available but only the Forward Pick locations are marked as Sales Allowed. This allows a sales order to be created regardless of inventory location but will prevent the Shipment/Picklist creation if doing so would direct a picker to a Reserve Stock location.This is where the pain point is introduced. We currently utilize the “Tasks” feature in Acumatica to direct our warehouse mobile users to transfer items from Reserve Stock to Forward Pick so that shipments containing affected items can be created.Ideally we would like a proper means of creating a Transfer Order which would direct a warehouse user to transfer the items between locations.I’m wondering if this is already an o

3 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

GlenMartin34has earned the badge Easy talker
vishalsharma49has 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