Inventory quantity calculation

You can enter the quantity of a product in the Initial Quantity field when you add the product to your list of products offered.

You can also define the quantity at any time by entering an inventory adjustment.

However, OnBalance changes the quantity of a product each time you change one of the following items on which the product is included.

  • Add, edit, cancel, or delete a sale.
  • Add, edit, cancel, or delete a purchase.
  • Add, edit, cancel, or delete a customer's product return.
  • Add, edit, cancel, or delete a product return to a vendor.

The following actions change the inventory quantity of a product.

Action Result
Add a purchase Increase inventory
Add a customer's product return Increase inventory
Cancel or delete a sale Increase inventory
Cancel or delete a product return to a vendor Increase inventory
Add a sale Decrease inventory
Add a product return to a vendor Decrease inventory
Cancel or delete a purchase Decrease inventory
Cancel or delete a customer's product return Decrease inventory
Edit a sale Varies depending on changes
Edit a purchase Varies depending on changes
Edit a customer's product return Varies depending on changes
Edit a product return to a vendor Varies depending on changes

Example

  • Product A has a current quantity equal to 50 units.
  • There is a sale where 10 units of product A are sold.
  • You change this sale from 10 to 7 units of sold product A.
  • the quantity of product A that OnBalance lists increases by 3 units (10 - 7), showing 53 as the new current quantity.

If you do not want to accept the new calculated quantity of a product (for example, the products that a customer returned were broken, and you cannot sell them again), enter an inventory adjustment.