SyncVirtualStock

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;
}