This feature is designed to formulate a blend to inventory (for stockpile) instead of invoicing the resulting blended material. It combines the power of the Blending module and the manufactured blend function.
Navigate to Blending / Edit / Blend to Stock then choose From Weights or From Automated Blender File.
From Weights
The first step is to create a Blend Ticket. Next, either move the inventory from that ticket to an existing Product or create a new Product to which the inventory will be moved. Once a ticket is selected, the Edit Blend to Stock window displays which is similar to the Edit to Actual Scale window. Here, the actual weight of the product is entered and is prorated over the analysis products on the ticket by choosing Apply.
Selecting OK prompts to either select an existing product or add a new product. If New Product is selected, the Add a New Product window displays to enter the information needed to set up the new product. Once the product is selected, a valid lot number may be added here manually or one previously set on this product may be chosen from the drop-down.
Once a product is selected or created, indicate the quantity of final product produced and choose Save. A message displays indicating Manufactured Inventory was created successfully and provides a reference number. The Blend Ticket is marked as Processed and the Amount on Hand of the selected product is increased by the Quantity.
From Automated Blender File
Once the product has been made, go to Edit / Blend to Stock / From Automated Blender File.
Select the Scale Ticket. Only Blend Tickets that have completed blender files show in the list. Choose the finished good, enter the finished quantity, and select OK. The Read Automated File for Blend to Stock window opens and displays the Products, Original weights, Done weights, and UOM. The Done weights may be edited if corrections are needed.
After selecting OK, a message appears indicating that the manufactured blend was successfully created.
Posting Notes for Blend to Stock Entry
- Inventory Detail – An inventory record is made for the finished product and each raw material for an audit trail of inventory activity.
- Inventory Amount on Hand – The product’s Amount on Hand quantity is updated for each of the products involved. The quantity is increased for the finished product and decreased for each raw material.
- Finished Product Cost – The blended product's Average and Last Cost is updated based on the cost of the raw materials.
- General Ledger:
| General Journal Entry | Debits | Credits |
|---|---|---|
| Total cost of all raw materials | Cost of Sales for finished product | |
| Each raw material cost | Cost of Sales for each raw material product | |
| If using Transactional Inventory valuation | ||
| Total cost of all raw materials | Inventory Asset for finished product | |
| Each raw material cost | Inventory Asset for each raw material product |
