Copy from one field to another using Custom Functions
Hi, I have attempted to write the following function to copy the purchase price to sell price when the purchase price is updated on an Item. Once I have solved this I then need to draft a function to update the purchase price from the most recent purchase order, but that's down the line for now.
itemID = zoho.inventory.getRecordsByID("items",[entered my organisation ID],"item_ID");
purchasePrice = item.get("purchase_rate");
newRate = Map();
newRate.put("rate",purchasePrice);
update = zoho.inventory.updateRecord("items",[entered my organisation ID],itemID,newRate);
info newRate;
info update;
After executing, all appears OK....
Result
Function Executed Successfully
Log Messages
{"rate":"70.0"}
java.lang.Object@4ed6233f
After executing, the Item sell price (rate) is not updated from the purchase price field (purchase_rate)
Sell Price currently set at £0.00
Purchase Price currently set at £70.00
I have then set up a Workflow to try and trigger when any field on the item is updated, however the Sell Price (rate) remains at £0.00 and it does not pull the updated purchase price (purchase_rate) of £70.00 (in this test)
Thanks in advance
Chris
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
manager.acmezz
Madhan Gopal
Sticky Posts
Zoho Inventory will discontinue support for older browser versions soon
Hello users, Starting from May 15, 2024, Zoho Inventory will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older thanZoho Finance Workshop 2023 is coming to the USA. Meet the experts, get exclusive training on Zoho Finance apps and more.
Hello all, We'd like to invite you to our biggest Zoho Finance workshop in the United States. After a brief break, we are excited to be back. This year, we're bringing together our customers and community members for two days of curated hands-on sessions,Celebrating our Zoho Community SuperBuds
The SuperBud program recognizes the efforts Zoho users put in to help the rest of the community thrive and grow in their individual Zoho journeys. Be it the ZUG meetups or these forums, several Zoho users including our MVPs andZUG leaders, have steppedAuthtoken Deprecation for Zoho Inventory APIs
UPDATE (7 July 2021): We've extended the deadline to 30 August 2021 for converting Authtokens to OAuth. Hello everyone, The usage of Authtokens to authenticate API calls is being deprecated on 30 August 2021 across Zoho's Finance suite of products,ZOHO Inventory - Early Access
https://twitter.com/zoho/status/646715717849493504
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー