Tuesday, 1 March 2016

AP invoice accounting status not updated to ‘yes’ still it is showing ‘no’ for one invoice

Analysis: We are able to see JE for invoice when we checked view accounting from invoice screen, so the problem with only status
Solution: As it seems data corruption issues, we logged a ‘SR’ with oracle, they have provided data fix. The issue has been resolved.

2 Journals are not getting posted when auto post program run

Analysis: Journals are created after program completion that is at 11.00 pm
Solution: We asked user to wait until next run so that it will get posted

Not able to account payment document when I tried from action window of payment work bench

Analysis: Associated invoice not accounted hence payment not getting accounted
Solution: Account the invoice and then account payment

Invoice not getting validated

Analysis: Quantity Received hold is placed on invoice, customer using 3 way matching, but still receiving transaction not created in oracle for this PO, hence it could not be validated.
Solution: Require to update received qty for this PO. So this invoice will get validated

There are 10 assets under one corporate book in which user want to calculate depreciation for 7 assets


Solution: (disable) depreciation check box at asset workbench for which depreciation should not calculate.

Unable to add bank statement lines manually to imported bank statement

Solution: Enable allow adding lines imported statement in system parameters.

Monday, 29 February 2016

User not able to create invoice for supplier but PO already created for same supplier.

Analysis: While creating supplier user forget to enable payment purpose at address and site level
Solution: Payment purpose at address and site level.

Account Payable Supporting Issues in Oracle Appps

Issue 1: When we run create accounting program payment not getting accounted and error message showing cash clearing account not assigned
Solution: Assign cash clearing A/c to Bank Account and then we ask the user to run create accounting program so that it got accounted.

Issue 2: While running Payment Process Request (PPR) system has selected more than 200 Invoices but able to view the Invoices till
200 Invoice. 
Solution: Need to Increase limit for Profile Option: "FND: View Object Max Fetch Size".

Issue 3: India Creditor Trail Balance Report(Customized) showing wrong Functional balance(In INR).
Solution:  Incase of Exchange rate gain or Loss,  System is taking till date Values. Update Query to consider for only time range entered in Report Parameters.

Issue 4:  Unable to apply prepayment In case of Prepayment with TDS and Standard Invoice with GST & TDS.
Solution: In Prepayment, For GST Taxes Amount is created in Seperate Lines and TDS Tax not Attached. Now Standard Invoice for Tax amount (Miscellaneous Invoice Type) TDS not attached. Insure both Prepayment standard and Standard Invoice Deduct similar Amount of TDS. While application of Prepayment to Standard Invoice no Problem will appear.

Issue 4: While running Create Accouting the following Error appears.
Error: Error No: 95353 Subledger Accounting was unable to derive an accounting code combination using the account derivation rule Exchange Rate and Tax Exchange Rate Variances owned by Oracle. Please review the account derivation rule and make sure it derives a valid accounting flexfield combination for the source values passed for the transaction.  
Solution: Download and apply Patch 18997204:R12.AP.B

Saturday, 13 February 2016

Issue1: When we run create accounting program payment not getting accounted and error message showing cash clearing account not assigned
Solution: Assign cash clearing A/c to Bank Account and then we ask the user to run create accounting program so that it got accounted.


Issue2: User not able to create invoice for supplier but PO already created for same supplier.
Analysis: While creating supplier user forget to enable payment purpose at address and site level
Solution: Payment purpose at address and site level.


Issue3: Request for new tax code creation
Solution: Prepare a template to get details from use and get approval from the super user and define
Tax code


Issue4: Defining accounting segment values
Define Security rule
Defining CVR rules


Issue5: Unable to add bank statement lines manually to imported bank statement
Solution: Enable allow adding lines imported statement in system parameters.


Issue6: There are 10 assets under one corporate book in which user want to calculate depreciation for 7 assets

Solution: [  ] à(disable) depreciation check box at asset workbench for which depreciation should not calculate.

Issue7: Invoice not getting validated
Analysis: Quantity Received hold is placed on invoice, customer using 3 way matching, but still receiving transaction not created in oracle for this PO, hence it could not be validated.
Solution: Require to update received qty for this PO. So this invoice will get validated

Issue8: Not able to account payment document when I tried from action window of payment work bench
Analysis: Associated invoice not accounted hence payment not getting accounted
Solution: Account the invoice and then account payment
                                                                                                                   
Issue9: 2 Journals are not getting posted when auto post program run
Analysis: Journals are created after program completion that is at 11.00 pm
Solution: We asked user to wait until next run so that it will get posted

Issue10: AP invoice accounting status not updated to ‘yes’ still it is showing ‘no’ for one invoice
Analysis: We are able to see JE for invoice when we checked view accounting from invoice screen, so the problem with only status
Solution: As it seems data corruption issues, we logged a ‘SR’ with oracle, they have provided data fix. The issue has been resolved.

Issue11: Bank statement line status not updated to ‘Reconciled’, when we reconcile for payment document still it is showing ‘unreconciled’ status
Solution: - As it seems data corruption issues we logged a ‘SR’ with oracle, they have provided data fix, then the issue has been resolved. {All things in AP payment document and Bank Statements}

Issue12: There is difference between AP and GL when we reconcile GL balance is greater than AP trial balance report
Analysis: This difference is because of manual JE which is created by another user for adjustment purpose
Solution: We informed to user, so that it has been resolved after reversing JE

Issue13: There are 5 assets under one asset category. Now user is requesting to change asset cost account in asset category
Solution: 1. Create new category (New Asset Account)
    2. Perform Mass Reclassification

Issue14: Expenses report not getting imported into AP as a invoice (Setup Related issue)
Analysis:-Home address not defined in employee record in HR, hence invoice had not been created
Solution: Address has been created in employee record after taking necessary approvals

Issue15: Cash A/C not updated in receipt class when user modified Cash A/C in Bank A/C
Solution: End date old receipt method in receipt class hen create new receipt method


Issue16: User requesting separate payment numbers for manual payments
Solution: Enable allow restricted to manual payment check box at payment document so that it can be used for only manual payments

Friday, 5 February 2016

Accounting Entries for Assets Module in Oracle Apps

Depreciation Accounting:
Depreciation Expense A/c...........Dr.
              To Accumulated Depreciation A/c.............. Cr.

Asset addition Accounting:
In Payable module, At the time of Invoice the following accounting is generated
Asset Clearing A/c .........Dr.
               To Account Payable liability A/c................Cr.
In Asset module, At the time of addition of asset the following accounting is generated
Asset Cost A/c...................................Dr.
               To Asset Clearing A/c.................................Cr

Merger Accounting:
Asset Cost A/c .................................. Dr. 4000
                To Asset Clearing A/c.....................................Cr 3000
                To Asset Clearing A/c ....................................Cr 1000

Construction In Process(CIP) Addition Accounting
CIP Cost A/c.........................................Dr
                 To CIP Clearing A/c............................................Cr.

Capitalization Accounting: Transfer CIP asset to capitalize asset.
Asset Cost A/c.....................................Dr.
                To CIP Cost A/c …...................................Cr.

Amortized Accounting:
Depreciation Expense A/c...........Dr.
                To Accumulated Depreciation A/c.............. Cr.

Asset Transfer Accounting:
From Department transferred
Accumulated Depreciation A/c....................Dr.
                 To Asset Cost A/c...................................Cr
To department transferred
Asset Cost A/c.........................................Dr
Depreciation Expense A/c........................Dr
                   To Accumulated Depreciation A/c...................Cr

Reclassification accounting: When you reclassify an asset from office equipment to computers.
The accounting as follows.
Office Equipment:
Accumulated Depreciation A/c....................Dr.
                   To Asset Cost A/c...................................Cr
Computer Head
Asset Cost A/c.........................................Dr
Depreciation Expense A/c........................Dr
                    To Accumulated Depreciation A/c...................Cr.

Revaluation:
Positive Revaluation
Asset Cost A/c.............................Dr.
                   To Revaluation Reserve A/c........................Cr.
                   To Accumulated Depreciation A/c.............. Cr.
Negative Revaluation:
Revaluation Reserve A/c..................Dr
Accumulated Depreciation A/c.........Dr.
                   To Asset Cost A/c …...............................Cr.


Retirement:  

Accumulated Depreciation ..........Dr.                 (Dep Till Date)
Proceeds from Sale Asset Clearing A/c.....Dr.   ( Sale Value)
                    To Asset Cost.........................Cr    (Total Asset Cost)
                    To Profit/Loss..........................Cr   (P/L for Asset)