To filter G/L Account table Based on Dimension Project Code

Hello, I want to produce a G/L report with budget amount and actual amount which can give the amount based on the project code in dimension value. I figured out in my G/L Account table does not segregate the amount based on project code. I've been thinking perhaps I need to link the G/L Account table with my Dimension Value table. But there is no data linked between those tables. In business central I can view the budget and actual amount extracted from G/L in analysis view and do filtering based on Project filter. How do I do that also in Jet? I want to customize the report further. Thank you.

1 comment

Please sign in to leave a comment.