Discussions, Best Practices, and Product Feedback

Recently active
Forums
Help others

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

13 minutes 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?

14 minutes ago

wxbrianJr Varsity II

Reports and Generic Inquires

Editing or Saving As Pivot redirecting to home page

Hey Everyone, We have recently started to have issues while trying to edit a pivot table from within the GI or Save as New Pivot table. Both options take me to Acumatica’s home page. We have multiple tenants and it works on other tenants except for one. I have admin access and have tried it on other computers, browsers, with other users…I ran out of ideas. Both options above take me to the screen below.The trace doesn’t give me any errors. Have anyone gone through this before?

17 minutes ago

claudematherne24Freshman I

Reports and Generic Inquires

Can I change the default reference of the Report Designer to use a specific verisonin the Preview state

Scenario: I am working on a Invoice Report, and need to make some changes to how the report calculates discounts. While in report designer, when I click on Preview, the verison of the report is one that doesn’t reflect what I am trying to work on. Meaning the Invoice in quesiton does not have any discounts to update, so I cannot see if my changes are working as expected. I have just been saving to the server, and checking there. But is there a way to tell Report Designer what data I want it to pull?

18 minutes ago

kkeating24Freshman I

Retail

Shoppify Mappings COO / Last Cost / Pricing

Hello @simonliang91 @KarthikGajendran et al. I was looking through the mappings and wanted to see if we have any updates to the following:https://help.acumatica.com/(W(11))/Help?ScreenId=ShowWiki&pageid=5ecd0d16-a869-4ccb-bf09-7ffb05f25a4e& For Shopify integrations I have the need to map:Country Of Origin - I don’t see this as a field value that is mappable in the entity screen and it is not mapped out of the box. Last Cost vs. Current Cost - i know there are couple threads out there (one that I started) but it seems the customization focuses on Matrix Items. It would be nice if we had the option to choose which one, as I have an example where the valuation is FIFO and it is not pulling last cost. It is pulling the current cost (from Standard Cost) so this is effectively 0 in our scenario. Pricing - a general question - does the mapping consider sales pricing at all? either promotional or worksheet based (non b2b)?Cheers,k2

18 minutes ago

dguildFreshman I

Import and Export Scenarios

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?

32 minutes ago

jwarrenVarsity I

Reports and Generic Inquires

dsimmerlySemi-Pro II

Financials

Fixed Assets Annual Depreciation

We have a client who needs to depreciate their assets (Land/Property) for a FULL year at a time every year. So they may have some assets that depreciate over 5, 10 or 50 years, but they only want the full amount of depreciation for the year on the last day, NOT monthly.We thought we could define a depreciation method for the year, but then it wants to depreciate the first full year on the day you enter it and then the next year it will still calculate monthly.They could do this in their old system, so perhaps I’m just missing something?How can I define the depreciation method for them accurately and have it only post annually on the last day of the year?

49 minutes ago

Discussion Forums

Get inspired and gain all the knowledge you need

Financials

1773 topics
5835 Replies

Distribution

1717 topics
6579 Replies

Manufacturing

603 topics
2271 Replies

Construction

581 topics
1947 Replies

CRM

161 topics
482 Replies

Field Service

284 topics
930 Replies

Retail

454 topics
2006 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
2393 Replies

ISV Solutions

120 topics
494 Replies

Configuration and Installation

762 topics
2783 Replies

Reports and Generic Inquires

1760 topics
6806 Replies

Import and Export Scenarios

681 topics
2787 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

dmerrillFreshman I

Distribution

How to Handle Overstock Locations

13 minutes ago

claudematherne24Freshman I

Manufacturing

Update standard cost is overriding Warehouse Item Details

14 minutes ago

wxbrianJr Varsity II

Reports and Generic Inquires

Editing or Saving As Pivot redirecting to home page

17 minutes ago

claudematherne24Freshman I

Reports and Generic Inquires

Can I change the default reference of the Report Designer to use a specific verisonin the Preview state

18 minutes ago

kkeating24Freshman I

Retail

Shoppify Mappings COO / Last Cost / Pricing

18 minutes ago

kyrenmearr

Import and Export Scenarios

Mapping Customer Organization (Acumatica) Attribute to Shopify Customer Tag

35 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:

41 minutes ago

dsimmerlySemi-Pro II

Financials

Fixed Assets Annual Depreciation

49 minutes 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?

2 hours 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?

2 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