Menampilkan SO DATE di Preview Sales Receipt

Bagaimana menampilkan SO Date di masing-masing faktur(SI) yang dilunasi di preview Sales Receipt :

  1. Setup | Form Template | Sales Receipt. Edit Template yang dimaksud.
  2. Klik button Design As frf, lalu pilih Page2. Klik sekali di IBX ke dua dari kanan(ARInvPmt: TfrlBXQuery), kemudian tekan F11 di keyboard, double klik bagian SQL.
  3. Tambahkan :
  • “x.SODate” sebelum “from ARInvPmt a“
  • Tambahkan “Left outer join SO X on X.SOid =c.SOid” setelah baris “from ARInvPmt a“
  • Tambahkan “inner join ARInvdet c on c.ARInvoiceID=a.ARInvoiceID” di sebelum “where 1=1“

4. Klik tanda cawang(ok) lalu kembali ke Page1.

5. Di designer tsb, dimana kita mau tampilkan SO Date, silahkan isi dengan [qryARInvPMT.SODate] di Text Editor nya.

Catatan :

Jika Sales Invoice yang dilunasi tsb mengambil dari beberapa SO, maka baris Invoice akan ditampilkan sebanyak SO dengan informasi masing-masing SO Date nya.

Gallery | This entry was posted in Template. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s