采购销售发票管理系统表

今天是:2019年12月31日【星期二】,基础信息发票业务收支业务发票检索收支检索报表查询使用说明, 使用说明：,1、《客户信息》《供应商信息》《商品信息》《其他信息》表中录入基础数据，用于其他表格选择使用。2、《进项发票》《付款单》用于核算采购业务，标题栏都有对应的新增，修改，删除按钮。3、《销项发票》《收款单》用于核算销售业务，标题栏都有对应的新增，修改，删除按钮。4、进项检索和销项检索可以进行发票明细数据的筛选。5、付款检索和收款检索可以进行收付明细数据的筛选。6、《应收多栏账》《应付多栏账》用于生成往来单位的账款、开票汇总记录。,,【应付多栏明细帐查询】2017-4-12017-4-302019-10-312019-12-31, (开始日期：2019-10-31 结束日期：2019-12-31) ,序号代码单位名称期初开票期初付款本期开具本期付款期末开票期末付款差额,1.0GYS001供应商1300000.0503050.0803050.0502050.0,2.0GYS002供应商21386.051386.051386.0,3.0GYS003供应商34269.054269.054269.0,4.0GYS004供应商4,5.0GYS005供应商5,6.0GYS006供应商6,7.0GYS007供应商7,8.0GYS008供应商8,9.0GYS009供应商9,10.0GYS010供应商10,合 计611517.24885230.01496747.24,【应收多栏明细帐查询】2019-1-12020-12-31, (开始日期：2019-1-1 结束日期：2020-12-31) ,序号代码单位名称期初开票期初收款本期开具本期收款期末开票期末收款差额,1.0KH001客户11000.058438.065000.059438.065000.0-5562.0,2.0KH002客户298558.2533262.298558.2533262.265296.05,3.0KH003客户393080.035415.593080.035415.557664.5,4.0KH004客户498342.081608.0618342.0601608.016734.0,5.0KH005客户553995.0178320.053995.0178320.0-124325.0,6.0KH006客户682000.0177262.082000.0177262.0-95262.0,7.0KH007客户753500.0245000.053500.0245000.0-191500.0,8.0KH008客户851000.0138800.051000.0138800.0-87800.0,9.0KH009客户970000.0249247.2570000.0249247.25-179247.25,10.0KH010客户10125000.086080.0125000.086080.038920.0,合 计521000.0783913.251289994.951304913.251809994.95,【进项发票检索】2019-1-12019-12-31,查询条件：开始日期：2019-1-1 结束日期：2019-12-31 供应商名称包含：供应商1,日期摘要代码往来单位发票种类发票号码代码商品名称规格型号单位类别数量单价金额备注,13526653,13526652,13526651,1422492576800.076800.0,14224924,1422492331200.031200.0,1422485633600.033600.0,1422485525650.025650.0,1422485442000.042000.0,14224853,1422485274000.074000.0,1422485119800.019800.0,合计12.0803050.0,【销项发票检索】2019-1-12019-12-30,查询条件：开始日期：2019-1-1 结束日期：2019-12-30,日期摘要代码往来单位发票种类发票号码代码商品名称规格型号单位类别数量单价金额备注,43802.01245706830000.030000.0,43802.01245706732000.032000.0,43808.0KH001客户11245706956640.056640.0,43811.01245707125247.2525247.25,43812.01245707236080.036080.0,43815.0KH004客户41245707371080.071080.0,KH005客户51245707548000.048000.0,KH006客户60023600282000.082000.0,43810.0KH007客户712457070,43810.0KH008客户800236001增项,KH009客户900236004,KH010客户100023600366500.066500.0,43818.0KH007客户7002360053500.03500.0,43819.0KH008客户80023600631000.031000.0,43819.0KH009客户900236008,43825.0KH010客户100023600958500.058500.0,43825.00023601027000.027000.0,43829.0KH004客户40023601127262.027262.0,KH005客户524217229技术服务5995.05995.0,KH001客户124217230技术服务1798.01798.0,43823.05078738141311.041311.0,合计21.0783913.25,【付款记录检索】2019-1-12019-12-31,查询条件：开始日期：2019-1-1 结束日期：2019-12-31,付款日期付款方式凭证号代码往来单位摘要付款金额,43470.0转帐GYS001供应商11000.0,合计1000.0,【收款记录检索】,查询条件： ,收款日期收款方式凭证号代码往来单位摘要收款金额,43803.0KH001客户115000.0,43804.0KH002客户225000.0,43804.0KH003客户319200.0,43808.0KH004客户410528.0,43809.0KH005客户528320.0,43810.0KH006客户627262.0,43812.0KH007客户795000.0,43812.0KH008客户8126000.0,43817.0KH009客户925247.25,43817.0KH010客户1036080.0,43818.0KH001客户150000.0,KH002客户28262.2,KH003客户316215.5,KH004客户471080.0,43822.0KH005客户5,KH006客户6,KH007客户7,KH008客户812800.0,43824.0KH009客户9224000.0,43824.0KH010客户1050000.0,合计1289994.95,【进项发票列表】,日期摘要代码往来单位发票种类发票号码代码商品名称规格型号单位类别数量单价金额备注,13526653,13526652,13526651,43763.0GYS002供应商2175522231100183130,43761.0GYS003供应商3057234621300191130,43766.0李振项目GYS004供应商4006500721300191160原材料120*30120000.0120000.0,1422492576800.076800.0,14224924,1422492331200.031200.0,1422485633600.033600.0,1422485525650.025650.0,1422485442000.042000.0,14224853,1422485274000.074000.0,1422485119800.019800.0,43778.0GYS002供应商20070215911001931301386.01386.0,43777.0GYS003供应商301318297电脑4269.04269.0电脑,43754.0GYS004供应商412087921物业费房租91517.2491517.24,耿凡项目GYS005供应商513696500,43779.0GYS006供应商6135528262250.02250.0,GYS007供应商701349516,GYS008供应商801349517,GYS009供应商90134951899365.099365.0,【销项发票列表】1,日期摘要代码往来单位发票种类发票号码代码商品名称规格型号单位类别数量单价金额备注,43802.01245706830000.030000.0,43802.01245706732000.032000.0,43808.0KH001客户11245706956640.056640.0,43811.01245707125247.2525247.25,43812.01245707236080.036080.0,43815.0KH004客户41245707371080.071080.0,KH005客户51245707548000.048000.0,KH006客户60023600282000.082000.0,43810.0KH007客户712457070,43810.0KH008客户800236001增项,KH009客户900236004,KH010客户100023600366500.066500.0,43818.0KH007客户7002360053500.03500.0,43819.0KH008客户80023600631000.031000.0,43819.0KH009客户900236008,43825.0KH010客户100023600958500.058500.0,43825.00023601027000.027000.0,43829.0KH004客户40023601127262.027262.0,KH005客户524217229技术服务5995.05995.0,KH001客户124217230技术服务1798.01798.0,43823.05078738141311.041311.0,【付款单列表】1,付款日期付款方式凭证号代码往来单位摘要付款金额,43470.0转帐GYS001供应商11000.0,【收款单列表】,收款日期收款方式凭证号代码往来单位摘要收款金额,43803.0KH001客户115000.0,43804.0KH002客户225000.0,43804.0KH003客户319200.0,43808.0KH004客户410528.0,43809.0KH005客户528320.0,43810.0KH006客户627262.0,43812.0KH007客户795000.0,43812.0KH008客户8126000.0,43817.0KH009客户925247.25,43817.0KH010客户1036080.0,43818.0KH001客户150000.0,KH002客户28262.2,KH003客户316215.5,KH004客户471080.0,43822.0KH005客户5,KH006客户6,KH007客户7,KH008客户812800.0,43824.0KH009客户9224000.0,43824.0KH010客户1050000.0,编号公司名称纳税人代码开户行名称银行账号联系人手机备注期初发票金额期初应付金额,GYS001供应商1300000.0,GYS002供应商2,GYS003供应商3,GYS004供应商4,GYS005供应商5,GYS006供应商6,GYS007供应商7,GYS008供应商8,GYS009供应商9,GYS010供应商10,编号公司名称纳税人代码开户行名称银行账号联系人手机备注期初发票金额期初收款金额,KH001客户1011000.0,KH002客户202,KH003客户303,KH004客户4520000.0520000.0,KH005客户5,KH006客户6,KH007客户7,KH008客户8,KH009客户9,KH010客户10,代码商品名称规格型号计量单位类别备注,001原材料120*30个原材料,002原材料210*5个原材料,003设备款2-9只库存商品,004劳务费人工,005工程款,006技术服务,007材料、设备款,008物业费房租,结算方式发票种类,转帐专用增票,汇票小规模票,承兑普通发票,现金运输发票