Spreadsheet: 872164d1718547289-is-there-any-other-way-to-do-this-book2-1-rev002
Sheet: Sheet1

Date | Job # | Inovice Number | Invoice Status | Branch Name | Branch ID | Customer Type | Customer ID | Customer Name | Mobile Number | Sex | Customer Notes | Car Plate Number | [NAME] | [NAME] | Model ID | [NAME] | Manufacuring Year | Mileage | Offer Code | Promo Code | Supervisor ID | [NAME] | Technician | Technician ID | Service/Part | Service/Part ID | Item Name | Category ID | Category | Quantity | Unit Price | Total Price | Discount | Net of Discount | VAT % | [NAME] | Total Include VAT | Trade Market ID | Trade Market | Specification ID | Specification | Average Cost | Purchase Price | Payment Type | Cutomer Employee ID | Inv_Final_Status
2023-03-30 00:00:00 | 1 | HGT4 | invoiced | Khurais | 57 | individually | 30873 | عبد الرحمن | 530471341 |  |  | DVA9798 | 143 | TOYOTA | 30 | LAND CRUISER | 2004 | 445699 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | Service | 45 | FUEL SYSTEM CLEAN | 36 | INELECTOR&AIR INTAKE SYSTEM CLEAN | 1 | 200 | 200 | 0 | 200 | 15 | 30 | 230 |  |  |  |  |  |  | Credit
2023-03-30 00:00:00 | 1 | HGT4 | returned | Khurais | 57 | individually | 30873 | عبد الرحمن | 530471341 |  |  | DVA9798 | 143 | TOYOTA | 30 | LAND CRUISER | 2004 | 445699 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | part | 775 | INELECTOR&AIR INTAKE SYSTEM CLEAN BG 2983 GDI SYSTEM CLEANING(Pcs) | 36 | INELECTOR&AIR INTAKE SYSTEM CLEAN | 1 | 421.4 | 421.4 | 0 | 421.4 | 15 | 63.21 | 484.61 | 15 | BG | 717 | 2983 GDI SYSTEM CLEANING | 343.85 |  | Credit |  | R
2023-03-30 00:00:00 | 59 | HGT14 | invoiced | Khurais | 57 | individually | 30873 | عبد الرحمن | 530471341 |  |  | DVA9798 | 143 | TOYOTA | 30 | LAND CRUISER | 2004 | 445699 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | Service | 45 | FUEL SYSTEM CLEAN | 36 | INELECTOR&AIR INTAKE SYSTEM CLEAN | -1 | 200 | -200 | 0 | -200 | 15 | -30 | -230 |  |  |  |  |  |  | Credit |  | I
2023-03-30 00:00:00 | 59 | HGT14 | invoiced | Khurais | 57 | individually | 30873 | عبد الرحمن | 530471341 |  |  | DVA9798 | 143 | TOYOTA | 30 | LAND CRUISER | 2004 | 445699 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | part | 775 | INELECTOR&AIR INTAKE SYSTEM CLEAN BG 2983 GDI SYSTEM CLEANING(Pcs) | 36 | INELECTOR&AIR INTAKE SYSTEM CLEAN | -1 | 421.4 | -421.4 | 0 | -421.4 | 15 | -63.21 | -484.61 | 15 | BG | 717 | 2983 GDI SYSTEM CLEANING | 343.85 |  | Credit |  | I
2023-03-31 00:00:00 | 95 | [NAME] | invoiced | Khurais | 57 | individually | 30886 | [NAME] | 505559831 |  |  | GZD6400 | 143 | TOYOTA | 19 | CAMRY | 2020 | 174000 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | 1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Cash |  | R
2023-03-31 00:00:00 | 95 | [NAME] | invoiced | Khurais | 57 | individually | 30886 | [NAME] | 505559831 |  |  | GZD6400 | 143 | TOYOTA | 19 | CAMRY | 2020 | 174000 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | part | 749 | ENGINE OIL TOYOTA 10W40(LTR) | 8 | ENGINE OIL | 1 | 40 | 40 | 0 | 40 | 15 | 6 | 46 | 17 | TOYOTA | 96 | 10W40 | 20.62 |  | Cash |  | R
2023-03-31 00:00:00 | 95 | [NAME] | returned | Khurais | 57 | individually | 30886 | [NAME] | 505559831 |  |  | GZD6400 | 143 | TOYOTA | 19 | CAMRY | 2020 | 174000 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | -1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Cash |  | R
2023-03-31 00:00:00 | 95 | [NAME] | returned | Khurais | 57 | individually | 30886 | [NAME] | 505559831 |  |  | GZD6400 | 143 | TOYOTA | 19 | CAMRY | 2020 | 174000 |  |  | 15 | محمود الجرحي | RABIN DAYAL | 47 | part | 749 | ENGINE OIL TOYOTA 10W40(LTR) | 8 | ENGINE OIL | -1 | 40 | -40 | 0 | -40 | 15 | -6 | -46 | 17 | TOYOTA | 96 | 10W40 | 20.62 |  | Cash |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | invoiced | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | 1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | invoiced | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | part | 137 | ENGINE OIL ORIZON 5W40(LTR) | 8 | ENGINE OIL | 1 | 40 | 40 | 0 | 40 | 15 | 6 | 46 | 5 | ORIZON | 103 | 5W40 | 19.81 |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | invoiced | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 38 | ENGINE OIL FILTER CHANGE | 16 | O/F | 1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | invoiced | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | part | 733 | O/F TOYOTA 90915-10009(Pcs) | 16 | O/F | 1 | 53.04347826 | 53.04347826 | 0 | 53.04347826 | 15 | 7.956521739 | 61 | 17 | TOYOTA | 399 | 90915-10009 | 34.62 |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | invoiced | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 44 | CAR FLUIDS CHECK | 38 | SERVICE | 1 | 13 | 13 | 0 | 13 | 15 | 1.95 | 14.95 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | returned | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | -1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | returned | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | part | 137 | ENGINE OIL ORIZON 5W40(LTR) | 8 | ENGINE OIL | -1 | 40 | -40 | 0 | -40 | 15 | -6 | -46 | 5 | ORIZON | 103 | 5W40 | 19.81 |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | returned | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 38 | ENGINE OIL FILTER CHANGE | 16 | O/F | -1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | returned | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | part | 733 | O/F TOYOTA 90915-10009(Pcs) | 16 | O/F | -1 | 53.04347826 | -53.04347826 | 0 | -53.04347826 | 15 | -7.956521739 | -61 | 17 | TOYOTA | 399 | 90915-10009 | 34.62 |  | Credit |  | R
2023-04-04 00:00:00 | 256 | CFQ380 | returned | tawiq | 68 | individually | 30968 | محمد احمد الشمراني | 501835805 |  |  | ebr7071 | 143 | TOYOTA | 19 | CAMRY | 2022 | 31222 |  |  | 13 | حسن منصور | JAMALUDIN ABDULLAH TUGAYA | 53 | Service | 44 | CAR FLUIDS CHECK | 38 | SERVICE | -1 | 13 | -13 | 0 | -13 | 15 | -1.95 | -14.95 |  |  |  |  |  |  | Credit |  | R
2023-04-04 00:00:00 | 282 | CFQ862 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | 5 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ862 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | part | 131 | ENGINE OIL ORIZON 20W50(LTR) | 8 | ENGINE OIL | 5 | 18.26 | 91.3 | 0 | 91.3 | 15 | 13.695 | 104.995 | 5 | ORIZON | 100 | 20W50 | 3.97 |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ862 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | Service | 38 | ENGINE OIL FILTER CHANGE | 16 | O/F | 1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ862 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | part | 651 | O/F TOYOTA 04152-31090(Pcs) | 16 | O/F | 1 | 45.2173913 | 45.2173913 | 0 | 45.2173913 | 15 | 6.782608696 | 52 | 17 | TOYOTA | 350 | 04152-31090 | 30.24 |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ629 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | Service | 37 | ENGINE OIL CHANGE | 8 | ENGINE OIL | -5 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ629 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | part | 131 | ENGINE OIL ORIZON 20W50(LTR) | 8 | ENGINE OIL | -5 | 18.26 | -91.3 | 0 | -91.3 | 15 | -13.695 | -104.995 | 5 | ORIZON | 100 | 20W50 | 3.97 |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ629 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | Service | 38 | ENGINE OIL FILTER CHANGE | 16 | O/F | -1 | 0 | 0 | 0 | 0 | 15 | 0 | 0 |  |  |  |  |  |  | Credit |  | I
2023-04-04 00:00:00 | 282 | CFQ629 | invoiced | [NAME] | 69 | individually | 30983 | زياد عبدالرحمن | 501285574 |  |  | kvd4383 | 143 | TOYOTA | 19 | CAMRY | 2013 | 179021 |  |  | 11 | [NAME] الغلبان | RAJAN RAI | 10 | part | 651 | O/F TOYOTA 04152-31090(Pcs) | 16 | O/F | -1 | 45.2173913 | -45.2173913 | 0 | -45.2173913 | 15 | -6.782608696 | -52 | 17 | TOYOTA | 350 | 04152-31090 | 30.24 |  | Credit |  | I