Scenario
User is attempting to use the Global Bill Payments functionality in NetSuite, but no transactions appear on the page.
Cause
This issue occurs when one or more required setup fields are missing or incorrect on either the Vendor Bill, Vendor Record, or Global Bill Payments page, preventing the bill from being eligible for display.
Solution
To ensure transactions appear in the Global Bill Payments page, review and validate the following checklist:
- Vendor Bill Configuration:
- The Entity (Vendor) field is populated on the EFT tab of the Bill record. (This is the most commonly missed field.)
- The Vendor Bill is in Approved status.
- The A/P Account used on the Vendor Bill matches the A/P Account used on the Global Bill Payments page.
- Global Bill Payments Page
- The Base Currency and Primary Currency set match the Vendor’s currency.
- Vendor Record Configuration:
- Navigate to Vendor Record > Bank Payment Details:
- Ensure EFT Bill Payment is checked.
- Navigate to Vendor Record > Entity Bank Details:
- Verify that the Payment File Format matches the Company Bank’s Payment File Format
Next Steps (if issue persists):
If none of the above resolves the issue:
- Provide the following information to NetSuite Support for further investigation:
- Document Number of the Bill that is expected to appear
- Bank Account being used in the Global Payments page
NetSuite Support can then review the records and configuration in detail offline.
Additional Notes
- The most common oversight is missing the Entity (Vendor) field on the EFT tab of the bill.
- Establishing a validation checklist for bill creation and vendor setup can help prevent this issue in the future.
- Consider customizing a saved search or report to identify Vendor Bills missing required EFT fields before initiating Global Payments.
Conclusion
Following the provided checklist ensures that transactions will be eligible and visible in the Global Bill Payments interface. This improves process efficiency and reduces troubleshooting delays. Ongoing user training and record validation can further streamline EFT processing and compliance.
-----
If you find this information useful, let us know by reacting or commenting on this post!