Jika faktur beli dapat dilakukan dengan cara berikut :
– masuk menu pengaturan | desain cetakan | pilih desain | klik desain FRF | klik kotak ibx nomor 2 dari kiri | tekan F11 | klik bagian SQL, ganti menjadi :
Select p.*, v2.Name ShipVendor,
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,v.Tax1ExemptionNo, v.Tax2ExemptionNo,
t.TermName, t.TermMemo, cu.CurrencyName, s.Name ShipName, w.Name WarehouseName,
x1.TaxName TaxName1, x2.TaxName TaxName2,
v.CHRRESERVED1,v.CHRRESERVED2,
v.CHRRESERVED5,v.CHRRESERVED6,
v.CHRRESERVED9,v.
v.CURRRESERVED3,v.
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN APINV ON APINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE APINV.APInvoiceID = :APInvoiceID) creator
From APInv p
Inner Join PersonData v ON v.ID=p.VendorID
Inner Join WareHS w ON w.WarehouseID=p.WarehouseID
Left Outer join Currency cu On cu.CurrencyID=v.CurrencyID
Left Outer join TermOPmt t On t.TermID=p.TermsID
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
Left Outer Join PersonData v2 ON v2.ID=p.ShipVendID
Left Outer Join View_SN_ByTrans(p.APInvoiceID, ‘APINV’) sn ON sn.ID=p.APInvoiceID
Where p.APInvoiceID=:APInvoiceID
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,v.Tax1ExemptionNo, v.Tax2ExemptionNo,
t.TermName, t.TermMemo, cu.CurrencyName, s.Name ShipName, w.Name WarehouseName,
x1.TaxName TaxName1, x2.TaxName TaxName2,
v.CHRRESERVED1,v.CHRRESERVED2,
v.CHRRESERVED5,v.CHRRESERVED6,
v.CHRRESERVED9,v.
v.CURRRESERVED3,v.
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN APINV ON APINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE APINV.APInvoiceID = :APInvoiceID) creator
From APInv p
Inner Join PersonData v ON v.ID=p.VendorID
Inner Join WareHS w ON w.WarehouseID=p.WarehouseID
Left Outer join Currency cu On cu.CurrencyID=v.CurrencyID
Left Outer join TermOPmt t On t.TermID=p.TermsID
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
Left Outer Join PersonData v2 ON v2.ID=p.ShipVendID
Left Outer Join View_SN_ByTrans(p.APInvoiceID, ‘APINV’) sn ON sn.ID=p.APInvoiceID
Where p.APInvoiceID=:APInvoiceID
– klik simpan
– klik file | data dictionary | tambahkan variabel baru (nama pengguna, misal) pada bagian folder invoice | isikan dengan rumus creator.
Terakhir tambahkan variabel nama pengguna seperti biasa di desain cetakannya.
Untuk faktur penjualan juga sama, hanya SQL ganti dengan :
Select a.ARINVOICEID, a.SEQ, a.USEDINSIID,
a.USEDINSI, a.INVOICENO, a.PONOFROMDO,
a.ITEMNO, a.ITEMOVDESC, a.QUANTITY,
a.ITEMDISCPC, a.BRUTOUNITPRICE, a.UNITPRICE,
a.ITEMHISTID, a.ITEMCOST, a.ITEMCOSTBASE,
a.ITEMUNIT, a.UNITRATIO, a.ITEMTYPE,
a.UNIT1, a.UNIT2, a.UNIT3, a.RATIO2, a.RATIO3, a.NOTES,
a.INVENTORYGLACCNT, a.COGSGLACCNT, a.SALESGLACCNT,
a.SALESDISCOUNTACCNT, a.GOODSTRANSITACCNT,
a.TAXCODES, a.TAXABLEAMOUNT1, a.TAXABLEAMOUNT2,
a.ITEMRESERVED1, a.ITEMRESERVED2, a.ITEMRESERVED3,
a.ITEMRESERVED4, a.ITEMRESERVED5, a.ITEMRESERVED6,
a.ITEMRESERVED7, a.ITEMRESERVED8, a.ITEMRESERVED9,
a.ITEMRESERVED10, a.SOID, a.SOSEQ, a.SONO, a.PONOFROMSO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName, a.QuoteID, a.QuoteNo, a.SNLine, a.SNExpDate,
a.QTYCONTROL,
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN ARINV ON ARINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE ARINV.ARInvoiceID = :ARInvoiceID) creator,
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN ARINV ON ARINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE ARINV.ARInvoiceID = :ARInvoiceID) creator
From TEMPLATE_ARINVDET(:
Where 1=1
and (a.GroupSeq is null or (a.GroupSeq is not null
and (Exists (select s.Seq from ARINVDET s
inner join Item it on it.itemNo=s.ItemNo and it.ItemType=3
where it.MinimumQty=1 and s.ARInvoiceID=a.ARInvoiceID and s.Seq=a.GroupSeq))))
Order by a.Seq
a.USEDINSI, a.INVOICENO, a.PONOFROMDO,
a.ITEMNO, a.ITEMOVDESC, a.QUANTITY,
a.ITEMDISCPC, a.BRUTOUNITPRICE, a.UNITPRICE,
a.ITEMHISTID, a.ITEMCOST, a.ITEMCOSTBASE,
a.ITEMUNIT, a.UNITRATIO, a.ITEMTYPE,
a.UNIT1, a.UNIT2, a.UNIT3, a.RATIO2, a.RATIO3, a.NOTES,
a.INVENTORYGLACCNT, a.COGSGLACCNT, a.SALESGLACCNT,
a.SALESDISCOUNTACCNT, a.GOODSTRANSITACCNT,
a.TAXCODES, a.TAXABLEAMOUNT1, a.TAXABLEAMOUNT2,
a.ITEMRESERVED1, a.ITEMRESERVED2, a.ITEMRESERVED3,
a.ITEMRESERVED4, a.ITEMRESERVED5, a.ITEMRESERVED6,
a.ITEMRESERVED7, a.ITEMRESERVED8, a.ITEMRESERVED9,
a.ITEMRESERVED10, a.SOID, a.SOSEQ, a.SONO, a.PONOFROMSO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName, a.QuoteID, a.QuoteNo, a.SNLine, a.SNExpDate,
a.QTYCONTROL,
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN ARINV ON ARINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE ARINV.ARInvoiceID = :ARInvoiceID) creator,
(SELECT FIRST 1 (users.USERNAME) FROM AUDIT a
INNER JOIN ARINV ON ARINV.GLHISTID = a.GLHISTID
INNER JOIN USERS ON users.USERID = a.USERID
WHERE ARINV.ARInvoiceID = :ARInvoiceID) creator
From TEMPLATE_ARINVDET(:
Where 1=1
and (a.GroupSeq is null or (a.GroupSeq is not null
and (Exists (select s.Seq from ARINVDET s
inner join Item it on it.itemNo=s.ItemNo and it.ItemType=3
where it.MinimumQty=1 and s.ARInvoiceID=a.ARInvoiceID and s.Seq=a.GroupSeq))))
Order by a.Seq
FAC Institute hadir sebagai mitra training Accurate terpercaya
untuk menjawab kebutuhan bisnis Anda. Dengan modul lengkap dan layanan terbaik, Anda dapat mengelola pembukuan dengan lebih mudah, efisien, dan profesional.
Hubungi kami sekarang juga untuk konsultasi gratis dan nikmati layanan premium kami! Mari tingkatkan pengelolaan bisnis Anda bersama FAC Institute.
