Inventory adjustments can be created automatically through Pavilion activity, such as sales and returns. You can also add manual adjustments when you need to correct quantities, update inventory balances, or reflect physical inventory changes.

ℹ️ Automatic adjustments generated by Pavilion cannot be edited.

Adjustments might affect Store Balances (see Inventory Balances )

Adjustment Types

Adjustment Type	Behaviour	Can be added manually	Note
Purchase	Adjusts the Owned quantity	✅	It is automatically added when a new In Stock item is created or a memoed item is purchased.
Trade-In	Adjusts the Owned quantity	✅	It is automatically added when a new trade-in item is created.
Return to Vendor	Adjusts the Owned quantity	✅	It is used to manually adjust quantities in cases such as returning an item to the vendor or returning a memoed item to the vendor.
Memo In	Adjusts the Memo In quantity	✅	It is automatically added when a new In Stock item is created with a “Memo” flag checked
Memo Out	Adjusts the Memo Out quantity	✅	It is automatically added when the B2B Memo document is posted
Memo Out Return	Adjusts Memo Out quantity	✅	It is used to manually adjust quantities when returning a Memo Out item.
Sale	Adjusts Owned and On Memo quantity	✅	It is automatically added during sales and when the order is finalized.
Sale Return	Adjusts the Owned quantity	✅	It is automatically added during sales and when order related item is returned.
Lost	When adjustment quantity is a positive number, it increases number of owned items. Otherwise, owned pieces are consumed before pieces on memo.	✅	It is used to manually adjust quantities during the inventory process when an item is lost.
Found	When the adjustment quantity is a negative number, it decreases the number of owned items.	✅	It is used to manually adjust quantities during the inventory process when an item is found.
Scrap	When adjustment quantity is a positive number, it increases number of owned items. Otherwise, owned pieces are consumed before pieces on memo.	✅	It is used to manually adjust quantities during the inventory process when an item is scrapped.
Reserve	Adjusts the available quantity without changing the on-hand quantity	❌	It is automatically created when an item is a part of any unfinished order or when item is used as a reference for a job.

Add a manual inventory adjustment

Open the inventory item you want to update.
Go to the Activity tab.
In the Inventory Balances section, click + Adjust.
In the Operation dropdown, select the type of adjustment you want to make.
Review or update the Date and Time.
Enter the Quantity.
Enter the Price for the adjustment.
Search for and select the related Vendor / Customer, if applicable.
Enter a Document / Note, if needed.
If the item uses a multi-quantity pricing model, select the Store and Location where the adjustment should apply.
Click Save.

The adjustment will appear in the item’s inventory balance history.

Filter inventory balances by store

If an item has inventory activity across multiple stores, use the Choose store dropdown to filter the inventory balances by store.

This helps you review adjustments for a specific store location.

Edit a manual inventory adjustment

You can edit manual adjustments after they have been added. Automatic adjustments cannot be edited.

Open the inventory item.
Go to the Activity tab.
In the Inventory Balances section, find the manual adjustment you want to update.
Click the arrow next to the adjustment.
Click Edit.
Update the adjustment information.
Review the edited information for accuracy.
Click Save.

Delete a manual inventory adjustment

You can delete manual adjustments if they were added manually and are eligible to be removed.

Open the inventory item.
Go to the Activity tab.
In the Inventory Balances section, find the manual adjustment you want to delete.
Click the arrow next to the adjustment.
Click Delete.
Confirm the deletion by clicking Delete again.

How do I add, edit, or delete manual inventory adjustments?