back order visualization

[andyrebs]

Hi,

I would like to have a chart that displays backorders, but only for customers who also have an order for delivery tomorrow.

I have those two table

Cod.Cus	CompanyName
001	Company1
002	Company2
003	Company3
004	Company4
005	Company5
006	Company6
007	Company7
008	Company8
009	Company9
010	Company10
011	Company11
012	Company12
013	Company13
014	Company14
015	Company15
016	Company16
017	Company17
018	Company18
019	Company19

ordN°	CodCus	CodArt.	DeliveryDateRequired	Qty	Price	Status
Ord001	Cus001	Art001	29/07/2013	1	10	Delivered
Ord001	Cus001	Art002	29/07/2013	2	12	pending
Ord001	Cus001	Art003	29/07/2013	4	9	pending
Ord002	Cus002	Art004	29/07/2013	1	3	Delivered
Ord003	Cus003	Art005	29/07/2013	2	78	pending
Ord004	Cus001	Art006	30/07/2013	1	12	Delivered
Ord005	Cus002	Art007	30/07/2013	3	15	Delivered
Ord005	Cus002	Art008	30/07/2013	12	12	Delivered
Ord005	Cus002	Art009	30/07/2013	3	1	pending
Ord010	Cus003	Art010	30/07/2013	1	43	pending
Ord011	Cus001	Art011	31/07/2013	3	23	Delivered
Ord011	Cus001	Art012	31/07/2013	1	54	Delivered
Ord012	Cus002	Art013	31/07/2013	4	12	Delivered
Ord012	Cus002	Art014	31/07/2013	2	1	Delivered
Ord013	Cus003	Art015	31/07/2013	3	3	pending
Ord016	Cus001	Art016	01/08/2013	1	4	pending
Ord016	Cus001	Art017	01/08/2013	7	5	pending
Ord017	Cus002	Art018	01/08/2013	4	1	pending
Ord017	Cus002	Art019	01/08/2013	1	323	pending

I would see only the order in status pending, but only of customers Cus001 and Cus002, because they have an order with DeliveryDateRequired tomorrow (today is 31-07-2013).

Many Thanks

Andrea

[Kushal_Chawda]

hi,

see the attched application

[andyrebs]

Hi Kush,

many thanks for you answer. Unfortunatelly this is not what I am looking for.

In your application you use this expression

=if(Date=date(Today()+1,'DD/MM/YYYY'),Status)

It show me the orders that I have to deliver tomorrow, but not the backorders of those customers .

If it is possible, I would see not only the orders I should deliver tomorrow, but also the back orders of the customers that have an order that it should be delivered tomorrow.

[andyrebs]

Hi All..

Any News?