Menampilkan Age of Due pada Report Customer Statement

Menampilkan Age of Due pada Report Customer Statement merupakan menampilkan laporan umur piutang pelanggan yang ada di Accurate, dibawah ini menjelaskan Cara untuk menampilkan Age Of Due di ACCURATE.

Berikut adalah cara untuk Menampilkan Age of Due pada Report Customer Statement :

  1. Pada tampilan report, klik Modify lalu keluarkan satu kolom Calculated Field 7 atau diatasnya dari Available Columns.
  2. Dari tab Selected Columns & Filters, ceklis kolom tsb.
  3. Buka Designer, di tab “Data” double click IBX “First_Query”
  4. Muncul kotak SQL, lalu ganti semua menjadi,

Seperti Dibawah ini :

[box] SELECT

CUSTOMER.PERSONNO COLUMNVALUE_1,

CUSTOMER.ID PRIMARYKEYVALUE_10001,

CUSTOMER.NAME COLUMNVALUE_2,

CUSTOMER_CURRENCYID.CURRENCYNAME COLUMNVALUE_3,

CUSTOMER_CURRENCYID.CURRENCYID PRIMARYKEYVALUE_49,

CUSTOMER.ADDRESSLINE1 COLUMNVALUE_4,

CUSTOMER.ADDRESSLINE2 COLUMNVALUE_5,

CUSTOMER.ZIPCODE COLUMNVALUE_6,

CUSTOMER.CONTACT COLUMNVALUE_7,

CUSTOMER.PHONE COLUMNVALUE_8,

CUSTOMER.FAX COLUMNVALUE_9,

CUSTOMER.EMAIL COLUMNVALUE_10,

PERSON_STATEMENTSUM.INVOICENO COLUMNVALUE_11,

PERSON_STATEMENTSUM.INVOICEID PRIMARYKEYVALUE_30001,

PERSON_STATEMENTSUM.SOURCENO COLUMNVALUE_12,

PERSON_STATEMENTSUM.TRANSDATE COLUMNVALUE_13,

PERSON_STATEMENTSUM.DESCRIPTION COLUMNVALUE_14,

PERSON_STATEMENTSUM.DPRIMEAMOUNT COLUMNVALUE_15,

PERSON_STATEMENTSUM.CPRIMEAMOUNT COLUMNVALUE_16,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD1 COLUMNVALUE_17,

GET_REPORTCUSTOMFIELD.PKFIELD PRIMARYKEYVALUE_40001,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD2 COLUMNVALUE_18,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD3 COLUMNVALUE_19,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD4 COLUMNVALUE_20,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD5 COLUMNVALUE_21,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD6 COLUMNVALUE_22,

PERSON_PRIMEANDBASE.BASECURR COLUMNVALUE_23,

PERSON_PRIMEANDBASE.ID PRIMARYKEYVALUE_20001,

PERSON_PRIMEANDBASE.BBAMOUNT COLUMNVALUE_24,

PERSON_PRIMEANDBASE.BBAMOUNTDC COLUMNVALUE_25,

PERSON_PRIMEANDBASE.EBAMOUNT COLUMNVALUE_26,

PERSON_PRIMEANDBASE.EBAMOUNTDC COLUMNVALUE_27,

DATA_COUNT.DATACOUNT COLUMNVALUE_28,

DATA_COUNT.DATACOUNT PRIMARYKEYVALUE_50001,

PERSON_STATEMENTSUM.SOURCETRANS COLUMNVALUE_29,

GET_REPORTCUSTOMFIELD.CUSTOMFIELD7 COLUMNVALUE_30

,GET_TERMSDUE.AGEFRDUE

FROM

PERSONDATA CUSTOMER

LEFT OUTER JOIN PERSON_PRIMEANDBASE (CUSTOMER.ID, cast(:PARAMDATE1 as date) -1, :PARAMDATE2) ON CUSTOMER.ID=PERSON_PRIMEANDBASE.ID

LEFT OUTER JOIN PERSON_STATEMENTSUM (CUSTOMER.ID, CUSTOMER.CURRENCYID, :PARAMDATE1, :PARAMDATE2) ON PERSON_STATEMENTSUM.PPERSONID=CUSTOMER.ID AND  PERSON_STATEMENTSUM.BASECURR=PERSON_PRIMEANDBASE.BASECURR

LEFT OUTER JOIN GET_REPORTCUSTOMFIELD ON 1=1 LEFT OUTER JOIN DATA_COUNT ON 1=1

LEFT OUTER JOIN CURRENCY CUSTOMER_CURRENCYID ON CUSTOMER.CURRENCYID=CUSTOMER_CURRENCYID.CURRENCYID

LEFT OUTER JOIN ARINV ON PERSON_STATEMENTSUM.INVOICEID=ARINV.ARINVOICEID

LEFT OUTER JOIN GET_TERMSDUE (PERSON_STATEMENTSUM.INVOICEID, PERSON_STATEMENTSUM.TRANSDATE, CURRENT_DATE, ARINV.TERMSID) ON GET_TERMSDUE.TERMID=ARINV.TERMSID

WHERE 1=1

AND (CUSTOMER.PERSONTYPE = 0) AND ((PERSON_PRIMEANDBASE.EBAMOUNT <> 0) OR (PERSON_PRIMEANDBASE.EBAMOUNTDC <> 0)) AND PERSON_STATEMENTSUM.INVOICEID IS NOT NULL AND (CUSTOMER.PRINTSTATEMENT = 1)

ORDER BY

CUSTOMER.PERSONNO ASC, PERSON_PRIMEANDBASE.BASECURR ASC,

PERSON_STATEMENTSUM.TRANSDATE ASC,

PERSON_STATEMENTSUM.SOURCETRANS ASC[/box]

Menampilkan Age of Due pada Report Customer Statement

Jika sudah, klik tanda ceklis.

  1. Pindah ke tab “Report Page”
  2. Pada baris “Master Data” di kolom Calculated Field tadi, klik dan tambahkan Memo

 

[box] [IIF(<First_Query.”AGEFRDUE”>=null,’0 Days’,IntToStr(<First_Query.”AGEFRDUE”>) + ‘ Days’)][/box]

  1. Selesai, dan simpan report dengan format FR3

 

CATATAN : Nilai Age From Due dihitung dari tanggal sistem saat membuka report (tidak seperti report Outstanding Invoices yang dihitung dari parameter tanggal report).

 

Untuk Download Manualbook ACCURATE 5 Klik Disini

 

Jika Anda membutuhkan Penawaran Resmi ACCURATE klik dibawah ini :

[flm_button link_address=”https://agent.accurate.id/landing/request-quotation.do?a=LWDRW93G” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”ACCURATE 5 & RENE 2″ font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-shopping-cart”] [flm_button link_address=”https://agent.accurate.id/landing/online-offer/LWDRW93G/commercial.do” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”ACCURATE ONLINE” font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-shopping-cart”] [flm_button link_address=”https://fac-institute.com/order/” link_target=”_blank” icon_placement=”Right” small_placement=”Left” button_text=”PENAWARAN TRAINING FAC” font_family=”{CLASS-Times-New-Roman}” button_size=”MD” button_color=”Dark” button_style_icon=”Mask-Right” button_hover=”HoverB-Black” rounded_corners=”3″ icon=”fa-group”] [flm_button link_address=”https://account.co.id/cara-membeli-accurate-5/” link_target=”_blank” icon_placement=”Right” button_text=”Cara Beli ACCURATE” button_size=”MD” button_color=”Black” button_style_icon=”Lines-Right” button_style_3d=”D3″ rounded_corners=”3″ icon=”fa-shopping-cart”]

INFO : Jika anda sudah mengisi Form penawaran di Atas, anda akan dikirimkan penawaran oleh ACCURATE Cloud License service yang dikirim langsung dari ACCURATE CPSSOFT ke email yang didaftarkan.

 

Untuk Trail ACCURATE Online, Silahkan Klik Disini

Atau Hubungi :

Marketing Accurate Mal Metropolitan Cabang Bekasi

Anis Wahyu Wijaya
081299029493
Email : anis.wahyu@myabcshop.com
Alamat : Mall Metropolitan Bekasi Lt. Basement BS-06 Jl.K.H Noer Alie Bekasi Selatan 17148

 

Related Posts: