[AP] Why "View journal entries" display nothing?

近日user對於某張被cancel 的 Invoice於Create Accounting後，View journal entries但無任何Subledger Journal Entry 的detail資料顯示感到疑惑。

依以下步驟檢示設定，並配合Oracle Support的解釋，就能了解為何 "View journal entries"看不到journal lines 的資料。

a)      Subledger Accounting Options
GL Responsibility->Setup->Accounting Setup Manager->Accounting Setups
1) Choose the ledger
2) Click on "Update Accounting Options"
3) Scroll to “Subledger Accounting Options” in the Primary Ledger section
4) Click on Update Icon
5) Click on “Update Accounting Options” Icon against the Application to be setup(Example: Payables)
6) Field: General Ledger Journal Entry Summarization
Ans:General Ledger Journal Entry Summarization= Group by GL Date

b)      Journal Line Types
Payables Responsibility->Setup->Accounting Setups-> Subledger Accounting Setup->Accounting Methods Builder->Journal Entry Setups-> Journal Line Types
1) Application to be setup(Example: Payables)
2) Field: Transfer to GL
Ans:Transfer to GL= ‘Summary’

c)      Profile : "SLA: Show Zero Amount Journal Lines"
System administrator Responsibility->Profile->System
1) Enter Application : Payables
2) Responsibility: Your responsibility(Example: Payables)
3) Profile : "SLA: Show Zero Amount Journal Lines"
4) Click Find
Ans:SLA: Show Zero Amount Journal Lines=> Site level = ‘No’

Oracle Support's Explanation & Solutions

1. "SLA: Show Zero Amount Journal Lines" is control if you can view the journal lines with 0 amount.

Here in your case , you set it at Site level to No, which means once the journal lines with 0 amount, you cannot view it in page.

2.You also has below setups:
General Ledger Journal Entry Summarization :Group by GL Date
Transfer to GL : Summary

Which means the journal lines transferred will be in summary mode which means , your journal lines will be summarized together grouped by GL Date.

So in your case , as the invoice lines has been discarded, and the GL date is all the same, so when you create accounting, the journal lines summarized by the GL date will has the total amount with 0.
And as your 1 setup, the 0 amount journal line will not be displayed.

That is why you can not view the journal lines for this invoice.
===
So for your confirmation, you can set the "SLA: Show Zero Amount Journal Lines" to Yes and see if you can view journal with 0 amount.
Or transfer to GL in details.