Saturday, June 1, 2019

Determine the Related Vendor Bill Variance Journal Entries for Purchase Orders/Vendor Bills that was Recorded to Close out the Variance in the Inventory Received Not Billed Account


The transaction link information between a Purchase Order/Vendor Bill and a Journal on the posted Vendor Bill Variance transaction is not yet available in the system. This is discussed under Enhancement 190209: Transactions > Purchases/Vendors > Post Vendor Bill Variance Journal Entry should be linked to its purchase order or vendor bill.

An alternate solution to determine the transaction links between these transactions is to create a Transaction Saved Search.  Here are the steps that you need to do:

1. Navigate to Reports>Saved Searches>All Saved Searches>New

2. Select Search Type = Transaction

3. Navigate to Criteria tab>Standard subtab>Filter column and add the following filters:

a. Type = is Journal

b. 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>Field column and add the following fields:

a. Created From

b. Date

c. Type

d. Created From Fields…>Name

e. Account

f. Amount

5. Hit Save & Run button


No comments:

Post a Comment