1 | SKU | Image | FNSKU | NAME | IN or OUT | Transacted Units | Location | Count Type | Per Type | Error Check | Edited (IN/OUT) | Edited (Transacted) | Unit Cost | Curr QTY | Prev QTY | Transacted Value | Curr Inv Value | Prev Inv. Value | $ Value OUT |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Manually enter SKU to check in/out | AMZN FNSKU or chagne to what you need. | Short name to identify | IN = receive OUT = send To transfer, do OUT then IN | The number you use to count | Your physical location (not Amazon) | The case "name" | Units per case | Will light up if col E and F don't have values. | Auto updates with time of edit | Auto updates with time of edit | Loads the unit cost you entered in InventoryDetails | TOTAL quantity of inventory in your locations | Prior quantity before latest transaction | Total value of inventory movement | Current inventory value based on current qty | Prior inventory value based on previous quantity | Inventory value sent out | |
3 | AAAA1111 | - | BSDFU49232 | FOX HELMET | IN | 7 | Office | BOX 20x20x20 | 6 | 7/5/2018 | 7/5/2018 | $100.00 | 42 | 0 | $4,200.00 | $4,200.00 | $0.00 | - | |
4 | AAAA1111 | - | BSDFU49232 | FOX HELMET | IN | 2 | Storage | BOX 20x20x20 | 6 | 7/5/2018 | 7/5/2018 | $100.00 | 54 | 42 | $1,200.00 | $5,400.00 | $4,200.00 | - | |
5 | BBBB2222 | - | JDYENJJDK3 | MTN BIKE | IN | 12 | Storage | BIKE PALLET | 2 | 7/5/2018 | 7/5/2018 | $500.00 | 24 | 0 | $12,000.00 | $12,000.00 | $0.00 | - | |
6 | CCCC3333 | - | KJHSDIU437 | BIKE SHOES | IN | 10 | Office | Case | 12 | 7/5/2018 | 7/5/2018 | $50.00 | 120 | 0 | $6,000.00 | $6,000.00 | $0.00 | - | |
7 | DDDD4444 | - | ALDFNS3448 | PEDALS | IN | 15 | Office | Case | 12 | 7/5/2018 | 7/5/2018 | $30.00 | 180 | 0 | $5,400.00 | $5,400.00 | $0.00 | - | |
8 | AAAA1111 | - | BSDFU49232 | FOX HELMET | OUT | 1 | Office | BOX 20x20x20 | 6 | 7/10/2018 | 7/10/2018 | $100.00 | 48 | 54 | $600.00 | $4,800.00 | $5,400.00 | $600.00 | |
9 | AAAA1111 | - | BSDFU49232 | FOX HELMET | OUT | 2 | Office | BOX 20x20x20 | 6 | 7/10/2018 | 7/10/2018 | $100.00 | 36 | 48 | $1,200.00 | $3,600.00 | $4,800.00 | $1,200.00 | |
10 | AAAA1111 | - | BSDFU49232 | FOX HELMET | OUT | 1 | Storage | BOX 20x20x20 | 6 | 7/15/2018 | 7/15/2018 | $100.00 | 30 | 36 | $600.00 | $3,000.00 | $3,600.00 | $600.00 | |
11 | BBBB2222 | - | JDYENJJDK3 | MTN BIKE | OUT | 4 | Storage | BIKE PALLET | 2 | 7/16/2018 | 7/16/2018 | $500.00 | 16 | 24 | $4,000.00 | $8,000.00 | $12,000.00 | $4,000.00 | |
12 | BBBB2222 | - | JDYENJJDK3 | MTN BIKE | IN | 4 | Office | BIKE PALLET | 2 | 7/16/2018 | 7/16/2018 | $500.00 | 24 | 16 | $4,000.00 | $12,000.00 | $8,000.00 | - | |
13 | |||||||||||||||||||
14 | |||||||||||||||||||
15 | |||||||||||||||||||
16 | |||||||||||||||||||
17 | |||||||||||||||||||
18 | |||||||||||||||||||
19 | |||||||||||||||||||
20 |