--------------------------------------------------------------- Log Entry : 1/2/2024 10:31:42 AM - ------------------------------------------------------------- {"iTransId":0,"iDocNo":1,"iDocType":1,"iDate":"2024-01-02","iAccount":39,"iApproved":0,"iSuspended":0,"iUser":11,"sNarration":"","sCustomer":"Hubbell Power Systems Inc.","TransBody":[{"iTransDtId":1,"iFixedAsset":0,"iTag1":1,"iTag2":36,"iTag3":0,"iTag4":0,"iTag5":0,"iTag6":0,"iTag7":0,"iTag8":1,"iTag9":0,"iTag10":0,"fRate":342.65,"fQty":6.0,"fVat":0.0,"iAssetType":17,"sRemarks":null,"sName":"Slotted Blanket - C4060348","sTaxCode":"SR","sPoNo":"2019/RM/9186","iLinkId":62943,"iApproved":0,"iReturnDate":null}]} --------------------------------------------------------------- Log Entry : 1/2/2024 10:35:13 AM - ------------------------------------------------------------- {"iTransId":0,"iDocNo":2,"iDocType":1,"iDate":"2024-01-02","iAccount":35,"iApproved":0,"iSuspended":0,"iUser":11,"sNarration":"","sCustomer":"Afaq Al Khaleej Engineering Resources LLC","TransBody":[{"iTransDtId":1,"iFixedAsset":0,"iTag1":3,"iTag2":37,"iTag3":0,"iTag4":0,"iTag5":0,"iTag6":0,"iTag7":0,"iTag8":3,"iTag9":0,"iTag10":0,"fRate":27.0,"fQty":1.0,"fVat":0.0,"iAssetType":1,"sRemarks":null,"sName":"Vise Grip - Universal Plier (Tengtool) TT-74250051","sTaxCode":"SR","sPoNo":"2020/RP/6001","iLinkId":419438889,"iApproved":0,"iReturnDate":null}]} --------------------------------------------------------------- Log Entry : 1/2/2024 10:40:11 AM - ------------------------------------------------------------- {"iTransId":681,"iDocNo":1,"iDocType":1,"iDate":"2024-01-02","iAccount":39,"iApproved":0,"iSuspended":0,"iUser":11,"sNarration":" ","sCustomer":"Hubbell Power Systems Inc.","TransBody":[{"iTransDtId":1,"iFixedAsset":0,"iTag1":1,"iTag2":36,"iTag3":0,"iTag4":0,"iTag5":0,"iTag6":0,"iTag7":0,"iTag8":1,"iTag9":0,"iTag10":0,"fRate":342.65,"fQty":6.0,"fVat":0.0,"iAssetType":17,"sRemarks":"","sName":"Slotted Blanket - C4060348","sTaxCode":"SR","sPoNo":"2019/RM/9186","iLinkId":62943,"iApproved":0,"iReturnDate":null},{"iTransDtId":2,"iFixedAsset":0,"iTag1":1,"iTag2":36,"iTag3":0,"iTag4":0,"iTag5":0,"iTag6":0,"iTag7":0,"iTag8":5,"iTag9":0,"iTag10":0,"fRate":304.25,"fQty":6.0,"fVat":0.0,"iAssetType":23,"sRemarks":"","sName":"Solid Blanket - C4060346","sTaxCode":"SR","sPoNo":"2019/RM/9186","iLinkId":62942,"iApproved":0,"iReturnDate":null}]} --------------------------------------------------------------- Log Entry : 1/2/2024 11:16:46 AM - ------------------------------------------------------------- obj={"sName":"Fibreglass Double Extension Ladder - 11.4 Mtr","sCode":"MT000006","sAltName":"2019/RM/911","sBarcode":"444444444","sRegNo":" 250","sInvNo":" ","iAssetType":1,"iAssetSubCategory":7,"iCompany":3,"iLocation":22,"iSupplier":194,"iProject":57,"iWarehouse":3,"iPurchaseDate":"2019-02-22","fPurchaseValue":1216,"fCumDeprValue":0,"fInsuredValue":1216,"fScrapValue":250,"fITDeprRate":0.33,"fITAccr":20,"fQty":1,"sImagePath":"","image":null,"bDepreciable":true,"iDepreciation":1,"iUnitOfUsage":0,"fLifePeriod":3,"iDateOfCommencement":"2023-12-26","iWriteOfPeriodYr":3,"iWriteOfPeriodMonth":36,"iAssetAc":269,"iAccumDeprAc":277,"iDeprPLAc":285,"iDisposalGain":292,"iDisposalLoss":300,"sModel":"2019","sMake":" ","sDateYear":"0","sSection":" ","iId":6,"iUser":11} --------------------------------------------------------------- Log Entry : 1/2/2024 11:20:33 AM - ------------------------------------------------------------- obj={"sName":"vsd","sCode":"000153","sAltName":"","sBarcode":" ","sRegNo":" ","sInvNo":" ","iAssetType":0,"iAssetSubCategory":0,"iCompany":6,"iLocation":0,"iSupplier":0,"iProject":0,"iWarehouse":0,"iPurchaseDate":"2023-12-27","fPurchaseValue":0,"fCumDeprValue":0,"fInsuredValue":0,"fScrapValue":0,"fITDeprRate":0,"fITAccr":0,"fQty":2,"sImagePath":"","image":null,"bDepreciable":false,"iDepreciation":0,"iUnitOfUsage":0,"fLifePeriod":0,"iDateOfCommencement":null,"iWriteOfPeriodYr":0,"iWriteOfPeriodMonth":0,"iAssetAc":0,"iAccumDeprAc":0,"iDeprPLAc":0,"iDisposalGain":0,"iDisposalLoss":0,"sModel":" ","sMake":" ","sDateYear":" ","sSection":" ","iId":8468,"iUser":11} --------------------------------------------------------------- Log Entry : 1/2/2024 3:40:43 PM - ------------------------------------------------------------- TransactionController Method:LoadDepreciation System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting date and/or time from character string. at Sang.Asset.WebAPI.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.Asset.WebAPI.Controllers.TransactionController.LoadDepreciation(Int32 iAssetType, Int32 iMonth, Int32 iYear) ClientConnectionId:da4940d8-b2e3-4503-81a5-77ef67a1bb32 Error Number:241,State:1,Class:16