Stock value

In this procedure you can create lists showing the value of the parts in stock.

You can select which balance you want to use in the valuation of parts in stock. The available balances are current balance, last stock count date, optional stock count date, and different historical balances which are based on actual date or log date. You can also decide if parts without balance should be included. You can enter a minimum value per unit for the parts you want to include in the list. Different price alternatives for purchased and manufactured parts are then selected for the valuation, e.g. current standard price or a historical price.

There are no update options in the procedure.

Detailed

This list shows detailed information about the stock value for the selected parts. The list can be grouped by part code or product group.

Total

This list shows total information about the stock value for the selected parts. The balances and values in the list are also displayed as a bar chart. It can be presented as total by part, by part code, or by product group.

Total by date

This list shows total information about the stock value for the selected parts. The purpose is to see how the stock value has changed over time. The balances and values in the list are also displayed as a bar chart. This list is shown as total by date, based on the grouping of dates you select in the next field.

Configured parts

This list type is available if the option Product configurator is installed in your system. Here you can see the stock value based on current balances of the configured parts.

Reconciliation

In this list type you reconcile the stock value with the booked balance on stock accounts in the accounting.

The presentations determine how the selected list should be displayed/presented. For example if it should be presented as grouped or as total. There are some standard presentations included in the program.

In most procedures where you can load lists, it is possible to create your own presentations. This is done under Presentations in the backstage of the procedure in question. If you create your own presentation you can for example choose if it should have a drilldown function and a drilldown filterering.

You can select which columns the list should consist of, and for each of the columns you can configure grouping, sorting, aggregation, and if the column should be shown in chart form and if it should be printed. Additionally you can also make printout settings, chart settings, and settings regarding extra aggregation.

Read more about this in Presentations.

In a list procedure there is always a tab called Selection where you can select data records in different intervals from the database. The data records are then loaded by using the Load button in the toolbar of the procedure.

Under Selection rows in the backstage of the procedure, you can choose which selection rows that each list type should have, under the Selection tab in the procedure. In the List type field you select for which list type you want to customize the selection rows.

One table shows selection rows possible to select and one one table shows the selected selection rows. You can add, delete, or move selection rows by dragging and dropping the selection rows with your mouse pointer.

Using the Save button you save the selected selection rows.

Read more about this in the Selection topic.