Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Saved Search on PO to show if the Vender Bill has a bill payment or bill Credit
I have a transaction saved search that is based on Purchase Orders for a specific vendor. It correctly pulls in the status of the the PO and Vendor bill. Because of the overall process that is needed, we cannot create this saved search from the Vendor Bill. I need assistance in finding the correct field to pull in if the Vendor Bill is paid in full because of a Bill Credit or a Bill payment.
From the Vendor Bill, under Related Records\Payments. It shows that the type is either a Bill Credit or a Bill Payment.
I have correctly found that the field "Billing Transaction : Applying Transaction" will show the bill credits. But I am having issues finding the correct reference field for a Bill Payment. I am not sure the correct terminology that NS uses for a Bill Payment, because clearly it is not Applying Transaction. Or if there is a single field that will show the Type in one column that would be ideal. But if I can at least find the correct field I can dump them both into a formula.