There are three ways to adjust material inventory’s quantity of hand for any material marked as a Stock Item. In the Material record’s Detail view, select Stock or Increase Adjustment to increase the quantity on hand or Decrease Adjustment to decrease the quantity on hand. If the organization is using the Advanced Resources extension, Material Location is required when performing one of these actions.

This quantity on hand adjustment entries are listed in the logs in the Material detail view as stocked, increase adjustment, or decrease adjustment transactions. Once the entries are made, they cannot be edited. Make another entry to adjust the quantity. Quantity on hand updates when an entry is saved. This setup is not editable by users.

The total quantity on hand for the material is listed in the header of the Material record. This is a total of the quantity for all locations.

Inventory Fields

These fields help in determining whether a material is ready for Ordering for a location or a material is below the minimum amount to get refilled.

These fields are:

  • Reorder Point-a point after which material is ready to be ordered for a location.
  • Reorder Amount-default amount to order when reorder point is past.
  • Set these fields for each material from the location page.
  • Minimum Amount-minimum threshold set after which to refill the truck.

Each Stock material should be stocked at a location.

For example, Lead is stocked at East warehouse and West warehouse.

The Reorder Point is set at 5 lb for East warehouse while 9 lb for West warehouse; lead at West warehouse gets used more than East warehouse.

The Reorder Amount is set at 25 lb and 45 lb respectively.

Once material’s quantity on hand falls below the reorder point. For example, quantity-on-hand is 4 lb for East and 8 lb for West warehouse, these materials display on the Ordering screen with Reorder amount defaulted to 25 lb and 45 lb respectively.

NOTE: Setting them from the material page wouldn’t work because materials at different location could have different values for these.

Inventory Methods

There are many ways to value inventory and determine the cost used when items are used for task activities. Your organization’s accounting department determines your inventory valuation method.

NOTE: The material log transaction reflects the use of the specified quantity at a total cost. The total cost is determined by the inventory method selected for the material. The Cost per Unit (CPU) shown for this transaction is the total cost divided by the quantity. Once an inventory method is selected for a material, it cannot be changed if logs have been posted to the material.

Cartegraph recognizes the following inventory methods:

  • FIFO (First in, First Out): Items are used at the price of the oldest inventory item.
  • LIFO (Last in, First Out): Items are used at the price of the newest in inventory.

When LIFO or FIFO calculations are based on the date of the transactions. When two transactions have the same date, the system uses the first date encountered.

  • Most Expensive: The most expensive items are used first, regardless of when the items were received into inventory.
  • Least Expensive: The least expensive items are used first, regardless of when the items were received into inventory.


SCHEDULE A DEMONSTRATION

An AGL Representative is standing by to assist you.
For sales and technical support, call now!