Microsoft Dynamics NAV (Archived)

Report for Sub ledger details

(0) Share

Report

Posted on by javedakhtar

1,745

Hi All ,

i am making report for sub ledger details based on the dimension code and dimension value code in nav 2016.

i want to show three things in my report .

1.dimension code and value code exist .

2.dimension code exist and value code does not exist .

3.dimension and value code does not exist .

my approach was , i have take integer data item .and taken g/l entry as buffer table .setrange the g/l entry based on the gl account no and posting date ,passing every dimension set id to the functiion name dimension code exist or not .in that function i have first setrange on the dimension value entry in the record variable of dimension set entry .loop through the record ,if my filter dimension value code matches with dimension value code ,then i return true else false.but i am stuck in the last part of my requirment . kindly guide me

*This post is locked for comments

All responses (2)

Answers (0)

javedakhtar 1,745 on at

Like (0)

Report

RE: Report for Sub ledger details

Dear Amol ,

i just wanna ask you that if my third case possible and under what condition ,how can i create an entry whose dimension code does not exist at all, one of my functional consultant told me that if my dimension set id is zero that mean its dimension code and dimension value does not exist , based on this i can group on zero dimension id as my third case .kindly guide me on this
Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Report for Sub ledger details

By looking at third scenario If Dimension is not defined then you can not get data

Is my understanding correct?