make relation with mainaccount

(0) Share

Report

Posted on by shelpaya

406

Hello Everybody,

Hello EveryBody how can i fetch all MainAccount on my report which have transaction and have'nt, on ax2009 i can do this from ledgertable&ledgertrans but on ax2012 i'm not able to do the same ...

Best Regards.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

Hi shelpaya,

Are you trying to create a new report or do you want to have an existing report showing all main accounts with/without balances?

So are you looking for a functional or technical answer?

Was this reply helpful? Yes No
shelpaya 406 on at

Like (0)

Report

Hi Ander,

i'm trying to create anew report which contain all mainaccount as mater table & ledgertrans as details account ..

Regards.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Shelpaya,

Why do you need to develop this? Have you tried using the main account and/or Trial list page form in GL.

From what you write above I suppose that those forms and sub-forms already provide what you try to develop.

Ludwig

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (2)

Report

Hi Shelpaya,

If you need to link the main accounts to the transactions you need these tables:

- MainAccount

- DimensionAttributeValueCombination (MainAccount = MainAccount.RecId)

- GeneralJournalAccountEntry (LedgerDimension = DimensionAttributeValueCombination.RecId)

- GeneralJournalEntry (RecId = GeneralJournalAccountEntry.GeneralJournalEntry)

Was this reply helpful? Yes No
shelpaya 406 on at

Like (0)

Report

thank you soooooooooo much Boss

Regards.

Was this reply helpful? Yes No
shelpaya 406 on at

Like (0)

Report

thanks for your replay Mr.Ludwig

...i use this query for integration with other system.

Regards.

Was this reply helpful? Yes No