Türker Tunalı TurkerTunali
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| frappe.listview_settings['Purchase Order'] = { | |
| button: { | |
| show: function(doc) { | |
| return true; | |
| }, | |
| get_label: function() { | |
| return __('View'); | |
| }, | |
| get_description: function(doc) { | |
| return __('Print {0}', [doc.name]) |
TurkerTunali
/ Tur rapor.sql
Created
February 27, 2021 07:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| GEN_DATE.GEN_DATE, | |
| LEFT(CUSTOMER.name, 29) AS CUSTOMER_NAME, | |
| FORMAT(IFNULL(TGL.bakiye, 0), 2, 'tr_TR') AS BAKIYE, | |
| /*PAYMENT_ENTRY.posting_date, | |
| SALES_ORDER.transaction_date, | |
| DELIVERY_NOTE.posting_date,*/ | |
| #COALESCE(PAYMENT_ENTRY.posting_date, SALES_ORDER.transaction_date, DELIVERY_NOTE.posting_date) AS TRANSACTION_DATE, | |
| FORMAT(SUM(CASE PAYMENT_ENTRY.mode_of_payment WHEN CONCAT('Kadir Kızıl', ' Nakit') THEN PAYMENT_ENTRY.paid_amount ELSE 0 END), 2, 'tr_TR') AS CASH, |
TurkerTunali
/ ConsolidatedRunningBalance.sql
Last active
July 21, 2020 16:18
Running balance report for customer and suppliers combined by tax id
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| #LOGEDOSOFT-2019 | |
| #Amac: Tedarici ve Satiscilari vergi numarasina gore gruplayarak cari ekstre gosterir | |
| #Versiyonlar: | |
| #21.12.2019:Alim fatura tarihi ellge girilen tedarikci fatura tarihinden getirildi. Tahsilat yapildiginda kapatilan fatura rakamlari getiriliyordu, direk tahsilat tutarinin getirilmesi saglandi | |
| #27.12.2019:Fis turu alani duzgun getirildi. Gereksiz kolonlar kapatildi. | |
| #27.12.2019:Satis fatura aciklamasi ozel alan olan aciklama alanindan getirildi(remarks alani kaldirildi) | |
| #18.02.2020:Alim fatura aciklamasi getirildi (remarks kaldirildi) | |
| #18.02.2020:Ceklerin vade tarihi aciklama alanina getirildi. | |
| #25.02.2020:DÜZELTME: Belge Tarihi olarak posting_date, Açıklama da ki tarihe reference_date gelmeli. |
TurkerTunali
/ Test2
Created
March 25, 2020 15:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*LOGEDOSOFT 2020 | |
| Amac: Alim irsaliyelerinde ambar ve malzeme karti kisitlamasi yapmak. | |
| Detay: | |
| - Alim irsaliyelerde sadece Ticari ve ham madde urunler gorunmeli. | |
| https://app.asana.com/0/1159095102216267/1118662457336759/f | |
| - Alim irsaliyelerde sadece Ticari malzeme ise sevk (Merkez, şube) ambarı görünmeli. HM. ise hm (Merkez, şube) ambarı görünmeli. | |
| https://app.asana.com/0/1159095102216267/1118662457336758/f | |
| */ | |
| frappe.ui.form.on('Purchase Receipt', { |
TurkerTunali
/ Test1
Created
March 25, 2020 15:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /*LOGEDOSOFT 2020 | |
| Amac: Alim irsaliyelerinde ambar ve malzeme karti kisitlamasi yapmak. | |
| Detay: | |
| - Alim irsaliyelerde sadece Ticari ve ham madde urunler gorunmeli. | |
| https://app.asana.com/0/1159095102216267/1118662457336759/f | |
| - Alim irsaliyelerde sadece Ticari malzeme ise sevk (Merkez, şube) ambarı görünmeli. HM. ise hm (Merkez, şube) ambarı görünmeli. | |
| https://app.asana.com/0/1159095102216267/1118662457336758/f | |
| */ | |
| frappe.ui.form.on('Purchase Receipt', { |
NewerOlder