Menampilkan Nomor Purchase Order Di Template Purchase Payment

Menampilkan Nomor Purchase Order Di Template Purchase Payment

Berikut adalah langkah – langkah untuk menampilkan Nomor Purchase Order di Template Purchase Payment :

  • Dari menu Setup (Persiapan) | Form Template (Rancangan Formulir)

Menampilkan Nomor Purchase Order Di Template Purchase Payment

  • Klik nama template nya | klik  Design as FRF (Desain Sbg FRF)

  • Klik Page 2 |  Klik IBX ke 3 dari kiri (APInvChq)

Menampilkan Nomor Purchase Order Di Template Purchase Payment

  • Tekan F11 |  klik […] SQL

kemudian :

  • -Di bagian SELECT tambahkan “k.PONO”-Setelah baris “Inner Join APInv ioni.APInvoiceID=a.APInvoiceID”tambahkan baris-baris dibawah ini :

Menampilkan Nomor Purchase Order Di Template Purchase Payment

left outer join apitmdet j on j.APInvoiceID = i.APInvoiceID and j.SEQ = 1

left outer join PO k on k.POID = j.POID

Sehingga keseluruhan menjadi :

Select ad.DiscAccount, a.*,

i.InvoiceNo, i.InvoiceDate, i.InvoiceAmount, V.PrimeOwing Owing, V.BaseOwing OwingDC, i.Description,

i.PurchaseOrderNo, t.DiscDays, t.NetDays, g.AccountName, gd.List_AccName, k.PONO

from APInvChq a

Inner Join APInv i on i.APInvoiceID=a.APInvoiceID

left outer join apitmdet j on j.APInvoiceID = i.APInvoiceID and j.SEQ = 1

left outer join PO k on k.POID = j.POID

Left Outer Join TermOPmt t on t.termID=i.TermsID

Left outer join Get_Value_PI(a.APInvoiceID) V on V.APInvoiceID=i.APInvoiceID

Left outer join APINVCHQ_DISC ad on ad.INVCHQID = a.INVCHQID and  ad.Seq =(select min(seq) from APINVCHQ_DISC where INVCHQID = a.INVCHQID)

Left outer join GLAccnt g on g.GLAccount=ad.DiscAccount

Left outer join Get_DiscAcc_VP(a.INVCHQID) gd on gd.INVCHEQ_ID = a.INVCHQID

WHERE a.ChequeID=:ChequeID

ORDER BY a.Seq

Menampilkan Nomor Purchase Order Di Template Purchase Payment

  • Klik tanda Checkmark |  klik Page 1
  • Klik  File | Data Dictionary

  • Klik Invoice | New Variable

  • Masukkan tulisan PONO | ganti kolom value menjadi DialogForm.APInvChq |  klik PONO yang ada di kolom value tsb dengan PONO yang di buat dengan New Variable.

  • Klik OK | klik Close | Yes
  • Klik tab Detail |Centang Screen dan Print di kolom date | dan di ganti namanya menjadi PO NO

  • Klik Designer(Desain) | klik kolom PO NO

  • Selanjutnya klik Insert expression | klik Variable | klik Invoice | klik PONO 2 kali

  • Klik tanda Checkmark | klik OK
  • Klik Close | Yes

Untuk Informasi Lebih Lanjut mengenai Software Akuntansi ACCURATEACCURATE Online yang cocok dengan Perusahaan Anda atau Download Gratis ACCURATE, Silahkan Menghubungi :

RIKI SAEPUL ROHMAN

Tlpn : 0822-4435-2122

Email : riki@myabcshop.com

Error “Faktur Penjualan xxx : Can Not Get Tax: Code P” 

 

 

Kami melayani penjualan ACCURATE di seluruh Indonesia.

Beli ACCURATE Jakarta, Beli ACCURATE Bekasi, ACCURATE Tangerang, ACCURATE Karawang, Beli ACCURATE Pulogadung, ACCURATE Surabaya,  ACCURATE Pasuruan, ACCURATE Makassar,  ACCURATE Medan, ACCURATE Bandung, ACCURATE Yogyakarta,  ACCURATE Denpasar, ACCURATE Manado, ACCURATE Batam, ACCURATE Banjarmasin,  ACCURATE Palembang, ACCURATE Semarang,  ACCURATE Balikpapan, ACCURATE Pekanbaru, Beli ACCURATE Ambon, ACCURATE Jayapura,  ACCURATE Kupang,  ACCURATE Padang, ACCURATE Pontianak, ACCURATE Malang,Beli ACCURATE Cikarang, ACCURATE Cibitung, ACCURATE MM2100,  ACCURATE Bantargebang, ACCURATE Solo , penjualan resmi accurate, penjualan resmi accurate, penjualan resmi accurate, accurate resmi,, accurate resmi,, accurate resmi, agen penjualan resmi accurate, agen penjualan resmi accurate, agen penjualan resmi accurate, accurate 5 accounting software, accurate 5 accounting software, accurate 5 accounting software, Beli ACCURATE 5 Accounting Software Dan RENE 2 (RESMI), Software ACCURATE Bekasi, Software ACCURATE Bekasi,

By |2017-08-14T18:59:04+00:00August 14th, 2017|Tutorial|0 Comments

About the Author:

Profesional, komitmen dan integritas. Menguasai filosofi dan seni dalam menjual

Leave A Comment

%d bloggers like this: