Dear Community,
We have faced the following issue trying to compare the budget vs actual figures. (Release 2020.1)
A Custom Segment PRODUCT has been created and applied to Record types : Journals and Budget Imports.
The Budget has been uploaded using the custom Segment “Product” as a dimension on the revenue accounts.
Rev Rec Journal entry has been created automatically from Advanced Revenue recognition. Custom Segment “Product” has been processed on the Journal line level on the Revenue GL accounts.
The Budget vs Actual report has been customized by adding the Custom Segment “Product” as a Column from field area Budget and field area Financials in order to compare budget and financial balances.
The amounts of the actuals and the budget referring to one and the same product are on separate lines (Pic. 7)
The Custom Segment Product field is available in “Budget” and in “Financial” field's areas, but it is not available in “Budget and Financial” field area (Pic. 8)
Could you please, advice is there a way to enable the custom segment on “Budget and Financial” field on the Budget vs. Actual report or there is another approach in order to have the comparison on one line on the report?
Thanks a lot in advance,
Kind Regards,
Iveta