English
Español
AGR0085 - Valuation Table
The Valuation Table screen is where the values used in various system scenarios are registered, especially in the Payments and Labor modules. These values are applied in different processes, such as in calculation routines, price formation, valuation of third-party services and transport work logs.
From the tables and their respective valuation ranges registered on this screen, the system retrieves the necessary values for the valuation of the movements and operations executed in the various work log and calculation processes.
Important
- The Formação de Preços (AGR0227) screen will use this registration to perform a price formation that will be used on the Apontamento de Produção (AGR0087) screen, resulting in the valuation of a service provided.
- This registration will also be used on the Executar Rotinas (AGR0226), Executar Cálculos (PAG0226), Executar Cálculos (PAG0002) and Executar Cálculos (PAG0371) screens, whose linking mechanisms are described on the respective screens.
What can you do?
Register Valuation Table
- Access the menu Agricultural > Labor > Valuation Table (AGR0085);
- Click on Add ;
- Initially the screen header has standard system entities as described below:
- Production Unit : mandatory field, automatically filled according to the production unit selected in the production units registration;
- Code : mandatory field that will be filled manually according to the user’s standard;
- Description : mandatory field that will be filled manually according to the user’s standard;
- Start Date : mandatory and informative field, filled with the start date of the table’s validity;
- Group : optional field that will be used on some screens of the payments and labor module to group the routines and calculations, aiming to facilitate their location;
- Event for Payment / Discount : optional field that retrieves the information registered on the eventos (AGR0231) screen, referencing the event that will be executed in the calculation.
- After the header, some sections will be presented to specify the valuation table definitions;
- Taxes/Fees: if the value refers to taxes or association fees, one or more options in this section need to be active:
- Deduct from Total Value : used to indicate that the table value must be deducted from the total value of a calculation, such as Invoice calculations;
- Represents a Tax/Fee: used to indicate that the table is a tax and must be displayed for consultation on the PAG0197 - Grupo de Impostos screen, therefore it works as a grouper, so that on the PAG0197 - Grupo de Impostos screen it concentrates all the valuation tables that have this field active;
- Represents an Association Fee : used when the client makes payment of fees to some association of which they are a member, when active these values are visible in reports and used in specific association calculation routines;
- Value per Ton : when active it will identify that this value must be used in invoice and contract calculations, multiplying the value by the ton.
- Options: this second section presents three different types of settings, in addition to the default setting. It will only be possible to choose one of the options and each one of them changes the filling of the Valuation Range grid. When none is active, there is already a default valuation table grid.
- Configure Value Range ;
- Payment Condition ;
- Formula ;
- Valuation Range: third option that represents a quantity range that will be used in the valuation. For example mileage ranges, it is possible to register mileage ranges and each range will represent a value to be paid;
- Taxes/Fees: if the value refers to taxes or association fees, one or more options in this section need to be active:
- Click on Save.
Register Valuation Range (default layout)
- If none of the Options checkboxes is active, the grid remains with the default setting, which has the following fields:
- Project : mandatory field that retrieves the information registered on the projects screen, AGR0013, for filling;
- Period : mandatory field that retrieves the information registered on the periods screen, AGR0014, for filling;
- Description : mandatory field that will be filled manually according to the user’s standard;
- Start Date : mandatory field that must be filled with the start date of this range’s validity. This date will be validated in the calculation routines;
- Minimum Quantity : mandatory numeric field that will be filled manually according to the minimum quantity to be considered in the calculation;
- Minimum Quantity : mandatory numeric field that will be filled manually according to the maximum quantity to be considered in the calculation;
- Value : mandatory field, determines the value to be considered for the given range and validity;
- Auxiliary Value ;
- Valuation Table : optional and complementary field, used in specific scenarios of the Third-Party payment process.
Register Value Range
- If the Configure Value Range checkbox is activated, the purpose of this selection field is to register a range within the range, because there are calculations that need to have value ranges within the range. Therefore it is necessary to fill in the fields:
- Project : mandatory field that retrieves the information registered on the projects screen, AGR0013, for filling;
- Period : mandatory field that retrieves the information registered on the periods screen, AGR0014, for filling;
- Description : mandatory field that will be filled manually according to the user’s standard;
- Start Date : mandatory field that will be filled with the date of the start of the validity that this range will have, it is this date that will be validated in the calculation routines;
- Minimum Quantity : mandatory numeric field that will be filled manually according to the minimum quantity to be considered in the calculation;
- Maximum Quantity : mandatory numeric field that will be filled manually according to the maximum quantity to be considered in the calculation;
- Minimum Value : mandatory numeric field that will be filled manually according to the minimum value of the value range, it must be a value between the maximum and minimum quantity;
- Maximum Value : optional numeric field that will be filled manually according to the maximum value of the value range, it must be a value between the maximum and minimum quantity;
- Auxiliary Value : optional and complementary field, used in specific scenarios of the Third-Party payment process, where a complementary value is determined for the range or even a substitute according to the payment rule used;
- Valuation Table : optional field that retrieves the information registered on the valuation table screen, AGR0085, for filling.
Register Payment Condition
- If the Payment Condition selection field is activated it has these fields for filling:
- Description : mandatory field that will be filled manually according to the user’s standard;
- Routine : mandatory field that retrieves the information registered on the calculations screen, AGR0220, for filling;
- Month : mandatory field and it is possible to fill with any month of the year from a predefined system list;
- Flag Cash Installment : defines the payment of the movement at the time of processing, therefore without the need to inform the Due Day/Month;
- Due Day/Month : mandatory field and it is possible to fill with any day and month of the year;
- Event : mandatory field that retrieves the information registered on the events screen, AGR0231;
- Value : mandatory field, determines the value to be considered for the given range and condition.
Register Formula
- If the Formula selection field is activated, it has these fields for filling:
- Event: mandatory field that retrieves the information registered on the events screen, AGR0231;
- Formula : dynamic field, allows the user to configure mathematical formulas, based on system variables. This functionality was considered in a specific process of the Payments module;
- Specific Grouping : optional registrations, which were used in a specific process of the Payments module. They allowed specifying some specific entities related to the Valuation Table;
- Harvest Type : non-mandatory field and it is possible to fill in according to the standard that the system presents, it can be mechanized or manual;
- Characteristic : field that retrieves the system’s standard enumerator, with the possibility Raw or Burned, referring to the characteristic of the harvested sugarcane;
- Add Owner: optional field that retrieves the information registered on the proprietário (ADM0007) screen;
- Add Rural Property : optional field that retrieves the information registered on the propriedade rural (AGR0017) screen;
- Add Operation : optional field that retrieves the information registered on the operation screen, árvore de processo (ADM0043).
English
Español
