The “India – Accrual Reconciliation Load Run” Program Is Loading Third-Party Tax Amounts Into the CST_AP_PO_RECONCILIATION Table for the Purchase Order(PO) Receipts Leading to Reconciliation Issues.
(Doc ID 3004429.1)
Last updated on FEBRUARY 20, 2024
Applies to:
Oracle Financials for India - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
The "India - Accrual Reconciliation Load Run" program is populating third-party tax amounts in the CST_AP_PO_RECONCILIATION table for the PO receipts.
The program should not populate the third-party tax amount in the CST_AP_PO_RECONCILIATION table as it will lead to accrual reconciliation issues between Receipt and Invoice.
The issue can be reproduced at will with the following steps:
1. Navigate to India Local Purchasing responsibility.
2. Purchase Orders-> Purchase Orders.
3. Enter a new PO, and click on Tools-> India Tax Details, apply normal and third-party taxes on it.
4. Approve the PO.
5. Go to Receiving-> Receipts.
6. Enter a new receipt against the purchase order.
7. Click on Tools-> India Tax Details, and confirm taxes.
8. Save the receipt. The system generates Third-party invoices for the third-party taxes applied on receipt.
9. Submit the Create Accounting- Receiving program to generate accounting entries for the Receive event.
10. Navigate to the India Local Payables responsibility.
11. Invoices-> Entry-> Invoices.
12. Enter a new invoice and match it with the receipt.
13. Validate the invoice and run create Accounting for it.
14. Submit the "India - Accrual Reconciliation Load Run" program and check data in the CST_AP_PO_RECONCILIATION table.
15. The Third party tax amount is populated for the PO receipt. However, for the standard invoice the third party tax amount is not populate because a separate invoice is already generated for the third party tax amount.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |