User_BCKYD Red Ribbon

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!

It wasnt the ideal solution as much as it was a work around.

ok, thank you for the information.

Hello Michelle Jabanes, I will try your proposed solution and let you know if i require additional assistance. Thank you!

Thanks @User_ZCWF3, I removed the status criteria and the conversion percentage seems more realistic now. I changed my summary type to MINIMUM but it doesnt seem to affect the results. Why do you use MINIMUM vs SUM? Thanks!

Hi, I came across the link below and was able to fix my saved search. Basically i had to manually type in the formula instead of COPY/PASTE. There must be some hidden characters in the formula i copied from SuiteAnswers. This question can be closed. Thanks!

Hello, Just wanted to get an update on this question. Please let me know if any clarification is needed. Thanks!

Hi Joahnna, Just checking in on this ticket. Hope my previous post makes sense. THanks!

Thanks for the information! Below is the current code and highlighted are the column labels and check.apply section. THis looks like the voucher code you sent me. Do you mean i add your code at the very bottom of this screenshot, under the check.credit section that is commented out?

Hi Johanna, Just following up on this question. Let me know if you need anything else to assist. Thanks!

Hi Johanna, Please let me know if you need any additional info from me. I appreciate your help.

Sure, here you go!

Thanks for this, Shaik. After a couple more tweaks to the code it finally works for me. I appreciate it.

Thanks Shaik, I tried to enter the code you suggested. Below is what i have. But the code throws this error when i preview it.

Jack, I kept getting error The string "--" is not permitted within comments" so to get around this just removed the code that was commented out and saved it in case i need it later. So im all set here. Thanks for your help, once again.