Walkthrough: Process a Purchase Order for Variable Lot in/Serial Out Items
This walkthrough demonstrates how to process a purchase order for variable weight items in the Lot in/Serial Out scenario.
When using the Lot in/Serial Out scenario, the total weight of all of the cases for a specific lot is recorded for all INBOUND and MOVE transactions, and specific case weights are recorded according to serial number for OUTBOUND transactions.
For INBOUND and MOVE transactions, the Item Ledger entries, and Warehouse entries record a transaction for the lot number. For OUTBOUND transactions, the Item Ledger entries record a transaction for each serial number, and the Warehouse entries record a transaction for the lot number.
About This Walkthrough
This walkthrough demonstrates the following tasks:
Create an Item Tracking Code
Create a Variable Weight Item
Create a Variable Weight Purchase Order
Create a Variable Weight Warehouse Receipt
Register a Warehouse Put-away
Invoice a Variable Weight Purchase Order
Prerequisites
On the No. Series page, number series have been defined for purchase orders.
On the No. Series page, lot number series have been defined.
On the Units of Measure page, units of measure have been defined.
On the Item Categories page, an item category has been defined.
Variable weight surcharges have been set up. For more information see, Set up Variable Weight Surcharges.
A warehouse location has been set up for non-directed picks and put-aways. For more information see Walkthrough: Set up a Warehouse Location with Non-Directed Picks and Put-Aways.
The employee that is performing the steps in this walkthrough, is set up as a warehouse employee for the SEATTLE location.
Story
The JF Company purchases and receives bulk cheese items. These cheese items are priced according to weight, and any surcharges are also distributed based on weight.
The SEATTLE location has been set up as a warehouse that uses non-directed put-aways. At the SEATTLE location, the JF company is purchasing 2 cases of bulk cheddar cheese (VW-LISO-CHEDDARCHEESE) and 3 cases of bulk mozzarella (VW-LISO-MOZACHEESE), both of which are received as cases but priced in pounds. A case of cheddar is expected to weigh 10 pounds. A case of mozzarella is expected to weigh 6 pounds.
When the 2 cheddar cheese cases are received, the total weight of the cases is 21.2 pounds. When the 3 mozzarella cases are received, the total weight of the cases is 17.8 pounds.
When the vendor invoice is received, the vendor has charged a delivery surcharge. When the purchase order is invoiced, the surcharge is split between the items based on the total lot weight.
Create an Item Tracking Code
Before creating a variable weight item for the Lot in/Serial Out scenario, create an Item Tracking Code. The Item Tracking Code, which is assigned to an item, is how JustFood determines how variable weights are handled.
To create an Item Tracking Code
Choose
, enter item tracking codes, and then choose the related link.The Item Tracking Codes page opens.
On the action bar, choose New.
The Item Tracking Code Card page opens.
On the General FastTab, perform the following steps:
In the Code field, enter VW-S3-LISO.
In the Description field, enter Variable Weight Scenario 3 Lot In Serial Out.
On the Serial No. FastTab, perform the following steps:
Turn on SN Specific Tracking.
Under Outboard, turn on SN Sales Tracking and SN Manufacturing.
On the Lot No. FastTab, except for the Lot No. Info Must Exist fields, turn on all fields.
On the Misc. FastTab, turn on Variable Weight Tracking.
Create a Variable Weight Item
A variable weight item must be created for the bulk cheddar cheese (VW-LISO-CHEDDARCHEESE) and bulk mozzarella (VW-LISO-MOZACHEESE) that will be purchased.
A case of cheddar is expected to weigh 10 pounds. A case of mozzarella is expected to weigh 6 pounds.
To create a variable weight item for the bulk cheddar cheese item
Choose
, enter items, and then choose the related link.The Items page opens.
On the action bar, choose New.
The Item Card page opens.
On the General FastTab, perform the following steps:
In the No. field, enter VW-LISO-CHEDDARCHEESE.
In the Description field, enter Cheddar Cheese Bulk.
In the Item Category Code field, select RAW.
To create the item's Units of Measure (UOM), perform the following steps:
On the action bar, choose Navigate > Item > Units of Measure.
The Item Units of Measure page opens.
Add the following records:
Code Qt. per Base UOM Weight CASE 1 10 LBS 10 1 On the Current Base Unit of Measure FastTab, in the Base Unit of Measure field, select CASE.
To return to the Item Card page, choose
.On the General FastTab, the Base Unit of Measure field is populated with CASE.
On the Costs & Posting FastTab, in the Costing Method field, select FIFO.
On the Prices & Sales FastTab, perform the following steps:
In the Sales Price Unit of Measure Code field, select LBS.
In the Purchase Price Unit of Measure field, select LBS.
On the Item Tracking FastTab, perform the following steps:
In the Item Tracking Code field, select VW-S3-LISO.
In the Serial Nos. field, select SERIAL.
In the Lot Nos. field, select LOT.
In the Expiration Calculation field, enter 6M.
On the action bar, choose Actions > Functions > Weight > Calculate Net Weight.
On the Inventory FastTab, the Net Weight field is populated. The net weight is calculated based on the defined units of measure. The net weight flows to document lines, such as for sales, picks, and warehouse entries.
Create a Variable Weight Item
Variable weight items must be created for the bulk cheddar cheese (VW-LISO-CHEDDARCHEESE) and bulk mozzarella (VW-LISO-MOZACHEESE) that will be purchased.
A case of cheddar is expected to weigh 10 pounds. A case of mozzarella is expected to weigh 6 pounds.
To create a variable weight item for the bulk mozzarella item
Choose
, enter items, and then choose the related link.The Items page opens.
On the action bar, choose New.
The Item Card page opens.
On the General FastTab, perform the following steps:
In the No. field, enter VW-LISO-MOZACHEESE.
In the Description field, enter Mozzarella Cheese Bulk.
In the Item Category Code field, select RAW.
To create the item's Units of Measure (UOM), perform the following steps:
On the action bar, choose Navigate > Item > Units of Measure.
The Item Units of Measure page opens.
Add the following records:
Code Qt. per Base UOM Weight CASE 1 6 LBS 6 1 On the Current Base Unit of Measure FastTab, in the Base Unit of Measure field, select CASE.
To return to the Item Card page, choose
.On the General FastTab, the Base Unit of Measure field is populated with CASE.
On the Costs & Posting FastTab, in the Costing Method field, select FIFO.
On the Prices & Sales FastTab, perform the following steps:
In the Sales Price Unit of Measure Code field, select LBS.
In the Purchase Price Unit of Measure field, select LBS.
On the Item Tracking FastTab, perform the following steps:
In the Item Tracking Code field, select VW-S3-LISO.
In the Serial Nos. field, select SERIAL.
In the Lot Nos. field, select LOT.
In the Expiration Calculation field, enter 6M.
On the action bar, choose Actions > Functions > Weight > Calculate Net Weight.
On the Inventory FastTab, the Net Weight field is populated. The net weight is calculated based on the defined units of measure. The net weight flows to document lines, such as for sales, picks, and warehouse entries.
Create a Variable Weight Purchase Order
After the variable weight items have been created, a variable weight purchase order can be created.
To create a variable weight purchase oder
Choose
, enter purchase orders, and then choose the related link.The Purchase Orders page opens.
On the action bar, choose New.
The Purchase Order page opens.
On the General FastTab, in the Vendor No. field, select a vendor.
On the Lines, to enter information for the cheddar, perform the following steps:
In the Type field, select Item.
In the No. field, select VW-LISO-CHEDDARCHEESE.
In the Location Code field, select SEATTLE.
In the Quantity field, enter 2.
The value in the Unit of Measure field represents the base UOM. This value is not the unit of measure for the weight.
In the Direct Unit Cost (Purch. Price UOM) field, enter 2.50.
This value is the cost of the item based on the item's weight. The cost of the cheddar is $2.50 per pound.
The Direct Unit Cost Excl. Tax field is automatically populated with 25.00, which is the price per CASE. One CASE is expected to weigh 10 LBS at $2.50 per pound.
On the Lines, to enter information for the mozzarella, perform the following steps:
In the Type field, select Item.
In the No. field, select VW-LISO-MOZACHEESE.
In the Location Code field, select SEATTLE.
In the Quantity field, enter 3.
The value in the Unit of Measure field represents the base UOM. This value is not the unit of measure for the weight.
In the Direct Unit Cost (Purch. Price UOM) field, enter 2.00.
This value is the cost of the item based on the item's weight. The cost of the mozzarella is $2.00 per pound.
The Direct Unit Cost Excl. Tax field is automatically populated with 20.00, which is the price per CASE. One CASE is expected to weigh 10 LBS at $2.00 per pound.
On the action bar, choose Process > Release.
At this point, none of the Line Net Weight fields are populated.
Create a Warehouse Receipt
After a purchase order is created and released, a warehouse receipt can be created.
To create a warehouse receipt
Choose
, enter purchase orders, and then choose the related link.The Purchase Orders page opens.
Select the released purchase order that was created for the variable weight items, and then on the action bar, choose Manage > View.
The Purchase Order page opens.
On the action bar, choose Process > Create Whse. Receipt.
A dialog box appears and displays a message that indicates that a warehouse receipt header was created.
To close the dialog box, choose OK.
The Warehouse Receipt page opens.
To enter the tracking information for the cheddar line, perform the following steps:
Select the VW-LISO-CHEDDARCHEESE line.
In the Qty. to Receive field, enter 2.
On the Lines section action bar, choose Line > Item Tracking Lines.
The Item Tracking Lines page opens.
On the action bar, choose Process > Assign Lot No.
In the Net Weight field, enter 21.2.
The value of 21.2 is the total weight of the 2 cases.
To return to the Purchase Order page, choose Close.
The Line Net Weight to Receive field is automatically populated with 21.2.
To enter the tracking information for the mozzarella line, perform the following steps:
Select the VW-LISO-MOZACHEESE line.
In the Qty. to Receive field, enter 3.
On the Lines section action bar, choose Line > Item Tracking Lines.
The Item Tracking Lines page opens.
On the action bar, choose Process > Assign Lot No.
In the Net Weight field, enter 17.8.
The value of 17.8 is the total weight of the 3 cases.
To return to the Purchase Order page, choose Close.
The Line Net Weight to Receive field is automatically populated with 17.8.
On the action bar, choose Posting > Post Receipt.
A dialog box appears and displays a question asking whether you want to post the receipt.
Choose Yes.
A dialog box appears and displays a message that indicates that a source document was posted, and a put-away activity was created.
Choose OK.
The Posted Whse. Receipt page opens.
If you return to the purchase order, you can see that some of the Line Net Weight fields have been populated. In the Direct Unit Cost Excl. Tax fields, the values were recalculated to reflect the weights that were received. For example, 3 cases of mozzarella weighed 17.8 pounds, and the total cost of the cases is $35.60 ($2.00 x 17.8). The cost of each case is $11.86667 ($35.60 divided by 3).
Register the Warehouse Put-Away
After the warehouse receipt is created, the warehouse put-away can be registered.
To register the warehouse put-away
Choose
, enter posted warehouse receipts, and then choose the related link.The Posted Warehouse Receipts page opens.
Select the posted warehouse receipt that was created, and then on the action bar, choose Manage > View.
The Posted Whse. Receipt page opens.
On the action bar, choose Navigate > Receipt > Put-away Lines.
The Warehouse Activity Lines page opens.
The lines display the following:
Take 2 cases of the VW-LISO-CHEDDARCHEESE item, with a net weight of 21.2, from the RECEIVE bin, and place the cases into the A1-01-01 bin.
Take 3 cases of the VW-LISO-MOZACHEESE item, with a net weight of 17.8, from the RECEIVE bin, and place it into the A1-01-01 bin.
On the action bar, choose Process > Show Document.
The Warehouse Put-away page opens.
On the action bar, choose Process > Register Put-away.
A dialog box appears.
To register the put-away document, choose Yes.
Each lot is moved as a whole unit to the appropriate bins in JustFood.
On the Warehouse Entries page, you can view the positive adjustments, and the movement from the RECEIVE bin to the A1-01-01 bin for both the items.
Invoice the Variable Weight Purchase Order
When the invoice is received, the vendor has charged a $20.00 delivery surcharge. When the purchase order is invoiced, the surcharge is split between the items based on the total lot weight.
To invoice the variable weight purchase order
Choose
, enter purchase orders, and then choose the related link.The Purchase Orders page opens.
Select the released purchase order that was created for the variable weight items, and then on the action bar, choose Manage > View.
The Purchase Order page opens.
On the action bar, choose Process > Reopen.
On the Lines, to add a new line for the charge, perform the following steps:
In the Type field, select Charge (Item)
In the No. field, enter FREIGHT.
In the Location Code field, enter SEATTLE.
In the Quantity field, enter 1.
In the Direct Unit Cost Excl. Tax field, enter 20.00.
In the Qty. to Receive field, enter 1.
To assign the item charge, perform the following steps:
Select the item charge line, and then on the Lines section action bar, choose Line > Item Charge Assignment.
The Item Charge Assignment page opens.
Select all existing lines, and then on the action bar, choose Manage > Delete.
A dialog box appears.
To delete the selected lines, choose Yes.
On the action bar, choose Item Charge > Get Receipt Lines.
The Purch. Receipt Lines page opens.
Select the 2 lines that are associated with the purchase order, and then choose OK.
The two receipt lines are returned to the Item Charge Assignment page.
On the action bar, choose Item Charge > Suggest Item Charge Assignment.
Select Weight (Gross if Not Zero Else Net).
Choose OK.
The Qty. to Assign field is automatically updated. The Amount to Assign is based on the weight of each lot. The total delivery charge is $20.00, and $9.13 is assigned to the 21.2 pounds of the bulk cheddar, and $10.87 is assigned to the 17.8 pounds of the bulk mozzarella.
Choose Close.
On the Lines, in the Qty. to Invoice field, enter 2 for the bulk cheddar line, and enter 3 for the bulk mozzarella line.
On the action bar, choose Posting > Post.
A dialog box appears.
Select Receive and Invoice, and then choose OK.
The purchase order is invoiced.
On the Item Ledger Entries page, a transaction for the total lot of each item is displayed.
The Value Entries page displays how the costs were assigned for each item.