18 | GSTFR (Custom Report)
This article demonstrates an example of a Custom GSTFR Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.
This article demonstrates an example of a Custom GSTFR Report.
Disclaimer:
This report may need modifications or alterations base on each system setup and configuration.
Report Query:
<?xml version="1.0" encoding="utf-8"?>
<cViews xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<iListType>25</iListType>
<dtDateUpdated>2013-04-19T12:39:24</dtDateUpdated>
<iOperatorID>0</iOperatorID>
<sName>GSTFR*</sName>
<sViewXML><?xml version="1.0" encoding="utf-16"?><cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><sReportName>Asterix for GST Free ITems</sReportName><sSQL>select name, longname FROM ProdStore INNER JOIN
Product ON ProdStore.ProductID = Product.ProductID
where selltaxtype = 0
update product
set name = '*' + name,
longname = '*' + longname
FROM ProdStore INNER JOIN
Product ON ProdStore.ProductID = Product.ProductID
where selltaxtype = 0 and product.name NOT LIKE '*%'</sSQL><oColumnDefs><dictionary /></oColumnDefs></cCustomReport></sViewXML>
</cViews>
Other Parameter Settings:
This file needs to be saved as a *.REP file using a document editor
Other Parameter Settings: