3954539

This appears to be based on percentages. Is there a way to have it post actual costs to each subsidiary, respectively?

in Intercompany Payments - Vendor Bills Line Entry Comment by 3954539 Dec 22, 2014 6:32PM

that 2nd one worked perfectly!!! thank you very much!

in Search Truncate Field result Comment by 3954539 Feb 16, 2018 12:23PM

I'm not sure I'm following that. I need it to look at a character in a custom field. I tried LTRIM(: [, {custcol_item_for_je}]) and it isn't working thoughts?

in Search Truncate Field result Comment by 3954539 Feb 16, 2018 11:29AM

I just tried to add the quick search but when I type in an internal ID that I'm looking for it doesn't work that way. If there was a record type of internal ID it would probably work.

in Creating an INTERNAL ID lookup SEARCH Comment by 3954539 Jan 21, 2016 9:29PM

Yes, I do show internal IDs. The issue at time is that some filters, criteria, CSV responses will only give you the internal ID and you have no idea what it is. I thought there may be a way to create a record search of some kind with internal IDs as the filter where I could drop one in and it would tell me what the record…

in Creating an INTERNAL ID lookup SEARCH Comment by 3954539 Jan 21, 2016 5:31PM

I am invoicing a SO. I just need to be able to find the needle in the haystack of which ones to invoice. For example, we may have 1 sales order with 12 lines, 1 for each month of the year. We would want to be able to generate the 1 line on that sales order that is related to April, for example....but I need to be able to…

in Auto Generating an Invoice from a Sales Order Comment by 3954539 Apr 7, 2017 12:03PM

Thanks all. This worked perfectly.

in Void a Bill in a Prior Period without effecting Prior Period Comment by 3954539 Jan 16, 2015 9:51AM

System notes do not exist on time records apparently. It isnt an option on a Time Search

in Show time records that have been changed Comment by 3954539 Jun 11, 2015 11:36AM

I was trying to create a similar search to be able to show me time records that were either created or modified after 5/31/2015 but the issue is I can't find out what was modified. This issue would go away if Netsuite would even lock down time entry like they do for AR/AP. Any constructive criticism is appreciated.

in Show time records that have been changed Comment by 3954539 Jun 10, 2015 2:48PM

Thanks for the input. I'm very new at script writing. Is there any class that Netsuite offers that I could get a good 101 on the subject?

in Setting a field at the line level = Mandatory Comment by 3954539 Jun 2, 2014 9:15AM

Per the Field Help it almost makes me think that a user in that department can only access it....does that mean write POs to that one department. See below? Or is it like you said, links transactions to the one account to the one department? Select a class to restrict use of this account to roles with permission to access…

in Linking and Account to 1 or more Departments Comment by 3954539 Nov 21, 2013 12:05PM

Hi Jeff, You can specify a custom income statement detail report on your custom income statement. Once you are done on customizing and saving the custom income statement detail report, access your custom income statement report and Under More Options, there is a Drill Down Report dropdown and select your custom income…

in Custom Income Statement Detail Comment by 3954539 Sep 5, 2013 9:21AM

That worked!!! Thanks all!

in Enter a Bill to a Locked Period Comment by 3954539 Aug 13, 2013 8:43PM

If I am not good at scripting has anyone written one to solve this issue? This would make my accounting department's year if we were able to get some assistance.

in Line Item - Department - Prevent Parent Selection Comment by 3954539 Feb 24, 2015 7:01PM

Currently we do not have the franchisees set up as a sub-customer. We have set them up as a custom tab on a parent customer record. We did this because of the 1:1 relationship between a project and a customer. We may have 1,000 franchisees that participate in 1 project and I would rather job cost on 1 project instead of…

in Cash on Account Comment by 3954539 Aug 1, 2012 9:19AM

Bump. Can I get a Consolidating Trial Balance? I know we can get a Consolidating Balance Sheet and Income Statement but not a Trial. Wondering if anyone has any suggestions.

in Balance Sheet and Trial Balance all subsidiaries in subsidiary curr in one report Comment by 3954539 Nov 9, 2016 6:13PM

The standard employee center role has purchase order permission. To read more about employee center and the permissions available please access SuiteAnswers: 1. Login to NetSuite. 2. Click Support tab. 3. Click Go To SuiteAnswers button in SuiteAnswers portlet. 4. Search for Answer ID 30661 or access the URL below:…

in Sales Order - Employee Center? Comment by 3954539 Jan 30, 2015 4:51PM

Hello Jeff, By design Employee Center role do not have Sales Order permission available. Why do they have access to purchase orders?

in Sales Order - Employee Center? Comment by 3954539 Jan 30, 2015 3:06PM

I'm interested in this. I loaded the budget and was able to point the revenue to a customer. How can we show results vs budget by customer on a dashboard?

in Include budgets in KPI's Comment by 3954539 Mar 9, 2018 11:53AM

Its only counting records. You could design your own Employee HC KPI though and improve it. I would like to know how I could create a custom search and improve it. That is the part that I'm stuck with. I would imagine that I could put in a If/Then formula on the criteria tab but I'm not sure. That is the help I'm needing.

in Custom Employee Headcount KPI Comment by 3954539 Jan 29, 2015 12:30PM

Actually you can create that search. The formula will be an IF statement that calls one result if Full Time (1) or 0.5 is part time, Can you write an IF Statement? Ok, I figured it out by using the "CASE {employeestatus} WHEN 'Part-Time Employee' THEN .5 ELSE 1 END" But now on my KPI it only shows Current and it won't let…

in Custom Employee Headcount KPI Comment by 3954539 Jan 30, 2015 12:03PM

Define your criteria first. How will you count or sum the records? Ts the field already there? If not make one. You can get very complex here if you choose to. Where are you currently storing the FTE status of an employee? You may end up creating a custom record and a custom field. In the custom field ou will refer to a…

in Custom Employee Headcount KPI Comment by 3954539 Jan 29, 2015 12:48PM

Thanks for the response. The only question I have is do you put any date criteria in the search?

in Delinquent Time Entry Report Comment by 3954539 Oct 1, 2012 10:18AM

ok, so it's important to run it on a Sunday, right? I ran it today and there were not any values because it is Monday and there isn't any time in the system yet. Does that make sense? So, does the output only show employees who have less than 40hrs in that week?

in Delinquent Time Entry Report Comment by 3954539 Oct 1, 2012 11:12AM

I would also like to know the answer to this. We are about to create 2 more subsidiaries as we acquired 2 businesses and we will have the same client over multiple subsidiaries. I want to know best practices on setting up or reporting on a consolidated level. thanks

in What's the best way to manage contacts across multiple subsidiaries? Comment by 3954539 May 23, 2012 9:44AM

Carl, Thanks for the comments. We have the same 1 entity in 2 Subs, for example. We invoice under 1 and do JEs on the other to get revenue there. We will then eliminate the revenue. The issue with the elimination is that you are not able to associate a JE on the Elim Sub to an Entity or customer record. So, when I run…

in Elimination Subsidiary - Entering Customers Comment by 3954539 Jun 22, 2015 12:18PM

Carl, We have tried the Netsuite consultant path and they just don't understand or perhaps we did not get the best consultant. At a high level, how did you set yours up?

in Elimination Subsidiary - Entering Customers Comment by 3954539 Jun 12, 2015 9:21AM

Oliver, the total revenue is $1,000. The sub invoicing needs to earn $1,000 and the other sub will earn $500 or their share. The sub with the $1,000 invoicing revenue will have $500 of Consulting Expense. Thus we need to eliminate $500 from revenue and $500 from Consulting expense. This is GAAP accounting.

in Elimination Subsidiary - Entering Customers Comment by 3954539 Jun 22, 2015 2:21PM

Below is the scenario that I'm trying to accomplish. DAL, STL, and ELIM all represent subsidiaries. At the end of the day I need to show that Pepsi has $100 of revenue and a margin must be recognized on each sub. DALSTLELIMConsolidatedNet Revenue - Pepsi25100(25)100 Salaries - Interco (50650) 25(25)- - COGS Total-25(25)-…

in Elimination Subsidiary - Entering Customers Comment by 3954539 Jun 22, 2015 3:57PM

I am aware of how consolidations work and I've been down the path with a consultant. Netsuite doesn't appear to follow the laws of GAAP. They have no idea how to eliminate through both the income statement and balance sheet. Each subsidiary that should record intercompany revenues must be eliminated and it would certainly…

in Elimination Subsidiary - Entering Customers Comment by 3954539 Jun 5, 2015 9:13AM

3954539 Green Ribbon

Comments