Finance | Project Operations, Human Resources, ...

Why is changecompany() not working?

(0) Share

Report

Posted on by Shooowtek

845

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)

Sort by

Suggested answer

Layan Jwei 8,282 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

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,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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