Hi @SAAKAGUILAR 

MPCCOM_ACCOUNTING_ID is stored on GEN_LED_VOUCHER_ROW. You can join with MPCCOM_ACCOUNTING or INVENTORY_TRANSACTION_HIST views to achieve what you want

I created a sample quick report for you. Parameters are COMPANY, ACCOUNTING_YEAR and ACCOUNTING_PERIOD

You can extend the report based on your requirements

SELECT X.COMPANY,
       X.ACCOUNTING_YEAR,
       X.VOUCHER_TYPE,
       X.VOUCHER_NO,
       X.ACCOUNT,
       X.DEBET_AMOUNT,
       X.CREDIT_AMOUNT,
       Y.CONTRACT,
       Y.PART_NO,
       IFSAPP.INVENTORY_PART_API.GET_DESCRIPTION(Y.CONTRACT,Y.PART_NO) DESCRIPTION
  FROM IFSAPP.GEN_LED_VOUCHER_ROW X, IFSAPP.INVENTORY_TRANSACTION_HIST Y 
 WHERE X.COMPANY = '&COMPANY'
   AND X.ACCOUNTING_YEAR = '&ACCOUNTING_YEAR'
   AND X.ACCOUNTING_PERIOD = '&ACCOUNTING_PERIOD'
AND X.MPCCOM_ACCOUNTING_ID= Y.ACCOUNTING_ID

Hope this helps

Just one more thing,

The voucher must not exist in summarize voucher window. This may cause lose of mpccom_accounting_id during GL update routine

Regards

Hi, 

The GL - Balance analysis / similar does not have a configuration that can bring in that type of detail - inventory part. Like @gumabs wrote - a very common process is to create a quick report, and was nice to add that to this posting.   

The idea is you could use this as a quick report - even add that to your IFS navigator. It would essentially run similar to the voucher rows analysis screen.  

Best regards