you're reading...
Uncategorized

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)123456
  •  Klik nama template nya | klik  Design as FRF (Desain Sbg FRF)
    PP2

  • Klik Page 2 |  Klik IBX ke 3 dari kiri (APInvChq)PP3
  • Tekan F11 |  klik […] SQLPP4
  •  kemudian :
    -Di bagian SELECT tambahkan “k.PONO”-Setelah baris “Inner Join APInv ioni.APInvoiceID=a.APInvoiceID”tambahkan baris-baris dibawah ini :
left outer join apitmdet j on j.APInvoiceID = i.APInvoiceID and j.SEQ = 1
left outer join PO k on k.POID = j.POID

PP5

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
  • Klik tanda Checkmark |  klik Page 1
  • Klik  File | Data Dictionary
    pp6
  • Klik Invoice | New Variable
    NEW7
  • 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.

PP8

  • Klik OK | klik Close | Yes
  • Klik tab Detail |Centang Screen dan Print di kolom date | dan di ganti namanya menjadi PO NO
    P9
  • Klik Designer(Desain) | klik kolom PO NO
    PP10
  • Selanjutnya klik Insert expression | klik Variable | klik Invoice | klik PONO 2 kali
    P11
  • Klik tanda Checkmark | klik OK
  • Klik Close | Yes

(Available for v4)

Discussion

Comments are closed.

%d bloggers like this: