I am planning on using the PartTran table in a BAQ, and extract records from a part number for a period of 1 year… Is it possible to then summarize and display the quantity results into their own separate months?
Thank you
Crawling the PartTran table is possible yes.
Yes, I have done this recently by creating a datediff month calculation on the trandate and then grouping the transactions by that calculation and transaction type.
@tdejager Thomas attached are 2 examples of how I have worked with the dates. First is just and extract from part tran hist. The other groups on month and price point to look for pricing issues.
PL_CustPartPriceHist.baq (39.2 KB)
EPIUSERS_PartTran.baq (18.9 KB)
I hope they give you a starting point.
I created the same before. Created calculated fields, datename for year and month for the trandate, sum of tranqty then group by partnum, trantype, month, year.