Following joins will helps to understand exact relation between iExpenses and AP invoices. 1 2 3 4 5 6 SELECT aerh.vouchno, aerh.report_header_id FROM ap_expense_report_headers_all aerh, ap_invoices_all ap WHERE aerh.expense_status_code = 'INVOICED' AND ap.invoice_id= aerh.vouchno; then […]
A) AutoInvoice requires a batch of type Imported. Batch sources define default information such as transaction type and automatic numbering. There are two types available: Manual and Imported. AutoInvoice requires a batch of type Imported. Autoinvoice […]
Use the following query to find AR Transaction Sequence By Source. SELECT * FROM all_sequences WHERE sequence_name LIKE ‘RA_TRX_NUMBER%’; Some Tips Example 1) Sequence RA_TRX_NUMBER_N1_81_S is a standard and manual source, this means N1 represents manual source. Example […]
How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]
Use following query to find the accounting package is being used 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 […]
Enterprise Resource Planning and Integrations BlogSpot 