Approved Supplier Change Log

Epicor ERP 10
1

Hi

I need to apply a changelog to monitor any Suppliers being added/removed from Approved Supplier.

Within the Supplier Pricelist there is an ‘Approved Supplier’ Boolean. I need to monitor if this is ticked / unticked. However I know this is a view and so I am unsure where to apply my changelog
image

Can anyone offer any assistance please?

2

Hmmm … Even if you create a change log on DB field, there’s no “Change log button” to view the change log.

image

Where as a form like Part has:

image

3

It looks like Approved Supplier isn’t explicitly stored anywhere. But rather that if an entry exists in AprvVend, then it is shows as true. (Approved Supplier is checked).

Un-checking that box deletes the related record in AprvVend.

So a change log won’t work. You’ll need to either have:

  1. A BPM to email you when A record in AprvVend is created or deleted
  2. A BPM to create an entry in a UD table to log the Addition or deletion of the AprvVend record.
1 Like
4

Many thanks Calvin. I was leaning towards the email function if I couldn’t find a solution - much appreciated- i’ll give it a whirl

Stay safe!