Kedalene · New Creation · Silver Medal

Hi Patrick I finally figured out It is not possible to achieve Zero Balance in any month Column as long there is any postings to Profit and Loss Accounts during first till last day of that month. The opening balance current month will exclude previous month cumulative balances, usually Dec, Mar or Jun if it coincides with…

Hi Clarisa/Patrick I finally figured out It is not possible to achieve Zero Balance in any month Column as long there is any postings to Profit and Loss Accounts during first till last day of that month. The opening balance current month will exclude previous month cumulative balances, usually Dec, Mar or Jun if it…

Hi Angela I found it under Accounting Preferences!

Hi Angela Thanks for your Tips! I cant locate Accounting Settings. Please share a screenshot of where to locate it thanks! setup>accounting>accounting settings, and ensure that the box labeled 'allow transactions dated outside of current period' is checked.

Hi Angela Thanks for your sharing about setting Default Posting Period for all records without adding separate Posting Period Column in CSV Import file. If the Posting Period is not the same for all Imported Invoices, we can add additional Posting Period Column on the last Column in Excel/CSV file and add Posting Period to…

Hi All I found Field Mapping for Posting Period and Posting Period Column Name in Invoice Import Sample in Suite Answer 9980. So we can add additional Posting Period Column on the last Column in Excel/CSV file and add Posting Period to the last row in CSV Import Assistant Field Mapping? Must the sequence in Excel/CSV file…

Hi Clarisa Please share a relevant Suite Answer for your explanation thanks! Kedalene Chong

Hi Patrick Manually Creating Period End Journal Entries are too troublesome. Please help share a relevant Suite Answer describing Trial Balance Opening Balance on Profit and Loss Accounts can never be Zero without manually creating Period End Journal Entries.

Hi Clarisa I managed to create a single day Adjustment Period in 2006 and single month Adjustment Period 1 till 31 Oct 2006 but not able to add multiple Periods in an Adjustment Period 1 Oct to 31 Dec? I noticed Suite Answer 24124 mentioned it is possible to create Adjustment Period of more than 1 day. Is it confirm…

Hi Clarisa So Full Year Trial Balance for Profit and Loss is always cumulative balance as at last day of the month? Please share with me a relevant Suite Answer Note so I can share with our client. Kedalene Chong

Hi Clarisa Please help elaborate how to add a single Adjustment Period back to Financial Year 2006 in Manage Accounting Periods in Diley Demo Database when there are other Adjustment Periods in subsequent Financial Year 2021? Kedalene Chong

Hi Clarisa I found this One Day Year End Adj Period option when setting new Full Year. That means we cannot activate this Adjustment Period if the previous Year was created without selecting this option? So it will always be the last day of Financial Year coincide as Adjustment Period for Audit Adjustments? So it does not…

Hi Clarisa What are the steps to create an Adjustment Period for posting Audit Adjustments? I can't find in Suite Answer. Kedalene

Hi Patrick But the Profit and Loss Accounts are not Zero even if I change to Opening Period Jan 2023. Kedalene Chong

Hi Clarisa I can't find this Suite Answer 46287. I am not able to get Opening Trial Balance Zero for Profit and Loss Accounts following your workaround solution for one Opening Period example Dec 2023/Jan 2024 in Diley Demo Database. Kedalene Chong

Hi Dominca Thank you so much for your researched Answer! So it should work for these Multicurrency Scenarios too? We have multiple scenarios which include: Payment in USD, Trade Invoice in USD, Non-Trade Invoice in USD Payment in USD, Trade invoice in local currency, Non-Trade Invoice in local currency Payment in local…

Hi All I see each Customer Payment can only apply to Invoices of one of the AR Control Accounts. Is there any Suite improvement ideas posted for this system limitation? Please let me know if anyone think of a better workaround solution?

Hi All We have multiple scenarios which include: Payment in USD, Trade Invoice in USD, Non-Trade Invoice in USD Payment in USD, Trade invoice in local currency, Non-Trade Invoice in local currency Payment in local currency, Trade invoice in local currency, Non-Trade Invoice in local currency

Hi Clarisa I figure out highlighting the Periods without selecting the Quarterly title works in my Diley Demo Database! I will ask my client to try! Kedalene Chong

Hi Clarisa When I highlight the periods, it doesnt matter to highlight the Quarterly title as well using SHIFT Key right? Hope Oracle Support can remote connect with us to see the real problem. I am able to replicate the same reporting problem in another Client's database! Kedalene Chong

Hi Clarisa Is there anything else that cause us seeing different result? Is it the NetSuite version or any other setup affecting this result? Please show me more detail screenshots how you highlight the non cumulative Periods Jan till Nov 2022 in Customize Trial Balance Edited Column? Please also share the Default Year End…

Hi Veronica Yes, still following up with Support. Do you know whether they can access my Diley Demo Database Edited Customize Trial Balance Report? We will have a hard time in communication if they can't simulate our experience in Diley Demo Database and our client's Live Database.

Hi Christopher/Clarisa Thanks for your tips! I finally see the Vendor Bill after editing the Amortization Schedule G/L Account to match Vendor Bill Original Expense and not selecting any specific Original, Target and Deferral G/L Account! I cannot choose All Accounts but I can choose not to input anything for Accounts. Its…

Hi Patrick Thanks for your screenshots. Please also help send me a screenshot of the final result after CSV Import in Currency Exchange Rates Page showing Base USD to Canada Currency? Kedalene Chong

Hi Christopher Its so tricky. I managed to find the Contact Support form at Suite Answers.

Hi All Please see my screenshots of Vendor Bill and Amortization Schedule and Create Amortization Journal Entries windows from Diley Demo Database. I thought I have input all Matching information but there is still no Source transaction record to show in Create Amortization Journal Entries. Please help to see what else I…

Hi Patrick Please help show me a screenshot if it is possible to maintain more than 1 Effective Dates and Rates for the same currency in the same month after CSV Import?

Hi Clarisa Please see my screenshots below in Diley Demo database. Even if I use Amount Non Cumulative Jan till Nov 2023, it still gives result till Dec 2023 reference to General Ledger. The Cumulative Closing Balance Column is correct whether I select Nov or Dec 2023. Please see any mistake in my Customize Trial Balance.

Hi Patrick I am really to manually editing Foreign Currency Exchange Rates. It is not possible to maintain multiple exchange rates for the same currency in the same month? Example 1 Jan 2024 USD rate to SGD 1.3 10 Jan 2024 USD rate to SGD 1.31 31 Jan 2024 USD rate to SGD 1.32 When we input a USD transaction with Posting…

Hi Clarisa It is simple to understand. We can simulate in Diley Demo Database. Please help try to simulate and confirm you can see the same Defect or system behaviour? Example Default Posting Period in Diley Demo Database is Jan till Dec 2023 Edited Custom Trial Balance Debit Credit Column, Jan till Nov 2023 will still…