Summary
How it works
Crystal Reports
PRINT
Date
COPY_ARRAY
IS_WEEKEND
Decimal
COPY_ARRAY
Development
LINK_OPEN
VALIDATE
VALIDATE_TRANSACTION
VIEW_SCREEN
Integer
COPY_ARRAY
Short Integer
COPY_ARRAY
File
CREATE_DIRECTORY
CSV_TO_XLSX
DEL_DIRECTORY
DOWNLOAD
GET_COMPLETE_NAME
GET_EXTENSION
GET_HASH
GET_NAME
LIST_DIRECTORIES
LIST_FILES
PATH_TO_VOLUME
UNZIP
UPLOAD
VOLUME_TO_PATH
ZIP
FTP
DELETE
DOWNLOAD
LIST
UPLOAD
Image
GENERATE_CODE
IMAP
LIST_DIRECTORIES
JSON
COUNT
DEL_KEY
GET_KEYS
GET_ONE
GET_POS_KEY
GET_TYPE
GET_VALUE
SET_VALUE
TO_ARRAY
SMS
SEND
SMTP
SEND_EMAIL
Stock
GET_AVAILABLE_QTY
GET_COST
Text
COPY_ARRAY
COUNT_OCCURRENCES
HTML_DECODE
HTML_ENCODE
HTML_TO_TXT
IS_NUMERIC
LINK_DECODE
LINK_ENCODE
RANDOM
REPLACE
RTF_TO_TXT
SPLIT
TO_BASE64
User
CHECK_PASSWORD
Sale
CLOSE_ORDER
GET_PRICE
func X3.EN_STOCK_GET_AVAILABLE_QTY(Char FACILITY_IN, Char ITEM_IN, Char LOT_IN, Char LOCATION_IN, Integer LOCATION_TYPE_IN, Integer STATUS_IN, Char CUSTOMER_IN, Char OWNER_IN, Char WAREHOUSE_IN, Char VERSION_IN) : Decimal

Returns the available stock for an item and facility filtered on lot, location, status, warehouse

  • FACILITY_IN Char Stock facility
  • ITEM_IN Char Article
  • LOT_IN Char Lot number with the following options:
    • Full lot number
    • Start of lot number followed by "*"
    • All lot numbers with "*"
    • Empty lot number with ""
  • LOCATION_IN Char Location with the following options:
    • Complete location code
    • Start of location code followed by "*"
    • All locations with "*"
  • LOCATION_TYPE_IN Integer Type of location with the following options:
    • -7 = All except Internal
    • -6 = Client + Subcontractor
    • -5 = Waiting for storage + Subcontractor
    • -4 = Subcontractor
    • -3 = Waiting for storage + Customer
    • -2 = Customer
    • -1 = Waiting for storage
    • 0 = Internal
    • 1 = Internal + Waiting for storage
    • 2 = Internal + Customer
    • 3 = Internal + Waiting for storage + Customer
    • 4 = Internal + Subcontractor
    • 5 = Internal + Waiting for storage + Subcontractor
    • 6 = Internal + Customer + Subcontractor
    • 7 = Tous
  • STATUS_IN Integer Statuses searched with the following options:
    • 1 = Status A
    • 2 = Status Q
    • 3 = Status A+Q
    • 4 = Status R
    • 5 = Status A+R
    • 6 = Status Q+R
    • 7 = Status A+Q+R
  • CUSTOMER_IN Char Customer load delivered if customer reservation consumption or ""
  • OWNER_IN Char Owner or ""
  • WAREHOUSE_IN Char Warehouse or ""
  • VERSION_IN Char Major version or ""
Return Decimal Quantity available in stock unit
Example

func X3.EN_STOCK_GET_AVAILABLE_QTY("DE012", "BMS001", "*", "*", 0, 1, "", "", "", "")
Returns the quantity available for the item BMS001 on facility DE012 on all internal locations in status A