brocha Red Ribbon

Ok, thanks Tris. I think i figured it out. I appreciate the assistance.

ok, thank you!

Ok, makes sense. I have serialized inventory and non-serialized inventory items. Are there specific native templates i can download or should i create an import file based on what i want to import?

Yes ive tried cu^ and it returns all customer and customer invoices. Is there a way to sort the results to customer appears first? Or when searching for vendors (ven:), getting vendors to appear first in the results, not vendor bills.

hello, just checking on this ticket!

Hello, We get the same results when using the cu: prefix. The customer "specialty appliance" is not returned.

Aha, so that's why. Makes sense. Thanks for the help!

Yes, i can sort the Expiration Date, so it doesnt behave like Project Name. I recreated, removed/readded the Project Name field and did not put a custom label on it. Below you can see the native field name "Title" is still not sortable. Also you can see Expiration Date HAS been sorted.

And yes, the search does return results. When i click on Project Name, nothing happens. I took a short video of the search and how the cursor behaves. I can send to you at a different email address if you like? Just to avoid sharing publicly.

Hi, Yes, there are two other fields with custom names, one being the Create Date, native name is Name. This field can be sorted as seen below by the small arrow on Create Date. All columns in the screenshot below are sortable, except Project Name.

Yes, this is the desired outcome. However i nothing happens when i click on the PROJECT NAME header. The cursor changes to the pointer finger when i hover over the other headers, but not when i try with PROJECT NAME. This is the "title" field. Where does this field live in NS. Im wondering if there is something in the…

Sure. Here is the criteria Results And Available Filters Thanks for looking into this!

Wow that was fast! yes, i used your first example and it is working. Thank you so much!

Hello Jervin, Your suggestion worked for us! Thanks for your help!

Hello Jervin, Ill try your suggestion and let you know. Thanks!

Hello Jervin, Any update on this?

I appreciate it, Jervin. Thanks!

Just wanted to add that the values in NS appear correct. The negative totals only appear on the template.

I did some more research and found on the form/screen fields/there is a column named Space Before. I entered 1 in this field, but at only moves the field columns down x amount of spaces. It doesnt actually remove/hide a field. If there is another way to accomplish this, please let me know. THanks!

Hi, We were able to figure this out with the help of NetSuite Customer Support. It was determined we had a negative qty in the system. We can see the negative qty by creating an inventory balance saved search, with filter on item and location. Then we created an inventory worksheet for item in question. Thanks for your…

Hello, Just checking on this inquiry. Let me know if you all need more information!

Jervin, i think you did it! I see the correct fields appearing on the PDFs according to the business.id. Thank you so much for your help!

Here is a screenshot of an "appliance" PDF where record.cseg_appf_business.id == '1'. You can see both the Project Name and PO fields are on the PDF. We only want the Project Name field to appear when business.id = 1. When record.cseg_appf_business.id == '2', we only want the PO field to appear, not the Project Name field.

Hello everyone, Just checking on this request. Let me know if you have questions!

Hello, Im still waiting to hear from our Ops Mgr on this. But will the newly added SKU field appear on already created invoices (retroactively update old invoices)? Or will it only apply to newly created invoices?

Well, looks like that worked! Im going to ask our Operations Manager to test and ill get back to you.

Update: I made the changes below to the highlighted field and no longer get the error. However this is what appears on the PDF in the SKU column. We are looking for the item vendor name to appear in this column.

Just want to provide some of the code. Here is the itemtable code with the custcol2 field highlighted. Ive also tried: record.item.custcol2 item.custcol2 item.item.custcol2 When i try to preview i get the below error.

This does help. THank you!

Hi, this is how im importing price updates Im matching on item internal id and updating the price level field with a numeric value. Just want to know if this type of price update will retroactively update all existing documents like previously entered quotes. THanks!