QMcKay
July 9, 2018, 12:54pm
6
adam100:
is there a way to generate data from the account screen, into a spreadsheet view. where it shows the ticket, time, date, total due and payment methods, including any vouchers taken?
Yes, using a Data Export to CSV which is like a Report, but it exports the data to a file instead of displaying it on screen. Using Excel, you can read/load CSV files …
I notice Data Exports feature under Manage > Reports, but nothing mentioned on the forum about it. What does this do? Can I use it to create CSV exports? Any info much appreciated. Thanks
EDIT: Ok I notice it exports the report to a txt file. If for example I use the {REPORT INVENTORY} tag I am getting output like this:
>Local Warehouse||
Svedka|4,900|ML
Absolute|4,280|ML
Belvedere|455|ML
Taking same format from the inventory report with the table header
[Inventory Report:1,1, 1…