Hello everyone,
We use the STD method, and change the STD cost irregularly, and don’t use cost roll-up feature.(only entered manually)
So I want to see who made what changes and when for each part. Past change history.
Has anyone created this report? Could you please give me some advice on how to create this report in BAQ?
Thanks in advance!
Part Transaction History Tracker will show you this info if you’re just after a quick enquiry into a single part.
Otherwise, create a BAQ and query the Part Tran table. Most of what you will need is in this single table.
Filter it down by “ADJ-CST” in the PartTran.TranType column.
You may also want consider joining PartTran.InvAdjReason to Reason.code.
Hi,
Actually, I created BAQ that filter it down by “ADJ-CST” in the PartTran.TranType column. However, we have various ADJ-CSTs in addition to this STD adjustment. For example, ADJ-CST also appears when PPV occurs. So I only want to see the details that the user entered in Cost Adjustment.
Of course I can filter by Reason code, but I can’t filter out cases where the user accidentally enters a different Reason code. So I only want to see the details entered in this Cost Adjustment menu.
Cost Adjustment is done by several people, and unfortunately I cannot ask them to keep this Transaction Log.
Table PartCost holds the current cost
Table CostPart shows the history, which cost group changed the part cost and if you bring in the group table, who did it.
Do I need to do any other settings besides the screenshot you showed?
I tried that, but it doesn’t show the history, only the latest information.
After further looking at it, this only works for the costing workbench. I would stick with the previous suggestion, look for ADJ-CST transactions on PartTran. There is a reference field on that screen that flows through to PartTran. Maybe a screen customization could populate that with something for you to filter by.
