Administration > Setup > Inventory > Generate item overview > Generate item - robinfeng/beashelp GitHub Wiki
Field Meaning Group Define a group to select from (optional) Selection Definition of group selection. Input mandatory. Select from groups. Designation A further designation of the selection can be entered. Creating a new item, the selection is displayed in brackets, followed by the designation Item number changeable Item number is generated automatically. Enable this function to make the number changeable. Source item Which item to use as default (as template)? Description Type of description:
- like source item
- manual input at new creation
- automatic generation
Tab Meaning Item number and designation Determines structure of item number and designation Start- and end script A script can be deposited, which will be executed at selection, start and end of item creation. You can use it to predefine the designation or item number (temporarily saved in a variable) Field assignments Determine, which values are entered to the item fields. Access all item master fields.
Item number and designation Field Meaning Item number Text and placeholder describing the structure of the item number Example: ABC-<time,hhmmss> Creates an item number with ABC-[time], ABC-100520 or AA0<select convert(varchar(8),isnull(max(convert(decimal(10,0),substring(itemcode,4,8))),0)+1) from oitm where substring(itemcode,1,3)='AA0' and len(itemcode)=8%,padr 0=5> creates item number AA000001, AA000002, ...
Also possible: in tab Start and end script in field "script at selection" build up the item number in advance with beas-script select convert(varchar(8),isnull(max(convert(decimal(10,0),substring(itemcode,4,8))),0)+1) from oitm where substring(itemcode,1,3)='AA0' setvar=ls_itemcode=AA0
enter variable in field item number <ls_itemcode>
help-beispielExample of item generation: Item number "A00" + an 8-digit consecutive number should be generated:
AA0<select convert(varchar(8),isnull(max(convert(decimal(10,0),substring(itemcode,4,8))),0)+1) from oitm where substring(itemcode,1,3)='AA0' and len(itemcode)=8%,padr 0=5>
Designation If the designation is to be generated, define with placeholders: hello world -> In designation field this text would be entered
Start and End script Field Meaning Script at selection A beas-script can be entered which is executed at selection of new item creation. In this way, item number or designation can be generated in advance. To cancel the process: return false Start-Script This script is called, after clicking the New / Copy button, but before the item is copied. Reading and writing access on the variables: itemcode_from from which the item is copied itemcode_to target item number Example: setvar=itemcode_to=11134 The item number is changed. Jump back by return false to cancel the process. End-Script This script is called after copying. Subsequently BOM or routing positions can be matched. The created item is in variable itemcode_to Example: update beas_stl set menge_verbrauch=1 where itemcode=N'<itemcode_to>' and pos_id=10 Copying finished, jump back with return false has no effect.
Field assignment
Any field assignment can be made to all fields of item master (OITM table). feldname=neuer wert
Example 1:
In field "felder" a field can be selected. This is added under "field assignments" Example: Enter a 1 in item - version number u_beas_ver=1
Example 2: The user field "u_group" should receive the selected item generation number u_group=
back to generate item overview
θΏε δΈ»ι‘΅