Berikut cara menampilkan nama user yang membuat transaksi di preview Other Payment
1.Ke Menu Setup | From Template
2. Klik nama template | klik Design as FRF
3. Klik IBX 2 | klik F11 | Klik [::] SQL
4. Sebelum WHERE, tambahkan:
left outer join audit on audit.GLHISTID = j.GLHISTID
left outer join users on users.USERID = audit.USERID
5. Sebelum FROM, tambahkan:
, users.USERNAME
6. Sehingga keseluruhan menjadi :
Select j.*
, d.GLAccount Bank, g.AccountName, d.Rate, d.PrimeAmount Amount, c.CurrencyName, users.USERNAME
From JV j
Inner Join JVDet d On d.Seq=0 and d.JVID=j.JVID
Inner Join GLAccnt g On g.GLAccount=d.GLAccount
Inner Join Currency c On c.CurrencyID = g.CurrencyID
left outer join audit on audit.GLHISTID = j.GLHISTID
left outer join users on users.USERID = audit.USERID
Where j.JVID=:JVID
7. Klik Close (X) dan pilih Yes
8. Klik Designer
9. Klik Insert Rectangle Object dan letakkan dibagian misalkan footer template
10. Masukkan variable [DialogForm.JV.”USERNAME”] di kolom insert rectangle object tsb.
11. Checklist kolom tsb | Klik Close (x) | Yes.
(Available for ACCURATE 4 & 5)