Spreadsheet: 758464d1638887150-populate-data-based-on-selection-from-dropdown-project-planning
Sheet: Sales

Date | Voucher No | Branch | Currency | Exchange Rate | Party | Item Type | Other Account | Product | UOM | Quantity | Free Quantity | Unit Rate | Gross Amount | VATCST Amount | Net Amount | Net Amount In Company Currency | Division | Invoice No | Gross Amount2
2021-08-25 00:00:00 | SI 6731 | LIFECON | SAR | 1 | ITC - Sadar | Items |  | HDD & Install HDPE pipe 200mmx1, SDR17 PN10 | M | 414 |  | 750 | SAR 310,500.00 |  | SAR 310,500.00 | SAR 310,500.00 | OSP | 6731 | 310500
2021-08-12 00:00:00 | SI 6711 | LIFECON | SAR | 1 | [NAME] | Items |  | HDD & Install HDPE pipe 200mmx8 SDR17 PN10 | M | 82.5 |  | 2180 | SAR 179,850.00 | SAR 26,977.50 | SAR 206,827.50 | SAR 206,827.50 | OSP | 6711 | 179850
2021-08-12 00:00:00 | SI 6712 | LIFECON | SAR | 1 | NASRE AL JAZIRA CONT. CO. | Items |  | HDD & Install HDPE pipe 200x4 SDR17 PN10 | M | 45 |  | 1580 | SAR 71,100.00 | SAR 10,665.00 | SAR 81,765.00 | SAR 81,765.00 | OSP | 6712 | 71100
2021-08-25 00:00:00 | SI 6729 | LIFECON | SAR | 1 | Al Azaem Power Tech | Items |  | HDD & Install HDPE pipe 200x4 SDR17 PN10 | M | 125 |  | 1499 | SAR 187,375.00 | SAR 28,106.25 | SAR 215,481.25 | SAR 215,481.25 | OSP | 6729 | 187375
2021-08-09 00:00:00 | SI 6707 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDD & Install HDPE pipe 315x1 SDR17 PN10 | M | 101.7 |  | 710 | SAR 72,207.00 | SAR 10,831.05 | SAR 83,038.05 | SAR 83,038.05 | OSP | 6707 | 72207
2021-08-09 00:00:00 | SI 6708 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDD & Install HDPE pipe 315x1 SDR17 PN10 | M | 92 |  | 710 | SAR 65,320.00 | SAR 9,798.00 | SAR 75,118.00 | SAR 75,118.00 | OSP | 6708 | 65320
2021-08-22 00:00:00 | SI 6726 | LIFECON | SAR | 1 | KEIR International Co | Items |  | HDD & Install HDPE pipe 315x1 SDR17 PN10 | M | 70 |  | 800 | SAR 56,000.00 | SAR 8,400.00 | SAR 64,400.00 | SAR 64,400.00 | OSP | 6726 | 56000
2021-08-19 00:00:00 | SI 6724 | LIFECON | SAR | 1 | Global Communication Trading & Contracting Co. Ltd. | Items |  | HDD & Install HDPE pipe Ф110x1 SDR17 PN10 | M | 103 |  | 370 | SAR 38,110.00 | SAR 5,716.50 | SAR 43,826.50 | SAR 43,826.50 | OSP | 6724 | 38110
2021-08-08 00:00:00 | SI 6699 | LIFECON | SAR | 1 | AL ANADEE CO | Items |  | HDD & Install HDPE pipe Ф160x1 SDR17 PN10 | M | 119 |  | 710 | SAR 84,490.00 | SAR 12,673.50 | SAR 97,163.50 | SAR 97,163.50 | OSP | 6699 | 84490
2021-08-16 00:00:00 | SI 6714 | LIFECON | SAR | 1 | AL ANADEE CO | Items |  | HDD & Install HDPE pipe Ф160x1 SDR17 PN10 | M | 70 |  | 710 | SAR 49,700.00 | SAR 7,455.00 | SAR 57,155.00 | SAR 57,155.00 | OSP | 6714 | 49700
2021-08-30 00:00:00 | SI 6733 | LIFECON | SAR | 1 | CCS Jeddah | Items |  | HDD & Install HDPE pipe Ф160x1 SDR17 PN10 | M | 358 |  | 440 | SAR 157,520.00 | SAR 23,628.00 | SAR 181,148.00 | SAR 181,148.00 | OSP | 6733 | 157520
2021-08-25 00:00:00 | SI 6725 | LIFECON | SAR | 1 | Tamimi Global Co Ltd | Items |  | HDD & Install HDPE pipe Ф200x1 SDR17 PN10 | M | 47 |  | 650 | SAR 30,550.00 | SAR 4,582.50 | SAR 35,132.50 | SAR 35,132.50 | OSP | 6725 | 30550
2021-08-08 00:00:00 | SI 6698 | LIFECON | SAR | 1 | [NAME]. [NAME] | Items |  | HDD & Install HDPE pipe Ф200x2 SDR17 PN10 | M | 60 |  | 880 | SAR 52,800.00 | SAR 7,920.00 | SAR 60,720.00 | SAR 60,720.00 | OSP | 6698 | 52800
2021-08-19 00:00:00 | SI 6723 | LIFECON | SAR | 1 | [NAME] | Items |  | HDD & Install HDPE pipe Ф200x2 SDR17 PN10 | M | 155 |  | 1329 | SAR 205,995.00 | SAR 30,899.25 | SAR 236,894.25 | SAR 236,894.25 | OSP | 6723 | 205995
2021-08-25 00:00:00 | SI 6728 | LIFECON | SAR | 1 | AL YAMAMA CO. | Items |  | HDD & Install HDPE pipe Ф200x2 SDR17 PN10 | M | 94 |  | 1000 | SAR 94,000.00 | SAR 14,100.00 | SAR 108,100.00 | SAR 108,100.00 | OSP | 6728 | 94000
2021-08-25 00:00:00 | SI 6730 | LIFECON | SAR | 1 | [NAME] | Items |  | HDD & Install HDPE pipe Ф200x2 SDR17 PN10 | M | 52 |  | 1329 | SAR 69,108.00 | SAR 10,366.20 | SAR 79,474.20 | SAR 79,474.20 | OSP | 6730 | 69108
2021-08-01 00:00:00 | SI 6641 | LIFECON | SAR | 1 | AL SAHELY CO | Items |  | HDD & Install HDPE pipe Ф200x6 SDR17 PN10 | M | 60 |  | 2006 | SAR 120,360.00 | SAR 18,054.00 | SAR 138,414.00 | SAR 138,414.00 | OSP | 6641 | 120360
2021-08-09 00:00:00 | SI 6709 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDD & Install HDPE pipe Ф500x1 SDR17 PN10 | M | 58.3 |  | 2550 | SAR 148,665.00 | SAR 22,299.75 | SAR 170,964.75 | SAR 170,964.75 | OSP | 6709 | 148665
2021-08-09 00:00:00 | SI 6707-1 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDPE Pipe Jointing | Nos | 9 |  | 1800 | SAR 16,200.00 | SAR 2,430.00 | SAR 18,630.00 | SAR 18,630.00 | OSP | 6707-1 | 16200
2021-08-09 00:00:00 | SI 6708-2 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDPE Pipe Jointing | Nos | 8 |  | 1800 | SAR 14,400.00 | SAR 2,160.00 | SAR 16,560.00 | SAR 16,560.00 | OSP | 6708-1 | 14400
2021-08-09 00:00:00 | SI 6709-3 | LIFECON | SAR | 1 | Badan Agricultural Company | Items |  | HDPE Pipe Jointing | Nos | 5 |  | 1800 | SAR 9,000.00 | SAR 1,350.00 | SAR 10,350.00 | SAR 10,350.00 | OSP | 6709-1 | 9000
2021-08-08 00:00:00 | SI 6698 | LIFECON | SAR | 1 | [NAME]. [NAME] | Items |  | Machine Mobilization-1 | Nos | 1 |  | 5000 | SAR 5,000.00 | SAR 750.00 | SAR 5,750.00 | SAR 5,750.00 | OSP | 6698-1 | 5000
2021-08-12 00:00:00 | SI 6712 | LIFECON | SAR | 1 | NASRE AL JAZIRA CONT. CO. | Items |  | Machine Mobilization-2 | Nos | 1 |  | 7000 | SAR 7,000.00 | SAR 1,050.00 | SAR 8,050.00 | SAR 8,050.00 | OSP | 6712-1 | 7000
2021-08-25 00:00:00 | SI 6725 | LIFECON | SAR | 1 | Tamimi Global Co Ltd | Items |  | Machine Mobilization-3 | Nos | 1 |  | 12450 | SAR 12,450.00 | SAR 1,867.50 | SAR 14,317.50 | SAR 14,317.50 | OSP | 6725-1 | 12450