0

Use of Jet Report- Dimension Set Entry Link with G/L Entry Table

I am trying to Connect G/L Entry with the Dimension Set Entry table so that user can filter combination of dimensions . 

I tried linking the table with multiple combination 

LINK="Dimension Set Entry"

Dimension Set ID =Dimension SET ID

Dimension Code="Dimension1"

Dimension Value Code =*

It is working fine but if I have to filter more than 1 dimension and since only 10 filters can be used so iam trying to use special FILTER= Command. When iam running it , it is not showing any error but showing the total value without applying any filter.

=NL("SUM","G/L ENTRY","Amount","G/L Account No.",E9,"Link=","Dimension Set Entry","Dimension Set ID","=Dimension Set ID","Filters=",Options!F5:G10)

EXCEL Range Cell values 

F5-Dimension Code
G5- BRAND
F6-Dimension Value Code
G6-OCBAO1
F7-Link=
G7-Dimension Set Entry
F8-Dimension Set ID
G8-Dimension Set ID
F9-Dimension Code
G9-COUNTRY
F10-Dimension Value Code
G10-AU

1 comment

Please sign in to leave a comment.