Configuration and Installation

I’m trying to set up a one step reviewer.  A/P Clerk creates the bill and I approve it.  But they are still able to release the Bills on their own and I don’t know what I'm missing.    

Hi All, I have 2 questions:1:what is the best way to hide an option in a Bill type? removing a debit adj  2: What is the best way to hide a tab from a screen/ Form

I have been roped in to helping configure a current cloud install of Acumatica, and frankly, I’m out of my depth. I have a technical background, but have not used or configured any similar software.I thought that a good approach would be to start with a local installation on my Windows 10 Machine. I use it for video editing, so it’s quite well equipped. That would allow me to play with the company's data set safely in a sandbox. It would also allow me to work my way through Acumatica training guides (A150 looks like a good one to start with).My first question concerns which version of Acumatica to install. The company is using 2021 R2 (Build 21.210.0030), and the A150 lesson seems to need 2022 R1. Do I need to install both versions (one to run A150 lessons, and one to play with the company’s data set)?I decided to start with the download of ERP 2021 R2 Update 4 from the Acumatica site, but it seems to be an earlier version (21.204.0055) than the one we’re running in the cloud. I tried

Use case :User wants to delete an attribute, ‘Delete’ is greyed out on CS205000 screen User wants to know if the attribute was ever used on an Entity class or an Entity profileSteps to find required information:Here are the steps to find out if an attributeID was ever linked to an Entity class and also on what Entity profiles is this attribute used.To find Entity class profile linked to an attribute:When you select an attribute on an Entity class profile ( say an Item class or Customer class etc.) an entry gets added to CSAttributeGroup table  Create a GI and pull all records from CSAttributeGroup table, filter by AttributeID, you can find Entity classes with specific AttributeID.To find Entity profiles linked to an attribute:When user adds a value for an attribute on an Entity profile ( Say select a value for an attribute on a customer profile or an item profile), a line gets added to CSAnswers table Create a GI on CSAnswers table and set a filter based on AttributeID, you can find li

I’m struggling to add a new currency field to my SOLine DAC. ErrorsWhen setting the value on any of the SOLines, if the value is >=100, then I get this error.CustomizationHere’s how I added the custom fields: I created two fields, a UsrSalesRepUnitCost and a UsrCurySalesRepUnitCost, with the following attributes in each. The “Database Scripts” section in the customization project window indicates the both of the custom fields are using the `DECIMAL(8, 4)` datatype, which I would assume would allow values as high as 9999.9999. QuestionsWhy am I getting an error indicating that the value 150.0000 is too large? Have I properly configured the two custom fields to accurately work for representing currency? I couldn’t find any resources in the documentation about creating custom currency fields.

We have a web-hosted Acumatica instance (2021 R2).We use Tasks quite a bit, and we frequently set due dates and although we check the “Reminder” box and set a date, nothing happens. There’s no pop-up, no email, nothing. Essentially, the “Reminder” box is useless to us right now. Apart from setting up my own Business Event that will email people when triggered, I don’t understand how I can get the “Reminder” box to do anything? I found instructions to “Turn on Reminders” https://biofermenergy.acumatica.com/(W(1))/Help?CompanyID=BIOFerm+Energy&ScreenId=ShowWiki&pageid=667e2765-09c0-4800-a02d-0e225b8203e1, but these instructions seem to only work with locally-hosted setups of the ERP (hence the topic being underneath the tree of System Administration/Maintaining Acumatica ERP Locally).  I could not find equivalent setup instructions for web-hosted ERP… Can anyone help?

I have a client using Acumatica MFA with the option to only require a code on new or unknown devices only. It seems that Acumatica is requesting the code nearly every time even though they are logging in using the same computer.Has anyone experienced this of have any suggestions?We have tried changing browser settings to allow all cookies but still no luck.

Hi ,How can we reset all passwords at once.  Is it possible to reset all user passwords to a one passwords  at once? Thank you,Dulanjana

Hi All,Need help to figure out why the Automation Schedule are not working, we are not in lock out mode but still we are getting error as “Automation Schedule scenario has not been performed due to the database lockout”. Please help us.I think this is happening from yesterday after we published new customization package. Below are the steps we followed when doing package publish first put in lockout mode, then took snapshot then deleted the snapshot, then removed the lockout modethen again, when i was about to publish the package, i put in lockout mode again and published the package then removed from lockout mode

How Can we Identify a Purchase Order is linked via Mark for PO to a Sales Order? Is there any field or grid column indicating that relationship?

Has anyone found a way to set up a PO approval based on USD when the the PO’s can be in multiple currencies.  That is we need to have approval on PO over $20,000 USD regardless of the PO currency

I have DeviceHub configured successfully with printers, but when I add a usb scale it exceeds the API request limit all on its own after a minute or two. Seems like devicehub is updating the SMScale table with the scale weight, but then forgetting to log itself out after??Does anyone have any ideas? TY!! 

Hi All,I want to create inventory based on a company. I have 4 companies, i want 3 companies to share 1 list and 4th company to have a separate list, which should not be visible to the first 3.I don’t want to create user roles for it or restriction groups.Is there any other way i can achieve it?Thank you.

hi everybody,i set the “From” adress in our ShipmentConfirmationNotification to “versand@”, but it will always be overwritten by the user profile email settings of the automated sender, in this case “info@”.    Does anybody know how to avoid this? Thank you!!Best Regards, Benjamin

Is there an Acumatica method to merge two tenants into one which are currently in the same database?Client has multiple companies and multiple branches in two separate tenants, is it possible to merge the two tenants into one, if they share the same Chart of Accounts and same periods?   If not, Is there a script that can be run to bring the master records together with just the settings without transactions?

There is a default Physical Inventory reason code in Inventory Preferences. I have approximately 20 different Physical Inventory Types generated by Item Class. When you select “GENERATE PI”  in “Prepare Physical Count” it always pulls the default reason code from Inventory Preferences. I need a different reason code for each of the Item Class Inventory Types. Does anyone know if there is a way to set this up so you don’t have to change the default reason code every time before selecting “GENERATE PI” (in “Prepare Physical Count”) ?

HiLooking to figure out which REST API I can use to update/amend the substitution lists.The swagger.json at the top level isn’t showing me much helpI can subaccounts but not substitutionsIdeas?  

In the pre-setup instructions (Installation Guide/Preparing for Installing Acumatica ERP), it says to enable these IIS features. It should clarify that only ASP.NET 4.7 (or appropriate ASP.NET version for the installation) needs to be included. Not ASP.NET 3.5, which is usually an option in IIS setup (see below).  

I have taken a bunch of backups through the system over time for 2021R2. Now I want to upgrade to 2022 R1. My current version number of 2021 R2 is too high to be upgraded with 2022 R1. So I wanted to go back to a backup that was old enough to be supported by the 2022 R1 installer for upgrade.When I went to my list of backups, I noticed that almost all of them list the latest version of 2021 R2 as the version. However, that version didn’t come out until a few weeks ago, and most of the backups were from way before it came out.Can anyone explain (you will see there are a few backups in the list with a previous version….but not most of them)? How can backups taken before the latest version came out now have the latest version number?  

When I process an email activity Acumatica gives an error saying “Mail Processing Is turned Off”How do I fix this, I tried to enable that option from Email Preferences screen. But I couldn’t find that kind of option there😐 

Hi Team, I have some query on how to set the base currency in a tenant.Case 1 - We have a company in the United states, India, Europe. All have their own company currency i.e., Base currency - USD,INR,EUR. If I set the Company Currency for United states, the base currency is taken as USD. If I tried to create another company for India the same USD base currency field was freezed and automatically taking USD. As per the Document, base currency once set in the system will be applicable for all the companies in a tenant. In order to have multi base currency, then we should able the multi base currency option from Enable/Disable features. When we trying to enable it, system ask us to disable some features like Contract management, Payroll, Time management etc. But we do have payroll and time management in our business.Case 2 - In the above three companies, how we can perform the consolidation. My reporting company is in US, we are in need to provide the consolidated report in USD quarterly

We are testing multi-factor authentication with the Acumatica mobile app.   With Andriod, we receive the approval notice on the mobile device and can approve or deny access easily.   With iPhones, the user must re-enter a code each time they attempt to log in.   Have others found this difference between iPhone and Android?  Are there any settings or updates needed on iPhones so a code isn’t required for each log in?

I have removed some snap shots from our production instance and ran the “Optimize Database”  operation. However I am still seeing space being occupied by the snap shots. Has anyone else seen this? How can i keep up with the Whitespace usage and Acumatica.   

Hi.  We are in the initial phase of implementation and are considering changing our Project numbering scheme?  Does anyone have any good schemes that work for them?Thanks,Brent M. Tabor

S100 has the steps for deploying on localhost but didn’t find any on public/private cloud. Can anyone share guide/steps/manual.Thanks.