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









                            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 WorkDrive Resources



                                                                  Zoho Campaigns Resources

                                                                    Zoho CRM Resources

                                                                    • CRM Community Learning Series

                                                                      CRM Community Learning Series


                                                                    • Tips

                                                                      Tips

                                                                    • 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