Kedalene · New Creation · Silver Medal

Hi Patrick/William Please elaborate how to add every subsidiary as separate Column in Balance Sheet and P&L report? Kedalene

Hi Michelle Yes, managed to find solution from the other thread! User is not able to list Parent Bank Account as your User Role has Subsidiary Restrictions limited to the selected Subsidiaries in User Role setup that is different from the Subsidiary used in Parent Bank GL Account. Thanks so much for the contributions of…

Hi Katerina Thanks your solution works!

Hi Patrick But the display of Subsidiaries at Footer only allow selection of one Subsidiary at a time right? The standard Trial Balance already allow selection of Subsidiary at Footer? But only possible to select one Subsidiary at a time right? Kedalene

Hi Patrick Your alternate solution is still only showing result of one Subsidiary at a time right? Is there no other workaround solution using Saved Search to show all the entities, by COA, amount, currency and amount (foreign currency)? 

Hi Katerina Please see relevant screenshots and help to find any clue? Administrator Role Non Administrator Role permissions Non Administrator Role can see the previous added Bank added with Sub Account Of 1113-0000 but cannot list to see 1113-0000 in Sub Account Of. Non Administrator Role Kedalene

Hi Katerina We noticed this non Administrator User Role can see other Inactive GL Accounts but not this Inactive Summary Account that has been used as Sub Account in another Bank Type Account. Kedalene

Hi Jack It is found in Transaction Body Fields? Do you know where to search for this Setup other than going to Global Search? Kedalene

Hi Katerina The Parent Bank account cannot be found in that User Role login. There is no show Inactives option.

Hi Katerina I found another important clue. I noticed I can list this Bank Account in Sub Account Of when login as Administrator role then I check further and noticed its a Summary and Inactive account. How to enable non Administrator Role to choose this account in Sub Account Of? Kedalene

Hi Jack Where do I click to add a new Transition Point 1 to Point 2? There is nothing no response when I try to drag Approved to Pending Approval State.

Hi Patrick Can these steps apply to General Ledger Detail Report or we must only view from Balance Sheet drill down to transaction details? Kedalene

Hi Katerina Yes both are Bank Type. We discovered in their live database new Bank Account to be created for Thailand Subsidiary does not match with the same Subsidiary of Sub Bank Account and there is system limitation that each Bank Account cannot select more than one Subsidiary. I hope my answer given to Customer is…

Hi Jack When I click on Pending Approval to Approved arrow in Workflow Space in Diley Demo Database, there is no arrow for me to change Transition On to After Record Submit? Kedalene Chong

Hi Joy So the next best workaround is to post Approved Invoice to Credit Note? Kedalene

Hi Katerina Is it User can Edit Approval decision given Edit Permission to Invoice? Is it affected by this kind of customized workflow?

Hi Clarisa Thanks for your patience! I managed to follow your steps closely. Please help to check is Edit Columns showing just Financial Row 1 2 3 4 5 correct? Can I see your example of Edit Columns window? Are these steps documented in a Suite Answer ID?

Hi Clarisa Thanks for your workaround. Is it possible to achieve a 12 months rolling cashflow statement? Kedalene

Hi Katerina Our client has double check the same Subsidiary has been selected in Chart of Accounts for G/L Sub Account.

Hi Ely You are totally right! I can change the Date but not posting period without reopen period using Allow Non GL Changes! So its better just Reopen Period when necessary to edit period. Kedalene

Hi Katerina Perhaps I just advise our client to leave it as it is since there is no new accounting impact and wont affect their present Bank Reconciliation status. Kedalene

Hi Ely Thanks for introducing me Allow Non GL Changes option that I can consider using in future. I deliberately close the period Apr 21 in Diley Demo Data and Allow Non GL Changes and really able to click Edit Applied transactions. However, after I unselect and reselect another Invoice to apply vendor prepayment, I am not…

Hi Ely Where to enable this Allow Non GL Changes? You mean I can enable this feature without re opening previous year posting period Dec 2022? But I tried in Diley Demo Database there is GL Accounting Impact and I am able to change both Posting Date and Posting Period to current month without error?

Hi Katerina Thanks for your workaround and I really appreciate your effort. But I am quite confused and need some clarifications. What should be the accounting entries of this Dummy Offsetting Journal Entry? It will permanently posted to General Ledger causing wrong ending Bank Balance in NetSuite? Kedalene

Hi Kristoffer I found this Suite Answer 11802, is it relevant? How to Unapprove an Invoice in OpenAir Share Last Updated 01/22/2023 Reading Time 1 min Answer ID 11802 Applies To Product: OpenAir Scenario In order, to un-approve invoice, follow these steps: Solution Navigate to Invoices module > Invoices tab > [select the…

Hi Ely If this vendor prepayment application is post in May 2022 and the period is now close, can I Edit the vendor prepayment application now and post this "reversal" to Feb 2023? Kedalene

Hi Katerina You are right they are listed as unreconciled in Bank Reconciliation Details! I am puzzled how should they proceed to match these data again without affecting the accuracy of Bank Reconciliation Statement as their current Bank Balance in NetSuite already tally with Bank Statement? Kedalene Chong

Hi Katerina The 7 records are really listed in the Bank Statement of Apr 2022. I will ask User to provide NetSuite Bank Reconciliation Details. Kedalene

Hi Patrick Thanks so much, will try your steps and update you! Kedalene

Hi Ely Thanks for your answer! Is there any related enhancement request for adding Memo at the Bill Payment Header portion? Kedalene