| Line 386... |
Line 386... |
| 386 |
worksheet.write(row, inc(), 'Transfer price', boldStyle)
|
386 |
worksheet.write(row, inc(), 'Transfer price', boldStyle)
|
| 387 |
worksheet.write(row, inc(), 'Nlc', boldStyle)
|
387 |
worksheet.write(row, inc(), 'Nlc', boldStyle)
|
| 388 |
worksheet.write(row, inc(), 'Total amount', boldStyle)
|
388 |
worksheet.write(row, inc(), 'Total amount', boldStyle)
|
| 389 |
worksheet.write(row, inc(), 'Pack Quantity', boldStyle)
|
389 |
worksheet.write(row, inc(), 'Pack Quantity', boldStyle)
|
| 390 |
worksheet.write(row, inc(), 'Available Quantity', boldStyle)
|
390 |
worksheet.write(row, inc(), 'Available Quantity', boldStyle)
|
| - |
|
391 |
worksheet.write(row, inc(), 'Reserved Quantity', boldStyle)
|
| 391 |
worksheet.write(row, inc(), 'Virtual Stock', boldStyle)
|
392 |
worksheet.write(row, inc(), 'Virtual Stock', boldStyle)
|
| 392 |
worksheet.write(row, inc(), 'NetPendingOrderQty', boldStyle)
|
393 |
worksheet.write(row, inc(), 'NetPendingOrderQty', boldStyle)
|
| 393 |
worksheet.write(row, inc(), 'PreviouslyOrderedQty', boldStyle)
|
394 |
worksheet.write(row, inc(), 'PreviouslyOrderedQty', boldStyle)
|
| 394 |
worksheet.write(row, inc(), 'AverageSale', boldStyle)
|
395 |
worksheet.write(row, inc(), 'AverageSale', boldStyle)
|
| 395 |
worksheet.write(row, inc(), 'Pending RTOs', boldStyle)
|
396 |
worksheet.write(row, inc(), 'Pending RTOs', boldStyle)
|
| Line 421... |
Line 422... |
| 421 |
worksheet.write(row, inc(), lineitem.get('packQuantity'))
|
422 |
worksheet.write(row, inc(), lineitem.get('packQuantity'))
|
| 422 |
reservedCount = 0
|
423 |
reservedCount = 0
|
| 423 |
if lineitem.get('reservedQuantity') is not None:
|
424 |
if lineitem.get('reservedQuantity') is not None:
|
| 424 |
reservedCount = lineitem.get('reservedQuantity')
|
425 |
reservedCount = lineitem.get('reservedQuantity')
|
| 425 |
worksheet.write(row, inc(), long(lineitem.get('availableQuantity')))
|
426 |
worksheet.write(row, inc(), long(lineitem.get('availableQuantity')))
|
| - |
|
427 |
worksheet.write(row, inc(), long(reservedCount))
|
| 426 |
worksheet.write(row, inc(), lineitem.get('virtualStock'))
|
428 |
worksheet.write(row, inc(), lineitem.get('virtualStock'))
|
| 427 |
worksheet.write(row, inc(), long(reservedCount)-long(lineitem.get('availableQuantity')))
|
429 |
worksheet.write(row, inc(), long(reservedCount)-long(lineitem.get('availableQuantity')))
|
| 428 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
430 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
| 429 |
worksheet.write(row, inc(), "("+lineitem.get('lastXdaysSale')+")"+str(lineitem.get('avgSales')))
|
431 |
worksheet.write(row, inc(), "("+lineitem.get('lastXdaysSale')+")"+str(lineitem.get('avgSales')))
|
| 430 |
worksheet.write(row, inc(), lineitem.get('rtoOrders'))
|
432 |
worksheet.write(row, inc(), lineitem.get('rtoOrders'))
|