ok, not a deal breaker, thank you for confirming.

ok, how about this, I must have done something wrong, could you please enlighten me? Thank you, thank you! <td><br /><#list record.<custrecord_office>?split("\n") as custrecord_office> <td colspan="12" style="padding: 0;">${‌custrecord_office}</td></#list></td>

That works perfect, thank you!!!

great, it works. I was able to add the amount as well. One further favor if possible, any way to list taxes on separate rows if there are multiple? Thank you so much!

Like this? It still gives me an error. There might be several tax type, GST, PST, HST etc

ok, checked another place, so the extra line was a forecasted charge. somehow after actual charge is deleted, the forecasted charge was still there. so I deleted the forecasted charge, and remove the line from the SO, or recreated SO (i forgot which step i did exactly). this time, the charges are showing the SO link, but…

it's a non inventory item that can be fulfilled. I also tested a non inventory item that cannot be fulfilled and doesn't seem to be successful either. i usually generated the charges first, and then create the SO. like it's suggested on the Suite Answer, for the time based charges, i was able to go back delete the charge…

this actually worked, amazing! Now i understand better, the original one that was there was probably brought in by bundling all sandbox configurations, and this rev rec rule should probably only be generated by the system instead. Renaming the old one would be able to tell the system differentiate the two, and only use the…

This is the name

and I have charges on the projects, but it's not generating revenue arrangement as it did in Sandbox, which i'm thinking related to that error.

Can you confirm if the error is encountered when you refresh the Revenue Arrangements for projects? Yes Here are the rev rec rules. I don't think the project rev rec rule was manually created, even thought it has UI in the context. I think this is probably when we turned on the project and the system created the rev rec…

the issue is with bill transaction. There is not much tax implication on POs compared to bills, as it's non posting anyway. on the bill transaction, where there is a tax implication, there is no ship to field. so currently, we have to instruct people to manually select override Nexus and select the right state, and hope…

How about using a script instead of workflow? Would that work? We use OneSource + SuiteTax, and the calculation is based on the custom field already, it's just the native Nexus field is still based on ship to. The Nexus will determine the GL account, sales/use tax payable to CA, NY etc. This is not as much of an issue on…

so you are saying, there's no way to remove these FAM tabs in the Custom tab, correct? I just would like to confirm, so we will give up the idea :)

I see, that's probably a little over-kill, but I will keep that in mind, thank you!

I don't really see any option under the address sublist. Is there any way to accomplish this without a script? Thank you!

Hi Angelica Mae Segador-Oracle, with the guidance from that suite answer, it worked, super!

tried, still didn't show the search

this is a customer search, sorry, still confused...

yes, the concept works. However, I couldn't locate SuiteSucess AR aging workbook, and trying to create myself following answer 96128. The numbers don't tie to the standard aging report. Could you kindly check what's wrong? Thank you! standard aging, total $3.9M workbook, total outstanding $3.4M dataset

But customer does not just need to see the name of the file, but the actual file. So currently, there is no workaround at all in netsuite to achieve that?

I was able to follow answer 49990 and it worked now. Looks like it was recently updated, nice!

this shows percentage of each customer of the total, not the current/ 30 day/ 60 day amount as a percentage of the total AR, right? " Are you trying to get the % each aging bucket makes up of the total outstanding balance for a customer?" this is what I'm trying to get, and it doesn't have to be at the customer level, at a…

yep, it worked. I really appreciate your brilliant workarounds. I remember you had come up with a workaround for this post of mine as well. https://community.oracle.com/netsuite/english/discussion/4489097/how-to-set-a-custom-field-on-an-invoice-to-be-the-same-as-a-custom-email-field-on-customer-record#latest That was truly…

I add the files to the search, and can see it in the customer center. but when clicking on the file, it still says no access. any idea?

thank you, i appreciate it.

here it is, thank you!

Hi I have a question on advanced pdf form of PO. We have this project field on the line item, i can show the whole project name on the PO pdf, but i just need the PRJ-000151, how can i do that. I tried to use item.custcol_cs_sub_project.entityid, item.custcol_cs_sub_project.id, item.custcol_cs_sub_project.entity.id,…

interesting, it actually did work. Netsuite is so smart!

but this will send the whole AR list, not the AR list for their own accounts? I don't have issue on the scheduling email part. The difficulty is in the search result that i don't want the whole AR sent, just the accounts pertaining to the sales rep/ regional director.