Event Handler Does Not Add Record In Other Table

(0) Share

Report

Posted on by haroonattari

2,346

Hi Everyone

I have a requirement from customer to assign specific address book to all newly created customers. To achieve this, I added a post event on Insert method and am trying to assign the address book in Event handler class method.

public static void postInsertRecordHandler(XppPrePostArgs _args)
{
    CustTable                   custTable;
    CustTableEventHandler       custTableEventHandler;

    custTable = _args.getThis();

    custTableEventHandler = new CustTableEventHandler(custTable);

    custTableEventHandler.assignAddressBook();
}


public void assignAddressBook()
{
    container   addressBooks = ["ALL"];

    DirAddressBookParty::createPartyRelationsByName(custTable.Party, addressBooks);

    info(strFmt('assignAddressBook() - All addressbook assigned to %1-%2-%3-%4', custTable.AccountNum, custTable.Party, custTable.dataAreaId, custTable.RecId));
}

The code is running successfully but it is not inserting record in DirAddressbookParty table.

Will appreciate if anyone of you can let me know if I am missing anything for achieving the requirement.

Thanks in advance.

Haroon

I have the same question (0)

All responses (24)

Answers (2)

nmaenpaa 101,162 Moderator on at

Like (0)

Report

Let's first separate your problem in two parts.

1) When customer is inserted, run your event handler code

2) Assign address books to customer in code

It seems to me that part 1 is working.

But part 2 is not working as expected.

Did you debug your code? Do you have some value in CustTable.Party in line 18 of the code that you shared?

Do you have address book in your system, that have name "ALL"?

Was this reply helpful? Yes No
haroonattari 2,346 on at

Like (0)

Report

Hi Nikolas

I have an address book with id 'ALL' in system and also the infolog in assignAddressBook method is showing value for custTable.Party field.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

Did you debug the DirAddressBookParty::createPartyRelationsByName method? If not, could you do that and let us know where it goes wrong?

Was this reply helpful? Yes No
haroonattari 2,346 on at

Like (0)

Report
I used this method earlier in a job to assign 'ALL' address book to all customer and it went well. I also tried creating record directly in DirAddressbookParty using following code but that did not work either.

public void assignAddressBook() { DirAddressBook dirAddressBook; DirAddressBookParty dirAddressBookParty; DirAddressBookName addressBookName; addressBookName = 'ALL'; dirAddressBook = DirAddressBook::find(addressBookName); if (custTable.RecId && dirAddressBook.RecId) { dirAddressBookParty.clear(); dirAddressBookParty.initValue(); dirAddressBookParty.AddressBook = dirAddressBook.RecId; dirAddressBookParty.Party = custTable.Party; dirAddressBookParty.insert(); info(strFmt('assignAddressBookNew() - All addressbook assigned to %1-%2-%3-%4-%5', custTable.AccountNum, custTable.Party, custTable.dataAreaId, custTable.RecId, dirAddressBookParty.RecId)); } }

Surprisingly the infolog in this method is also showing RecId for DirAddressbookParty table but when I am querying the same from SQL it is not available there.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,162 Moderator on at

Like (0)

Report

If you see RecId for DirAddressbookParty table in the infolog, can you find the same record with Table browser?

SQL Server data is not always 100% corresponding with the application because of AOS caching and other things.

Anyway, you should develop code that works reliably for assigning an address book for the customer. Once it's working, call it from your event handler code and you're done.

Was this reply helpful? Yes No
haroonattari 2,346 on at

Like (0)

Report

The code I have shared is from the job which I developed to assign the addressbook to whole cutomer list. Also I tried looking for the record from table browser but no success.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

The code is not from a job, it's from a method.

Is your code running in a transaction? If yes, perhaps something in the process fails after the infolog is printed, rolling back the transaction. This would explain why you don't see the value in table browser or SQL.

But, if you run the code in a job, the record should definetely be visible in table browser after the code is executed.

Was this reply helpful? Yes No
haroonattari 2,346 on at

Like (0)

Report
I mean the code I have copied from the job which was running successfully. Also I tried running code in CustTableEventHandler class in a job and it also assigned the address book successfully.

static void HAR_Update_AddressBook(Args _args) { CustTable custTable; CustTableEventHandler custTableEventHandler; custTable = CustTable::find(CustNum); custTableEventHandler = new CustTableEventHandler(custTable); custTableEventHandler.assignAddressBookNew(); //custTableEventHandler.createCustomTableRecord(); }

To further debug, I tried creating a record in custom table and the record was successfully created.

Was this reply helpful? Yes No
nmaenpaa 101,162 Moderator on at

Like (0)

Report

So everything works now?

Was this reply helpful? Yes No
haroonattari 2,346 on at

Like (0)

Report

Not for DirAddressbookParty table :(

Was this reply helpful? Yes No

Join the conversation

Community site session details

Event Handler Does Not Add Record In Other Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Event Handler Does Not Add Record In Other Table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates