AGR0790 – Bulk Work Order Import

During validation and import, the system checks:

• Missing required fields or filling of column with invalid data (e.g.: date field filled with text, numeric field filled with description etc.);
• Existence of valid and current contracts for third-party operations;
• Validation of plots (without estimate, without area balance, location status verification etc.);
• Parameter conflicts (such as mandatory Start Forecast);
• Approval Limit and Application Factor parameters according to unit authorizations.

The screen has an additional tab for managing custom fields (Flex Fields);

1. In the Flex Fields tab, view the additional fields configured in the client’s database;
2. Select the desired fields to be included as columns in the generated template;
3. Flex Fields created after the screen release must be added manually by the technical team.

Each Work Order type has specific columns in the Excel template. See the main ones below:

• Planting and Replanting: basic information (WO header), Planting Type details, Location tab, Operation, Resources, Application Information and Observation;

• Crop Treatments and Pre-Planting Preparation: basic information (WO header), Location tab, Operation, Resources and Observation;

• Harvest: basic information (WO header), Harvest details, Location tab, Operation, Resources and Observation;

• Agricultural/Quality Monitoring: basic information (WO header), Location tab, Operation, Resources and Observation;

• Non-Agricultural: linked operations and Services, basic information (WO header), Location tab, Operation, Resources and Observation.

Examples of validations that may prevent import:

• Invalid contract: inactive, outside validity period or not authorized for the operation;
• Inconsistent plot: without estimate, without area balance or incompatible crop status;
• Invalid date: incorrect format (e.g.: dd/mm/yyyy hh:mm required);
• Missing required parameters: such as Start Forecast or Total Area;
• Application Factor/Excess Area: exclusive filling rules — if both are filled, Excess Area prevails.

For the AGR0790 screen to be available and functional, it is necessary to configure the following parameters:

1. Access the ADM0012 - Unidade Produtora screen;
2. In the Work Order tab, activate the Enable Work Order Import parameter;
3. This parameter is evaluated as soon as the Production Unit is selected in AGR0790;
4. If disabled, import will be blocked.

Message displayed:

.

During import, the system executes several automatic validations. Below are the main implemented rules:

Plots and Locations

The screen verifies if the Plot:

• Has a valid estimate (in case of Harvest WO);
• Has sufficient area balance;
• Has adequate status for the crop/WO type.

Operations:

• Correctly informed Operation (considering the PSGO registration performed - ADM0043 - Árvore de Processo);
• Validation of the selected contract (active contract, valid for the WO period and with authorization for the informed Operation) - when applicable.

Items and Resources

• Validation of Product x Balance x Stock Location;
• Validation of the Dose/Quantity informed for consumption (if both are filled, the value informed in Dose will prevail).

• WO’s with harvest waiting period go through approval in Fila de Aprovação (AGR0660);
• During this flow, only header and location data are utilized;
• After approval, it is necessary to manually complete the WO with Operation and Resources;
• The system will automatically include a standard observation.

Example:

[Lote_OS] - Work Order with Product Waiting Period approval. Necessary to finish WO construction (Operation and Resources tabs).

To use the feature, access- SimpleFarm > Agricultural Menu > Imports > Bulk WO Import and follow the steps below:

1. Select the Production Unit registered in ADM0012 - Unidade Produtora;
2. Choose the Standard WO Type and then the Work Order Type registered in screen Tipo de Ordem de Serviço (AGR0046);
3. If necessary, also select the Crop (when required by the location type);
4. Generate the template file by clicking Example File and fill in according to template instructions;
5. Use Attach File to upload the filled spreadsheet;
6. Click Load All to view the data on the screen;
7. Validate the data by clicking Validate. The system will highlight lines with issues, if any;
8. When all records are correct, finalize by clicking Import.