Skip to main content
Question

Countries / States Active Checkbox

  • February 14, 2025
  • 3 replies
  • 37 views

Forum|alt.badge.img

We seem to have many States (State-CountryStates) within Countries (country-CountryID) that are setup incorrectly over the 7 years we’ve been on Acumatica/Merged in Data and this is causing issues now that we are using an External Tax Provider.

How do we get a request in for Acumatica to develop the ability to have an Active checkbox on these states so that we can deactivate them when they’re incorrect?

The best I can come up with right now, is marking them do no use because without being able to update all records where they’re referenced which are now complete/locked records via SQL I can’t remove them as they’re referenced in a record.

“State (IN, MUMBAI) cannot be deleted because it is referenced in the following record: Address (105882).”

 

Tagging some of my favorite people in case they can point me in the right direction ;) 

@Doug Johnson 

@Laura02 

 

 

 

3 replies

  • Acumatica Employee
  • 6 replies
  • February 18, 2025

Hello, Astra!

To help you identify the addresses that need to be updated, I created and attached a Generic Inquiry connecting each address with the Business Accounts (customer, vendor, employee, etc.).

Laura


Forum|alt.badge.img+12
  • Acumatica Support Team
  • 871 replies
  • February 18, 2025

Hi ​@astramathis30 

Are those states been used on any Transaction linked Customer/ Business account profiles? If they are sitting on bunch of Customer/Vendor/Business accounts, which have not been used, then you may contact support and check with our Data services team if they can delete those states. Support can arrange for a quote from services team if its doable.

Regards,


Forum|alt.badge.img
  • Author
  • Freshman I
  • 28 replies
  • February 21, 2025

Hi ​@vkumar - thank you for your reply. Laura’s GI worked great and was similar I had in place with my own GI but just better. Using her GI I was able to remove the incorrect states from the Business Accounts, but since those states are tied to Sales Orders (which can be reopened and edited) and Invoices (which I don’t think can be reopened to be edited) we still can’t delete them, this is why I’m wondering if we can have an Active checkbox on these records like there are active checkboxes in many other screens. Should this be something we customize or something we can request from Acu?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings