Skip to main content

Can I see Sales Monitor at the line item detail level? - Knowledgebase / SalesPad / FAQ - Cavallo Technical Support

Can I see Sales Monitor at the line item detail level?

Authors list

No, Sales Monitor does not display line item detail, but here's a Quick Report (no UDFs required) that will display Sales Line Detail by Workflow Queue:




SELECT
sl.Sales_Doc_Num,
sl.Sales_Doc_Type,
sl.Source,
Item_Number,
Sales_Batch,
sl.Warehouse_Code
FROM
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