RE: Does anyone know how to pick Vendor Credits applied in Bill Payment records?
We need to have vendor credits applied sublist data in our UE script but according to NetSuite support, this sublist is not exposed to scripts. We tried getting the data through saved search but failed to get the exact lines as the connection between Verdor payment and Vendor Credits is not one to one.
is there any way to get it through DOM, or saved search? Have anyone ever faced this?
Hi,
I hope this will help you!
1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Click on Transactions
3. Search Title: Enter preferred Title
4. Click Criteria
5. Click Standard
6. Add the following Filter:
- Type = is Bill
- Main Line = is True
- Applying Transaction : Type = is Bill Credit
7. Click Results
8. Click Columns
9. Field:
- Select Date
- Select Document Number
- Select Name
- Select Applying Transaction
- Select Applying Link Amount
6. Click Save and Run
