Need assistance creating a Custom Report (Excel Export)

V5 Question
1

I am trying to create a custom report with the following fields and information to be exported to an excel file at the end of the business day.

The fields required are:

Customer Number
Invoice Number
POS Customer
Customer
Invoice DateTime
InvoiceDate
Product/ServiceDescription
Product/Service
LineNum
Product/Service Quantity
Product/Service Amount
Customer Sales Tax Code
Sales Tax

Any assistance with this would be greatly appreciated.

2
3

You can make a report that will act like a .CSV file and it can be exported through a DATA EXPORT

Here is an example of one I found on the forum.

[Sales:1,1,1]
@{REPORT ORDER DETAILS:O.MenuItemName,O.ExactTotal.Sum.desc:(ODI=True):{0}:,}
{REPORT ORDER DETAILS: 
	O.ItemGroup,
  O.MenuItemName,
  O.Quantity.Sum.desc,
  O.ExactTotal.Sum.desc
:(ODI=True) and O.MenuItemName="$1"
:"{0}";"{1}";{2};{3}}

Also note I use semicolon instead of commas it just a personal preference.

Here is some more useful info