Today has been long and my brain isn’t liking this puzzle and decided to ask for help. I’m needing to have every part in PartTran to have 1-12 for months of the year with the number of times a transaction has happened against it within that month; even if it’s zero. Note: I’m restricting to time …

You can make 12 calculated fields, [image] Then in each field’s code, you can put this for the corresponding month number: [image] Keep in mind this doesn’t take into account years. It will count all occurrences, doesn’t matter which year it is. You may have to give it a date range if you want t…

That would work. Would like to get the months in the same column.

All months into one column? like “Jan: 14, Feb: 1, Mar: 3, …”?

There is a guide in Epicor help on how to do a pivot which I believe is what you want [image] How to make a monthly booking by rep BAQ ERP 10 You can do a pivot in the BAQ. It just has to be specific criteria, but since you are doing months, that would work. Pivots are ki…

JM707_Pivot.baq (35.9 KB) Here is a Pivot Table Example. I put this baq in a dashboard, added to the menu structure then added it to the context menu for PartNum. You can right click and get the shipping history for a manufactured part or the issued history for a purchased part since may company …

PartTran baq help

Kinetic ERP

tkoch (TK) November 2, 2023, 2:06am 6

There is a guide in Epicor help on how to do a pivot which I believe is what you want

Topic		Replies	Views
BAQ summing PartTran transactions by months Epicor ERP 10 baq	4	2512	February 3, 2022
BAQ Pivot - Help Needed Epicor ERP 10 baq	3	3625	April 14, 2021
Right tool to use for task? BAQ, Report, stored procedure? Epicor ERP 10	6	684	August 30, 2018
Return 0 instead of blank field in BAQ for PartTran Epicor ERP 10 baq	7	1114	June 20, 2023
BAQ Pivot - Help Epicor ERP 10 baq	5	1996	November 21, 2019

PartTran baq help

Related topics