Custom Table that References CustTable

Finance and Operations/AX Developer Forum
1

I am new to development within AX 2012. I am working on creating a custom table that will store user-defined fields. This information is tied to customers, so it relates to the CustTable table. I have the relation set-up and everything works fine if I enter the information in AOT. However, when adding the information on the customer form it is not grabbing the CustAccount. It only writes the value of the user-defined field. I was wondering where I need to write the code to insert the CustAccount number. Is this done on the form?

Thanks.

2

Bump.

3

Hi Neil,

u want custaccountnumber which are already present in AOT…

then simple give relation to your table and custtable…NORMAL relation will work as lookup…

4

I have that field in my custom table. The problem is that it does not grab the customer’s account number when inserting a value. So, the customer account field is blank and the user defined field gets populated. Where do I write the code to grab the customer’s account number?

5

Hi Neil,

i think u made a mistake in the given ralations…without any relations fields will take userdefined data…

if u want to insert data through code in forms use form->datasource->methods->write method…

6

I have all of the relations set up. It just won’t write the customerAccount when I add the data through the form. If I go into the AOT and specify the customerAccount then the data correctly shows up in the form. I do not want to have to write a method to grab the customerAccount, so I was just wondering if this was required.

7

I think my problem was that I was doing an outer join for the Link Type when it should have been Active.