进销存管理系统完美版

进销存管理系统完美版基础信息设置进销存管理对账单利润统计应收应付管理供应商信息 表 关于同志近三年现实表现材料材料类招标技术评分表图表与交易pdf视力表打印pdf用图表说话 pdf 进货明细产品库存查询付款明细表客户信息表销售明细供应商对账单收款明细表产品信息表产品库存客户对账单应付账款统计急需进货物品表应收账款统计收支利润统计使用 说明 关于失联党员情况说明岗位说明总经理岗位说明书会计岗位说明书行政主管岗位说明书 供应商联系电话地址上期尾款N11359862北京朝阳区N21359863北京朝阳区N31359864北京朝阳区N41359865北京朝阳区N51359866北京朝阳区N61359867北京朝阳区N71359868北京朝阳区客户名称电话地址上期尾款赵11325628天津市和平区001号赵21325629天津市和平区002号赵31325630天津市和平区003号赵41325631天津市和平区004号赵51325632天津市和平区005号产品编码类别产品名称产品规格货架进货价格销售价格B001清洁类化妆品清洁霜50ML1货架4060B002清洁类化妆品清洁霜100ML1货架70100B003清洁类化妆品洗面奶50ML1货架3050B004清洁类化妆品洗面奶100ML1货架50100B005清洁类化妆品洗发剂200ML1货架3060B006清洁类化妆品洗发剂400ML1货架50100B007清洁类化妆品沐浴露200ML1货架2040B008清洁类化妆品沐浴露400ML1货架3670B009基础化妆品化妆水100ML2货架50100B010基础化妆品化妆水200ML2货架80150B011基础化妆品面霜50ML2货架80150B012基础化妆品面霜100ML3货架150270B013基础化妆品面膜10片3货架70150B014基础化妆品发胶50ML3货架80150B015基础化妆品发乳50ML3货架80150B016美容化妆品口红10G4货架120200B017美容化妆品眼影10G4货架100180B018美容化妆品胭脂10G4货架60100B019美容化妆品指甲油10Ml4货架3050B020美容化妆品指甲油10Ml4货架4590辅助列日期产品编码类别产品名称产品规格位置价格数量金额入库人供应商联系电话2-42675B001清洁类化妆品清洁霜50ML1货架4010400张三N1135986242675B002清洁类化妆品清洁霜100ML1货架7010700张三N2135986342675B003清洁类化妆品洗面奶50ML1货架3025750张三N3135986442675B004清洁类化妆品洗面奶100ML1货架50603000张三N4135986542675B005清洁类化妆品洗发剂200ML1货架30501500张三N5135986642675B006清洁类化妆品洗发剂400ML1货架50301500张三N6135986742675B007清洁类化妆品沐浴露200ML1货架20501000张三N713598689-42675B008清洁类化妆品沐浴露400ML1货架36602160张三N1135986242675B009基础化妆品化妆水100ML2货架50452250张三N2135986311-42684B002清洁类化妆品清洁霜100ML1货架70201400张三N1135986242684B003清洁类化妆品洗面奶50ML1货架3010300张三N2135986342684B004清洁类化妆品洗面奶100ML1货架50502500张三N3135986442684B005清洁类化妆品洗发剂200ML1货架3030900张三N4135986542684B006清洁类化妆品洗发剂400ML1货架505250张三N5135986642684B007清洁类化妆品沐浴露200ML1货架205100张三N61359867日期产品编码类别产品名称产品规格位置销售价格进货价格数量金额利润客户名称电话地址2-42671B001清洁类化妆品清洁霜50ML1货架604016020赵11325628天津市和平区001号42672B003清洁类化妆品洗面奶50ML1货架50306300120赵21325629天津市和平区002号42673B005清洁类化妆品洗发剂200ML1货架6030251500750赵31325630天津市和平区003号42674B008清洁类化妆品沐浴露400ML1货架7036214068赵41325631天津市和平区004号42675B013基础化妆品面膜10片3货架150702030001600赵51325632天津市和平区005号7-42676B017美容化妆品眼影10G4货架1801004072003200赵11325628天津市和平区001号42677B013基础化妆品面膜10片3货架15070101500800赵21325629天津市和平区002号42678B018美容化妆品胭脂10G4货架10060151500600赵31325630天津市和平区003号42679B019美容化妆品指甲油10Ml4货架503016800320赵41325631天津市和平区004号42680B010基础化妆品化妆水200ML2货架150805750350赵51325632天津市和平区005号12-42681B011基础化妆品面霜50ML2货架150805075003500赵11325628天津市和平区001号42682B012基础化妆品面霜100ML3货架2701502978303480赵21325629天津市和平区002号42683B013基础化妆品面膜10片3货架150703450240赵31325630天津市和平区003号42683B014基础化妆品发胶50ML3货架150801522501050赵41325631天津市和平区004号产品编码类别产品编码产品规格位置期初库存入库数量出库数量进货价格库存数量库存金额最低库存是否低于最低库存B001清洁类化妆品清洁霜50ML1货架2101401144050是B002清洁类化妆品清洁霜100ML1货架03007030210050是B003清洁类化妆品洗面奶50ML1货架4356303399050是B004清洁类化妆品洗面奶100ML1货架0110050110550050否B005清洁类化妆品洗发剂200ML1货架1080253065195050否B006清洁类化妆品洗发剂400ML1货架13505036180050是B007清洁类化妆品沐浴露200ML1货架25502057114050否B008清洁类化妆品沐浴露400ML1货架66023664230450否B009基础化妆品化妆水100ML2货架274505072360030否B010基础化妆品化妆水200ML2货架36058031248030否B011基础化妆品面霜50ML2货架5905080972030是B012基础化妆品面霜100ML3货架4302915014210030是B013基础化妆品面膜10片3货架003370-33-231030是B014基础化妆品发胶50ML3货架001580-15-120030是B015基础化妆品发乳50ML3货架000800030是B016美容化妆品口红10G4货架0001200020是B017美容化妆品眼影10G4货架27040100-13-130020是B018美容化妆品胭脂10G4货架401560-11-66020是B019美容化妆品指甲油10Ml4货架601630-10-30020是B020美容化妆品指甲油10Ml4货架30045313520是00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000产品出入库数量及库存数量查询产品编码B001请输入要查询的产品编码产品名称清洁霜类别清洁类化妆品产品规格50ML位置1货架入库数量10出库数量1库存数量11供应商名称N1上期尾款0进货金额3960已付金额7000本期尾款-3040商品交易明细表付款明细日期产品编码类别产品名称产品规格价格数量金额日期金额付款人2-11"月"1"日"B001清洁类化妆品清洁霜50ML4010400311"月"1"日"5000王19-11"月"1"日"B008清洁类化妆品沐浴露400ML366021601011"月"8"日"2000王211-11"月"10"日"B002清洁类化妆品清洁霜100ML7020140000000000000000000000000000000000000000000000000000000000000000000000000000000000000000客户姓名赵1上期尾款0进货金额14760已付金额8000本期尾款6760商品交易明细表收款明细表日期产品编码类别产品名称产品规格销售价格数量金额日期金额付款人12-11716B011基础化妆品面霜50ML1505075003111174000赵17-11216B017美容化妆品眼影10G1804072008116174000赵12-102816B001清洁类化妆品清洁霜50ML6016000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000产品编码类别产品名称产品规格进货价格库存数量最低库存B020美容化妆品指甲油10Ml45320B019美容化妆品指甲油10Ml30-1020B018美容化妆品胭脂10G60-1120B017美容化妆品眼影10G100-1320B016美容化妆品口红10G120020B015基础化妆品发乳50ML80030B014基础化妆品发胶50ML80-1530B013基础化妆品面膜10片70-3330B012基础化妆品面霜100ML1501430B011基础化妆品面霜50ML80930B006清洁类化妆品洗发剂400ML503650B003清洁类化妆品洗面奶50ML303350B002清洁类化妆品清洁霜100ML703050B001清洁类化妆品清洁霜50ML40115010月份销售分析表库存货物金额11月份利润产品编码利润排名销量排名1948915140B00120414B002050511月份进货金额11月份销售金额B0031202621871032780B0040505B0057501251B0060505B0070505B00868323B0090505B0100505B0110505B0120505B0130505B0140505B0150505B0160505B0170505B0180505B0190505B0200505000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000付款明细表日期供应商金额付款人343040N15000王143041N24000王143042N34000王143043N44000王143044N55000王143045N66000王143046N75000王11043047N12000王243048N31000王243049N55000王2收款明细日期客户名称金额付款人343040赵14000赵143041赵24000赵243042赵31000赵343043赵41000赵443044赵51000赵5843045赵14000赵143046赵24000赵243047赵31000赵343048赵41000赵443049赵51000赵5应付统计表供应商进货金额已付金额应付金额N139607000-3040N232504000-750N332505000-1750N439004000-100N5175010000-8250N616006000-4400N710005000-4000000000000000000000000000000000000000000000000000000000000应收统计表客户名称销售金额已付金额应收金额赵11476080006760赵2963080001630赵3345020001450赵4319020001190赵5375020001750000000000000000000000000000000000000000000000000000000000000000使用说明1需要先在产品信息表中录入各种物料的编码类别名称规格货架进货价格及销售价格2在客户信息表中录入客户账号销售途径客户名称电话地址3在供应商信息表中录入供应商名称电话地址4入库明细按照所列内容录入日期编码数量入库人供应商其他可以自动显示即可若需要增加 记录 混凝土 养护记录下载土方回填监理旁站记录免费下载集备记录下载集备记录下载集备记录下载 的项目在后面自行添加即可5出库明细中按照所列内容录入日期编码数量客户账号其他可以自动显示即可若需要增加记录的项目在后面自行添加即可6产品库存表中需列出所有的产品编码并填入期初库存和最低库存其他内容自动生成7产品查询需要输入编码可查询所有信息8收支利润分析表中会自动统计库存货物的金额价格按进货价计算输入月份分可以自动统计出该月的进货金额销售金额及利润9客户对账表中只要输入客户的账号名称则该客户的销售明细自动弹出供应商对账表只要输入供应商的名称则该供应商的进货明细自动弹出10在付款明细表中逐项填写付款明细在收款明细表中逐项填写收款明细11在应付统计表中输入供应商名称在应收统计表中输入客户名称其他内容自动生成12急需进货物品统计表中当库存数量小于最低库存时则该物品信息自动汇总到急需进货物品统计表中无须录入任何内容13本报表为年表每年更换一次即可注意本表使用时请选中没有公式的单元格-右键-清除内容后再填入新的数据请勿删除行或列也不要随意插入行或列若表中自动显示的地方的公式不够请自行下拉即可售后服务仅限于在稻壳稻米等直接付款购买如需售后请勿使用免单等途径购买