Purchase vs Consumption Unit of Measure Conversions

I'm new to Zoho but I'm not new to ERP systems and I have a new small business i'd like to use Zoho for CRM and Inventory primarily.

I'm piloting some initial master & transactional data to see how the system works and I'm having trouble mapping a few of my use cases to the solution.

First, a bit of business background. This is for an indoor hydroponic grow operation. In my case we'll be procuring lots of seeds, grow plugs, and nutrients as raw materials. I need to be able to track inventory for both raw materials (non sellable) and finished goods (most likely composite items).

My first problem is I need to track the batch number from seed to sale. Unfortunately it looks like the batch tracking is only available for "sales" materials, not "purchase" materials. I have configured some purchase only raw materials (because I don't want these to show up as available for sales orders) but I can't input a batch number when recording the purchase receipt.

My next problem is seeds are not sold in a consistent unit of measure and even if they were the purchase UoM is different than the consumption UoM on a bill of materials (composite item).

For example, on my most recent purchase order some seeds are sold by:

count (i.e. 1000 or 5000 seeds)

ounces (i.e. half ounce, ounce, or even lb)

packet (count is often unknown but averages exist - i.e. Seed 1 - Avg 10,000 seeds per packet, Seed 2 - 7,000 seeds per packet).

If i order 1 container of 1000 seeds when I receive I'd like to be able to say this 1 purchase unit has a 1000 seeds. When I create a composite item to hold the seed, the plug, the nutrients, and the labor I need to consume 1 seed only.

I could change the PO item to reflect the number of seeds; however, many of items I won't know how many seeds I get nor is that how my vendor actually wants to receive my order so the order details are wrong.

Any ideas on what I might be missing or how I can configure the system to do what I need?

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

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

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Shaun Williams
Akshaya G

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