How i link between dimension value table and Gen. Journal Line table by employee code in test report

Business Central/NAV Developers Forum
1

In Financial Management section - Cash Management - Cash Receipt Journal I want to add Employee code to

table Gen. Journal Line when account no is staff account The source table of this form (Cash Receipt Journal number 255)

is Gen. Journal Line and Source table of employee code is dimension value table how i can make link between two table to

display employee code in report number 2 general journal test.because when i make test report i don’t know how i can get

employee code to this stuff account

thanks

2

Did you add Employee Code dimension in Cash receiot Journal from Line–>Dimensions

And while printing test report, Check Show Dimensions under Options tab>

3

OK this quick way i thanks for it

But if i need to add this field to the table gen.journal line and link it from dimension value table how i make this

4

I mean this task can made by flow field

5

Add one field in Table no 81 and go the properties of that added field

Go to properties Table Relation

Select Table :- Dimension Value

Field :- Code

Table Filter :- Here Set filter for Global Dimension No as per your selection in General Ledger Setup -->Dimension i.e Here you have to select Shortcut dimension no.

6

OK thanks for reply but in last line after table filter :(Table Filter :- Here Set filter for Global Dimension No as per your selection in General Ledger Setup -->Dimension i.e Here you have to select Shortcut dimension no.) can you show this point more detail if possible

7

what i write in field and value and what field i must create in tables and which tables

the picture found in this link

http://www.mediafire.com/?0fo4o0zdq9m01d9

please help me

8

Go to General Leger Setup

Go to Dimension Tab

In this tab you are fixing the dimension as per the requirement

Now e.q if you setup you dimension ‘Employee’ in Shortcut Dimension 1 Code field then you need to set following in the employee field of table 81

Select Table :- Dimension Value

Field :- Code

Table Filter :- 1

Hope this clear your requirement

9

OK THANKS