Custom Fields (upgraded)

custom fields
1. Introduction
Custom fields have proven to be very user-friendly among ERPAG users.
Customers were given the possibility to easily adapt to specific needs in an easy way.
At the end of 2019, we decided to raise that useful option to a higher level.
2. Setup
The setup is now specifically separated in the Administration section of ERPAG.
ERPAG custom fields
The list of documents where it is possible to add a custom field is already completed.
document list custom fields
By activating the document you are entering the preview, or, the option settings (in order to change the setting you have to enter the EDIT mode of the document – click on the EDIT button).
3. Document Header
It is currently possible to have up to 15 custom fields per document.
The custom field types are:
  • Inactive – As the name suggests, if checked, the field is excluded from the entry or view;
  • Free text – Free text entry;
  • List – When entering a document, one of the options from the list must be selected. Possible values are predefined in the List – Options column;
custom fields list option
  • Amount/Price – Numerical data entry. “Amount” is usually displayed with 2 decimal places, while the number of decimal places for “Price” is taken from the Localization setup;
  • Date/Date and time – Date entry or date and time entry.
The Default – Value column is a value that is automatically populated when a new document is added. While “Read Only” indicates that the data cannot be changed.
For example, we can name the custom field “Year”, enter “default value” to be “2020” and set it to read-only.
custom field read only
And now, upon creating a new customer, the custom field will automatically be populated with a value we defined.
custom field customer default value
While entering default – value for the types “Amount”, “Price”, “Date” and “Date and time” you have to enter them in the same format as your localization is set up.
For example. If your date format is Day – Month – Year you should enter (31/01/2020).
One small hidden option – if you enter “NOW” in the default – value for date values, the current date/time will be entered in the field.
custom field default value now
And the default value when a new customer is created:
customer custom field default value
4. Document items
Some documents, such as Sales Orders, have another custom field level – on the item level.
custom field item level
custom field item level
Number “1” indicates custom fields on the document header, while number “2” indicates custom fields on the item level.
5. Copy from field
Some data is recorded in the ERPAG according to the document system. For example, the entered Sales order remains in the database recorded as it was entered. If, for example, we change the name of the item it will not automatically change in the entered documents (the changes are not applied retroactively).
In order to optimize resources, basic data (SKU, Description, UOM, etc.) is recorded in the document. If additional information needs to be recorded, we can use custom filed with the option “Copy from field”.
In our example, we will copy the “shelf” setting from the item.
custom fields copy from field
We will enter the new custom field named “Item Shelf” in the document items and select “copy from field” to be “Item – Shelf”.
And as we enter the document, the value from the item setting will be automatically copied.
custom fields copy from
Note: If on the item we have custom fields in the selection menu for the “copy from field” option, those fields will be offered as well.
6. Work order
A work order is a little bit specific, and it has 4 types of custom fields.
work order custom fields
It has to have more types as each section can have different logic. For example, an output item has a need for additional info (color, size, finish, etc.) while the input items and work operations don’t. And vice versa.
2020. ERPAG Inc

Read More

Related Posts

ERPAG Change log 08-04-2023

ERPAG Change log 08-04-2023

It's the peak of the summer heat, but that doesn't stop us from improving ERPAG! Here is the list of our newest updates: You can now list the "Additional info" information as a column in your Manufacturing report: 2. Exploded view is now available in the multi-level...

read more
JSON / XML Designer

JSON / XML Designer

JSON/XML Designer in ERPAG is a visual tool that will allow users to transform data from the ERPAG database into JSON or XML format. This can be further used for future integration with API services. This tool provides a user-friendly interface where users can define...

read more
Change log 05/29/2023

Change log 05/29/2023

The biggest change we developed is Automatization and Customization. This change is a huge milestone for us, and we will publish individual instructions for using the new features in the upcoming period. This module is divided into individual wholes: JSON Designer -...

read more