Minha área
Comentários
-
That's a good start. Many scripts don't create logs, or only when there is an error, so I'm afraid you'd have to look into those scripts and workflows to check what they are doing. That is, unless somebody else has a better idea what could be the problem.
-
Hello Shunta-san, I cannot reproduce that on our account. Amount and gross amount are re-calculated when I change the quantity as soon as the focus moves out of the quantity field, e.g. by hitting tab or enter, or by clicking on a new line. Works that way both when entering a new vendor bill credit and when editing an…
-
@Carissa: Could it be that you are using Packing Slips (printed from Item Fulfillment) instead of Picking Tickets (printed from Sales Order) for your warehouse? Otherwise I can't reproduce what you're describing. If yes and you don't want to change to Picking Tickets for some reason, you could try using the field with id…
-
In the Results tab, add a column and choose Applied To Transaction Fields... → Document Number That will give you the numbers only, without transaction type & link:
-
@Mikko De La Fuente-Oracle : shipphone is a standard field, but undocumented. I guess it is a shorthand for shipaddress.addrphone. Maybe it is not available for setting directly, I have not tried this myself. But you can look at it by pulling up a sales order and adding &xml=T to the browser address, or by creating a saved…
-
What's the value of phone_number? Maybe that is causing the problem. The field validates for a minimum length of 7 characters. Otherwise, posting the relevant parts of your code would help. Since you're not mentioning any errors, I take it the script is being executed, but the field value remains unchanged, right?
-
The easiest would be to use the indexOf function which is meant for normal strings instead of search which is for regular expressions: if(Tags[i].indexOf('+') != -1) To use search() and escape + you should provide a regular expression, not a string. Then escaping the + character should work as expected:…
-
We've had exactly the same issue a couple of times already, only workaround I've found is pretty involved: warehouse deletes the associated pick task within the wave if already picked, need to change picked quantity back to 0 & reset status to ready first change the quantity of the item that is to be deleted to 0 on the SO…
-
Setup -> Sales -> CRM Lists In the filters, change type to Lead Source. Click New
-
Assuming that the complex formula you're currently putting in those 3 locations is identical, you should be able to simplify it to only 1 like below: GREATEST(0, CASE WHEN {type} IN ('Invoice','Cash Sale') THEN 1 WHEN {type} IN ('Credit Memo','Cash Refund') THEN -1 END * ([complex formula here])) Edit: On second thought,…
-
That's CSS styling so it requires an Advanced PDF/HTML Template. It is applied by the class="even" and class="odd" attributes. The styling itself is stored in a CSS file which I link to in the <head> of all our templates. Sorry I hadn't read properly through the entire thread and somehow thought you were looking for an…
-
Did you try that for both transactions or only for Sales Orders? I'm asking because this field exists ONLY for Item Fulfillments (as far as I could find), it does not exist for Sales Orders. For other transactions (e.g. Estimate, Sales Order, Invoice) I'm using the below code in our templates which works by checking for…
-
We had the same requirement, I made an Advanced PDF/HTML Template for it that comes out like this: Components are indented and have an icon to mark more clearly. It keeps the same line background colour for the kit and its contained components, whereas normal items have banded rows with a different colour for each item.…
-
Have you checked if the leading zeros are really missing from the .csv file by opening it in Notepad / some text editor? I ask because Excel will often remove such zeros by converting the text to a number when you open a CSV, at least if you don't specify the column's formatting as text (using the Data -> From Text/CSV…
-
Thanks, I hadn't tried that, getContact() works like a charm. Didn't know about that function, because it's not listed in the documentation for nlobjContext (SuiteAnswers 10261). Would be good to add, so others don't have to search around as long as me.
-
Hello Mikko, thanks for the reply. I've cast my vote, but sad to hear that's the only thing I can do now. From my experience for such low priority enhancements nothing gets changed for years, i.e. probably never. Judging from the number this one is a few years old already. If anybody has an alternative workaround that…
-
A different workaround I've found to work is to use the HTML align attribute instead of CSS styling, i.e. <td align="right"> <span ...> ... </span> </td> Normally not the best way to style your documents, but in this case it's actually a lot more concise.
-
Well, the scripts wouldn't be that complex really, I think the required steps would be as below: * create a new custom record type (e.g. "Product Category") and give it fields "Prefix" and "Current Number" (or more if you want other behaviour, similar to the Set Up Auto-Generated Numbers screen) * set up your categories as…
-
nic_reg_01 wrote:What we would like to ensure as well is the continuity of reports even after performing this change. That's going to be tricky for e.g. Sales by Item reports, because the old items will be a separate set of data from the new items. One possible workaround is to make the new items parent items of the old…
-
You can do that by embedding those 2 tables into another table, e.g. like this <table width="100%" class="sidebyside"> <tr> <td width="60%" class="leftside"> <table width="100%" class="leftside"> ... </table> </td> <td width="40%" class="rightside"> <table width="100%" class="rightside"> ... </table> </td> </tr></table>…
-
On a related note, is it possible to create stand alone invoices and credit memos without affecting the inventory? And without a workaround like using a service item and putting the actual item details in the description? Sometimes if an item was invoiced at a wrong price and the customer claims it only later, we need to…
-
No, in that case you will need to enter a new purchase order to be able to receive it again. If you notice this kind of mistake in time, the easiest solution is to edit or delete the wrong item receipt. Then you can enter the correct item receipt later as required. Not sure if there was some additional communication with…
-
Formulas are according to SQL syntax, so you need to put strings in single quotes and concatenate by the || operator. Have you tried the below? <%=Case when {custrecord_muv_customer} Is Null Then 'SomeText or the actual FieldName: ' || {custrecord_muv_contact} End%> I haven't used this particular feature yet but would be…
-
Would it work for your requirement to use the standard approval feature of sales orders? I.e. leave the order as "Pending Approval" when entered and only click "Approve" when the order needs to be fulfilled? As long as the status of sales orders is "Pending Approval" no stock is reserved.
-
We had the same requirement, because we frequently get partial shipments from our main supplier, so each shipment usually consists of 1 main order plus 4-5 back orders. We used the "Bill Purchase Orders" page before, but then you get a list of ALL open lines of the selected POs which can be >100 lines in our case. That's…
-
As an alternative, you could add a custom check box field (e.g. "Notified", make sure to activate "store value") to the records you're searching and filter your saved search to records where this field is not checked. Then add a routine in your scheduled script to set this new field to checked ("T") for each record that…
-
Regular expression should work well for this, not sure what you've already tried that gave you errors, but maybe try this: REGEXP_REPLACE({trackingFieldID}), '^([0-9]+)[^0-9].*$', '\1') Or if the tracking number can contain letters, add that to the expression accordingly: REGEXP_REPLACE({trackingFieldID}),…
-
The ID mentioned in that SuiteAnswers article is basically optional, because NetSuite will assign a unique ID automatically if you leave the ID field blank. As Robert has mentioned you might want to set an ID yourself to be more memorable/self-explanatory if you plan to reference the search using SuiteScript, but otherwise…
-
You need a client script to do this, SuiteAnswers #66632 has the required code and deployment settings: https://netsuite.custhelp.com/app/answers/detail/a_id/66632/
-
Can't test it right now, but I think it should be as straightforward as this: <#if item.itemtype=='Discount'>${item.amount}<#else>${item.rate}</#if>