excel出入库台账设计范例

4 13 5 1 5 10 3 3 11 1 6 12 4 3 5 10 8 2 8 1 1 1 4 6 4 1 5 3 6 11 5 2 3 9 3 7 3 5 3 1 1 3 1
AO07080601
CO07073101 CO07080101 CO07080301 AO07091101
AO07090802 AO07090803 AO07090901 AO07091102 AO07090802 AO07091103 AO07091201
2007-9-6 2007-8-22 2007-9-1 2007-8-30 2007-8-31 2007-9-1 2007-9-1 2007-9-14 2007-9-14 2007-9-15 2007-9-15 2007-9-15 2007-9-15 2007-8-30 2007-8-31 2007-8-10 2007-8-10 2007-8-11 2007-8-12 2007-8-12
2013-8-4
11943.488 Openning remarks 0.000 20.770 123.672 103.680 0.000 0.000 0.000 0.000 0.000 0.000 0.000 117.280 357.820 141.840 27.920 0.000 105.252 211.784 66.426 0.000 76.420 304.820 11.122 0.000 176.880 339.620 105.760 56.740 0.000 141.920 0.000 295.900 174.000 0.000 58.500 232.900 38.400 31.060 28.260 87.780 194.160 133.220 29.920 107.684 101.720 146.580 298.580 42.000 48.800 95.440 0.000 224.817 81.020 0.000 224.700 60.940 97.200 61.520 19.290 20.540 62.030 19.660 0.000 9月16日 9月16日 9月16日 9月16日 9月16日
117.280 357.820 141.840 27.920 105.252 211.784 66.426 76.420 304.820 11.122 176.880 339.620 105.760 56.740 141.920 295.900 174.000 58.500 232.900 38.400 31.060 28.260 87.780 194.160 133.220 29.920 107.684 101.720 146.580 298.580 42.000 48.800 95.440 224.817 81.020 224.700 60.940 97.200 61.520 19.290 20.540 62.030 19.660
Rm Inventory Aging Report
11637.626 Warehouse Bin CTN CTN CTN CTN CTN CTN CTN CTN CTN CTN CTN No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.1 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 T T T T T T DIP DIP DIP DIP DIP A1-1 A1-1 A1-1 A1-1 A1-2 A2-1 A2-1 A2-1 A2-2 A3-1 A3-1 A3-1 A3-2 A4-1 A4-1 A4-1 A4-1 A4-2 A5-1 A5-2 B1-1 B1-1 B1-2 B2-1 B2-1 B2-1 B2-2 B2-2 B3-1 B3-1 B3-1 B3-1 B3-2 B4-1 B4-1 B4-2 B5-1 B5-1 B5-1 B5-2 D1-1 D1-2 D2-1 D2-2 D3-1 D3-1 D3-1 D3-1 D3-1 D3-1 D3-1 D3-2 Material AONP AONP AONP AONP AONP Receiving date Batch 2007-9-14 2007-9-14 2007-9-15 2007-9-16 2007-9-16 AO07091302 AO07091301 AO07091402 AO07091402 AO07091501 Balance Ctns 0.000 24.820 0.000 39.970 263.430 0 0 1 0 2 12 age 0 2151 2151 2150 2149 2149 0 0 0 0 0 2169 2168 2167 2160 0 2188 2188 2187 0 2166 2165 2160 0 2173 2172 2170 2169 0 2163 0 2165 2164 0 2190 2189 2187 2153 2152 2186 2185 2184 2181 2189 2174 2173 2153 2196 2195 2193 0 2156 2155 0 2161 2155 2155 2155 2155 2154 2154 2154 0 <15 >90 >90 >90 >90 >90 <15 <15 <15 <15 <15 >90 >90 >90 >90 <15 >90 >90 >90 <15 >90 >90 >90 <15 >90 >90 >90 >90 <15 >90 <15 >90 >90 <15 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 >90 <15 >90 >90 <15 >90 >90 >90 >90 >90 >90 >90 >90 <15 628.020 Age range Receiving 933.882 Issue 20.770 98.852 103.680 39.970 263.430
CONP CONP CONP CONP AONP(PPIM) AONP(PPIM) AONP(PPIM) CONP CONP CONP CONP CONP CONP CONP COMG CONP CONP CONP CONP CONP COMG COMG CONP CONP CONP CONP AONP(PPIM) CONP CONP CONP CONP CONP CONP AONP(PPIM) CONP CONP AONP AONP AONP AONP AONP AONP AONP
1 1 5 8 12 2 1 3 1 2 3 10 4 2 4 10 7 8 1 1 3 6 5 10
CONP CONP CONP CONP CONP
2007-9-13 2007-9-14 2007-9-15 2007-9-10 2007-9-11
ቤተ መጻሕፍቲ ባይዱ
65.340 91.640 123.680 54.900 270.420
20.340 19.880 102.360 162.400 259.324 69.580 26.020 79.560 27.800 0.000 0.000 241.230 99.100 66.660 0.000 148.951 141.676 157.880 21.040 20.760 60.340 121.260 99.560 208.600
AO07090803 AO07090901 AO07090902 AO07091103 AO07090301
AO07081202 AO07081301 AO07070601 AO07070601 AO07070601 AO07090801 AO07090802 AO07090803 AO07090902 AO07091001 AO07091001 AO07082901
3 3 5 2 9
EONP AONP AONP AONP(PPIM) AONP(PPIM) AONP AONP AONP AONP AONP AONP AONP AONP AONP(PPIM) AONP(PPIM) AONP(PPIM) AONP(PPIM) AONP(PPIM) AONP(PPIM) AONP(PPIM)
AONP AONP AONP AONP AONP(PPIM) CONP CONP CONP CONP CONP CONP AONP AONP COMG AONP(PPIM) AONP(PPIM) AONP(PPIM) AONP AONP AONP AONP AONP AONP AONP(PPIM)
2007-9-11 2007-9-11 2007-9-11 2007-9-11 2007-9-3 2007-9-4 2007-9-6 2007-9-9 2007-9-10 2007-9-9 2007-9-10 2007-8-13 2007-8-13 2007-8-15 2007-7-8 2007-7-9 2007-7-10 2007-9-8 2007-9-8 2007-9-8 2007-9-8 2007-9-8 2007-9-9 2007-8-30
2007-8-27 2007-8-28 2007-8-29 2007-9-5 2007-8-8 2007-8-8 2007-8-9 2007-8-30 2007-8-31 2007-9-5 2007-8-23 2007-8-24 2007-8-26 2007-8-27 2007-9-2 2007-8-31 2007-9-1 2007-8-6 2007-8-7 2007-8-9 2007-9-12 2007-9-13 2007-8-10 2007-8-11 2007-8-12 2007-8-15 2007-8-7 2007-8-22 2007-8-23 2007-9-12 2007-7-31 2007-8-1 2007-8-3 2007-9-9 2007-9-10 2007-9-4 2007-9-10 2007-9-10 2007-9-10 2007-9-10 2007-9-11 2007-9-11 2007-9-11 CO07080605 CO07080701 AO07080701 AO07080701 AO07080701
D4-1 D4-1 D4-1 D4-1 D4-2 D5-1 D5-1 D5-1 D5-1 D5-2 D5-2 E1-1 E1-1 E1-2 E2-1 E2-1 E2-1 E2-2 E3-1 E3-1 E3-1 E3-1 E3-1 E3-1 E3-2 E4-1 E4-2 E5-1 E5-1 E5-1 E5-2 F1-1 F1-1 F1-2 F2-1 F2-2 F3-1 F3-1 F3-2 F3-2 F4-1 F4-1 F4-2 F4-2 F4-2 F4-2 F5-1 F5-1 F5-2 F5-2 G1-1 G1-2 G1-2 G1-2 G1-2 G1-2 G2-1 G2-2 G3-1 G3-2 G3-2 G4-1 G4-1 G4-1 G4-1 G4-2 G4-2
No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2 No.2