Adjustment Memo Fields

Adjustments Overview | Creating an Adjustment Memo

Basic

Refer to the tables below for descriptions of each adjustment memo field. Fields shown in brackets, e.g. [field name], are suggested or read-only fields auto-filled by Point of Sale.

If, when viewing a record list, columns (fields) shown below are not visible, you can use the customize columns feature to add them.

See also item fields for a description of common item fields that may appear on documents.

Cost Memos Fields:

Field	Usage
[Old Cost]	In Item List: Average unit cost for this item before adjustment.
New Cost	In Item List: Enter the adjusted average unit cost.
[Diff Cost]	In Item List: Difference in cost for the item: New Cost Old Cost
[Old Value]	In Totals area and Adjustment history: The total cost for all items listed on the memo before the adjustment.
[New Value]	In Totals area and Adjustment history: The total cost for all items listed on the memo after the adjustment.
[Value Change]	In Totals area and Adjustment history: Total difference in cost for all items on the memo. New Value Old Value
[Qty On-Hand]	In Totals area and Adjustment history list: Total combined quantity on-hand for all items on this memo.
[Current Qty]	In Item list: Current item on-hand quantity. This dynamic field shows the current inventory quantity, even when viewing saved cost memos (i.e. not the quantity at the time memo was created).

Quantity Memos Fields:

Field	Usage
[Old Qty]	In Item List: Quantity on hand for this item before adjustment. In Totals area and Adjustment History: Total quantity on hand for all items on this memo before adjustment.
New Qty	In Item List: Enter the adjusted quantity for the item. Becomes the new inventory quantity after saving. In Totals area and Adjustment history: Total quantity on hand for all items on this memo after adjustment. Not editable.
[Diff Qty]	In Item List: Difference in quantity for the item: New Qty Old Qty
[Qty Change]	In Totals area and Adjustment history: Total difference in quantity for all items on the memo: New Qty Old Qty
[Value Change]	In Totals and Adjustment history: Total difference in inventory value due to the quantity changes recorded on the memo. For example, if an item costs $5, and the quantity changes from 5 to 4, the value change is -$5. If the quantity changes from 5 to 7, the value change is $10.

Serial # (Pro)

Optional: Used to record item serial number(s) for the adjusted quantities.

[Store] Pro)

Headquarters only. Select the store for which you are making the adjustment memo. Default is Headquarters store. Editable

Common Memo Fields:

Field	Usage
Associate	The employee making the memo. Auto-filled if requiring employee login. If not requiring login, optionally select a name from the drop-down list.
Comment	For many actions in which memos are automatically generated, the Comment field will contain a description of why the memo was created. For example, Assembly created from inventory is the comment for a memo generated when assembly items are created. For manually created memos, enter a comment at your discretion.
Date	The date the memo was created. Editable, subject to security rights.
[QB Status] (QuickBooks financial software users only)	In Adjustment History list: Displays the status of Financial Exchange for a memo: Not Posted (not yet sent to QuickBooks), Complete (sent to QuickBooks), or Error (attempting to send the memo to QuickBooks resulted in an error). Learn more
Reason	Required field. Enter the reason for the adjustment or select from the drop-down list of predefined reasons. In the case of system-generated memos, the Reason field will be auto-filled: adjustment when manually adding items to inventory (Man Adj), building an assembly (CreatAsm), breaking an assembly (Brk Asm), etc.
[Source]	The action or module that created the memo: manually created memo (Manual), reversed in memo module (Reverse), physical inventory (Physical) inventory adjustment (Inventory), Assembly item (Assembly).
[Status]	In Adjustment History list: Shows the memo status: Regular, Reversed, or Reversing. Learn more.
[Type]	In Adjustment History list: The inventory value being adjusted: Quantity or Cost.
[Qty On-Hand]	In Totals area and Adjustment history list: Total combined quantity on-hand for all items on this memo.
[Current Qty]	(Item list) Current item on-hand quantity in inventory. This dynamic field shows the current inventory quantity, even when viewing former cost memos (i.e. not the quantity at the time memo was created).

[Unit of Measure] (Pro)

Used to display the base unit of measure (size) of the item being adjusted when using the multiple units of measure feature. Read only.

Return to top

Data fields overview