void Intercompany.Intercompany_BillstoBooks(int ID)
{
// 266977000000478229
so_id = ID;
po_data = Select_Margin[ID == so_id];
fetorg = Organization_Master[ID == po_data.Deal_Organization];
fetpo = Purchase_Order[Purchase_Order == po_data.Purchase_Order];
acc1 = Account_Master[Organization_Name == po_data.Deal_Organization && Account_Name == po_data.Purchase_Organization.Organization_Name];
accsub1 = Account_Master_Books_Details[Account_Master_ID == acc1.ID && Organization_Name == po_data.Deal_Organization && Type_field == "Vendor"];
//info fetorg.Organization_Code;
fetsm = Select_Margin[ID != null && Bill_Number != null] sort by Bill_Number desc;
if(fetsm.count() == 0)
{
Order_no = "Bill" + "-" + 00001;
}
else
{
last_so = getsuffix(fetsm.Bill_Number,"-");
so_value = (ifnull(last_so.toLong(),0) + 1).trim().leftpad(5).replaceAll(" ","0");
Order_no = "Bill" + "-" + so_value;
}
main_map = Map();
main_map.put("vendor_id",accsub1.Books_ID);
main_map.put("reference_number",fetpo.Bill_Books_ID);
main_map.put("bill_number",Order_no);
main_map.put("date",zoho.currentdate.toString("yyyy-MM-dd"));
Line_list = List();
line_map = Map();
for each line_data in po_data
{
item_data = Item_Master[ID == line_data.Item_Name];
itm = Item_Master_Books_Details[Item_Master_ID == item_data.ID];
for each rec in itm
{
if(rec.Organization_Code.Organization_Code == fetorg.Organization_Code)
{
itmbks = rec.Item_Books_ID;
}
// info itmbks;
//info rec.Organization_Code.Organization_Code;
}
// info fetorg.Organization_Code;
// Align the line Details
line_map.put("item_id",itmbks);
break;
}
line_map.put("quantity",1);
line_map.put("rate",po_data.Total_Amount);
Line_list.add(line_map);
//info line_map ;
main_map.put("line_items",Line_list);
// info main_map;
response_books = invokeurl
[
url :"https://www.zohoapis.in/books/v3/bills?organization_id=" + fetorg.Organization_Code
type :POST
parameters:main_map.toString()
connection:"books"
];
info response_books;
if(0 == response_books.get("code"))
{
bill_data = response_books.get("bill");
po_data.PO_Bills_ID=bill_data.get("bill_id");
po_data.Bill_Number=bill_data.get("bill_number");
}
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter