產(chǎn)品出入庫數(shù)據(jù)記錄表格模板

1、產(chǎn)產(chǎn)品品出出入入庫庫數(shù)數(shù)據(jù)據(jù)記記錄錄表表產(chǎn)產(chǎn)品品品品種種一一覽覽表表出出入入庫庫數(shù)數(shù)據(jù)據(jù)記記錄錄表表本本期期庫庫存存匯匯總總表表安安全全庫庫存存量量預(yù)預(yù)警警每每天天出出入入庫庫數(shù)數(shù)據(jù)據(jù)查查詢?cè)兏鞲髌菲贩N種出出入入庫庫數(shù)數(shù)據(jù)據(jù)統(tǒng)統(tǒng)計(jì)計(jì)某某食品產(chǎn)品品種一覽表編碼品種名稱與規(guī)格單位單價(jià)（元）A-001果蔬草莓125克盒￥4.80A-002果蔬黃桃125克盒￥5.60A-003果蔬原味125克盒￥9.00A-004果蔬獼猴桃125克盒￥10.80B-001酸乳酸乳無糖袋￥1.60B-002酸乳酸乳原味袋￥1.60C-001袋酸袋酸草莓袋￥21.00C-002袋酸袋酸高鈣袋￥21.00C-003袋酸袋酸

2、原味袋￥21.00D-001單果粒草莓125克條￥13.80D-002單果粒黃桃125克條￥12.80D-003單果粒蘆薈125克條￥16.00D-004單果粒獼猴桃125克條￥11.20E-001復(fù)合果粒復(fù)合草莓樹莓杯￥2.10E-002復(fù)合果粒復(fù)合黃桃芒果杯￥2.10E-003復(fù)合果粒復(fù)合蘆薈獼猴桃杯￥2.10F-001果粒250克果粒250克草莓瓶￥6.90F-002果粒250克果粒250克紅豆瓶￥6.50F-003果粒250克果粒250克藍(lán)莓瓶￥6.90F-004果粒250克果粒250克綠豆瓶￥6.50G-001可奇可奇草莓100克杯￥3.50G-002可奇可奇藍(lán)莓100克杯￥3.50

3、H-001普通杯雙株原味100克條￥8.80H-002普通杯無糖125克條￥12.50H-003普通杯原味100克條￥9.00H-004普通杯原味125克條￥11.50某某食品產(chǎn)品出入庫數(shù)據(jù)記錄表日日期期編編碼碼品品種種名名稱稱與與規(guī)規(guī)格格單單位位單單價(jià)價(jià)入入庫庫數(shù)數(shù)據(jù)據(jù)入入庫庫數(shù)數(shù)量量入入庫庫金金額額（元元）2013/5/1A-002果蔬黃桃125克盒5.615842013/5/1A-004果蔬獼猴桃125克盒10.85542013/5/1B-002酸乳酸乳原味袋1.650802013/5/1B-001酸乳酸乳無糖袋1.650802013/5/1C-002袋酸袋酸高鈣袋2151052013/

4、5/1B-002酸乳酸乳原味袋1.602013/5/1A-003果蔬原味125克盒902013/5/1D-002單果粒黃桃125克條12.8101282013/5/1E-001復(fù)合果粒復(fù)合草莓樹莓杯2.140842013/5/1D-001單果粒草莓125克條13.802013/5/1A-003果蔬原味125克盒910902013/5/2C-003袋酸袋酸原味袋2151052013/5/2D-003單果粒蘆薈125克條165802013/5/2F-003果粒250克果粒250克藍(lán)莓瓶6.910692013/5/2F-004果粒250克果粒250克綠豆瓶6.5201302013/5/2H-002普

5、通杯無糖125克條12.5562.52013/5/2D-002單果粒黃桃125克條12.802013/5/2F-003果粒250克果粒250克藍(lán)莓瓶6.902013/5/3D-004單果粒獼猴桃125克條11.2889.62013/5/3F-001果粒250克果粒250克草莓瓶6.915103.52013/5/3F-004果粒250克果粒250克綠豆瓶6.502013/5/3H-004普通杯原味125克條11.5101152013/5/3C-002袋酸袋酸高鈣袋2102013/5/3G-002可奇可奇藍(lán)莓100克杯3.520702013/5/3I-002普通杯原味125克條11.5101152

6、013/5/3E-001復(fù)合果粒復(fù)合草莓樹莓杯2.102013/5/3G-002可奇可奇藍(lán)莓100克杯3.502013/5/4D-004單果粒獼猴桃125克條11.202013/5/4D-001單果粒草莓125克條13.802013/5/4A-002果蔬黃桃125克盒5.602013/5/4B-001酸乳酸乳無糖袋1.602013/5/4C-002袋酸袋酸高鈣袋2102013/5/4B-002酸乳酸乳原味袋1.602013/5/5C-003袋酸袋酸原味袋2102013/5/5B-001酸乳酸乳無糖袋1.650802013/5/5D-001單果粒草莓125克條13.8202762013/5/5C

7、-002袋酸袋酸高鈣袋2102013/5/5B-002酸乳酸乳原味袋1.650802013/5/5A-002果蔬黃桃125克盒5.610562013/5/5A-003果蔬原味125克盒902013/5/6H-002普通杯無糖125克條12.502013/5/6H-003普通杯原味100克條910902013/5/6F-002果粒250克果粒250克紅豆瓶6.510652013/5/6D-003單果粒蘆薈125克條1602013/5/7E-003復(fù)合果粒復(fù)合蘆薈獼猴桃杯2.130632013/5/7H-004普通杯原味125克條11.502013/5/7H-003普通杯原味100克條954520

8、13/5/7F-002果粒250克果粒250克紅豆瓶6.502013/5/7F-001果粒250克果粒250克草莓瓶6.902013/5/7D-001單果粒草莓125克條13.802013/5/7I-002普通杯原味125克條11.502013/5/7I-001普通杯原味125克條11.5557.52013/5/7C-002袋酸袋酸高鈣袋2102013/5/8C-001袋酸袋酸草莓袋214842013/5/8C-002袋酸袋酸高鈣袋2102013/5/8G-002可奇可奇藍(lán)莓100克杯3.520702013/5/8I-001普通杯原味125克條11.502013/5/8I-002普通杯原味12

9、5克條11.502013/5/9E-003復(fù)合果粒復(fù)合蘆薈獼猴桃杯2.102013/5/9E-001復(fù)合果粒復(fù)合草莓樹莓杯2.120422013/5/9G-002可奇可奇藍(lán)莓100克杯3.502013/5/9B-001酸乳酸乳無糖袋1.602013/5/9I-001普通杯原味125克條11.502013/5/9A-002果蔬黃桃125克盒5.602013/5/10H-003普通杯原味100克條902013/5/10H-004普通杯原味125克條11.502013/5/10E-001復(fù)合果粒復(fù)合草莓樹莓杯2.102013/5/10D-003單果粒蘆薈125克條1602013/5/10A-004果

10、蔬獼猴桃125克盒10.80出出庫庫數(shù)數(shù)據(jù)據(jù)出出庫庫數(shù)數(shù)量量出出庫庫金金額額（元元）0000040641199005690000009115.210690018117051050020421552.5889.6569158440642425824200510500某某食品產(chǎn)品出入庫數(shù)據(jù)記錄表872562.5003480111.508521069101382230242024202236692042020702540223844.8141268923063232443.2某某某某食食品品各各品品種種出出入入庫庫數(shù)數(shù)據(jù)據(jù)統(tǒng)統(tǒng)計(jì)計(jì)表表編編碼碼品品種種入入庫庫數(shù)數(shù)據(jù)據(jù)出出庫庫數(shù)數(shù)據(jù)據(jù)入入庫庫數(shù)數(shù)量量入

11、入庫庫金金額額（元元）出出庫庫數(shù)數(shù)量量出出庫庫金金額額（元元）A-果蔬4028446343B-酸乳200320110176C-袋酸1429418378D-單果粒43573.642560.8E-復(fù)合果粒9018970147F-果粒250克55367.546307G-可奇4014035122.5H-普通杯4548540430I-桶裝0000數(shù)量某某某某食食品品每每天天產(chǎn)產(chǎn)品品出出入入庫庫數(shù)數(shù)據(jù)據(jù)查查詢?cè)儽肀碚?qǐng)請(qǐng)選選擇擇要要查查詢?cè)內(nèi)杖?013/5/3編碼品種產(chǎn)品名稱單位單價(jià)入庫數(shù)量 入庫金額 出庫數(shù)量A-001果蔬草莓125克盒4.8000A-002果蔬黃桃125克盒5.6000A-003果蔬原味

12、125克盒9000A-004果蔬獼猴桃125克盒10.8000B-001酸乳酸乳無糖袋1.6000B-002酸乳酸乳原味袋1.6000C-001袋酸袋酸草莓袋21000C-002袋酸袋酸高鈣袋21005C-003袋酸袋酸原味袋21000D-001單果粒草莓125克條13.8000D-002單果粒黃桃125克條12.8000D-003單果粒蘆薈125克條16000D-004單果粒獼猴桃125克條11.2889.60E-001復(fù)合果粒復(fù)合草莓樹莓杯2.10020E-002復(fù)合果粒復(fù)合黃桃芒果杯2.1000E-003復(fù)合果粒復(fù)合蘆薈獼猴桃杯2.1000F-001果粒250克果粒250克草莓瓶6.91

13、5103.50F-002果粒250克果粒250克紅豆瓶6.5000F-003果粒250克果粒250克藍(lán)莓瓶6.9000F-004果粒250克果粒250克綠豆瓶6.50018G-001可奇可奇草莓100克杯3.5000G-002可奇可奇藍(lán)莓100克杯3.5207015H-001普通杯雙株原味100克條8.8000H-002普通杯無糖125克條12.5000H-003普通杯原味100克條9000H-004普通杯原味125克條11.5101150出庫金額2013/5/102013/5/202013/5/302013/5/402013/5/502013/5/602013/5/702013/5/8105

14、2013/5/902013/5/1002013/5/1102013/5/1202013/5/1302013/5/14422013/5/1502013/5/1602013/5/1702013/5/1802013/5/1902013/5/201172013/5/2102013/5/2252.52013/5/2302013/5/2402013/5/2502013/5/2602013/5/272013/5/282013/5/292013/5/302013/5/31某某某某食食品品每每天天產(chǎn)產(chǎn)品品出出入入庫庫數(shù)數(shù)據(jù)據(jù)查查詢?cè)儽肀砟衬衬衬呈呈称菲繁颈酒谄趲鞄齑娲鎱R匯總總表表編編碼碼品品種種名名稱稱與與規(guī)規(guī)

15、格格單單位位單單價(jià)價(jià)期期初初庫庫存存入入庫庫數(shù)數(shù)據(jù)據(jù)出出庫庫數(shù)數(shù)據(jù)據(jù)數(shù)數(shù)量量金金額額數(shù)數(shù)量量金金額額數(shù)數(shù)量量金金額額A-001果蔬草莓125克盒￥4.805240000A-002果蔬黃桃125克盒￥5.60002527023248.4A-003果蔬原味125克盒￥9.001090109019171A-004果蔬獼猴桃125克盒￥10.80221.6554443.2B-001酸乳酸乳無糖袋￥1.600010016065104B-002酸乳酸乳原味袋￥1.60001001604572C-001袋酸袋酸草莓袋￥21.000048400C-002袋酸袋酸高鈣袋￥21.0012252510516336C

16、-003袋酸袋酸原味袋￥21.00005105242D-001單果粒草莓125克條￥13.80002027620276D-002單果粒黃桃125克條￥12.80225.6101389124.2D-003單果粒蘆薈125克條￥16.00116580580D-004單果粒獼猴桃125克條￥11.20008110.48110.4E-001復(fù)合果粒 復(fù)合草莓樹莓杯￥2.10006012650105E-002復(fù)合果粒 復(fù)合黃桃芒果杯￥2.10000000E-003復(fù)合果粒 復(fù)合蘆薈獼猴桃杯￥2.100030632042F-001果粒250克果粒250克草莓瓶￥6.900015103.51069F-002

17、果粒250克果粒250克紅豆瓶￥6.50001065852F-003果粒250克果粒250克藍(lán)莓瓶￥6.900010691069F-004果粒250克果粒250克綠豆瓶￥6.50002013018117G-001可奇可奇草莓100克杯￥3.50000000G-002可奇可奇藍(lán)莓100克杯￥3.50004014035122.5H-001普通杯雙株原味100克條￥8.80000000H-002普通杯無糖125克條￥12.5000562.5562.5H-003普通杯原味100克條￥9.00001513514126H-004普通杯原味125克條￥11.5000101159103.5本本期期結(jié)結(jié)存存數(shù)數(shù)

18、量量金金額額524211.219332.43556558848412136300338.4116001021001021534.52130021300517.5000019111.5某某某某食食品品本本期期庫庫存存匯匯總總表表安安全全庫庫存存量量預(yù)預(yù)警警表表公司名稱某某集團(tuán)制表時(shí)間制表部門品管部單位材材料料編編碼碼材材料料類類別別規(guī)規(guī)格格型型號(hào)號(hào)單單位位月月初初余余額額本本月月入入庫庫數(shù)數(shù)量量本本月月出出庫庫數(shù)數(shù)量量DZ0001電阻25支50022002333DZ0002電阻32支100009507864DZ0003電阻100支8201200902DZ0004電阻320支158010001290DZ0005電阻29支700551