Sell, ship and invoice liters of alcohol
When prices for variable strength items are agreed in liters of alcohol, the system automatically adjusts the sales order line to reflect the actual alcohol content of the shipped lot, while preserving the agreed unit price.
Exercise: Sell a full tank truck of alcohol
Story
Anna is sales manager at CRONUS DIT. With the customer, she agreed a price of 1.30 per liter alcohol. She creates a sales order for a full tank truck.
Verify that you are a warehouse employee for location BLUE-PROD
- Select the Search icon
, enter Sales Orders, and then choose the related link. - On the Sales Order page, select the customer.
-
Create a sales line with an alcohol item configured in LA (liters of alcohol).
- In the Volume L field, enter 25,000.
- Check the Strength ABV; 96.00 is the default off the item.
- Check the Total ABV*L; 24,000 is the liters of alcohol.
- Check the Quantity; equal to the liters of alcohol.
- Check the Unit Price and Line Amount; according to sales price setup.
-
Release the order.
Bob is warehouse employee. He prepares the warehouse shipment for the order and now registers the shipment according to the delivery. The tank contained 24,800 liters at a strength of 95.80%.
-
Create the warehouse shipment by executing the Create Whse. Shipment action.
- On the Lines FastTab, choose the Item Tracking Lines action.
- Assign a lot number with the Assign Lot No. function.
- Register the actual 24,800 liters in the Quantity Base field and the actual strength in Strength ABV.
-
Close the page and confirm the update question.
The system recalculates the Quantity and Total ABV*L on the sales order line based on the actual lot strength. The agreed Unit Price is preserved exactly as set on the order.
- Check the Total ABV*L on the sales order line; 23,758.40 is the actual liters of alcohol.
- Check the Quantity; equal to the actual liters of alcohol.
- Check the Unit Price; unchanged at 1.30.
- Check the Line Amount; 23,758.40 × 1.30 = 30,885.92 excl. VAT.
-
To post the shipment, choose the Post action.
Ian is the accounts receivable employee that prepares the sales invoice. The posted shipment documents 23,758.40 liters of alcohol calculated at 1.30 per liter. This makes the total amount excl. VAT 30,885.92. Before he posts the invoice, he confirms that the invoice matches the actual shipment and the agreed price.
-
Select the Search icon
, enter Sales Invoices, and then choose the related link. - On the Sales Invoice page, select the customer and register the document reference.
- On the Lines FastTab, choose the Get Shipment Lines action.
- Select the shipment line that is included in the invoice.
- Match the invoice amounts. To post the invoice, choose the Post action.
See also
Order, receive and invoice liters of alcohol
Volume and strength units of measure