Composite item converted to Sales Order does not list the individual items on the sales order

@Madhan Gopal

I am a building contractor.

I buy all material as needed and do not keep any inventory, so inventory management is not a concern (or a solution) for this problem.

I produce estimates for customer approval, and then convert the estimates into a sales order.

From there, the sales order can be converted to multiple invoices for deposit and progress payments.

The sales order can also be converted into a sales order so I can order the material needed to construct the project.

When I convert the sale order to a purchase order, all I see is the composite item, not the individual items that are required to create the composite item.

I need purchase orders that list each individual item, and the quantity of each item.

I would think this is a real problem for every company that orders material on demand instead of ordering material based on inventory levels.

This is a standard feature on most software applications

Here is one solution.

When converting a sales order to a purchase order, a simple code that does something like this

For Example

On convert to purchase order (from Sales Order)

For each item in list

If item flags as composite then
Add Associated Items and quantities
Multiply quantities by composite item quantities
Remove OG composite item
Next
Else
Next

This would (in my mind at least) run through each of the items on the sales order, check if it is composite, add on all of the associated items in the required quantities, remove the composite item.

Is there a way to achieve this?

If not, Composite items are useless for every company that orders material on demand instead of ordering material based on inventory levels.

Zoho Desk Resources

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

Topic Participants
darren
nanda
Donald Love

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