beas_invhistory [itemcode]
Returns all inventory history information on that item:
Balance |
Current balance |
Stock |
Released stock. The option of the current order proposal list is considered. According to this, blocked batches are subtracted. |
Stocklocked |
Stock on blocked warehouses + batches which are not available (status:blockerd) |
Workorderreceipt |
Planned goods receipt for production less already posted quantity |
workorderissue |
Reserved for work orders (issue according to BOM) |
Onorder |
Open purchase orders |
Iscommited |
Open sales orders |
Minlevel |
Minimum quantity (the setting stock management per warehouse is considered) |
Maxlevel |
Maximum quantity (the setting stock management per warehouse is considered) |
Leadtime |
Replenishment lead time |
Currentmrp |
Currently used MRP (required to read out the setting) |
reservation_total |
total Reservation (only Stock-Reservation) |
reservation_customerorder |
sum of Stock-Reservation for Customer Order |
The inventory history window uses this function.
Example:
tools=isql=exec beas_invhistory 'C11772'
Example
destroy=lds
declare=lds=ue_datastorevalues
lds=execute beas_invhistory 'C11772'
See isql