on 09-11-2008 2:10 PM
hi,
does anybody has experience in logging price information. Each time the price of an item is updated (item master data, or pricelist -->overview) i want to log this information and store it in a user defined table (user, date, item, pricelist, price).
What is the best way to do this?
1.Addon : each addon might be a handicap (performance, ...).
2. SBO Transaction Notification : lots of partners did some codings in this stored procedure and causes lots of problems
3. B1i: seems to be the best way
how would you implement such functionality
best regards
Markus
Edited by: Markus Rewak on Sep 11, 2008 3:12 PM
Hi Mark,
i would go for 1. or 2.
but 2. can be very problematic cause when you update the Item you can't really track if
the price changed.
so 1. ist the easiest (official) way for me - but only because i've never tried B1i ...
the easiest forbidden way is to use a trigger on ITM1 table
lg David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.