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

                                  • Feature Request - Ability to Customise Contact Info Card on Ticket Details View

                                    Hi Desk Team, I've added a "Contact Priority" and "Account Prioirty" field and it would be very useful to agents if they could see that information in the Contact Info card on the Ticket Details view. It would be great if we could choose some fields to
                                  • Tax in Quote

                                    Each row item in a quote has a tax value. At the total numbers at the bottom, there is also a Tax entry. If you select tax in both of the (line item, and the total), the tax doubles. My assumption is that the Tax total should be totalling the tax from
                                  • Zoho Flow integration with Facebook Messenger and Whatsapp

                                    Hi there,  any plans of adding integrations with Facebook Messenger and Whatsapp into Zoho Flow? Seems that more and more business are delivering automated updates such as "your order is received",  "your order has been shipped" and so on via these two platforms. Not sure if Whatsapp has the API access needed i am pretty sure that Facebook Messenger has... Kind regards Bo Thygesen 
                                  • Notes badge as a quick action in the list view

                                    Hello all, We are introducing the Notes badge in the list view of all modules as a quick action you can perform for each record, in addition to the existing Activity badge. With this enhancement, users will have quick visibility into the notes associated
                                  • Really want the field "Company" in the activities module!

                                    Hi team! Something we are really missing is able to see the field Company when working in the activities module. We have a lot of tasks and need to see what company it's related to. It's really annoying to not be able to see it.🙈 Thx!
                                  • Feature Requests - Contact Coloured Picklist Visibility & Field Visibility During Ticket Creation

                                    Hi Desk Team, I have 2 feature requests for you. Since Coloured Picklists are now available in Desk, It would be great if the colours were visible on the Related Details (Contact Information) when creating a ticket. In the screenshot below, I have 2 fields
                                  • Multi-currency and Products

                                    One of the main reasons I have gone down the Zoho route is because I need multi-currency support.  However, I find that products can only be priced in the home currency, We sell to the US and UK.  However, we maintain different price lists for each. 
                                  • Campaigns unsubscribe/manage preferences links

                                    Hi, Where can I edit the unscubscribe and manage preferences link in the footer of the email. I would like it so that when you click 'manage preferences' an form opens up that allows the person to choose what type of emails they do and don't wish to
                                  • email address somehow still not verified (?!)

                                    L.S. After creating a new email template in CRM I was about to send a group email to my clients, then Zoho CRM announced that they would change the sender address to some kind of Zoho-e-ddress because my email address "has not been verified". Not only
                                  • Marketing Tip #17: Add credibility to your online store with Review Widgets

                                    One of the fastest ways to build trust in an online store is to show real customer feedback right where people are deciding to buy. Third-party widgets let you embed things like Google Reviews, Instagram feeds, or even a WhatsApp chat button. These add
                                  • adding several team members to an Opportunity

                                    How can we add several team members to one opportunity for collaboration? I have researched and only found something called Deal Team which I cannot find in my CRM to configure.
                                  • CRM gets location smart with the all new Map View: visualize records, locate records within any radius, and more

                                    Hello all, We've introduced a new way to work with location data in Zoho CRM: the Map View. Instead of scrolling through endless lists, your records now appear as pins on a map. Built on top of the all-new address field and powered by Mappls (MapMyIndia),
                                  • PDF Annotation is here - Mark Up PDFs Your Way!

                                    Reviewing PDFs just got a whole lot easier. You can now annotate PDFs directly in Zoho Notebook. Highlight important sections, add text, insert images, apply watermarks, and mark up documents in detail without leaving your notes. No app switching. No
                                  • Bulk update Profile Permissions

                                    Dears, What should we do if we add new forms or reports and need to update more than 20 permissions? Updating them one by one feels pretty harsh, doesn’t it?
                                  • From Zoho CRM to Paper : Design & Print Data Directly using Canvas Print View

                                    Hello Everyone, We are excited to announce a new addition to your Canvas in Zoho CRM - Print View. Canvas print view helps you transform your custom CRM layouts into print-ready documents, so you can bring your digital data to the physical world with
                                  • Customizable UI components in pages | Theme builder

                                    Anyone know when these roadmap items are scheduled for release? They were originally scheduled for Q4 2025. https://www.zoho.com/creator/product-roadmap.html
                                  • Unify Overlapping Functionalities Across Zoho Products

                                    Hi Zoho One Team, We would like to raise a concern about the current overlap of core functionalities across various Zoho applications. While Zoho offers a rich suite of tools, many applications include similar or identical features—such as shift management,
                                  • Filter in fields from Jira extension

                                    We have installed the Jira extension so we can maken Jira issues from Zoho desk. In Zoho desk I can also see the Jira issue status for example but I can not filter on this field. I would like to setup an filter showing me the closed Jira issues. How can
                                  • text length in list report mobile/tablet

                                    Is there a way to make the full text of a text field appear in the list report on mobile and tablet? With custom layouts, the text is always truncated after a certain number of characters.
                                  • Zoho Creator customer portal limitation | Zoho One

                                    I'm asking you all for any feedback as to the logic or reasoning behind drastically limiting portal users when Zoho already meters based on number of records. I'm a single-seat, Zoho One Enterprise license holder. If my portal users are going to add records, wouldn't that increase revenue for Zoho as that is how Creator is monetized? Why limit my customer portal to only THREE external users when more users would equate to more records being entered into the database?!? (See help ticket reply below.)
                                  • Link Contacts to Billed Accounts

                                    Hello, I want to do a survey on all my customers of 2025. For that I want to select all contacts linked to accounts who where billed in 2025. How to I create this link to I can then use Zoho Survey with this database of contacts?
                                  • Export all of our manuals from Zoho Learn in one go

                                    Hi, I know there's a way to export manuals in Zoho Learn, but I want to export everything in one go so it won't take so long. I can't see a way to do this, can I get some assistance or is this a feature in the pipeline? Thanks, Hannah
                                  • Bring Zoho Shifts Capabilities into Zoho People Shift Module

                                    Hello Zoho People Product Team, After a deep review of the Zoho People Shift module and a direct comparison with Zoho Shifts, we would like to raise a feature request and serious concern regarding the current state of shift management in Zoho People.
                                  • Historical Sales Info - Blend with Finance Invoice Line Items, Access in CRM and Desk

                                    My company has been using Zoho One since 2021, with sales data going back through 2020. However, we have been in business much longer, and we have historical sales information that we want to have at our fingertips when talking with customers (usually
                                  • Is there API Doc for Zoho Survey?

                                    Hi everyone, Is there API doc for Zoho Survey? Currently evaluating a solution - use case to automate survey administration especially for internal use. But after a brief search, I couldn't find API doc for this. So I thought I should ask here. Than
                                  • Pre-Zoho Sales Info - Best Way to Add to Desk / CRM

                                    My company has been using Zoho One since 2021, with sales data going back through 2020. However, we have been in business much longer, and we have historical sales information that we want to have at our fingertips when talking with customers (usually
                                  • Shift-Centric View for Assigning and Managing Shifts in Zoho People

                                    Hello Zoho People Product Team, Greetings and hope you are doing well. This feature request is related to Zoho People - please don't move it to zoho one! We would like to submit a feature request regarding the shift assignment and management view in Zoho
                                  • CRM function REST API response format

                                    Is there a way to control the JSON response returned by the CRM function REST API? If I call a function using either OAuth or an API key it returns a 200 OK response with a string in the format shown below. I am using a particular feature of an external
                                  • Add Employee Availability Functionality to Zoho People Shift Module

                                    Hello Zoho People Product Team, Greetings and hope you are doing well. We would like to submit a feature request to enhance the Zoho People Shift module by adding employee availability management, similar to the functionality available in Zoho Shifts.
                                  • Using MPN across multiple SKUs and inventory tracking

                                    I have several different SKU's that share a common MPN and would like to track inventory by MPN. SKU1 has MPN1 assigned SKU2 has MPN1 assigned Here is an example If I start with 5 of MPN 1 in stock I want each SKU1 and SKU2 to show as 5 in stock, If I
                                  • Unable to Access Application:

                                    Whenever I try to access my application from the desktop, say I am editing it and want to test something in the desktop environment I get: An error has occurred. An internal error has occurred. Please check the URL , or try refreshing the page I can edit
                                  • Adding custom "lookup" fields in Zoho Customization

                                    How can I add a second “lookup” field in Zoho? I’m trying to create another lookup that pulls from my Contacts, but the option doesn’t appear in the module customization sidebar. In many cases, a single work order involves multiple contacts. Ideally,
                                  • Cannot see Application from Lookup field

                                    Hi all, I am trying to access data for an application on our account via a lookup field; however, the application doesn't appear in the dropdown at all. Can anyone shed any light on this, please? I have asked Zoho support; however, they're just as confused,
                                  • Cannot see correct DNS config for mail after moving domain to another provider

                                    I have moved my domain from one provider to another and after that zoho mail stopped working (expected). Problem is, zoho mail admin panel still shows (10 hours after move) that all records are correct while I haven't changed anything in my domain DNS
                                  • Zoho CRM Meetings Module Issues

                                    We have a use-case that is very common in today's world, but won't work in Zoho CRM. We have an SDR (Sales Development Rep) who makes many calls per day to Leads and Contacts, and schedules meetings for our primary Sales Reps. He does this by logging
                                  • Zoho Books integration sync from Zoho CRM does not work

                                    Hi Zoho Community & Zoho Support We just tried to get a sync some products into Zoho Books from CRM using the native sync and we're getting an error: "It looks like some mandatory fields you're trying to map are empty. Please provide valid field names
                                  • P & L Sub-categorized accounts

                                    How can I show sub-categorized Income and Expense accounts on the P & L report?
                                  • Report showing Bill Details with Project and Sales Invoice Number

                                    Hi There, I am hoping that someone can help, I am looking for report that can show the bill and expense details along with project its as assigned to and the invoice number that the sales has been raised in. The goal is I can filter a customer/project
                                  • Advanced Payment for Inventory Items with serial numbers

                                    Hello, We sell equipment that we track the unique serial numbers on using Sales Orders. We can charge the customers an advanced payment, then the balance on delivery. We cannot figure out a way to do this in Books/Inventory: - Cannot part invoice a SO
                                  • Is it possible to restrict ZCRM user to see only custom views created by administrator

                                    I have segmented data in my CRM and I want to allow different users to be able to see only parts of it based on some criteria. I've tried to create and share a custom view, but then there is always an option for user to see all open lead for example.
                                  • Next Page