Kedalene · New Creation · Silver Medal

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

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…