进销存管理表.xlsx
《进销存管理表.xlsx》由会员分享,可在线阅读,更多相关《进销存管理表.xlsx(42页珍藏版)》请在得力文库 - 分享文档赚钱的网站上搜索。
1、 进销存明细表 商品及库存信息 采购销售明细表商品编码品名规格初始库存现库存日期进/销LY00001A_1品名*26262021/01/02采购LY00002A_2品名*35392021/01/03采购LY00003A_3品名*46452021/01/04采购LY00004A_4品名*1182021/01/05采购LY00005A_5品名*11202021/02/06采购LY00006A_6品名*41362021/02/07采购LY00007A_7品名*50582021/02/08采购LY00008A_8品名*32342021/02/09采购LY00009A_9品名*24172021/03/1
2、0采购LY00010A_10品名*36352021/03/11采购LY00011A_11品名*35392021/03/12采购LY00012A_12品名*11122021/04/13采购LY00013A_13品名*21222021/04/14采购LY00014A_14品名*29292021/04/15采购LY00015A_15品名*15132021/05/16采购LY00016A_16品名*36332021/05/17采购LY00017A_17品名*29292021/05/18采购LY00018A_18品名*20272021/06/19采购LY00019A_19品名*28242021/06/2
3、0采购LY00020A_20品名*50512021/06/21采购3.2万元4.7万元2.4万元0.9万元2.6万元2.4万元1.7万元2.5万元2.9万元2.1万元3.6万元3.8万元8.7万元3.9万元3.8万元4.7万元6.5万元3.6万元6.0万元2.4万元2.5万元3.7万元2.4万元6.2万元1月2月3月4月5月6月7月8月9月10月11月12月采购销售LY00021A_21品名*20112021/07/22采购LY00022A_22品名*46482021/07/23采购LY00023A_23品名*16202021/07/24采购LY00024A_24品名*27322021/08/
4、25采购LY00025A_25品名*15162021/08/26采购LY00026A_26品名*33402021/08/27采购LY00027A_27品名*13202021/08/28采购LY00028A_28品名*39392021/01/02销售LY00029A_29品名*50502021/01/03销售LY00030A_30品名*40402021/01/04销售LY00031A_31品名*12122021/01/05销售LY00032A_32品名*12122021/02/06销售LY00033A_33品名*19192021/02/07销售LY00034A_34品名*17172021/02/
5、08销售LY00035A_35品名*33332021/02/09销售LY00036A_36品名*12122021/03/10销售LY00037A_37品名*39392021/03/11销售LY00038A_38品名*40402021/03/12销售LY00039A_39品名*28282021/04/13销售LY00040A_40品名*11112021/04/14销售LY00041A_41品名*22222021/04/15销售LY00042A_42品名*44442021/05/16销售LY00043A_43品名*33332021/05/17销售LY00044A_44品名*48482021/05/
6、18销售LY00045A_45品名*29292021/06/19销售LY00046A_46品名*1542021/06/20销售LY00047A_47品名*28232021/06/21销售LY00048A_48品名*20172021/07/22销售LY00049A_49品名*40322021/07/23销售LY00050A_50品名*49412021/07/24销售LY00051A_51品名*1232021/08/25销售LY00052A_52品名*45392021/08/26销售LY00053A_53品名*18152021/08/27销售LY00054A_54品名*36322021/08/28
7、销售LY00055A_55品名*49362021/09/18销售LY00056A_56品名*36292021/09/19销售LY00057A_57品名*34252021/09/20销售LY00058A_58品名*28402021/10/21销售LY00059A_59品名*31392021/10/22销售LY00060A_60品名*37502021/10/23销售LY00061A_61品名*12252021/11/24销售LY00062A_62品名*33412021/11/04销售LY00063A_63品名*35482021/11/05销售LY00064A_64品名*22312021/12/06
8、销售LY00065A_65品名*50582021/12/07销售LY00066A_66品名*47592021/12/08销售LY00067A_67品名*22312021/09/18采购LY00068A_68品名*11172021/09/19采购LY00069A_69品名*41532021/09/20采购LY00070A_70品名*35352021/10/21采购LY00071A_71品名*31312021/10/22采购LY00072A_72品名*40402021/10/23采购LY00073A_73品名*26262021/11/24采购LY00074A_74品名*43432021/11/04
9、采购LY00075A_75品名*50502021/11/05采购LY00076A_76品名*39392021/12/06采购LY00077A_77品名*34342021/12/07采购LY00078A_78品名*33332021/12/08采购LY00079A_79品名*1818LY00080A_80品名*4444LY00081A_81品名*1919LY00082A_82品名*2525LY00083A_83品名*1111LY00084A_84品名*1515LY00085A_85品名*1313LY00086A_86品名*4343LY00087A_87品名*2222LY00088A_88品名*27
10、27LY00089A_89品名*2727LY00090A_90品名*1818LY00091A_91品名*4242LY00092A_92品名*2626LY00093A_93品名*4545LY00094A_94品名*3131LY00095A_95品名*2222LY00096A_96品名*2424LY00097A_97品名*2828LY00098A_98品名*2626商品编码品名规格数量单价金额备注LY00001A_1品名*111,673.0018,403.00LY00002A_2品名*13919.0011,947.00LY00003A_3品名*1071.00710.00LY00004A_4品名*1
11、0127.001,270.00LY00005A_5品名*13296.003,848.00LY00006A_6品名*8889.007,112.00LY00007A_7品名*131,427.0018,551.00LY00008A_8品名*121,427.0017,124.00LY00009A_9品名*414.0056.00LY00010A_10品名*101,098.0010,980.00LY00011A_11品名*91,427.0012,843.00LY00012A_12品名*11226.002,486.00LY00013A_13品名*7502.003,514.00LY00014A_14品名*38
12、46.002,538.00LY00015A_15品名*111,349.0014,839.00LY00016A_16品名*6507.003,042.00LY00017A_17品名*13615.007,995.00LY00018A_18品名*10848.008,480.00LY00019A_19品名*51,550.007,750.00LY00020A_20品名*81,024.008,192.00采购32.7万元38%销售54.3万元62% 进销存明细表3.2万元4.7万元2.4万元0.9万元2.6万元2.4万元1.7万元2.5万元2.9万元2.1万元3.6万元3.8万元8.7万元3.9万元3.8万
13、元4.7万元6.5万元3.6万元6.0万元2.4万元2.5万元3.7万元2.4万元6.2万元1月2月3月4月5月6月7月8月9月10月11月12月采购销售LY00021A_21品名*316.0048.00LY00022A_22品名*993.00837.00LY00023A_23品名*101,617.0016,170.00LY00024A_24品名*12184.002,208.00LY00025A_25品名*7895.006,265.00LY00026A_26品名*111,391.0015,301.00LY00027A_27品名*10116.001,160.00LY00001A_1品名*112,
14、374.0026,114.00LY00002A_2品名*91,279.0011,511.00LY00003A_3品名*112,434.0026,774.00LY00004A_4品名*131,702.0022,126.00LY00005A_5品名*42,088.008,352.00LY00006A_6品名*13389.005,057.00LY00007A_7品名*51,677.008,385.00LY00008A_8品名*101,677.0016,770.00LY00009A_9品名*11716.007,876.00LY00010A_10品名*112,029.0022,319.00LY00011
15、A_11品名*51,637.008,185.00LY00012A_12品名*102,477.0024,770.00LY00013A_13品名*62,963.0017,778.00LY00014A_14品名*31,505.004,515.00LY00015A_15品名*132,141.0027,833.00LY00016A_16品名*9765.006,885.00LY00017A_17品名*132,302.0029,926.00LY00018A_18品名*31,152.003,456.00LY00019A_19品名*92,140.0019,260.00LY00020A_20品名*71,933.0
16、013,531.00LY00021A_21品名*122,926.0035,112.00LY00022A_22品名*71,224.008,568.00LY00023A_23品名*62,706.0016,236.00LY00024A_24品名*71,568.0010,976.00LY00025A_25品名*61,561.009,366.00LY00026A_26品名*4418.001,672.00LY00027A_27品名*3523.001,569.00LY00046A_46品名*11768.008,448.00LY00047A_47品名*52,508.0012,540.00LY00048A_48
17、品名*31,312.003,936.00LY00049A_49品名*8704.005,632.00LY00050A_50品名*82,237.0017,896.00LY00051A_51品名*91,544.0013,896.00LY00052A_52品名*62,898.0017,388.00LY00053A_53品名*3745.002,235.00LY00054A_54品名*41,092.004,368.00LY00055A_55品名*132,573.0033,449.00LY00056A_56品名*72,877.0020,139.00LY00057A_57品名*9909.008,181.00L
18、Y00058A_58品名*12555.006,660.00LY00059A_59品名*8593.004,744.00LY00060A_60品名*131,341.0017,433.00LY00061A_61品名*131,301.0016,913.00LY00062A_62品名*884.00672.00LY00063A_63品名*13259.003,367.00LY00064A_64品名*91,691.0015,219.00LY00065A_65品名*8724.005,792.00LY00066A_66品名*121,219.0014,628.00LY00067A_67品名*91,680.0015,
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 进销存 管理
限制150内