The reports are made easily with the programming language SQL and some other commands from EMDI that are implement on the comments.

Variables that you can use on the code

:apo                                            starting date
:ews                                            final date
:search                                       Search
:asearch                                     Search
:position                                    position of repeated variable

Περιγραφή αναφοράς           1 parameter accounts
Κωδικός αναφοράς                2nd parameter accounts
:param1                                    3rd parameter accounts
:param2                                   4th parameter accounts

:search                                     search for forms that are search checked
:orderby                                   it is added instead of order by command for sorting

–nodecimals–                        unlimited decimals

 

Fields on the code

(used in the select command)
doc                                            sales line number “Aa” (create a button that opens sales in the selected document)
cus                                            client line number “Aa” (create a button that opens the selected customer)
pro                                            product line number “Aa” (creating a button that opens the selected item)
prd                                            the product line number “Aa” (creating a button that opens the documents of the selected item)
ksq                                            its result is used in the update script (creating a button that opens an editor for data editing)
eml                                           the e-mail to be send|Name|E-invoice link|Shipping tracking number (create a button that sends an e-mail)
sms                                           the mobile to be send|Name|E-invoice link|Shipping tracking number (create a button that sends sms)

NEXT VALUE FOR “gen_counter”     number line

The first line contains some commands from EMDI like comments:

Where searchtitle,the title of the search field(2 fields).

If you want to create a graph, then complete where xx the field for axel x and yy the field for the axel y and xxlabel the title of the field that is on the axel x.

To create loops,fill the fromvalue,tovalue,stepvalue

To count the lines use the following variable which is after the select: