Thank you Sankar. Will this work also in Purchase Order?

Yes I test that . The normal journal entry shows up in our sales report

hello Micah, Thanks for the information. but my main problem is I can't reopen the period of the inactive subsidiary because it is not in the manage accounting period list anymore. So how do I open a period for an inactive subsidiary?

Invoices, Vendor Bills, Item Fulfillments, Journal Entries, Item Receipts

Thanks, I tested it and it works.

Thanks for the confirmation Mikko. The thing is Netsuite doesn't recalculate exact amount discount line that is why we are thinking to put a script on post sourcing when Fill % is clicked. anyway I will just use user event script to do what we needed.

Hello Erick, I decided to manually compute and set the amount and total amount for the whole invoice. Although I don't particularly like this 'solution' as it might cause issues in the future. I just don't understand why Netsuite didn't compute automatically when I added new item lines via user event script. Anyway, our…

Thanks Erick. It worked.

okay I will try that. but is the currency not exposed in Item Record or in saved search?

In the Records Browser of Inventory Part, There's a currency field for Purchase Price. This is not a custom field. This is a field by Netsuite. https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2021_1/script/record/inventoryitem.html That's the field I want to show in my saved search

I'm working on Item Saved Search. Both solutions are not working for me. The purchase price I'm referring is the purchase price and purchase price currency main field in the Item Record. We have multicurrency and multisubsidiary.

No. I feel like the person who answered my question just took keywords from my post and didn't really took the time to understand my question.

okay thank you for this but may I know the reason why? We are expecting it will be easier to implement a new US subsidiary because Netsuite is also a US company. We didn't see this problem since this is also not mentioned explicitly in the US help topics.

There's no purchase tax code for US in Legacy Tax engine. What's Netsuite plan with this? How about a workaround to load all purchase tax codes to our US subsidiary?

I was told it can be done. but instead I should "append" it. I don't see how to do it.

Thanks for the reply. I appreciate it. I will discuss further with the accountant.

Thanks for the answer Mica. The info in the link you sent is not as detailed as the one for Suitetax. why is too different for legacy and suitetax engine tax lookup? Does that mean Legacy tax is not enough for US subsidiary? Do we need to convert to Suitetax?

Thanks for your answer Patrick. Your answer is actually what I am already doing. What I wanted is something similar to what is happening in Sales transactions which is the same in the suiteidea enhancement you suggested I voted in. Also as I said in previous reply, there is no shipping tab in Vendor Bill. WE have vendor…

okay thanks I will tell our accountant.

The link for the suiteanswers article is for Suitetax. How about for companies that are using legacy tax and have multiple nexuses?

There's no ship to nor Shipping tab in vendor bill transaction record. Even in Purchase Record, this doesn't work. Scenario Subsidiary A has nexus on Singapore, Austria. Purchase #1 Ship To: Singapore Bill To: Austria Company A address default bill and ship address is in Austria Purchase #1 nexus determined by Netsuite is…

Hello, The explanation works on Sales Transactions, but it doesn't work in Purchase Transactions. How is nexus determined in Purchase transactions?

My code doesn't work on vendor bill all the time which is puzzling me. I can't find the reason why it is working on some record while to others, it is not.

Here is my script: /** * PAGE INIT FUNCTION * Page Init events occur when the page completes loading or when the form is reset. * The recordType (internal id) corresponds to the "Applied To" record in your script deployment. * @appliedtorecord recordType * @param {String} type Access mode: create, copy, edit * @returns…

Thanks for the answer.

Inventory asset is in Item Receipt and Item fulfillment COGS is in Item Fulfillment, Vendor Bills.

Okay. Thank you for checking. I'll just vote that enhancement.

Yes it hase store form checked. I'm looking at all transaction types that have inactive forms.

Thanks for the reply but this is not what I was referring to. I meant Vendor Bill Installment not Vendor Payment Installment.

It's the Realized Gain/Loss currency revaluation record. GL Impact of Payment Record Payments sublist of the Invoice record Currency Revaluation/s generated