3944633 Newbie

You could easily create a script to set the dynamic field value when a component of the dynamic field changes (or on save). That will solve both problems. Something like: function onFieldChanged(type, fieldname) { if( fldname != 'somefield'|| fldname != 'someotherfield') return; var newValue =…

I believe you are correct about hours. You will need to use hours (24, 48, 72 ..... 192). At least that is what I needed to do for escalation by days. I hope that helps. =r

You might try this: Viewing them in list view, make sure "Enable List Editing" is on. Check "Show Inactives". Click the first "Inactive" check box. Hold Shift key and click last "Inactive" check box of those to delete (limit to about 25 at a time). This selects them and should create a dashed line box around the inactive…

Please see my post on creating a report to reconcile the Inventory Received Not Billed account. https://usergroup.netsuite.com/users/showthread.php?t=11335 I hope that helps.

Evan, RE: Case #650000 Update : Defect 135746: This Case needs immediate attention. The results of this problem are manifest in numerous areas for the client. He is VERY upset that these problems have not been resolved. Although reported 9 months ago, this problem is evident in his account beginning in August 2007. This…

Thanks Evan!! You ARE the man! Best regards,

It appears that this is being assigned multiple cases and defect numbers. Could this be why it is not getting the proper attention? Our case # 650000 (yes that right - opened in Novenber 2007), defect # 135746 is status S2 and has been open for over 8 months. In the meanwhile financial statements to the banks are…

Going forward (or back), I recommend reconciling the account on a regular basis. How do you do that when there is no report for that? We created a report to assist with the reconciliation. Recipe is as follows: Base report: Reports > Financial > General Ledger Columns: 1) Register Transactions: Created From - Check Group…

We also have an open case #678414 on this matter. When switching to Multl-location inventory the following occurs after distributing the inventory: 1) Inventory status reports are incorrect. 2) Inventory valuation reports are incorrect. 3) Inventory item > Inventory tab shows incorrect quantities and values. 4) Inventory…

Julie, If you change the name in the Item record, all associated transactions will have the "new name" of the item displayed, historical and future. I'm not sure how this effects your vendor purchasing of these items. Are they correct with the vendor (122 = 122 at vendor)? Perhaps test by renaming one of the items and look…

Julie, Sounds like fun! ;) Need a little more info to be able to respond. Parts in same asssembly? Parts purchased/ordered/received as correct part? How many transactions? Financial impacts? Probably should consider fixing for going forward only (depending on financial impact). Creating new items & assemblies and adjusting…

Not going to add much here, but I see several alternatives: 1) Use the notes fields in v 2007 (doesn't resolve everything). 2) Put the newest at the back/ oldest at front (Grocery stores do it). 3) Mark items in some way - with a grease pencil, a sticker with date and/or cost (Restaurants do it). In any event, it is a…

I believe that a credit balance would be Accrued Liabilities (or Accrued Accounts Payable if you will) and if the balance is a debit, it would be Prepaid Expenses, assuming that the account is in balance (see below). The key to this account is the balancing of it on a regular basis. Let's say if 100 of an item is received…

Angela, Coster, Thanks a bundle!! :) I was able to get close with the search Coster suggested and I added another footer filter Item Fields (linked table): Serial/Lot Number. When used in the footer and entering the same serial in both fileds, I get the answer. This is bit awkward for the client, to say the least (entering…

NetSuite does provide for that functionality currently. However, there are several options to achieve this. Simplest will be custom fields and custom search with alert. 1. Custom entity, currency type field on Vendor record for "Minimum Purchase". 2. Custom transaction body, currency type field that sources from field 1…

Latif, Thanks for the rant, we've all been there. Now, can you take a deep breath and kindly tell us more about the search? Thanks, and have a fun day! :)

Thanks Evan! Still getting used to the new stuff. :) Have a fun day!

To get the details and the summary, you need to use a result column that is unique, such as Transaction number or entity and use "Group" as the summary function. You will need to use a summary function on all columns that you wish to appear in the search. Hope that helps. :)

Thanks for bringing this up! This has been a problem lately for me as well. I would think Admin would be able to see them/edit them. Weren't we able to in the past? I have the same issue with custom reports for all the reasons you mentioned.

We have typically used JavaScript to calculate and populate a custom field on the Sales Order that prints on the Picking Ticket and Invoice. This field can contain the number of lines/items and/or the total quantity of items. Is that what you are trying to do? best of fortunes ;)

I agree that this is the NetSuite prescribed method. However, this is not the way people in business handle credit cards and Accounts Payable. The likely scenario follows: The CFO wants to know how much is in A/P and/or how much are cash requirements. So the Controller answers "Here is the A/P report filtered for due dates…

Yes I agree there are workarounds. All out clients use them (because you have to). The main point I make is that while one can transfer amounts from the credit card account(s) to A/P in any number of workaround methods, the ONLY reason one has to do a workaround is because the transfer method of using a Bill entry doesn't…

In version 2007: Setup > Accounting > Accounting Preferences - Expand Account Lists In version 11.0.6: Setup > Accounting > Setup Accounting - Accounts Tab - Expand Account Lists You have to have role permission level to Setup Accounting or be Administrator. Hope that helps. :)

Bob, Uncheck the "Store Value" box on the custom field. I forgot to mention that.

Jim, Try this. It took me weeks to figure out this one. I'll send you the bill. :) Custom field: type: Text Area; size: 40 x 3; default value: formula; Store Value = false; Display Type = Disabled; Subtab = Main. {shipaddr1} || NVL2({shipaddr2}, ' ' || {shipaddr2} || ' ', '') || ' ' || {shipcity} || ', ' || {shipstate} ||…

Just a quick observation: in field custevent_case_dnsserver1, Store value = No means it is not stored to retrieve in a merge. Store it and it will merge. Hope that helps. :) p. s. I sense your frustration in your posts. That explict expression tends to hold people back from assisting you in this user group. :)

Click the Help link in NetSuite and navigate to the SuiteFlex section and the SuiteScript subsection. Also, there are a "million" posts in this newsgroup on SuiteScript and customization with sample javascript code. Hope that helps. :)

Jay, You could do several things: 1) Write a script to total the Cartons on save (or on change to see the total as line quantities are entered) and put in a custom field to print in the Body section of the transaction form. Something like: function onSaveFulfillment() { for( var i = 1; i <= nlapiGetLineItemCount('item');…

There are several methods to update multiple records: 1) Lists > Mass Updates > Mass Updates. Select criteria and fields to update. 2) To update Sales Rep: Setup > Sales > Territory Reassignment. 3) In a list view of records (i.e. Customers), click "Enable Editing". Editable fields will have a Pencil symbol by the field…

Consider using a Description type item. If you are not printing the item ID column this will work great. If you are printing item ID, item can be named ".", or "-". Also you can add spaces between items at Setup > Company > Printing, Fax & Email Preferences: PDF's section. Hope that helps. :)