NSC | Show Related Purchase Order or Vendor Bill of the Post Vendor Bill Variance Journal Entry

Elychelle Gulen-Oracle

Currently, the ability to show related Purchase Order or Vendor Bill in the Post Vendor Bill Variance Journal Entry is a system limitation.

A workaround for this is to create a Transaction Saved Search to see the list of linked Purchase Order or Vendor Bill of the Post Vendor Bill Variance Journal Entry.

Here are the steps you may take:

1. Navigate to Reports > Saved Searches > All Saved Searches > New
2. Select Transaction
3. Under Criteria tab > Standard subtab, add the following filters:
   - Type = is Journal
   - Formula (Numeric) | Formula: Case when {memo} like 'Total Bill Variance' then 1 else 0 end | Formula (Numeric): is equal to | Value: 1
4. Navigate to Results tab > Columns subtab, add the following fields:
   - Created From
   - Date
   - Type
   - Created From Fields… = Name
   - Account
   -Amount
5. Click Save & Run

I hope this helps! Let us know your comments below. 😊