Skip to Content
0
Former Member
May 13, 2008 at 02:05 PM

Inventory - last purchase date

1671 Views

This is my first post, so my apologies if all is not correct.

We were recently taken over and the new owners are trying to put a realistic value on the stock and it has fallen to me to provide the information. I need to ascertain the age of the stock and could do this 2 ways if the information was available:

1. Use the last purchase date to determine how long we have held the stock. Acceptable but the last purchase field in OITM is not the last purchase date. For items it is, for others it is the last stock transaction date and for the rest I have no idea what the date relates to.

2. Use a last transaction date, if only SAP had one. Our old system had this date and it made life very simple.

I can find dates for last issue, receipt and sale but not for production order transactions. If I could then I can get the information merging a few spreadsheets.

A last transaction date must be stored somewhere, maybe in the financials?

Any help would be gratefully received.

Regards

Stewart Clark

We are using 2005 SP1 PL45.