Inserted record not displayed in form

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi All,

"GeneralJournalEntry" table**(Table-1)** is the header table for all the journal.

I’m trying to insert a record in “GeneralJournalAccountEntry” table**(Table-2)** which will have all the voucher transactions for a particular journal.

The relation between Table 1 and Table 2 is

GeneralJournalEntry.Recid == GeneralJournalAccountEntry.GeneralJournalEntry

I’m able to insert a row in Table 2 with the corresponding Table 1 RecId as Table 2 - GeneralJournalEntry.

But when i open the form to check the newly inserted record,i don’t find the record.But the new record is present in the table.

Please Help.

Thanks and Regards,

Rajee

2

Hi,

Check form datasource join source property, design Grid properties and GeneralJournalAccountEntry.GeneralJournalEntry has data relevant to GeneralJournalEntry.recId.

3

Hi Kuppusamy,

The form which displays the voucher transactions is “LedgerTransVoucher”. I checked the fom DS join property ,for “GeneralJournalAccountEntry” the join source and type are ‘GeneralJournalEntry and Inner join’ respectively.

And when i try to sort the GeneralJournalAccountEntry table with the field “GeneralJournalEntry”,i get the inserted recored listed.

Do i need to check anything other than this?

4

Verify all the inner joined tables and look at the ranges that being added in the form.

5

Thanks Kranthi and Kuppusamy!

Your suggestions helped me.

The point which i had been missing is the 'LedgerDimension" Value of the “GeneralJournalAccountEntry” table,with this value it creates a record in the “DimensionAttributeValueCombination” table which has the ‘Account no’,which intern has a record created for the same in the “MainAccount” Table.

Missing the LedgerDimension will not create related records in DimensionAttributeValueCombination and MainAccount table for that particular entry and thus it will not be displayed in the form.

Regards,

Rajee

6

Thanks Kranthi and Kuppusamy!

Your suggestions helped me.

The point which i had been missing is the 'LedgerDimension" Value of the “GeneralJournalAccountEntry” table,with this value it creates a record in the “DimensionAttributeValueCombination” table which has the ‘Account no’,which intern has a record created for the same in the “MainAccount” Table.

Missing the LedgerDimension will not create related records in DimensionAttributeValueCombination and MainAccount table for that particular entry and thus it will not be displayed in the form.

Regards,

Rajee