Access Open Batches Formulation
The Formulation tab has two primary functions. It is where the nutrients needed will be entered and the ingredient list that will be used to create that batch based on the Blend ID selected. The Request Nutrients PFU/Acre column is inactive if the Request Quantity Method has been selected.
Req Nutr PFU/Acre- Requested Nutrient Plant Food Unit per Acre, each macro-ingredient is listed which allows the user to enter the amount of each ingredient needed.
Dlvrd Nutr PFU/Acre- Delivered Nutrient Plant Food Unit per Acre, calculated when Formulate is selected.
Dlvrd Anlys PFU/100 lb- Delivered Analysis Plant Food Unit per 100 lb, calculated when Formulate is selected.
Ingredients grid
- Add Item- Not a recommended method for editing a Batch. When selecting Add Item to the Batch, the Method for the batch will update to Request Quantity. Select the Add Icon and select the Item then enter the Pounds per Acre.
- Revise and Edit Blend Component is the preferred method of editing the Ingredients on a batch by using the icons to add, remove or change the order of ingredients. Expand the ingredient to set a minimum and maximum of nutrients to be used from each ingredient for the Blend.
- Add an ingredient - enter the Item ID or select F12 to search. The ingredient's nutrient analysis will display as set on the Item.
- Remove a selected ingredient.
- Select to move an ingredient up in the formulation order Edit the Blend Sheet for any permanent change to the formulation order.
- Select to move an ingredient down in the formulation order.
- Select to enter a new Price date for a selected ingredient.
- Margin, Select to view Revenue, Cost, Margin, and Margin Percent. Update the Margin on the Batch by Percentage or by Dollar amount in the Fertilizer Ingredient Margin window. To update the Margin by a Dollar amount, enter the Margin amount in the New Margin field in Per Ton column. To update the Margin by Percentage, enter a Percentage in the New Margin % field in the Order Total column. Select OK to apply the new Margin for the Batch.
- Booking, select to view the Bookings for the Customer.
Ingredients- Ingredients populate this grid when the Blend ID is selected. The Item description of the ingredient.
Units- The Stocking Unit of Measure for the Ingredient.
Pounds Per Acre- This is the total pounds applied per acre.
Ext Qty Pounds- Extended Quantity in Pounds, the weight of the ingredient to achieve the pounds per acre.
For Liquid Fertilizer, Gallons per Acre- The total gallons per acre.
For Liquid Fertilizer, Ext Qty Gallons,- Extended Quantity in Gallons.
Price Per Unit- Current L1 Price of the Ingredient for the Stocking Unit of Measure.
Actual Extended Price- Total cost of the ingredient
Tx- Tax, if the Customer is taxable, may indicate L for Low or H for High
Flg - Flag - Items may be flagged for additional information regarding the item.
- RC - Restricted Chemical, current Chemical license required for purchase.
- LN - Lot Number required
- SN - Serial Number required - After the item quantity is entered, the Enter Serial Number window appears.
- OS - Out of Stock
Blend- Available only on Batches with Variable Spread selected as the Service Type. Ingredients with the checkmark removed will not be blended in the Batch and will be available for Variable Rate Technology when spreading.
Price per Ton- The price of the batch per ton allows for adjusting the total price per ton of fertilizer. This option is available when the setting Allow Selling Batch by the Ton is set to Yes in Setup > Access Locations > Fertilizer. Click the Price per Ton button to access the Edit Price Per Ton window. Enter the new Price Per Ton to update pricing on the batch.
Force Rounding to equal New Extended Price is automatically selected when a Non-Inventory Item is added to Merchant Ag FIN > Admin > Installation > Access Parameters > Fertilizer. The Rounding item is automatically added to the Service Items section found on the Seed and Services tab and displays the rounding amount as a Unit Price. See Setup > Access States to set the rounding method used.
Fertilizer in Pounds- The weight of the batch in pounds.
Fertilizer in Tons- The weight of the batch in tons.
Select Allow Excess Nutrients for a specific Batch with both macro- and micro- ingredients to allow the micro-ingredients to be fulfilled which may cause the macro-ingredients to exceed the Requested Analysis amounts.
When formulating a batch with Allow Excess Nutrients checked, Batches use the following calculation to determine the amount of an ingredient to use:
(Requested Nutrient * (100 + Parameter for Batch Excess Nutrition Allowance (%)) as the limit for the ingredient being used to fill the requested Nutrient.
IE if set to 10% then use 110% requested Nutrient