Dynamics Community Forum Thread Details

Management Report - Adding STAT Ledger (Actual) and Budget

Hi Everyone,

I am new to this community so please bare with me if I do not use the correct terminology to define things.

I have created a management report that uses a Stat Ledger, Actual and Budget numbers.

On the report, it is pulling in the Actual numbers for the month which come from a Stat Ledger (monthly journal entry) but not the budget numbers. The link for the Financial Document is the budget number but I do not know what to use for the Row Modifier. If I use "Book Code: Stats", the stat ledger is pulled in correctly but then my budget number is not correct and pulls the stats number. So the report shows the actual number and the budget number as the same when they should be different.

Row Code Description Row Modifier Link to FS

83 1st Lien Loan Balance Account Modifier=[/C] +Book Code=[STATS] +Account = [LO-1st UPB]

84 1st Lien Loans +Book Code=[STATS] +Account = [LOANS]
85 2nd Lien Loan Balance Account Modifier=[/C] +Book Code=[STATS] +Account = [LO-2nd UPB]
86 2nd Lien Loan +Book Code=[STATS] +Account = [LOANS-2]

(Number Example)

Actual Budget

1st Lien Loan Balance	18,888,518	9825.3%	18,888,518
1st Lien Loans	9	0.0%	9
2nd Lien Loan Balance	11,879,748	6179.5%	11,879,748
2nd Lien Loan	7	0.0%	7

So from the report table above, the actual is correct but the budget for 1st Lien should be 9,343, 471 and the budget for 2nd lien should be 7,672,655. The budget numbers were entered under [LO-2nd UPB and LO UPB].

Please let me know how to correct this. I've tried so many combinations.

Thanks

Quick Links