Maybe the implementation by the programmers is simply inconsistent from one table to the next.
Epicor programmers would never be inconsistent.
Wow this thread went for a spin.
Alright so @klincecum and I are seeing the ChangeLog records deleted, ie no longer present. I’m looking in SSMS, and this is specifically for LaborHed & LaborDtl records.
@JasonMcD says the ChangeLog records are not deleted…
Perhaps there is a setting somewhere?? Or maybe the ChangeLog functions differently for the PartRev table?
And could I get an answer to my above question:
Any reason I can’t just add a change log record directly via BPM? The record will be orphaned I suppose; is that an issue? And yes I’d still need a BAQ to see them.
I’m pretty sure he was saying you could “infer” the record in the main table was deleted
in the specific case where a new record would be created.
As far as I can tell, unless there is some type of custom programming somewhere,
when a record is gone, so are it’s logs.
(Any custom logic would have to be done on Epicor’s side, because you can’t write directly to the ChgLog table. At least I haven’t been able to.)
Cool I just voted for the idea. I think you meant this one:
https://epicor-manufacturing.ideas.aha.io/ideas/ERP-I-1875
Oh, I meant the 3 digit one.
I want to add a sink for out of the database and not just update the current one. I like the immutability.