@Elychelle Gulen-Oracle - Yes, that makes sense. I don't LIKE that answer and feel it is very poor design :( but you still gave an answer that makes sense and I appreciate it! Thank you!

I think the difference is - your account is a balance sheet account and mine are expense accounts. Entity does show up for balance sheet accounts on Bills. So why don't they show up for expense type accounts?

No - I'm using the Posting Account Activity Dataset. Please see attached photo with Entity blank for Bill type. Thank you!

It did! Thank you so much for these answers!

Yes, I did try that, but I received an error about that value possibly being null. Again, being new to html and Freemarker, I'm assuming I need to account for the potential null in a manner similar to what you're doing for the tracking number. This is my attempt at duplicating what you did but for the shipMethod....but I…

This article is exactly what I'd been searching for!! Thank you SO MUCH for discovering this solution. One question I do have - how do I get the shipping method to also display in the email template? I'm fairly new to html but I'm assuming I need to create a separate list for that since it doesn't exist in package? I truly…

@Mikko De La Fuente-Oracle What missing field would I check for? The item receipts are coming through with the landed cost templates set at each line carried over from the purchase order. And the 'Landed Cost Per Line' box is checked on the item receipt as well. When manually receiving, having those two present is all that…

Thank you. I don't LIKE the answer :| but I thank you for answering it.

Yes, this can be continued in the newly created thread I submitted found here: https://community.oracle.com/netsuite/discussion/4476068/manually-closing-marking-paid-in-full-an-invoice Thank you!

Found this via search as I have the same question. I want to load historical (legacy, pre-NetSuite) invoices into NetSuite so I can report against them in my sales reports. (My reports are generated at the line level so we can see which skus were ordered in prior months). I planned on doing JE's to reverse out the…

Related to this, maybe? Because I was also wondering why the formula wasn't coming through in the web query. But also - why do my columns not show up in the same order as the report? Example, the report has, in this order: Sales Rep, Customer Name, Current Month $, Prior Month $, Variance $. But the web query comes out in…