feifarujingzhe
New Member
- Joined
- Jun 29, 2014
- Messages
- 2
I have problem updating my company's sales data. The ERP does not allow me to pull daily sales data and I have to calculate it manually everyday. I need to insert a new column daily. Is there a better way to update the sales data so that I can compare to the inventory data and make purchase decision? Thanks.
<tbody>
</tbody>
Item | Date | Sold Qty | Month | Week | Item | On-Hand Inventory | Average Demand | Order Qty | ||
A-01 | 1/3/2016 | 1 | 1 | 1 | A-01 | 100 | 8.25 | |||
A-02 | 1/3/2016 | 3 | 1 | 1 | A-02 | 37 | 11.75 | 11.75 | ||
A-03 | 1/3/2016 | 3 | 1 | 1 | A-03 | 88 | 10.25 | 10.25 | ||
A-04 | 1/3/2016 | 1 | 1 | 1 | A-04 | 65 | 10.25 | 10.25 | ||
A-05 | 1/3/2016 | 4 | 1 | 1 | A-05 | 89 | 5.5 | |||
A-06 | 1/3/2016 | 1 | 1 | A-06 | 87 | 10.25 | 10.25 | |||
B-01 | 1/3/2016 | 1 | 1 | 1 | B-01 | 69 | 11.75 | 11.75 | ||
B-02 | 1/3/2016 | 2 | 1 | 1 | B-02 | 119 | 11 | 11 | ||
B-03 | 1/3/2016 | 4 | 1 | 1 | B-03 | 112 | 7.75 | |||
C-01 | 1/3/2016 | 3 | 1 | 1 | C-01 | 194 | 11 | |||
C-02 | 1/3/2016 | 1 | 1 | C-02 | 103 | 10.25 | 10.25 | |||
C-03 | 1/3/2016 | 1 | 1 | 1 | C-03 | 69 | 8.75 | 8.75 | ||
C-04 | 1/3/2016 | 3 | 1 | 1 | C-04 | 68 | 10.25 | 10.25 | ||
C-05 | 1/3/2016 | 1 | 1 | 1 | C-05 | 47 | 8.75 | 8.75 | ||
A-01 | 1/4/2016 | 1 | 1 | |||||||
A-02 | 1/4/2016 | 4 | 1 | 1 | Today's Date | Tuesday, October 25, 2016 | ||||
A-03 | 1/4/2016 | 1 | 1 | Week Number | 44 | |||||
A-04 | 1/4/2016 | 2 | 1 | 1 | Previous Week | 43 | ||||
A-05 | 1/4/2016 | 2 | 1 | 1 | 42 | |||||
A-06 | 1/4/2016 | 1 | 1 | 1 | 41 | |||||
B-01 | 1/4/2016 | 4 | 1 | 1 | 40 | |||||
Item | New data need to be inserted daily | 1/3/2016 | 1/4/2016 | 1/5/2016 | 1/6/2016 | 1/7/2016 | 1/10/2016 | 1/11/2016 | 1/12/2016 | 1/13/2016 |
A-01 | 1 | 3 | 3 | 2 | 3 | 4 | ||||
A-02 | 3 | 4 | 1 | 3 | 2 | 2 | 1 | 2 | ||
A-03 | 3 | 4 | 4 | 1 | 4 | 4 | 4 | |||
A-04 | 1 | 2 | 4 | 3 | 3 | 1 | 2 | 1 | ||
A-05 | 4 | 2 | 2 | 3 | 1 | 4 | ||||
A-06 | 1 | 4 | 2 | 1 | 1 | 1 | 2 | 4 | ||
B-01 | 1 | 4 | 2 | 2 | 2 | 1 | 2 | |||
B-02 | 2 | 3 | 2 | 3 | 4 | 1 | 3 | 4 | ||
B-03 | 4 | 2 | 4 | 2 | 4 | 2 | 2 | 2 | ||
C-01 | 3 | 2 | 3 | 3 | 3 | 1 | ||||
C-02 | 4 | 2 | 4 | 4 | 3 | |||||
C-03 | 1 | 2 | 1 | 2 | 2 | 1 | 3 | 2 | ||
C-04 | 3 | 3 | 2 | 3 | 4 | 1 | ||||
C-05 | 1 | 3 | 2 | 2 |
<tbody>
</tbody>
Last edited: