Inventory Projection Report

Former Member · ‎2008 Jun 24

HI ALL,BELOW IS MY REQUIREMENT FROM CLIENT ,CAN ANYBODY HELP ON THIS.......

Current Current Month

Valuation (from Accntg 1 view) Run-Date(Today is 5/27) May-08 Wk 19 Wk 20 Wk 21 Wk 22 8-May 7-Jun 7-Jul 6-Aug 5-Sep

3610 1000 1032 1045 2034

5610 1320 1402 1045

. . . . . . . . . . .

. . . . . . . . .

. . . . . . . . . . .

In - Transit (= Sum of Confirm. Cat = LA on ShipNT) 5432 5432 5432 5432 5432 5432 5432 5432 5432 5432

Total 2320 2434 2090 2034

In-Transit broken out by valuation class

Weeks will be only for future days. 5 week columns will be static. Data will be for current month (Sunday end).

Selection Screen

Plant

Material

REGARDS

SATHEESH

GauthamV · ‎2008 Jun 24

hi,

take the relevant tables and logic for ur report from functional consultants and start working if any query then come back.

Former Member · ‎2008 Jun 24

hi,

unable to understant your requirement.

but for fetching, you can get every months all 5 weeks, their satart date and end date

FM:GET_WEEK_INFO_BASED_ON_DATE