Give access to PriceLists in Deluge (custom fucntions)
Give me access to "PriceLists" via custom fucntions with deluge
Please add the one line of code that allows zoho.books.getrecords("Pricelist"...... and zoho.books.getRecordsByID("Pricelist"......
Its concerning that I can access Invoices, bank records, sales orders, purchase orders etc this way but I can not access a simple list of data for pricelists
-
Brad Hassell commented
OH EUREKA! Better WorkAround
Step 1) Create "pricelist" in books so manual PO creation can access correct prices
Step 2) Export "pricelist"
Step 3) add multi-line Text box as custom field for each Item
Step 4) add pricelist data as JSON for a specific item to the custom field created above in each itemThis eliminates the need to call zoho.crm.getrecords and reduces the number of deluge calls in a cunction since the data is now available when fetching an item using zoho,books.get records
Still silly
-
Brad Hassell commented
ZOHO DEVELOPMENT TEAM:
The following is an example at how silly this is
To work around the inability of deluge to access "Price List" from custom function in books and because I need a custom function to be able to read this simple list of data in order to create accurate purchase orders from a custom function the following is the most simplistic work around (that does not require writing a custom API, Creator App, and most importantly NOT re-writing the custom function I use to create POs in bulk each monthWORK AROUND:
Step 1) Create "pricelist" in books so manual PO creation can access correct prices
Step 2) Create field in CRM Products module to hold the exact same data, since PriceLists are also not synced to any other app
Step 3) Use zoho.books.getRecordsByID to access items it Books and aquire Zcrm Product ID
Step 4) Use zoho.crm.getRecordsBy ID to access the correct product in CRM, then access correct field to know the correct item price
Step 5) Use response from Step 4 to create PO with correct price using zoho.books.createRecord