AGR0220 - Calculations
The Calculations - AGR0220 registration screen is essential for using the Labor, payments (closing), third-party services, variable remuneration (RV), and Scheduled Calculations (CPG) modules.
Most calculations are registered as system defaults, however in specific scenarios, it may be necessary to register a new calculation, along with the development of a new routine for the modules described above.
Changes to calculation parameterization are usually performed during the system and module implementation process at the client. Normally, changes to the registrations do not occur frequently, as some changes can directly impact the processes and routines performed at the company.
The calculations displayed on this screen have standard codes and rules. For specific scenarios in which the standard calculation rules do not meet the client’s scenario, it may be possible to create rotinas de intervenção that meet the necessary specifications, and that reflect the same registered calculation.
What can you do?
- Access the menu Agricultural > Labor > Calculations (AGR220);
- Click on Add ;
- To perform the registration, you need to fill in the fields:
- Routine Group : mandatory field, has some standard values referring to the modules (Routine Execution screens) and groupings in which the calculation in question will be displayed and can be executed. The standard Groups are: Advances, Contract, CPG - Scheduled Calculations, Supplier Discount, Debt, Labor, Invoice, Others, Payments, Service Provision, Raw Material Quality and Third-Party Services;
- Code : mandatory field, allows alphanumeric values. It will be used in the execution screen codes to search for the routine referring to the calculation. Changing this field can directly affect routine execution;
- Description : mandatory field, you must enter the description of the calculation in question, which will be displayed on the routine execution screens;
- Execution Order : defines the execution order of routines from the respective execution screens. It aims to avoid errors in processing when the user selects more than one calculation for execution, where the “parent calculation”, whose values will be used in subsequent routines, has not yet been executed;
- Recording Entity : mandatory field, defines the standard system table in which the information, generated in routines and calculations, will be saved;
- Preferred Entities (Price Formation): non-mandatory field. It can be used in specific routines in which the price formation process is used, to return the valuation table to be considered in the process execution, for example the OS Work Log Import routine. When one or more values are entered in this field, they will be prioritized in the price formation search process. If these preferred entities are not found in the work log to be valued, the system performs the process verification without such entities to find the necessary formation.
- During calculation registration, the following selection fields can be activated according to the rules or situations you want to apply:
- Execute Calculation : activate the system so that the calculation execution screen is displayed. Execution will be allowed according to the screen defined in the registered routine group;
- Require Approval : activate the feature to require that the item and/or execution batch be approved on the Calculation Maintenance screen before being made available for integration. This setting works as a safety lock, preventing unchecked items from being incorrectly integrated into the ERP. When activating the feature, an optional field will also be enabled to define the transaction approval authority. This authority must be previously registered on the PAG0224 - Alçada de Aprovação screen and will be responsible for authorizing or rejecting the calculation batches displayed on the maintenance screens of the respective modules;
- Display in Maintenance : when active, the respective calculation and its respective batches generated through the execution screen, will be displayed on the calculation maintenance screen, allowing checks, approvals and integrations, according to the parameterization performed;
- Cascade Reversal : when active, the system allows and performs automatic ERP reversal of dependent routine batches, when a batch of an original (parent) routine is reversed or deleted;
- Consider in Invoice Value :used in specific scenarios. When active, the value generated through the routine/calculation in question will not be considered as a discount when generating the invoice, it will already be implicitly discounted from the total invoice value;
- Consider in Financial Statement : when active, for the specific calculation, some parameterized events will be considered in the financial statement displayed as a tab within the contratos.In this standard report, the system displays the contract balance according to the filtered period and processed routines, containing its debits and credits for the contract in question;
- Validate Reference Month : when active, the system starts to display on the routine execution screen, when the specific calculation is selected, a field to define the payment month, which has the values Current and Overdue. This will be validated according to the reference month in the execution period;
- Inform ATR Value : when active, on the routine execution screen, when the monthly invoice routine is checked, the system displays a field to add the current ATR value. This would be considered if it were informed at the time of the routine, otherwise, the system would follow the standard process. This parameter was created to meet a specific client scenario, currently not used;
- Allow Document Numbering : when active, when executing the routine, the system saves each processing item according to a “document” created in the process, which can later be checked through the calculation maintenance screen. It is worth noting that the functionality must be provided for in the code of the routine in question, otherwise, the document column will be null;
- Allow Integration : when active, on the calculation maintenance screen, the system starts to display the button that will allow sending the calculation processing batch to the ERP from a rotina de integração;
- Allow Editing : when active, the system allows the values generated in the events, present in the calculation processing, to be changed through the calculation maintenance screen;
- Allow Expected Calculation : for some specific routines of the payments module it is possible to generate a “pre-execution” of the calculation from a distinct parameterization in the parâmetros do contrato, in relation to the routine that will consume the actual data obtained from the contract in question. For this process, it is necessary that the selection box be active in the standard routine, in addition, it is necessary to register a calculation that the system will display the standard calculation, but it will be possible to define through an option whether the Expected or Actual calculation will be executed. Examples of possible calculations: Advance Installment - Valuation, Advance Adjustment - Harvest, Advance Adjustment - Periodic, Adjustment Invoice - Periodic;
- Import External Data : use this feature in specific scenarios, in which the import of data such as sugarcane entries does not occur from other system modules, but rather through a file with a previously defined format. This file will be validated and processed during execution, with the support of a layout configured in the Monitoring Form, linked to the respective calculation. When checking this option, on the routine execution screen, the system will display a new field to select the file that will serve as the source of the data to be imported;
- Layout : when the Import External Data selection field is active, this field will be released to insert the File Import type monitoring form, which contains the configuration in the standard format required to import the file through the routine execution screen.In this case, this field retrieves the information from the AGR0109 - Ficha de Monitoramento screen;
- Click on Save .
- On the ADM0088 - Parâmetros screen, Payments group, the following parameters are related to calculations registered through this screen:
- PayAverageCalculationFormula | Formula for Average Calculation: for specific client scenarios that use an intervention routine to perform the Daily Average calculation, it is possible to define a calculation rule from linking a Tabela de Valorização in this parameter. This valuation table must have the registration of the formulas that will be considered in the routine execution, to generate the respective values in the eventos in question.
- PayInfoCalcManualEntries | Inform the calculation on the Manual Entries screen: when active, on the Manual Entries screens (PAG0227 and PAG0491), the system starts to display a field from which it is possible to make an entry directly for the calculation routine in question. The calculations displayed vary according to the screen module. When the parameter is disabled, the Calculations field is not displayed on the respective screens, in this case, it is only possible to make the work log for the manual entries routine of each module.
Important
The calculations registered on this screen will be used in the Execution of Standard Routines of the Labor, Third-Party Services, Payments (Closing), Variable Remuneration (RV) and Scheduled Calculations (CPG) modules:
- AGR0226 - Executar Rotinas
- PAG0002 - Executar Rotinas
- PAG0226 - Executar Rotinas
- PAG0371 - Executar Rotinas
- PAG0431 - CPG - Executar Cálculos / Importações
After executing the calculations, it is possible to check the generated values through the respective screens:
- AGR0225 - Manutenção de Cálculos
- PAG0003 - Manutenção de Cálculos
- PAG0225 - Manutenção de Cálculos
- PAG0381 - Manutenção de Cálculos
- PAG0441 - CPG - Manutenção de Cálculos
For the Third-Party Services, Payments (Closing), Variable Compensation (RV) and Scheduled Calculations (CPG) modules, it is still possible to perform manual entries for calculations through the following screens:
- PAG0491 - Lançamentos Manuais
- PAG0227 - Lançamentos Manuais
- PAG0391 - Lançamentos Manuais
- PAG0471 - CPG - Lançamentos
It is still possible to perform entries for Calculations through the scheduling tab of the PAG0199 - Contratos screen, directly reflecting on the contracts of the payments and third-party services modules.
To use the Third-Party Services and Payments modules, it is necessary to register the PAG0214 - Parâmetros do Contrato, in which the link is made to the calculations that can be executed for the respective contract linked to the parameter.
English
Español

English
Español

