簡易Excel庫存管理表格

,,,,,,,查詢日期

,,,,,,,2018/11/5

序號,品類,貨品名稱,入庫,出庫,結余,,

1,PA66,AG5FRC4BK,50,0,50,,

2,PA66,A3V0NC1102/H,20,0,20,,

3,PA66,10G3201,0,0,0,,

4,PA66,20G6201,0,0,0,,

5,PA66,21G3202,0,0,0,,

6,PA66,21G6202,0,0,0,,

7,PA66,6410G5AWT1,50,0,50,,

8,PBT,1100-211M,250,0,250,,

9,PBT,1100-211LC1,0,0,0,,

10,PBT,1100-600S（漳州產）,2450,0,2450,,

11,PBT,1100-600S（常熟產）,2900,0,2900,,

12,PBT,1403G6GNC6,100,0,100,,

13,PBT,2100-104B,0,0,0,,

14,PBT,3015-104,500,25,475,,

15,PBT,3015-200S,0,0,0,,

16,PBT,3015-200XS,0,0,0,,

18,PBT,3015-201,2075,75,2000,,

17,PBT,3015-205S,2000,1500,500,,

19,PBT,3020-104,0,0,0,,

20,PBT,3020-201,0,0,0,,

21,PBT,3030-104,0,0,0,,

22,PBT,3030-104(臺灣產）,0,0,0,,

23,PBT,3030-201,3000,1000,2000,,

25,PBT,3316ED3002BLACK,0,0,0,,

24,PBT,3030-200S,25,0,25,,

26,PBT,3316EF2001ATURAKL,0,0,0,,

27,PBT,4115-104F,0,0,0,,

28,PBT,4115-226U,0,0,0,,

29,PBT,4115-226U25,1750,0,1750,,

30,PBT,4130-104F,4300,0,4300,,

31,PBT,4130-134W,5,0,5,,

32,PBT,4130-202F,1000,0,1000,,

33,PBT,4130FBGW,225,0,225,,

34,PBT,4130FNGW,0,0,0,,

55,PBT,8730BKK,0,0,0,,

47,PBT,4830BKF,450,0,450,,

40,PBT,4815NCF,3300,1000,2300,,

35,PBT,4815BK,21490,0,21490,,

39,PBT,4815NCB,3325,0,3325,,

50,PBT,4830NCB,125,25,100,,

48,PBT,4830BKK（常熟產）,300,0,300,,

52,PBT,4830NKK,0,0,0,,

37,PBT,4815BKF,6850,0,6850,,

45,PBT,4830BK,1000,1000,0,,

46,PBT,4830BK（常熟產）,875,0,875,,

57,PBT,DS30EF2001ATURAI,0,0,0,,

59,電木粉,T375HF,0,0,0,,

49,PBT,4830BKK（臺灣產）,275,0,275,,

51,PBT,4830NCF,75,25,50,,

38,PBT,4815BKF（廢料),4275,0,4275,,

36,PBT,4815BK（臺灣產）,6975,0,6975,,

41,PBT,4820BK,3190,0,3190,,

42,PBT,4820BKK,3000,0,3000,,

43,PBT,4820NCB,2000,0,2000,,

44,PBT,4820NCT,2750,0,2750,,

53,PBT,5630F-105A,0,0,0,,

54,PBT,6730BK6,0,0,0,,