Rank: Newbie
Joined: 27/07/2016(UTC)
Posts: 1
|
Pozdravljeni,
mi lahko kdo pove, ali in na kakšen način je možno izvoziti - z vsemi pripadajočimi podatki - subjekte (naslov, davčna ...) in idente (ean, nabavna cena, prodajna, maloprodajna cena) v excelovo tabelo?
Hvala,
Matjaž
|
|
|
|
|
|
Rank: Member
Joined: 05/05/2017(UTC)
Posts: 26
|
V PA pojdite normalno na formo izpisa in pripravite filtre. Nato pa na na obliki izpisa - npr. za šifrant subjektov na izpisu 035-Vsi podatki kliknete desni klik miške in izberete Pošlji v Sql urejevalnik. S tem se vam odpre forma za urejanje Sql poizvedb (se prenese tudi poizvedba) in kliknete zeleni gumb puščica. Spodaj v tabeli se vam prikažejo podatki, te pa lahko izvozite v excel (desni klik miške in izvoz v Excel).
Lp.
|
|
|
|
|
|
Rank: Newbie
Joined: 31/07/2017(UTC)
Posts: 1
|
Prosim za še malce podrobnejšo pomoč. Sledil sem vašim navodilom. Šel sem v Nastavitve, nato v Programi, nato v Oblike izpisov in tam izbral šifro 035 (Vsi podatki). Pri desnem kliku pa se mi je ustavilo, saj mi ni ponudil opcije Pošlji v Sql urejevalnik. V katero polje natanko bi moral desno klikniti z miško, oz. ali bi moral iti že prej v kakšen drugi meni? Hvala za odgovor.
|
|
|
|
|
|
Rank: Member
Joined: 05/05/2017(UTC)
Posts: 26
|
Greste normalno v formo izpisov, torej za šifrant subjetkov Nastavitve / Subjekti / Subjekti / nato na gumb tiskalnik, uredite lahko filtre, nato pa na vrsti izpisa desni klik miške. Slika v prilogi. File Attachment(s):  Pošlji v sql .docx (3.796kb) downloaded 60 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Newbie
Joined: 27/05/2020(UTC)
Posts: 1
|
Pozdravljeni,
kako se bi dali narediti izvoz vseh subjektov, da se preveri kateri nima elektronskega naslova za pošiljanje opominov. Kako se imenuje to polje.
SELECT
S.*, S.acCity AS PostaKraj, B.acBnkAcctNo1, B.acBnkAcctNo2, B.acBnkAcctNo3, B.acBank as RacunBanka, S.anQId as anQIdGDPRLogS
FROM vHE_SetSubj S LEFT JOIN tHE_SetSubjBank B ON B.acSubject = S.acSubject and B.acType = 'D' and B.anNo = (select MIN(B.anNo) as anNo FROM tHE_SetSubjBank B WHERE B.acType = 'D' and acSubject = S.acSubject)
WHERE (S.acSupplier = 'T') AND (S.acActive IN ('T'))
ORDER BY S.acSubject
hvala
|
|
|
|
|
|
Rank: Datalab
Joined: 24/04/2009(UTC)
Posts: 403
|
Zdravo,
dopolnjen sql spodaj. acRemindersMails. Elektronski naslovi za pošiljanje opominov so v tabeli tHE_SetSubjContactAddress. Lahko jih je več in so vezani na podjetje in kontaktne osebe.
SimonKlemen
SQL spodaj
SELECT S.*,
S.acCity AS PostaKraj,
B.acBnkAcctNo1,
B.acBnkAcctNo2,
B.acBnkAcctNo3,
B.acBank AS RacunBanka,
S.anQId AS anQIdGDPRLogS,
acRemainderMails = STUFF((SELECT ',' + acPhone from tHE_SetSubjContactAddress where acSubject = S.acSubject and acType = 'R' for xml path('')), 1, 1, '')
FROM vHE_SetSubj S
LEFT JOIN tHE_SetSubjBank B ON B.acSubject = S.acSubject
AND B.acType = 'D'
AND B.anNo = (
SELECT MIN(B.anNo) AS anNo
FROM tHE_SetSubjBank B
WHERE B.acType = 'D'
AND acSubject = S.acSubject
)
WHERE (S.acSupplier = 'T')
AND (S.acActive IN ('T'))
ORDER BY S.acSubject
|
|
|
|
|
|
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.NETThis page was generated in 0,233 seconds.