Inventory transactions enquiry (DMR61501)

Options

Function keys

Note: This function key is only available in the 5250 session, not the DC1 UI Client.

More selections

Redefine your selection and sequencing criteria.

Retrieved records

The following columns display the records that the system retrieved when you clicked OK on the previous selection and sequence panels.

Item: This column lists the items on the inventory transaction.

Whs: This column lists the warehouses per item on the inventory transaction.

Inventory transaction type: This column lists the inventory transaction type identification for the created inventory transaction.

Accounting period: This column lists the accounting period per item for the created inventory transaction.

Quantity

This column lists the available quantity of the items per warehouse. If the unit is equal to the D/E-unit for the item, this quantity could display two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.

Stock account transaction type: This column lists the G/L stock account transaction type for the created inventory transaction.

Batch: This column lists the batch number of a batch controlled item.

Description: This column lists the transaction text, further describing the transaction.

Date: This column denotes the date the inventory transaction was created.

Submitted time: This column denotes the time when the inventory transaction was created.

Summarised transaction: Indicates if the transaction(s) is summarised. If set to YES, the accounting period for which the transactions are summarised is displayed in the Description column. Summarised transactions are those transactions with the same inventory event code, transaction type, item code and warehouse, within a certain time period, which have been combined into one. This summarisation is done in the Reorganise inventory transaction file program.

Transit delivery Y/N: This column is only displayed if the BtB function is activated, i.e. the BtB feature used field is set to YES in the DIS control file. Indicates if the inventory transaction is for a BtB order with a transit delivery.

Inventory event: This column lists the inventory event code and corresponding description, denoting the event that caused the inventory transaction to be created. For example, sales order, purchase order, stock withdrawal, etc.

Order number: This column lists the order number for the sales order/purchase order/service order/internal replenishment order/cash receipt /stock list or request number on this inventory transaction.

Order line number: This column lists the order line number for the sales order/purchase order/service order/internal replenishment order/cash receipt/stock list or request number on this inventory transaction.

Pick list/Reception note/: If this is a Sales order/Service order/Internal replenishment order and a pick list has been printed, this column lists the Pick list number on this inventory transaction.

Pick list line number/Reception note line number: If this is a Sales order/Service order/Internal replenishment order and a pick list has been printed, this column lists the Pick list line number on this inventory transaction.

Pick consolidation number: If the inventory transaction is for a Sales order/Service order/Internal replenishment order with pick consolidation, this column lists the pick consolidation number.

Shipment number: If the inventory transaction is for a Sales order/Service order/Internal replenishment order, this column lists the shipment number.

From/To warehouse: If this is an inventory movement transaction and/or internal replenishment order, this column lists the warehouse from which the item was moved.

Batch exists Y/N: This column is set to YES for all batch controlled items.

Non-confirming stock category: If the transaction refers to non-conforming stock, this column lists the non-conforming stock category. This category controls if the item is usable or not.

Non-conformity certificate number: If the transaction refers to non-conforming stock, this column lists the non-conformity certificate number.

Cost value of inventory transaction: This column lists the total cost value of the inventory transaction.

Reason code: This column is applicable for inventory adjustment transactions and lists the reason code entered when the inventory adjustment was done.

Signature: This column lists the user id if applicable.

User id: This column lists the code that identifies the employee that entered the transaction.

Work station id/job name: This column lists the work station id from where the transaction was entered and the job name.

Transport note: If the inventory transaction is for a Sales order/Service order/Internal replenishment order, this column lists the transport note number.

Non-conformity certificate active: This column is set to YES if the transaction was made against a NCC.

Transaction number: This column lists the internally used number.

Issue/reception: This column lists the value 1 if the transaction is an issue from stock and 2 if the transaction is a reception.

Type of order

This column lists the code for the type of order.

The following values could be displayed:

1	Sales order
2	Purchase order
3	Manufacturing order

Counted quantity: This column lists the stock take counted quantity.

Item account group: This column lists the item account group of the item on the transaction.

Item group: This column lists the item group of the item on the transaction.

Handler: This column lists the handler used on the transaction.

Cost-only transaction: This column denotes if the transaction is a cost-only transaction. “Cost-only” transactions are those that are written for events, such as an average cost change, that cause the stock value to be changed, but not the quantity.

Stock unit: This column lists the stock unit for the transaction.

Cost value full amount: This column lists the transaction cost value without adjustment according to the number of decimals for amount. Used for bookkeeping transaction creation for the decimals by the “Stock cost rounding” job.

Already cost/income accounted Y/N: This column denotes if the transaction has already been cost or income accounted.

Issue unit: This column lists the issue unit if the issue has been made in another unit than the stock unit. This information is applicable only for manufacturing orders.

Quantity issues in issue unit: This column lists the issued quantity in issue unit. This information is only applicable for manufacturing orders.

Inventory contract: This column is only available to display if DC1 Contract Managed Inventory (CMI) is activated. Displays the inventory contract for the inventory transaction.

Inventory contract line: This column is only available to display if DC1 Contract Managed Inventory (CMI) is activated. Displays the line number for the inventory contract.

Item description: This column lists the description of the item on the transaction.

Inventory transaction enquiry (DMR61504)

Related topics

This panel displays detailed information for the selected inventory transaction. Different information will be displayed depending on the inventory transaction type.

Function keys

Item: Displays the item on the inventory transaction and its description.

Batch: Displays the batch numbers of the item on the transaction.

Warehouse: Displays the warehouse in which the transaction took place.

Corresponding wh: If this is an inventory movement transaction and/or internal replenishment order, displays the warehouse from which the item was moved.

Quantity: Displays the quantity of the inventory transaction. Note: If the unit is equal to the D/E-unit for the item, this quantity could display two units in the same quantity field. The partial units could be displayed with decimal positions for the Display/Entry unit or by a dual display/entry of both the Display/Entry unit and the Stock unit separated by a user-defined delimiter. See About display/entry unit handling for more information.

Inventory event: Displays the inventory event code and corresponding description, indicating the event that caused the inventory transaction to be created. For example, sales order, purchase order, stock withdrawal, etc.

Transaction type: Displays the type and description of the inventory transaction created.

Accounting period: Displays the accounting period in which the inventory transaction is posted.

Cost value: Displays the total cost value of the inventory transaction.

Order/Cash receipt/List/Request

Four field names are valid for this field. The following information could be displayed:

the Order number for the sales order/purchase order/service order/internal replenishment order which created the transaction.
the Cash receipt number for the cash receipt which created the transaction.
the Stock take list number for the stock take list which created the transaction.
the Request number for the request and return transaction which created the transaction.

Order line/Cash receipt line/List line/Request line

Four field names are valid for this field. The following information could be displayed:

the Order line number for the sales order/purchase order/service order/internal replenishment order which created the transaction.
the Cash receipt line number for the cash receipt which created the transaction.
the Stock take list line number for the stock take list which created the transaction.
the Request line number for the request and return transaction which created the transaction.

Pick list/Reception note/Return list

Three field names are valid for this field. The following information could be displayed:

if this is a Sales order/Service order/Internal replenishment order and a pick list has been printed, displays the Pick list number on this inventory transaction.
if this is a Purchase order and a reception note has been confirmed, displays the Reception note number on this inventory transaction.
if this is a Service order and a return list has been printed, this field displays the Return list number on this inventory transaction.

Pick list line/Reception note line/Return list line

Three field names are valid for this field. The following information could be displayed:

if this is a Sales order/Service order/Internal replenishment order and a pick list has been printed, displays the Pick list line number on this inventory transaction.
if this is a Purchase order and a reception note has been confirmed, displays the Reception note line number on this inventory transaction.
if this is a Service order and a return list has been printed, this field displays the Return list line number on this inventory transaction.

Pick consolidation: If the inventory transaction is for a Sales order/Service order/Internal replenishment order with pick consolidation, displays the pick consolidation number.

Shipment number: If the inventory transaction is for a Sales order/Service order/Internal replenishment order, displays the shipment number.

Transport note: If the inventory transaction is for a Sales order/Service order/Internal replenishment order, displays the transport note number.

Inventory transaction enquiry, Selections (DMR61511)

Related topics

In this program you can make enquiries into the overall inventory transaction situation of each item within each warehouse where the item is stored. You can make one-time enquiries, but for enquiries made on a regular basis, you can define and use templates to retrieve the transaction details.

You can add or maintain templates by clicking Maintain template on this panel or by selecting Work with inv trans enquiry template from the menu item selection window.

This panel presents a subfile of the records that were selected according to the values defined in the template used for the enquiry. The records are presented in the sequence specified in the same template.

Scroll to view/enter more selections and when you are ready, click OK to view the result.

Function keys

Template: If you already have defined a template for the enquiry you want to run, enter the template name and click OK. If there are no templates configured in your system, you are able to enter applicable selection criteria and then save the transaction enquiry as a template by making use of Save as template. Note: The first time that you enter this panel, the default template SYSTEM will be used. When you subsequently access this panel, the template field is defaulted with the last template that you maintained, which is identified by the system through the user id.

Selection part 1

Inventory transaction enquiry, Selections (DMR61512)

Related topics

On this panel you can enter further selection criteria for this transaction enquiry.

Function keys

Template: If you are currently using a template, displays the template code.

Selection part 2

Item account group
Handler
Accounting period
Stock acc trans type
Inventory event
Inventory contract – Only displayed if DC1 Contract Managed Inventory (CMI) is activated.
Inv contract line – Only displayed if DC1 Contract Managed Inventory (CMI) is activated.

Click Next to access the next panel where you can define the sequence.

Inventory transaction enquiry (DMR61513)

Related topics

On this panel you define the sequence in which the major key fields selected in your template are to be displayed and printed. The predefined sequence is defaulted from the template that you are currently using, but can be changed. At least one field must be defined with a sequence.

Function keys

Sequence

Save as template (DMR61514)

Related topics

This window is displayed if you entered selection criteria on the Inventory transaction enquiry, Selections/Sequence panels and want to save these entries as a template.

Template

Click OK to confirm your new template and update it in the Work with inv trans enquiry template file.

Inventory transaction enquiry, Print (DMR61515)

Related topics

On this panel you confirm your transaction list printout.

Template: Displays the template selected for the transaction list printout you are creating.

Inventory transaction enquiry (DMR61516)

Related topics

This panel displays more detailed information for the selected inventory transaction. Different information will be displayed depending on the inventory transaction type.

Transaction number: Displays the inventory transaction number.

Date: Displays the date this inventory transaction was created.

Time: Displays the time when the inventory transaction was created.

User: Displays the code that identifies the employee that entered the transaction.

NCC number: Displays the non-conformity certificate number, if the transaction refers to non-conforming stock.

Stock category: Displays the non-conforming stock category, if the transaction refers to non-conforming stock. This category controls if the item is usable or not.

Summarised: Indicates if the transaction(s) is summarised. If set to YES, the accounting period for which the transactions are summarised is displayed in the Description field. Summarised transactions are those transactions with the same inventory event code, transaction type, item code and warehouse, within a certain time period, which have been combined into one. This summarisation is done in the Reorganise inventory transaction file program.

Transit: Only displayed if the BtB function is activated, i.e. the BtB feature used field is set to YES in the DIS control file. Indicates if the inventory transaction is for a BtB order with a transit delivery.

Stock acc trans type: Displays the transaction type of the stock account that was updated.

Reconciliation ref: Displays the unique reference number, which is automatically attached to this transaction and used in the reconciliation of the stock values between DC1 Distribution and DC1 Financials.

Item account group: Displays the item account group of the item on the transaction.

Item group: Displays the item group of the item on the transaction.

Handler: Displays the handler used on the transaction.