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
: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:
--search-searchtitle-asearch-searchtitle-graph x-xx-graph y-yy-graph labels-xxlabel-from-fromvalue-to-tovalue-step-stepvalue
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:
NEXT VALUE FOR "gen_counter" AS "Row #", ...