Lots Adjustments In CustomBooks™

Lots Adjustments

In CustomBooks™, Lots Adjustments are used to correct or update the quantity, cost, or lot assignment of lot-tracked inventory items.  This ensures accurate inventory tracking, compliance, and valuation.

Viewing the List of Lots Adjustments

To view the list of Lots Adjustments: Navigate to Inventory > Lots Adjustments.



From the Lots Adjustments List View, you can:
  • Create New or Copy a Lots Adjustment.
  • Export the Lots Adjustment List to Excel, PDF, or other formats.
  • Manage Columns: add, remove, or reorder.
  • Refresh the Lots Adjustment list.
  • Create multiple custom views using Filters, Sorting, Ordering, and Conditional Appearance Settings.

Creating a New Lots Adjustment

To create a new Lot Adjustment:
  1. Navigate to Inventory > Lot Adjustments.
  2. Click Create > New.
  3. Enter the Lot Adjustment Date.
  4. Select the Inventory Item with Lots.
  5. Choose the Location/Warehouse.
  6. Select the Lots from the drop-down list.
  7. Enter the Adjustment Quantity or the New Quantity.
  8. Click Save or Save and Close.



See How to Create a Lot Adjustment

This video provides a step-by-step walkthrough of creating a Lot Adjustment in CustomBooks, including selecting the inventory item and lot, entering the adjustment amount, reviewing the updated quantity, and saving the adjustment.

Video Summary

To create a Lot Adjustment, navigate to Inventory > Lot Adjustments and select Create > New. Select the item and the specific lot you want to adjust, then enter the adjustment amount. CustomBooks displays the current quantity and automatically calculates the updated quantity before you save the adjustment.

Key Takeaways

  • Create a new Lot Adjustment from Inventory > Lot Adjustments.
  • The adjustment date defaults to the current date and can be changed when a different adjustment date is needed.
  • Select the inventory item and specific lot, then enter the adjustment amount.
  • CustomBooks displays the current quantity and calculates the updated quantity before you save the adjustment.
＋ Read the Full Video Transcript

In this video, we’ll guide you through creating a Lot Adjustment in CustomBooks.

To get started, navigate to the Inventory menu and select Lot Adjustments. Then, click Create and New to open a new Lot Adjustment form.

The date field will automatically populate with today’s date. If you need to apply the adjustment to a different date, be sure to update it accordingly. Next, enter the item and the specific lot for which you are making the adjustment.

CustomBooks will display the current quantity for the selected item and lot. Simply enter the adjustment amount, and the system will automatically calculate and display the updated quantity, helping you ensure your inventory remains accurate.

When you’re satisfied with the adjustment, click Save to finalize the update to your lot quantity.