Walkthrough: Process a Purchase Order for Variable Serial in/Serial Out Items

This walkthrough demonstrates how to process a purchase order for variable weight items in the Serial in/Serial Out scenario.

In the Serial in-Serial Out scenario for variable weight, a total weight is assigned to the entire lot for all INBOUND and OUTBOUND transactions, and an individual weight is assigned to each serial number for MOVE transactions.

For MOVE transactions, the item ledger entries, and warehouse entries record a transaction for the lot number. For INBOUND and 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, lot number series have been defined.
On the No. Series page, serial 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: Setting 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 sides of beef. These meat items are priced according to weight, and any vendor item 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 3 sides of beef (VW-SISO-BEEF_SIDE), which are received as cases but are priced in pounds. The vendor charges a delivery surcharge of $3.00 per case. This surcharge is automatically added to the purchase order.

A side of beef is expected to weigh 150 pounds. The cost is $4.00 per pound. When the sides of beef arrive, the weights are 145, 152 and 153.5 pounds. The delivery surcharge of $9.00 ($3.00 per case) is divided among the three cases based on the 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:
1. In the Code field, enter VW-S4-SISO.
2. In the Description field, enter Variable Weight Scenario 4 Serial In Serial Out.
On the Serial No. FastTab, perform the following steps:
1. Turn on SN Specific Tracking.
2. Under Inbound, turn on SN Purchase Tracking, SN Manufacturing Tracking, and SN Transfer Tracking.
3. Under Outbound, turn on SN Sales Tracking and SN Manufacturing Tracking.
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 sides of beef that will be purchased. The item's weight is expected to be 150 pounds per case.

To create a variable weight 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:
1. In the No. field, enter VW-SISO-BEEF_SIDE.
2. In the Description field, enter Beef Side.
3. In the Item Category Code field, select RAW.
To create the item's Units of Measure (UOM), perform the following steps:
1. On the action bar, choose Navigate > Item > Units of Measure.
  
  The Item Units of Measure page opens.
2. Add the following records:
  
  Code Qt. per Base UOM Weight
  
  CASE 1 150
  
  LBS 150 1
3. On the Current Base Unit of Measure FastTab, in the Base Unit of Measure field, select CASE.
4. 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:
1. In the Sales Price Unit of Measure Code field, select LBS.
2. In the Purchase Price Unit of Measure field, select LBS.
To define the vendor item surcharge, perform the following steps:
1. On the action bar, choose Navigate > Purchases > Special Purchase Prices & Discounts > Vendor Surcharges.
  
  The Vendor Item Surcharges page opens.
2. In the Sales Type field, select CASE.
3. In the Purch. Code field, enter 1002.
4. In the Item No. field, enter VW-SISO-BEEF_SIDE.
5. In the Surcharge UOM field, enter CASE.
6. In the Surcharge Code field, enter FREIGHT.
7. In the Value field, enter 3.00.
  
  After this vendor item surcharge record is entered, whenever a side of beef (VW-SISO-BEEF_SIDE) is purchased from the 1002 vendor, for each case, $3.00 will be added to the purchase order.
8. To return to the Item Card page, choose .
On the Item Tracking FastTab, perform the following steps:
1. In the Item Tracking Code field, select VW-S4-SISO.
2. In the Serial Nos. field, select SERIAL.
3. In the Lot Nos. field, select LOT.
4. 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.

Code	Qt. per Base UOM	Weight
CASE	1	150
LBS	150	1

Create a Variable Weight Purchase Order

After the variable weight item has been created, a variable weight purchase order can be created.

To create a variable weight purchase order

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, perform the following steps:
1. In the Type field, select Item.
2. In the No. field, select VW-SISO-BEEF_SIDE.
3. In the Location Code field, select SEATTLE.
4. 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.
5. In the Direct Unit Cost (Purch. Price UOM) field, enter 4.00.
  
  This value is the cost of the item based on the item's weight. The cost of the beef is $4.00 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.
  
  The delivery surcharge is automatically added because a surcharge was set up for the item and vendor combination.
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 side of beef, perform the following steps:
1. Select the VW-SISO-BEEF_SIDE line.
2. In the Qty. to Receive field, enter 3.
3. On the Line section action bar, choose Line > Item Tracking Lines.
  
  The Item Tracking Lines page opens.
4. On the action bar, choose Process > Assign Serial No.
  The Enter Quantity to Create page opens.
5. In the Quantity to Create field, enter 3.
6. Turn on Create New Lot No..
7. Choose OK.
8. In the Net Weight fields, enter 145, 152 and 153.5. These values are the individual weights of each side of beef.
9. To close the Item Tracking Lines page, choose Close.
  
  On the Warehouse Receipt page, the Line Net Weight to Receive field is automatically populated with 450.5.
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.

On the Purchase Order page, some of the Line Net Weight fields have been populated. The values in the Direct Unit Cost Excl. Tax fields were recalculated to reflect the weights that were received. The 3 cases of beef weighed 450.5 pounds, and the total cost of the cases is $1802.00 ($4.00 x 450.5). The cost of each case is $600.66667 ($1802 divided by 3).

Register a Warehouse Put-Away

After the warehouse receipt is created, the warehouse put-away can be registered.

To register a 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 1 case of the VW-SISO-BEEF_SIDE item, with a net weight of 145, from the RECEIVE bin, and place it into the A1-01-01 bin.
- Take 1 case of the VW-SISO-BEEF_SIDE item, with a net weight of 152, from the RECEIVE bin, and place it into the A1-01-01 bin.
- Take 1 case of the VW-SISO-BEEF_SIDE item, with a net weight of 153.5, 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, the positive adjustments can be viewed, as well as the movement from the RECEIVE bin to the A1-01-01 bin for both of the items.

Invoice a Variable Weight Purchase Order

After the warehouse put-away has been registered, the variable weight purchase order can be invoiced. When the purchase invoice is posted, the vendor delivery charge must be split between the cases based on the weight.

To invoice a 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.
For the item line, in the Qty. to Invoice field, enter 3.
On the action bar, choose Posting > Post.

A dialog box appears.
Select Invoice, and then choose OK.

The purchase order is invoiced.

On the Item Ledger Entries page, the individual weight of each item in the Net Weight field can be viewed. The Cost Amount (Actual) field displays the actual cost of the item cost plus the item charge cost, both of which are distributed based on the item’s weight.

The Value Entries page for each item display how the costs were assigned.