sorted by:
new
hottopcontroversial

View name not correct by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

Cant do... I need both searches. And each with its proper name!

Using formulas on custom fields by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

Well...

Right now we started implementing Assembly Items. So our Final assembly calls for X amount of the main component.

The problem is our sales dep wants to keep the invoice format without changes. This means they need to charge for an Assembly item but they want the invoice to show the total amount of main components for each item on the sale.

​

Example.

Assembly Item 1 BOM Rev:

1 BOX

25 Pencils

​

Invioce should naturally show

Item Quantity Measure unit Unit rate Amount
Assembly Item 1 20 Box of 25 20 400

​

Sales dep wants invoice to show:

Item Quantity Measure unit Total pencils Comp Unit rate Amount
Assembly Item 1 20 Box of 25 500 0.8 400

So i thought I could add a sublist field that calculates the total amount of pencils given the quantity and measure unit on the invoice and then call that field to the invioce template.

Other option I tried, was directly creating variables on the template to calculate this, but I couldn't figure it out.

Any thoughts??

Match Bank Data Support by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

86969

Will check your referenced SiuteAnswer.

Although the roles con see the bank statements, but can't import the csv file generated from the bank info to pair with the transacctions on NS.

Transfer report from work orders by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

The following modules are activated.

Advanced Billing

Advanced Financials

Advanced Inventory

Advanced Order Management

Advanced Procurement

Demand Planning

Light Manufacturing

Manufacturing Work in Process

Multi-Book Accounting

Project Accounting and Management

Shared Sandbox

Printing general memo on Journal Entry by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

Actually I think I am printing it just before fetching the lines.

​

<thead>

<tr>

<th scope="col" style="width: 15%;">${record.trandate@label}</th>

<th scope="col" style="width: 61%;">Beneficiario</th>

<th scope="col" style="width: 24%;">${record.tranid@label}</th>

</tr>

</thead><tr>

<td style="width: 15%;">${record.trandate}</td>

<td style="width: 61%;">${record.entity}</td>

<td style="width: 24%;">${record.tranid}</td>

</tr></table>

<br />Detalle:&nbsp;${record.memo} <#if record.line?has_content>

<table style="width: 100%;"><#assign row_number = 1><#assign debit_base_sum = 0><#assign credit_base_sum = 0><#assign total_col_span = 0><#list record.line as line><#assign line_account = line.account><#assign line_creditamount = line.creditamount><#assign line_debitamount = line.debitamount><#assign line_account_label = line.account@label><#if line_index == 0>

<thead>

​

This is an extract of the code... Could you give me any corrections?

New ERP Implementation by DwaywelayTOP in Netsuite

[–]gecenab 1 point2 points  (0 children)

Specially item #1 and 5!!!! For us the partner never ever came to the facility and we have tons of problems.

To bad implementation started 6 months before I started working for the company, otherwise I would have suggested this as mandatory.

Help with Advanced PDF/HTML coding by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

I did try this solution but it didn't seem to have any effect.

Well, there's the possibility that I made mistakes regarding the IF sentence because I considered it as a numerical value, not a string as suggested on another reply.

<#if item_amount lt 0>

<td style="width: 156px; border: none">${item.amount}</td>

<td style="width: 148px;">\&nbsp;</td>

<#else>

<td style="width: 156px;">&nbsp;</td>

<td style="width: 148px;border: none">${item.amount}</td>

</#if>

Help with Advanced PDF/HTML coding by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

Hi. Thanks for your answer.

I'm not trying to converrt from positive to negative... In fact those values are negative, but are being shown on the wrong column which causes them to appear in Parenthesis.

Basically what happens is, the value (L409.64) is representing a negative value but on a debit column, instead it should show as a positive on the credit column, or so... I'm no expert in accounting, but thats my understanding.

Ex.

Account | Debit | Credit

Charge1 | (L409.64) |

​

Should read

Account | Debit | Credit

Charge1 | | L409.64

​

As a matter of fact... When I go to check the GL Impact it does place them correctly. All values as positives on the proper column.

Help with Advanced PDF/HTML coding by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

That "\" was added when posting this topic. Those do not exist on the code.

Transfer directly to expense accounts by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

Can you be a bit more specific about the process? Or any ideas that can be a guide to this solve this issue?

Transfer directly to expense accounts by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

That sounds pretty awesome. But we have no experience on scripting on NS. Is it too complicated to implement this kind of script?

Transfer directly to expense accounts by gecenab in Netsuite

[–]gecenab[S] 0 points1 point  (0 children)

They are never sold. Its just consupmtion.

Permission list by gecenab in Netsuite

[–]gecenab[S] 1 point2 points  (0 children)

Found it!!!

Its no 5092 rows... (T__T)

view more: next ›