Thanks for your response. This is not a one world account. The Multiple Currencies feature is turned off. There are no items, vendors, or transactions at all. This is a newly provisioned account.

Sure but I couldn't find it. Can you direct me?

Thanks!

Thanks for your quick response. I read the article. So I can inactivate that account and it will remain with a negative internal ID but will not be used. You say "Netsuite needs a main email address to use for the account.". It doesn't allow me to change the email address on that account but that user left the company and…

I understand. Glad to hear it's logged as an enhancement. For now I will work around it. I very much appreciate your help.

Thanks very much for your reply. It can do as a work-around although it's not ideal. What would be great is if I can attach the detail of this report (or another report) on the same email as an attachment. That would be awesome. Is it possible to have two reports sent on one email? Again, I appreciate your help.

Thanks for your help. It works ok. The problem I had was that my system always opened the csv file using Excel because that it how my Windows File Associations are set up. This causes the leading zero supression. However, when the csv file is emailed directly from the saved search as an attachment it does not strip the…

I appreciate your help. When I click on the csv icon on the top left (screenshot) it automatically opens up in Excel. Maybe that's the issue. Is there a way that it can open a "Save As" window so that I can save the results to a file? I'm hoping that it will then save as text WITH the leading zero. Possible?

Thanks for replying. Excellent point, but yes. It's missing the leading zero in notepad as well. Is there a way to somehow force the leading zero to appear in the csv file?

Thanks for your reply. Main Line is true Created By is all Location is all Type is Invoice

Hi Shamaine, Wow. Thanks so much. It works now.?

Thanks for your reply. "Are you using the same formula for the columns Gross Profit and GP%?" - No. One calculates the Dollar Profit and the other GP%. "Kindly try marking Apply Formula to Grand Total checkbox while leaving the Add Grand Total blank/unchecked." - I tried and still get the same result.