Line items

All the line items in the stock entry are displayed and can be recorded on the Items | Goods received | Line items tab. The line items in a return slip are shown here for return slips.

 

Items | Goods received | View goods received authorization is required for this menu command.

Items | Warehouse management | Edit stock entries authorization is required to edit a stock entry.

You can make entries directly in the table or you can use the areas below the table for this.

 

All the line items that are aleady flagged as Completed (Completed option is activated) are displayed in gray. Uncompleted line items are shown in black.

'Stock entry slip line items' list

The individual line items in a stock entry slip / return slip are listed here.

Stock entry slip line item

Internal unique line item number, cannot be edited.

Purchase order line item

Corresponds to the Print line item field in the purchase order. The sequence order of the purchase order line items is recorded in the Print line item field when a purchase order is booked / printed. The purchase order line items can be placed in a particular sequence order using the Sequence field in a purchase order. If entries exist in the Sequence field for a purchase order line item, they will be included in the Print line item field.

List functions

The filter, search, and sort list functions can be used to adjust the view.

Create stock entry line item

  1. Click on the button in the Navigator on the Items | Goods received | Line items tab. A new data set is created in the list of stock entry line items.

  2. You can make the entries in the table or in the areas below the list. To insert an item from the item master data, open the item search assistnt using the button.

  3. A unique stock entry slip line item number is generated when saving or inserting a further stock entry line item.

'Items' area

You can edit the item data for the stock entry / return slip line item marked in the list in this area.

Items

The Item number and Item description 1 for the current stock entry line item are displayed here.

The item search assistant can be opened for selecting an item using the Selection field.

Number

Contains the delivered quantity of an item (quantity received).

Purchase order no.

Displays the transferred purchase order number of the item for the selected vendor. This field can still be edited.

Warehouse

Specify for each line item the warehouse to which the stock entry slip line item is to be booked.

You can select a warehouse from the warehouse list using the Selection field.

If a warehouse is not specified for a line item, the warehouse specified on the Items | Goods received | Details - 'Details' area tab is used.

The default setting is the main warehouse.

 

Main warehouse

The Main warehouse is specified under Settings | Items | Warehouse management | Settings - 'General' area.

Warehouse booked

This option is activated if the line item has already been booked to a warehouse.

The option cannot be changed.

Average PP booked

This option indicates if the average purchase price (PP) has been booked for this line item.

The Checked button is used to flag the stock entry as Checked and the average purchase price booked (depending on the settings).

 

If the On stock entry payment approval option or the On booking stock entry option under Settings | Items | Item management | Settings - 'General' area is activated for Average purchase price, the average purchase price will be determined on the basis of the purchase price entered for the stock entry.

'Prices' area

You can view / edit the price data of an item for the stock entry / return slip line item marked in the list in this area.

Net price / PU

Displays the net price of the individual line item in the selected currency. The price refers to the price unit (PU) shown in the adjacent field. This price is the basis for paying the invoice from the vendor. The currency will be taken into account when creating an invoice for foreign vendors.

 

The net price is included in the stock entryb if the vendor's currency code corresponds to the currency code of the purchase order.

The price of each individual line item is already specified in the purchase order. This stipulated purchase price is entered automatically when the individual line items are included.

However, the final price can differ from the previously stipulated price. The prices may need to be corrected so that the correct amount can be paid.

The price field on this tab can be edited until the average purchase price has been calculated or the stock entry is approved for payment. (The corresponding options are then activated).

As soon as one of these options is set, the price will be grayed out so that it can no longer be edited.

If With actual purchase prices is used (Settings | Items | Item management | Settings - 'General' area), the purchase prices on the Project | Project orders | Materials overview tab in order processing will allso be adjusted when the purchase prices are altered in the stock entry.

Total

The total price is calculated automatically (quantity * unit price) and shown in the Total field.

'Serial numbers' area

The available serial numbers for the stock entry slip / return note line item marked in the list are shown in this area.

The List functions are available in the Serial numbers list.

The serial numbers can be recorded using the Manage button in the Serial numbers area of the Line items toolbar.

Functions / Toolbars

Various functions are provided in the toolbars (ribbons / ribbon bars) above the tabs.

The toolbar structure depends on the current module / tab.

 

Some toolbars are only shown when you edit certain fields, such as the Text toolbar when you edit rich text fields.

'Line items' toolbar

'Edit data set' area

Edit

Click on the Edit button to switch the Form to Edit mode.

The usual Input elements are available in Edit mode.

If data has been changed and you close the form or change to another data set, a message will be displayed asking you if you want to save the changes or not.

Changes can be undone by clicking the Reject changes button as long as input has not been actively saved or the form has not been closed or the data set changed.

 

Detail data sets can also be opened directly in Edit mode. To do this, deactivate the Do not automatically edit detail data option under Settings | General | General | Settings | System settings - 'Program behavior' area.

Also see Edit Data Set

Apply

You can always actively save changes in the data by clicking the Apply button.

Apply and close

You can save the changed data and close the entry form / module in one go with the Apply and close function.

Reject changes

Changes can be undone by clicking the Reject changes button as long as input has not been actively saved or the form has not been closed or the data set changed.

'Line item' area

Add copper price

Adds the copper price to the current stock entry line item.

 

You can edit the basic copper price for goods received on the Items | Goods received | Details - 'Details' area tab. The copper price recorded under Settings | Items | Item management | Settings - 'General' area is entered by default when a stock entry is created.

You can also add the copper price to individual stock entry line items using the Add copper price function in the Navigation toolbar.

 

The options specified for Materials purchase costs and Copper surcharge according to under Settings | Items | Stock movement | Settings | General - 'Order material' area affect the copper price calculation and the charges for an order.

Remove copper price

You can remove the copper price from all the stock entry line items to which it has been added (Add copper price function) using the Remove copper price button.

 

The copper price can be removed from all line items of a stock entry using the Remove copper price function in the Navigation toolbar.

Stock levels

You can display the current warehouse stocks of the selected item in a separate window (warehouse stocks dialog) at any time using the Warehouse stocks button.

The current item number and item description 1 are shown in the header of the Warehouse stocks window.

 

You can leave the window open and select a different item in the list. The display of the warehouse stocks will be updated accordingly.

Include prices in item master data

The prices from the stock entry line item can be included in the item master data using this function. The function is only available for items that exist in the item master data.

 

Items | Item management | Edit item PP or Items | Item management | Edit items (own OB only) (incl. PP) authorization is required for the Enter price in item master data function.

A security prompt is displayed before the prices are actually entered.

Include in item master data

You can use this button to create an item in the item master data from an item in the stock entry, such as a miscellaneous item from the purchase order.

Label printing

You can use this command to print labels for the current line item.

It is necessary for a corresponding report to be registered under the program entry point.

Purchase order line item allocation

If there is a purchase order associated with the stock entry, you can open the Order assignment window for the currently selected line item using the Purchase order line item allocation button. Here you can view the order numbers belonging to each particular purchase order line item. As well as the order number, the warehouse, commissioned quantity, and any reservations, etc. are also displayed.

The commissioned quantity can be edited. The new total quantities resulting from this are immediately entered in the purchase order line items.

You can change the breakdown of the purchase order line items using the Remove breakdowns button. You can use the New for order button to allocate an order requirement line item and the New for warehouse button to allocate a line item to a warehouse.

 

The totals of the breakdown quantities must be equal to the quantity of purchase order line items (Ordered quantity) after the changes have been made, otherwise the changed breakdown cannot be saved.

Breakdown

Breakdown of stock entry note line items across several orders

This dialog displays the breakdown or distribution of a stock entry note line item or return note line item.

Assign requirement line items

This function enables assignment of a stock entry line item to an order requirement line item. The orders are searched for a requirement line item corresponding to the marked line item and this will be suggested for assignment. The selection can be further restricted using filters.

All the requirement line items are shown in this dialog. A requirement line item can then be assigned using the Assign button.

For each Requirement line item, the

  • Item no.
  • Item description 1 and Item description 2 from the item master data,
  • Purchase order description 1 and Purchase order description 2 for the particular vendor from the Items | Vendors - 'Purchase order data' sub tab tab,
  • data for the associated order line item (Line item ID, Print line item, Item no., and Description 1 and 2),

when it is opened.

Additionally, the requested quantity, open quantity, ordered quantity, and the Deliver by date from the requirement line item are shown.

The purchase price check is made through the purchase price from the order line item. The percentage difference is displayed in color.

Functionality

The items marked in the list are shown in the header of the Assign order requirement line items window. A requirement line item is assigned to this item.

All the order line items are shown in the list. The list can be restricted using the Order, Item, and Open order requirements only filters

Position on the item line item in the table that you want to assign to the line item in the header of the window. The particular purchase price (PP) of the line items is shown at the bottom of the window.

Click on the Assign button to assign the ItemIDno to the order line item of the miscellaneous line item.

Set warehouse

A different warehouse can be specified for individual line items.

More information about warehouse bookings for stock entries is found under Consider warehouse when booking.

Specify warehouse for stock entry line items

  1. Mark one or more line items in the list. The marked line items are highlighted in color.

     

    Multiple selection / marking of data sets

    Several entries in the list can be selected by holding down the Ctrl key and left clicking on the entries.

  2. Click on the Set warehouse button.

    The Select warehouse window opens.

  3. Select a warehouse from the list and then click on OK.

     

    You can also use the Search function to find a warehouse in the list.

'Serial numbers' area

Manage

Use the Manage button to open Serial number management / serial number recording for an item.

 

Requirements for serial number management

To manage the serial numbers of warehouse items it is necessary to set With serial number management to Complete under Settings | Items | Item management | Settings - 'General' area and to activate the With serial number management option for the item on the Items | Items / Services | Details II - 'Items' area tab.

'Information' area

The details about the selected item are displayed in the Information area.

'Assigned serial numbers' area

The serial numbers already recorded are listed in the Assigned serial numbers area. You can create, delete, and save serial number entries, and generate consecutive serial numbers using the Navigator above the list.

'Serial number details' area

You can record the detail information for each recorded serial number in this area.

Correct

You can edit an already recorded serial number using the Correct button.

Record serial numbers

  1. To enter serial numbers, click on the button in the Navigator.

    A new data set is created.

  2. Now enter the serial number for an item.

     

    If more than one serial number is sent with a shipping notification through eswawi, the additional serial numbers in the Additional serial no. field will be saved on import.

  3. Enter the Date received and the Manufacture date.

  4. The main vendor of the item is entered as the Vendor by default. This can be edited.

  5. Enter the vendor's guarantee period in months (Guarantee (external)) and your own guarantee period (Guarantee (own)) if this is different.

  6. You can also record a Remark in the information window

  7. Save your entries by clicking on the button in the navigator.

  8. Repeat the above steps to enter more serial numbers.

When all of your items have been given serial numbers, they are then saved automatically and can be recalled at any time.

Automatic serial number assignment

Serial numbers can also be assigned automatically in eserp.

A vendor will usually supply items with consecutive serial numbers. For this reason, you can simply specify the starting serial number when entering serial numbers for goods received, for example. The subsequent numbers are then generated automatically.

Serial numbers up to the maximum number of existing items can be created automatically for goods received and for warehouse items.

The Generate button is provided in the Navigator above the serial number list for this purpose.

Enter the first serial number manually as the start number.

Then click on the Generate button.

The Generate serial numbers window opens, showing the maximum number of serial numbers to be created. The Number can be adjusted. You can view the Start serial number and the End serial number.

The Generate button records these numbers automatically.

 

There are two ways to increment automatically.

The maximum number of numerical places is usually cut from the end. The number cut is used as the minimum for the increment.

If the first digit in the cut number is a zero, formatting will be used. Otherwise, no formatting is used.

Example: 25 serial numbers are to be generated automatically.

With formatting

Start serial number 345 0815 - 07.

The digits 07 are cut and the serial numbers from 345 0815 - 08 through 345 0815 - 32 are created.

Without formatting

Start serial number 345 0815 - 107.

The digits 107 are cut and the serial numbers from 345 0815 - 108 through 345 0815 - 132 are created.

Start serial number 345 0815 - 7.

The digit 7 is cut and the serial numbers from 345 0815 - 8 through 345 0815 - 32 are created.

'Batch' area

Items can be collected together into a BatchClosed DotNetHost is an esoffice program extension for generating and checking electronic invoices in the ZUGFeRD and xInvoice formats., for example to assign all the items in a batch to one warehouse location. The serial number search can be filtered to a batch.

Create batch

You can create a batch for the currently marked line item using this button.

The Vendor is already set to the Vendor for the stock entry.

Assign a matchcode to the batch and enter the vendor's number for the batch.

Click on the OK button to create the batch. An internal batch number is drawn from the CHA number range.

 

If a batch has already been created for the line item, the button will be grayed out.

Edit batch

You can edit an existing batch using this button.

 

If a batch has not yet been created for the line item, the button will be grayed out.