inventory part number on general ledger

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