here is the list of button ids in NetSuite - this will help everyone Button UI Label Button Internal ID Add Items addmatrix Accept accept Accept Payment acceptpayment Apply apply Approve approve Approve Return approvereturn Authorize Return return Auto Fill autofill Bill bill Bill Remaining billremaining Cancel Order…

You need to enable location wise numbering or subsidiary wise numbering to have different prefixes for transactions

i think sburk meant transactions entered in a month but period not matching the date i.e. transaction date : Jun 6 2017 but period is July 2017. if this is the case create a saved search on transactions with the following formula : CASE WHEN TO_CHAR({trandate}, 'Mon YYYY') = {postingperiod} THEN 'Yes' ELSE 'No' END This…

During an unapproved bill the GL Impact is non-posting and only during approval the GL posting changes to a impacting transaction and thats the reason you get the message. As Mike suggested you can set the accounting preferences.

NetSuite manages this automatically and the difference between currency rates is recorded under Realized Forex Gain Loss account. This JE is created by the system during period close. You can view it under Realized Gain Loss report.

Use amortization schedules in which you specify the dollars/percentages & period. Link this to item/account and this will generate the entries every month and make accruals.

I had a similar need and ended up implementing easily by creating the Customers locations as Shipping Locations in NetSuite, that way I did not have to create so many customers which are not required anyway as they are just delivery addresses which are neither billed nor needed. Create the HQ as the customer with a default…

there is no payment schedule in NetSuite so the possibility of that is ruled out - i had a similar scenario and used SO for creating the 100K record and billing schedule to bill 20K every month, since you would want the revenue to be recognized when the item is shipped and not when billing is done, for this you need to…

with advanced rev rec you have an option to Defer Until Item Delivered – Until this item is marked delivered, the revenue recognition of this item is deferred. This setting is the default for this field. there are many options to defer until bundle delivered vsoe pricing and many more. hope this helps.

we had a similar need and could not get the accountingperiod record, strangely netsuite has taxperiod exposed in api library but not accountingperiod object, we created a custom replica record of accounting period in which we had a linked accounting period dropdown, so we use to search on this by filtering accountingperiod…

Goto transaction form PDF layouts - Pick the Check layout template - Select Memo field - On left side Element size - set to zero height and width. This should take care of it .

it is a netsuite module and needs to be enabled under enable features - customization - gl plugin - go through the documenation in suiteanswers before implementing it

there are two ways this can be addressed - a. use the Custom GL Plugin to negate the COGS impact and realize the cogs during invoicing - b. use advanced revenue recognition to recognize revenue on fulfillment (through sales order) so gl impact is dr. unbilled cr. revenue and when bill is raised it removes from unbilled…

there are 2 permissions now with employees - goto the role and permissions tab - lists - here you can see employee record and employees - give the appropriate permission to the role and it should work. this has been introduced recently.

you need to sign out completely and log in again, mostly this updates the role storage cache, else try hard refresh Ctrl-f5

i have solved this already - first you need to search on all employees and then sum of actual time so that even if some one has not entered time reflects in the report. if we search time records than only the employees who entered time will be picked. here is the formula i use to search all who have entered less than 40 or…

alternatively try -> case when to_char({time.date},'IW') = to_char({today},'IW') then {time.durationdecimal} else 0 end the full string starting with case till end has to be there.

hello everyone, we are in the same boat now implementing NS and wondering if we should go the timetrack or the timesheet route ?? any pointers if the issues have been fixed in 2015.1 anyone started using this successfully, one pressing need that we have is to use suiteflow and scripts to customize time entries which seems…

you will have to first import the parent records so that they exist and then the child else import will fail

One tip that I use is prefix any numeric/date string with ' a single quote - this will make excel mark it as text and it will not convert it to anything else automatically. hope this helps.

better to import these as 'write checks' transaction using bank account using which these were paid - this will hit the right accounts and also record for vendor

Yes, this can be done using workfow, in the approved state give a trigger on edit and check for old total and new total variance, if it exceeds 10% than transition back to Start state else stay in approved state.

you will need the check the logs to see if the assets have been generated, the issue with FA module is it is very silent and mostly does not give appropriate messages and difficult to track - you can check under FA->back ground process-log list to see if there are any errors

A good idea would be to enter the same as amount column in quantity and rate as 1, so that the total amount is same. When you create bill from PO enter the partial amount in qty column this way you can enter multiple bills against same PO. NetSuite maitains the data by quantity (not by amount) for maintaining PO / Bills /…

make sure you have created the right set of intercompany customer and vendor - double check on the 'represents subsidiary' field - this is mandatory for intercompany transactions

we are facing the same issue - it seems like a bug - have already logged case and had a couple of sessions with support. its not resolved yet.

it is solved after updation of FA bundle by support so you too should log a case and get the bundle updated

Here it is for your reference : [h=2]Feature-specific, System-generated Accounts[/h] The following table provides the feature and respective system-generated accounts. Feature System-generated Account A/P (Payable) Accounts Payable [h=3]Note[/h] Depending upon your NetSuite Edition, the account may be named Acct Pay. A/R…

i have worked with transaction as high as a million records and did not have any issues with rev rec schedules, you can verify this with NetSuite too, hope this helps.

You can create a Custom Billing Schedule - and select 28 and days in the count and units sublist. you can even have it based on different dates intervals weeks and custom dates.