Hi I have developed a program.This program should display the accumulated stock (in_qty_oh) by item number (in_part) by domain (in_domain)
For instance when i have an item located in domain 004 site ITIDD and 5001 then the stock for this domain must be calculated together.
When I run my created script then it shows the accumulated stock but it does not make a break per domain.
I need this because if pt_status inside domain 001 = XX and the stock inside domain 002 to 004 is 0. then the item status of the pt_part must also be XX.
thus i need the report wich shows the item number, + total stock per domain.
so that i can compare with domain 001.
Can any one help me how the code shoud be?..
For instance when i have an item located in domain 004 site ITIDD and 5001 then the stock for this domain must be calculated together.
When I run my created script then it shows the accumulated stock but it does not make a break per domain.
I need this because if pt_status inside domain 001 = XX and the stock inside domain 002 to 004 is 0. then the item status of the pt_part must also be XX.
thus i need the report wich shows the item number, + total stock per domain.
so that i can compare with domain 001.
Can any one help me how the code shoud be?..