Hello,
I'd like to retreive the sum of a selection of records from the value entries in table 5802 Value Entry.
Since we use dimensions to separate the results from 3 different companies within one database, I'd like to have a filter on global dimension 1.
I entered that in my NL statement (in Dutch) NL("som";"waardepost";"Tot. werk. omzet";"boekingsdatum";AJ$5;"global dimension 1 code";$B14;"Geboekt aantal";"<0";"Artikelpostsoort";"verkoop";"Prod.-boekingsgroep";$D14;"documentnr.";"*")
The result is not correct but maybe I don not filter the appropriate way. I once heard something about the dimension table being linked to all other tables in a special way, but I cannot find any documentation on that.
Thanx,
Patrick
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello again,
In addition to my post the following. I found out how to incorporate the shortcut dimension in the NL function. Our second shortcut dimension is named KSTNPL, and you can simply add it as an extra filter in the NL function. That's easy.
But, my problem is that our global dimension 1 code has the same name (DIVISIE) as the first shortcut dimension (DIVISIE) but they mean different things. I need the shortcut dimension 1 in my NL function, but don't know how.
Thankx,
Patrick -
Jet Reports Historic Posts Alle dimensies die aan de Waardposten hangen staan in tabel [355 Postdimensie].
Als je op die tabel filtert met [Tabel-id=5802] [Volgnummer=Waarpost Volgnummer] dan krijg je de geposte dimensies.
Je kan dat vervolgens bijvoorbeeld gebruiken met een NL("Koppelen") of NL("Rijen",,,"Koppelen=").
Please sign in to leave a comment.