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
Emails missing from desktop but visible on phone
Subject says it all. Windows 11 laptop. Apple phone. all systems up to date.
Website Hosting
Hello, I want to host my domain on Hostinger, and I want my emails to run through Zoho Mail. Please provide me with the SPF record, MX record (Type: TXT), and A record, so that I don’t face any issues with my emails. My website is on Hostinger hosting,
Can not search zoho mail after update V.1.7.0
i can not search mail on to and cc box from attached picture and then search contacts box can't click or use anything. include replay mail too.
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
How to retreive the "To be received" value of an Item displayed in Zoho inventory.
Hi everyone, We have our own Deluge code to generate a PO according to taget quantity and box quantity, pretty usefull and powerful! However, we want to reduce our quantity to order according to "To be received" variable. Seems like this might not even
Payment on a past due balance
Scenario: Customer is past due on their account for 4 months. We suspend their billing in Zoho books. Customer finally logs into the portal and enters a new credit card. We associate that cardwith their subscription, which will permit the card to be used
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
Kaizen #211 - Answering your Questions | Using Canvas and Widgets to Tailor CRM for Mobile
Howdy, tech wizards! We are back with the final post in addressing the queries you shared for our 200th milestone. This week, we are focusing on a couple of queries on Zoho CRM mobile configurations and custom payment gateway integration. 1. Mobile SDK
Remove "Invalid entries found. Rectify and submit again" modal
Following up on a post from a few years back, but can the Zoho team consider either removing the 'Invalid entries found. Rectify and submit again' modal that displays for empty mandatory fields OR allow an admin to change it? I've built a custom error
Validation function not preventing candidates under 18 or over 30 from submitting the web form
Hello everyone, I’m trying to create a validation rule for the Candidate Webform in Zoho Recruit. I added a custom field called “Date of Birth”, and I want to make sure that candidates cannot submit the form unless their age is between 18 and 30 years.
Cadence reports as front-end reports
Hello everyone, We have built a cadence which is connected to the Leads module. There are 11 steps in total, 7 are automatic emails and 4 are tasks for the Lead owners. As admins, we have access to this (very nicely made) 'View Reports' tab where we can
Zoho Commerce in multiple languages
When will you be able to offer Zoho Commerce in more languages? We sell in multiple markets and want to be able to offer a local version of our webshop. What does the roadmap look like?
Show elapsed time on the thank-you page?
Is it possible to display the total time a user spent filling out a Zoho Form on the thank-you? I’d like to show the difference between the `form submission timestamp` and the `start time` (currently have a hidden Date-Time field set to autofill the date
Email Integration - Zoho CRM - OAuth and IMAP
Hello, We are attempting to integrate our Microsoft 365 email with Zoho CRM. We are using the documentation at Email Configuration for IMAP and POP3 (zoho.com) We use Microsoft 365 and per their recommendations (and requirements) for secure email we have
I need to do crud with snippet html
I need to implement a form with an improved user interface. I would like to use snippets to build a CRUD that allows me to create and update records. How could I achieve this using snippets?
Allow Stripe Credit Card and Stripe ACH payment methods to be enabled separately on an invoice.
I need to be able to pick at the invoice level whether Stripe Credit Card and/or Stripe ACH payment methods are available. Currently, I'm not able to select from the two Stripe payment methods individually on an invoice. However, there are some larger
Meeting impossible to use when sharing screen
he Meeting tool in Brazil is practically unusable when sharing anything, whether it’s a presentation or simple navigation. When accessed via Cliq, the situation gets even worse: even basic calls fail to work properly, constantly freezing. And as you are
Resume Harvester: New Enhancements for Faster Sourcing
We’re excited to share a set of enhancements to Resume Harvester that make sourcing faster and more flexible. These updates help you cut down on repetitive steps, manage auto searches more efficiently, and review candidate profiles with ease. Why we built
Incorrect “correct” password on email client apple mail
I have troubleshot this account several times. I have deleted and re added account. It keeps saying incorrect password. Can you check that it is not locked on your end?
Is it possible to lock editing subform rows?
Ideally editing would only be locked after the form has been updated but I still want them to be able to add new subform records at any time and they should be able to delete rows from the subform. It is a named subform if that's relevant however the
"Spreadsheet Mode" for Fast Bulk Edits
One of the challenges with using Zoho Inventory is when bulk edits need to be done via the UI, and each value that needs to be changed is different. A very common use case here is price changes. Often, a price increase will need to be implemented, and
What is the maximum file size of a video upload in Zoho chat?
Can I upload a 20 mb video file and share it with my colleagues?
Update a field in ALL all calls under a contact
HI guys! I have written some deluge code to update a field in my calls after i have comepleted the call, i need this field to update in all my scheduled calls as well that are comeing up. I just cant seem to get it to work, i have put teh code below,
In place field editing for candidates
Wondering about any insight/best practices for efficiently updating candidate records while reviewing them in a Job Opening pipeline. We can do in-field editing (e.g. update job title or City) only when we have the full candidate record open, however
Automatic Matching from Bank Statements / Feeds
Is it possible to have transactions from a feed or bank statement automatically match when certain criteria are met? My use case, which is pretty broadly applicable, is e-commerce transactions for merchant services accounts (clearing accounts). In these
Verifying Zoho Mail Functionality After Switching DNS from Cloudflare to Hosting Provider
I initially configured my domain's (https://roblaxmod.com/) email with Zoho Mail while using Cloudflare to manage my DNS records (MX, SPF, etc.). All services were working correctly. Recently, I have removed my site from Cloudflare and switched my domain's
Fat Download of Ulaa Browser
I just observed that Ulaa Browser is offering an one-capsule big download. These days it is a custom to offer a small bootstrap downloader and based on user customization options an appropriate download completes. And this is particularly common with
Cancelled Transfer order problem
Hello, We've canceled a transfer order, and we can't add the related items to a new Transfer Order. The system tells us that the bin doesn't have the required quantity, but when we check the item, it indicates that there are 2 units in the bin. It also
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.)
Changing the Default Search Criteria for Finding Duplicates
Hey everyone, is it possible to adjust the default search criteria for finding and merging duplicate records? Right now, CRM uses some (in my opinion nonsensical) fields as search criteria for duplicate records which do nothing except dilute the results.
Billing Management: #8 Usage Billing in Logistics & Delivery Services
The logistics and delivery industry thrives on movement and precision. Every delivery completed, every kilometre driven, and every ton transported is a measurable activity. However, billing often lags behind. Many logistics companies still rely on fixed-rate
Create custom rollup summary fields in Zoho CRM
Hello everyone, In Zoho CRM, rollup summary fields have been essential tools for summarizing data across related records and enabling users to gain quick insights without having to jump across modules. Previously, only predefined summary functions were
Zoho sheet for desktop
Hi is zoho sheets available for desktop version for windows
Tags for New Tickets
Hi there, When creating a new ticket, there is currently no way to choose a tag you would like to associate with the new ticket. Being able to associate a tag while creating a new ticket will be very beneficial as it will save time and flow well with
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
Zoho Desk: No Incoming email
Is Zoho Desk services down? No incoming email reflect to desk tickets.
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
Zoho CRM - Widgets | Update #3 : Introducing SDK V1.5 along with new ZDK Methods and ZRC Support
Hello everyone! Widgets in Zoho CRM just got a big upgrade! With the release of SDK v1.5, developers can now create more immersive widget experiences. This update elevates Widget development with new ZDK methods for easier interactivity and ZRC support
Unusual activity detected, account blocked
I am unable to send emails and am getting the error "Outgoing blocked: Unusual activity detected. To unblock your account, please and submit a request. Learn more.". I am unsure as to why this is happening since all my activity is legitimate, mainly confirmation
Unable to Send Emails – Outgoing Mail Blocked (Error 554 5.1.8)
Description: Hello Zoho Support Team, I am facing an issue with my Zoho Mail account ( admin@osamarahmani.tech ). Whenever I try to send an email, I get the following error: 554 5.1.8 Email Outgoing Blocked I would like to clarify that I have not done
Next Page