Modifikasi Jitu 2 way (Template Received Item) < Accurate Accounting
PROGRAM AKUNTANSI TERBAIK DAN TOP BRAND DI INDONESIA: ACCURATE ACCOUNTING DAN RENE POINT OF SALE UNTUK SEMUA JENIS USAHA BISNIS ANDA. HUBUNGI KAMI DI 081318986619, KAMI SIAP UNTUK MEMBANTU ANDA
accurate accounting, point of sale, mesin kasir, sistem akuntansi, program akuntansi, program kasir, program toko, program kasir alfamart, program kasir supermarket, program kasir restoran, program kasir klinik, program kasir apotik, program kasir bengkel, program akuntansi dagang, program akuntansi pabrik, pabrikasi, pajak, perpajakan, dagang, jasa, kontraktor, accouting software, software akuntansi, program pembukuan, accurate business center, accurate online, abc accurate, training accurate, pelatihan accurate, kursus accurate, implementasi accurate accounting, accurate jakarta, accurate jakarta barat, accurate jakarta timur, accurate bekasi, accurate jakarta utara, accurate jakarta selatan, accurate jakarta pusat, accurate bekasi, accurate tangerang, accurate banten, accurate kupang, accurate indonesia, konsultan accurate, konsultan accurate accounting, konsultan point of sale, szeto accurate consultant, training accurate terbaik, jasa training accurate, jasa pelatihan accurate, jasa konsultan accurate, konsultan accurate terbaik, implementor accurate, jasa implementor, jasa implementor terbaik
22552
post-template-default,single,single-post,postid-22552,single-format-standard,ajax_updown_fade,page_not_loaded,,select-theme-ver-3.8.1,wpb-js-composer js-comp-ver-5.1.1,vc_responsive
 

Modifikasi Jitu 2 way (Template Received Item)

May 22, 2018 In Tips & Trik Accurate 5 Desktop By Cornelis_Mauboy

Modifikasi Jitu 2 way (Template Received Item)

Untuk membaca artikel: Modifikasi Jitu 2 way (Template Received Item)  Klik Link download PDF di bawah ini.

Copy Script

Select a.APINVOICEID, a.SEQ, a.BILLID,
a.INVOICENO PINO,
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.UNBILLEDACCOUNT,
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.POID, a.POSEQ, a.PONO,
a.DEPTID, a.DEPTNO, a.DEPTNAME,
a.PROJECTID, a.PROJECTNO, a.PROJECTNAME,
a.WAREHOUSEID, a.NAME WPIName, a.ReqNo RequestNo, a.SNLine, a.SNExpDate,
a.QTYCONTROL, pod.Quantity POQTY, pod.QtyRECV POQTYRECV, p.PODate
From TEMPLATE_APITMDET(:APInvoiceID) a
Left Join PO p on p.POID = a.POID
Left Join PODET pod on a.poid = pod.poid and a.poseq = pod.seq
Where 1=1
Order by A.APInvoiceID, a.SEQ

No Comments

Sorry, the comment form is closed at this time.