57 | SupFree (Custom Report)
This article demonstrates an example of a Custom SupFree Report. Disclaimer: This report may need modifications or alterations base on each system setup and configuration.
This article demonstrates an example of a Custom SupFree 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>2012-03-13T13:18:25</dtDateUpdated>
<iOperatorID>0</iOperatorID>
<sName>SupFree</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>Supplier Free Products</sReportName><sSQL>SELECT SupplierID, Description, SUM(OrderedEachEx) AS OrigCost, SUM(ReceivedEachEx) AS RecvCost,
(SUM(ReceivedUnits) + Sum(ReceivedCases * Caseqty)) AS Qty
FROM POLine INNER JOIN
POHeader ON POLine.POHeaderID = POHeader.POHeaderID
Where ReceivedEachEx = 0
and POLine.firstReceiveDate &gt;= {DateFrom}
And POLine.FirstReceiveDate &lt;= {DateTo}
and SupplierID = {NumEntry:SuiplierID}
GROUP BY SupplierID, Description
</sSQL><oColumnDefs><dictionary /></oColumnDefs></cCustomReport></sViewXML>
</cViews>