Payables Accounting Process Analysis of invoice entry
Payables Accounting Process Analysis of invoice entry
Problem: Invoices state accounted for by the Yes to No, then Yes the course of the demonstration
1. 20090224-1 invoice number generation, authentication / create accounting entries, the current Accounted = Yes;
2. Change the background DB, the Accounted = Yes into Accounted = No;
2.1) recorded in the deletion of sub-line information;
delete from ap_ae_lines_all where ae_header_id = 755034;
2.2) recorded in the deletion of sub-header information;
delete from ap_ae_headers_all where accounting_event_id = 818594;
2.3) to update the invoice distribution line marker;
Update ap_invoice_distributions_all
set posted_flag = 'N', ACCRUAL_POSTED_FLAG = 'N'
where invoice_id = 558505
Invoice Form at this time on the inquiry into Accounted = No;
3. Change the background DB, the Accounted = No into Accounted = Yes;
3.1) to change the tag ap_accounting_events_all table;
Update ap.ap_accounting_events_all
set event_status_code = 'CREATED'
where accounting_event_id = 818594;
3.2) to the Payables Accounting Processes;
Invoices at this time found Accounted = Yes
Related Posts of Payables Accounting Process Analysis of invoice entry
-
What's value for status_code of GL_Daily_Rates?
There are 3 possible status codes in this table: 'C', 'O', 'D' Status_code 'C' indicates that the daily rate is not used by any set of books that has average-balances enabled; Status_code 'O' indicates that the ...
-
The role of parameters local_listener
Listener log file e: oracleproduct10.2.0db_1networkloglistener.log Summary of monitoring endpoint ... (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = xys) (PORT = 1522))) Service Summary .. Service "orcl" contains two routines. Routine & ...
-
Invoice has been fully paid and still be able to choose the payment amount of zero
Background: Recent users, some of the invoices have been fully paid and still be able to choose zero-sum payment, currently we do not have this feature turned on (enable the Allow Zero Payments option in the Payables Options region of the Bank Accoun ...
-
How to datafix AR, REC is not equal to REV plus TAX
- ================================================ ============================================= - Trx_Number | | Customer_trx_id | Payment_Schedule_id | Receivable_application_id | Type | - ================================================ ========== ...
-
summary of the usage of oracle hints
1. / * + ALL_ROWS * / Show that the choice to block the optimization method based on cost and get the best throughput to minimize consumption of resources. For example: SELECT / * + ALL + _ROWS * / EMP_NO, EMP_NAM, DAT_IN FROM BSEMPMS WHERE EMP_NO = ...
-
SQL Optimization of the process of common usage of Oracle HINT
SQL statement in the optimization process, we often use hint, is to sum up the process in the SQL optimization Oracle HINT common usage: 1. / * + ALL_ROWS * / Show that the choice to block the optimization method based on cost and get the best throug ...
-
SQL optimization process in common use Oracle HINT
SQL statement in the optimization process, we often use hint, is to sum up the process in the SQL optimization Oracle HINT common usage: 1. / * + ALL_ROWS * / Show that the choice to block the optimization method based on cost and get the best throug ...
-
The second part (15) practice to create table space-level replication environment (1) to initialize the environment
DBMS_STREAMS_ADM provide table space to create three-level process of replication environment: MAINTAIN_SIMPLE_TTS: a single sheet of copy space MAINTAIN_TTS: more than a copy of table space PRE_INSTANTIATION_SETUP and POST_INSTANTIATION_SETUP: more ...
-
Oracle's role in the password file and notes
Did not start in the database before the database built-users are unable to verify the identity of the database Password file stored sysdba / sysoper user's user name and password to allow users to password file authentication, in the database di ...
Leave a Reply