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.Recent Topics
Zoho Inventory - Composite Items - Assembly - Single Line Item Quantity of One
Hi Zoho Inventory Team, Please consider relaxing the system rules which prevent an assembly items from consisting of a single line item and outputting a quantity of 1. A client I'm currently working with sells cosmetics and offers testers of their products
Clients not receiving emails
I've been informed that my emails are not being received. Is there anything that I should look into to rectify this? Many thanks!
Allocating inventory to specific SO's
Is there a way that allocate inventory to a specific sales order? For example, let's say we have 90 items in stock. Customer 1 orders 100 items. This allocates all 90 items to their order, and they have a back order for the remaining 10 items which could
Max numbr of IMAP Accounts in Zoho Mail?
In Zoho mail, you can manage the inboxes of other accounts using IMAP (and POP, actually) https://www.zoho.com/mail/help/external-imap-accounts.html Is there a max to the number of inboxes we can add?
Formula Fields Trouble
Hi, I can't get even a simple formula field to work and must be doing something dumb. This formula: If(Len(Trim(${Quotes.Subject}))=0,1,2) Gives the error: You used the wrong type of data in an argument. Check what you entered between the parentheses of your functions to make sure you put the right kind of data in the right place. This formula: Len(Trim(${Quotes.Subject}))=0 Gives the error: Syntax Error. Check the examples for any functions you're using to see if you formatted them correctly. Make
OPTED FOR STORAGE BY DESCRIPTIVE MISGUIDANCE
We've opened a domain with three mail ids and payment has also been processed now the bill raised is for single use ID with additional storage capacity. Kindly request you to modify the purchase.
How can I add a new organization on Zoho Campaign
I want to create a new organization with my Zoho Campaign
White Label certificate
Hi all, About 72 hours ago, we fulfilled all steps for white labeling (CNAME to point to mail.cs.zohohost.eu), but since then the configuration page is now stuck at "generating certificate" since 3 days. When I execute an NSLOOKUP mail.webfoundry.be it
Split my account
Hello, I recently bought an email service for a friend. But, looks like I used my personal account to buy the plan. Please split the account so that the email service stays in a different account than my personal account.
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
Have Mail Lite, wish to add/purchase 2nd domain and use email
Hello, I have recently created two new businesses. I have successfully used Zoho to create a domain for one business and have set up two email addresses / users on that domain. I am trying to figure out how to create a second domain, just like I did the
Zoho Learn - AI Translate
Hi Learn team, I had a situation today where I was providing training to a client team and I had written articles into their Zoho Learn to support their learning. I realised that one of the team members was a non-native English speaker and they were struggling
Need support in setting up the company email and few other setups
Need support in setting up the company email and few other setups
This mobile number has been marked spam.
Dear zoho team, I am very happy to use zoho,because it india 🇮🇳 own app, but when we login into zoho account we facing some issue, please solve below issue ASAP. Add your mobile number As an added security measure for Accounts, you need to verify and
IP Address Blocked
Hi Team. Hope you're doing good. I'm unable to access Zoho with my IP address. I have to use VPN to access it. IP: 39.44.12.153 This is happening with all the Zoho products, the admin console and the mail.
Add an external email to the allowed list
I need to allow an external email to raise a ticket on Manage Engine ServiceDesk Plus. The external email is a outside of our domain and is not a domain user. The email address that needs to be allowed to raise a ticket request is noreply@formsatack.com.
Display name & account type change
I made a mistake and subscribed with an individual account instead of business, how can I change the account type and enter the details of the business. The other question, if I can't, then I want the display name of our email to be 'Business name' instead
Request to change display name in Zoho mail
Hello Zoho Mail Support, I am experiencing an issue with changing the display name on my Zoho Mail account. My email address is: info@witchcraftproduction.rs . I have already updated the display name in Settings > Mail Accounts, where it now shows as
Outbound IP address SPAM problem.
Hello Zoho Support, We noticed that one of your outbound IP addresses (136.143.188.12), which delivers our domain’s mail, is currently listed on the UCEProtect blacklist. Because of this, our messages are sometimes flagged as spam by recipient servers.
Answer Bot and Personalized Questions
Hi there, I have the same problem using the SalesIQ Answer Bot and the Zoho Desk Answer Bot (which really need different names, to be honest, in order to avoid confusion...) Customers that visit our website ask questions in the form of "What do you do?"
Forwarding
How can I forward my Zoho account to my gmail account? Noël
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
Add a Way to Duplicate Cards in the Same Canvas (Retain All Settings)
Dear Zoho SalesIQ Team, We would like to request a new feature in Zoho SalesIQ: the ability to duplicate an existing card within the same canvas while retaining all of its information and settings, including conditions, configurations, and display preferences.
Zoho Mail CC and BCC not working
Zoho Mail CC and BCC not working. I have tried multiple combinations amongst my domain aliases but emails sent as CC or BCC never arrive, not even to Spam. I have checked that the DNS is set up correctly in Cloudflare and have even received a DMARC report
Is anyone else having trouble saving a custom image in their email signature, or is it just me?
When I try to save the image I get an error that says "Operation Failed" I opened a support ticket two weeks ago and received a response that it would be debugged, but it still isn’t working
Feature Request: Tag, Search, and Report on Individual Private Comments
Zoho Desk Team, First, I want to say that we are extensive users of Zoho Desk and it is a core part of our support operations. We rely heavily on the private comments feature for internal communication, knowledge sharing, and maintaining a clear history
Zoho Autoplay Issue
Currently, we run our graphics on a playlist with youtube videos interspersed in our office -- however, when we go to update the playlist (since last Thursday at around 8-9am EST) it no longer saves the autoplay function. We have tried making a new account, manually saving with cntrl+s, making a new show, etc but nothing seems to work. Even with our old program, we can't change it off of autoplay for ones that were created in the past. Another issue is that if we change a slide transition to anything
Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed
Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted
Kaizen #152 - Client Script Support for the new Canvas Record Forms
Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved
Adding hyperlinks in CRM emails time automatically
It may just be me, but when I am writing an email to a lead, I find inserting a hyperlink very time consuming. Granted, I can use templates but there are a ton of scenarios where I might want to put a link in to an website that wouldnt require me to go though the effort of creating a template. Ideally, the crm would identify that I that a string of text is a URL and insert the hyperlink automatically, just like microsoft outlook or gmail. Has anyone else had this same experience and found a way
Enhance "Applications Usage" with Date Filters, Historical Analytics & App-Level Breakdown
Hello Zoho Creator Team, We are writing to request a critical enhancement to the Applications Usage section to improve our ability to monitor, analyze, and manage our platform consumption over time. While the current view of today’s usage is helpful for
External File Share - Allow delete
Hi Team, when I share an external link and give it edit rights the external user can add but not delete files and folders. what am i doing wrong?
Cliq iOS can't see shared screen
Hello, I had this morning a video call with a colleague. She is using Cliq Desktop MacOS and wanted to share her screen with me. I'm on iPad. I noticed, while she shared her screen, I could only see her video, but not the shared screen... Does Cliq iOS is able to display shared screen, or is it somewhere else to be found ? Regards
Tables from ZohoSheets remove images when updated from source
I have a few tables from a ZohoSheet in a ZohoWriter document that will remove the images in the cells when I refresh from the source. The source still has the images in the table when I go to refresh. After updating from the source, as you can see the
Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM
Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
Where is the Global Search field?
I am looking for an alternative to SF.com. Zoho CRM seems to be work fine, and be customizable in terms of the fields and reports. But there's one big thing missing and it's going to prevent us from using it: there's no global search box at the top of
Enhancements to finance suite integrations
Update: Based on your feedback, we’ve updated the capabilities for integration users. In addition to the Estimates module, they can now create, view, and edit records in all the finance modules including Sales Order, Invoices, Purchase Order. We're also
How to notify all members on any updates to zoho crm?
Hi, I am using the free version of zoho CRM and currently seeing this will work for our company. We are a small company and wanted to be more informed about all the changes in zoho. 1. How do I s et notifications that go to the team for any and all changes
How to change the format for phone numbers?
Mobile phone numbers are currently formatted (###) ###-####. How can I change this to a more appropriate forms for Australia being either #### ### ### or (#)### ### ###?
Unattended Access on Android without Play Store
I'm testing Zoho Assist for remote config and maintenance of our IoT devices. The devices are running Android 8.1 and do NOT have Google Play Store installed, nor can it be installed. I've been able to install Zoho Assist on the devices and load the enrollment
Next Page