仓库管理系统带库存报表

北京市牛图文科技有限公司送货单,地址：XX区CC街道XX巷XXC号 电话：010-12388888NO:,客户名称：客户电话：制单人员：,客户地址：联 系 人：191210008送货日期：,序号产品名称规格单位数量单价（元）金额（元）备注白存根,红客户,黄回单,1.0商品编号规格单位数量单价不含税金额备 注,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,金额合计（大 写）：小写金额,注：以上货品请核对数量，如有质量问题，请在收货后3天内通知本公司。送货人： 收货人（签名）：,1、【产品资料】【供应商资料】【客户资料】中，录入相应资料,编码列一定不能为空,不要纯数字的编码,2、【进货录入】双击选择供应商,商品信息,通过按钮进行单据的保存,查询,修改,删除操作, 【销售录入】双击选择客户,商品信息,通过按钮进行单据的保存,查询,修改,删除操作, 【领用录入】双击选择客户,商品信息,通过按钮进行单据的保存,查询,修改,删除操作,3、【收款录入】双击选择日期,客户，其他手录, 【付款录入】双击选择日期,供应商，其他手录,4、【供应总览】点击查询，选择日期,自动生成应付汇总报表, 【供应对账】点击查询，选择日期和供应商,自动生成明细报表,5、【客户总览】点击查询，选择日期,自动生成应收汇总报表, 【客户对账】点击查询，选择日期和客户,自动生成明细报表,6、【出入库检索】用于检索出入库明细记录,7、【库存报表】录入起止日期,用于生成一定期间的出入库汇总表,,日期凭证单号出入类别收入发出结存,单价成本单价均价,系统设置,序号项目参数,1.0初始化密码888888,2.0送货单打印格式抬头名称北京市牛图文科技有限公司,3.0公司联系地址(打印格式)XX区CC街道XX巷XXC号,4.0公司联系电话(打印格式)010-12388888,2.0入库单号样式选择 (示例)→→191210001,3.0其中:入库单单号字段一(自定义,如JH),4.0 入库单单号字段二(日期格式),5.0 入库单号默认位数(样式),6.0,7.0销售单号样式选择 (示例)→→1912100001,8.0其中:销售单单号字段一(自定义,如XS),9.0 销售单单号字段二(日期格式),10.0 销售单号默认位数(样式),11.0,12.0领用单号样式选择 (示例)→→1912100001,13.0其中:领用单单号字段一(自定义,如XS),14.0 领用单单号字段二(日期格式),15.0 领用单号默认位数(样式),16.0,应 付 账 款 总 览,2019-12-1~2019-12-31金额单位：元,序号编号供货商上期应付账款余额本期应付本期已付方向期末余额,1.0GY0001供应商1贷,2.0GY0002供应商2,3.0GY0003供应商3,4.0GY0004供应商4,5.0GY0005供应商5,6.0GY0006供应商6,7.0GY0007供应商7,合计,应 付 明 细 账,编码：GY0001供应商:供应商12019-12-1~2019-12-31,年单号编号品名规格单位借方贷方方向余额备注,月日数量单价金额,上期结转平,J0076YJ19-0751159.11504425,J0077YJ19-0741165.486725661317.02626.8,J00781块块1096.460176991239.03865.8,J007945毛料16块7092.035398238014.011879.8,J0080CR12MOV毛料3475.221238943927.015806.8,J0081YJ19-077467.256637168528.016334.8,J0082YJ19-076472.566371681534.016868.8,J0083P20光板665.486725664752.017620.8,J00845739.823008856486.024106.8,J0085D2光板30块19587.610619522134.046240.8,J0076YJ19-0751159.1150442547550.6,J0077YJ19-0741165.486725661317.048867.6,J00781块块1096.460176991239.050106.6,J007945毛料16块7092.035398238014.058120.6,J0080CR12MOV毛料3475.221238943927.062047.6,J0081YJ19-077467.256637168528.062575.6,J0082YJ19-076472.566371681534.063109.6,J0083P20光板665.486725664752.063861.6,J00845739.823008856486.070347.6,J0085D2光板30块19587.610619522134.092481.6,B0037夹子2.017.535.092516.6,B0038印泥3.07.6666666666723.092539.6,B0039软面抄本10.08.080.092619.6,B0037夹子2.017.535.092654.6,B0038印泥3.07.6666666666723.092677.6,B0039软面抄本10.08.080.0,12月本月合计0.0,12月本年累计0.0,客户对账单,编码：C0005客户:客户52019-12-1~2019-12-31,年单号编号品名规格单位借方贷方方向余额备注,月日数量单价金额,上期结转平,S0096合金钻头14,S0094合金钻头72.05.811.630.2,J007312.9级内六角螺钉12*300.575.735.9,S0014口罩个17.00.2505510791374.2593683453240.16,C0004ER精密筒夹8uER25*1217.717.757.86,S0083螺纹胶瓶67.86,S0001锤把20.020.087.86,S0002两用扳手27CM把25.075.0162.86,S0003毛毛虫油瓶8.04.6666666666737.3333333333200.19,S0005毛毛虫油枪壶95.0950.0,12月本月合计1150.192701680.0,12月本年累计1150.192701680.0,应 收 账 款 总 览,2019-12-1~2019-12-31金额单位：元,序号编号客户名称上期应收余额本期应收本期已收方向期末余额,1.0C0001客户1,2.0C0002客户2,3.0C0003客户3,4.0C0004客户4,5.0C0005客户5借,6.0C0006生产部,7.0C0007后勤部,合计,日期编号供应商金额账户备注,日期编号客户金额账户备注,客户编号客户名称联系地址联系电话联系人期初余额,C0001客户1,C0002客户2,C0003客户3,C0004客户4,C0005客户5,C0006生产部,C0007后勤部,供应商编号供应商名称联系地址联系电话联系人期初余额,GY0001供应商1,GY0002供应商2,GY0003供应商3,GY0004供应商4,GY0005供应商5,GY0006供应商6,GY0007供应商7,仓库类别商品编号商品名称规格单位进价售价期初数量单价金额类别仓库,S0001锤原材料,S0002两用扳手27CM25.025.0,S0003毛毛虫油瓶30.04.66667140.0成品库,S0004红机油壶13.026.0产成品,S0005毛毛虫油枪壶95.095.0,S0006F2510.0,S0007F103.46.8,S0008F166.06.740.2,S0009F145.246.8,S0010F123.830.4,B0001针式打印机EPSON 820K 票据 发票 送货单台1650.01650.0,Q000184消毒液瓶5.3312542.65,Q0002洁厕刷7.1221.36,Q0003洁厕刷8.98.9,Q0004马桶刷9.929.7,Q0005油漆笔2.9166666666726.25,Q0006扫把10.7532.25,S0011锂基润滑油桶120.0360.0,S0012液压油桶280.0840.0,Q0007塑料刷,Q0008钢丝球14.00.93333428571413.06668,Q0009加厚垃圾袋卷77.00.74857.596,Q0010拖把头10.0,B0002透明封箱带卷4.3835.04,S0013非成品油石油制品*切削液升18.013.2744388889238.9399,B0003美工刀片4.5,B0004双头油性笔红29.019.14,B0005双头油性笔蓝28.018.48,B0006双头油性笔黑27.017.82,B0007美工刀6.02.4814.88,B0008电脑连接头70.00.3524.5,B00095米拖线板60.360.3,B001010米拖线板89.3289.32,牛图文科技有限公司入库单当前日期43809.0GY0007A,当前单号14.0,供应商：开单日期:2019-12-10单据编号:191210014默认行数10.0,地 址:电 话：联 系 人：,序号商品编号名称规格单位数量单价不含税金额税率税额含税金额备 注,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,合 计人民币(大写) 零元(小写):,备 注,负责人：采购：经办人：制单人：小红,牛图文科技有限公司销售单当前日期43809.0GY001备注类别订货号,, 合同编号：地址：牛图文省高新开发区幸福大道8号当前单号8.0,收货单位：开单日期:2019-12-10单据编号:191210008默认行数10.0,地 址:电 话：联 系 人：,序号商品编号名称规格单位数量单价不含税金额税率税额含税金额备 注,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,合 计人民币(大写) 零元(小写):,备 注,收货人：送货人：制单人：小红,北京市牛图文科技有限公司入库单,地址：XX区CC街道XX巷XXC号 电话：010-12388888NO:,供 货 商：供货商电话：制单人员：,地 址：联 系 人：191210014收货日期：,序号产品名称规格单位数量单价（元）金额（元）备注白存根,红客户,黄回单,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,金额合计（大 写）：人民币(大写) 零元小写金额,注：以上货品请核对数量，如有质量问题，请在收货后3天内通知本公司。,牛图文科技有限公司领用单当前日期43809.0C0002GY001备注类别订货号,地址：牛图文省高新开发区幸福大道8号当前单号6.0,领用部门：开单日期:2019-12-10单据编号:191210006默认行数10.0,领 用 人:电 话：联 系 人：,序号商品编号名称规格单位数量单价不含税金额税率税额含税金额备 注,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,合 计人民币(大写) 零元(小写):,备 注,部门负责人：仓库：领用人：制单人：,日期单号单位编号往来单位地址电话联系人商品编号名称规格单位数量单价不含税金额税率税额含税金额明细备注总备注制单人类型,J0076YJ19-075150.6849557521309.8,J0077YJ19-074151.5132743361317.0,J00781块块142.5398230091239.0,J007945毛料16块921.964601778014.0,J0080CR12MOV毛料451.7787610623927.0,J0081YJ19-07760.7433628319528.0,J0082YJ19-07661.4336283186534.0,J0083P20光板86.5132743363752.0,J0084746.176991156486.0,J0085D2光板30块2546.3893805322134.0,J0076YJ19-075150.6849557521309.8,J0077YJ19-074151.5132743361317.0,J00781块块142.5398230091239.0,J007945毛料16块921.964601778014.0,J0080CR12MOV毛料451.7787610623927.0,J0081YJ19-07760.7433628319528.0,J0082YJ19-07661.4336283186534.0,J0083P20光板86.5132743363752.0,J0084746.176991156486.0,J0085D2光板30块2546.3893805322134.0,S0096合金钻头14,S0094合金钻头75.811.611.6,J007312.9级内六角螺钉12*300.575.75.7,S0014口罩个17.00.2505510791374.259368345324.25936834532,C0004ER精密筒夹8uER25*12,S0083螺纹胶瓶,S0001锤把,S0002两用扳手27CM把25.075.075.0,S0003毛毛虫油瓶4.6666666666737.333333333337.3333333333,S0005毛毛虫油枪壶95.0950.0950.0,B0037夹子17.5,B0038印泥7.66666666667,B0039软面抄本,B0037夹子17.5,B0038印泥7.66666666667,B0039软面抄本,,进销存报表,开始日期:43739.0,结束日期:43830.0,行号产品编号产品名称规格型号单位上期结存本期入库本期销售本期结存,均价成本利润,S0001锤,S0002两用扳手27CM75.075.0-2.0-50.0,S0003毛毛虫油瓶30.0140.04.6666666666737.333333333337.3333333333-3.5527136788e-14102.666666667,4.0S0004红机油壶,5.0S0005毛毛虫油枪壶95.010.095.0950.0950.0-9.0-855.0,S0006F25,7.0S0007F106.86.8,S0008F1640.240.2,S0009F1446.846.8,10.0S0010F1230.430.4,11.0B0001针式打印机EPSON 820K 票据 发票 送货单台1650.01650.0,12.0Q000184消毒液瓶42.6542.65,13.0Q0002洁厕刷21.3621.36,Q0003洁厕刷8.98.9,15.0Q0004马桶刷29.729.7,16.0Q0005油漆笔26.2526.25,17.0Q0006扫把32.2532.25,S0011锂基润滑油桶360.0360.0,19.0S0012液压油桶840.0840.0,Q0007塑料刷0.50.5,21.0Q0008钢丝球13.0666813.06668,Q0009加厚垃圾袋卷77.057.59677.057.596,23.0Q0010拖把头,24.0B0002透明封箱带卷35.0435.04,S0013非成品油石油制品*切削液升238.9399238.9399,B0003美工刀片4.54.5,B0004双头油性笔红19.1419.14,B0005双头油性笔蓝18.4818.48,B0006双头油性笔黑17.8217.82,30.0B0007美工刀14.8814.88,31.0B0008电脑连接头70.024.570.024.5,32.0B00095米拖线板60.360.3,33.0B001010米拖线板89.3289.32,合计:387.04075.392581082.333333331082.33333333-3.5527136788e-14365.02993.05924667,查询结果→→合计82118.123893810639.476106292757.6,查询条件↓↓日期单号单位编号往来单位地址电话联系人商品编号名称规格单位数量单价不含税金额税率税额含税金额明细备注总备注制单人类型,开始日期J0076YJ19-075150.6849557521309.8,结束日期J0077YJ19-074151.5132743361317.0,单据类型J00781块块142.5398230091239.0,单 号J007945毛料16块921.964601778014.0,往来单位J0080CR12MOV毛料451.7787610623927.0,货品编号J0081YJ19-07760.7433628319528.0,货品名称J0082YJ19-07661.4336283186534.0,J0083P20光板86.5132743363752.0,J0084746.176991156486.0,J0085D2光板30块2546.3893805322134.0,J0076YJ19-075150.6849557521309.8,J0077YJ19-074151.5132743361317.0,J00781块块142.5398230091239.0,J007945毛料16块921.964601778014.0,J0080CR12MOV毛料451.7787610623927.0,J0081YJ19-07760.7433628319528.0,J0082YJ19-07661.4336283186534.0,J0083P20光板86.5132743363752.0,J0084746.176991156486.0,J0085D2光板30块2546.3893805322134.0,B0037夹子2.017.5,B0038印泥3.07.66666666667,B0039软面抄本10.08.0,B0037夹子2.017.5,B0038印泥3.07.66666666667,B0039软面抄本10.08.0