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

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

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 than
Zoho 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 stepped
Authtoken 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