New in Acumatica 2018 R2: Using Attributes as User Defined Fields (No Programming Required!)

Acumatica Attributes

In a previous blog, we discussed how to add custom data fields to a form and also discussed the advantages and limitations of Attributes.

Prior to the Acumatica 2018 R2 update, Attributes were only available for Customer Management (e.g. Leads, Contacts, Cases, Opportunities, Business Accounts, and Marketing Campaigns), Inventory Items, Projects, Employees, Vendors, and Customers.

In the latest 2018 R2 release, Acumatica has unlocked the full potential of Attributes by providing a mechanism to use them as User Defined Fields in a vastly expanded list of forms. The current list is included below in an Appendix.

User Defined Fields can be added directly to their corresponding data-entry forms. This is useful for multiple documents for which the standard Attributes functionality is not available. The original information of a record is displayed on the Document tab and the added fields are displayed on the User Defined Fields tab.

How-to Set It Up:

In this example, we will add a User Defined Field to the Sales Orders screen (SO301000).

  1. Add an Attribute in the Attributes screen (CS205000)
    Acumatica R2
  1. Open the Sales Orders screen (SO301000) and click “Manage User Defined Fields” form the Customization menu.
    Acumatica R2
  1. Click “Add User Defined Field”
    Acumatica R2
  1. Select the desired Attribute, set the Column and Row, and click OK.
    Acumatica R2
  1. Acumatica will add the Attribute as a User Defined Field
  1. Exit the screen to go back to the Sales Order screen where there is a new tab at the top named USER DEFINED FIELDS
    Acumatica R2
  1. The Attribute is now part of the Sales Order header.
    Acumatica R2

 

The value will be saved with each Sales Order and it’s now part of the SOHeader DAC, which means that you can use it in generic inquiries and reports.

That’s all it takes to take your forms to the next level for tracking transactional data in a way that it wasn’t available for non-programmers. This new capability is one more reason why Acumatica has just been awarded with top ratings in Usability.

_____________________________________________________________________

Appendix: Current list of forms that support User Defined Fields

Time and Expenses

  • Expense Receipt (EP301020)
  • Expense Claim (EP301000)
  • Employee Time Card (EP305000)
  • Equipment Time Card (EP308000)

General Ledger

  • Journal Transactions (GL301000)
  • Journal Vouchers (GL304000)
  • Budgets (GL302010)
  • Trial Balance (GL303010)
  • Master Financial Calendar (GL201000)
  • Allocations (GL204500)
  • Recurring Transactions (GL203500)

Cash Management

  • Transactions (CA304000)
  • Funds Transfers (CA301000)
  • Bank Deposits (CA305000)
  • Import Bank Transactions (CA306500)
  • Reconciliation Statements (CA302000)
  • Anticipated Cash Transactions (CA305500)
  • Cash Accounts (CA202000)

Accounts Payable

  • Bills and Adjustments (AP301000)
  • Checks and Payments (AP302000)
  • Quick Checks (AP304000)
  • Batch Payments (AP305000)
  • Vendor Price Worksheets (AP202010)
  • Vendor Locations (AP303010)
  • Recurring Transactions (AP203500)
  • Vendor Discounts (AP205000)

Accounts Receivable

  • Invoices and Memos (AR301000)
  • Payments and Applications (AR302000)
  • Cash Sales (AR304000)
  • Sales Price Worksheets (AR202010)
  • Customer Locations (AR303020)
  • Customer Payment Methods (AR303010)
  • Recurring Transactions (AR203500)
  • Discounts (AR209500)

Fixed Assets

  • Fixed Asset Transactions (FA301000)
  • Fixed Assets (FA303000)

Taxes

  • Tax Bills and Adjustments (TX303000)
  • Tax Adjustments (TX301000)
  • Tax Periods (TX207000)
  • Tax Zones (TX206000)
  • Tax Categories (TX205500)
  • Taxes (TX205000)

Currency Management and Deferred Revenue

  • Translation Worksheets (CM304000)
  • Currency Rates (CM301000)
  • Deferral Schedules (DR201510)

Inventory Management

  • Receipts (IN301000)
  • Issues (IN302000)
  • Kit Assembly (IN307000)
  • Transfers (IN304000)
  • Adjustments (IN303000)
  • Physical Inventory Review (IN305000)
  • Item Warehouse Details (IN204500)
  • Kit Specifications (IN209500)

Order Management

  • Sales Orders (SO301000)
  • Shipments (SO302000)
  • Invoices (SO303000)
  • Purchase Orders (PO301000)
  • Purchase Receipts (PO302000)
  • Requests (RQ301000)
  • Bidding Responses (RQ303000)
  • Requisitions (RQ302000)

Contact us at support@crestwood.com for further questions.

Leave a Reply