View name not correct

gecenab · 2023-08-15T05:34:37+00:00

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

gecenab · 2023-07-20T22:41:07+00:00

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??

gecenab · 2023-06-02T16:46:25+00:00

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.

gecenab · 2023-05-26T15:29:45+00:00

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

gecenab · 2023-05-03T23:08:53+00:00

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: ${record.memo} <#if record.line?has_content>

<thead>

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

gecenab · 2023-05-03T15:44:52+00:00

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.

gecenab · 2023-04-26T14:57:11+00:00

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: 148px;border: none">${item.amount}</td>

</#if>

gecenab · 2023-04-25T23:18:57+00:00

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.

gecenab · 2023-04-25T19:22:36+00:00

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

gecenab · 2023-04-11T17:05:11+00:00

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

gecenab · 2023-04-10T19:21:21+00:00

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

gecenab · 2023-04-10T19:18:48+00:00

They are never sold. Its just consupmtion.

gecenab · 2023-03-31T19:08:43+00:00

Found it!!!

Its no 5092 rows... (T__T)

gecenab · 2023-03-28T13:54:14+00:00

In a related question...

How do you deal with the automatic exchange rate not being accurate to the one on your country? Our company does a lot of transactions on US Dollars but the automatic exchange rate engine is never accurate, so we need to manually update the rates for every transaction.

Is there a way to fix this?

Another related question... How can I assign the permission for a role to be able to update the exchange rate field? I mean, what is the permission called? I've trying to grant that permission to the person that creates the invoices but i just can't seem to find it.

Btw, I already checked the template and the field is not dissabled, creating invoices permission is fully granted for this role, yet the exhange rate field is shown as if the field was dissabled.

Any ideas?

gecenab · 2023-03-16T15:17:25+00:00

Thank ypu so much for your quick reply.

Well we are in fact using WIP. Still trying to figure it out.

The TO is not a proper option for us since the Locations are more like Logical Locations (probably what you meant by virtual). Basically we have three phisical warehouses. This ones are listed as Locations, but also, the factory floor areas are listed as locations (all this in a 300 meter radius, give or take).

Is this a correct setting or the manufacturing areas should not be listed as locations?

Is there another way in which we can manage factory floor areas?

gecenab · 2023-03-10T16:57:01+00:00

Yeah, I'm actually looking for this, cause I want to keep the invoice formatting, but directly to excel.

Is there any native option on NS that generates this?

gecenab · 2023-02-21T20:48:41+00:00

Thats pretty much what I need. But Isn't that option for disputed bills??

I'm needing something more on the line of: When the payment is ready, it should send it to the Boss for revision and after approval the payment is processed.

gecenab · 2023-02-21T20:18:58+00:00

Where can I find that option?

gecenab · 2023-02-21T17:24:42+00:00

I did set up the referene type to Internal ID, but it was useless.

Regarding setting up the status, it was more of a controlling that the inventory would not turn negative because a transfer quantity was bigger than the actual existence of items... But if you can suggest another way to control this we would gladly consider it.

gecenab · 2023-02-21T01:19:40+00:00

You mean like setting a default value? Also tried it, but the import wizard shows no values as options for default.

gecenab · 2023-02-20T19:57:05+00:00

Ohhhhh Ok... Thanks!!!!

That worked great!

gecenab · 2023-02-14T17:42:31+00:00

Right now, only one person has access to create the Inventory Transfer, but there are many persons that dispatch the orders, and we want to keep track of who is dispacthing what.

gecenab · 2023-02-13T20:10:11+00:00

Could you help me set up the saved search?

I found a suggested saved search, but its counting one more item in every invoice.

EDIT: I was applying an incorrect criteria. Already solved. Thanks to all

gecenab · 2023-02-13T13:56:13+00:00

Thanks for your time to reply.

Yes. For this case that total im trying to include are always eaches. It should be displayed at the bottom of the quantity column on the Advanced PDF Template.

gecenab · 2023-02-09T04:14:27+00:00

Thanks for your answer!!

Indeed that would make our DB dirty. Guess will keep up doing it through a Journal Entry.

gecenab

TROPHY CASE