Kedalene · New Creation · Silver Medal

Hi Patrick I managed to see the Historical Conso Rate for Jan 2024. So the Elimination is to post the difference $72.5 to a Cumulative Translation Adjustment Elimination G/L Account of Elimination Subsidiary? Where can I find this setup of pre defined Cumulative Translation Adjustment Elimination G/L Account Number?

Hi Patrick There is no Advanced Revenue option in our client's Revenue Accounting.

Hi Patrick I tested a simple Non AR AP Control Investment BS Eliminating G/L account (General Rate Type Historical) from Subsidiary MYR to Subsidiary USD. However, I dont understand how my initial Journal USD 100 x 1.3 MYR 100 become USD 27.5 in the Conso Report? Please guide me how to understand the system calculation…

Hi Patrick How to check if our client is using Advanced Revenue Management or Legacy Revenue Management? Kedalene Chong

Hi Patrick Please help explain the meaning of this statement in Suite Answer 78837? How to remove recognized revenue from posted Invoice? The only way to delete this is to Edit the Invoice and change the Exchange Rate to the Exchange Rate in the payment. Since there is already a recognized Revenue, the Invoice cannot be…

Hi Patrick This Saved Search result will be same as the Dataset Analytics you shared earlier? Kedalene Chong

Hi Patrick We find editing the Rounding Revaluation JE Date from Original Invoice Date to Payment Date is better with no obvious accounting impact on Subledger Aging and General Ledger. Kedalene Chong

Hi Patrick Thanks for your patience. I not sure why I cant see from their posted JE From and To Subsidiaries or any Ticked in Eliminate option in JE rows. Please share the steps and relevant Suite Answers the correct way to post InterCompany Journal Entries and does it auto create eliminating journal entries after run…

Hi Patrick So the recommended solution in Suite Answer 78837 is to edit Invoice exchange rate to follow payment rate? This must be done when Invoice Date and month is not Closed right? Kedalene Chong

Hi Patrick Thanks for the tip! I will find time to try. Kedalene Chong

Hi All Please help advise any better permanent solution or workaround solution? Does increasing this Foreign Currency Precision Decimals help?

Hi Patrick Please help confirm it is not possible to exclude Adjustment Period Postings in Trial Balance and Balance sheet which do not exclude Non Audit Adjustments when Adjustment Period is selected. Your alternative solution to exclude Adjustment Period only works for Income Statement and General Ledger? Kedalene Chong

Hi Patrick Please help conform it is not possible to post transaction to a Subsidiary’s Adjustment Period and not to reflect in Consolidating Group Level Financial Report. I found your alternative Solution using Custom Income Statement Report. The alternate solutions are as follows: 1. Customize the income statement…

Hi Patrick The Date of Adjustment Period is 31 Dec 2023. Our Client is asking is it possible to post transactions to Adjustment Period to only Subsidiary level but not to be captured in Group Company level. Kedalene Chong

Hi Veronica I find out AP Invoice Class will show in Amortization Journal Entry non Accounts Payable Double entries but not in Revaluation Journal Entry as Payable Control Side has no Class. But AP Invoice Class cannot be edited in System generated Amortization Journal Entry and Payable Revaluation Journal Entry. Kedalene…

Hi Patrick We discovered there is System generated revaluation posted to Rounding exchange gain loss account local currency $0.02 in GL upon payment, probably due to sum of Debited Amounts converted from Foreign to Local Currency in 2 Decimals differs from lump Sum AP Invoice foreign Currency amount x exchange rate. Please…

Hi All Where is the Currency rounding decimals setup that can prevent such system generated rounding differences? Kedalene Chong

Hi All We noticed there was an internal system generated rounding adjustment to Vendor Bill posted in General Ledger for a minor backend rounding difference in the sum of Amounts Debited to Expenses converted from HKD to SGD resulting the AP Invoice amount in SGD being recalculated to 4,865.19 in Accounts Payable Aging…

Hi All AP Register shows realised exchanged gain loss calculated based on $4865.19!

Hi All Amount posted to Accounts Payable in General Ledger is same as GL Impact, only AP Aging report shows different decimals amount.

Hi Patrick Thanks for the tips! I have shared the tips to my colleague, will update you after receiving any feedback.

Hi Patrick Elimination Accounts should be Zero out in all Subsidiaries? What is it is not Zero? Please help provide a Systematic Checklists, thanks! Kedalene Chong

Hi Patrick You mean we can do this steps on every Adjustment Period even before User accidentally post any Revaluation to Adjustment Period? Kedalene Chong

Hi Clarisa Thanks for your clarification. I figured out postings to Audit Adjustment Period Dec will still show in Financial Reports for Posting Period Dec except when select Adjustment Period it will show these Revaluation entries together with other genuine Audit Adjustments. Only General Ledger and P&L reports will…

Hi Clarisa Thanks, I will ask User to try. But will this Delete Action work correctly for InterCompany Elimination Journal? I not sure is there any other consequences as I not familiar with InterCompany Elimination. Kedalene Chong

Hi Patrick Please help explain what other consequences or limitations in Financial Reporting for non Audit Adjustments posted to Audit Adjustment Period.

Hi All I figured this is posted already. Please advise the correct way to Cancel/Reverse this Revaluation posted wrongly to Adjustment Period as it should be posted to Dec Period instead? Or is it necessary to Cancel/Reverse it since it already auto reverse in next month? What is the impact on Accounting Reports? Kedalene…

Hi Patrick So the only way is make sure Audit Adjustment Period is Closed right? In this Case the Revaluation posted wrongly to Audit Adjustment Period will still be auto reversed in the next Period right? Or is it possible to Cancel this Task without posting Revaluation?

Hi Patrick Is it possible to use formula to filter Subtraction of 2 Columns on Profit and Loss Accounts only? Kedalene Chong

Hi Patrick I mean before the Task is started, how to prevent any task to run on an Audit Adjust Period. Kedalene Chong