进销存（采购）管理系统.xlsx

《进销存（采购）管理系统.xlsx》由会员分享，可在线阅读，更多相关《进销存（采购）管理系统.xlsx（1031页珍藏版）》请在得力文库 - 分享文档赚钱的网站上搜索。

1、进销存（采购）管理系统使用说明出入库明细进销存明细库存汇总物料跟踪基本资料供应商信息采购订单使用说明出入库明细进销存明细库存汇总基本资料录入表序序号号 物物料料编编码码 ERPERP料料件件编编号号供供应应商商产产品品名名称称类类别别包包装装物物 单单位位 单单重重标标准准包包装装数数量量11000110000201-001xx公司样品1办公用品盒支100021000210000201-001xx公司样品1办公用品盒支100031000310000201-001xx公司样品1办公用品盒支100041000410000201-002xx公司样品2办公用品盒支100051000510000201-

2、003xx科技样品3电气设备箱台100061000610000201-003xx科技样品3电气设备箱台100071000710000201-003xx科技样品3电气设备箱台100081000810000201-004 xx公司样品4办公用品盒支100091000910000201-005xx公司样品5办公用品盒支1000101001010000201-005xx公司样品5办公用品盒支1000111213141516171819202122232425262728293031323334353637返回主界面38394041424344454647484950515253545556575859

3、606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721

4、731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722

5、73274275276277278279280281282283284285286287288289290291292293294295296297298299300最最大大容容量量( (件件) )启启用用盘盘点点数数量量存存放放区区最最低低存存量量最最高高存存量量备备 注注ERPERP品品名名100箱500A-1区10002000样品1100箱500A-1区10002000样品1100箱500A-1区10002000样品1100箱500A-2区10002000样品2100箱200A-3区10002000样品3100箱200A-3区10002000样品3100箱200A-3区10002000样

6、品350箱1000A-4区10002000样品450箱1000A-5区10002000样品550箱1000A-5区10002000样品5基本资料录入表ERPERP规规格格mmmmmmssaaaaaaaacccc供应商信息表序序号号供供应应商商名名称称供供应应商商简简称称主主要要负负责责人人姓姓名名负负责责人人职职位位1xxxx有限公司xx公司李总副经理2xx科技有限公司xx科技345678910111213141516171819202122232425262728返回主界面负负责责人人联联系系电电话话工工作作人人员员姓姓名名工工作作人人员员部部门门职职位位工工作作人人员员联联系系电电话话13

7、911112222小王销售部职员18711112222供应商信息表某公司采购订单明细物物料料编编码码产产品品名名称称ERPERP料料件件编编号号ERPERP品品名名ERPERP规规格格类类别别单单位位供供应应商商10001样品110000201-001样品1mm办公用品 支xx公司10002样品110000201-001样品1mm办公用品 支xx公司10003样品110000201-001样品1mm办公用品 支xx公司10004样品210000201-002样品2ss办公用品 支xx公司10005样品310000201-003样品3aa电气设备 台xx科技10006样品310000201-00

8、3样品3aa电气设备 台xx科技10007样品310000201-003样品3aa电气设备 台xx科技10008样品410000201-004样品4aa办公用品 支xx公司10009样品510000201-005样品5cc办公用品 支xx公司10010样品510000201-005样品5cc办公用品 支xx公司返回主界面日日期期单单据据号号码码订订购购数数量量 订订购购单单价价 订订购购总总额额备备注注8月1日 0000028910001.919008月2日 0000029010001.919008月3日 0000029110001.818008月4日 000002921000110008月5

9、日 0000029350500250008月6日 0000029440500200008月7日 0000029530500150008月8日 0000029610001.919008月9日 0000029710001.919000 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0某公司采购订单明细0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

10、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

11、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

12、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

13、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

14、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

15、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

16、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

17、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

18、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

19、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

20、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

21、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

22、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

23、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

24、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

25、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

26、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

27、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

28、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0

29、0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0某公司采购物料供应状况表序号物物料料编编码码老产品名称ERP料件编号ERP品名ERP规格类别单位标准包装数量供应商110001样品110000201-001 样品1mm办公用品支1000 xx公司210002样品110000201-001 样品1mm办公用品支1000 xx公司310003样品110000201-001 样品1mm办公用品支1000 xx公司410004样品210000201-002 样品2ss办公用

30、品支1000 xx公司510005样品310000201-003 样品3aa电气设备台1000 xx科技610006样品310000201-003 样品3aa电气设备台1000 xx科技710007样品310000201-003 样品3aa电气设备台1000 xx科技810008样品410000201-004 样品4aa办公用品支1000 xx公司910009样品510000201-005 样品5cc办公用品支1000 xx公司1010010样品510000201-005 样品5cc办公用品支1000 xx公司110120130140150160170180190200210220230240

31、250260270280290300310320330340返回主界面3503603703803904004104204304404504604704804905005105205305405505605705805906006106206306406506606706806907007107207307407507607707807908008108208308408508608708808909009109209309409509609709809901001011021031041051061071081091101111121131141151161171181191201211221

32、231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222

33、232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223

34、233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224

35、234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225

36、235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226

37、236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227

38、237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228

39、238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229

40、239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000上月计划未回数量本期已送数量未回数量退回数量采购数量仓库库存状态存放区备 注10030080001000800正常A-1区10001

41、10001000200正常A-1区100500600010001000正常A-1区100590510010001090超超订订A-2区105010050250超超订订A-3区0400040240超超订订A-3区0300030230超超订订A-3区1001001000010001100正常A-4区1010110101000500正常A-5区102010200500正常A-5区0000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常0

42、0000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常0某公司采购物料供应状况表0000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00

43、000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常00000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

44、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

45、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

46、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

47、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

48、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

49、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正

50、常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正常0000正