Hi Micah Mia Villafuerte, CPA, CMA | Customer Support has filed Defect 655402. We follow the alternative solution provided from Case 5454989 and get the correct Opening and Closing Retained Earnings result. Alternate Solution: 1. Open Custom Trial Balance and click Customize 2. Remove original Opening Balance and Closing…

Hi Clarisa Thanks for your tips, I can see the Vendor Foreign Currency, Exchange Rate and Equivalent Foreign Currency amount in General Ledger Report Accounting Details now. Is it possible to show Vendor Foreign Currency, Exchange Rate and equivalent Vendor Foreign Currency amount in the Original posted transaction GL…

Hi Patrick How do I search for this Defect 655402? Is it published in Suite Ideas?

Hi Patrick Mia Villafuerte, CPA, CMA | Customer Support has filed Defect 655402. We follow the alternative solution provided from Case 5454989 and get the correct Opening and Closing Retained Earnings result. Alternate Solution: 1. Open Custom Trial Balance and click Customize 2. Remove original Opening Balance and Closing…

Hi Patrick Philippines Subsidiary is not using Standard Fiscal Calendar, it is Oct till Sep 2022 for Year 2022 and Oct 2022 till Dec 2023 for Year 2023. I follow your steps to edit Custom report but Retained Earnings Closing Balance is still not correct.

Hi Clarisa This is the Diley Demo Database Currency in USD. We need to see the Source Currency and exchange rate used in any posted transaction in accounting journal entry and General Ledger Detail Report.

Hi Patrick How to check is our client using Calendar Year or Fiscal Calendar Year? Kedalene Chong

Hi Ely I am able to see Bill Credit of English Book Inventory Item is Credited and Quantity added back though Purchase Order Billed Quantity is not changed in Diley Demo Database. Is there any scenario where Bill Credit does not credit Inventory but Credit Goods Received Clearing Account on different types of Item? Now I…

Hi Micah Please share any updated relevant Suite Answer that explains this Scenario and should I submit a new Suite Idea about this Scenario? However, we are not sure how this Scenario can be reproduced as it may not happen to all other Customers due to complexity of InterCompany related transactions. Kedalene Chong

Hi Patrick The ending balance does not match with the Default Trial Balance (Debit/Credit formula) at all when the Default Trial Balance result is correct. I purposely add the Default Trial Balance (Debit/Credit formula) in the same Open Closing Trial Balance and see the Retained Earnings under Default Trial Balance…

Hi Micah I found a good recommendation from Suite Answer 81585. Scenario User locks the A/R and A/P of the current Accounting Period. Even though Expense Reports are dated within the current period, the user expects to post it to the next Open Period. Solution To have Expense Reports post to the next Open Period, ensure…

Hi Micah Do you have a more specific Suite Answer to explain that Suite Answer 73701 Custom Opening and Closing Trial Balance does not work well on Retained Earnings? And what is the workaround solution for User to use this Custom Opening and Closing Trial Balance since all Accounts are correct except Retained Earnings? I…

Hi All How to search for this NetSuite Video for sharing? Kedalene Chong

Hi Micah So NetSuite Answer 73701 Custom Opening and Closing Balances Column Trial Balance may not work correctly on Retained Earnings right? Do we need to post a new Suite Idea or it is considered covered in 460818? Kedalene Chong

Please see customized formula and result. Only the Amount Debit/Credit Column result is correct as I purposely copy from Default Trial Balance formula. It seems Opening Balance Retained Earnings is wrong so Ending Balance also wrong. Debit Column and Credit Column is Zero. Kedalene Chong

Hi Patrick We have already followed these steps but the Retained Earnings is still not correct and different from the Default Trial Balance. Kedalene

Hi Patrick We followed Suite Answer 73701 so did not checked Cumulative Value for Debit and Credit Columns. So we should checked Cumulative Value for Debit and Credit Columns and Retained Earnings will tally with the Default Trial Balance? Kedalene Chong

Hi Micah It is a Custom General Ledger Report.

Hi All I added the Default Debit Credit Amount Column as per Default Trial Balance to see side by side and noticed only Retained Earnings Closing Balance is different from Amount (Debit/Credit) which is correct as per Default Trial Balance. How is the Grand Total of Trial Balance Amount Closing Balance Computed? Should it…

Hi Micah The customized the TB to add the opening balance, all looks correct except for the retained earnings figure: This default Trial Balance is correct but the Retained Earnings in Customized Trial Balance with Opening and Closing Balances is wrong. Please help advise what other steps need to be done thanks! Kedalene…

Hi Michelle Not yet, I need simulate in Diley Demo Database.

Hi Patrick How about Amortization Schedule Amount and Remaining Deferred Balance also not possible to show in Amortization Forecast report? Do we need to write another Suite Idea for these important information to be added to forecast report?

Hi Clarisa I did not need re create the Calendar, just assigned in Manage Accounting Tax Period. It is just confusing that the assigned Calendar disappeared Tax Base Period Fiscal Calendars after Saved though its working fine when filtering Date in GST Tax Report.

Hi Clarisa I did not need re create the Calendar, just assigned in Manage Accounting Tax Period. It is just confusing that the assigned Calendar disappeared Tax Base Period Fiscal Calendars after Saved though its working fine when filtering Date in GST Tax Report.

Hi Micah The dates range is Oct 2023.

Hi Micah I managed to re submit Approval for User using Administrator Role but cant see who is the Next Approver as not mentioned in Disposal Journal. There is customized workflow. Any idea how to trace who is the Next Approver other than any Administrator?

Hi Micah I just Edit the Search Results Criteria to show Amortization Schedule Amount, Total Amortized and Remaining Deferred Balance. Diley Demo Data

Hi Clarisa We managed to solved after adding new Calendar used by new Subsidiary in Manage Accounting Tax Period setup. But is it normal the new Calendar is added and not saved is not displayed visible when I view the same Tax Period again though it is already showing in GST Report Dates range selection?

Hi Clarisa I solved the dates missing selection in GST Report for some subsidiaries using different Calendar by doing the steps in my earlier screenshots. But I am just curious is it normal the assigned new Calendar is not visible in Manage Accounting Tax setup after Saved? Kedalene Chong

Hi Micah I managed to show Amortization Schedule the Amount, Total Amortized and Remaining Deferred Balance in this Amortization Schedule Saved Search. Kedalene Chong