First of all, the code attached is not mine I got off the internet and it's working ok except the regional date is incorrect its failing to pick Pretoria or Harare time Zone. Is it possible someone can assist to correct the VBA code attached.
Below is my final working of my data
Below is my final working of my data
Code:
] Ì{
"PosVendor": "Nector Prime Accounting Solutions",
"PosSoftVersion": "2.0.0.1",
"PosModel": "Cap-2017",
"PosSerialNumber": "20230117220000",
"IssueTime": "20230117220000",
"TransactionType": 0,
"PaymentMode": 3,
"SaleType": 1,
"LocalPurchaseOrder": null,
"Cashier": "Admin Manager",
"BuyerTPIN": null,
"BuyerName": "MWIINDE",
"BuyerTaxAccountName": "MWIINDE",
"BuyerAddress": null,
"BuyerTel": null,
"OriginalInvoiceCode": null,
"OriginalInvoiceNumber": null,
"Memo": null,
"Currency-Type": "ZMW",
"Conversion-Rate": 1,
"Items": [
{
"ItemId": 1,
"Description": "RICE 50 KGS",
"BarCode": "871253",
"Quantity": 10,
"UnitPrice": 150,
"Discount": 0,
"TaxLabels": [
"A",
"E"
],
"TotalAmount": 1500,
"IsTaxInclusive": true,
"RRP": 0
}
]
}Þ^