@Karina just regular transaction search but I've been learning that that doesn't work! sounds like I'll need to look into the other search type then

@al3xicon -regular trans search it does not work for MB

there we go

thank you

Does anyone know of a way to automate the creation of amortization schedules in the secondary book? We integrate vendor bills from a different system and only the primary book gets a schedule. Do we really have to go to each individual vendor bill to update amortization for the secondary book?

Hi guys... What happens if we implement Multi Book after years of transactions in NetSuite? Do we need to upload some open balances to the new secondary books?

Hi everyone. I learned some quirky stuff about Multi-Book yesterday. Maybe it’s common knowledge, but I share it here all the same. This learning stemmed from a user request: “we enabled multi-book for february but we have a reason to go back and post one more transaction in january.” The most interesting findings involve the fiscal periods that precede the Effective Period of the secondary book. While from a UI/documentation/expectations standpoint, the secondary book should not have any impact on the periods that come before the secondary book’s existence……..it does! 1. after the creation of the secondary book, if you wish to create entries in a prior period, you can only use a Book Specific Journal Entry. Regular JE, Vendor Bill, etc. - these will only allow you to post to the earliest open period where the secondary book is effective. 2. the Manage Accounting Periods screen behaves strangely. In the screenshot below, Jan 2022 is a period before the existence of the secondary book, and Jan 2022 was opened using “All” for Accounting Books. Nonetheless, the little hover widget says the secondary book is closed, and shows the happy green checkbox for the period. WTF? 3. Users who want to post to a period before the earliest effective period of the book not only need to use a Book Specific Journal, they also need to have the “Override Period Restrictions” role permission even if AP and AR are unlocked. WTF?

Hi all, in need of some help regarding intercompany multi-book and multi-currency reporting. We have a business where they created a local book for reporting in a different currency (I know this is not the way to do it, and hope to correct this in the future) The issue is the trail balance. when running the report in local book, there is a balance of 850 DKK, but when running it on the primary book, there is a balance of 0 USD Subsidiary A: base currency USD, Primary book USD, Local book DKK Subsidiary B: base currency USD, Primary book USD, Local book USD an advanced intercompany journal has been created: Sub A: account 1, debit 740 USD Sub A: account 2, credit 740 USD Sub B: account 2, debit 740 USD Sub B: account 1, credit 740 USD the GL impact looks correct: Local book: Sub A: account 1, debit 5200 DKK Local book: Sub A: account 2, credit 5200 DKK Local book: Sub B: account 2, debit 740 USD Local book: Sub B: account 1, credit 740 USD Primary book: Sub A: account 1, debit 740 USD Primary book: Sub A: account 2, credit 740 USD Primary book: Sub B: account 2, debit 740 USD Primary book: Sub B: account 1, credit 740 USD

Hi @Peter Bertelsen did you ever find the answer to your questions above? I was happy to see a multibook channel, but then saw it was only you in here 🙂

Hi @Sara Dickinson , did not notice that 😛 But yes, I found that the account had not been set up for currency revaluation and that created the issue.

Hello, how do I create a specific book for an Journal entry r using an amortization template. When I start the journal amortization process, it only works for the primary book. But nothing is posted on the other book.

do you actually have any data in the secondary book where you are trying to post the journal? @Marc

No, I have data on the 2nd book in question. Moreover, if I see the GL Impact of my journal in question, I can see that it is posted on my primary and secondary book. However, when I run the journal entries amortization, it only posts to the 1st book.

On my screen when i select secondary book on the amortization journal entrie page , i can't find my amortization schedule

Ok now it's working but i have this message : Book specific journal entries can not post to Accounts Receivable or Accounts Payable lines that have an entity on it.

can you confirm you are using items? that’s the only way different amort schedules can work. you should set them (AS) for each book. Then the transactions must post. Then you can post your journals, per book per sub, etc.

Amortization does not post (should not) into AP account, it must post into def expense account. you may have issues with your account type set up

No I use expense account ( it’s working on primary book ) My journal entry use 1- expense account with amortization template 2- a/p account with name So when I run the process for the primary book it’s working but for the secondary book I have the error message

expense account does not work for the purposes you describe. You MUST use items. That’s where you set up different amortization templates per book on the item record.

wait - are you doing amortization via manual journal entries?

no, it works for a journal entry on which I can only put expenses (same on my vendorbill, I manage to post on my secondary book with the expenses) but I don't know why the system created an amortization schedule on my AP line when I don't have a template or a start date / end date

it is not intended to work this way; you should be using items for the different amortization schedules. I suppose the error is native, and it makes sense. Waht is the reason you are using journal entries to book VB transactions? an accountant in his/her right mind will never post a manual journal into a system account

the journal entry is created by an integration between netsuite and an tool called Navan. The supplier bills goes down to journal entry format. Now the problem is that for the primary book I have no problems with this AP line but only on the secondary book where an amortization plan has been created on this line.

😞. MB is tricky and not straight forward. what may work as an exception for primary book is not applicable for the sec book. I suggest you contact NS to see what they think.

yes I think I will contact them but thank you very much for your help and advice

Howdy multibookers... does anyone have any general guidance on how long the HTP process should take to run? In Sandbox accounts, we have never even had it successfully run. We let it run for 6 weeks once, most times it just freezes. NetSuite Support has not been helpful obviously because they just tell us that Sandbox performance is not Production. Any guidance here? I know its relative to transaction counts, time windows, etc, but I'm just trying to get a level of confidence that the thing will even successfully run. Thanks!

how many transactions do you have? do you have inventory? scripts?

I'm starting a new thread to not derail the previous one with my questions, but the concern is the same. We are working with Professional Services to implement Multibook. The main issue is the time to run HTP (10 days in Sandbox for 5 million transactions). They recommend us to stop ERP activities in order to copy all transactions for the brand new secondary book. But we can not stop operations for more than a weekend each time, so we asked if several HTP runs each weekend would be feasible: split by year, period or module, run HTP every weekend till completion. Professional Services says we can't do that. Each new book must complete its HTP in a single run. We are very close to forget about multibook.

Hi all, do you know what's the best way to import mid-life assets with an alternate book? Do I need to add the alternate book to the asset type? Do you import depn history for the alternate book too?

just like regular book except you select the book you want and then everything is the same.