Finance | Project Operations, Human Resources, ...

Why is changecompany() not working?

(0) Share

Report

Posted on by Shooowtek

843

Hello,

In the class where I make the select in CustTable, changecompany() is not working. It stays in the current location all the time.
Can anyone suggest how to apply this correctly?

[...]

changecompany(_company)
{
select firstOnly custTableLocal
where custTableLocal.AccountNum== _customer;

//some logic
}

[...]

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shooowtek,

May I ask how did you know that it is not working?

Did you try and debug? and see what is the value of _company and custTable.DataAreaId?

what if the same custAccount exists in different legal entities and you thought it's the same?

However, if you debugged and found that dataArea values are different then maybe declare CustTable inside changeCompany.

Thanks,
Layan Jweihan

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi, You didn't provided the complete code. However, try clearing custTableLocal buffer before select statement.

http://www.theaxapta.com/2012/12/change-company-from-current-company-in.html

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

The problem is with the table buffer. When you select the table it will carry a buffer. The change company doesn't clear the buffer and will find a value from the previous company which will obviously return empty buffer. So to get the exact buffer either you can clear the table buffer like Mohit suggested or declare the table variable inside the change company.

I mean,

changeCompany('compName')

{

Table table;

select table;

}

Was this reply helpful? Yes No

Join the conversation

Community site session details

Why is changecompany() not working?

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

Why is changecompany() not working?

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