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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;cCustomReport xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;&lt;sReportName&gt;Asterix for GST Free ITems&lt;/sReportName&gt;&lt;sSQL&gt;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 '*%'&lt;/sSQL&gt;&lt;oColumnDefs&gt;&lt;dictionary /&gt;&lt;/oColumnDefs&gt;&lt;/cCustomReport&gt;</sViewXML>

</cViews>