1 Reply Latest reply on Oct 5, 2016 8:47 AM by raghu_ram

    In Purchase Requisitions - accrual account & charge account is not getting generated for Project related

    shijij

      We have upgraded from 12.0.4 to 12.0.6 after upgrade in Purchase requisitions for Destination Type - "EXPENSE" and we specify the project and task information automatically the charge account will get populated.  But after upgrade it is not getting populated

        • 1. Re: In Purchase Requisitions - accrual account & charge account is not getting generated for Project related
          raghu_ram

          Hi shijij,

           

          Run this query by passing item_name and organization_id and check if it returns expense account from msib definition table

           

          select msib.segment1,

          msib.description,

          msib.expense_account,

          msib.inventory_item_id,

          msib.organization_id 

          from mtl_system_items_b msib,

          gl_code_combinations gcc,

          pa_expenditure_items_all peia

          where 1=1

          msib.inventory_item_id = peia.expenditure_item_id

          and rtrim(ltrim(msib.expense_account)) = rtrim(ltrim(gcc.code_combination_id))

          and msib.segment1 = <'item_name'> --pass item name here

          and msib.organization_id = <organization_id> -- pass organization_id here

           

           

          Regards

          raghu