Unlike customer statements, there are no standard functionality to generate vendor statement in NetSuite yet.
1.We can generate the vendor statement by customization.
- By A/P register customization.
- By creating a Saved search with required details.
2. We can create a Transaction Saved Search can be created to simulate a Vendor Statement.
Navigate to Lists > Search > Saved Searches > NewClick TransactionSearch Title: Enter TitleClick Criteria tabClick Standard subtabFilter:
- Select Type
- Type: Select any of
- Select Bill
- Select Status
- Status: Select any of
- Select Bill:Open, Bill:Paid In Full
- Select Account Type
- Account Type: Select any of
- Select Accounts Payable
- Select join field Applying Transaction Fields…
- Applying Transaction Filter: Select Status
- Status: Select none of
- Select Bill Payment:Voided
Click Results tabClick Columns subtabField:
- Select *
- Select Date
- Select As-Of-Date
- Select Period
- Select Type
- Select Document Number
- Select Name
- Select Account
- Select Memo
- Select Amount
- Select Status
- Select Formula (Currency)
- Formula: Enter CASE WHEN {applyingtransaction.status} = ‘Voided’ THEN 0 ELSE {applyingtransaction.amount} END
- Custom Label: Enter Payment Amount
- Select Applying Transaction
- Custom Label: Payment Transaction
Click Available Filters tabFilter:
- Select join field Applying Transaction Fields…
- Applying Transaction Filter: Select Name
- Show in Filter Region: Enter Checkmark
- Click Add
Click Save & Run