Kindly tell me, where I can see history of item master except Audit feature, in audit taking too much time & extra data, I used sessions ttaad4461m000 and ttaad4463m000 also

My objective is, I want to know only those item code which is start "RM" created in specific period

Item code : RM To RMZZZZZZZZZZZZZ
Created Date new item : 01/04/2009 To 08/11/2009


Thanks in Advance

Regards

Ali

Hello Muhammad,

the baan application does not record the creation date if an item in the item master. The normal method is to use audit management, which is not wanted in your case.

2 alternatives:
1. Create a DB trigger which can be used for the future
2. You could use the cost price history table ticpr300 assuming the cost price of an item is calculted on the same day that an item is inserted.

The second alternative is not very elegant, but should help in accomplihing your task.

Dear zacharyg

great...........

2nd suggestion is very near to solve my problem, thanks a lot

Regards

Ali