Best Of
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
OliverK
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
Re: Related records tab permissions
Hi @RobertBongers,
Adding the Work Order and Financial History permissions gave me access to the Work Order's Related Records tab.
Can you confirm if a different form is set as the preferred for the roles in question? If so, the Related Records tab may be hidden from the form.
Re: Regexp Substring in Workflow
That wouldn't work as it's not looking for a particular phrase and is just extracting a number (while here, I need to extract anything after the phrase and before the first blank space after the phrase).
The following is working
REGEXP_REPLACE({incomingmessage}, '^.*?(our purchase order number|the purchase order number|the purchase order number is|purchase order no|PO number|po number|po no|purchase order)\s+([0-9a-zA-Z-_()/]+)?.*$', '\2',1, 1,'imn')
It does need a second field to get rid of the additional text that is extracted by this formula. The second field's formula is:
NVL(SUBSTR({custevent_po_lookup}, 0, INSTR({custevent_po_lookup}, CHR(10))-1), {custevent_po_lookup})
Vernita
Re: Attach Saved Document file to posted AP Invoice
Hi All
I found this Knowledge Article 8930 useful. Please let me know if there is any other way for mass attachments using import method, thanks!
Attaching Files to Records
Published 03/04/2011 11:44 AM | Updated 05/08/2022 11:02 PM | Answer Id: 8930
Kedalene
Re: Invoice reporting for commission
Have you tried the result field "Amount (Transaction Total)"? Be forwarned that if your invoice has multiple lines, the same amount will be repeated
Re: Unrealized Foreign Currency Report - Empty
Hello @User_XQ321,
Is it possible that the period range that you have selected in your Unrealized Exchange Rate Gains and Losses report does not have any Currency Revaluation yet?
For example for the month of June 2022:
Since I have not yet ran the Currency Revaluation for the month of June 2022 no data will appear in the report.
However, if I set it from April 2022 to May 2022, I am able to see results:
This is because unrealized/gain loss was posted for these periods as indicated by the Unrealized Gain/Loss Trans Number column
I hope this clarifies ?
==============
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, and you will also get closer to earning your next Answer Accepter badge.