Skip to main content

Quick Report Sales Line Detail by Workflow Queue - Knowledgebase / SalesPad / Reporting - Cavallo Technical Support

Quick Report Sales Line Detail by Workflow Queue

Authors list

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




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*/


Helpful Unhelpful