Entering Data - Fields and Buttons

This Wiki is read-only for reference purposes to avoid broken links.

⇐ Table of Contents{{#if: | | [[{{{2}}}]] }}{{#if: | | [[{{{3}}}]] }}{{#if: | | [[{{{4}}}]] }}{{#if: | | [[{{{5}}}]] }} | Entering Data - Fields and Buttons{{#if: Functionality| | Functionality }} ⇒

Each window that you open in ADempiere will likely provide you with the opportunity to enter data. This article describes the types of fields, buttons and controls that you will come across, the type of data that they will accept and how each of them functions. All the controls are listed below. The most common ones are String, Number, Date.

Several of the fields have helper functions, indicated by an icon/button at the right side of the field. The helper functions can be opened by clicking this icon. They may also open if the entered data is not clear or complete. The helper functions include the Calendar Tool, Calculator Tool, Search and Info windows (See the Functionality list, and others.

Account

The Account Element control displays the details of a selected Accounting Dimension or combination. (See Accounting Dimensions for more info.) It is usually found on Accounting tabs which provide accounting information related to the parent tab.

 

 

Data can be typed into the field as text. The data that is entered will be assessed as follows:

• If the text is null, zero length or equals "%", the Account Dialog will be opened.
• If the text does not end with a percent sign "%", one is added as the last character.
• The software then looks for a valid combination where the alias or the combination string match the text
• If there is a single match, the field is filled with the valid combination.
• If there is no match or more than one match, the Account Dialog is opened.

The Account Button () can also be pressed to activate the Account Dialog. A combination selected in the Account Dialog will be displayed once the dialog is confirmed and closed. If the Account Dialog is canceled, the Account field will be cleared.

(Software: client/src org.compiere.grid.ed.VAccount.java)

Amount

Amounts are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Amount fields are typically used for monetary values. See Number for more information.

Assignment

Resource Assignment

Binary

Binary Data

Button

Command Button - starts a process

Color

Color element

Costs+Prices

Costs + Prices are numeric fields with a minimum precision of 2 decimal places and a maximum of 12. Costs + Prices fields are typically used for monetary values. See Number for more information.

Date

Date mm/dd/yyyy

Date+Time

Date with time

FileName

Local File

FilePath

Local File Path

ID

10 Digit Identifier

Image

Binary Image Data

Integer

The Integer field is a numeric field with no fractional part and a maximum of 10 digits. See Number for more information.

List

Reference List

Location (Address)

Location/Address

Locator (WH)

Warehouse Locator Data type

Memo

Large Text Editor - Character String up to 2000 characters

Number

Number fields provide a way to enter and display numeric values. There are several types:

• Amounts
• Costs + Prices
• Integers and
• Quantities

The default number field has a maximum of 28 digits in the integer part and 12 digits in the fractional part. The default presentation is as a float number with one digit after the decimal. The number of digits in the presentation varies with the type of field.

All the numeric fields use the Calculator Tool as the helper function. To access the Calculator, click on the Calculator icon ().

The presentation of the field for all the numeric fields can be overridden by defining a number format in the {{#if: |{{{3}}}|Column }} Tab of the {{#if: Table and Column|Table and Column|TableandColumn }} Window.

Product Attribute

Product Attribute

Quantity

The Quantity field is a numeric field with a maximum of 12 digits in the fractional part and 28 digits in the integer part. See Number for more information.

RowID

Row ID Data Type

Search

Search Field

String

Character String

Table

Table List

Table Direct

Direct Table Access

Text

Character String up to 2000 characters

Text Long

Text (Long) - Text > 2000 characters

Time

Time

URL

URL

Yes-No

CheckBox