Good morning Epicor Community! I wanted to see if anyone has some ideas for creating a standalone calendar to be used in BAQ’s. The purpose would be to have this calendar as a point of reference. Some tables used in my queries do not have daily activity, and creating running totals based off of ev…

I have an idea. It uses the ZDataField table as a source for essentially infinite records. (Over 100,000 anyway). Check this out, super simple: select (ROW_NUMBER() OVER(ORDER BY ZDataField.SysRevID ASC)) as [Calculated_Row_Num], (dateadd(day, Row_Num, '1/1/2000')) as [Calculated_Date] from Ice.…

Running Calendar in BAQ

Epicor ERP 10

klincecum (Kevin Lincecum) June 15, 2023, 4:02pm 7

Future reference:

1 Like

Topic		Replies	Views
ClockInDate Epicor ERP 10 baq , clock-in	24	1039	September 25, 2023
BAQ Running Total Epicor ERP 10	12	9152	December 19, 2018
Making SQL code into BAQ Epicor ERP 10 e10 , epicor , baq	2	332	December 8, 2023
BAQ Starting with a Table of Dates Kinetic ERP e10 , baq	2	278	April 2, 2024
BAQ using Shop Load Epicor ERP 10 epicor	23	5086	June 6, 2023

Running Calendar in BAQ

Related Topics