topic Re: Re: Material Requirement Planning (weekly) in QlikView

Material Requirement Planning (weekly)

Sun, 27 Oct 2013 12:25:57 GMT

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 — Sun, 27 Oct 2013 13:29:43 GMT

I´ve loaded you data and started you table.

You can continue based on this qvw

Sun, 27 Oct 2013 13:37:01 GMT

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

Sun, 27 Oct 2013 14:10:59 GMT

Dear clever,

pls find attached the sample files.\

i am not getting closing as opening.

preminqlik — Sun, 27 Oct 2013 19:52:57 GMT

hope this helps u