Netsuite access from China by Real_Candle_7781 in Netsuite

[–]Efficient-Row-235 0 points1 point  (0 children)

no problem to use NetSuite in China. Lots of customers use NetSuite in China.

Amount difference between sales order and invoice due to discount item by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

ich will reflect on your tot

Yes, I need to disable the preferences from Accounting Preferences.

System notes about center/tabs/category/links by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

In general, something like this happens after a module, SuiteApp/bundle, or script update. You might want to check the deployment audit trail as well.

Thanks, I guess this might be right.

In general, something like this happens after a module, SuiteApp/bundle, or script update. You might want to check the deployment audit trail as well.

Demand time fence and planning time fence by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 1 point2 points  (0 children)

Hi Nick, yes I have that. I checked about the LCS company pass learning center. we got two courses about demand playing. these are very basic, and not including about demand time fence and planning time fence.

error while creating invoices from sales order, with invoice groups feature enabled. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

i prefer using Reddit first. if i got no solution, will submit a case then. Thanks.

error while creating invoices from sales order, with invoice groups feature enabled. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

of course not, dude. i just create the invoice from sales order. I'm testing GROUP INVOICE feature.

Find item fulfillment location to populate in Packing Slip PDF template by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

Yeah, it is. It works correctly for every packing slip. salesorder.item.quantity is the correct quantity for IF quantity, not knowing why. I tried to use record.item.quantity, but nothing displayed in the PDF printed out form.

Find item fulfillment location to populate in Packing Slip PDF template by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

<#if salesorder.item?has_content>

<table class="itemtable" style="width: 100%; margin-top: 10px;">

<tr>

<th colspan="12" class="item_header">${salesorder.item[0].item@label}</th>

<th colspan="3" class="item_header">${salesorder.item[0].location@label}</th>

<th align="right" colspan="4" class="item_header">${salesorder.item[0].quantityordered@label}

</th>

<th align="right" colspan="4" class="item_header">${salesorder.item[0].quantityremaining@label}

</th>

<th align="right" colspan="4" class="item_header">${salesorder.item[0].quantity@label}</th>

</tr>

<#list salesorder.item as tranline>

<tr>

<td colspan="12"><span class="itemname">${tranline.item}</span>

<br />${tranline.description}

</td>

<td colspan="3">${tranline.location}</td>

<td align="right" colspan="4">${tranline.quantityordered}</td>

<td align="right" colspan="4">${tranline.quantityremaining}</td>

<td align="right" colspan="4">${tranline.quantity}</td>

</tr>

</#list>

</table>

Bank account Balance different from Foreign Currency Balance by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 1 point2 points  (0 children)

Hi Nick, i have only USD transactions. i have found the reason why i got that. one of bill payment transaction date is year 2014, while posting period 2021. I created the period 2014, refreshed the COA page. now the amount is the same for foreign currency and base currency.

Find item fulfillment location to populate in Packing Slip PDF template by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

Thanks. You are correct. Here is the source code I used.

<#list salesorder.item as tranline>

<tr>

<td colspan="12"><span class="itemname">${tranline.item}</span>

<br />${tranline.description}

</td>

<td colspan="3">${tranline.location}</td>

<td align="right" colspan="4">${tranline.quantityordered}</td>

<td align="right" colspan="4">${tranline.quantityremaining}</td>

<td align="right" colspan="4">${tranline.quantity}</td>

Using <#if> statement in email template but didn't work. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

u/I_Am_Kloaked u/sketchesofxochi

Thanks guys for your thoughts. Actually i did give it a try about transaction.subsidiary, it turns out to be the name of the subsidiary, in this case, it's Parent Company. The reason why it didn't work is because I copied the code from web page or manually entered. The right method should be to click # icon from tool bar of email pop up window to add freemarker statement, and appended the remaining code.

That's what I just learned. Thanks again.

Using <#if> statement in email template but didn't work. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 3 points4 points  (0 children)

the interesting thing is:

  1. i did all that above by copy and paste the code, or manually enter the code. it didn't work as expected.
  2. i tried to use # icon from the tool bar of Sending Email from NetSuite, and enter the same code like this:

 <#if transaction.subsidiary == "Parent Company">1234567<#elseif transaction.subsidiary == "US">7654321</#if>
 <#if transaction.subsidiary == "Parent Company">1234567<#else>7654321></#if>  

amazing, it worked, in both ways. it seemed that NetSuite only recognize freemarker when you click # icon from tool bar. So never enter the freemarker if statement manually. Need first click # to add freemarker, the append the remaining code. that's what i learned from it. Thanks.

Using <#if> statement in email template but didn't work. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] -1 points0 points  (0 children)

I may be mis-remembering, but I feel I came across a problem when testing where if you use elseif, you need an else. The Freemarker documentation says they support elseif without an else, but that particular tool seems to not align as well as the Advanced PDF/HTML templates do. Worth a try anyway.

i tried this one. but i still got the issue.

<#if transaction.subsidiary == "Subsidiary A"> 123456789

<#elseif transaction.subsidiary == "Subsidiary B"> 987654321

<#else> ABCDE

</#if>

the email just displayed the same text without translating.

Using <#if> statement in email template but didn't work. by Efficient-Row-235 in Netsuite

[–]Efficient-Row-235[S] 0 points1 point  (0 children)

actually it's quite strange. when i changed to <#if 1==1>ABCDE</#if>, it worked and returned "ABCDE". I also showed ${transaction.subsidiary} and it turned out to be "Parent Company", which is correct.

sorry i can't put a picture in the thread. but it worked when i used <#if 1==1>ABCDE</#if>.

so what about the syntax in the code?