Item to item transfer both quantity and value

Item to item transfer both quantity and value

We are using zoho inventory extensively and making the most out of it by just using native functionality although it is missing a few functionalities like Bins and multi-level BOM handling.

But one thing is still challenging which is item-to-item transfer. I hope I'm not alone needed this feature. 

If you are in a typical manufacturing company (SME) and sell only composite items, where we have one associated item (raw material) is a part of multiple composite items. Let's say we make 4 different models of mobile phones ( Sku's: A, B, C, D - Composite items) with the same battery (associated item). Now the battery SKU is a part of multiple composite items. 

Generally, companies plan the procurement of the raw materials (Battery - I'm referring to only one item for better understating) based on the sales and demand of the finished good which is the Mobile Phone (Composite item). 

Let's say the company planned to produce the below composite items where the battery (Associated item) is common across the composite items.

SKU: A - 10,000 EA
SKU: B - 5,000 EA
SKU: C - 3,000 EA
SKU: D - 2,000 EA

Now based on the above plan the procurement team has to procure a single model of battery of 20,000 quantities which are part of multiple composite items. We'll release the Purchase order for the battery (Single SKU) and we'll receive the stock of 20,000.

Now, if we go to composite bunding the system will show that "You can bundle 20,000 mobile phones" for each model (A, B, C, D) irrespective of the above production plan. 

My Request: If we can transfer the battery(item) into a different item, let's say I create 4 more SKUs for each model mobile and transfer the required quantities as per the production plan would be a more ideal process I believe. Using this method I can reverse calculate that what is my plan and what is my actual stock.

I know we can achieve this using "Inventory adjustment" but it will create more problems in terms of cost tracking and physical item identity since every item will be tracked with bar coded serial number.

I have taken an example of one particular item, but trust me if you are handling multiple composite items in the above environment a lot of Excel work has to be maintained.

Currently, there are no specific reports for bundling in inventory somehow we are managing using zoho analytics for production reports and planning reports. Every company needs one particular report which is how many that they can manufacture (composite items) using the associated raw materials levels. If possible add this as a default report.

It would be a big relief for the companies who use Zoho Inventory if zoho can provide the below essentials
  1. Item-to-item transfer 
  2. Serial number generation upon bundling action
  3. Option to mark associated items as committed items when a composite item sales order is confirmed
  4. Reserve inventory against sales order
  5. Bundling reports and custom fields in the bundling layout
  6. Re-order levels warehouse-specific
  7. BINS
  8. Negative stock controls warehouse-specific stock, currently, it is controlled by org-specific stock.

Regards,
Tirumala





    Access your files securely from anywhere

        Zoho Developer Community




                                  Zoho Desk Resources

                                  • Desk Community Learning Series


                                  • Digest


                                  • Functions


                                  • Meetups


                                  • Kbase


                                  • Resources


                                  • Glossary


                                  • Desk Marketplace


                                  • MVP Corner


                                  • Word of the Day



                                      Zoho Marketing Automation


                                              Manage your brands on social media



                                                    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

                                                                          • CRM Community Learning Series

                                                                            CRM Community Learning Series


                                                                          • Kaizen

                                                                            Kaizen

                                                                          • Functions

                                                                            Functions

                                                                          • Meetups

                                                                            Meetups

                                                                          • Kbase

                                                                            Kbase

                                                                          • Resources

                                                                            Resources

                                                                          • Digest

                                                                            Digest

                                                                          • CRM Marketplace

                                                                            CRM Marketplace

                                                                          • MVP Corner

                                                                            MVP Corner





                                                                              Design. Discuss. Deliver.

                                                                              Create visually engaging stories with Zoho Show.

                                                                              Get Started Now