业务需求
需求描述


5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt

美西一仓

X001W9XP0L

以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条

案例2：

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt

波兰仓

X001Q6KUJB

这条也是一样的情况

案例3：

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt

波兰仓

X0012SONU5

合到353-0DAN2上

sql：

-- 库存

select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',

'67-16017433')

and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1

and CustomerCode in ('000060','000067')

group by CustomerCode,ItemCode ;



5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM

美西一仓

B0CHFT6T5P

000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整

5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM

验收标准
158Create
价值描述
10000
历史记录  
  1. 2025-07-11 10:26:48, 由 林很 创建。
  2. 2025-07-11 10:27:14, 由 林很 编辑。
    修改了 所属计划，旧值为 ""，新值为 "2080"。
    修改了 所处阶段，旧值为 "wait"，新值为 "planned"。
  3. 2025-07-11 10:27:56, 由 林很 变更。
    修改了 版本号 ，旧值为 "1"，新值为 "2"。
    修改了 需求名称，区别为：
    001- 【盛宝隆】库存多FNSKU的合并库龄展示
    001+ 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整
    001- 【盛宝隆】库存多FNSKU的合并库龄展示
    001+ 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整
    修改了 需求描述，区别为：
    001-
    001+
    002- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    002+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    003- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    003+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    004- 美西一仓
    004+ 美西一仓
    005- X001W9XP0L
    005+ X001W9XP0L
    006-
    006+
    007- 以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条
    007+ 以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条
    008-
    008+
    009- 案例2：
    009+ 案例2：
    010- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    010+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    011- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    011+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    012- 波兰仓
    012+ 波兰仓
    013- X001Q6KUJB
    013+ X001Q6KUJB
    014-
    014+
    015- 这条也是一样的情况
    015+ 这条也是一样的情况
    016-
    016+
    017- 案例3：
    017+ 案例3：
    018- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    018+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    019- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    019+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    020- 波兰仓
    020+ 波兰仓
    021- X0012SONU5
    021+ X0012SONU5
    022-
    022+
    023- 合到353-0DAN2上
    023+ 合到353-0DAN2上
    024-
    024+
    025-
    025+
    026- sql：
    026+ sql：
    027- -- 库存
    027+ -- 库存
    028- select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',
    028+ select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',
    029- '67-16017433')
    029+ '67-16017433')
    030- and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1
    030+ and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1
    031- and CustomerCode in ('000060','000067')
    031+ and CustomerCode in ('000060','000067')
    032- group by CustomerCode,ItemCode ;
    032+ group by CustomerCode,ItemCode ;
    033-
    033+
    034-
    034+
    036-
    036+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    037- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    037+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    038- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    038+ 美西一仓
    039- 美西一仓
    039+ B0CHFT6T5P
    040- B0CHFT6T5P
    040+
    041-
    041+ 000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整
    042- 000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整
    042+
    043-
    043+ <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    044- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    001- <p>
    001+ <p><br /></p>
    002- </p><p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    002+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    003- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    003+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    004- <p><span>美西一仓 </span></p>
    004+ <p><span>美西一仓 </span></p>
    005- <p><span>X001W9XP0L</span></p>
    005+ <p><span>X001W9XP0L</span></p>
    006- <p><span></span></p>
    006+ <p><span></span></p>
    007- <p><span>以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条</span></p>
    007+ <p><span>以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条</span></p>
    008- <p><span></span></p>
    008+ <p><span></span></p>
    009- <p><span>案例2：</span></p>
    009+ <p><span>案例2：</span></p>
    010- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    010+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    011- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    011+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    012- <p><span>波兰仓</span></p>
    012+ <p><span>波兰仓</span></p>
    013- <p><span>X001Q6KUJB</span></p>
    013+ <p><span>X001Q6KUJB</span></p>
    014- <p><span></span></p>
    014+ <p><span></span></p>
    015- <p><span>这条也是一样的情况</span></p>
    015+ <p><span>这条也是一样的情况</span></p>
    016- <p><span></span></p>
    016+ <p><span></span></p>
    017- <p><span>案例3：</span></p>
    017+ <p><span>案例3：</span></p>
    018- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    018+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    019- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    019+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    020- <p><span>波兰仓</span></p>
    020+ <p><span>波兰仓</span></p>
    021- <p><span>X0012SONU5</span></p>
    021+ <p><span>X0012SONU5</span></p>
    022- <p><span></span></p>
    022+ <p><span></span></p>
    023- <p><span>合到353-0DAN2上</span></p>
    023+ <p><span>合到353-0DAN2上</span></p>
    024- <p><span></span></p>
    024+ <p><span></span></p>
    025- <p><span></span></p>
    025+ <p><span></span></p>
    026- <p><span>sql：</span></p>
    026+ <p><span>sql：</span></p>
    027- <p><span>-- 库存</span></p>
    027+ <p><span>-- 库存</span></p>
    028- <p><span>select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',</span></p>
    028+ <p><span>select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',</span></p>
    029- <p><span>'67-16017433') </span></p>
    029+ <p><span>'67-16017433') </span></p>
    030- <p><span>and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1</span></p>
    030+ <p><span>and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1</span></p>
    031- <p><span>and CustomerCode in ('000060','000067')</span></p>
    031+ <p><span>and CustomerCode in ('000060','000067')</span></p>
    032- <p><span>group by CustomerCode,ItemCode ;</span></p>
    032+ <p><span>group by CustomerCode,ItemCode ;</span></p>
    033- <p><span></span></p>
    033+ <p><span></span></p>
    034-
    034+ <p><br /></p>
    036- <p>
    036+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    037- </p><p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    037+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    038- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    038+ <p><span>美西一仓</span></p>
    039- <p><span>美西一仓</span></p>
    039+ <p><span>B0CHFT6T5P</span></p>
    040- <p><span>B0CHFT6T5P</span></p>
    040+ <p><span></span></p>
    041- <p><span></span></p>
    041+ <p><span>000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整</span></p>
    042- <p><span>000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整</span></p>
    042+ <p><span></span></p>
    043- <p><span></span></p>
    043+ <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    044- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
  4. 2025-07-15 17:37:10, 由 林很 编辑。
    修改了 所属计划，旧值为 "2080"，新值为 "1923"。
  5. 2025-07-16 09:13:32, 由 周杰 编辑。
    修改了 上线时间，旧值为 "2025-08-05"，新值为 "0000-00-00"。
  6. 2025-08-05 17:59:12, 由 林很 变更。
    修改了 版本号 ，旧值为 "2"，新值为 "3"。
    修改了 需求名称，区别为：
    001- 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整
    001+ 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整及弹窗导入字段调整
    001- 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整
    001+ 【盛宝隆】库存多FNSKU的合并库龄及库龄报告调整及弹窗导入字段调整
  7. 2025-08-05 20:10:13, 由 林很 变更。
    修改了 版本号 ，旧值为 "3"，新值为 "4"。
    修改了 需求描述，区别为：
    001-
    001+ https://alidocs.dingtalk.com/i/nodes/Gl6Pm2Db8D3kB579tn0gEg02JxLq0Ee4?utm_scene=team_space
    002- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    003- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    004- 美西一仓
    005- X001W9XP0L
    006-
    007- 以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条
    008-
    009- 案例2：
    010- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    011- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    012- 波兰仓
    013- X001Q6KUJB
    014-
    015- 这条也是一样的情况
    016-
    017- 案例3：
    018- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    019- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" />
    020- 波兰仓
    021- X0012SONU5
    022-
    023- 合到353-0DAN2上
    024-
    025-
    026- sql：
    027- -- 库存
    028- select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',
    029- '67-16017433')
    030- and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1
    031- and CustomerCode in ('000060','000067')
    032- group by CustomerCode,ItemCode ;
    033-
    034-
    035-
    036- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    037- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    038- 美西一仓
    039- B0CHFT6T5P
    040-
    041- 000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整
    042-
    043- <img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" />
    001- <p><br /></p>
    001+ <p>https://alidocs.dingtalk.com/i/nodes/Gl6Pm2Db8D3kB579tn0gEg02JxLq0Ee4?utm_scene=team_space</p>
    002- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:567px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d50f358280fbf6c4619bffbcf6e0b6e165e5725a22c2d0566055e37fcb4058bfcbf6b7c87863412ca8?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    003- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:426px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d59f0f57bf207dc3fdc9ef3d30c0662e515f0582ef7c06bd1429b55ee81880733dbb4a64e841641388?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    004- <p><span>美西一仓 </span></p>
    005- <p><span>X001W9XP0L</span></p>
    006- <p><span></span></p>
    007- <p><span>以及这个条码的，能不能全部放在67-0097K这个上面去跑，不要让它有两条</span></p>
    008- <p><span></span></p>
    009- <p><span>案例2：</span></p>
    010- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:254px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d54a1820b6bf228968b83ed018c9c43a25074a9f55b0708dd33a5a52a641632cf0f0378a726bc64e7c?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    011- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5621371a6819a6fc5d46c2462e93b2e523417742c3ae997264f08c252182888a7c79dc4c9e10ad4e5?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    012- <p><span>波兰仓</span></p>
    013- <p><span>X001Q6KUJB</span></p>
    014- <p><span></span></p>
    015- <p><span>这条也是一样的情况</span></p>
    016- <p><span></span></p>
    017- <p><span>案例3：</span></p>
    018- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:357px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d55cc5dd30dee3796997baec244f9dc392c31cab2623f3283e08147f95738a490e5e8e328c75440770?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    019- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" style="height:280px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d53423c040ccb4b5883a2f1c8a887c07657d9a38932a9e4f3d74a05c5f10eae267d81ae86327b5bc38?tmpCode=iPoGcPgcFZvY6a0zy3nnt" /><span></span></p>
    020- <p><span>波兰仓</span></p>
    021- <p><span>X0012SONU5</span></p>
    022- <p><span></span></p>
    023- <p><span>合到353-0DAN2上</span></p>
    024- <p><span></span></p>
    025- <p><span></span></p>
    026- <p><span>sql：</span></p>
    027- <p><span>-- 库存</span></p>
    028- <p><span>select CustomerCode,ItemCode,MultiCode,sum(UsableQuantity) from inv_inventory where ItemCode in ('60-16017433',</span></p>
    029- <p><span>'67-16017433') </span></p>
    030- <p><span>and MultiCode='X001Q6KUJB' and WarehouseId=103 and StorageModeId=1</span></p>
    031- <p><span>and CustomerCode in ('000060','000067')</span></p>
    032- <p><span>group by CustomerCode,ItemCode ;</span></p>
    033- <p><span></span></p>
    034- <p><br /></p>
    035- <p><br /></p>
    036- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:873px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5a9d50aaf5c724878fa430bb0ac7fb08f101608cd354780a24730d12e1b02702d2631c962fb8e62b3?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    037- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="height:455px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d5701700c3d2ccf198dbea2204a6b6126be42804e11d30a7bbfbfc0a799d35da4994eb1ca00718f47b?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
    038- <p><span>美西一仓</span></p>
    039- <p><span>B0CHFT6T5P</span></p>
    040- <p><span></span></p>
    041- <p><span>000067账号的库存已经出库完了，但是库龄还在跑，这15个库龄应该是在000060的账号上跑才是正确的，看下怎么调整</span></p>
    042- <p><span></span></p>
    043- <p><span></span><img src="https://alidocs.dingtalk.com/core/api/resources/img/5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" style="width:211px;height:895px;" alt="5eecdaf48460cde5d0b5374014b93d20041f2b75906be05275b8339e1c4c24838100ac3a9bb2fddfc1f71d1ebd810e12a156a98577f418d58b7e3e8f7530fa7ab3ff9430d847825de02dcc3c31650b0d72a37e7d6b91237714227166b7b10051?tmpCode=6Hp6gP1DCcLYhxpKg7eMM" /><span></span></p>
  8. 2025-08-06 14:09:19, 由 林很 编辑。
    修改了 所属计划，旧值为 "1923"，新值为 "2142"。
  9. 2025-08-06 21:03:03, 由 张明磊 编辑。
    修改了 预计工时，旧值为 "12"，新值为 "16"。
    修改了 成本 ，旧值为 "6000"，新值为 "8000"。
    修改了 ROI ，旧值为 "10.00"，新值为 "7.50"。

    工时：20H

    1. 库存多FNSKU合并库龄及导出优化 5H

    2. 外部映射条码导入入参校验及新增渠道SKU维度 3H

    3. PAD头程入库单新增是否已部分上架字段判断 3H

    4. 前端调整 9H

  10. 2025-08-06 21:03:26, 由 张明磊 编辑。
    修改了 预计工时，旧值为 "16"，新值为 "20"。
    修改了 成本 ，旧值为 "8000"，新值为 "10000"。
    修改了 ROI ，旧值为 "7.50"，新值为 "6.00"。
  11. 2025-08-07 10:20:58, 由 张明磊 记录评审结果，结果为 确认通过。
  12. 2025-08-07 10:28:25, 由 周杰 关联到迭代 主干_8月V3版本_20250819 。
  13. 2025-08-07 18:00:17, 由 周杰 编辑。
    修改了 上线时间 ，旧值为 "0000-00-00"，新值为 "2025-08-19"。
    修改了 计划验收时间，旧值为 "0000-00-00"，新值为 "2025-08-22"。
    修改了 计划上线 ，旧值为 "0000-00-00"，新值为 "2025-08-19"。
  14. 2025-08-13 11:23:14, 由 曾倩 编辑。
    修改了 测试人员，旧值为 ""，新值为 "zengqian"。
  15. 2025-08-19 09:26:37, 由 周杰 编辑。
    修改了 所处阶段 ，旧值为 "tested"，新值为 "bepending"。
    修改了 设置阶段者，旧值为 ""，新值为 "zhoujie"。
  16. 2025-09-20 16:37:01, 由 许瑞丰 编辑。
    修改了 所处阶段，旧值为 "业务验收中"，新值为 "业务验收通过"。
    功能验收：验收通过
    满意度：满意
    价值验收：基本达成
    原因备注：无
  17. 2025-09-22 19:29:12, 由 周杰 关闭，原因为 已完成 。
    修改了 由谁关闭，旧值为 ""，新值为 "zhoujie"。
    修改了 关闭日期，旧值为 "0000-00-00 00:00:00"，新值为 "2025-09-22 19:29:10"。
    修改了 指派给 ，旧值为 "zhangminglei"，新值为 "closed"。
    修改了 当前状态，旧值为 "active"，新值为 "closed"。
    修改了 所处阶段，旧值为 "verified"，新值为 "closed"。
    修改了 关闭原因，旧值为 ""，新值为 "done"。
  18. 2025-12-05 19:45:10, 由 许瑞丰 编辑。
    修改了 业务回填价值，旧值为 "0"，新值为 "10000"。
    修改了 actualAchieveDesc ，旧值为 ""，新值为 ""。
迭代版本
提报业务部门 技术研发中心
提报人员 林很
需求来源 bug转需求
所属项目 技术中心-需求池
所属模块 财务   财务管理
所属计划
业务价值
开发组 财务开发组
受益业务部门 技术研发中心
验收人员 许瑞丰
业务目标类型
中心业务目标
业务价值 控制风险
每月价值量 10000
每月节省人数 0
优先级 P3
价值类型 长期价值
预计工时 20
成本 250
ROI 40.00
操作手册 否
高价值 -
主被动 被动接收
复杂度 一般性
工作流ID
工作流创建时间 0000-00-00 00:00:00
更新点
是否高危 否
评分
当前状态 已关闭
所处阶段 已关闭
关键词
评审次数 一次
计划上线 2025-08-19
上线时间 2025-08-19
计划验收时间 2025-08-22
业务验收时间 2025-09-20 16:37:01
满意度 满意
价值验收 基本达成
满意度分值 80
业务回填价值 10000
验收达成价值 48000.0
验收达成ROI 4.8
抄送给 曾倩  
由谁创建 林很 于 2025-07-11 10:26:48
指派给 Closed 于 2025-09-22 19:29:10
由谁评审 张明磊
评审时间 2025-08-07
由谁关闭 周杰 于 2025-09-22 19:29:10
关闭原因 已完成
最后修改 周杰 于 2025-09-22 19:29:10
相关Bug
相关用例
相关需求
细分需求