Concept of planned Document:
1. Create a Document with type (issue, transfer and so on)
2. Insert lines per Batchnum/Warehouse
3. Create the issue, transfer and so on
Table: beas_plandocument, beas_plandocument_line
You can create the planned Document from Reservation or other
new=<doctype> |
Create new planned Document set docentry, doctype and lifetime before new Example: declare=res=ue_reservation res=planned=ref2=WO201 res=planned=comments=Issue for Workorder res=planned=doctype=issue res=planned=new res=planned=addline=<..> |
docdate=<date> |
set the planned document-date. Set this argument first (first docdate, then new) |
ref2 |
set the ref2 for the document. Set this argument first (first ref2, then new) |
comments |
set the comments for the document. Set this argument first (first comments, then new) |
docentry=<pdocentry> |
set the current docentry (example if you reopen the object and lost the instance ec WEBAPPS-Developement) set this bevor you set "new" |
doctype=<pdoctype> |
set the current doctype |
livetime |
set livetime - Propertie (set before you set "new") |
addline=<properties> |
set line to the current planned document (only datastore, not database), delimited with tab example:itemcode=xxx<char 9>quantity=5<tab> ... with parameter "save" you create the database-update directly |
updateline |
save the added lines to database |
delete |
delete current plan-document |
addfromreservation=<filter> |
load List from reservation declare=res=ue_reservation res=planned=new=issue res=planned=addfromreservation=beas_reservation_line.base_type='wo' and beas_reservation_line.base_docentry=48 res=issuewo |
issuewo |
Workorder-Issue |
btransfer |
Batchnum-Transfer (ue_reservation.transfer_batch) |
res_docentry |
docentry reservation-Line
|
res_linenum |
linenum of reservation-Line |
base_doctype |
the base-document, example: wo for Workorder 17 = customer order wo = work order
Purchase 13 = Purchase Reserve Invoice 22 = Purchase Order 540000006 = Purchase Quotation |
base_docentry |
the base-docentry, example: the beas_fthaupt.belnr_id |
base_linenum |
the base-linenum, example: the beas_ftpos.belpos_id, customer-order: 0 |
base_linenum2 |
the base-linenum2, example: the beas_ftstl.pos_id, customer-order: rdr1.linenum |
set_quantity |
the Qty to book |
quantity |
the issue-Quantity |
itemcode |
itemcode |
whscode |
warehouse |
batchnum, distnumber |
the batchnumber or serial-internal-Number if a receipt-function then the serial-number or serial/batchnumber, comma-separated or with " , " max 1024 Sign
|
status |
Status Batchnumber (only for receipt) |
mnfserial |
Batch Attribut 1 (only for receipt) |
lotnumber |
Batch Attribut 2 (only for receipt) |
indate |
Admission Date (only for receipt) |
mnfdate |
Manufacturing Date (only for receipt) |
expdate |
Expiry date (only for receipt) |
details, notes |
Batchnum - Notes (varchar 255): (only for receipt) |
bincode |
the bincode or osri.sysserial as string |
rfid |
rfid |
linenum |
|
linetype |
type of line |
udf1 ... udf4 |
UDF1 to UDF4 |
price |
|
currency |
|
save |
save the line. ATTENTION: If you add more then one line, then don't use this propertie! Add All Lines and after then use "planned=updateline". This is faster |
Batch-Properties |
generate more entries in one step ... |
totalqty |
total quantity. beas make entrys with quantity while sum of quantity <= totalqty |
counterlen |
Length of counter |
format |
Format for batch/distnumber. Placeholder for counter: {counter] Example: format=ABC-{counter} This string is the new batch number / distnumber |
counterstart |
Begin of Counter |
Example Generate Line for 100 Serialnumbers
declare=res=ue_reservation
res=planned=new=incommingpo
res=planned=addline=itemcode=A0002<tab>whscode=01<tab>&
base_docentry=<5><tab>base_linenum=<1><tab>base_doctype=22<tab>&
quantity=1<tab>&
linetype=incommingpo<tab>&
totalqty=100<tab>format=ABC-{counter}<tab>&
counterstart=20<tab>counterlen=4<tab>&
save
This Command Generate 100 Serial number-Entrys in beas_plandocument with
"ABC-0020","ABC-00021" ...