ACCURATE BUSINESS CENTER KEMAYORAN 

 

 

Telp. 021 - 2937 1464 / 65

Team Marketing
  •  Agus

          085 777 555 721 

          085 777 555 721

  •  Arika     ​

          0856 9482 1700

          0812 9493 0813

  •  Dewi 

          0878 7210 7373

          0813 5490 8290

  •  Raymond

          0856 9771 4094 

          0856 9771 4094

  •  Rizal

          0812 1383 4578 

          0857 1744 3233

  •  Wati

          0812 938 2595

          0812 938 2595

 

 

Informasi
Produk Kami
Manual Book Accurate Online

Berita-berita - Menampilkan nomor NPWP Vendor
  18 Apr 2016

Menampilkan nomor NPWP Vendor di preview Purchase Order

POSTED BY ADMIN ⋅ 18 APRIL  2016

ACCURATE, PROGRAM, ACCURATE ACCOUNTING SOFTWARE

Accounting Software Yach .... ACCURATE

 

Berikut langkah-langkah menampilkan nomor NPWP Vendor di preview Purchase Order :

 

  • Ke menu Setup | Form Template1
  • Klik Nama Template | klik Design as FRF2
  • Klik Page 2 | klik IBX 2 (qryPO) | tekan F11 | klik [..] SQL3
  • Tambahkan variable v.Tax1ExemptionNo, v.Tax2ExemptionNo, di bagian Select
    4
  • Sehingga keseluruhan SQL menjadi :Select p.POID, p.PONo InvoiceNo, p.PODate InvoiceDate, p.Description,
    p.ShipTo1, p.ShipTo2, p.ShipTo3, p.ShipTo4, p.ShipTo5, p.RoundedTax1Amount,p.RoundedTax2Amount,
    p.Expected, p.POAmount InvoiceAmount, p.DP Payment, p.DPUsed, p.CashDiscount, p.Rate,
    p.InclusiveTax, p.FOB, p.Rate, p.VendorIsTaxable InvoiceIsTaxable,
    p.Tax1Amount, p.Tax2Amount, p.CashDiscPC, p.Freight,
    v.Name, v.AddressLine1, v.AddressLine2, v.City, v.StateProv, v.PersonNo,
    v.ZipCode, v.Country, v.Contact, v.Phone, v.Fax, v.email, v.Webpage,
    t.TermName, t.TermMemo, cu.CurrencyName, s.Name ShipName,v.Tax1ExemptionNo, v.Tax2ExemptionNo,
    x1.TaxName TaxName1, x2.TaxName TaxName2
    ,v.CHRRESERVED1,v.CHRRESERVED2,v.CHRRESERVED3,v.CHRRESERVED4,
    v.CHRRESERVED5,v.CHRRESERVED6,v.CHRRESERVED7,v.CHRRESERVED8,
    v.CHRRESERVED9,v.CHRRESERVED10,v.CURRRESERVED1,v.CURRRESERVED2,
    v.CURRRESERVED3,v.DATERESERVED1,v.DATERESERVED2
    From PO p
    Inner Join PersonData v ON v.ID=p.VendorID
    Left Outer join Currency cu On cu.CurrencyID=v.CurrencyID
    Left Outer join TermOPmt t On t.TermID=p.TermID
    Left Outer Join Shipment s ON s.ShipID=p.ShipVia
    Left Outer Join Tax x1 ON x1.TaxCode=p.Tax1Code
    Left Outer Join Tax x2 ON x2.TaxCode=p.Tax2Code
    Where p.POID=:POID
  • Klik Checkmark | klik Page 1 | Data Dictionary
  • Klik Vendor | New Variable | masukkan NPWP 1 | Kolom Value pilih DialogForm.qryPO | klik TAX1EXEMPTIONNO
  • Klik New Variable | masukkan NPWP 2 | Kolom Value pilih DialogForm.qryPO | klik TAX2EXEMPTIONNO5
  • Klik ok | Close | Yes
  • Lalu untuk menampilkannya klik designer | klik insert rectangle object | letakkan di tempat yang diinginkan | klik insert expression variable | vendor | klik 2 kali NPWP 1 dan NPWP 2 | klik ok | ok | checkmark | klik close | yes .

(Available for version 4 & 5 )


Berita Terbaru
PENGGUNA ACCURATE