Adjusting Actuals

When the blend quantity that the customer actually takes differs from the blend amount that was calculated by agrē, you have the option to go back and adjust the blend values to reflect the actual blend quantities used. Adjusting Actuals keeps your inventory levels more accurate, because you are reducing  inventory levels by the same amount that the customer actually took.

You can adjust actuals per blend or per batch, and specify the changes by weight of the product or by scale stops.

You can adjust actuals for blends saved on loadout tickets or invoices where inventory is moved. The adjust actuals option is unavailable for blends made from the Blending menu or blends saved on work orders since inventory is not affected.

Any changes you make to the blend amount using the Adjust Actuals window is reflected in the cost of the original quote and total blend quantity.

Note

Adjusting actuals does not change the guaranteed analysis of the blend, so a message appears if you adjust the values by more than 5%. The recommended course of action under these circumstances is to recalculate the blend with the values so that the guaranteed analysis is accurate.

Click Yes to cancel your adjustments, or click No to save your adjustments.

You cannot adjust actuals if price splits have been entered since agrē cannot determine how to allocate the price splits based on the new quantities. Price splits can be entered after actuals have been adjusted. You can adjust actuals if work order links exist, providing there are no price splits.

If the adjustment increases a product quantity above the quantity limit and work order links exist, you can choose to remove the adjusted actuals or split the line on the invoice (the work order quantity is taken completely and the remainder is put onto a new blend at current prices).

To Adjust Actuals

Edit the loadout ticket or invoice belonging to the customer whose blend actuals you want to adjust.
The source document window opens.

From the Product list, select the blend to adjust and then click Edit Row.
The Make a Blend window opens.

Click the Calculation tab.

Click Adjust Actuals.
The Adjust Actuals window opens.

Select Product Quantity or Scale Stops to define how the products being adjusted are measured.
Select Product Quantity to measure according to the actual amount of products blended, or select Scale Stops to measure cumulatively as the products enter the blender.

Select Blend or Batch to enter actuals per blend or per batch.

Note

If you selected Blend proceed to Adjust by Blend.
If you selected Batch, jump to Adjust by Batch.

Adjust by Blend

In the Actual Quantity column, optionally change the actual quantity for each product.

Under Adjust for blend quantity change, select whether you want to adjust the blend Rate or Field Size.

Note

You can choose to have agrē automatically recalculate the blend based on quantity shift, or you can keep the blend price the same and make adjustments to the individual products’ prices.

(If you opened the blend from an invoice only.) Select the Recalculate blend unit price based on revised product proportions? check box if you want agrē to automatically recalculate the blend based on the quantity shift.

Click Update to save the new quantities.
The Adjust Actuals window closes and the updated values appear on the Calculation tab.

Click Save. to save the blend (with the updated quantities)
The Make a Blend window closes and the updated blend appears in the Product list on the Edit Loadout Ticket or Edit Invoice window.
If the adjustment increases a product quantity above the quantity limit and work order links exist, you can choose to remove the adjusted actuals or split the line on the invoice (the work order quantity is taken completely and the remainder is put onto a new blend at current prices).

Click Save.

In the table, add rows until you have entered each batch that appears on your blend batch worksheet.

Tip

Click Remove to remove a row from the table.

Adjust by Batch

Under Adjust for blend quantity change, select whether you want to adjust the blend Rate or Field Size.

Note

You can choose to have agrē automatically recalculate the blend based on quantity shift, or you can keep the blend price the same and make adjustments to the individual products’ prices.

(If you opened the blend from an invoice only.) Select the Recalculate blend unit price based on revised product proportions? check box if you want agrē to automatically recalculate the blend based on the quantity shift.

Note

When you click Update, the overall product totals are saved but the batch details are not saved.

Click Update.
The
Adjust Actuals window closes and the updated values appear on the Calculation tab.

Click Save.
The Make a Blend window closes and the updated blend appears in the Product list on the Edit Loadout Ticket or Edit Invoice window.
If the adjustment increases a product quantity above the quantity limit and work order links exist, you can choose to remove the adjusted actuals or split the line on the invoice (the work order quantity is taken completely and the remainder is put onto a new blend at current prices).

Click Save.