Hi Anitha, My response assumes that you are looking for two separate measurements. 1) the number of cancelled orders 2) the number of shipped orders
To count the number of orders that have been cancelled I would write a query and either use crystal or a dashboard to count the sales order records where the line status shows OrderDtl.VoidLine = Yes. This assumes that you are using the close line menu option when an order is cancelled which changes the Void line staus from no to yes. Since the void status is in the OrderDtl table and not the OrderHed table, you will need to decide how to include an order if one line is shipped complete and another line is voided. Dou you want to include this in your number of cancelled orders if only one line was cancelled? Another thing to consider is that the line is marked as voided only if it has no shipments made against it.
You say that you want to "find number of orders that have been shipped"
Are you looking to count the number of shipments or the number of unique sales orders that have been shipped?
Virginia Joseph
Deep Hole Specialists
440-543-8157
To count the number of orders that have been cancelled I would write a query and either use crystal or a dashboard to count the sales order records where the line status shows OrderDtl.VoidLine = Yes. This assumes that you are using the close line menu option when an order is cancelled which changes the Void line staus from no to yes. Since the void status is in the OrderDtl table and not the OrderHed table, you will need to decide how to include an order if one line is shipped complete and another line is voided. Dou you want to include this in your number of cancelled orders if only one line was cancelled? Another thing to consider is that the line is marked as voided only if it has no shipments made against it.
You say that you want to "find number of orders that have been shipped"
Are you looking to count the number of shipments or the number of unique sales orders that have been shipped?
Virginia Joseph
Deep Hole Specialists
440-543-8157
--- In vantage@yahoogroups.com, "Anitha" <anithayedavalli@...> wrote:
>
> Hi All,
> How do you find number of orders that have been shipped and cancelled in Epicor?I know to find open orders.Please reply quickly.Any help will be appreciated.
>
> Thanks,
> Regards,
> Anitha.
>