Technical Support Hours

M-F 8am to 8pm (EST)

Start a conversation

Quick Report Sales Line Detail by Workflow Queue

The following Quick Report (no UDFs required) will display Sales Line Detail by Workflow Queue:

<report name="Sales Line" AutoLinks="true" autoRun="true" BestFitAll="true">
<search name="Warehouse" column="Wareshouse_Code" searchOp="like" />
<query addWhere="true">
SELECT
FROM
sl.Sales_Doc_Num, sl.Sales_Doc_Type, sl.Source, Item_Number, Sales_Batch, sl.Warehouse_Code
spv3SalesLineItem as sl (nolock)
join spv3SalesDocument as sd (nolock) on sd.Sales_Doc_Num =
sl.Sales_Doc_Num and sd.Sales_Doc_Type = sl.Sales_Doc_Type
/*where*/
</query>
<column name="Source" Visible="false"/>
</report>

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. SalesPad Support

  2. Posted

Comments