Best Of

Ok noted. Thank you.

Thank you, Elychelle. I have submitted a case to Customer Support. They have been able to reproduce the error and they are looking into why this is happening.

Have a great weekend.

Hi @Chandanesh,

Good day! Hope you are doing well. 😊

Please add back the Line ID to resolve the Error: "Ambiguity error on logical key multi-match." but make sure it is mapped correctly.

Kindly confirm if the Data Handling is set to Update with the Overwrite Sublists box (under the Advanced Options) checked.

Thank you! 😊

Hi @Tiffany Haslerud,

Good day!

It is a current limitation to source values from the Item Fulfillment to the Invoice record as they have no link between them.

However, I have found an alternate solution for this. We'll need to use a Saved Search and a Custom Field. I'll guide you with the steps below:

Create the Transaction Saved Search:

On the Criteria subtab, input the values below:

• Filter: Type
• Description: is Item Fulfillment

On the Results subtab, input the values below:

• Field: <The field found on your Item Fulfillment>
• Summary Type: Maximum

On the Available Filters subtab, input the values below:

• Filter: Created From

Create a Custom Field on your Invoice:

• Store Value: Unchecked

On the Applies To subtab, set the values below:

• Sale: Yes

On the Validation & Defaulting subtab, input the values below:

• Search: <The Search we created>
• Field: Created From

Once done, it should now display the values of the field from the Item Fulfillment as seen below:

Item Fulfillment:

Invoice:

I hope this helps!

__

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.

Hi,

Unfortunately, this concern is not available or a system limitation of Oracle NetSuite.

Upon checking, there's an existing Enhancement requests for this:

• 384812 ODBC>Ability to query the Saved Search Filters and Columns using SuiteAnalytics Connect.
• 110729 SuiteAnalytics > Convert a saved search into an ODBC query

Let me know if these are associated with your concern. If so, you can vote for this enhancement on the SuiteIdeas page. See 10054: Voting for Enhancements

Thank you!

@gbradley To update the Role of the contact, please follow the below steps.

Open the Customer record associated with the contact.

Click on Relationships > Contacts > Update Primary

Click on Edit button and select the Role and click Save.

Thank you.

Seeking your valuable knowledge for our member @Sequel Developer. Your input is highly appreciated.

In the meantime, you might be interested in participating in our Pop Quiz 1, Pop Quiz 2, Pop Quiz 3, Pop Quiz 4. You only have until March 29, 2PM ET to comment on your answers and earn rewards! Click here for more details

Hello everyone,

Our team is already aware of the issue, which is filed under Issue 762857 system.netsuite.com > Click Login > Goes to White Screen, we are actively working on a fix. For now, use the URL https://XXXXX.app.netsuite.com/app/center/card.nl?sc=-29&whence= to login.

@Richard James Uri-Oracle Thank you.

Hello there, apologies, there was some traffic between myself and our Finance team in the meantime, they're happy with a report they already have and just needed the trigger setting up, but they have me a bit mystified as i'm not sure how they're getting the pending billing on all items on a report that isn't working from line level, so i think i'll build the one you've suggested and suggest to them that this one will work more accurately, thanks for your help.