A custom report with Cutom Field filtering

Added 2 new columns in Account Screen

Custom Field 1
Custom Field 2

Value Entered
Account No. = 1001

Custom Field 1 = CF1

Custom Field 2 = CF2

Now Entered 2 JVs –
1.

Account No. = 1001 , Dept A – $2000 Dr.
Account No. = 1001 , Dept B – $8000 Dr.
Bank Account , $10000 Cr.

2.

Account No. = 1001 , $4000 Dr.
Account No. = 1001 , Dept A – $6000 Dr.
Bank Account , $10000 Cr.

Now I want to create a Report –

Account No.        Custom Field 1            Custom Field 2          Dept.             Amount

1001                         CF1                                     (NULL)                          DeptA           $2000

1001                         CF1                                      (NULL)                         DeptB            $8000

1001                         (NULL)                                CF2                              -No Dept-     $4000

1001                         CF1                                      (NULL)                         DeptA            $6000

But I am unable to create this filtering.

experts please help.

Regards

Rookie Asked on April 16, 2021 in Reports.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor