void Payments.Payments(int booksid) { fet_payBook = Get_Payments_ID_from_Books[ID == input.booksid]; bksid = fet_payBook.Payment_Books_ID; books_access = thisapp.Books.Get_Books_Access(); conn_tok = books_access.get("connection"); org_id = books_access.get("organisation_id"); get_payresp = zoho.books.getRecordsByID("customerpayments",org_id,bksid,conn_tok); // info get_payresp; pay_data = get_payresp.tomap().get("payment"); // info pay_data ; custname = pay_data.get("customer_name"); payid = pay_data.get("payment_id"); custid = pay_data.get("customer_id"); //info custid; invoices = pay_data.get("invoices").toList(); invlist = List(); invid = List(); invamt = List(); payamnt = List(); for each rec in invoices { map_val = rec.toMap(); invoice_ID = map_val.get("invoice_id"); invoice_no = map_val.get("invoice_number"); inv_amnt = map_val.get("invoice_amount"); pay_amnt = map_val.get("amount_applied"); fetinv = Invoice[Zoho_Books_ID == invoice_ID].ID; fetinvno = Invoice[Invoice_No == invoice_no]; fetinvamnt = Invoice[Grand_Total == inv_amnt]; fetpayamnt = Payments[Payment_Amount == pay_amnt]; invlist.add(fetinvno); invid.add(fetinv); invamt.add(inv_amnt); pay_amnt.add(pay_amnt); } customer_id = Customers[Customer_Books_ID == custid].ID; amtrec = pay_data.get("amount"); paydate = pay_data.get("date"); //-------------------------------------------------- paymode = pay_data.get("payment_mode"); invdate = pay_data.get("date"); // invno = pay_data.get("invoice_number"); payno = pay_data.get("payment_number"); payins = insert into Payments [ Added_User=zoho.loginuser Customer_Name=customer_id Payment_ID=payid Customer_ID=custid Amount_Received=amtrec Payment_Date=paydate Payment_Mode=paymode Invoice_Date=invdate Inv_ID=invid Invoice_No1=invlist Payment_No=payno Payment_Status="Success" Invoice_Amount=invamt Payment_Amount=payamnt ]; }