in our company we are using IFS9, there is a big issues in the integration between inventory part, accounting and manufacturing system.
does system have a report to display the missed information in each master data ?
example
part X doesn’t have accounting group which used in M1 and M53.
Best answer by Nagah.khaled
I solved this issue by using SQL statements .
-- accounting group in Posting control M53
select distinct ACCOUNTING_GROUP from INVENTORY_PART where contract='151A' and ACCOUNTING_GROUP not in (
select distinct CONTROL_TYPE2_VALUE from POSTING_CTRL_COMB_DETAIL where company='151' and POSTING_TYPE ='M53');
I solved this issue by using SQL statements .
-- accounting group in Posting control M53
select distinct ACCOUNTING_GROUP from INVENTORY_PART where contract='151A' and ACCOUNTING_GROUP not in (
select distinct CONTROL_TYPE2_VALUE from POSTING_CTRL_COMB_DETAIL where company='151' and POSTING_TYPE ='M53');
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
