void Books.SyncVirtualStock(int recid) { books_access = thisapp.Books.Get_Books_Access(); conn_tok = books_access.get("connection"); org_id = books_access.get("organisation_id"); getinventory = Inventory[ID != null]; //cnt = 0; for each rec in getinventory { fet_vs = Virtual_Stock[Inventory_Rec_ID == rec.ID]; //info fet_vs.Part_No.Part_No; if(fet_vs.count() == 0) { // cnt = cnt + 1; // info rec.Part_No.Part_No; ins = insert into Virtual_Stock [ Warehouse=rec.Warehouse Available_Qty=rec.Available_Qty Part_Description=rec.Part_Description Sub_Location=rec.Sub_Location Location_Name=rec.Location_Name Rack_Number=rec.Rack_Number Total_Qty=rec.Total_Qty Part_No=rec.Part_No UOM=rec.UOM Category=rec.Category Sub_Category=rec.Sub_Category Inventory_Rec_ID=rec.ID Added_User=zoho.loginuser ]; } else if(fet_vs.Block_Qty == null || fet_vs.Block_Qty >= 0) { fet_vs.Available_Qty=rec.Available_Qty; fet_vs.Total_Qty=rec.Total_Qty; fet_vs.Block_Qty=rec.Block_Qty; } } //info cnt; }