Purchase order and bill payment Amount variance report

SCENARIO

The Client requires to know the If there is any Purchase order whose bill payment is more than Purchase order amount

SOLUTION:

Create a saved search

Go to Report>Saved Search>New Search

Select Type of search as Transaction

Criteria

1. Type is Purchase Order 
2. Date Created
3. Applying Transaction : Type is Bill 
4. Status is Purchase Order: Fully Billed 
5. Applying Transaction : Status is Bill: Paid In Full 
6. Formula (Numeric) is not 0 ABS({fxamount})-ABS({applyingtransaction.fxamount})

RESULT

1. Date         
2. Period         
3. Type         
4. Transaction Number         
5. Name         
6. Amount (Foreign Currency)   in Custom label: PO Amount    
7. Applying Transaction : Amount (Foreign Currency)   in Custom label: Bill Amount    
8. Applying Transaction : Date  in custom label  Bill date    
9. Applying Transaction : Transaction Number   in custom label   Bill Transaction number    
10. Applying Transaction : Document Number  in custom label    Bill Doc Number

Provide name for the report and click save and run