Best Of

Hello @Tiru Chembeti,

I would just like to ask for the screenshots of samples so we can further check this. Just make sure to keep confidential information hidden when sharing screenshots in the community. ?

Thanks and regards,

Joy

hi @Dominica Sevilla-Oracle

your suggestion to add the vendor by expanding vendor (Line) is working. but the catch is to bring only 1 vendor.

it solved our purpose as we want to use it as Supplier Statement one-by-one when needed. i did the testing with various cases. Finance is also testing it. most probably this will suffice.

it will be better if the enhancement request is delivered. When ER is resolved and delivered please update this thread as lot of people can benefit from the ER.

thanks a lot!!!!😊

regards

Ahmed

@Dominica Sevilla-Oracle

Thank you for sharing detailed screen shots. The actual requirement is A/P register should be grouped with Vendor name not by account name and its not best practise to have two different columns for vendor body and line.

Hi @User_DU7YV,

Thank you for creating this thread. 😊

Hello, everyone! We warmly invite you to join the conversation and share your valuable insights with us.

Hi,

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

•  153242 SSS > nlobjSubList/serverWidget.Sublist > allow insertField method

You can vote for this enhancement on the SuiteIdeas page. See 10054: Voting for
Enhancements

Let me know if this is associated with your concern. Thank you!

Hi tech work, glad to have you with us today and thanks for posting here in the NetSuite Support Community!
Greetings, everyone! We have a fellow member who could use our assistance. Please don't hesitate to share your knowledge and insights to help them out. Your input is highly valued and appreciated!

Update:

I was able to figure it out - correct formula is

CASE WHEN {trandate} BETWEEN TO_DATE('01/01/2023','MM/DD/YYYY') AND TO_DATE('06/30/2023','MM/DD/YYYY') THEN {totalamount} ELSE 0 END

The sample script linked (re: flat rate shipping) could be useful - we will be investigating this in more detail.

Hi @Tafranklin5

Regarding associating items with customers in NetSuite, there isn’t a direct equivalent to the Vendor subtab for customers. However, you can achieve similar functionality by using custom fields or other workarounds. some options I aware are:

Custom Fields:
Create custom fields on the item record to store customer-specific information. For example, you can add custom fields for customer codes, customer part numbers, or any other relevant details. Assign the custom field to the Item record type.
Once you’ve created the custom field, you can populate it with customer-related data.

Item Descriptions:
Including customer-specific information in the item description is an option. While it doesn’t provide a separate subtab, it ensures visibility within the item details.
However, relying solely on the item description may not be as efficient for searching or reporting purposes.

Workaround Using Sublists:
Although there isn’t a direct “Customer” subtab, you can use the Sublists section within the item record to associate customer-specific data.
For example, you can create a custom sublist called “Customer Associations” or similar. Within this sublist, you can add fields such as customer name, customer item number, and any other relevant information. While this approach won’t mirror the Vendor subtab exactly, it allows you to organize customer-related data within the item record.

Workflow Automation:
If you’re comfortable with scripting, consider using workflow automation to achieve more complex associations.