,全自動(dòng)化管理進(jìn)銷存明細(xì)表,,,,,,,,,,,,,,,

,單品進(jìn)銷存明細(xì)查詢,,,,襪子,,,,進(jìn)銷存合計(jì)匯總,,,,,,,

,初始庫存,,20,,初始金額,,2000,,初始庫存,,86,,初始金額,,8734,

,入庫數(shù)量,,500,,入庫金額,,50000,,入庫數(shù)量,,2006,,入庫金額,,203614,

,出庫總量,,500,,出庫金額,,75000,,出庫總量,,2006,,出庫金額,,303914,

,剩余總量,,20,,剩余金額,,2000,,剩余總量,,86,,剩余金額,,8734,

,序號(hào),品名,"單位

規(guī)格",原庫存,,,入庫,,,出庫,,,現(xiàn)庫存,,,備注

,,,,單價(jià),數(shù)量,金額,單價(jià),數(shù)量,金額,單價(jià),數(shù)量,金額,單價(jià),數(shù)量,金額,

,1,襪子,****,100,20,2000,100,500,50000,150,500,75000,100,20,2000,

,2,香皂,****,101,21,2121,101,501,50601,151,501,75651,101,21,2121,

,3,鉛筆,****,102,22,2244,102,502,51204,152,502,76304,102,22,2244,

,4,充電器,****,103,23,2369,103,503,51809,153,503,76959,103,23,2369,

,5,,,,,0,,,0,,,0,104,0,0,

,6,,,,,0,,,0,,,0,105,0,0,

,7,,,,,0,,,0,,,0,106,0,0,

,8,,,,,0,,,0,,,0,107,0,0,

,9,,,,,0,,,0,,,0,108,0,0,

,10,,,,,0,,,0,,,0,,0,0,

,11,,,,,0,,,0,,,0,,0,0,

,12,,,,,0,,,0,,,0,,0,0,

,13,,,,,0,,,0,,,0,,0,0,

,14,,,,,0,,,0,,,0,,0,0,

,15,,,,,0,,,0,,,0,,0,0,

,16,,,,,0,,,0,,,0,,0,0,

,17,,,,,0,,,0,,,0,,0,0,

,18,,,,,0,,,0,,,0,,0,0,

,19,,,,,0,,,0,,,0,,0,0,

,20,,,,,0,,,0,,,0,,0,0,

,21,,,,,0,,,0,,,0,,0,0,

,22,,,,,0,,,0,,,0,,0,0,

,23,,,,,0,,,0,,,0,,0,0,

,24,,,,,0,,,0,,,0,,0,0,

,25,,,,,0,,,0,,,0,,0,0,

,26,,,,,0,,,0,,,0,,0,0,

,27,,,,,0,,,0,,,0,,0,0,

,28,,,,,0,,,0,,,0,,0,0,

,29,,,,,0,,,0,,,0,,0,0,

,30,,,,,0,,,0,,,0,,0,0,

,31,,,,,0,,,0,,,0,,0,0,

,32,,,,,0,,,0,,,0,,0,0,

,33,,,,,0,,,0,,,0,,0,0,

,34,,,,,0,,,0,,,0,,0,0,

,35,,,,,0,,,0,,,0,,0,0,

,36,,,,,0,,,0,,,0,,0,0,

,37,,,,,0,,,0,,,0,,0,0,

,38,,,,,0,,,0,,,0,,0,0,

,39,,,,,0,,,0,,,0,,0,0,

,40,,,,,0,,,0,,,0,,0,0,

,41,,,,,0,,,0,,,0,,0,0,

,42,,,,,0,,,0,,,0,,0,0,

,43,,,,,0,,,0,,,0,,0,0,

,44,,,,,0,,,0,,,0,,0,0,

,45,,,,,0,,,0,,,0,,0,0,

,46,,,,,0,,,0,,,0,,0,0,

,47,,,,,0,,,0,,,0,,0,0,

,48,,,,,0,,,0,,,0,,0,0,

,49,,,,,0,,,0,,,0,,0,0,

,50,,,,,0,,,0,,,0,,0,0,

,51,,,,,0,,,0,,,0,,0,0,

,52,,,,,0,,,0,,,0,,0,0,

,53,,,,,0,,,0,,,0,,0,0,

,54,,,,,0,,,0,,,0,,0,0,

,55,,,,,0,,,0,,,0,,0,0,

,56,,,,,0,,,0,,,0,,0,0,

,57,,,,,0,,,0,,,0,,0,0,

,58,,,,,0,,,0,,,0,,0,0,

,59,,,,,0,,,0,,,0,,0,0,

,60,,,,,0,,,0,,,0,,0,0,

,61,,,,,0,,,0,,,0,,0,0,

,62,,,,,0,,,0,,,0,,0,0,

,63,,,,,0,,,0,,,0,,0,0,

,64,,,,,0,,,0,,,0,,0,0,

,65,,,,,0,,,0,,,0,,0,0,

,66,,,,,0,,,0,,,0,,0,0,

,67,,,,,0,,,0,,,0,,0,0,

,68,,,,,0,,,0,,,0,,0,0,

,69,,,,,0,,,0,,,0,,0,0,

,70,,,,,0,,,0,,,0,,0,0,

,71,,,,,0,,,0,,,0,,0,0,

,72,,,,,0,,,0,,,0,,0,0,

,73,,,,,0,,,0,,,0,,0,0,

,74,,,,,0,,,0,,,0,,0,0,

,75,,,,,0,,,0,,,0,,0,0,

,76,,,,,0,,,0,,,0,,0,0,

,77,,,,,0,,,0,,,0,,0,0,

,78,,,,,0,,,0,,,0,,0,0,

,79,,,,,0,,,0,,,0,,0,0,

,80,,,,,0,,,0,,,0,,0,0,

,81,,,,,0,,,0,,,0,,0,0,

,82,,,,,0,,,0,,,0,,0,0,

,83,,,,,0,,,0,,,0,,0,0,

,84,,,,,0,,,0,,,0,,0,0,

,85,,,,,0,,,0,,,0,,0,0,

,86,,,,,0,,,0,,,0,,0,0,

,87,,,,,0,,,0,,,0,,0,0,

,88,,,,,0,,,0,,,0,,0,0,

,89,,,,,0,,,0,,,0,,0,0,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,