Forum

Welcome Guest! To enable all features please try to register or login.
Finansijski saldo za ispis na fakturama
Options Go to last post Go to first unread
Previous Topic Next Topic
NIKOLA.K
#1 Posted : 18 April 2012 10:08:37(UTC)
NIKOLA.K

Rank: DL Partner

Joined: 24/04/2009(UTC)
Posts: 14
Pozdrav svima,

može li neko dati kratke instrukcije (ili gotov ispis) za ubacivanje subreporta na ispis koji bi na fakturi izdanoj kupcu imao rekapitulaciju otvorenih stavki ili bar saldo konta kupca kako bi uz svaku fakturu imali podsjetnik na postojeća dugovanja....
HARUN.S
#2 Posted : 24 April 2012 18:26:21(UTC)
HARUN.S

Rank: Datalab

Joined: 24/04/2009(UTC)
Posts: 132
Pozdrav,

otprilike...

Dospjele obaveze:
[SQLEXP('select SUM(andebit-ancredit) from the_accttransitem where acacct = 2111 and acsubject='''+<qreportizpisd."acreceiver">+''' and addatedue <=
'''+FormatDateTime('yyyymmdd',<qreportizpisd."addateinv">)+'''')] KM

Knjižene obaveze:
[SQLEXP('select SUM(andebit-ancredit) from the_accttransitem where acacct = 2111 and acsubject='''+<qreportizpisd."acreceiver">+''' and addatedoc <=
'''+FormatDateTime('yyyymmdd',<qreportizpisd."addateinv">)+'''')] KM

pa dorađuj. Ako ti treba više konta, deklariraj varijable u code ispisa i dodijeli vrijednosti, a na ispisu koristi ='''+konto1+''' OR '''+konto2+''' ...ili LIKE.



LP
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0.465 seconds.