Get_Payments_ID_from_Books
Tue Jan 07 2025 15:19:42 GMT+0000 (Coordinated Universal Time)
Saved by
@Pooja
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
];
}
content_copyCOPY
Comments