BAQ the parts change log

Yahoo Archive
1
Patrick, thank you.
ChgLog itself just work fine with criteria for Table name = Part. Tech support pointed me in right direction.
Your suggestion is good too. That was my original dilemma on how to join both together. But looks like adding Part table in my situation adds no value to information i am pulling. Thanks again. Mikhail
2
Hello,
We are at Epicor 9 and I need help to identify tables to use in my BAQ.
I have setup BAM to track changes in Part, specifically part description.
It records any changes made to part description.

Now I need to create BAQ for all parts, changes made to part description.
I can't identify tables that I need. Please help.

Thanks,
Mikhail
3

Join PART to ChgLog  (inner or Outer) pending on what you want.

Company to Company

PartNum to Key1

 

That should get you started. You will have to filter for specifics.

 

Patrick Winter

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, October 20, 2014 09:28
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ the parts change log

 

 

Hello,
We are at Epicor 9 and I need help to identify tables to use in my BAQ.
I have setup BAM to track changes in Part, specifically part description.
It records any changes made to part description.

Now I need to create BAQ for all parts, changes made to part description.
I can't identify tables that I need. Please help.

Thanks,
Mikhail

This email and any attached files are confidential and intended solely for the intended recipient(s). If you are not the named recipient you should not read, distribute, copy or alter this email. Any views or opinions expressed in this email are those of the author and do not represent those of the Specialty Screw Corporation company. Warning: Although precautions have been taken to make sure no viruses are present in this email, the company cannot accept responsibility for any loss or damage that arise from the use of this email or attachments.