Expense report in payables
Expense report in payables
I can't find the lines in UI after I created an expense report. But it can be got in database, and it can be imported. Why?
-
- Posts: 6
- Joined: Wed Oct 10, 2007 12:13 am
- Location: Saudi Arabia
If you mean that you cant see exp report details , run below queries on SQL*Plus or toad .
update ap_expense_reports_all
set org_id = null
where report_type = 'Seeded Personal Expense';
update ap_expense_report_params_all
set org_id = null
where expense_report_id in
(select expense_report_id from ap_expense_reports_all
where report_type = 'Seeded Personal Expense');
commit;
Good luck
update ap_expense_reports_all
set org_id = null
where report_type = 'Seeded Personal Expense';
update ap_expense_report_params_all
set org_id = null
where expense_report_id in
(select expense_report_id from ap_expense_reports_all
where report_type = 'Seeded Personal Expense');
commit;
Good luck
Who is online
Users browsing this forum: Ahrefs [Bot] and 4 guests