Adjusting Physical Inventory

Adjusting Physical Inventory

Not getting very far with support on this one, they say they are going to fix it but nothings happened since November. Please give this a thumbs up if you would like to see this feature or comment if you have some insight. 

Use Case: Inventory set to be based on shipments and receives.

Physical Stock panel on item:

1. Item 1 has 35 items on the shelf, no sales orders yet.

Stock on Hand = 35
Commited Stock = 0
Available for sale = 35

2. Sales order is raised for qty 35 (not shipped yet)

Stock on Hand = 35
Commited Stock = 35
Available for sale = 0

3. We do a stock take and notice 3 have gone missing (Lets say they were stolen) meaning there is 32 on the shelf. We adjust the stock and get this screen:



We enter 32 in "New Quantity on Hand"

Stock now shows:

Stock on Hand = 67
Commited Stock = 35
Available for sale = 32

But I have 32 on the shelf not 67...... The stock take screen asks for "New Stock On Hand" but it is actually interpreting this as "Available for Sale", it is doing the following calculation to determine the amount to adjust by:

The current logic: "Entered on hand figure" - "Available for sale" = "Adjustment Amount"
e.g. 32 - 0 = 32. (It then increments the stock by 32 bringing us to 67 from 35)

The logic should be

"Adjustment amount entered" - "Current Stock on hand" 
e.g. 32 - 35 = -3.  Then increment the stock by -3 which brings us to 32 the correct physical amount. 

This is driving me crazy and making it near impossible to do stock takes as we constantly have committed stock. 

It is possible that this is tied to the accounting stock management setting and it just doesn't work when set to manage stock by shipments and receives which we are on. Works in accounting world but not in the real one!

Please comment/thumbs up if you can, I need to push this with Zoho inventory and get it fixed.

    Zoho Campaigns Resources

      Zoho Desk Resources

      • Desk Community Learning Series


      • Digest


      • Functions


      • Meetups


      • Kbase


      • Resources


      • Glossary


      • Desk Marketplace


      • MVP Corner


      • Word of the Day


        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

                                • Zoho Mail Not Receiving or Sending Email

                                  My zoho mail is not sending or receiving mail. What's the fix for this?
                                • Where can I find my documents

                                  I am evaluating solutions to store text documents. I once created one text document on zoho and worked on it. I came back to zoho a few weeks later. Impossible to find it again. Is there a web page containing my documents or my folders? How can I retrieve
                                • Unsuscribe, suscribe and tell a friend links not working

                                  Hello, I'm new to Zoho campaigns. I created and sent a test campaign to myself but on clicking the subscribe, unsubscribe, view in browser ans tell a friend links, i realize none of them leads anywhere. Instead i get the following error:
                                • Tip #5: Setting access rights at the subfolder level

                                  Hello everyone, We hope you're finding our WorkDrive Tips and Tricks series useful. For today's tip, we'll teach you how to assign higher subfolder permissions to Team Folder members. Team Folders helps you avoid the drawbacks of traditional file sharing.
                                • Getting error for invalid session on zoho mail

                                  Hello, Today our office staff start having challenges with our email once logged in. I keep saying : Invalid session you will be logged out in 3 seconds. And it wont allow me to send any messages.
                                • Login Request

                                  Good afternoon. Id like to receive help, I'm requesting information in regards to account login issues. I've bee asked to provide additional security information. Ie: phone number in order to access my account. I no longer have access to this account
                                • integrating Zoho CRM vendors with Zoho projects

                                  In most of our projects we collaborate with our Vendors. Being able to integrate only Accounts and not Vendors from CRM, is a huge limitation for our perspective and needs. We would really love to see this feature in the CRM-Projects integration.
                                • Multiple Vendor SKUs

                                  One of the big concerns we have with ZOHO Inventory is lack of Vendor Skus like many other inventory software packages offer. Being able to have multiple vendor skus for the same product would be HUGE! It would populate the appropriate vendor Sku for
                                • Include SalesIQ activity when sending Forms data to CRM as a new Lead

                                  Is there a way that when I get a new lead via a zoho form on my website to include the activity in CRM? I have Sales IQ integrated with the form however, most of my leads do not talk to us through the chat fuction but they do fill out a zoho form. Id
                                • Unblock ME

                                  info@pentekykloi.gr Unable to send message;Reason:554 5.1.8 Email Outgoing Blocked. Learn more. I purchase additional storage
                                • Custom CSS in Webform

                                  When creating a webform in Zoho CRM, there are some limited WYSIWYG styling options, but no way to edit the CSS directly to fully customize the style of the form. I am aware that you can use the "source code" publishing option and edit the styles in your
                                • Getting error for invalid session on zoho mail

                                  Since yesterday I am getting following error when I am trying to log in on zoho mail your session is invalid. you will be logged out in 3 seconds!!  Can someone please help me how to fix this? Thanks Manoj
                                • Can't add Email Alias - AS101 error

                                  Hi, It won't let me add a alias email address on any of my domains under Admin Console,  User, add alias email address it just says AS101 error, I have never had issues creating an alias address before Please fix this
                                • Reply All function omits the full list of original To and Cc recipients in the email body

                                  When using "Reply All" in Zoho Mail, the email body only shows the sender's details (e.g., "John Doe wrote") without listing the original To and Cc recipients, making it difficult for recipients to see the full email thread context. This differs for example
                                • Attendance Bulk Import Not working.

                                  It was working for me from last one year the same format. but now its giving bad request(400). Please help me. resolved this problem.
                                • ZOho Booking and CRM integration.

                                  We are using Zoho Booking wiht Zoho CRM in a custom module. Inside our module we use the option to book a meeting with the customer. This part works great we feed the field to the URL and everything work 100%. Now my issue is that I was not able to find
                                • Chrome browser issues. Anyone else?

                                  I am suddenly having multiple issues with Chrome browser interpreting the Zoho Mail interface.  Anyone else?  Any known problems? Thanks, Todd
                                • 554 5.2.3 MailPolicy violation Error, help?

                                  This message was created automatically by mail delivery software. A message that you sent could not be delivered to one or more of its recipients. 554 5.2.3 MailPolicy violation Error delivering to mailboxes I am not sure why i am getting this, please
                                • Display comma in number field (thousand separator)

                                  Love Zoho so far!  How can I add comma as thousand separator in number field upon input by user?  This is essential feature when dealing with larger numbers to make readable.  Is there number formatting script for this? For example, change 600000 to 600,000 This link appears to be related to the topic. https://help.zoho.com/portal/en/community/topic/amount-display#2266000001410984
                                • Any way to Associate a Recurring Invoice with Deal/Potential in Zoho CRM

                                  When we create an Invoice in Zoho Books, we have the option to associate that invoice with a Potential/Deal that is tied to that same customer. Can we do the same thing with Recurring Invoices? When creating a Recurring Invoice, I want to be able to Associate
                                • Tracking leads through the sales process

                                  Our leads are being generated via paid google ads and are arriving to us with UTM data showing lead sources, campaign mediums and campaign names. I want to track the progress of those leads as they migrate through our sales funnel while maintaining a
                                • Elevating Email Security on Zoho Desk: DKIM Now Mandatory

                                  Hello Zoho Desk Users! It has been a wonderful journey with you on Zoho Desk. As we welcome 2025, we are strengthening our efforts to ensure a secure and seamless experience for you. To enhance email security, DKIM configuration will be mandatory for
                                • Introducing 'Queries' In Zoho CRM

                                  Hello everyone! We are here with an exciting feature - Queries in Zoho CRM! A little context before we dive right into the feature specifics :) In today’s fast-paced business environment, immediate access to relevant data is essential for informed decision-making.
                                • How to send mail with js SDK

                                  Hell o I'm using https://live.zwidgets.com/js-sdk/1.2/ZohoEmbededAppSDK.min.js, for my widget in CRM (built with sigma) Is it possible to send email from js file, I try ti use that ZOHO.CRM.API.sendMail({ "Entity": "Accounts", "RecordID": sharedVariableEntityId,
                                • How to merge data from Zoho CRM to Zoho Sheet

                                  Hello! A few months ago, I made a Zoho sheet with the ability to bring in data from Zoho CRM. It worked by adding the email of a Contact to the sheet, and then it would fill in the rest of the information in the row with information that was stored in
                                • Zoho say my domain seems to be already associated with another account

                                  I created a website on zoho and associated my domain (bompescado.com) on it. You can see the A record and CNAME are working to it. Now I need to associate the same domain as webmail, but when I try it return with: " This domain name seems to be already associated with another account. If you own this domain, please contact us for assistance." Im following the advice and conctacting you to say I've not been associated this domain on zoho before.  What do I need? Well, I need you manually remove it
                                • Subform Auto-populate based on Main Form Drop Down

                                  Zoho CRM. I have a drop down named ''number of items'' which ranges from 1-100. Below that I have a subform with 18 fields. Here is an example of what I need for this section: Number of items: 10 Subform (all 18 fields) show up 10 times Number of items:
                                • Zoho Sheets working offline

                                  Hi,  I am looking for the ability to work offline in Zoho Sheets, but currently I cannot find the process to complete this.  Does someone have any ideas or steps I might have missed?  Also does Zoho Sheets have the "Format as Tables" function as is currently in MS Excel 2016??  Many thanks. 
                                • Lost ZB Code

                                  Hi,  Please what is the ZB code for my domain? It was mistakenly deleted. Please treat as urgent.  
                                • Unusual activity detected from this IP. Please try again after some time

                                  When i try to create new addresses on my account i am getting this error, it has been 24 hours now and i am still getting this error can anyone help
                                • Dialing Microsoft Teams Phone Service via Zoho CRM

                                  I am using the VOIP option in Microsoft teams for my office phone system. I was hoping to have a way to dial numbers directly from Zoho CRM, but don't see anything in the Teams Integration or in the Telephony integration that will enable this. Does anyone
                                • Date format in the Account settings are not reflected in other applications

                                  The issue where changes to the date format in the Account settings are not reflected in other applications. Not only the date format, but even after switching the language in some part remains the same. This issue has persisted for a week. Could someone
                                • How to add the time duration for scheldule call

                                  Hi, When we are planning phone calls with leads or customers. Depending on the client, lead and the reason for the call the time planned is always different from 15 minutes to 2 hours. Currently, the system does not allow us to change or add a time duration
                                • Contacts per department

                                  Hello, Is it possible to limit Contacts to a Department? Thanks
                                • Project profitability

                                  It would be useful to analyze project profitability. Besides adding an hourly rate for staff or task, I would also like to add an hourly cost for that person or task, so that I can compare time spent vs time billed and easily calculate profit margin.
                                • How to search records in integration task in creator?

                                  How to search using integration task in creator searchString = {"zcrm_account_id:4050082000001001499"}; contactData = zoho.books.getRecords("Contacts","xxxxxx",searchString); I get an error that third argument needs to be string, I tried to convert it
                                • How can I create individual records from a subform

                                  Hi, I am collecting subform data into a Lead record and I need to create individual records for each row associated to the account when it is converted. How can I do this?
                                • How to add a record for a different report

                                  I have one form and it has two reports I need to programmatically add records to both reports For example one report is draft and other is processed After the user performs some action on the draft report I want to create a new report in Processed and
                                • Introducing Zia GenAI: Zoho's Native Generative AI for Zoho Desk

                                  Hello everyone, Zia GenAI is available on Early Access for Zoho Desk Enterprise subscribers. Kindly fill out this Registration Form to request early access. We are excited to announce the Beta release of Zia GenAI in Zoho Desk, now available through our
                                • Location Lookup

                                  Hi Team, When I enter an address into the location field, there is no map address lookup happening. What setting have I missed that will get this working? Kind Regards John
                                • Next Page