| Line 360... |
Line 360... |
| 360 |
worksheet.write(row, inc(), 'COD', boldStyle)
|
360 |
worksheet.write(row, inc(), 'COD', boldStyle)
|
| 361 |
worksheet.write(row, inc(), 'Prepaid', boldStyle)
|
361 |
worksheet.write(row, inc(), 'Prepaid', boldStyle)
|
| 362 |
worksheet.write(row, inc(), 'Transfer price', boldStyle)
|
362 |
worksheet.write(row, inc(), 'Transfer price', boldStyle)
|
| 363 |
worksheet.write(row, inc(), 'Nlc', boldStyle)
|
363 |
worksheet.write(row, inc(), 'Nlc', boldStyle)
|
| 364 |
worksheet.write(row, inc(), 'Total amount', boldStyle)
|
364 |
worksheet.write(row, inc(), 'Total amount', boldStyle)
|
| - |
|
365 |
worksheet.write(row, inc(), 'Pack Quantity', boldStyle)
|
| 365 |
worksheet.write(row, inc(), 'NetPendingOrderQty', boldStyle)
|
366 |
worksheet.write(row, inc(), 'NetPendingOrderQty', boldStyle)
|
| 366 |
worksheet.write(row, inc(), 'PreviouslyOrderedQty', boldStyle)
|
367 |
worksheet.write(row, inc(), 'PreviouslyOrderedQty', boldStyle)
|
| 367 |
worksheet.write(row, inc(), 'Pack Quantity', boldStyle)
|
- |
|
| 368 |
worksheet.write(row, inc(), 'AverageSale', boldStyle)
|
368 |
worksheet.write(row, inc(), 'AverageSale', boldStyle)
|
| 369 |
worksheet.write(row, inc(), 'Pending RTOs', boldStyle)
|
369 |
worksheet.write(row, inc(), 'Pending RTOs', boldStyle)
|
| 370 |
worksheet.write(row, inc(), 'NumDaysStock', boldStyle)
|
370 |
worksheet.write(row, inc(), 'NumDaysStock', boldStyle)
|
| 371 |
worksheet.write(row, inc(), 'MinStockReq', boldStyle)
|
371 |
worksheet.write(row, inc(), 'MinStockReq', boldStyle)
|
| 372 |
worksheet.write(row, inc(), 'Additional Qty', boldStyle)
|
372 |
worksheet.write(row, inc(), 'Additional Qty', boldStyle)
|
| Line 389... |
Line 389... |
| 389 |
worksheet.write(row, inc(), codCount)
|
389 |
worksheet.write(row, inc(), codCount)
|
| 390 |
worksheet.write(row, inc(), long(lineitem.get('quantity'))-long(codCount))
|
390 |
worksheet.write(row, inc(), long(lineitem.get('quantity'))-long(codCount))
|
| 391 |
worksheet.write(row, inc(), lineitem.get('unitPrice'))
|
391 |
worksheet.write(row, inc(), lineitem.get('unitPrice'))
|
| 392 |
worksheet.write(row, inc(), lineitem.get('nlc'))
|
392 |
worksheet.write(row, inc(), lineitem.get('nlc'))
|
| 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 |
reservedCount = 0
|
395 |
reservedCount = 0
|
| 395 |
if lineitem.get('reservedQuantity') is not None:
|
396 |
if lineitem.get('reservedQuantity') is not None:
|
| 396 |
reservedCount = lineitem.get('reservedQuantity')
|
397 |
reservedCount = lineitem.get('reservedQuantity')
|
| 397 |
worksheet.write(row, inc(), long(lineitem.get('availableQuantity'))-long(reservedCount))
|
398 |
worksheet.write(row, inc(), long(lineitem.get('availableQuantity'))-long(reservedCount))
|
| 398 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
399 |
worksheet.write(row, inc(), lineitem.get('previouslyOrderedQty'))
|
| 399 |
worksheet.write(row, inc(), lineitem.get('packQuantity'))
|
- |
|
| 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'))
|
| 404 |
|
404 |
|