I’m trying to find an efficient method for adding the EmpID to the PartTranHist data view in the ‘Part Transaction Histroy Tracker’ form.
The data is in the PartTran table, it’s just not pulled into the PartTranHist view.
I’ve tried adding the PartTran table as a foreign key view to the PartTranHist view but neither the TranNum or SysRowID seem to be exposed for me to attempt a join
I’ve tried looking for a system BAQ to copy/clone to create my own view to replace the system view. I’ve found a couple I could build from but they’re missing the RunningTotal.
Is there a simple way to do this or do I need to create my own view that mimmicks the system view and then add/calculate the running total manually myself?