Search code examples
sql-serverssisaxaptadynamics-ax-2012x++

Budget transaction line data by fiscal period

Is there a relation between BudgetTransactionLine table and FiscalCalendarPeriod table?

I want to get the FiscalCalendarPeriod.shortname of each BudgetTransactionLine .

Thank you

Solution

  • Here's a link to the ERD for AX 2012. It looks like you need to go from the BudgetHeader to the BudgetCycle, which connects to the FiscalCalendarPeriod.

    https://www.microsoft.com/dynamics/ax/erd/ax2012r2/

    All the default relationships for the Budgeting module:

    https://www.microsoft.com/dynamics/ax/erd/ax2012r2/Fky-Budget-ChildParents-11.htm