In cases where Users would like to track the unbilled and billed amounts of the Items received, they can create a Transaction Saved Search and use a Formula (Currency) to achieve it.
Here are the steps to take in creating the Saved Search:
1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Select Transactions as Search Type
3. Under Criteria Tab, enter the following:
- Type = Purchase Order
- Status = Is any of Purchase Order: Pending Bill, Purchase Order: Pending Billing/Partially Received
4. Under the Results Tab, enter the following:
Field | Custom Label
- Date
- Type
- Item
- Document Number
- Name
- Status
- Formula (Currency) = Formula = CASE WHEN {billingamount} IS NULL THEN {amount} ELSE {amount}-{billingamount} END | Unbilled Amount
- Billing Transaction
- Billing Amount | Billed Amount
5. Enter the Search Title
6. Click Save & Run
I hope this helps! 😊
Share your insights about this in the comments below!