Material Requirement Planning (weekly)

[#1]

Dear experts,

pls find attached a file with data from three tables in three different sheets.

I want to design Material Requirement planning on a weekly basis. but i am always not getting the correct sum total for few weeks.

I think the problem is more to do with date format.

the following are the columns required.

a.Week no, (column wise).

b. Item no. and No. are same fields ,

c. opening stock in qty

d. net change (sum of qty in inventory sheet)

e. production (sum of Qty in Production sheet)

f. Purchase (sum of Qty in Purchase Sheet)

g. Closing Stock in Qty.

This closing stock will become opening stock of next month.

Can anyone try this and tell exactly where the error is from.

it will be great if you can provide the answer in qlikview file.

[Clever_Anjos]

I´ve loaded you data and started you table.

You can continue based on this qvw

[#3]

Thanks Clever.

How to calculate closing qty and use the same for next day's opening.

I want the data for all dates, even if no qty on that date

[#4]

Dear clever,

pls find attached the sample files.\

i am not getting closing as opening.

[preminqlik]

hope this helps u