{"@odata.context":"https://api.businesscentral.dynamics.com/v2.0/5bb5b6c7-c97d-4183-b7e4-c85971d1772e/Production/api/kashaglobal/invoices/v1.0/$metadata#companies(72f92bc4-f6b6-ec11-8aa5-00224865acd7)/customPostedSalesInvoices","value":[{"@odata.etag":"W/\"JzIwOzE0OTg5NjAxMTcyNjYxODQ4NDQ3MTswMDsn\"","id":"07c16892-ff79-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100000","orderNumber":"KE/SO/24/124030","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":2000,"amountIncludingVAT":2000,"remainingAmount":0,"customerNumber":"CKE022537","customerName":"Safmart Shop","billToAddress":"Thika, makongeni opposite BAT","sellToAddress":"Thika, makongeni opposite BAT","shipToAddress":"Thika, makongeni opposite BAT","salespersonCode":"3157","salespersonPhone":"727532244","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-25","corrective":false,"cancelled":true,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"Insufficient funds to pay","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-25T07:17:12.01Z","sellToPhoneNo":"714290247","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:00:11.64Z","deliveryReadyDateTime":"2024-09-23T23:00:01.613Z","postingDateTime":"2024-09-23T23:00:15.09Z","orderCreationDateTime":"2024-09-23T16:43:15.397Z","deliveryStatus":"Assigned","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"2024-09-25T07:17:11.747Z","completedDate":"2024-09-25T07:17:12.01Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":15.48,"deliveryCoordinates":"-1.3500617, 36.8967883","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzIwOzEzMjc2MjE4NDA0MjI5NDA4NzExMTswMDsn\"","Line_No":10000,"Document_No":"KE/PSI/24/100000","Type":"Item","No":"3071","Description":"Raha Premium Maize Flour 1kg","Location_Code":"MAIN","Quantity":1,"Unit_of_Measure_Code":"BOX","Unit_of_Measure":"Box","Unit_Cost_LCY":1960.00008,"Unit_Price":2000,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":2000,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":2000,"Total_Amount_Incl_VAT":2000,"VAT_Prod_Posting_Group":"ZERO","VAT_Percent":0,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:00:14.737Z","Pharma_Dim":"GC PRODUCT","Category":"GROCERIES","Sales_Price_Excl_VAT":2000}]},{"@odata.etag":"W/\"JzE5Ozg4Nzg4ODMwOTk0MTgxNTMwNzUxOzAwOyc=\"","id":"180e61ae-ff79-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100001","orderNumber":"KE/SO/24/124032","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":16368,"amountIncludingVAT":16368,"remainingAmount":0,"customerNumber":"CKE020526","customerName":"Kinangop Shop","billToAddress":"Thika, Kiganjo","sellToAddress":"Thika, Kiganjo","shipToAddress":"Thika, Kiganjo","salespersonCode":"3157","salespersonPhone":"727532244","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T19:05:35.46Z","sellToPhoneNo":"727087968","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:00:53.12Z","deliveryReadyDateTime":"2024-09-23T23:00:44.2Z","postingDateTime":"2024-09-23T23:00:56.7Z","orderCreationDateTime":"2024-09-23T16:51:44.46Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T12:50:15.513Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":126.71,"deliveryCoordinates":"-1.1570477, 36.9201683","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzIwOzE2MTMwMjg2MTY5OTM4Mjc4ODk1MTswMDsn\"","Line_No":10000,"Document_No":"KE/PSI/24/100001","Type":"Item","No":"2140","Description":"Mara moja 100's tablets","Location_Code":"MAIN","Quantity":1,"Unit_of_Measure_Code":"BOX","Unit_of_Measure":"Box","Unit_Cost_LCY":15835.296,"Unit_Price":16368,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":16368,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"4100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":16368,"Total_Amount_Incl_VAT":16368,"VAT_Prod_Posting_Group":"EXEMPT","VAT_Percent":0,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"WHOLESALER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:00:56.457Z","Pharma_Dim":"HHP PRODUCT","Category":"PAIN KILLERS","Sales_Price_Excl_VAT":16368}]},{"@odata.etag":"W/\"JzE5OzIwNjc2Nzg5Mjk4MzM2MTMwNDYxOzAwOyc=\"","id":"4b736bc8-ff79-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100002","orderNumber":"KE/SO/24/123659","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":25300,"amountIncludingVAT":25300,"remainingAmount":0,"customerNumber":"CKE020230","customerName":"Mathene Shop","billToAddress":"Thika, kiganjo","sellToAddress":"Thika, kiganjo","shipToAddress":"Thika, kiganjo","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T19:07:30.95Z","sellToPhoneNo":"721462039","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:01:36.803Z","deliveryReadyDateTime":"2024-09-23T23:01:24.007Z","postingDateTime":"2024-09-23T23:01:40.59Z","orderCreationDateTime":"2024-09-23T07:19:02.73Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T13:16:41.097Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":195.86,"deliveryCoordinates":"-1.1570571, 36.9201708","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzIwOzE0MTY3Mjk2Mjk3MjQxNDE2NDUwMTswMDsn\"","Line_No":10000,"Document_No":"KE/PSI/24/100002","Type":"Item","No":"2749","Description":"Biryani Rice 25kg","Location_Code":"MAIN","Quantity":10,"Unit_of_Measure_Code":"PCS","Unit_of_Measure":"Piece","Unit_Cost_LCY":2501.66667,"Unit_Price":2530,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":25300,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":25300,"Total_Amount_Incl_VAT":25300,"VAT_Prod_Posting_Group":"EXEMPT","VAT_Percent":0,"Gen_Bus_Posting_Group":"LOCAL-DBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:01:40.197Z","Pharma_Dim":"GC PRODUCT","Category":"WHITE RICE","Sales_Price_Excl_VAT":2530}]},{"@odata.etag":"W/\"JzIwOzE1MjQ4MDE1OTU1NjExMDQyMTI0MTswMDsn\"","id":"68ecc6e1-ff79-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100004","orderNumber":"KE/SO/24/123656","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":15172.4,"amountIncludingVAT":17599.98,"remainingAmount":0,"customerNumber":"CKE019730","customerName":"Kwa Maina Shop","billToAddress":"Thika, Kiganjo","sellToAddress":"Thika, Kiganjo","shipToAddress":"Thika, Kiganjo","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T19:07:31.03Z","sellToPhoneNo":"701992212","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:02:16.483Z","deliveryReadyDateTime":"2024-09-23T23:02:07.4Z","postingDateTime":"2024-09-23T23:02:20.26Z","orderCreationDateTime":"2024-09-23T07:16:38.89Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T13:27:30.647Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":136.25,"deliveryCoordinates":"0.0, 0.0","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzE5OzcxMjUxMzU3NDcxNjA3NjM0MDkxOzAwOyc=\"","Line_No":10000,"Document_No":"KE/PSI/24/100004","Type":"Item","No":"2957","Description":"Samli Cooking Fat 10kg-Yellow","Location_Code":"MAIN","Quantity":10,"Unit_of_Measure_Code":"PCS","Unit_of_Measure":"Piece","Unit_Cost_LCY":1491.37924,"Unit_Price":1517.24,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":15172.4,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":15172.4,"Total_Amount_Incl_VAT":17599.98,"VAT_Prod_Posting_Group":"VAT-STANDARD16","VAT_Percent":16,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:02:19.5Z","Pharma_Dim":"GC PRODUCT","Category":"COOKING FAT","Sales_Price_Excl_VAT":1517.24}]},{"@odata.etag":"W/\"JzIwOzE4MTA1Mzc2ODU4NjU5MDYwMDYwMTswMDsn\"","id":"0db823f8-ff79-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100005","orderNumber":"KE/SO/24/123531","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":15172.4,"amountIncludingVAT":17599.98,"remainingAmount":0,"customerNumber":"CKE020388","customerName":"Wa Sam Shop","billToAddress":"Thika Makongeni","sellToAddress":"Thika Makongeni","shipToAddress":"Thika Makongeni","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-25T13:06:32.323Z","sellToPhoneNo":"714195807","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:02:59.13Z","deliveryReadyDateTime":"2024-09-23T23:02:49.73Z","postingDateTime":"2024-09-23T23:03:03.653Z","orderCreationDateTime":"2024-09-23T05:07:58.907Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T18:16:36.68Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":136.25,"deliveryCoordinates":"-1.0986232, 37.0767567","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzE4OzM0MDc5NDA1NzkwNzYzMjMwNjE7MDA7Jw==\"","Line_No":10000,"Document_No":"KE/PSI/24/100005","Type":"Item","No":"2957","Description":"Samli Cooking Fat 10kg-Yellow","Location_Code":"MAIN","Quantity":10,"Unit_of_Measure_Code":"PCS","Unit_of_Measure":"Piece","Unit_Cost_LCY":1491.37924,"Unit_Price":1517.24,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":15172.4,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":15172.4,"Total_Amount_Incl_VAT":17599.98,"VAT_Prod_Posting_Group":"VAT-STANDARD16","VAT_Percent":16,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:03:02.933Z","Pharma_Dim":"GC PRODUCT","Category":"COOKING FAT","Sales_Price_Excl_VAT":1517.24}]},{"@odata.etag":"W/\"JzE5Ozk4NTQ5OTkxNzcwMzI5MjYzODkxOzAwOyc=\"","id":"37773f04-007a-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100006","orderNumber":"KE/SO/24/123528","externalDocumentNumber":"","orderDate":"2024-09-24","postingDate":"2024-09-24","amountExcludingVAT":15172.4,"amountIncludingVAT":17599.98,"remainingAmount":0,"customerNumber":"CKE020937","customerName":"Wa Devis Shop","billToAddress":"Gachororo near JKUAT","sellToAddress":"Gachororo near JKUAT","shipToAddress":"Gachororo near JKUAT","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T17:06:47.173Z","sellToPhoneNo":"722176232","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:03:17.18Z","deliveryReadyDateTime":"2024-09-23T23:02:58.573Z","postingDateTime":"2024-09-23T23:03:24.763Z","orderCreationDateTime":"2024-09-23T05:04:22.963Z","deliveryStatus":"Assigned","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T17:06:47.17Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":136.25,"deliveryCoordinates":"-1.1573498, 36.9589761","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzIwOzE0NTMyNTk3MDI0MTI2OTkxMTcxMTswMDsn\"","Line_No":10000,"Document_No":"KE/PSI/24/100006","Type":"Item","No":"2957","Description":"Samli Cooking Fat 10kg-Yellow","Location_Code":"MAIN","Quantity":10,"Unit_of_Measure_Code":"PCS","Unit_of_Measure":"Piece","Unit_Cost_LCY":1491.37924,"Unit_Price":1517.24,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":15172.4,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":15172.4,"Total_Amount_Incl_VAT":17599.98,"VAT_Prod_Posting_Group":"VAT-STANDARD16","VAT_Percent":16,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:03:24.087Z","Pharma_Dim":"GC PRODUCT","Category":"COOKING FAT","Sales_Price_Excl_VAT":1517.24}]},{"@odata.etag":"W/\"JzE5OzIwOTg2OTc0NzY5MzcxNDMxNDAxOzAwOyc=\"","id":"6675a613-007a-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100007","orderNumber":"KE/SO/24/123611","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":15172.4,"amountIncludingVAT":17599.98,"remainingAmount":0,"customerNumber":"CKE020538","customerName":"First Born Shop","billToAddress":"Thika , Kiganjo","sellToAddress":"Thika , Kiganjo","shipToAddress":"Thika , Kiganjo","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T19:07:31.11Z","sellToPhoneNo":"792008461","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:03:45.28Z","deliveryReadyDateTime":"2024-09-23T23:03:36.09Z","postingDateTime":"2024-09-23T23:03:50.027Z","orderCreationDateTime":"2024-09-23T06:32:35.89Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T16:56:47.803Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":136.25,"deliveryCoordinates":"-1.1570109, 36.9202709","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzE5OzM0MTY1MDk4NTU0NjA3MjgxMzIxOzAwOyc=\"","Line_No":10000,"Document_No":"KE/PSI/24/100007","Type":"Item","No":"2957","Description":"Samli Cooking Fat 10kg-Yellow","Location_Code":"MAIN","Quantity":10,"Unit_of_Measure_Code":"PCS","Unit_of_Measure":"Piece","Unit_Cost_LCY":1491.37924,"Unit_Price":1517.24,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":15172.4,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":15172.4,"Total_Amount_Incl_VAT":17599.98,"VAT_Prod_Posting_Group":"VAT-STANDARD16","VAT_Percent":16,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:03:49.33Z","Pharma_Dim":"GC PRODUCT","Category":"COOKING FAT","Sales_Price_Excl_VAT":1517.24}]},{"@odata.etag":"W/\"JzIwOzEwMjA0OTg0OTc3MzY3OTAzOTAxMTswMDsn\"","id":"fdc90eb5-e37b-ef11-a671-6045bd41cec6","number":"KE/PSI/24/100008","orderNumber":"KE/SO/24/123928","externalDocumentNumber":"","orderDate":"2024-09-25","postingDate":"2024-09-26","amountExcludingVAT":0,"amountIncludingVAT":0,"remainingAmount":0,"customerNumber":"CKE022078","customerName":"Gatundu Dealers","billToAddress":"Gatundu town-wamwangi on your way to mangu","sellToAddress":"Gatundu town-wamwangi on your way to mangu","shipToAddress":"Gatundu town-wamwangi on your way to mangu","salespersonCode":"13821","salespersonPhone":"254745467416","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CANCELLED","closed":true,"closedDate":"0001-01-01","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-27T13:04:58.023Z","sellToPhoneNo":"701486101","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"0001-01-01T00:00:00Z","deliveryReadyDateTime":"2024-09-24T22:35:19.497Z","postingDateTime":"0001-01-01T00:00:00Z","orderCreationDateTime":"0001-01-01T00:00:00Z","deliveryStatus":"Assigned","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"0001-01-01T00:00:00Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":0,"deliveryCoordinates":"-1.0949749, 37.079439","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzE5OzQ5MDkxNDgxNzM0MjM3NTYwMTExOzAwOyc=\"","Line_No":10000,"Document_No":"KE/PSI/24/100008","Type":"_x0020_","No":"","Description":"Deleted Document","Location_Code":"","Quantity":0,"Unit_of_Measure_Code":"","Unit_of_Measure":"","Unit_Cost_LCY":0,"Unit_Price":0,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":0,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"","Shortcut_Dimension_2_Code":"","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":0,"Total_Amount_Incl_VAT":0,"VAT_Prod_Posting_Group":"","VAT_Percent":0,"Gen_Bus_Posting_Group":"","Gen_Prod_Posting_Group":"","VAT_Bus_Posting_Group":"","Customer_Price_Group":"","Posting_Date":"0001-01-01","Last_Modified_DateTime":"2024-09-26T08:45:42.247Z","Pharma_Dim":"","Category":"","Sales_Price_Excl_VAT":0}]},{"@odata.etag":"W/\"JzE5Ozk0MDk0NzM4NzMzNTU0NTg0NjcxOzAwOyc=\"","id":"0924e42d-007a-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100009","orderNumber":"KE/SO/24/123756","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":1980,"amountIncludingVAT":1980,"remainingAmount":0,"customerNumber":"CKE011769","customerName":"Njoki( kwa pastor)","billToAddress":"Murera ndarasha( Ruiru kimbo)","sellToAddress":"Murera ndarasha( Ruiru kimbo)","shipToAddress":"Murera ndarasha( Ruiru kimbo)","salespersonCode":"10484","salespersonPhone":"254741946010","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-24","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-24T19:07:30.553Z","sellToPhoneNo":"794157869","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:04:27.043Z","deliveryReadyDateTime":"2024-09-23T23:04:17.503Z","postingDateTime":"2024-09-23T23:04:31.39Z","orderCreationDateTime":"2024-09-23T08:43:02.51Z","deliveryStatus":"Delivered","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-24T17:02:31.99Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":15.33,"deliveryCoordinates":"-1.3502786, 36.896788","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzIwOzEwODg2NDkwNDI4MzE2NjYwMjM0MTswMDsn\"","Line_No":10000,"Document_No":"KE/PSI/24/100009","Type":"Item","No":"3070","Description":"Raha Premium Maize Flour 2kg","Location_Code":"MAIN","Quantity":1,"Unit_of_Measure_Code":"BOX","Unit_of_Measure":"Box","Unit_Cost_LCY":1940.00004,"Unit_Price":1980,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":1980,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"2100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":1980,"Total_Amount_Incl_VAT":1980,"VAT_Prod_Posting_Group":"ZERO","VAT_Percent":0,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:04:31.15Z","Pharma_Dim":"GC PRODUCT","Category":"MAIZE FLOUR","Sales_Price_Excl_VAT":1980}]},{"@odata.etag":"W/\"JzIwOzEwMTQ0MTM3MjY3MTAyNzU3OTkyMTswMDsn\"","id":"ec523447-007a-ef11-a671-6045bd41ece8","number":"KE/PSI/24/100010","orderNumber":"KE/SO/24/123866","externalDocumentNumber":"","orderDate":"2024-09-23","postingDate":"2024-09-24","amountExcludingVAT":3103.44,"amountIncludingVAT":3599.99,"remainingAmount":0,"customerNumber":"CKE040369","customerName":"Adax Shop Marrum","billToAddress":"marrum kenyatta road on the way to gatundu","sellToAddress":"marrum kenyatta road on the way to gatundu","shipToAddress":"marrum kenyatta road on the way to gatundu","salespersonCode":"13821","salespersonPhone":"254745467416","agentSupervisor":"FAITH WANGARI","associatedSalesperson":"SP38","orderChannel":"WHATSAPP","orderStatusKasha":"New","orderVerification":"CC - CONFIRMED","closed":true,"closedDate":"2024-09-25","corrective":false,"cancelled":false,"sellToPostCode":"KIAMBU","billToPostCode":"KIAMBU","shipToPostCode":"KIAMBU","yourReference":"","additionalPaymentReferences":"","orderComments":"","contentFromNotes":"Notes are currently locked.","cancellationReason":"","shippingAgentCode":"","shippingAgentServiceCode":"","lastModifiedDateTime":"2024-09-25T08:36:41.113Z","sellToPhoneNo":"25472329008","locationCode":"MAIN","pickupLat":"","pickupLong":"","pickupTime":"0001-01-01T00:00:00Z","deliveryLat":"","deliveryLong":"","deliveryTime":"0001-01-01T00:00:00Z","releaseDateTime":"2024-09-23T23:05:11.733Z","deliveryReadyDateTime":"2024-09-23T23:05:01.277Z","postingDateTime":"2024-09-23T23:05:16.777Z","orderCreationDateTime":"2024-09-23T10:54:20.403Z","deliveryStatus":"Assigned","cancellationLat":"","cancellationLong":"","cancellationTime":"0001-01-01T00:00:00Z","returnLat":"","returnLong":"","returnTime":"0001-01-01T00:00:00Z","driverCancelDropdown":"","driverCancelNotes":"","returnedToWarehouseEmpl":"","warehouseReturnNotes":"","retailTypeName":"KIOSK SHOP","shortcutDimension1Code":"AGENTBULK","UIcancellationDateTime":"0001-01-01T00:00:00Z","completedDate":"2024-09-25T08:36:41.113Z","assginedDateTime":"0001-01-01T00:00:00Z","transactionDate":"","utm_tags":"","projectTag_1":"","projectTag_2":"","projectTag_3":"","projectTag_4":"","projectTag_5":"","ACY_Amount":27.87,"deliveryCoordinates":"-1.0935451, 37.0785703","sdpsiLinesAPI":[{"@odata.etag":"W/\"JzE5OzUzMjUxMzQ0NDI3OTk4MTI5OTkxOzAwOyc=\"","Line_No":20000,"Document_No":"KE/PSI/24/100010","Type":"Item","No":"1001","Description":"Menengai Cream Bar Soap 1kg","Location_Code":"MAIN","Quantity":1,"Unit_of_Measure_Code":"BOX","Unit_of_Measure":"Box","Unit_Cost_LCY":3060.346,"Unit_Price":3103.44,"Bulk_Promotion":"","Line_Discount_Percent":0,"Line_Amount":3103.44,"Line_Discount_Amount":0,"Allow_Invoice_Disc":true,"Deferral_Code":"","Shortcut_Dimension_1_Code":"AGENTBULK","Shortcut_Dimension_2_Code":"1100","Invoice_Discount_Amount":0,"Total_Amount_Excl_VAT":3103.44,"Total_Amount_Incl_VAT":3599.99,"VAT_Prod_Posting_Group":"VAT-STANDARD16","VAT_Percent":16,"Gen_Bus_Posting_Group":"LOCAL-AGENTBULK","Gen_Prod_Posting_Group":"SALE","VAT_Bus_Posting_Group":"LOCAL","Customer_Price_Group":"RETAILER","Posting_Date":"2024-09-24","Last_Modified_DateTime":"2024-09-23T23:05:16.507Z","Pharma_Dim":"HHP PRODUCT","Category":"MULTIPURP BAR SOAP","Sales_Price_Excl_VAT":3103.44}]}]}