Skip to main content

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.

 

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');
 

 


Reply