Etiket arşivi: Logo Tiger

Logo Connect Sevkiyat Açıklamasını Fatura Alanına Getirme Kuralı

Posted on by

sub ProcessEvent(App)

strShipLoc_Code = App.Doc.FieldAsString(“SHIPLOC_CODE”)

SEVKIYATACIKLAMA = App.UQUERY_GETFLD(58, “NAME”, 200, 52, FALSE, “CODE = ‘”+strShipLoc_Code+”‘” )

App.Doc.WriteStartElement “ADDITIONALDOCUMENTS/ADDITIONALDOCUMENT”

App.Doc.WriteElementString “ID”, SEVKIYATACIKLAMA

App.Doc.WriteElementString “ISSUEDATE”, Year(Date()) & “-” & Right(“0” & Month(Date), 2) & “-” & Day(Date())

App.Doc.WriteElementString “DOCUMENTTYPE”, “SEVKIYATACIKLAMA”

App.Doc.WriteEndElement

App.Doc.SaveData

end sub

 

XSLT ye Eklenecek Kod

 

<xsl:for-each select=”//n1:Invoice/cac:AdditionalDocumentReference”>

<xsl:if test =”cbc:DocumentType = ‘SEVKIYATACIKLAMA'”>

<p style=’margin-left: 20px;’>

<b>SEVKİYAT BİLGİSİ :</b>

<b>

<xsl:value-of select=”cbc:ID”/>

</b>     

</p>                                                                                                             

</xsl:if>

 

Logo Kredi Kartı Fiş Listesi

Posted on by

Logo Kredi Kartı fiş listesi
Logoda Cari hesap fiş listesini aldığımızda kredi kartının detayını vermiyor
aşağıdaki sql size kredi fişinin satırlarınıda listeler


SELECT DISTINCT 

                         CTRNS.DATE_, CLCARD.CODE AS CLCARD_CODE, CLCARD.DEFINITION_ AS CLCARD_DEFINITION_, CTRNS.AMOUNT, CTRNS.LINEEXP, BANKACC.CODE AS BANKACC_CODE, 

                         BANKACC.DEFINITION_ AS BANKACC_DEFINITION_, CLFICHE.FICHENO

FROM            LG_999_01_CLFLINE AS CTRNS LEFT OUTER JOIN

                             (SELECT        LOGICALREF, FICHENO

                               FROM            LG_999_01_CLFICHE) AS CLFICHE ON CTRNS.SOURCEFREF = CLFICHE.LOGICALREF LEFT OUTER JOIN

                             (SELECT        LOGICALREF, CODE, DEFINITION_

                               FROM            LG_999_BANKACC) AS BANKACC ON CTRNS.BANKACCREF = BANKACC.LOGICALREF LEFT OUTER JOIN

                             (SELECT        LOGICALREF, CODE, DEFINITION_

                               FROM            LG_999_CLCARD) AS CLCARD ON CTRNS.CLIENTREF = CLCARD.LOGICALREF

WHERE        (CTRNS.TRCODE = 70) AND (CTRNS.MODULENR = 5) AND (CTRNS.CANCELLED = 0)

Logo Cari Hesap Muhasebe Kodları

Posted on by

Cari Hesaplara bağlı muhasebe kodlarını gösteren sql

SELECT     CLCARD.CODE, CLCARD.DEFINITION_, EMUH.MUHCODE, EMUH.MUHDEFINITION_
FROM            LG_006_CLCARD AS CLCARD LEFT OUTER JOIN
                             (SELECT        CRDACREF.CARDREF, EMUHACC.CODE AS MUHCODE, EMUHACC.DEFINITION_ AS MUHDEFINITION_
                               FROM            lg_006_CRDACREF AS CRDACREF FULL OUTER JOIN
                                                         lg_006_EMUHACC AS EMUHACC ON CRDACREF.ACCOUNTREF = EMUHACC.LOGICALREF
                               WHERE        (CRDACREF.TRCODE = 5)) AS EMUH ON CLCARD.LOGICALREF = EMUH.CARDREF

order BY code

Logo Cari hesap Durum Raporu

Posted on by

Cari Hesapların Son alacak ve borç durumları ile son yapılan alacak / borç işlemimin tarihlerini verir
hareketsiz cariler listelenmez

SELECT  
CLCARD.LOGICALREF,
    CLCARD.CODE AS [CARİ KODU],
    CLCARD.DEFINITION_ AS [CARİ ÜNVANI],
(select TOP 1 case when (sum(DEBIT)- sum(CREDIT)) > 0 then ROUND(sum(DEBIT) - sum(CREDIT),2) ELSE 0  END  from LV_120_01_CLEKSTRE 
	where TRCURR = 0 and CLIENTREF = CLCARD.LOGICALREF and CANCELLED = 0)AS [BORÇ BAKİYE],
	(select TOP 1 case when (sum(CREDIT)-sum(DEBIT)) > 0 then ROUND(sum(CREDIT)-sum(DEBIT),2) ELSE 0 END  from LV_120_01_CLEKSTRE 
	where TRCURR = 0 and CLIENTREF = CLCARD.LOGICALREF and CANCELLED = 0)AS [ALACAK BAKİYE],
    (SELECT TOP 1 DATE_ FROM LG_120_01_CLFLINE WHERE  SIGN = 0 AND CLIENTREF=CLCARD.LOGICALREF AND CANCELLED = 0 ORDER BY DATE_ DESC) AS [SON BORC TARIHI],
    (SELECT TOP 1 DATE_ FROM LG_120_01_CLFLINE WHERE  SIGN = 1 AND CLIENTREF=CLCARD.LOGICALREF AND CANCELLED = 0 ORDER BY DATE_ DESC) AS [SON ALACAK TARIHI]
FROM  LG_120_01_CLFLINE AS CLFLINE INNER JOIN LG_120_CLCARD AS CLCARD ON CLFLINE.CLIENTREF = CLCARD.LOGICALREF
WHERE  CANCELLED = 0 
GROUP BY CLCARD.CODE, CLCARD.DEFINITION_,CLCARD.LOGICALREF