Hi All, I would like to know if the product stock is maintained in real time that is if a sales order is created for a product then does that product stock quantity gets reduced
There is no out of the box Salesforce feature that track inventory levels. If your company has that information in Salesforce, it is a customization so you will need to talk with your Salesforce Administrator to learn the details.
