This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Parent Sub UK (GPB) 
Child sub US ( dollars)

create a new level between the two sub with base currency = GPB

Don’t post any transaction to this sub 
Then if you use the context on the report : new sub consolidated , you can see the P&amp;L for the US SUB in gpb

Or you can replicate the P&amp;L in saved search and create formula to convert the amount with the monthly exchange rate ( it’s manual and you need to update the rate everytime and not precise )