AGR0114 - Formulas

Currently, the main feature of the screen is to register some formulas that can later be used in the Payments module, specifically on the Contracts (PAG0199) screen, Schedulings tab.

1. Access the menu Agricultural > Monitoring > Formulas (AGR0114);
2. Fill in the fields:
   • Monitoring Form : mandatory field, while the “Use the Formula unlinked from the Monitoring Form” checkbox, in the same registration, is disabled. When informed, the system links the registered formula with the appropriate Monitoring Form. The information in this field comes from the - Ficha de Monitoramento (AGR0109) screen;
   • Code : mandatory field. Refers to the code of the registered record;
   • Description :mandatory field. Refers to the description of the registered record;
   • Abbreviation: mandatory field. Refers to the abbreviation of the registered record;
   • Return Type:mandatory field. Informs whether the result of the calculation generated through the formula should be displayed in Number or Text format;
   • Decimal places:mandatory field. Informs the number of decimal places that the result of the calculation performed through the appropriate formula should have;
   • Use maximum precision in calculations: selection field that is disabled by default. When active, the system starts to consider the highest precision in rounding the results obtained through the appropriate formula;
   • Use the Formula unlinked from the Monitoring Form:checkbox that is disabled by default. When active, the Monitoring Form field, in the same registration, becomes optional.
3. Fields for creating the Formula:
   • Form Fields, Form by Point, Category Items and Work Log Variables: fields presented through expansion section, which reference the information registered in the appropriate Monitoring Form informed at the beginning of the registration. When selected, the system displays a field “card” in the formulas registration. When they are logged fields, it is possible to create some conditions, for example, search for the sum or average of the logged information, to consider them in the formula.
   • Formula Fields : in this field, through the conditions and signs that the system displays, it is possible to assemble the necessary formula. Using the mouse “double click”, or the “drag” feature of items into the formula grid, it is possible to assemble the registration. In addition to the signs used in mathematics, such as addition, subtraction, multiplication, greater than , and less than, the system has some conditions to be used (If, Is null, Round). From the “Number” or “Text” fields it is possible to define constants or identifiers to be verified.