倉庫原料、輔料進銷存表模版(內(nèi)含公式)_第1頁
倉庫原料、輔料進銷存表模版(內(nèi)含公式)_第2頁
倉庫原料、輔料進銷存表模版(內(nèi)含公式)_第3頁
倉庫原料、輔料進銷存表模版(內(nèi)含公式)_第4頁
倉庫原料、輔料進銷存表模版(內(nèi)含公式)_第5頁
已閱讀5頁，還剩16頁未讀， 繼續(xù)免費閱讀

下載本文檔

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進行舉報或認領(lǐng)

文檔簡介

1、ExcelExcel進進銷銷存存記記賬賬本本 V1.0V1.0當前庫存出庫記錄進庫記錄第 2 頁，共 21 頁JR-QR-WH-004A庫存表（物料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日期：2012年4月份編號規(guī) 格 名 稱幣種現(xiàn)在單價加權(quán)價上期單價單位 期初數(shù)量本月入庫本月出庫庫存金 額101101日日用用品品RMBRMB0 00 0張張0 00 00 000.000.001010110101紙紙巾巾RMBRMB0 0- - -包包0 010103 370.000.001010210102潔潔柔柔紙紙巾巾RMBRMB0 0- -包包0 03 30 030.000

2、.001010310103空空氣氣清清閑閑劑劑RMBRMB0 00 0瓶瓶0 00 00 000.000.001010410104飯飯盒盒RMBRMB0 00 0個個0 00 00 000.000.001010510105電電熱熱水水壺壺RMBRMB0 0- -個個0 02 21 110.000.00201201辦辦公公用用品品RMBRMB0 00 00 00 00 000.000.002010120101A4A4打打印印紙紙RMBRMB0 00 0包包0 00 00 000.000.002010220102入入庫庫單單RMBRMB0 00 0本本0 00 00 000.000.0020103

3、20103出出庫庫單單RMBRMB0 00 0本本0 00 00 000.000.002010420104筆筆記記本本RMBRMB0 00 0本本0 00 00 000.000.003 30101電電工工用用品品RMBRMB0 00 00 00 00 000.000.003 301010101電電線線RMBRMB0 00 0米米0 00 00 000.000.003 301020102鎖鎖RMBRMB0 00 0把把0 00 00 000.000.003010330103螺螺絲絲RMBRMB0 00 0個個0 00 00 000.000.00401401勞勞保保用用品品RMBRMB0 00 0

4、0 00 00 000.000.004010140101手手套套RMBRMB0 00 0盒盒0 00 00 000.000.004010240102口口罩罩RMBRMB0 00 0盒盒0 00 00 000.000.004010340103工工衣衣RMBRMB0 00 0條條0 00 00 000.000.005 50101包包裝裝物物RMBRMB0 00 00 00 00 000.000.005 501010101三三節(jié)節(jié)袋袋RMBRMB0 00 0包包0 00 00 000.000.005 501020102P PE E膠膠膜膜RMBRMB0 00 0公公斤斤0 00 00 000.000

5、.005010350103彩彩膜膜RMBRMB0 00 0張張0 00 00 000.000.005010450104珍珍珠珠棉棉RMBRMB0 00 0捆捆0 00 00 000.000.005010550105亞亞克克力力盒盒RMBRMB0 00 0個個0 00 00 000.000.00601601工工具具模模具具RMBRMB0 00 00 00 00 000.000.006 601010101模模坯坯RMBRMB0 00 0塊塊0 00 00 000.000.006 601020102模模具具RMBRMB0 00 0件件0 00 00 000.000.007 70101輔輔助助材材料料

6、RMBRMB0 00 00 00 00 000.000.007 701010101研研磨磨液液RMBRMB0 00 0桶桶0 00 00 000.000.007 701020102墨墨水水RMBRMB0 00 0瓶瓶0 00 00 000.000.00801801固固定定資資產(chǎn)產(chǎn)RMBRMB0 00 00 00 00 000.000.008 801010101精精軋軋機機RMBRMB0 00 0臺臺0 00 00 000.000.008 801020102拋拋光光機機RMBRMB0 00 0臺臺0 00 00 000.000.009 90101動動力力、燃燃氣氣RMBRMB0 00 00 00

7、 00 000.000.009010190101煤煤氣氣RMBRMB0 00 0瓶瓶0 00 00 000.000.009 901020102氧氧氣氣RMBRMB0 00 0瓶瓶0 00 00 000.000.009 901030103乙乙炔炔RMBRMB0 00 0瓶瓶0 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.00

8、0.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00返回主界面第 3 頁，共 21 頁JR-QR-WH-

9、004A庫存表（物料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日期：2012年4月份編號規(guī) 格 名 稱幣種現(xiàn)在單價加權(quán)價上期單價單位 期初數(shù)量本月入庫本月出庫庫存金 額返回主界面RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00

10、 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00

11、 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00

12、 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00

13、 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00

14、 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00第 4 頁，共 21 頁JR-QR-WH-004A庫存表（物料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日期：2012年4月份編號規(guī) 格 名 稱幣種現(xiàn)在單價加權(quán)價上期單價單位 期初數(shù)量本月入庫本月出庫庫存金 額返回主界面RMBRMB0 00 00 00

15、00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00

16、00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00

17、00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00

18、00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00 00 000.000.00RMBRMB0 00 00 00

19、00 000.000.00RMBRMB0 00 00 00 00 000.000.000 015154 411110.00審核：日期：第 5 頁，共 21 頁JR-QR-WH-004A備 注庫存表（物料）日期：2012年4月份第 6 頁，共 21 頁JR-QR-WH-004A備 注第 7 頁，共 21 頁JR-QR-WH-004A備 注2017/3/25page:出庫表（物料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日期：2017年2月份日期編號規(guī) 格 名 稱幣種單價單位 數(shù)量剩存金額領(lǐng)料人核準人部門領(lǐng)料單號10101紙巾RMB 0.00包370.00行政部20101A

20、4打印紙RMB 0包00.0030101電線RMB 0米00.0040101手套RMB 0盒00.0050101三節(jié)袋RMB 0包00.0060101模坯RMB 0塊00.0070101研磨液RMB 0桶00.0080101精軋機RMB 0臺00.0090101煤氣RMB 0瓶00.0090102氧氣RMB 0瓶00.0010103空氣清閑劑RMB 0瓶00.0010102潔柔紙巾RMB 0.00包30.0010104飯盒RMB 0個00.0010105電熱水壺RMB 0.00個110.00000000000000000000000000000000000000000返回主界page:返回主界

21、000000000000000000000000000000000000000000000000000000000page:返回主界000000000000000000000000000000000000page:預設(shè)部門備注部門辦辦公公室室廠廠辦辦業(yè)業(yè)務務部部設(shè)設(shè)計計部部財財務務部部采采購購部部油油壓壓車車間間制制模模車車間間彩彩印印車車間間軋軋制制車車間間品品質(zhì)質(zhì)部部倉倉儲儲物物流流部部技技術(shù)術(shù)部部1 12 23 34 4出庫表（物料）page:page:page:入入庫庫表表（物物料料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日日期期編編號號規(guī)規(guī)格格名名稱稱幣幣種

22、種單單價價單單位位數(shù)數(shù)量量金金額額（不不含含稅稅）金金額額（含含稅稅）10101紙巾RMB5.00包10050.0020101A4打印紙RMB0.00包00.0030101電線RMB0.00米00.0040101手套RMB盒00.0050101三節(jié)袋RMB包00.0060101模坯RMB塊00.0070101研磨液RMB桶00.0080101精軋機RMB臺00.0090101煤氣RMB瓶00.0090102氧氣RMB瓶00.0010103空氣清閑劑RMB瓶00.0010102潔柔紙巾RMB1.00包303.0010104飯盒RMB個00.0010105電熱水壺RMB15.00個2030.00R

23、MB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00.00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00返回主界面page:入入庫庫表表（物物料料）灰灰色色部部分分公公式式自自動動計計算算無無需需手手工工輸輸入入日日期期編編號號規(guī)規(guī)格格名名稱稱幣幣種種單單價價單單位位數(shù)數(shù)量量金金額額（不不含含稅稅）金金額額（含含稅稅）返回主界面RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00RMB00page:入入庫庫表表（物物料料）灰灰

溫馨提示

  • 1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預覽，若沒有圖紙預覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負責。
  • 6. 下載文件中如有侵權(quán)或不適當內(nèi)容，請與我們聯(lián)系，我們立即糾正。
  • 7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論