Convert Sales Order to Invoice in custom function (code)

Convert Sales Order to Invoice in custom function (code)


Hi..
I have tried to run this code
Unfortunately it didn't work
I am trying to convert a sales order into an invoice on the same date as the sales order
This is done when updating a specific field of the sales order






  2. respMap = zoho.books.getRecordById("Sales_Orders", input.soId.toLong());
  3. productDet = ifnull(respMap.get("product"),"");
  4. productList = productDet.toJSONList();
  5. pdlist = List();
  6. for each eachProd in productList
  7. {
  8. eachProdDet = eachProd.toMap();
  9. productDesc = ifnull(eachProdDet.get("Product Description"),"");
  10. quantity = ifnull(eachProdDet.get("Quantity"),"0");
  11. listPrice = (ifnull(eachProdDet.get("List Price"),"0.0")).toDecimal();
  12. netTotal = (ifnull(eachProdDet.get("Net Total"),"0.0")).toDecimal();
  13. linediscount = (ifnull(eachProdDet.get(("Discount")),"0.0")).toDecimal();
  14. total = (ifnull(eachProdDet.get("Total"),"0.0")).toDecimal();
  15. productId = ifnull(eachProdDet.get("Product Id"),"");
  16. linetax = (ifnull(eachProdDet.get("Tax"),"")).toDecimal();
  17. mp = map();
  18. mp.put("Product Id", productId);
  19. mp.put("Quantity", quantity);
  20. mp.put("List Price", listPrice);
  21. mp.put(("Discount"), linediscount);
  22. mp.put("Total", total);
  23. mp.put("Tax", linetax);
  24. mp.put("Net Total", netTotal);
  25. pdlist.add(mp);
  26. }
  27. paramap = map();
  28. paramap.put("Products", pdlist);
  29. paramap.put("Subject", ifnull(respMap.get("Subject"),""));
  30. paramap.put("CONTACTID", ifnull(respMap.get("CONTACTID"),""));
  31. paramap.put("Terms and Conditions", ifnull(respMap.get("Terms and Conditions"),""));
  32. paramap.put("Description", ifnull(respMap.get("Description"),""));
  33. paramap.put("Tax", (ifnull(respMap.get("Tax"),"0.0")).toDecimal());
  34. paramap.put("Adjustment", (ifnull(respMap.get("Adjustment"),"0.0")).toDecimal());
  35. paramap.put(("Discount"), (ifnull(respMap.get(("Discount")),"0.0")).toDecimal());
  36. paramap.put("Sub Total", (ifnull(respMap.get("Sub Total"),"0.0")).toDecimal());
  37. paramap.put("Grand Total", (ifnull(respMap.get("Grand Total"),"0.0")).toDecimal());
  38. paramap.put("Invoice Date", (ifnull(respMap.get("Order Date"),"0.0")).toDecimal());
  39. createResp = zoho.books.create("Invoices", paramap);
  40. return "Invoice created successfully";