Use ExtendInsights to create Vendor Payments in Excel and apply them to outstanding Vendor Bills in NetSuite. Keep the Vendor Bill details available while preparing the payment so you can reference the bill you want to settle.
Walkthrough Video
Watch the video for a walkthrough.
Prepare the Vendor Payment Template
Before building your template, review the NetSuite form and identify the header fields, line-level fields, and required fields for your process.
In the NetSuite Classic interface, go to Transactions → Payables → Pay Bill.
A Vendor Payment template may include:
Field | Purpose |
Tran ID | Identifies the payment |
Tran Date | Payment date |
Subsidiary | Used in NetSuite OneWorld |
Entity | Vendor receiving the payment |
Account | Account used for the payment |
Apply List: Line | Line information for the bill being applied |
Apply List: Doc | Internal ID of the Vendor Bill |
Apply List: Amount | Amount applied to the bill |
Apply List: Apply | Indicates whether to apply the payment to the bill |
💡 Tip: Your NetSuite forms and configuration may affect which fields are required. Confirm the fields you need in NetSuite before creating the template.
Create a Vendor Payment for a Vendor Bill
1. Retrieve the Vendor Bill
Retrieve the Vendor Bill you want to pay so you can reference its details when preparing the Vendor Payment. You can use a Data Filter, Saved Search, or Internal ID to retrieve the bill.
➡️ See the Retrieve Data guide collection for retrieval options.
Keep the Vendor Bill and Vendor Payment templates available in separate worksheet tabs.
2. Enter the Vendor Payment Details
Use the Vendor Payment template to enter the payment information. You can copy and paste values or use formulas to bring details over from the Vendor Bill worksheet.
For the bill you want to settle:
In Apply List: Doc, enter the Vendor Bill’s Internal ID.
In Apply List: Apply, enter TRUE.
3. Upload the Vendor Payment
Click Upload to NetSuite.
Click Upload Records.
Verify the Payment in NetSuite
After the payment is posted, check the Vendor Bill in NetSuite. If the bill has been paid in full, its status will update from Open to Paid in Full. Open the bill’s History and Payment tab to view the bill payment.
