表格模板-如何用表格完成仓库管理 精品.xls

《表格模板-如何用表格完成仓库管理 精品.xls》由会员分享，可在线阅读，更多相关《表格模板-如何用表格完成仓库管理 精品.xls（31页珍藏版）》请在第一文库网上搜索。

1、FamilyBin NumberItem CodeMaterials FamilyUnits priceQuantityValueMaterialMasterTurn InQuantityAA11-1MGA001-00-01FG2610567A11-2MGA001-00-02FG000A12-1MGA001-00-03FG000A12-2MGA001-00-04FG000A13-1MGA001-00-05FG000A13-2MGA001-00-06FG000A14-1MGA001-00-07#N/A5130530A14-2MGA001-00-08#N/A000A21-1MGA001-00-09

2、#N/A000A21-2MGA001-00-10#N/A000A22-1MGA001-00-11#N/A000A22-2MGA001-00-12#N/A000A23-1MGA001-00-13#N/A000A23-2MGA001-00-14#N/A000A24-1MGA001-00-15#N/A000A24-2MGA001-00-16#N/A000A31-1MGA001-00-17#N/A000A31-2MGA001-00-18#N/A000A32-10#N/A000A32-20#N/A000A33-10#N/A000A33-20#N/A000A34-10#N/A000A34-20#N/A00

3、0#N/A#N/A0B11-1000BB11-2000B12-1000B12-2000B13-1000B13-2000B14-1000B14-2000B21-1000B21-2000B22-1000B22-2000B23-1000B23-2000B24-1000B24-2000B31-1000B31-2000B32-1000B32-2000B33-1000B33-2000B34-1000B34-20000CC11-1000C11-2000C12-1000C12-2000C13-1000C13-2000C14-1000C14-2000C21-1000C21-2000C22-1000C22-200

4、0C23-1000C23-2000C24-1000C24-2000C31-1000C31-2000C32-1000C32-2000C33-1000C33-2000C34-1000C34-20000DD11-1000D11-2000D12-1000D12-2000D13-1000D13-2000D14-1000D14-2000D21-1000D21-2000D22-1000D22-2000D23-1000D23-2000D24-1000D24-2000D31-1000D31-2000D32-1000D32-2000D33-1000D33-2000D34-1000D34-20000EE11-100

5、0E11-2000E12-1000E12-2000E13-1000E13-2000E14-1000E14-2000E21-1000E21-2000E22-1000E22-2000E23-1000E23-2000E24-1000E24-2000E31-1000E31-2000E32-1000E32-2000E33-1000E33-2000E34-1000E34-20000FF11-1000F11-2000F12-1000F12-2000F13-1000F13-2000F14-1000F14-2000F21-1000F21-2000F22-1000F22-2000F23-1000F23-2000F

6、24-1000F24-2000F31-1000F31-2000F32-1000F32-2000F33-1000F33-2000F34-1000F34-20000GG11-1000G11-2000G12-1000G12-2000G13-1000G13-2000G14-1000G14-2000G21-1000G21-2000G22-1000G22-2000G23-1000G23-2000G24-1000G24-2000G31-1000G31-2000G32-1000G32-2000G33-1000G33-2000G34-1000G34-20000HH11-1000H11-2000H12-1000H

7、12-2000H13-1000H13-2000H14-1000H14-2000H21-1000H21-2000H22-1000H22-2000H23-1000H23-2000H24-1000H24-2000H31-1000H31-2000H32-1000H32-2000H33-1000H33-2000H34-1000H34-2000#N/A#N/ATurn OutGoodsIssueGoodsReceiveValue Quantity Value0-30604100000000000000000000000000-1701100000000000000000000000000000000000

8、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000Turn In00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

9、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

10、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

11、00000000000000000000000000000000000000000Bin NumberItem CodeDescriptionMaterialFamilyCurrent QTY14-6月A11-1MGA001-00-01FG3024633/GEARFG261500A11-2MGA001-00-02FG3019541/GEAR. SPURFG0A12-1MGA001-00-03FG3023859/GEAR. SPUR (CLUSTER)FG0A12-2MGA001-00-04FG3023860/GEAR. SPUR (OUTPUT)FG0A13-1MGA001-00-05FG30

12、30150/GEAR- SPURFG0A13-2MGA001-00-06FG3031067/WORM-GEARFG0A14-1MGA001-00-07#N/A#N/A513500A14-2MGA001-00-08#N/A#N/A0A21-1MGA001-00-09#N/A#N/A0A21-2MGA001-00-10#N/A#N/A0A22-1MGA001-00-11#N/A#N/A0A22-2MGA001-00-12#N/A#N/A0A23-1MGA001-00-13#N/A#N/A0A23-2MGA001-00-14#N/A#N/A0A24-1MGA001-00-15#N/A#N/A0A24

13、-2MGA001-00-16#N/A#N/A0A31-1MGA001-00-17#N/A#N/A0A31-2MGA001-00-18#N/A#N/A0A32-10A32-20A33-10A33-20A34-10A34-200B11-10B11-20B12-10B12-20B13-10B13-20B14-10B14-20B21-10B21-20B22-10B22-20B23-10B23-20B24-10B24-20B31-10B31-20B32-10B32-20B33-10B33-20B34-10B34-200C11-10C11-20C12-10C12-20C13-10C13-20C14-10C

14、14-20C21-10C21-20C22-10C22-20C23-10C23-20C24-10C24-20C31-10C31-20C32-10C32-20C33-10C33-20C34-10C34-200D11-10D11-20D12-10D12-20D13-10D13-20D14-10D14-20D21-10D21-20D22-10D22-20D23-10D23-20D24-10D24-20D31-10D31-20D32-10D32-20D33-10D33-20D34-10D34-200E11-10E11-20E12-10E12-20E13-10E13-20E14-10E14-20E21-1

15、0E21-20E22-10E22-20E23-10E23-20E24-10E24-20E31-10E31-20E32-10E32-20E33-10E33-20E34-10E34-200F11-10F11-20F12-10F12-20F13-10F13-20F14-10F14-20F21-10F21-20F22-10F22-20F23-10F23-20F24-10F24-20F31-10F31-20F32-10F32-20F33-10F33-20F34-10F34-200G11-10G11-20G12-10G12-20G13-10G13-20G14-10G14-20G21-10G21-20G22

16、-10G22-20G23-10G23-20G24-10G24-20G31-10G31-20G32-10G32-20G33-10G33-20G34-10G34-200H11-10H11-20H12-10H12-20H13-10H13-20H14-10H14-20H21-10H21-20H22-10H22-20H23-10H23-20H24-10H24-20H31-10H31-20H32-10H32-20H33-10H33-20H34-10H34-200# # # # #20-6月21-6月22-6月23-6月24-6月25-6月-7867-89 -76 -6330-17产品编号MGA001-00-01FG3024633/GEARMGA001-00-02FG3019541/GEAR. SPURMGA001-00-03FG3023859/GEAR. SPUR (CLUSTER)MGA001-01-03FG3023885/Gear pinionMGA001-00-04FG3023860/GEAR. SPUR (OUTPUT)MGA001-00-05FG3030150/GEAR- SPURMGA