Hi @User_RRIOM Can you click on VIEW hyperlink under NEW VALUE to see the change. Other reason can be was there any account change on item master. Change of account on item master has retrospective effect in NetSuite.

Hi @Mathias_Netsuite Pls check if there is any script or form level setting. By default users are allowed to select posting period on vendor bill.

you can set the external ID but try on afterSubmit mode irrespective on create or edit mode.

Can you run the search result with document Number, and write a formulae(numeric) = {netamount} - {taxamount} + {taxamount} . I had to add taxamount twice due to some tax amount showing in negative. Does this works for you?

This is interesting to analyse! I have couple of queries : Do you have 2 employee ID with 10011. This question is because On the screenshot attached I do not see employee name Fan Zhao as well as email ID as blank. Could there be possibility of another employee record created for user with 10011 ID. One being active and…

You can deploy a script on Journal entry which checks if any line contains BANK account type, if yes a custom checkbox can be marked as checked on body level. This checkbox field can then be used in saved search to pull all the GL lines.

HI, you can create a search on Journal with filter as Account Type as Bank.

you will have to run a loop in sequence against each line item where item = A1 and keep adding the quantity. Repeat this for all line items. Trick here would be to skip the line which already has item A1. So at the time of running FOR loop against an item, check if item is already considered previously or not.

you can try using NetSuite approval 3 way match and check if its fit your requirement. However, do note if not fulfilled, NetSuite supports SuiteScript wherein you can design the entire approval flow as per your own requirement.

Hi, you should be able to import project with project number tag JOB ID field.

you will have to do the payment in Bill currency followed by Bank transfer between 2 bank accounts basis exchange rate.

Since this is secondary book it impacts the GL accounting. If you are not able to open the JULY period, you will have to manually pass JE to adjust the values.

HI, this is not possible as standard functionality. However, if you need a customization/script approach can be designed. A custom record with relevant field can be created and updated with required billing schedule fields and tagged to respective Sales order.

how about adding the criteria in Saved search to ignore the Sales Order with IDs you need to update or inactive the search when you are updating it.

are you referencing to NAME field on Journal entry line. If yes, try MAINLINE NAME field to source the line level data

Hi, For Issue 1, you can hide the button using script till the time PO is not approved. For Issue 2, NetSuite has a standard TO BE EMAILED feature which send the PDF directly to vendor email address. You can write a workflow to mark the checkbox as checked as soon as the PO is approved. This will reduce the manual…

Its a suiteSuccess bundle. You can directly reach out to your Account Manager for enabling the bundle. Please check with Account Manager if this needs any licensing as well.

Hi , Are you facing any issue. Ideally if you have quantity remaining at the time of Invoice creation via Sales Order you should be able to generate multiple Invoices. NetSuite allows user to create multiple Invoice against a Sales Order if the qty remaining on Sales order >0.

Hi, You can create a search on Vendor with criteria as Transaction : Type is NONE and Date range is last 1 year. In the result column, add vendor Name and other details as required.

you can develop a script to update these numbers.

@Nicole Mendoza-Oracle What activity will be performed in System during the downtime for release?

NetSuite does not have any standard feature to identify country based on zip code. However, we can design a custom solution by maintaining zip code country basis in custom record and write a script to populate the country. The key would be its not ideal to get zip code for all city wise and country wise. We will also have…

I dont think there is any standard feature for this. However, you can create multiple reports on transaction created, transaction edited, audit trail on feature change if any. NetSuite also has a SuiteApp Administrator control which gives good insight of searches and reports.

HI @Amjad Kasem , you can achieve this using client script validation.

Hi, I think you are referencing to transaction date. if yes, you can create a search on transaction with criteria date is greater than today and mainline as true. Add required fields in result column to run the search.

Can you try scheduling the report since the volume is huge. You may also try writing a saved search on transaction basis with relevant details required and use the functionality of PERSIST SEARCH to download huge volume data at once.

Hi, Unfortunately this is still an enhancement in NetSuite.

Hi JoshPNW NetSuite has a feature of asset disposal where you can select disposal type as SALE. Can you check if this works for your organization.

Hi User_YJ6BU if you are using the workflow, you can hide the APPROVE field if current user == transaction creator on edit mode. Same logic can be applied using suitescript as well.

Not that I am fully aware. May be at time of license renewal NS Sales Rep might charge. Again I am not sure on this and hence cant confirm.