Hi Manish,
this is a german forum, but whatever...
there is not much information in you message, what do you want to proof. But: The last purchase price is part of the item. Little query:
SELECT T0.[ItemCode], T0.[ItemName], T0.[LastPurPrc] FROM OITM T0
hope that helps
Hi Andreas,
thank u so much for the response.and it worked for last purchase price.but i want a query
that genrate a alert msg if the new prices of the items differs from last purchase price.for example if the last purchase price was 100 of a perticular item 'X' and if i purchase 'X' item in 110.then i want that system will generate a alert msg that item 'X' price is > last purchase price.
best regards
manish
