On Hand by Vendor by Warehouse Screen
How to print: Complete the On Hand by Warehouse List Prompt Screen with the By warehouse/by warehouse vendor field set to 2 and with no Vendor specified.
CWDirect Rel 6.0 On Hand By Vendor By Warehouse EKAPLAN INR0881 10/03/02 11:13:10 Page 1 Sarah`s Joke Shop Warehouse: 10 THE MAIN WAREHOUSE Vendor: 10000 Item SKU Vendor Item Vendor Desc Returned Issued Adjusted Received O/H Cost Extension MTD MTD MTD MTD GR45678 VI12345 TOY GRABBAG 0 1 0 0 14 5.0000 70.0000 PE444444444 VI23456 KITTEN KIT 0 0 0 0 5 4.0000 20.0000 Vendor Totals 0 1 0 0 19 9.0000 90.0000 CWDirect Rel 6.0 On Hand By Vendor By Warehouse EKAPLAN INR0881 10/03/02 11:13:10 Page 2 Sarah`s Joke Shop Warehouse: 10 THE MAIN WAREHOUSE Vendor: 10001 Item SKU Vendor Item Vendor Desc Returned Issued Adjusted Received O/H Cost Extension MTD MTD MTD MTD PU44444 PP-222 PUPPY KIT 1 7 0 20 14 1.05000 14.7000 GR45678 GR-425 GROW POT 1 1 0 0 15 4.00000 60.0000 CA1234 1 OZ KT-123 CATNIP LOOSE 1 0 0 0 1 .00000 .0000 MI66666 ML-567 MILLET 1 OUNCE 0 5 0 20 20 1.00000 20.0000 KI22222 KB-987 DACHSHUND CHOW 30 40 2 100 152 1.00000 152.0000 YE22222 PE-456 PERCH NAT WOOD 0 3 0 20 17 13.33333 226.6661 Vendor Totals 33 56 2 160 219 20.38333 473.3661 |
Contents:
• warehouse number and description
• vendor number, based on the primary vendor identified for the item, regardless of whether this vendor or a different vendor actually sold you the inventory. This report starts a new page for each warehouse/vendor combination.
• item code
• SKU code, if any
• vendor/item code
• vendor/item description
• the total quantity of the item/SKU returned from the customer to the warehouse month-to-date
• the total quantity of the item/SKU shipped from the warehouse month-to-date
• the total quantity of the item/SKU adjusted (using an inventory transaction code of A) in the warehouse month-to-date
• the total quantity of the item/SKU received on purchase orders month-to-date (this quantity is updated when you place the stock, rather than when you dock a purchase order or place inventory in suspense)
• C = Cost: the standard, average, or FIFO cost on the report, based on the Costing Method (A25) system control value. If the appropriate cost is not specified in the SKU file, the report uses the cost from the Item file. If you use FIFO costing, the unit cost of each item/SKU is not listed, only the extended cost, calculated as the totals of FIFO layers (see Using FIFO Cost Layer Inquiry (WFCF))
• R = Retail: This report does not currently support printing the retail price.
• V = Vendor list: the vendor/item price for the item’s primary vendor. No vendor/item price is listed if the item has no primary vendor, or if there is no vendor/item for the primary vendor.
• blank: There is no cost or price information.
• The extended cost or vendor list price for the item/SKU
• Totals for the vendor and warehouse:
• quantity returned month-to-date
• quantity shipped month-to-date
• quantity adjusted month-to-date
• quantity received month-to-date
• quantity on-hand
• total of all unit costs or vendor/item prices
• total of all extended costs or vendor/item prices
Note:
• This report does not currently support printing the retail price.
• The vendor is 0 for kit items.
• The report does not perform currency conversion when the vendor’s currency is different from your own; in this situation, the unit and extended vendor/item prices may be incorrect.
• The vendor/item price is zero for kit items.
| On Hand by Warehouse Report | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 54: Pending Putaway Overview |
WH07_13r CWDirect 18.0 August 2015 OTN