This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

We want to create a list of this month's Vendor Bills and this month's applied Vendor Credits. The issue we have is the Vendor Credits. They credit may have been
• created in a previous month and applied to a specific bill this month.
• created in a previous month and included with this month's vendors Bill Payment transaction
• created this month and applied to a specific bill
• created this month and included in this month's Bill Payment.
Ideally I'd like to locate a specific field on the Bill Credit (body or line) which shows the day it was applied.

that day is your transaction date (or system date if transaction date can be changed manually).

That represents the date an invoice was paid and might be applicable to when it was applied

Or create a custom field and WF or script to populate {today} when the status = Applied

In our search the customer has three credits, one was created last month and applied with this months payment on 15 April.  A new credit is created today which will apply to a bill which will be paid next month. Third is a credit created and applied today.

<@U03GYQZTZDW> we were settling on a custom field.