| Line 393... |
Line 393... |
| 393 |
worksheet.write(row, inc(), float(lineitem.get('suggestedQuantity')) * float(lineitem.get('unitPrice')))
|
393 |
worksheet.write(row, inc(), float(lineitem.get('suggestedQuantity')) * float(lineitem.get('unitPrice')))
|
| 394 |
worksheet.write(row, inc(), lineitem.get('packQuantity'))
|
394 |
worksheet.write(row, inc(), lineitem.get('packQuantity'))
|
| 395 |
reservedCount = 0
|
395 |
reservedCount = 0
|
| 396 |
if lineitem.get('reservedQuantity') is not None:
|
396 |
if lineitem.get('reservedQuantity') is not None:
|
| 397 |
reservedCount = lineitem.get('reservedQuantity')
|
397 |
reservedCount = lineitem.get('reservedQuantity')
|
| 398 |
worksheet.write(row, inc(), long(lineitem.get('availableQuantity'))-long(reservedCount))
|
398 |
worksheet.write(row, inc(), long(reservedCount))-long(lineitem.get('availableQuantity'))
|
| 399 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
399 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
| 400 |
worksheet.write(row, inc(), "("+lineitem.get('lastXdaysSale')+")"+str(lineitem.get('avgSales')))
|
400 |
worksheet.write(row, inc(), "("+lineitem.get('lastXdaysSale')+")"+str(lineitem.get('avgSales')))
|
| 401 |
worksheet.write(row, inc(), lineitem.get('rtoOrders'))
|
401 |
worksheet.write(row, inc(), lineitem.get('rtoOrders'))
|
| 402 |
worksheet.write(row, inc(), lineitem.get('numberOfDaysStock'))
|
402 |
worksheet.write(row, inc(), lineitem.get('numberOfDaysStock'))
|
| 403 |
worksheet.write(row, inc(), lineitem.get('minStockLevel'))
|
403 |
worksheet.write(row, inc(), lineitem.get('minStockLevel'))
|