| | |
|---|
| | | // 客户库料架总数量 |
|---|
| | | mrcc := select( macroPlan, MaterialRackCustomRow.MaterialRackCustomCell, tempMRCCell, tempMRCCell.MaterialRackCustomRow().Generation() = ccerr.Generation() and tempMRCCell.MaterialRackCustomRow().MLB_MQB() = ccerr.MLB_MQB() and tempMRCCell.MaterialRackColumn().Month() = ccerc.StartDate().Month() ); |
|---|
| | | |
|---|
| | | // 当前月末最后一天日期 |
|---|
| | | lastDayOfThisMonth := ccerc.StartDate().StartOfNextMonth() - 1; |
|---|
| | | |
|---|
| | | cell := ccerr.CC_EngineRackCell( relnew ); |
|---|
| | | |
|---|
| | | // 料架总数量 |
|---|
| | |
|---|
| | | tempMRTCell.MaterialRackTotalRow().Generation() = ccerr.Generation() and |
|---|
| | | tempMRTCell.MaterialRackTotalRow().MLB_MQB() = ccerr.MLB_MQB() and |
|---|
| | | tempMRTCell.MaterialRackColumn().Month() = ccerc.StartDate().Month() ); |
|---|
| | | cell.TotalQuantityOfMaterialRacks( mrtcell.Quantity() ); |
|---|
| | | cell.TotalQuantityOfMaterialRacks( guard( mrtcell.Quantity(), 0 ) ); |
|---|
| | | |
|---|
| | | // 空料架数量：【350bar MQB料架总数量 - 所有350bar MQB总库存 / 包装容量-客户库料架数量】* 长春外租库空料架比例 |
|---|
| | | plannedInventory := sum( macroPlan, Product_MP.ProductInStockingPoint_MP.ProductInStockingPointInPeriod, tempPISPIP, |
|---|
