Report Designer Tip: Filtering by Status Codes in Build Schema

Hey Acumatica community,

I wanted to share a quick but important tip for anyone customizing reports using Report Designer and struggling with filters — especially when filtering by Order Status fields like POOrder.OrderStatus.

🎯 Problem:

I tried to filter my Purchase Order report to show only Open orders by adding this filter in Build Schema → Filters:

but the report didn’t return anything. It turns out, Acumatica uses internal code values, not the visible labels you see on screen!

✅ Solution:

To filter by Open POs, you need to use the correct code:

🔍 How to Find Status Codes in General

1. Inspect Element in Acumatica. and check the status field. then look for dropdown values. 

Hope this helps someone avoid a few hours of confusion like I had 😅

Cheers!