orders list master sheet
TRANSCRIPT
-
8/12/2019 Orders List Master Sheet
1/33
INVENTORY AND SALES MANAGER
ORDER NO Catalog Name Vendor Order source2 Count
012 b'wood replicas vol 3 RCPC SAILAJA 1
012 Raj kumar MAYANK SAILAJA 2
012 Eliza KETAN SAILAJA 1
013 Eliza KETAN TEJA 6
014 Eliza KETAN SAILAJA 1
O
-
8/12/2019 Orders List Master Sheet
2/33
-
8/12/2019 Orders List Master Sheet
3/33
-
8/12/2019 Orders List Master Sheet
4/33
-
8/12/2019 Orders List Master Sheet
5/33
-
8/12/2019 Orders List Master Sheet
6/33
-
8/12/2019 Orders List Master Sheet
7/33
-
8/12/2019 Orders List Master Sheet
8/33
-
8/12/2019 Orders List Master Sheet
9/33
-
8/12/2019 Orders List Master Sheet
10/33
-
8/12/2019 Orders List Master Sheet
11/33
-
8/12/2019 Orders List Master Sheet
12/33
-
8/12/2019 Orders List Master Sheet
13/33
-
8/12/2019 Orders List Master Sheet
14/33
-
8/12/2019 Orders List Master Sheet
15/33
-
8/12/2019 Orders List Master Sheet
16/33
-
8/12/2019 Orders List Master Sheet
17/33
-
8/12/2019 Orders List Master Sheet
18/33
-
8/12/2019 Orders List Master Sheet
19/33
-
8/12/2019 Orders List Master Sheet
20/33
-
8/12/2019 Orders List Master Sheet
21/33
-
8/12/2019 Orders List Master Sheet
22/33
-
8/12/2019 Orders List Master Sheet
23/33
-
8/12/2019 Orders List Master Sheet
24/33
-
8/12/2019 Orders List Master Sheet
25/33
-
8/12/2019 Orders List Master Sheet
26/33
End of 2000 Products
-
8/12/2019 Orders List Master Sheet
27/33
Order
NumberSource Order Date Vendor Item Code Catalog Quantity Unit Price Amount
Cum
012 =Products!D4 4-Mar-14 RCPC 179 vol 3 1 1150 1,150
012 =Products!D54-Mar-14
MAYANK
31401
31406 raj kumar 1 3963 3,963
012 =Products!D6 4-Mar-14 KETAN 22010 eliza 1 1350 1,350
013 =Products!D7 5-Mar-14 KETAN 6 eliza 1 8140 8,140
014 =Products!D8 5-Mar-14 KETAN 22008 eliza 1 1350 1,350
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
ENTER YOUR ORDER DETAILS these column
-
8/12/2019 Orders List Master Sheet
28/33
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 00 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
-
8/12/2019 Orders List Master Sheet
29/33
All the information here is based on Order Date and not Expected Date
AMOUNT - MONTHLY AND CUMULATIVE QUANTITY - MONTHLY AND CUMULATIVE
AMOUNT - BY PRODUCT CATEGORY QUANTITY - BY PRODUCT CATEGORY
AMOUNT BY PARTNER PRODUCT RANKING
RANK PRODUCT NAME
Choose one Order Type
at a time: Purchase or
Sale
Order Month
Jan Feb Mar Apr
May Jun Jul Aug
Sep Oct Nov Dec
Order Year
2/6... 2012 2013
Product Name
COOLPIX L120
COOLPIX L23
COOLPIX L24
COOLPIX S6000
COOLPIX S8100
COOLPIX S9100
Partner
Supplier Z
Customer A
Customer B
Customer C
Supplier X
Supplier Y
Order Type
Purchase
Sale
-
8/12/2019 Orders List Master Sheet
30/33
TERMS USED IN THIS TEMPLATE
Re-order Point: Amount that you set for each product, where when the current inventory level hits
that amount, you will place a new purchase order to replenish inventory. (For more, read Wikipedia
article http://en.wikipedia.org/wiki/Reorder_point)
Product Category: This allows you to categorize products. If you have numerous products,
categorizing similar products together can help in understanding product performance.
Order Number: This Order number is not used in the template to calculate anything. This has been
provided for you to track your orders easily. You can filter the Orders table by choosing specific order
number to see all the items in that order. If your systems generate any order numbers, you can enter
them here. If you dont have any such systems, you can create your own. The only recommendation is
that you should have a unique order number for each order.
Order Type: There are two types of Orders: Purchase and Sale. When you place an order to acquire
products from suppliers, it is called a Purchase order. When your customer places an order to buy
products from you, it is called a Sale.
Order Date: For Purchase orders, this is the date when the order is placed by you to your supplier.For Sale orders, this is the date when the order is placed by your customer to you.
Expected Date: For Purchase orders, this is the date when the inventory becomes available for you to
sell. For Sale orders, this is the date when the inventory will leave you to the customer.
Partner: For Purchase orders, your supplier is the Partner. For Sale orders your customer is the
Partner.
Quantity: Number of units of products. The unit can be any numeric value. Even if your unit is not
whole numbers, you can still use the Quantity field.
Unit Price: In Purchase orders, this is the cost of buying one unit of the product. In Sale orders, this is
the revenue from selling one unit of the product.
Amount(Calculated field): (Unit Price X Quantity) = represents the amount of money. In Purchaseorders this would be money leaving you and in Sale orders, this would be money that customers pay
you.
Inventory Availability(Calculated field): This is the quantity (number of items) of the product
-
8/12/2019 Orders List Master Sheet
31/33
Products
-
8/12/2019 Orders List Master Sheet
32/33
roduct
CHOOSE PRODUCT
Product rent Invent -order Poi
DUCTS AVAILA QUANTITY UCTS TO RE-OINVENTORY
DER POINT
G PURCHASE QUANTITY
NDING SALES QUANTITY
CURRENT FUTURE
*where Sale quantity is higher than Inventory available - highlighted with red border in the table below
#REF! ####
INVENTORY AND SALES MANAGER - ORDERS AND INVENTORY
ORDER ITEMS THAT CANNO
WHERE CURRENT INVENTORY
ES80
CURRENT INVENT
0 0 0
-
8/12/2019 Orders List Master Sheet
33/33
Report Terms
Pending Purchase Quantity
5