Production/Inventory Maangement

Production/Inventory Maangement

I am looking for a Zoho developer to create or modify a system to suitthe following. 'Order Management' does everything except the simple production aspect - we only produce one type of product and take weeks if not months to fulfill a single order of that one product - Btch Control is our key control element. 

Our business is very simple. Our Invoicing procedure is not complex, just different. 

 We have two raw materials. One raw material (Product A(n)) is trucked in in bulk between eight and twenty times per day. An INVENTORY ITEM is produced for each Product A which, while there will be very few ‘Product A’s’ they are identified SEPARATELY by their basic composition and source. To put it into perspective, we only envisage two Product As at this point in time. A PURCHASE ORDER is required for the complete order of Product A, which may be fulfilled over anything from 15 days to several years, and may be for anything from 15,000 to several hundred thousand tonnes.
 The INVENTORY system will show a PENDING PURCHASE ORDER for the full amount. A CHANGE ORDER is required to either increase or decrease the RATE at which Product A is delivered (in tonnes per day). Product A is measured in metric tonnes to two decimal place and weighed on entry. A WEIGHBRIDGE CERTIFICATE is produced and needs to be entered into the system.

 EVENTUALLY this should be automated but it is NOT desired in the first iteration. When the weighbridge certificate is entered into the system, the INVENTORY for Product A should automatically INCREASE by the measured amount and the pending purchase order shall decrease accordingly. Product B is brought in two or four times a month, in liquid form, and is measured in litres. A PURCHASE ORDER is required for each delivery. The INVENTORY system will show a PENDING PURCHASE ORDER for the full amount. When Product B is delivered it is accompanied by a DELIVERY DOCKET. When the Delivery Docket is entered into the system, the INVENTORY for Product B should automatically INCREASE by the delivered amount and the pending purchase order shall decrease accordingly.

 The CREDITORS must INCREASE by the value of the purchase. Throughout the day, Product A is blended with Product B to create Product C(n).
 Product C will weigh approximately 2% more than Product A. A WORKS ORDER is produced EACH DAY by the Site Supervisor describing the Product ID (C) and/or the BATCH ID (see below). The Inventory will show a PENDING WORKS ORDER for the anticipated daily production. Every two hours a PRODUCTION REPORT is filled out (by hand in this first iteration) and handed to the Site Clerk. When the Production Report is entered against the Works Order, the INVENTORY for Product C(n) increases accordingly. EVERY DAY multiple shipments of Product C are made to the client. At the end of each day, if all goes according to plan, we will have delivered the same amount of material as we have received, but we have a stockpile of 8,000 tonnes, so we need to INVENTORY EXCEPTION REPORT on Inventory of Product A on hand and create rules to either speed up or slow down deliveries of Product A. There will also be a stockpile of Product C that has been processed that day but not yet collected. We need a DASHBOARD chart that shows Inventory Levels of Product A (Generic), Product B and Product C (Generic). I use the term generic because we MAY have two sources of Product A on site at the same time, and there MAY be two batches of Product C overlapping but, for control purposes, they can all be grouped together on the DASHBOARD. It is RARE that we will be processing two different products on the same day (almost impossible), but two clients COULD be drawing from the same Batch on any one day. In other words, we may be processing Product C for two or even three clients, who will either collect it or have it delivered several times a day, but we would not PROCESS Product C1 and Product C2 on the same day. We would use the change in product specification to do a service of the Plant, so we would not process Product A1 and Product A2 on the same day. With every delivery to the client a DELIVERY DOCKET is created. Now, the complicating issue in this rather simple process is that Product A can vary in its specification. For this reason, every few days a sample of Product C (NOT Product A) is taken and sent to a laboratory for testing. Thirty-six hours later the results come back and that specification is assigned to that BATCH of Product C. If any parameter in the analysis (there can be five to ten parameters, depending on the client’s requirements) is outside its tolerances, then an ADJUSTMENT has to be made to the SELLING PRICE of that particular Product C (OR ITS BATCH). At a certain cut-off point, that may be a date, an agreed quantity (maybe 10,000 tonnes, which may take 15 days to fulfill) we INVOICE the goods delivered against a Sales Contract (Sales Order) – represented by the Delivery Dockets - which may be, forexample, 270,000 tonnes over 18 months. A PENDING SALES ORDER needs to be created and this needs to be adjusted each time product is delivered.

The Invoice has a long schedule of deliveries made up of: 

• Consignment Date: CD
• Delivery Docket ID: DD
 • Product ID: PID
• Batch ID: BID
• Vehicle ID: VID
• Weighbridge Docket ID: WID
• Consignment Weight: WGT
• Batch within Parameters Y/N: OK?
• Batch Price (per tonne): BPR
• Consignment Price: CPR

This can probably be summarised in a single page as follows CD DD PID BID WID WGT OK? BPR CPR (USD) 14.01.17 000107 ACF01 140115 1345 39.27 Y 21.92 860.80 14.01.17 000108 ACF01 140115 1346 40.10 Y 21.92 850.12 14.01.17 000109 ACF01 140115 1347 39.76 Y 21.92 871.54 14.01.18 000110 ACF01 140117 1351 40.12 N 21.12 847.33 14.01.18 000111 ACF01 140117 1353 39.27 N 21.12 829.38 14.01.21 000123 ACF01 140121 1365 41.02 Y 21.92 899.16 INVOICE TOTAL USD 5,158.33

Each Delivery Docket needs to create a PENDING DEBTOR so that, at any point in time, we can have a Report showing what our Debtors and pending Debtors are. This, along with Trade Creditor and general administration transactions, will automatically link to an accounting module, to be handled in the normal way.


Budget : Depends on whether one can modify Order Management | Duration : First Stage Urgent - Full system Two weeks

To leave a private message, please click the link for private response in post Action section.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


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




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ






                                ご検討中の方

                                  • Recent Topics

                                  • Duplicated Notebooks

                                    Out of the blue, almost all of my notebooks got duplicated and the different copies contain different information. Some seem like older copies than the others. I use the linux desktop app and sometimes the Android app. I assume that the sync failed at some point and was unable to merge the two versions together. But I'm afraid to add anything else to my notebook because if it can't properly sync 5 notebooks with only a handful of notes each, what will happen when I have hundreds of notes and I lose
                                  • Currency limitation when integrating Zoho CRM & Zoho Books

                                    Brief Video of Problem: https://www.loom.com/share/d61d1d07d0904e149d80c1901a22418e. Background ·       Our business is based in Australia and we have to have Zoho Books in AUD to comply with tax and reporting regulations in Australia. ·       We sell
                                  • Multi-select Lookup does not have Advanced filter options in CRM

                                    With much fanfare Zoho announced the advanced filter options for CRM lookup fields which was a nice addition. This feature is not available for Multi-Select lookup fields. Will it be rolled out in the next 3-6 months, considering the standard lookup filter
                                  • Experience effortless record management in CRM For Everyone with the all-new Grid View!

                                    Hello Everyone, Hope you are well! As part of our ongoing series of feature announcements for Zoho CRM For Everyone, we’re excited to bring you another type of module view : Grid View. In addition to Kanban view, List view, Canvas view, Chart view and
                                  • Unable to copy into a new document

                                    Whe I create a new Writer doc and attemp to copy and past I get this message. The only way to copy into a document is I duplicate an existing document, erase the text and save it under a different name and then paste the information. Not ideal. Can you
                                  • Kaizen #157: Flyouts in Client Script

                                    Hello everyone! Welcome back to another exciting edition of our Kaizen series, where we explore fresh insights and innovative ideas to help you discover more and expand your knowledge!In this post, we'll walk through how to display Flyouts in Client Script
                                  • Customize User Invites with Invitation Templates

                                    Invitation Templates help streamline the invitation process by allowing users to create customized email formats instead of sending a one-size-fits-all email. Different invitation templates can be created for portal users and client users to align with
                                  • Admin Control Over Profile Picture Visibility in Zoho One

                                    Hello Zoho Team, We hope you are doing well. Currently, as per Zoho’s design, each user can manage the visibility of their profile picture from their own Zoho Accounts page: accounts.zoho.com → Personal Information → Profile Picture → Profile Picture
                                  • Published Course Not Reflecting In Hub

                                    Hi! I am trying to create micro-learning courses for our team to be available for self-guided learning. I have published the courses with enrollment settings open to all users of the hub, but they don't appear to be available for enrollment. Am I missing
                                  • Unlock Locked Users via Zoho One Mobile App

                                    Hello Zoho One Team, We have noticed that in the Zoho One web admin panel, we can unlock a locked user when needed. However, when using the Zoho One mobile app, there is no indication that a user is locked, nor is there an unlock button similar to what
                                  • Tip #47- Stay Ahead with Automated Scheduled Reports in Zoho Assist- 'Insider Insights'

                                    We’ve made it easier for you to stay informed, even when you’re busy managing remote sessions! With Scheduled Reports in Zoho Assist, you can now automatically receive detailed insights about your remote support and unattended access activities directly
                                  • Colour Coded Flags in Tasks Module List View

                                    I really like the colour coded flags indicating the status of the tasks assigned to a Contact/Deal in the module list view. It would be a great addition to have this feature available in the list view of activities/tasks. I understand you have the Due
                                  • Uploading data to S3

                                    Has anyone successfully uploaded data from Creator to S3 using the InvokeURL command or any other method in Deluge? (keywords: S3, AWS, Amazon, bucket)
                                  • UPS Label size when generated via Zoho

                                    We've integrated UPS with Zoho inventory. When creating and downloading the shipping labels they are created in a larger paper size. I'd like them to be generated to print on a 4x6 printer. Zoho have told me I need to do this within our UPS portal. UPS
                                  • Credit Management: #4 Credits on Unused Period

                                    Recall a familiar situation. You sign up for a monthly gym membership. You pay the subscription fee upfront, get motivated, and show up consistently for the first week. Then, suddenly, you get caught up in work deadlines, travel plans, or a dip in motivation.
                                  • Zoho Analytics Automatically Deletes Queries and Reports When a Synced CRM Field Is Removed

                                    We’ve encountered a serious and recurring issue that poses a massive data integrity risk for any Zoho Analytics customer using Zoho CRM integration. When a field is deleted in Zoho CRM — even an unused one — Zoho Analytics automatically deletes every
                                  • Prevent new Record Association

                                    Hello all, We have a small sales organization therefore, it's helpful for everyone on the sales team to be able to view the full list of accounts to assist in preventing duplicate accounts from being created. However we want to prevent people from creating
                                  • Tip of the Week #73– Automate workflow with Make integration.

                                    Make is a no-code workflow automation platform designed to connect your favorite apps and automate repetitive tasks across services. By integrating Make with Zoho TeamInbox, you can streamline everyday inbox management and save valuable time. With this
                                  • Viewing attachments

                                    I'm using a Web Form integrated in my web site to collect Leads several info, including a image upload. In order to to approve each lead, we have to view the image uploaded. Unfortunately, in the Leads view, the Attachments can only be downloaded, not
                                  • Kaizen #89 - Color Coding using Client Script

                                    Hello everyone! Welcome back to another exciting Kaizen post. Today let us see how you can apply color codes to the List and Detail Pages of Zoho CRM using Client Script. Need for color code in Zoho CRM When you mark things with different colors as a
                                  • Instant Sync of Zoho CRM Data?

                                    With how valuable Zoho Analytics is to actually creating data driven dashboards/reports, we are surprised that there is no instant or near instant sync between Zoho CRM and Zoho Analytics. Waiting 3 hours is okay for most of our reports, but there are
                                  • Is it possibly to directly set the tax amount on order instead of indirectly via tax rates?

                                    We own an eCommerce application and want to funnel submitted orders from that system into Zoho. We're already calculating tax in our application and just need a way to set it in Zoho. We tried to use Zoho's tax objects for tax by setting the rates to
                                  • Zoho account sign in with passkey

                                    Hello, I am trying to sign in using passkey, but the option doesn't show up in the web and is disabled in Oneauth on mobile, saying the admin has restricted the use. On the Admin page in Security MFA I can find no option for passkey. Help would be greatly
                                  • Rescheduled US meetups: Zoho Desk user meetups are coming to seven U.S. cities in October and November, 2025

                                    Hello to our Zoho Desk users in the United States, We're excited to share the revised dates for the upcoming Zoho User Groups happening across the US this summer. Our product experts are heading to seven cities throughout the country, and for the first
                                  • Checklists as templates

                                    Is it possible to save checklists as templates to reuse them in other tasks? Example: I have a web project. I maintain individual web URLs as tasks. Within the tasks the same checklist should be used again and again: - Page created in CMS - Properties
                                  • Send mass email using my secondary email

                                    Hello, When I send an email to just one person from Zoho CRM, a complete email editor appears, where I can choose which of my email addresses I want to use in the From field. When I send a mass email, there is not such option. I can only select the email
                                  • Add the same FROM email to multiple department

                                    Hi, We have several agents who work with multiple departments and we'd like to be able to select their names on the FROM field (sender), but apparently it's not possible to add a FROM address to multiple departments. Is there any way around this? Thanks.
                                  • ZOHO TEAM INBOX Calendar Integration

                                    The Problem: Clients send meeting invitations to our TeamInbox address. TeamInbox receives these invites, but we cannot accept them. We do not use individual inboxes for transparency purposes. Ideal Solution: A way to accept calendar invites sent to our
                                  • Unearned / Deferred Revenue Automatic Calculation for Subscriptions

                                    As a SaaS business, we have multiple active subscriptions with varying dates and amounts. Is there a way to have a monthly automatic calculation for all of them that debits or credits the unearned revenue and revenue accounts accordingly? Alternatively,
                                  • Zoho Desk Limit for Comma Separated Queries

                                    Hi, I have just discovered a limit that I believed is not mentioned in any of Zoho's documentations. My search query looks like so: "query: {"accountId":"786050000091629966,786050000163589273,786050000163589427,786050000162753705,786050000162112971,786050000161987643,786050000160752868,786050000167089504,786050000167089378,786050000167089024,786050000167070005,786050000166295256,786050000128153693,786050000110560021,786050000046594575,786050000039106461,786050000002225356,786050000076889093,786050000047895103,786050000043365354,786050000044765191,786050000041790249,786050000040359116,786050000037945198,786050000024605077,786050000000525015,786050000155333895,786050000157741437,786050000000718125,786050000011574353,","departmentId":"786050000042648070","status":"Finished","sortBy":"createdTime","customField2":"cf_completion_date:2025-01-28T03:00:00.000Z,2025-10-28T03:00:00.000Z","customField3":"cf_billed:false"}"
                                  • Module Name doesn't exist

                                    I am trying to create a module named Activity, with plural Activities, but I have an error that module name already exists. This module is doesn't exist, and I don't have a single field called Activity or Activities.
                                  • Zoho Desk iOS and Android app update: AI powered: Reply Assistance and Refine Messages on IM module.

                                    Hello everyone! We are excited to introduce new AI powered features on the IM module of the Zoho Desk app. Reply Assistance: Reply Assistance generates suggested responses for incoming chat messages, which you can directly insert into the conversation
                                  • Unify All Zoho Video Meeting Experiences into One Standardized Platform

                                    Hi Zoho Team, We would like to share an important user experience concern regarding the current state of video meeting functionality across the Zoho ecosystem. The Problem Within Zoho, there are multiple ways to initiate or schedule a video meeting: Zoho
                                  • Is it possible to embed Youtube shorts?

                                    Hi Zoho desk support, This is Ryan from Accuver America. While I'm trying to create a knowledge base article with embed video, I ran into this issue. "www.youtube.com refuse to connect" A little bit background is that because this video is recorded on
                                  • Zoho Inventory - Move Orders

                                    Quick question about Move Orders... Why is there no status to say something like "Draft", "In Progress" and "Completed", similar to Transfer Orders? I'm assuming that when something needs to be moved it should be planned in Inventory, executed and then
                                  • Split functionality - Admins need ability to do this

                                    Admins should be able to split an expense at any point of the process prior to approval. The split is very helpful for our account coding, but to have to go back to a user and ask them to split an invoice that they simply want paid is a bit of an in
                                  • Delegates - Access to approved reports

                                    We realized that delegates do not have access to reports after they are approved. Many users ask questions of their delegates about past expense reports and the delegates can't see this information. Please allow delegates see all expense report activity,
                                  • How to include total km for multiple trips in expense report.

                                    Whenever I create a mileage report it only shows the total dollar amount to be reimbursed. The mileage for each individual trip is included but I also need to see the total distance for all trips in a report? How do I do this?
                                  • Get logged in user ID in Deluge script

                                    Hello all, How do I get the id of the logged-in user in a deluge script? the "zoho.loginuserid" function actually returns the users email address or whatever the user id they use to login to zoho with and not the id of the user record, and given that
                                  • Item Details Field - New Barcode / Document option?

                                    Is this a new feature??? its in both books and inventory.
                                  • Next Page