Best Of
Re: "Invoice Printing" Audit Log
Hello @User_XQ321,
Good day! ?
Upon checking, having an audit trail for printing activities is not yet possible in NetSuite. I have found Enhancements logged related to this behavior:
- 77305 Provide a system generated note or printing audit trail to track when a transaction or report was printed and by whom
- 87822 View Audit Trail > Please add the ability to audit exported data: lists, reports, searches, etc., and by whom
Hoping for your understanding on this system limitation. You can vote for the said Enhancements using the SuiteIdeas page. Thank you! ?
If you find this reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster without the need to read through all the replies.
Re: Multi Book
Hello @User_XQ321,
Regarding your question #1 about the automatic integration. You can select an exchange rate provider, please check SuiteAnswers Id: 80531 | Integrated Exchange Rate Providers
Your accounting books' GL impact will be automatically be converted to the exchange rate if you have data manually updated or via integration.
Here is an example:
My Australian subsidiary is being translated in an accounting book to Euro.
When I create a transaction, let's say for AUD $100:
The G/L impact to that accounting book will be automatically translated
This is in accordance to the date of the transaction and the currency transaction date.
For your second question, currently, there is no documentation about a default currency exchange rate for transactions. It would be best to reach out to your Account Manager to refer you with Professional Services or your Multi Book enabled partner to check if this is possible. It would be best to plan this with them so that they can give you with the best advice in the implementation of Multibooks and HTP.
Apologies for the limited support that we can provide
Re: Custom records not showing in Global Search
Quick update -
Support pushed out a fix for this on 6/25
Defect 676224: Global search not displaying certain records
In order for everything to work again I had to follow these steps for each of the custom records we had the issue with:
1. Go to the custom record and go to Edit mode
>Uncheck the INCLUDE IN GLOBAL SEARCH checkbox
>Save the record
2. Go back to the custom record on Edit mode
>Check the INCLUDE IN GLOBAL SEARCH checkbox
>Save the record
Everything is now back working again ?️
Re: Recommendation on Budget and Planning Tool
Just to set the stage: Our implementation is for NetSuite standard (not OneWorld). We do not license NetSuite Planning and Budgeting separately.
We leverage "Multiple Budgets" in SetUp>Company>Enable Features>Accounting>Advanced Features. (check or ask your administrator to see if you are entitled to it).
We then load a Budget by Budget Category for each year we are forecasting(as you can se we can Budget by Customer, Item, Class, Department, Location and Account Type)
There are some delivered Budget vs Actual Reports available.
We also leverage the ODBC connection to pull data into a SQL database for varied reporting.
Hope this gives you some ideas.
CDuf
Re: How to Filter Options in a Field based on selection in Other Fields then update related records?
Thanks for confirming and apologies for not so soon reply @Amjad Kasem.
To be able to filter the Receive Shipments field on the Package record per your requirement using the Custom Field Filtering feature, the Request to Forward Shipments Child Record sublist on the Received Shipment Record must be converted to a List/Record or Multiple Select field to be matched with the Ship Request to Forward Reference field in the Package record, since Child Record Sublists are not yet supported in the filtering options.
Also, there should be a Customer field created in the Received Shipment Record to use as a matching filter field for the customer on the Package record.
After you make the above adjustments, configure the filtering settings for the Received Shipments field on the Package record according to the screenshot below to get your desired result:
Related SuiteAnswers Articles:
10093: Dependent Dropdown Lists
99662: Dependent Dropdown Lists Example
Hope this helps.
If you find this reply to your question useful, others might be as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier and you will also get closer to earning your next Answer Accepter badge.
-Jack
Re: Users cannot select from lists
Good morning Joy
Just to update you, this problem was a browser issue.
If users start to report issues of this nature which seem localised then the answer is usually local. I instructed the users using the below to clear their browsers and cached data and this resolved the issue.
The way in which it was identified as being a browser problem was that I asked them to use another browser to see if the same problem occurred.
Thank you for your time and input.
Kind regards
Oliver
Re: Saved Search - Backlog of Sales Orders
Hi,
I think that :-
CASE WHEN {quantity}-{quantitybilled}>0 THEN 0 ELSE 1 END
and test for this being 0 again would work.
Kind regards,
Steve
Re: How to default a Subsidiary for transaction records
Hi,
there are 2 aspects I see to this :-
- A requirement to add subsidiary "Y" to all the client / vendor records - a CSV import for the client-subsidiary relationship and vendor-subsidiary relationship records could help achieve this.
- A workflow triggering on 'create' and using 'Transaction' then the relevant types (bill, bill credit, invoice, credit memo etc) with a 'set field value' action to set subsidiary "Y" would handle that side.
Hope this makes sense and is helpful to you.
Kind regards,
Steve
Re: Multi-Level Join in email
Greetings @Josh Harlow,
Workflows can only reference fields on the current record it is running or on a record that is joined by a Dropdown Field in the current record. Referencing child record fields is still a limitation of SuiteFlow.
With the above said, you may need to use SuiteScript instead for your requirement.
Please be informed that the scope of our support here in NetSuite Support Community does not include creating and implementing any complete scripting solutions from scratch.
For this, we recommend that you consult your technical requirements with your in-house developer or you may avail the services of our Professional Services or Advanced Customer Support Teams through your Account Manager so that they may help in developing your script.
However, we can provide resources that may help and get you started. Refer to the following SuiteAnswers Articles:
43519: SuiteScript 2.x API Introduction
And, if you have any specific concerns or inquiries in the course of the solution development, you can post them here in the community. That way, we might be able to help you further.
-Jack












