General information

The functionality of item history enables the preview of all transactions made with a given item. To open the item history, it is necessary to click on [History] button available in the main menu or in the ergonomic panel above the list of items.

The form of item history is divided into the following tabs: Chronologically, By customer/Vendor Groups and By Customer/Vendor Codes.

In the history, only those documents are displayed to which the operator currently logged-in to the center has access.

Tab Chronologically

Tab Chronologically contains chronologically presented list of transactions including a given item and Item Quantity in Warehouse (By Date of Receipt/Release) list.

The first list is composed of the following columns:

• Customer/Vendor Code − code of customer/vendor to which a transaction document was issued
• Customer/vendor Name − name of customer/vendor to which a transaction document was issued
• Type − transaction document type
• Quantity − item quantity expressed in the basic unit
• Value − total value of an item on a document
• Price − unit price of an item on a document
• Date − date on which transaction document was issued
• Document Number
• Acquisition Value/Cost
• Currency
• Status (hidden by default) − transaction document status

In French databases for AVCO method of queuing resources, canceled documents are displayed twice in the   list, one time with date “stocked”/date of issue and the other time with the date of cancellation. The values of canceled documents in columns Quantity, Value, Acquisition Value/Cost are presented with opposite sign.

The list Stock Level presents the quantity of item available in a given warehouse calculated on the basis of the data from the list of transactions. The list contains two rows and is composed of the following columns:

• Status − initial or ending stock balance of an item
• Data − date of initial or ending stock balance of an item
• Quantity − quantity of selected item available in warehouse on a given day
• Purchase Value
• Acquisition Value − purchase value increased by additional costs (e.g., costs of transport)
• Currency

Tab Resources Chronologically

The tab Resources Chronologically is available for databases with AVCO queuing method only. It contains a list of transactions in which a given item was involved and which affected its stock levels. Besides columns which are also available in the tab Resources Chronologically, the list contains additional columns:

• AVCO Unit Acquisition Price
• AVCO Acquisition Value

Columns hidden by default:

• Unit Purchase Price
• Purchase Value

Tab By Customer/Vendor Groups

The tab By Customer/Vendor Groups contains information about total number and value of transactions in which a given item was involved, ordered by groups to which customers/vendors, for whom the transaction documents were issued, are assigned. The list is composed of the following columns:

• Group Code
• Group Name
• Quantity
• Value
• Price (Average)
• Currency

Tab By Customer/Vendor Codes

The tab By Customer/Vendor Groups contains information about total number and value of transactions in which a given item was involved, ordered by codes of customers/vendors, for whom the transaction documents were issued. The list is composed of the following columns:

• Customer/Vendor Code
• Customer/Vendor Name
• Quantity
• Value
• Price (Average)
• Currency

Filtering

Below each list, there is a filter which allows for searching transactions by:

• Date of Receipt/Release
• Warehouse
• Customer/Vendor
• Document Status − available values are Confirmed and Unconfirmed
• Document Type

Detailed description of functioning of the filters can be found in category Searching and filtering data.