Skip to Content
avatar image
Former Member

best way to log price information ?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 11, 2008 at 01:17 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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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