Regarding a Check printed report

Question

Hi Everyone:

Would you please advise me how can I get a check printed report for checks issued through both "Bill payment" and "Vendor Prepayment" for a certain bank account( let's say account number 1001) ? The report must include the addressee

And the "Status" for the payment

thanks for the advise

Judith Culanding-Oracle · Accepted Answer

Hi @Kevenale,

You can create a Saved Search report to get the list of Bill payments and Vendor Prepayments for a certain bank account but you wont be able to get the Addressee from the actual transaction record.

Create a Transaction Saved Search with the following criteria:

Criteria

* Type = Bill Payment and/or Vendor Prepayment
* Account = Bank Account 1001 (sample)
* Main Line = Yes

Results

* Date
* Document Number 
* Type
* Name
* Amount
* Account

You can add additional fields to the Criteria and Results tabs as needed, and remove any fields that are not relevant to your reporting requirements.

Regarding the ability to source the Payee Address directly from the transaction record, this functionality is not currently available in standard NetSuite. There is, however, an existing Enhancement Request that has been logged to support this capability in a future release.

If this functionality is important to your business, you are encouraged to vote for the following Enhancement Request to help increase its visibility and priority:

* 378514 Billing / Shipping Address fields like State/Province, Zip have no values in searches and reports even if source sales transactions have these field values correctly encoded under the Address tab