库龄自动分析表01.xls_第1页
库龄自动分析表01.xls_第2页
库龄自动分析表01.xls_第3页
库龄自动分析表01.xls_第4页
库龄自动分析表01.xls_第5页
已阅读5页,还剩11页未读 继续免费阅读

下载本文档

版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领

文档简介

序号存货编码存货名称单位库别1-30天30-60天60-90天90-180天 180天-1年1年-3年3年以上合计 1 101160600200 - - - - 300,000.00 - - 300,000.00 2 201160600314 - - - - - - 302,640.00 302,640.00 3 301160603405 - - - - 126,800.00 - - 126,800.00 4 401180240121 - 350,000.00 - - - - - 350,000.00 5 5011802909 - - - - 400,000.00 - - 400,000.00 6 6011914059 - 5,000.00 - - - - - 5,000.00 7 70119140611 - 10,000.00 - - - - - 10,000.00 8 8050206033 - - - - - 10,000.00 - 10,000.00 9 905020603402 - - - - - 10,000.00 - 10,000.00 101005020603417 - - - - - 10,000.00 - 10,000.00 111105050115901 - 40,000.00 - - - - - 40,000.00 121205050115902 - 40,000.00 - - - - - 40,000.00 131305050115903 - 40,000.00 - - - - - 40,000.00 141405050115904 - 40,000.00 - - - - - 40,000.00 151505050115905 - 40,000.00 - - - - - 40,000.00 161605050115920 - 40,000.00 - - - - - 40,000.00 171705070155062 - - - - - 3,600.00 - 3,600.00 181805500202721 - - - - - 1,580.00 - 1,580.00 191905500203402 - - - - - 200.00 - 200.00 202005500203403 - - - - - 200.00 - 200.00 212105500203404 - - - - - 400.00 - 400.00 2222055004013 - - - - - 1,200.00 - 1,200.00 23230551020272 - - - - - 200.00 - 200.00 242405510203402 - - - - - 50.00 - 50.00 252505510203403 - - - - - 50.00 - 50.00 262605510203404 - - - - - 100.00 - 100.00 272705510401303 - - - - - 200.00 - 200.00 282805600200281 - - - - - 240.00 - 240.00 29290560020029 - - - - 800.00 - - 800.00 303005600200296 - - - - - 200.00 - 200.00 3131056040030 - - - - - 32.00 - 32.00 库龄自动分析表库龄自动分析表 2013年12月31日库龄分析基准日期: 序号存货编码存货名称单位库别1-30天30-60天60-90天90-180天 180天-1年1年-3年3年以上合计 库龄自动分析表库龄自动分析表 2013年12月31日库龄分析基准日期: 323205610200281 - - - - - 60.00 - 60.00 333305610200296 - - - - - 50.00 - 50.00 3434056140030 - - - - - 7.00 - 7.00 353509C735140201 - - - - - - 15,000.00 15,000.00 363609C786800101 - 200,000.00 - - - - - 200,000.00 373709C786800201 - 200,000.00 - - - - - 200,000.00 383809C786800301 - 300,000.00 - - - - 140,000.00 440,000.00 393909C796800101 - 150,000.00 - - - - 50,000.00 200,000.00 404009C796800201 - 200,000.00 - - - - - 200,000.00 414109C796800301 - 300,000.00 - - - - 140,000.00 440,000.00 424209C7A680101 - 200,000.00 - - - - 140,000.00 340,000.00 434309C7A680201 - 200,000.00 - - - - - 200,000.00 444409C7A680301 - 200,000.00 - - - - - 200,000.00 45453101036A - - - - - - 240.00 240.00 46463101043A 2,880.00 - - - - - - 2,880.00 47473101044A - - - - - - 144.00 144.00 48483101047A 432.00 - - - - - - 432.00 49493101071A - 120.00 - - - - - 120.00 50503101078A - 60.00 - - - - - 60.00 51513102001A - - - - - - 8,640.00 8,640.00 52523102002A 17,280.00 - - - - - 8,640.00 25,920.00 53533102003A - - - - - - 25,920.00 25,920.00 54543102021A - - - - - - 2,880.00 2,880.00 55553102022A 5,760.00 - - - - - 5,760.00 11,520.00 56563102023A 5,760.00 - - - - - 28,800.00 34,560.00 57573102028A - - - - - - 2,304.00 2,304.00 58583102058A - - - - - - 72.00 72.00 59593102532A - - - - - - 2,304.00 2,304.00 60603102533A 4,608.00 - - - - - - 4,608.00 61613102534A - - - - - - 4,608.00 4,608.00 62623102535A - - - - - - 1,152.00 1,152.00 序号存货编码存货名称单位库别1-30天30-60天60-90天90-180天 180天-1年1年-3年3年以上合计 库龄自动分析表库龄自动分析表 2013年12月31日库龄分析基准日期: 63633102536A 3,456.00 - - - - - 1,152.00 4,608.00 64643102537A - - - - - - 1,152.00 1,152.00 65653102576A - - - - - - 576.00 576.00 66663102577A - - - - - - 1,152.00 1,152.00 67673103152A - - - - - - 720.00 720.00 68683105002A 720.00 - - - - - 5,760.00 6,480.00 69693105003A 1,296.00 - - - - - - 1,296.00 70703105006A - - - - - - 1,440.00 1,440.00 71713106251A - - 12,024.00 - - - - 12,024.00 72723106253A - - 12,000.00 - - - - 12,000.00 73733106263A - - - - 4,824.00 - - 4,824.00 74743106461A - - 39,600.00 - 23,720.00 9,400.00 - 72,720.00 75753108016A - 6,912.00 - - - - - 6,912.00 76763108017A - - - - - - 4,608.00 4,608.00 77773108019A - - - - - - 3,456.00 3,456.00 78783108401A - - - - - - 5,760.00 5,760.00 79793108402A - - - - - - 17,280.00 17,280.00 80803203491A 72.00 - - - - - - 72.00 81813203801A - - 120.00 - - - - 120.00 82823204245A 72.00 - - - - - - 72.00 83833204361A 72.00 - - - - - - 72.00 84843204362A 36.00 - - - - - - 36.00 85853204555A 8,640.00 - - - - - 4,320.00 12,960.00 86863204566A - - - - - - 864.00 864.00 87873207039A - - - - - - 4,896.00 4,896.00 88883207131A - - 2,664.00 - - - - 2,664.00 89893207132A - - 4,356.00 - - - - 4,356.00 90903207133A - - 1,560.00 - - - - 1,560.00 91913207476A - - - - 23,720.00 7,800.00 - 31,520.00 92923207478A - - 10,944.00 - - - - 10,944.00 93933207482A - - - 6,240.00 - - - 6,240.00 序号存货编码存货名称单位库别1-30天30-60天60-90天90-180天 180天-1年1年-3年3年以上合计 库龄自动分析表库龄自动分析表 2013年12月31日库龄分析基准日期: 94943304113A - - 5,760.00 - - - - 5,760.00 95953304115A - - 15,840.00 - - - - 15,840.00 96963304116A - - 15,840.00 - - - - 15,840.00 97973304118A - - 5,760.00 - - - - 5,760.00 98983304119A - - 1,152.00 - - - - 1,152.00 99993304120A - - 2,880.00 - - - - 2,880.00 1001003304121A - - 7,200.00 - - - - 7,200.00 1011013304122A - - 4,320.00 - - - - 4,320.00 1021023304124A - - 4,464.00 - - - - 4,464.00 1031033304125A - - 9,216.00 - - - - 9,216.00 1041043304126A - 864.00 - - - - - 864.00 1051053501008A - - 1,080.00 - - - - 1,080.00 1061063501016A - - 3,600.00 - - - - 3,600.00 1071073501025A - - 36,000.00 - 1,440.00 - - 37,440.00 1081083602022A - 576.00 - - - - - 576.00 1091093602023A - 648.00 - - - - - 648.00 1101103602024A - 144.00 - - - - - 144.00 1111113602052A 144.00 - - - - - - 144.00 1121123602061A - - - - - - 816.00 816.00 1131133602063A - - - - - - 672.00 672.00 1141143910411111 - 306.00 - - - - - 306.00 1151153910411121 - 216.00 - - - - - 216.00 116116391041118 - 90.00 - - - - 216.00 306.00 11711739108303A - - - - - - 252.00 252.00 2172170- - - - - - - - 2182180- - - - - - - - 存货编码存货编码库别库别入帐(冲)日期入帐(冲)日期增加数量增加数量减少数量减少数量 01160600200 2013/1/4100000 01160600200 2013/1/5200000 01160600314 2009/2/12302640 01160603405 2013/1/3126800 01180240121 2013/11/22350000 011802909 2013/1/2400000 011914059 2013/11/35000 0119140611 2013/11/210000 050206033 2012/3/110000 05020603402 2012/2/2010000 05020603417 2012/2/2110000 05050115901 2013/11/740000 05050115902 2013/11/840000 05050115903 2013/11/940000 05050115904 2013/11/1040000 05050115905 2013/11/1140000 05050115920 2013/11/1240000 05070155062 2012/2/243600 05500202721 2012/2/271580 05500203402 2012/2/27200 05500203403 2012/2/27200 05500203404 2011/2/27400 055004013 2012/2/251200 0551020272 2012/2/28200 05510203402 2012/2/2750 05510203403 2012/2/2750 05510203404 2011/2/28100 05510401303 2012/2/26200 05600200281 2012/2/22206 05600200281 2012/2/2934 0560020029 2013/1/1800 05600200296 2012/2/23200 056040030 2012/2/2032 05610200281 2012/2/2360 05610200296 2012/2/2250 056140030 2012/2/217 09C735140201 2009/2/1415000 09C786800101 2013/11/13200000 09C786800201 2013/11/14200000 09C786800301 2009/2/8140000 09C786800301 2013/11/15300000 原始收发数据表 09C796800101 2009/2/950000 09C796800101 2013/11/16150000 09C796800201 2013/11/17200000 09C796800301 2009/2/10140000 09C796800301 2013/11/18300000 09C7A680101 2009/2/11140000 09C7A680101 2013/11/19200000 09C7A680201 2013/11/20200000 09C7A680301 2013/11/21200000 3101036A 2009/1/13240 3101043A 2013/12/72880 3101044A 2009/2/3144 3101047A 2013/12/15432 3101071A 2013/11/29120 3101078A 2013/11/3060 3102001A 2009/1/88640 3102002A 2009/1/93456 3102002A 2009/1/295184 3102002A 2013/12/817280 3102003A 2009/1/1517280 3102003A 2009/1/248640 3102021A 2009/1/112880 3102022A 2009/1/105760 3102022A 2013/12/105760 3102023A 2009/1/3016704 3102023A 2009/1/3111520 3102023A 2009/2/1576 3102023A 2013/12/95760 3102028A 2009/1/232304 3102058A 2009/1/2572 3102532A 2009/1/162304 3102533A 2013/12/24608 3102534A 2009/1/34608 3102535A 2009/1/201152 3102536A 2009/1/41152 3102536A 2013/12/33456 3102537A 2009/1/211152 3102576A 2009/1/22576 3102577A 2009/1/51152 3103152A 2009/1/17720 3105002A 2009/1/285760 3105002A 2013/12/12720 3105003A 2013/12/131296 3105006A 2009/1/271440 3106251A 2013/10/178488 3106251A 2013/10/183536 3106253A 2013/10/23600 3106253A 2013/10/58400 3106263A 2013/1/64104 3106263A 2013/1/7720 3106461A 2010/1/312160020,000.00 3106461A 2011/10/3110800 3106461A 2013/1/15237203,000.00 3106461A 2013/10/143600 3106461A 2013/10/15720 3106461A 2013/10/1635280 3108016A 2013/11/266912 3108017A 2009/1/194608 3108019A 2009/2/53456 3108401A 2009/1/62304 3108401A 2009/2/23456 3108402A 2009/1/711520 3108402A 2009/1/185760 3203491A 2013/12/1472 3203801A 2013/10/1260 3203801A 2013/10/1360 3204245A 2013/12/1172 3204361A 2013/12/572 3204362A 2013/12/636 3204555A 2009/2/64320 3204555A 2013/12/48640 3204566A 2009/2/4864 3207039A 2009/1/12576 3207039A 2009/1/142448 3207039A 2009/1/261872 3207131A 2013/10/92664 3207132A 2013/10/104356 3207133A 2013/10/111560 3207476A 2011/10/3110800 3207476A 2013/1/15237203,000.00 3207478A 2013/10/46384 3207478A 2013/10/64536 3207478A 2013/10/724 3207482A 2013/10/16240 3304113A 2013/10/195760 3304115A 2013/10/2010080 3304115A 2013/10/215760 3304116A 2013/10/226048 3304116A 2013/10/231152 3304116A 2013/10/248640 3304118A 2013/10/255760 3304119A 2013/10/261152 3304120A 2013/10/272880 3304121A 2013/10/287200 3304122A 2013/10/294320 3304124A 2013/10/304464 3304125A 2013/10/319216 3304126A 2013/11/1864 3501008A 2013/10/31080 3501016A 2013/10/143600 3501025A 2013/1/141440 3501025A 2013/10/15720 3501025A 2013/10/1635280 3602022A 2013/11/23144 3602022A 2013/11/27432 3602023A 2013/11/2572 3602023A 2013/11/28576 3602024A 2013/11/24144 3602052A 2013/12/1144 3602061A 2009/1/1816 3602063A 2009/1/2672 3910411111 2013/11/4306 3910411121 2013/11/5216 391041118 2009/2/7216 391041118 2013/11/690 39108303A 2009/2/13252 结余结余 100,000.00 300,000.00 302,640.00 126,800.00 350,000.00 400,000.00 5,000.00 10,000.00 10,000.00 10,000.00 10,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 40,000.00 3,600.00 1,580.00 200.00 200.00 400.00 1,200.00 200.00 50.00 50.00 100.00 200.00 206.00 240.00 800.00 200.00 32.00 60.00 50.00 7.00 15,000.00 200,000.00 200,000.00 140,000.00 440,000.00 50,000.00 200,000.00 200,000.00 140,000.00 440,000.00 140,000.00 340,000.00 200,000.00 200,000.00 240.00 2,880.00 144.00 432.00 120.00 60.00 8,640.00 3,456.00 8,640.00 25,920.00 17,280.00 25,920.00 2,880.00 5,760.00 11,520.00 16,704.00 28,224.00 28,800.00 34,560.00 2,304.00 72.00 2,304.00 4,608.00 4,608.00 1,152.00 1,152.00 4,608.00 1,152.00 576.00 1,152.00 720.00 5,760.00 6,480.00 1,296.00 1,440.00 8,488.00 12,024.00 3,600.00 12,000.00 4,104.00 4,824.00 1,600.00 12,400.00 33,120.00 36,720.00 37,440.00 72,720.00 6,912.00 4,608.00 3,456.00 2,304.00 5,760.00 11,520.00 17,280.00 72.00 60.00 120.00 72.00 72.00 36.00 4,320.00 12,960.00 864.00 576.00 3,024.00 4,896.00 2,664.00 4,356.00 1,560.00 10,800.00 31,520.00 6,384.00 10,920.00 10,944.00 6,240.00 5,760.00 10,080.00 15,840.00 6,048.00 7,200.00 15,840.00 5,760.00 1,152.00 2,880.00 7,200.00 4,320.00 4,464.00 9,216.00 864.00 1,080.00 3,600.00 1,440.00 2,160.00 37,440.00 144.00 576.00 72.00 648.00 144.00 144.00 816.00 672.00 306.00 216.00 216.00 306.00 252.00 存货编码存货名称单位 05500203404 05510203404 056040030 056140030 05600200281 05610200281 05070155062 055004013 05510401303 05500202721 0551020272 05600200281 050206033 05020603402 05020603417 05610200296 05600200296 05500203403 05500203402 05510203403 05510203402 0560020029 011802909 01160603405 01160600200 01160600200 3106263A 3106263A 3

温馨提示

  • 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
  • 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
  • 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
  • 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
  • 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
  • 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
  • 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。

评论

0/150

提交评论