cancel
Showing results for 
Search instead for 
Did you mean: 

best way to log price information ?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Nussi
Active Contributor
0 Kudos

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

Former Member
0 Kudos

hi David,

we never do forbidden things

i only need the price of each day (1 price / day). So it doesn't matter if the price has changed or not.

The problem is there are 2 ways to change the price:

1.item master

2.double click on pricelist --> items in pricelist

thanks

Markus