Hi All, Please can someone help me on this one? I’m trying to check the latest purchase date from PODetail and Rel I have used “max(column)” for both date and price fields but it’s still coming up with two dates this years and next years (2022) Any suggestions? Here is the BAQ Syntax and file. /…

You were getting duplicates because you were filtering in PORel and joining to PODtl. If you had more than one PORel it was going to get you duplicated. Below is a modified query that get’s you the last PORel that a part was purchased on. You can add whatever fields that you need to the subquery an…

Latest Purchase Price

Epicor ERP 10

Matt_Belshaw (Matt Belshaw) November 22, 2021, 1:34pm 7

I’ve used this post in the past:

Topic		Replies	Views
BAQ - Get recent date of part purchased and quantity Epicor ERP 10 e10 , baq	10	1253	May 2, 2024
BAQ - Subquery group Max/Min Epicor ERP 10 baq	14	3352	July 22, 2021
Last Quoted, Last Quote price, Last Quote number Epicor ERP 10 baq , aggregate	5	856	November 29, 2018
Last Purchased Date for a Part Epicor ERP 10 baq	9	4729	December 12, 2018
More MAX PartTran.TranDate problems in BAQ Kinetic ERP baq	18	1221	July 14, 2023

Latest Purchase Price

Related Topics