Sunday, June 30, 2019

Create a Saved Search to Display invoices with Different Ship to Address and "End User" Ship to Address

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

2.    Choose Search Type "Transaction"

3.    At the Criteria tab, set the following:

Filter

Description

Formula

Type

Is Invoice

Main Line

Is true

Formula (Numeric)

Is 1

Case When {shipaddress} != {custbody_end_user_default_ship_address} then 1 else 0 end

Date

Depends on the date range that the users need for the report.

4.    At The Results tab, there are already default fields. However, users may add other Results fields needed for their report. Add the following:

o End User Default Shipping Address (Custom)

o Shipping Address

Note: This report is useful for Avatax purposes if users need to export to Microsoft Excel the End User Ship to Address found in the Invoice.

No comments:

Post a Comment