INV: Adjustments

Overview

The Adjustments screen allows for the entry of adjustments for a specified Job #. This may be a contracted job or a generic job such as Warehouse or Inventory. Adjustments are commonly entered after a physical inventory count in order to adjust the Quantity On Hand information to make it equal to the actual quantity in stock.

Items entered as a negative number are subtracted from the Item Master file. Items entered with a positive number are added to the inventory for the specified item. When changes to items are made on this screen they will update the Quantity On Hand and Total Cost On Hand in the Item Master file.

Each item that is to be adjusted is entered into the Inventory Adjustment Details grid. The Item Number and Quantity are entered. The Price defaults from the Item Master File. The Extension value is calculated automatically, but may be manually adjusted, if needed. Item Information displays for any item selected.

Key Functionality

Click the Advanced filter button to create or edit a filter for finding and/or sorting specific records. You can also select a Saved filter. Click the Apply Filter/Sort button to apply any filter or sort criteria you created. Click the Remove Filter/Sort button to remove a filter or sort, if one is currently applied. For more information see Advanced Filtering.

Lookup

Enter the Adjustment reference number, or use the Lookup to locate an existing Adjustment record.

Posted

To view the GL Log# with which the transaction was posted and/or speed the process of un-posting and/or reprinting GL entries, the GL: Journal Update Log screen may be accessed by double-clicking a record's blue Posted status.

Reference Number

The system assigns the next available reference number. This number cannot be changed.

Date

Use the Date field to enter the actual date the adjustment should be made.
Select the default date, or use the Date Control to select a date.

If you are viewing an existing document, the Date field displays the date the items were adjusted.

Warehouse

Select the Warehouse responsible for the Adjustment. The list contains only the valid warehouses set up in Warehouse Locations screen.

You can double-click to open the Warehouse Locations add/edit list.

Job #

Enter the Job # in this field, or use the Lookup to locate the Job Number.

Notes

Use the Notes field to enter any notes about this adjustment record. If you enter more than one line of information, the system automatically wraps the lines of information for you. Date Added

Displays the date this record was created in the system.

Hover over the Change Information icon to see User Added, Date Added, User Changed and Date Changed information. WinTeam records the logon name of the user entering or changing this record. The Date Added is the original date this record was entered into the system. The Date Changed is the date the record was last changed. Right-click on the Change Info icon to filter for records added or changed by a specific user or date.

When you hover over the User Changed or Date Changed filters, you can:

  • Filter By Selection - Filters for all records that match your current records field value.
  • Filter by Exclusion - Excludes from your filter all records that match your current records field value.
  • Filter For - Filters based on the text/value you enter.
  • Sort Ascending - If you already have a filter applied, the Sort Ascending command is available. Also used to include all records in the filter and sort in ascending order based on the current records field value.
  • Sort Descending - If you already have a filter applied, the Sort Descending command is available. Also used to include all records in the filter and sort in descending order based on the current records field value.

Inventory Adjustment Details grid

Item Number

Enter the Item Number associated with the Adjustment, or use the Lookup to locate the Item Number.

Description

Displays the Description of the Item Number based on the description in the Item Master File.

Quantity

Use the Quantity field to enter the quantity to be adjusted.

To decrease the Quantity On Hand and the Total Cost in the Item Master File for this item, enter a Negative number.
To increase the Quantity On Hand, enter a Positive number.

You may use decimals.

Example:  If the unit of measure for the item is a case and you need to adjust only a half of a case, then enter as -.5 to signify that only half of a case is being adjusted out of inventory.

Price

The Price field defaults from the Item Master File for this item. The price displays based on the Job Cost Method entered on the Item Master File for this item. Normally the Standard Cost is used to calculate the cost.

Measure

The Measure field defaults from the Unit of Measure from the Item Master File for this item.

Extension

The extension is computed based upon the following calculation:

Quantity x Price = Extension

If the Quantity is modified, the Extension value is recalculated automatically. Negative adjustments are displayed/ in parentheses ( ). The Extension amount can be entered without a Quantity, to reflect a dollar adjustment to the Total Cost On Hand in the Item Master File.

Warning:  If you are making a negative adjustment to the extension amount you must enter a negative number either before or after the new extension amount. Entry of a positive number will blank out the Price field and increase the Total Cost On Hand in the Item Master File.