Create a sales report that would show the consolidate sales prior to elimation process

Scenario:

·        Create a sales report that would show theconsolidate sales prior to elimination process

 

Findings:

·        Users may opt to filter out transactions using the Intercompany Receivable Account toexclude sales between subsidiaries prior to actual elimination to come up witha more accurate consolidated sales total

 

Solution:

1.   Navigate to Reports> Sales > Sales by Item > Customize Detail

2.   Filters tab:

a.    Add Namefield from Sales Transaction folder> Account subfolder

b.   Select the IntercompanyReceivable account(s)

3.   Assign a report name

4.   Hit the Previewor Save