Umair,
We have no option to capture the status of the invoice, other than AP_INVOICE_V. To access the same table you should have 'owner APPS'
begin
fnd_client_info.set_org_context('org_id');
end;
Search found 20 matches
- Fri Feb 01, 2008 12:09 pm
- Forum: Reports (Only Oracle Apps Reports)
- Topic: AP AP_INVOICES_ALL TABLE
- Replies: 2
- Views: 4761
- Mon Jan 28, 2008 12:32 pm
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Payable options >> Matching
- Replies: 4
- Views: 3278
Venkatesh, Option 'Allow Final Matching' will allows you to check the final match check box in Payable distributions while matching a PO with an invoice. By selecting the final match check box in invoice the Po will be closed and will not allow the other invoices to match with this PO. Allow distrib...
- Mon Jan 28, 2008 12:17 pm
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Procure to pay accounting event
- Replies: 6
- Views: 3119
Venkatesh, As far as Purchasing options are concerned We can accrue Expense Items either at period end or at Receipt as per the client requirement. But we can acccrue Inventory items at Receipt only. Please go through the entries in my last update (Entries given for accrue expense items at both peri...
- Fri Aug 03, 2007 12:36 pm
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Procure to pay accounting event
- Replies: 6
- Views: 3119
Karthik, Entries are as follows: Inventory Item upon Receipt : Debit - Receiving inventory account (inspection) Credit - Inventory A/P Accrual Upon Delivery: Debit : Material account for inventory org. receiving goods Credit: Receiving inventory account Debit/credit : Purchase price variance Upon In...
- Fri Aug 03, 2007 11:47 am
- Forum: Purchasing & Inventory
- Topic: purchasing need by date
- Replies: 2
- Views: 2879
Dear Karthik, I hope you are using I-procurement, You can change the need by date in the Purchase Order, But if the Purchase order is autocreated from Requisition, you will be receiving the mails to receive the goods based on the old date that was given in the Requisition but not the amended date in...