cancel
Showing results for 
Search instead for 
Did you mean: 

Floor stock For Project

Former Member
0 Kudos

Dear Friends!

We require a report where in we can see the value & qty of all the components issued to project.

In our present scenario we are maintaining project stock, for a particular project, at say two storage locations 0001 & 0040.But once this material is issued to project for consuption etc. it is not traceable.

The report must show the opening floor stock for a period (ie material issued to project for consuption but not yet consumed): The received qty n value for the period & the final qty at end of month( ie opening + recieved- despatches from project) .

Any help with above issues wud be of gr8 value,

Regards,

Edited by: Seemant Parth on Apr 5, 2008 1:02 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hai,

Please verify if thos logic works....

Assume you have two periods Period 1 and Period 2.

Assume you are taking report for Period 2.

Report should have three columns

Stock in Project :: Material consumed :: Material recvd.

Stock in project = Materials available in Project stock and corresponding stnd price from Material master of each material.

Material consumed = Materials missing from the project stock as compared to period 1 project stock. Assuming you are not allowing any cross project transfers.

Material recvcd = Materials with GR posting date in Period 2.

For 2nd column data...

We should populate all materials from Proj stock table in to a Z-table and compare Z-table values and Proj stock table at end of each period. Whatever materials are missing are consumed.

Please discuss with your ABAPer..

Let us know after u try this.

Thanks

Saikishore Ganga.

Former Member
0 Kudos

Hi Ganga!

The ides is a good one and I will definitely sit with our devlopment team.The requirement is made even more complicated as we need to capture costs of work done in project activity, so it will be a challanging work.

Logically once we issue material to project we cant say its consumed immediately.Technically it cant be considered consumed till we confirm the activities holding the components.

The question is there any way(may be some modifications in material master) so that automatic GI is done to project from project stock once we partially confirme activities linked to component? OR Is there any standard table that gets populated with the data of components issued to project?

Thanks!

Former Member
0 Kudos

Hi!

Any takers?

This requirement is kind of unique, but thats where PS gurus pitch in with inovation.:-)

Regards,

Former Member
0 Kudos

Hi Gurus!

I am still awaiting responce & looking forward to distribute some forum points :-).

Regards