Skip to Content
0
Former Member
Jan 17, 2012 at 05:00 PM

Available To Promise - Monthly View

895 Views

Hello Experts,

Have anyone tried to generate a query that would display Availability of all items in month view:

Ex: It would be in this format. I created 2 views to accomodate this but still thinking to see if i get this data with a single query or is there any table that i look into and group by months?

*Year ItemCode ItemDesc Instock Jan Committed Jan OnOrder Jan ATP...........................Dec Commited Dec OnOrder Dec ATP*