Create a saved search to list items that are not billed to bill the rest.

Scenario: Create a saved search to list items that are not billed(fully or partially) to bill the rest.

Solution:

List> Search> Saved Searches

Select Transactions
Enter Search Title

Criteria: Vendor Return Authorization
Type: Sales Order
Main line: False
Filter: Formula (Numeric) Description: is greater than 0 Formula: ABS({quantity}) – {quantitybilled}
Filter: Status Description: is none of Vendor Return Authorization:Cancelled, Vendor Return Authorization:Closed

Results:
Field: Date
Field: Document Number
Field: Item
Field: Quantity
Field: Amount

Click Save

Leave a comment

Your email address will not be published. Required fields are marked *