Kedalene · New Creation · Silver Medal

Hi All Can they copy AP Invoice to Credit Note in Apr to reverse 1.36 with the wrong rate and post a new AP Invoice at 1.33 before apply payment to recognise realised exchange loss? Kedalene Chong

Hi Katerina I am not able to simulate using the Bank Reconciliation (not Match Bank Data) to reconcile then change amount. It is too difficult to simulate as I dont have imported Bank Statement Balance in my Match Bank Data in Diley Demo Database. Kedalene Chong

Hi Katerina Thanks for the Suite Answers! SA65780 mentioned If you change the amount of a previously reconciled transaction, the transaction becomes unreconciled again. Open the correct statement period for the transaction and reconcile the transaction again. Note If you change the account of the transaction, the…

Hi Katerina That means can only reimport Bank Statement with the correct As Of Date? It is possible to Cancel previous Bank Reconciliation, reimport Bank Statement and re match with posted GL transactions? Kedalene Chong

Hi Katerina Finally the Case is closed after applying your workaround solution except without any need of manual Journal Entry! Kedalene Chong

Hi Katerina This Suite Answer works in our client's live data and cleared the reconciliation difference. But we still need to manually exclude them in the Match Bank Data section. Is the root cause really caused by editing these posted bank transactions?

Hi Actually I mean the Applied Invoice number not the Prepayment Document Number.

Hi Katerina It doesnt seems correct as no Applied Invoice Number information details. Thanks for your attempt anyway.

Hi Katerina After re looking at the Reconciliation Details, I noticed there is Difference $30000 equal to the sum of Unreconciled Deposits and Payments in Apr 2022 resulting a Difference between Reconcile Statement Balance and Total as of 30 Apr 2022 (GL) and subsequent months. There is no Reconciliation Difference in…

Hi Katerina Thank you very much for the explanation! We will try out. Kedalene Chong

Hi Micah Is there any Suite Answer Number that explained Approved By is not showing in General Ledger Report even after added Approved By in the Result Column. Kedalene

Hi Katerina I have just created a new Idea using 146210A. Hope it will be published for votings and many Users are having such requests. Kedalene Chong

Hi Katerina Is there currently a separate enhancement improvement suggestion in SuiteIdeas about adding Approved By in General Ledger/Transaction Detail Report or already inclusive in this Idea 146210? Kedalene Chong

Hi Katerina So this is the same system limitation Approved By cannot be displayed in General Ledger and Transaction Detail too? Kedalene

Hi Katerina There is no reconciliaton difference yet there is a one cent higher difference in Bank Balance with General Ledger. Bank Statement plus unpresented deposits less unpresented checks lesser than Bank Balance in GL by 1 cent. Kedalene Chong

Hi Niks Please see attached screenshots. Kedalene Chong

Hi Ely How to match the average location cost before posting Inventory Decrease Adjustment to achieve Zero Value. We are not able to edit the Estimated Cost for decrease Quantity? Kedalene

Hi Katerina I believe its a typo error as it should be Sep 2022. Is there any other workaround solution? Is it possible they input the same Bank Balance as of Date in the next Bank Reconciliation?

Hi Ely Thanks for your explanation. So this Current Value is not matching with General Ledger which supposed to contain actual historical FIFO cost that is not necessary same as Location Average Cost x total Quantity on hand? How can SAP User edit the Estimated Unit Cost before posting Inventory Adjustment to prevent…

Hi Niks Its not the same. I am exploring this thread the basic functions in Diley Demo Database.

Hi Brian Please guide me if you know how to get the best Saved Search result to show Vendor Prepayment, Applied, partially Applied and Unapplied details and related applied AP Invoices? Kedalene Chong

Hi Katerina This is the modified Vendor Prepayment List Saved Search Results Column.

Hi Dominca Hi AP Payment History not showing unapplied Vendor Prepayment Amount? Kedalene

Hi All Can any expert advise me whether can I try this workaround solution from SuiteAnswer 104049 in their Live Database as our Client has no Sandbox testing environment? Kedalene

Hi Katerina Do you think we can try this workaround solution from SuiteAnswer 104049 in their Live Database? Bank Reconciliation Report shows Previously Reconciled Transaction as Unreconciled Last Updated 01/22/2023 Reading Time 2 mins Answer ID 104049 Applies To Product: 2022.1 Scenario Previously reconciled transactions…

Hi Ivy Thanks for your workaround solution. How do I see the breakdown of Open FIFO purchase transaction number history? Kedalene Chong

Hi Ivy Is it possible to do Inventory Adjustment on total Value without affecting Quantity? Kedalene Chong

Hi Katerina I can't find Deleted Record Search? Kedalene

Hi All I managed to find Period Closing Management Permission, Question Answered!

Hi Patrick/William Thanks Got it! So there is no need to follow Suite Answer 35106 from scratch! I can use the standard P&L Report, click customise to get the extra Column Filter Field to select Subsidiary for showing multiple Subsidiaries Columns display in P&L and Balance Sheet except its only available in Summary View!