Hi Grace We just added this Cost Center Custom Column Filter to show in Filter Region.

Hi Grace We have added a Cost Center Custom Column Filter to show in Filter Region.

Hi Veronica My senior colleague have some different findings. She has requested for a remote session for further discussion. Kedalene Chong

Hi Patrick Is it the system will generate new eliminating entries when we run elimination again if the conso rate is changed after the first elimination? Kedalene Chong

Hi Patrick How do I differentiate this Cumulative Translation Adjustment Elimination created by system or User? This is a Balance Sheet Account?

Hi Grace We have to add a Cost Center Custom Column Filter to show in Filter Region. Kedalene Chong

Hi Micah I think I have mistaken, this could be a physical meetup event. Kedalene Chong

Hi All It was a custom field filter that need to be added to show in region. Kedalene Chong

Hi Patrick My colleague solved it by other method. The Advanced InterCompany Journal entry cannot be opened. Kedalene Chong

Hi Micah Yes Depreciation Active is True. We noticed Depreciation Rule is Mid-month actual so Depreciation Run will start 30 Apr 2024.

Hi Clarisa Its showing data of selected Subsidiary but not able to filter by Cost Centre. Kedalene Chong

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!