beas_invhistory

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