Change Asset Tag Fields

This utility can be used to update and correct Asset Tag Details as if accessed from the Rental Inventory.
Tight operator Security Roles should be applied to this option to protect against unwarranted tag adjustments.

PRODUCT #

Enter the product number, or select it from the Inventory Search window.

ASSET TAG #

Enter the relevant Fixed Asset Tag number, or select it from the Asset Tag Search window.
If the tag does not exist yet or has any invalid data values, this can be addressed in the Tag window in Rental Inventory.

Fixed Asset Tag Information:
The current tag information is displayed and can be modified as follows:

DATE LAST DISPOSAL

Any existing disposal date is display and can be changed as required.

ORIGINAL QUANTITY

This is the Original Quantity on the tag, and can be updated as required which updates the Current Quantity On Hand and the Average Cost for the tag.
Note: A non-bulk product quantity cannot exceed a quantity of 1 after the disposals and transfers have been included.

QUANTITY SOLD

The total sold count is displayed and can be updated as required which updates the Current Quantity On Hand and the Average Cost for the tag.

QUANTITY TRANSFERRED

The total count transferred out to an external branch or to a Sales product is displayed and can be updated as required which updates the Current Quantity On Hand and the Average Cost for the tag.

CURRENT QUANTITY ON HAND

The resulting quantity is displayed.
(Current Qty = Original Qty - Qty Sold - Qty Transferred)

TOTAL ORIGINAL COST

The total Original Cost is usually calculated as the (Current Tag Qty * Avg Cost Each) however this is not updated automatically.
This can be changed manually as required which then updates the Net Original Cost, Book Values and the Average Cost for the tag.

ACCUMULATED ADDITIONS

The additions dollar value is displayed which can either be changed in this field which adds a "Manual Adjustment" as of the current date to the Accumulated Additions table, or can be added in the window provided which then updates the additions total.
A changes to the additions total updates the Net Original Cost, Book Values and the Average Cost for the tag.

ACCUMULATED DISPOSALS

The disposal dollar value is displayed which can either be changed in this field which updates the Net Original Cost, Book Values and the Average Cost for the tag.

ACCUMULATED TRANSFERS

The transfer out dollar value is displayed which can either be changed in this field which updates the Net Original Cost, Book Values and the Average Cost for the tag.

NET ORIGINAL COST

The total net cost is updated automatically based on changes to the Cost, Additions, Disposals and Transfers amounts.

ACCUMULATED DEPRECIATION

The total Accumulated Depreciation is calculated as the (Current Tag * the Average Depreciation Each).
This accumulated total value can be updated as required, which updates the Net Book Value and the Average Book Value, and adds an "Adjustment" as of the current date to the Depreciation History table on the Asset Tag Details that will be respected when calculating the next Depreciation.

NET BOOK VALUE

The Book Value is automatically calculated as the (Net Original Cost - Accumulated Depreciation) and cannot be changed manually.

AVERAGE COST

This is the average cost each value and is a display field only which will adjust automatically if the Net Original Cost changes.

AVGERAGE BOOK VALUE

This is the book value each and is a display field only, which will adjust automatically if the Net Book Value changes.

Finished?

Click the ACCEPT button to accept, or CANCEL to abort.

COST ADJUSTMENT DATE

When the Net Original Cost is changed and accepted the Operator is prompted for the Cost Adjustment Date as outlined in Cost Adjustment.
This date is used to track cost changes and is reflected in View Average Cost Adjustments.