Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO

Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO

Apabila ada kondisi pada saat pembuatan Sales Order memasukkan beberapa nomor Purchase Order atas barang tersebut berbeda dan ketika di preview di DO ingin di munculkan keseluruhan nomor PO nya tersebut, silahkan dijalankan langkah panduan berikut ini :

  1. Masuk ke dalam Setup | Form template | masuk ke dalam template Delivery Order yang digunakan
  2. Masuk ke dalam Design As FRF
  3. Pilih tab Page 2
  4. Pilih IBX kedua dari kiri (qrySIARInv: TfrIBXQuery) | tekan F11
  5. Di bagian sebelum baris from ARINV a silahkan tambahkan SQL berikut ini :

Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO

,(select LIST(distinct so.PONO) from so

where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)

) LISTPONO

  1. Sehingga keseluruhan SQL-nya menjadi seperti ini :

select a.*,

x1.TaxName TaxName1, x1.Rate Tax1Rate, x2.TaxName TaxName2,

c.ADDRESSLINE1, c.ADDRESSLINE2, c.CITY, c.CONTACT, c.COUNTRY, c.DEFAULTINVDESCRIPTION,

c.NAME, c.PERSONNO, c.PHONE, c.STATEPROV, c.ZIPCODE, c.TAX1EXEMPTIONNO, c.PersonMessage,

c.Fax, c.Email, c.WebPage, c.TaxAddress1, c.TaxAddress2, c.TAX2EXEMPTIONNO,

t.TERMNAME, t.NetDays, t.TERMMEMO, cu.CURRENCYNAME, s.FIRSTNAME, s.LASTNAME, v.NAME SHIPNAME,

w.Name WarehouseName, br.ExchangeRate BankRate

,c.CHRRESERVED1,c.CHRRESERVED2,c.CHRRESERVED3,c.CHRRESERVED4,

c.CHRRESERVED5,c.CHRRESERVED6,c.CHRRESERVED7,c.CHRRESERVED8,

c.CHRRESERVED9,c.CHRRESERVED10,c.CURRRESERVED1,c.CURRRESERVED2,

c.CURRRESERVED3,c.DATERESERVED1,c.DATERESERVED2, sn.SNList

,(select LIST(distinct so.PONO) from so

where so.SOID in (select SOID from arinvdet f where f.arinvoiceid=a.arinvoiceid)

) LISTPONO

from ARINV a

Inner join PersonData c on a.CustomerID=c.ID

Inner Join Currency cu on c.CurrencyID=cu.CurrencyID

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

Left Outer Join Salesman s on a.SalesmanID=s.SalesmanID

Left Outer Join Shipment v on a.ShipVia=v.ShipID

Left Outer Join Tax x1 ON x1.TaxID=a.Tax1ID

Left Outer Join Tax x2 ON x2.TaxID=a.Tax2ID

Left Outer Join WareHS w ON w.WarehouseID=a.WarehouseID

Left Outer Join Currency br on br.CurrencyID=(select CurrencyID from GLAccnt where GLAccount=a.DepositTo)

Left Outer Join View_SN_ByTrans(a.ARInvoiceID, ‘ARINV’) sn ON sn.ID=a.ARInvoiceID

Where a.ARInvoiceID=:ARINVOICEID

Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO

  1. Masuk ke dalam designer | di bagian kolom yang akan di tampilkan nomor PO nya tersebut silahkan diisikan dengan [DialogForm.qrySIARInv.”LISTPONO”]
  2. Save & close

Menampilkan Daftar PO No Yang Ada di SO Saat Preview DO

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

 

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-11T12:05:13+00:00 Agustus 11th, 2017|Tutorial|0 Comments

About the Author:

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

Leave A Comment

%d blogger menyukai ini: