Here you go. Sorry I redacted a lot! I hope that's enough to help.

I'll get a screenshot on Monday. I can say no the other two questions, though. No drop-ship, no non-inventory.

I created the report, but need feedback. I'm not sure if this will suffice. I think they're wanting something they can chart over time.

It was created directly from the Vendor Bill. Unfortunately, I don't have a screenshot, since the team decided to recreate the bill over another issue.

That worked! Thank you!

Sorry for the delay, here are the screens.

@leahlipska Sadly, I don't have access to that account, so I can't link it. Apologies!

D'oh. Nobody told me they BCC'd me on everything. Haha! We can close this. Thanks.

This thread can be closed. I've parted ways with the client with this issue. Thanks!

I believe I've successfully added the desired information to our voucher. Thank you! Future readers: refer to SA # 92427 for the best solution. You want to reference the apply sublist on a Vendor Payment. You can find the available fields in the NetSuite Records Browser.

I just noticed the item's originating location shows a 0.00 last purchase price. Could that be why there's no G/L impact? I know that can happen for Inventory Adjustments. Does that apply to Inventory Transfers as well? The transaction sublist shows the quantity was moved.

Thank you! I'll review these articles and see what we can create for the accounting team.

<table style="position: absolute;overflow: hidden;left: 10pt;top: 540pt;width: 550pt;"><tr> <th>Inv. Date</th> <th>Invoice #</th> <th>Invoice Amount</th> <th>Discount</th> <th>Net Invoice Amt.</th> </tr> <#list check.expense as expense> <tr> <td>${expense.trandate}</td> <td>${expense.tranid}</td> <td>${expense.amount}</td>…

When I go to add the formula, I get an error message that only numbers may be used in the field. It allowed me to save anyway and this worked! Thank you!

Can also check the transaction line column on an After Record Submit. That might be enough, but I'm not sure. To summarize: I created a custom field on the item record and a custom transaction line column called Don't Print. I created a workflow that applies to certain transactions. It checks the item to see if the…

Incidentally, the method from the SuiteAnswers article I shared does work...manually. I can create a column on the line item and if the user manually checks "don't print" it excludes it, but I know users are not going to want to or remember to do that, so it would be nice to be able to source it from the item itself.…

The inventory was all added with an import of an inventory worksheet back in January. These particular items, since they were never received, were never paid for since they were canceled. The information was erroneously imported by the original implementation team. Team seems to think this will work, even with the…

That sounds good, but the team wants some clarity around the costing. Isn't the cost on the item irrelevant because the adjustment will remove its value from the books, as well as the inventory quantity? Just want to make sure I'm not missing something and their question gave me pause. Thanks!

This is what we figured, so I think we're good. Thanks.

Thank you! This is exactly what we needed.

I have nothing to share on the PDF template since I had no success, I deleted the additional section. It's the standard Invoice PDF. Just want a way to link customer deposits and remaining balance on the standard Invoice PDF.

Yeah, I just realized that before I read this. Haha. As I said, I'm not a developer. I tinker with scripts once in a blue moon, so I never retain the knowledge.

@ericcwrigley Ah. I was always taught that you should declare variables with a semi-colon, so I suppose "mistake" was the wrong wording. It just struck me as sloppy. @Pierre_Plourde Perhaps I'm a bit confused, looking back at your other comment. The instructions say to add a custom field to the record you want to perform…

Unfortunately, it's a requirement that we lock fields when someone is editing. As there's no other native solution and I haven't gotten any other suggestions, I am forced to use this, poor solution or no. Frankly, I feel this is on NetSuite for not providing a very commonly-requested feature, but we do what we must.

Unfortunately, the example is not useable in its current state. I'm not really a developer, so I'm struggling with getting this easily set up. But even I can see there are a lot of mistakes in the code like not following ANY of the variables with a semi-colon. Any idea how to clean this up? I know I'm not doing this…

Yeah, we have figured things out. There was just some confusion around the needs. Thank you!

Great. Just wanted to throw out some examples. I understand the SO's are non-posting, but we will use them for reporting, which I think is the greater concern. As an example, a frequent scenario is having extra items sent by the supplier even if the customer nor we requested it. We want to capture and pay for the extra 5,…

@Joy Noreen Magoling-Oracle So, digging further, I think I see where the concerns arise. There was a bit of knowledge shared about editing sales orders AFTER it was invoiced. So yes, it would require a lot of changes along that chain, but wouldn't NetSuite realistically discourage that to begin with? I don't think we would…

So when I added the names myself, it worked just fine. I'm good to go. Will recommend we use External ID, too. Thanks!

Sure! Weird question.... The matrix naming template field data doesn't use the logic to form the names through CSV, does it? It's just for manual creation. I think that's where I am getting hung up. I was told it should.