Acumatica: How to Make a Field Required
acumatica make field required
Also searched as
- acumatica required field customization
- acumatica software pros and cons
- acumatica locations warehouse
- acumatica make field mandatory
Short answer
In Acumatica you make a field required with a customization project: use workflow field states for conditional rules, mark an attribute as required for item or customer classes, or use a DAC extension in code for an always-required field. Choose the least invasive route, test in a copy of the tenant, and publish the project.
Applies to: Acumatica Cloud ERP 2022 R2 and later, including MYOB Advanced in markets where it is sold; screens vary by edition
Make a field required
- 1Decide if the rule is always or conditional. Conditional rules, such as required only when status is On Hold, suit workflow.
- 2Open a test tenant and a customization project (System > Customization > Manage Customization Projects) and create or open your project.
- 3For a screen workflow rule, edit the workflow for the screen and set the field's state to Required for the relevant state or condition.
- 4For class-driven data, use attributes and mark the attribute as required for the item class, customer class or other class that uses it.
- 5For an always-required field, a developer adds a DAC extension that applies a required UI setting and a persisting check, then publishes the project.
- 6Publish, and test creating and saving the record as a user in the target role, including via import scenarios and the API.
- 7Document the rule and keep the project in source control.
Choosing the method
Workflow is best when the requirement depends on state, because it changes with the document and needs no code. Attributes work well for descriptive data tied to a class, and they are configured by administrators.
A DAC extension is the most direct way to make a field always required, but it needs a developer and follows the code upgrade path. A required indicator on the screen alone is not enough: if the rule must also hold for imports and the API, enforce it at the data level, not just in the UI.
Acumatica pros and cons for manufacturers
Strengths commonly cited: cloud or private-cloud deployment, a single database across modules, an open customization platform and a REST API, and a licence model based on resource usage rather than named users. Manufacturing is available as a separate edition, so confirm the capabilities you need before purchase.
Weaknesses to weigh: manufacturing depth is narrower than long-established discrete ERPs for complex routing, advanced planning and regulated industries, and heavy customization needs an implementation partner. Fully on-prem hosting is less typical than cloud, so check what deployment options your agreement supports.
Locations
People searching for Acumatica locations usually mean warehouse locations (bins) inside a warehouse, set up in Inventory configuration, which are different from company branches. Enable location tracking at the warehouse and item level before you rely on bin-level stock.
Decide early whether you need bin tracking: it improves accuracy but adds transaction steps for receiving, moves and issues.
Try it here, free
Acumatica Data Migration Field Mapping Worksheet
Map each legacy field to its Acumatica screen and field, record the transform rule and owner, and track cleansing status. Exports to Excel.
Common pitfalls
- !Making a field required in the UI only and finding imports and API calls still save blank values.
- !Testing as an administrator only.
- !Customizing in production without a test tenant.
- !Conflicting projects that override each other.
- !Enabling bin tracking without training receiving staff.
How an ERP-grounded AI assistant handles this
Before enforcing a new required field, an ERPray-style assistant can query existing records to show how many currently have the field blank, so you can clean data first. It reads through the Acumatica API or database with the user's roles, and is read-only by default. For private deployments, the model can run on your own servers, though Acumatica itself is usually hosted by Acumatica or a partner.
Frequently asked questions
How do I make a field mandatory on an Acumatica screen?
Use workflow field states for conditional rules, a required attribute for class-based data, or a developer-built DAC extension for an always-required field. Then publish the customization project and test as a normal user, not an administrator.
Will a required field apply to imports and the API?
Only if it is enforced at the data level. A purely visual required marker applies to the screen. A persisting check in a DAC extension also applies to import scenarios and the API, so choose by where the rule must hold.
What are Acumatica's pros and cons?
Pros include a modern cloud platform, open API and flexible licensing. Cons can include narrower manufacturing depth for complex or regulated environments and reliance on partners for deeper customization. Test your own scenarios in a trial before deciding.
What are locations in Acumatica?
Usually warehouse locations, meaning bins inside a warehouse, configured in the inventory setup. They are different from branches or companies. Enable location tracking deliberately because it adds steps to receipts, moves and issues.
Related
How to Add a Custom Field to the Sales Order Screen in Acumatica
There are two routes. For simple data capture use Attributes (Configuration > Common Settings > Attributes), assigned to a class, which show up without code. For a real database column with logic, create a DAC extension (PXCacheExtension on SOOrder) in a Customization Project, add the field to the screen layout in the Screen Editor, and publish.
Error fixAcumatica Customization Project Publish Failed: How to Fix It
A failed publish in Acumatica means the platform could not validate, compile or apply the customization package to the website and database. Open the Publish Customization Project dialog, read the Compilation log and the Validation log, fix the first error (usually a C# compile error, a missing DAC field or a conflicting project), and publish again, ideally on a test tenant first.
How-toHow to Create an Import Scenario in Acumatica
Import scenarios in Acumatica live under System Integration > Import Scenarios: you pick a source (a file or a Generic Inquiry), map each source field to a target DAC field on the destination screen, then run or schedule the scenario. A small sample file run through the wizard first makes the field mapping step far faster than mapping blind.
Error fixAcumatica REST API 401 Unauthorized and API Login Limit: How to Fix
A 401 from the Acumatica contract-based REST API usually means the login call failed or the session cookie was not sent back, and an API login limit error means too many API sessions are open for your license. Post to /entity/auth/login with name, password and company, reuse the cookie, and always call /entity/auth/logout when done. For integrations, prefer OAuth 2.0 through a Connected Application.
How-toHow to Create a Generic Inquiry in Acumatica
Generic Inquiries (GI) are Acumatica's no-code query builder for joining tables, adding filters, and exposing the result as an inquiry screen, dashboard data source, or API endpoint. Open System > Customization > Generic Inquiry, add your base table, define joins and conditions, then run and save. No SQL or customization project is required.
Error fixFix Odoo AccessError: You Are Not Allowed to Access Records
Odoo raises AccessError when a user's security groups do not grant a CRUD right on a model through ir.model.access.csv, or when an ir.rule record rule filters the specific record out for that user or company. Fix it by adding the user to the group named in the error, editing the model's access rights, or reviewing the record rule's domain under Settings > Technical > Security.
AI for ERPAI for Acumatica Manufacturing Edition, Built on Your Own Data
Add AI to Acumatica Manufacturing Edition without giving up control of your shop and cost data. Private LLMs and agents grounded in your Acumatica instance.
AI for ERPAI Agents for ERP, Running On-Prem
A practical guide to on-prem AI agents for ERP: what they can safely automate, where human approval belongs, and how to design the guardrails.
AI for ERPNatural Language Query for ERP Data: Ask SAP, Infor, or Oracle a Question in Plain English
See how natural language query over SAP, Infor, Oracle, and NetSuite data works: grounded text-to-SQL, role-based permissions, and a visible audit trail.
Stuck on Acumatica Cloud ERP?
Talk to engineers who work inside Acumatica Cloud ERP every week, and who build private AI that answers these questions from your own ERP data.
Keep exploring
Free tools
- Acumatica Data Migration Field Mapping WorksheetMap each legacy field to its Acumatica screen and field, record the transform rule and owner, and track cleansing status. Exports to Excel.
- Acumatica Go-Live Cutover Checklist for ManufacturersA cutover checklist covering data, inventory, open orders, security, integrations and rollback before and after an Acumatica go-live.
- Acumatica Implementation Statement of Work TemplateA fill-in SOW outline for an Acumatica project with scope, phases, deliverables, assumptions, customer responsibilities and approvals.
ERP fixes and how-tos
- How to Add a Custom Field to the Sales Order Screen in AcumaticaAdd a custom field to the Acumatica Sales Orders screen two ways: no-code Attributes or a DAC extension with the Customization Project Editor. Steps and pitfalls.
- How to Create an Import Scenario in AcumaticaBuild an Acumatica import scenario step by step: map CSV fields to DAC targets, test with a sample file, and schedule recurring imports safely.
- Acumatica Customization Project Publish Failed: How to Fix ItAcumatica customization publish failing? Read the Compilation and Validation logs, fix DAC or BLC conflicts, clear locks, and republish safely. Steps and causes.
AI on your ERP
- AI for Acumatica Manufacturing Edition, Built on Your Own DataAdd AI to Acumatica Manufacturing Edition without giving up control of your shop and cost data. Private LLMs and agents grounded in your Acumatica instance.
- AI for Acumatica Inventory and Purchasing: Stock, Reorder and Vendor Questions AnsweredAI for Acumatica inventory and purchasing: reorder risk, receipts, vendor lead times and stock questions answered in plain English via the REST API, read-only.
Integrations
- How to use Claude with AcumaticaUse Claude with Acumatica through MCP connectors, the Anthropic API, AWS Bedrock or Vertex AI, plus the on-prem alternative when data must stay inside.
- How to add AI agents to AcumaticaHow to build AI agents on Acumatica: a tool layer over the contract-based REST API and Generic Inquiries, approval before writes, cloud or on-prem models.
Software
- AcumaticaWhat Acumatica is, how its manufacturing, distribution and financial modules work, how its REST API integrates, and which ERP alternatives to compare.
- Oracle NetSuiteOracle NetSuite explained for manufacturers: modules, SuiteScript, SuiteTalk and SuiteQL, cloud deployment, limits, alternatives and where AI helps.