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

                                  • Currency selector (based on variable) usage in comparsion

                                    Hi, I've developed a currency selector based on the following topic, and it's working well in pivot tables and charts: https://help.zoho.com/portal/en/community/topic/how-can-i-allow-my-users-to-choose-a-currency-for-the-dashboard I also have a comparison
                                  • Notification received when self-assigning tickets

                                    When I assign tickets in Zoho Desk the relevant agent gets a notification email. When assigning myself a ticket in Zoho Desk, I get a notification email. Now, as I am the person who assigned the ticket to myself, getting a notification in this regard
                                  • Customize Column in Projects - Default View for Template?

                                    Is there a way to have the columns you'd like to see added to a template? I want my customized columns to show up every single time I create a project from that template. It appears I can customize them in the template but when I create the project they do not transfer over.  Template: See below how the columns in order are : Task, Owner, Status, Assigned, Website URL, Blog H1..etc. When I create a project from that same template it comes out as: Task, Owner, Status, Tags, Start Date, End Date, etc
                                  • Ask the Experts 24: Analytics, data administration, and mobile experience with Zoho Desk

                                    Hello Everyone! Welcome back to the Ask the Experts(ATE) series! We were so focused on our Autumn 2025 release that we didn't host an ATE session last month. In this month's ATE, we'd like to expand our areas for discussion: we'd like to listen to your
                                  • Multi-Page Forms in Zoho Creator!

                                    Let’s make long applications easier to handle by dividing them into pages, adding a progress bar, and guiding users step by step through complex data entry. This would be a total game-changer for the user experience and could significantly boost completion
                                  • Unable to Receive Emails on Zoho Mail After Office 365 Coexistence Setup – Error: 553 Relaying Disallowed

                                    Hello, My domain name is bigniter.com, and I’ve been using Zoho Mail as my email service provider without any issues. Recently, I followed the steps outlined in the Zoho documentation to enable Coexistence with Office 365: 🔗 https://www.zoho.com/mail/help/adminconsole/coexistence-with-office365.html#multi-server
                                  • Email login error

                                    Login successfully but email page error
                                  • Shared Mailboxes Disappeared

                                    Zoho Mail users in our company haven't been able to see their Shared Mailboxes for the past few hours. I've checked with App and Web Access, but they can't access them. When I send emails to their addresses, I get no error messages. They're still visible
                                  • Remote Server is misconfigured

                                    Dear Team, I am unable to use email id as remote server is misconfigured. It would be really great if you could help on this and get this resolved. Thanks & Regard Rohit Gupta
                                  • why cant i access my email account. it keeps asking me for reverifiying my account by entering my password.

                                    I cant access my account. it keeps asking me for reverifcaton by entering my password. once its entered it asks for it over and over.
                                  • The attendees will now be redirected to the landing webpage when they exit the webinar, set by the organizer.

                                    Hello All, In the latest version of the Zoho Meeting iOS mobile app (v1.3.16), we have brought in the below enhancements:   Post Webinar Re-direction Revamped exit UI for Webinar Post Webinar Re-direction:  The attendees will now be redirected to the
                                  • Free webinar alert on October 16 - Less Complexity, More Security: Workplace + Directory

                                    Hello Zoho Workplace Community! Security and productivity shouldn't be at odds—and with Zoho, they're not. Discover how Zoho Workplace + Directory delivers seamless collaboration with enterprise-grade security, all in one integrated ecosystem. Join our
                                  • Email Recall Feature In Zoho Mail Which Should Also Work For Outside Organisation Members

                                    Add a feature to recall or undo sending an email within a configurable short time window (e.g., 30 seconds to 2 minutes) after hitting send, similar to Gmail’s undo send. Currently the sent email can not be recall If the recipient is not from within your
                                  • Workdrive and ChatGPT Team Synced Connectors

                                    Hi, we want to be able to integrate Zoho Workdrive with OpenAI’s ChatGPT Team plan. Google Drive and OneDrive both offer this, zoho please catch up asap. We dont want to have to put our company files in google drive, we want to allow chatgpt Team edition
                                  • Zoho CRM IP Addresses to Whitelist

                                    We were told to whitelist IP addresses from Zoho CRM.  (CRM, not Zoho Mail.) What is the current list of IP Addresses to whitelist for outbound mail? Is there a website where these IP addresses are published and updated?  Everything I could find is over
                                  • Alias Name (on items) use case in Zoho inventory

                                    Hey, Hope everyone is well. Wondering if anyone can shed some light on the use case of Alias Names on Products in Zoho Inventory? Cheers, Chris
                                  • Updating an Invoice Line Item's Discount Account via API Call / Deluge Custom Function

                                    I need help updating an invoice line item's discount account via API. Below is a screenshot of the line item field I am referring to. Now the field to the left of the highlighted field (discount account) is the sales income account. I am able to modify
                                  • Send e-mail with attachments

                                    Dear Zoho, How is that possible in Zoho Flow to send an e-mail with attachment?  Just a simple example: Zoho Flow checks my Zoho mails and if the conditions starts the trigger then I would like to send an email with the original email's attachment. Any idea? BR, Adam
                                  • How to I get checkboxes on a subform to update via deluge

                                    Hello, would someone be able to tell me what I'm doing wrong here? I am trying to take the contents of a Deals subform and add them to an invoice then update the checkbox on each row so that 'add to invoice' is unticked and 'invoiced' is ticked. The output
                                  • Zoho SignForms: Prefill parameters with spaces render as “+” in the document (even when using %20)

                                    Hello Zoho Sign team, we are using SignForms with prefill parameters passed via URL. Spaces in parameter values are being rendered as “+” in the finalized document—even when we URL-encode spaces as %20. This is critical for us because we prefill addresses
                                  • CRM Related list table in Zoho analytics

                                    In Zoho Analytics, where can I view the tables created from zoho crm related lists? For example, in my Zoho CRM setup, I have added the Product module as a related list in the Lead module, and also the Lead module as a related list in the Product module.
                                  • Cadences

                                    I have just started using Cadences for follow-up up email pipeline. Is it just me or do you find the functionality very basic? For example, it will tell me (if I go looking for it) if someone has replied to a follow-up and been unenrolled; but it won't
                                  • Account in Quick View Filter

                                    I have a report that I often run against a specific Account. Every time, I have to go into the edit menu and change the Advanced Filter. I would prefer to use the Quick View Filter, but it does not allow me to use the one and only field that makes any
                                  • Add Webhook Response Module to Zoho Flow

                                    Hi Zoho Flow Team, We’d like to request a Webhook Response capability for Zoho Flow that can return a dynamic, computed reply to the original webhook caller after / during the flow runs. What exists today Zoho Flow’s webhook trigger can send custom acknowledgements
                                  • Your bot just got smarter: AI-Powered routing that reads between the lines

                                    What if your bot could tell the difference? Between a visitor who just needs a quick answer, someone actively comparing options, and a frustrated customer one click away from leaving? Most bots can't. They deliver the same response to everyone, missing
                                  • Tips & tricks: Make SalesIQ automations work for you

                                    Every day, thousands of visitors land on your website. Some browse, some buy, and some leave without a word. But, wouldn’t it be great if you could automatically know who’s interested, engage them at the right moment, and never miss a lead, and all this
                                  • Zoho Analytics & SQL Server - Live connect

                                    Below are the steps I did Created a fresh database and table in my own virtual server Created a new data source connection with live connect I was able to select the tables and created the data source successfully I am getting the error when I try to
                                  • Mapping a new Ticket in Zoho Desk to an Account or Deal in Zoho CRM manually

                                    Is there any way for me to map an existing ticket in Zoho desk to an account or Deal within Zoho CRM? Sometimes people use different email to put in a ticket than the one that we have in the CRM, but it's still the same person. We would like to be able
                                  • Good news! Calendar in Zoho CRM gets a face lift

                                    Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activities
                                  • Urgent Security Feature Request – Add MFA to Zoho Projects Client Portal Hello Zoho Projects Team,

                                    Hello Zoho Projects Team, We hope you are doing well. We would like to submit an urgent security enhancement request regarding the Zoho Projects Client Portal. At this time, as far as we are aware, there is no Multi-Factor Authentication (MFA) available
                                  • Unified customer portal login

                                    As I'm a Zoho One subscriber I can provide my customers with portal access to many of the Zoho apps. However, the customer must have a separate login for each app, which may be difficult for them to manage and frustrating as all they understand is that
                                  • Microsoft Teams now available as an online meeting provider

                                    Hello everyone, We're pleased to announce that Zoho CRM now supports Microsoft Teams as an online meeting provider—alongside the other providers already available. Admins can enable Microsoft Teams directly from the Preferences tab under the Meetings
                                  • Zoho Projects - Task Owner filter at Project level

                                    Hi Projects Team, The feature requests I would like to raise is the ability to create a custom view at the project level for projects with tasks owned by a user or users. For example "Ashley's Projects" custom view might contain a list of project in which
                                  • How to display Motivator components in Zoho CRM home page ?

                                    Hello, I created KPI's, games and so but I want to be able to see my KPI's and my tasks at the same time. Is this possible to display Motivator components in Zoho CRM home page ? Has someone any idea ? Thanks for your help.
                                  • Cadences

                                    I have just started using Cadences for follow-up up email pipeline. Is it just me or do you find the functionality very basic? For example, it will tell me (if I go looking for it) if someone has replied to a follow-up and been unenrolled; but it won't
                                  • Zoho Books-Accounting on the Go Series!

                                    Dear users, Continuing in the spirit of our 'Function Fridays' series, where we've been sharing custom function scripts to automate your back office operations, we're thrilled to introduce our latest initiative – the 'Zoho Books-Accounting on the Go Series'.
                                  • Custom Fonts in Zoho CRM Template Builder

                                    Hi, I am currently creating a new template for our quotes using the Zoho CRM template builder. However, I noticed that there is no option to add custom fonts to the template builder. It would greatly enhance the flexibility and branding capabilities if
                                  • Would be really awesome to have Created Time and Modified Time showing for custom functions list

                                    It would be SO HELPFUL to be able to sort custom functions by created time/ modified time. Also seeing a created by/ modified by with the little profile picture would be supremely helpful as well. Just really hard sometimes to find a function you were
                                  • What's New in Zoho Analytics - October 2025

                                    Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme
                                  • Ticket Export Does Not Include Ticket Threads

                                    Dear Zoho Desk Support Team, I hope you’re doing well. I would like to report an issue regarding the ticket export functionality in Zoho Desk. Currently, when exporting tickets, the ticket threads or conversation history are not included — only the ticket
                                  • Next Page