Custom Reports
      Back to home
      1. INTERNAL - Bepoz Help Guides
      2. End-User | Reporting, Data Analysis & Security
      3. Custom Reports

      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>&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;Supplier Free Products&lt;/sReportName&gt;&lt;sSQL&gt;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 &amp;gt;=  {DateFrom} 

      And POLine.FirstReceiveDate &amp;lt;=  {DateTo} 

       

      and SupplierID = {NumEntry:SuiplierID} 

      GROUP BY SupplierID, Description

      &lt;/sSQL&gt;&lt;oColumnDefs&gt;&lt;dictionary /&gt;&lt;/oColumnDefs&gt;&lt;/cCustomReport&gt;</sViewXML>

      </cViews>

       

       

       

       

      Other Parameter Settings:

      This file needs to be saved as a *.REP file using a document editor