I want to make my BAQ show the year of POHeader_OrderDate that matches GLBudgetHd_FiscalYear. How do I do this?

Kinetic ERP
,
1

I want to make my BAQ show the year of POHeader_OrderDate that matches GLBudgetHd_FiscalYear. How do I do this?

image
image1824×816 294 KB

2

You need a calculated field that gets the year from the order date:

OrderYear = Year(POHeader_OrderDate)

2 Likes
3

I’ve done it, but the data for 2026 isn’t showing because there’s no data available. I want to show the sections without data as well. What should I do?

image
image1327×676 89.2 KB

image
image1593×883 51.7 KB

image
image1838×725 57.4 KB