3948767 Newbie

Still not convinced. What i want to see in the report is show me my aged AR as at Oct 31, net of all subsequent receipts as of todays dates. Why? I use this to to provide external users (auditors) a report which shows how much of year end AR are still uncollected as at completion of fieldwork date. They have visibility…

Yes, Fufillment does muck with Billing Schedules (BS).... Our solution is: 1) have BS at the Header level, not the transaction line level. 2) Require BS to be Manditory. This will necessitate setting up a BS for an immediate bill, such as "Bill 100%, net 30". 2) Move any items which will not be fufilled at same time to a…

We use ADP Canada to processs payroll. We then input a memorized JE which breaks out the payroll by department & all DAS costs. Our plan for this year is to get EDI export from ADP and inport the JE directly. Currently we import only summary data, but with the EDI it s/b possible to import all individual EE data. Hope this…

Yes, I do it all the time. Open your Report, go to Customize, choose Foreign Amount, select Grand Total if needed. This will report the Foreign amount of the Transaction. You can then delete the column with Amount, as this is not needed. Select Preview to ensure this is providing you the report in Native currency (not Home…

Hi All, Sorry to hijack this thread, but on a similar note if I create a budget vs actual report for a user which contains multiple departments, and then share this report with the user, what is to stop that user from customizing this report & changing the departments to ones they should not have access to? Example. They…

Kyle did you find a resolution to this? Hi Amy, No I did not get any resolution to this issue. My interim solution is to write custom reports for each department group & share, and risk that no one changes the report specs. My longer term solution is to purchase the Netsuite Financial Planning module from Adaptive…

Here is the issue. If I sell a 36 month subscription, we set up a RR schedule which deferrs 100% of this amount. The RR schedule then recongnizes 1/36 monthly on a SL basis. For GAAP reporting at say month 4, we need to show Current portion is 12 mths, while LT portion is 20 months. There needs to be some report which can…

I have a similar problem... Need to provide Department heads access to their P&L's & Actual vs Budgets. Want them to have access to be able to drill down to transactional data. We only want them to see their Department. They must not be able to take a report & customize it to view other Departments info (ie. Payroll info).…

Sure NS won't let you print out the report specs, (pain in the ass somtimes), but I put some screen captures in the word document showing what I did. Provide me with an email address & I will send you the file. Cheers, Kyle

Hi all, I just created my own custom Statement of Cash Flows . Not a big deal to do as we had to customize the BS & PL reports anyways. Now I have complete FS package, done the way I want my FS presented. Cheers, Kyle

Hey All, We use ADP for payroll / HR & direct deposit. We then just us a memorized JE to post summary info, by department into NS. Aint to sexy, but it works, Cheers,

Hi All, We are a large NS user in Mississauga. We will have the same issues of setting up new tax codes for HST. Can anyone provide the required settings & codes for the following: 1) Standard (both GST & PST) 2) Meals 3) Exempt (can we use existing code?) Thanks,

We are using NS (Canadian + Software editon & multi-currency) and Adaptive Planning. We now import our monthly FS into AP & report from there. Still some issues with drilling back into actuals data from AP, due to the many to one mapping we initially chose for certain accounts. Also AP still has a bug with NS on launching…

Hey Netsuite, has any further work been done on this issue yet? We use partner commissions module & want our partners to have access to their commission reports via the Parnter Center. When we purchased the produt we were told this was possible. My qwerk is that all standard commissions reports are generated in home…

Hi Evan, We are not out of implementation with NS yet, & have not gone live. I have left this with our project manager, Helen Miller, but have not had any result from her on this issue. Surely this must be a simple setting, else how could a user make a foreign currencey deposit to a foreign currency account without a…

NS case # 837786 thanks,

Got off to a late start, but am now part way through the Adaptive Planning implementation. Hope to be up by end of Nov. Will post status update then Currently commencing Open Air evaluation to replace NS project. Anyone else using OA? Cheers Kyle

Have you found any way to create a project dashboard similar to the customer dashboard that could pull in its budget, the profitability and project data into a "project on a page" view? Are you using the financial budget module for project budgets or did you mock up something else? Hi Amy, No, we have not attempted to…

Yes NS advanced project is very weak! You can assign expenses and costs to a project by selecting the customer field on expense or bill entry, just be sure to select project in these fields. We renamed some of these fields to customer/project to help users. Note that these costs do not show up in the project module,…