Each time a product is selected (while issuing a document), it is possible to execute SQL code.
This is set in Settings-> Purchase/Sales-> Documents-> SQL Run
|
1 2 3 4 5 |
-- lines -- sql -- lines-eof -- |
After the user has selected a product, the variables sent by EMDI to the SQL code are:
:aa Document line number “pvlhseis”. “aa”
:cd Document type line number “eidhpar”. “aa”
:rd Related document “eidhpar”. “parallhlo”
:pd Parent document “eidhpar”. “Koino”
:cl Client line number “pelates”.”aa” or “pvlhseis”. “kvdikospelath”
:bl Delivery customer line number “pvlhseis”. “Delivery”
:as command line number “pvlhseis”. “assignor”
:re relevant Document line number “pvlhseis”. “Sxetiko”
:pi product line number “grammes”.”Eidos”
:li Document line number “grammes”. “aa”
: pc Item code “grammes”. ”KvdikosEidoys”
: pn Item description “grammes”. ”PerigrafhEidoys”
: pw Weight “grammes”. ”baros_”
: pp Position “grammes”. ”uesh_”
: pr Portion “grammes”. ” meridasx_ ”
: ps Verse“ grammes ”.” stixossx_ ”
: pe Start date“ grammes ”.” enarjh_ ”
: pl Expiry date“ grammes ”.” kinhseis_ ”
:pq product quantity “grammes”.”Posothta”
EMDI receives content from the variables and defines it accordingly:
im_expired -> Expiration date “kinhseis”.”Lhjh”
im_position -> Position “kinhseis”.”Uesh”
im_portion -> Portion “grammes”.”meridasx_”
im_move -> Move “kinhseis”.”Stixos”
im_value -> Value of movement “kinhseis”.”Ajia”
im_weight -> Weight “kinhseis”.”Baros”
im_price -> Value excl. VAT “grammes”.”Timh”
im_quantity -> Quantity “grammes”.”Posothta”
im_description -> Product description “grammes”.”PerigrafhEidoys”
im_discount -> Discount rate “grammes”.”Ekptvsh”
im_message -> Opens an informational message
im_messagw -> Opens a warning message
