Best Of

Hi @User_HNJ22

What flows into NSPB from NS are sourced from Saved Searches. You can verify in your NSPB Income Statement Transactions Saved Search how Vendor names are pulled from the Journal line items. Check the formula you have for the Relationship column. If it is using {vendor.internalid}, the Search will return Undefined_Relationship for Journals. If you use {vendorline.internalid}, the Search will return the internal ID of the Vendor which is located in the Journal line item.

@User_HNJ22 If the vendor names in Bill and Expense Reports are located on the Main Line section instead of Line Item, changing the formula to {vendorline.internalid} would only benefit Journal transactions.

Alternatively, you can create another Saved Search to pull Journal transactions only (by adding another filter under the Criteria tab: Type = Journal) then change the part of the Relationship formula that is using {vendor.internalid} to {vendorline.internalid}. However, you will need to set up another job in NSPB Data Management to load the data from this new Saved Search.

As for the existing Saved Search, you can just filter out the Journal transactions since you will be pulling it using another Search. Then, leave the Relationship formula unchanged.

Hi @Manuel Dambo,

This capability is NOT supported in NetSuite. An internal communication has been raised referring to this request and it is clearly defined that this cannot be implemented as this would be a violation of the Security policy.

The only recommendation provided is to lengthen the days the Password can be used. 

This can be set under the Setup > Company > General Preferences and set a value on the Password Expiration in Days field.

Currently, valid values are between 1-365.

Note: To comply with Payment Card Industry (PCI) standards, employees with access to View Unencrypted Credit Card Numbers are automatically required to change their passwords every 90 days.

I hope this answers your question.

Regards,

Hi Mikko,

The custom fields, send /get won't work in my situation. the suitelet popup is like another page on the top of the sales order record, and we have to pass the values from the suitelet page to the sales order again. As said the syntax I provided in my initial question didn't work, in suitescript 2.0.

Going into details, my actual need was to show only a set of items/values on the suitelet popup(as We couldn't filter the Standard Item field on SO/transaction.) based on the criteria/fields populated on SO. After I posted this question, I did a lot of research and experimented with it in different ways to make it work.

In the end, I found that, window.opener property works only in GET and not in POST. Or we can say, from where the script will run (client-side or server-side), this property works only for those scripts running from the client-side (Client Script).

So I passed the value to another client script and deployed it on the Sales order, then used the syntax to populate the item field. That worked.

I really appreciate the support here, I found an article online explaining this which helped me in this case. Following is the link.

Thanks,

Sampath(SAM) Kumar Rudra

Thank you, @Tiru Chembeti, for sharing your insights on this. ?

I had a similar requirement, where since this was an enhancement in search we tagged a checkbox on any transaction with those accounts using a UE/ Scheduled script.

Later created a search based on that checkbox to show both credit and debit accounts.

Is the difference due to consolidated exchange rate at subsidiary parent level. To knock it off for AP and AR looks like you will have to do write off the amount by passing the JE or adjusting the payment already done which caused this difference.

You can also use discount provided field on customer payment incase the amount was less paid by customer.

Hello @Dirk Nieuwkamp ,

Unfortunately, this is currently not available within NetSuite. We do have created the following Enhancements requests for this possibility:

• 221365 - Electronic Payments > Support withholding tax calculation
  • Alternate Solution: Use EP Instant Bank File. Create payment records outside EP and flag them for EP processing.
• 385852 - EFT Bill Payment > Netherland Subsidiary > Discount Taken is computed on Gross Amount including VAT
  • Alternate Solution: Process the bill payment thru Transactions > Payables > Pay Bills page. On this page, the accounting preference 'Include Tax For Term Discounts' works.
  • After processing the bill payment, you may create the EFT file thru 'Generate Bill Payment File' page (Payments > Bank File Generation > Generate Bill Payment File).

You may vote for these enhancements through SuiteIdeas to increase its points and have it possibly included on NetSuite's future releases.

Thank you for your understanding.

“Kindly click "Yes" on "Did this answer the question?" if you find the reply on your thread helpful. This will aid the others with the same question to easily find the correct answer. Thank you!

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.