Hi,

I have to find out the data whose Adjustments made in PA which are NOT interfaced to AP.
These adjustments are Supplier Invoice Costing adjustments made in PA.

Please help me to find the table and column in PA that has to be marked when those data got transferred to AP.

Thanks,
Nishank Jain

Hi Nishank,

You need to look into pa_expenditure_items_all(Ei) and pa_cost_distribution_lines_all tables(Cdl). In Ei table, the system_linkage_function will be ‘VI’ and
in Cdl you need to look for transfer_status_code = ‘A’ which means it has been transferred to AP.

Thanks,
Sathish
http://www.projectsaccounting.com