GauravAgrawal Bronze Crown

Hi @Kevenale , While this should have been straight forward pick from address but at times it doesnt pick the right value and chances that vendor can have multiple address as well. However, try the below formula to fetch the value. Formula(Text) : CASE WHEN INSTR({billaddress}, CHR(10)) > 0 THEN SUBSTR({billaddress}, 1,…

Hi User_LTXRR Can you confirm if any location is created against Subsidiary P F2 VA LLC.

C

Hi Team, Since this is little late India time I will not be able to join this time but would like to check on below query : In OneWorld accounts with 100+ subsidiaries, the subsidiary filter on financial reports has a narrow dropdown that makes selection cumbersome. How have you designed workaround for this

Hi User_M40SJ, Can you explain why do the business need to add 13000+ lines on single transaction. Is there a possibility to consolidate the lines. Even if you split the SO in 5000 lines each it will break the script validation and will have drastic impact on reporting. If you plan to invoice them, it could also be…

Hi Ckirk, Unfortunately this is a known limitation in NetSuite which doesnt allow both posting and non posting type item on same transaction.

Hi @Nilesh.Gupta You cannot change the customer on project once its in progress and work is done. Recommendation would be to close the project and create a new one with right customer.

Hi User_LTXRR Inventory adjustment needs to have a location as mandatory as you are transfering your item from one warehouse to another for tracking purpose. Are you manually creating inventory adjustment. If yes, did you select the location field.

Hi User_QUBD1, NetSuite converts foreign currency balances to base currency using the exchange rates on the transactions, and in OneWorld, subsidiary base currency amounts for consolidated exchange rate. The amount is calculated based on your parent subsidiary exchange rate. Check for any exchange rate between Tanzanian…

Hi Vernita, For department, you can reverse the amount using JE by tagging the department and Subsidiary. Deletion of record can be done, however please check if there are no scripts triggering on Bill payment which sends any notification to vendor on create or any approval process set. Also there is no link for vendor to…

True

Hi User_FJEEG, Can you clarify the saved search you want to run using Employee center. Employee center is restricted role and based on permissions can run the searches but will the results show depends on permission.

This folder ID 5 should work for now. Let us know if the error still persists.

Hi User_ZMPB4, Great point out. The table calculations are wrong or just a typo mistake. It would be to best test it in Sandbox to see the actual result. High level Four issues: Cumulative column doesn't add. 190 + 450 = 640, but the table shows 650. Table 2 on the same page uses 110 GB for month 2, which makes 200 → 650…

Yes, I would recommend go through LCS license or buy few from your Account Manager. Its the best platform to learn NetSuite from basics to high level to sales demo.

Hi User_MJ2UW, Does your company has NetSuite LCS license. If yes, I would strongly suggest to go through it. It has all the videos you would need to learn NS functionality. If not, You can download user guides from NetSuite HELP centre and go through it

Hi @Vernita if the period is open you may think of deleting them. However you are right it would impact reconciliation and also mark the bills as open. I would suggest pick a cutover date. Leave closed, reconciled data as is and then: Move the historical balances to the correct subsidiary with journals (intercompany or…

Hi Yee Yie, Can you confirm if RFQ currency, subsidiary and vendor matches

Do you only want to keep the Check# blank for certain bill payment right. In that case since auto numbering is enabled, created a custom workflow to make the field as blank on submit of record. You would need a unique identified or may be checkbox.

@Hi @Dext3r Can you confirm if the POs are still due. Also the screenshot says it can only be edited by admins. Are the users trying to modify the result. I had a similar issue but when modified the ALLOW AUDIENCE TO EDIT under AUDIENCE tab on saved search was checked it showed expected result.

Yes, can you try adding by giving VIEW level permission and check if the field is visible.

Hi User_FJEEG, All timesheets as best practice are always submitted against a project and not a customer. 1 customer can have multiple projects but 1 project can be tagged to only 1 customer. Thus when you submit a timesheet, you would always select a Project on customer field but the criteria will pull data from Project :…

Hi Vernita Yes, it works for us. Can you check if below 2 steps are checked for you Go to Setup > Company > Enable Features and click the Accounting subtab. Under Advanced Features, select Exception Management Models and Exception Management. PS : I have at times had to unselect all filters like in your case accounting…

Hi User_YKBKX, Vendor statement is currently not supported by NetSuite. You can either modify the A/P Register report or create a saved search.

Hi User_BCKYD Does your role has permission to edit accounting period.

Hi ReddishMiles, This time voucher are shared by your AMO. Please reach out to them for vouchers.

If thats mandatory to provide external Login, can you redirect the update to custom record and confirm with client before updating the actual master. May be you can put some mandatory field for customer to enter details on suitelet.

Hi, You can create a saved search on item master with following details : Criteria : Type as Invoice or select any other transaction. Main Line as False Tax Line / Shipping Line as No. Cogs Line = No Result : Transaction: Date grouped as Maximum

Hi Elina Kourouzidou, Can you try using summary in search results. Group by Date, Memo(main) and Document number. Replace amount with amount(Debit) or amount(Credit) and use summary as SUM.

Hi User_66SWC, Does your customer master has contact details stored and do the contacts have access to NetSuite. Does your customer center role has permission to edit Customer Profile which could be issue?