Recalculate settlements and consignments

Grower Return • Article • 10/21/2026 •

Open settlements and consignments can be recalculated automatically in the background by using the job queue, instead of recalculating each document manually. This is useful when many documents, for example weekly pooling settlements, must be recalculated regularly. A document that cannot be recalculated does not stop the other documents, and the failed documents are listed with the reason.

Prerequisites

Before documents are recalculated:

Settlements have the Status field value set to New or Calculated. The Calculate action must have been run at least once on the settlement, because the calculation parameters, including the pooling template, are stored on the settlement then.
Consignments have the Status field value set to New or Calculated. Consignments with the Status field value set to Closed are never changed.
The user who runs the job has the Grower Return permission set. Both the full and the basic permission set contain the new reports.

Set up the job queue entries

The system creates the job queue entries when the grower return setup is initialized for the first time: one for the Recalculate Settlements report and one for the Recalculate Consignments report. Each entry has the Status field value set to On Hold, creates no report output, runs every day, and starts at 02:00. If a job queue entry already exists for a report, no entry is created for that report.

The Set default values action on the Grower Return Setup page also creates the entries, but it resets the grower return setup to its default values. In an environment that is already in use, create the job queue entries manually for the two reports instead.

To adjust the job queue entries, follow these steps:

Select the Search icon , enter Job Queue Entries, and then choose the related link.
Open the entry of the report and set the filters on the request page of the report.

Report Available filters

Recalculate Settlements No., Accounting Method, Document Date

Recalculate Consignments No., Order No., Creation Date

Without filters, all open documents are processed.
Adjust the schedule if needed, for example to run weekly, and set the Status field value to Ready.

Report	Available filters
Recalculate Settlements	No., Accounting Method, Document Date
Recalculate Consignments	No., Order No., Creation Date

Recalculate documents manually

Select the Search icon , enter Recalculate Settlements or Recalculate Consignments, and then choose the related link.
Set the filters, and then select OK.
A message shows how many records were recalculated. If records failed, the Error Messages page opens with a summary at the top, followed by one entry for each failed record.

Understand the result

Each settlement is recalculated with its own stored parameters, with the same result as the Recalculate action on the Settlement page: the settlement lines are refreshed, the Status field value is Calculated, and the Last Calculated Date field value is updated.
Settlements with any other status are never recalculated, even if the filters include them.
A settlement without stored calculation parameters is not recalculated. It is reported as failed with the message "Settlement SET-0001 has no stored calculation parameters. Run Calculate on the settlement first."
When a document fails, the changes made to it are rolled back, and the remaining documents are still recalculated.
In the job queue, the log entry on the Job Queue Log Entries page gets the status Error when at least one document failed, and the error messages list each failed document with its error text.
No request page, confirmation, or message is shown during a background run.

For example, a customer has about 40 pooling settlements to recalculate every week. The Recalculate Settlements job queue entry is filtered on the Accounting Method field value Pooling, scheduled for Monday at 02:00, and its Status field value is set to Ready. On Monday, 38 settlements are recalculated and 2 fail. The log entry shows the status Error, and its error messages list the 2 settlement numbers with the reason, while the other 38 settlements are recalculated.

Recalculate a settlement from the Settlement page

On the Settlement page, select Recalculate. If the settlement has stored parameters, they are used. If no parameters are stored, the request page opens, and the entered parameters are stored on the settlement and used for the recalculation.