Adding Dimension in Statement (Report 116)

julkifli33

hi all... i want to add Shortcut dimension in Report 116 (Statement)
how do i link that?
which table should i use?
thanks

Koshe

I think you need to look in the table "Ledger Entry Dimensions"

akhileshek

Hi

You can't filter shortcut dimension directly in customer ledger. the shortcut dimensions are storing in ledger entry dimensions table, I will give you one solution I think its will solve your problem

add one data item table "Ledger Entry Dimension" in your report after customer data item set the request field Dimension Code,Dimension Value Code

write the code
Ledger Entry Dimension - OnAfterGetRecord()
CurrReport.SKIP;
otherwise its will run for all records in Ledger Entry Dimension

go to the Cust. Ledger Entry-CustLedgEntry2

CustLedgEntry2 - OnAfterGetRecord()

create a new variable RsLedgerDimention for Ledger Entry Dimension then
write the code

//001
RsLedgerDimention.RESET;
RsLedgerDimention.SETRANGE(RsLedgerDimention."Table ID",21);
RsLedgerDimention.SETFILTER(RsLedgerDimention."Dimension Code","Ledger Entry Dimension".GETFILTER("Dimension Code"));
RsLedgerDimention.SETFILTER(RsLedgerDimention."Dimension Value Code",
"Ledger Entry Dimension".GETFILTER("Dimension Value Code"));
IF NOT RsLedgerDimention.FINDFIRST THEN
CurrReport.SKIP;
//001

the code using for skipping the other dimensions values entries in customer ledger table

Save and run give the filter
I think it should work

regards

Akhilesh

akhileshek

akhileshek wrote:

Ledger Entry Dimension - OnAfterGetRecord()
CurrReport.SKIP;
otherwise its will run for all records in Ledger Entry Dimension

You can use this also
Ledger Entry Dimension -OnPreDataItem()
setfilter("Entry No.",0);

julkifli33

All ....
thanks a lot for the info