Summary
How it works
Crystal Reports
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_SALE_GET_PRICE(Char CUSTOMER_IN, Char ITEM_IN, Char SALE_FACILITY_IN, Char STOCK_FACILITY_IN, Char CURRENCY_IN, Date DATE_IN, Decimal QUANTITY_IN, Char UNIT_IN, Char TYPE_IN) : Decimal
Allows you to retrieve the gross or net selling price of an item
- CUSTOMER_IN Char Customer code concerned
- ITEM_IN Char Article reference concerned
- SALE_FACILITY_IN Char Sales site concerned
- STOCK_FACILITY_IN Char Stock site concerned
- CURRENCY_IN Char Currency concerned
- DATE_IN Date Date of sale concerned
- QUANTITY_IN Decimal Quantity concerned
- UNIT_IN Char Unit concerned
- TYPE_IN Char G for the GROSS price and N for the NET price
Example
func X3.EN_SALE_GET_PRICE("FR004", "DIS007", "FR011", "FR011", "EUR", [08/10/2020], 1, "UN", "N")
Returns the NET price of item DIS007 for customer FR004 in EURO on the given date and for 1 UN