Vietnam Receipt Voucher Report
The Vietnamese statutory receipt voucher (Phiếu thu) — each cash receipt in the local voucher format with payer, accounts, amount, and approver, as Vietnamese cash rules require.
Related The receipts counterpart to the Vietnam Payment Voucher Report.
Run note · Performance The subledger (XLA) join — especially Projects-to-XLA — is a known BI Publisher performance trap on large ledgers. Pre-join it in the warehouse, or apply tight ledger, period, and source filters before running online.
Sample build of the Vietnam Receipt Voucher Report — reconciled, and rendered tool-neutral so it runs in Power BI, ThoughtSpot, or Tableau.
| Voucher No | Date | Payer | Account | Amount | Approver |
|---|---|---|---|---|---|
| 1001 | 2026-04-30 | Sample | 1000-2100-000 | $1,240,500.00 | Sample |
| 1002 | 2026-03-31 | — | 1000-5400-000 | $842,150.75 | — |
| 1003 | 2026-02-28 | Sample | 1000-1410-000 | $96,400.00 | Sample |
| 1004 | 2026-01-31 | — | 2000-2100-000 | $1,005,233.10 | — |
| 1005 | 2025-12-31 | Sample | 1000-6300-000 | $58,720.40 | Sample |
| 1001 | 2026-04-30 | Sample | 1000-2100-000 | $1,240,500.00 | Sample |
The report reads AR receipts tied to their XLA accounting in the Vietnamese receipt-voucher layout.
Eight vouchers have no approver recorded — Vietnamese cash rules require an authorized approver on every receipt voucher.
Enforce the approval step on receipt vouchers; a missing approver invalidates the statutory voucher.
This is the report's BI Publisher data model — the SQL data set BI Publisher runs against Oracle tables to produce the output. The same SQL becomes a dbt model in your warehouse, so one definition drives both the formatted report and the analytics layer.
Data sources
Show / hide SQL
select
hp.party_name PAYER_NAME ,hca.account_number customer_num
,acra.comments
,acra.receipt_number
,to_char(acra.receipt_date,'DD-MON-YYYY','nls_date_language=American') receipt_date
,gcc.segment4 CASH_ACCOUNT
,ieba.bank_account_number CUST_BANK_ACCOUNT
,ieba.bank_name CUST_BANK_NAME
,acra.amount RECEIPT_AMOUNT
,acra.currency_code CURRENCY
,(case when rcta.COMMENTS is not null then
rcta.trx_number ||'-'|| rcta.COMMENTS
else
rcta.trx_number
end) Narrative
,araa.amount_applied --,acra.amount * nvl(acra.exchange_rate,1) functional_amount
,araa.amount_applied * nvl(acra.exchange_rate,1) functional_amount
,gcc.segment4 DR_ACCOUNT
,b.segment4 CR_ACCOUNT
from gl_je_lines gjl , gl_code_combinations b
,gl_je_headers gjh
,gl_import_references gir
,xla_ae_lines xlal
,xla_ae_headers xlah
,xla_transaction_entities xlate
,xla_distribution_links xladl
,ar_distributions_all ada
,ar_receivable_applications_all araa
,ar_cash_receipts_all acra
,gl_ledgers gl
,ce_bank_acct_uses_all cbaua
,ce_bank_accounts cba
,gl_code_combinations gcc
,hz_parties hp
,hz_cust_accounts hca
,iby_ext_bank_accounts_v ieba
,ra_customer_trx_all rcta
where 1=1
and gjl.code_combination_id=b.code_combination_id
--and gjl.je_header_id in (149065,149066)
and gjl.je_header_id=gjh.je_header_id
and gir.je_header_id = gjl.je_header_id
and gir.je_line_num = gjl.je_line_num
and xlal.gl_sl_link_id = gir.gl_sl_link_id
and xlah.ae_header_id= xlal.ae_header_id
and xlate.entity_id =xlah.entity_id
and xladl.ae_header_id = xlal.ae_header_id
and xladl.ae_line_num = xlal.ae_line_num
and xlal.application_id =222
and xladl.source_distribution_type ='AR_DISTRIBUTIONS_ALL'
and xladl.accounting_line_code ='RCT_DEFAULT_APP'
and xladl.source_distribution_id_num_1 = ada.line_id
and ada.source_id = araa.receivable_application_id
and araa.display='Y'
and xlal.ledger_id = gl.ledger_id
and gl.ledger_category_code ='PRIMARY'
and gl.name ='PL VIETNAM VND GAAP'
and acra.cash_receipt_id = araa.cash_receipt_id
and acra.remit_bank_acct_use_id = cbaua.bank_acct_use_id
and cbaua.bank_account_id = cba.bank_account_id
and cba.asset_code_combination_id=gcc.code_combination_id
and acra.pay_from_customer = hca.cust_account_id
and hca.party_id = hp.party_id
and acra.customer_bank_account_id =ieba.bank_account_id (+)
and araa.display = 'Y'
and araa.applied_customer_trx_id = rcta.customer_trx_id
and acra.receipt_date between :p_from_date and :p_to_date
and acra.receipt_number = NVL (:p_receipt,acra.receipt_number)
and ((hca.account_number IN (:p_cust_num)) OR COALESCE (:p_cust_num,null) is null )
AND acra.org_id IN (
SELECT distinct bu.bu_id
FROM fusion.fun_all_business_units_v bu
,fusion.fun_user_role_data_asgnmnts role
,fusion.per_users pu
,fusion.per_roles_dn_vl pr
,fusion.per_roles_dn_tl prtl
WHERE role.org_id = bu.bu_id
AND pu.user_guid = role.user_guid
AND pr.role_common_name = role.ROLE_NAME
and role.active_flag ='Y'
and pu.username = fnd_global.user_name
and pr.role_id=prtl.role_id
and prtl.LANGUAGE='US'
and prtl.ROLE_NAME in ('XXC Receivables Inquiry')
AND BU.SHORT_CODE ='VN BU VND'
)The data-warehouse model — one fact surrounded by conformed dimensions (what you slice by) and measures (what you aggregate), expressed as dbt so it migrates with you. Grain: one row per source transaction.
| Element | Type | Definition |
|---|---|---|
| AR_RECEIVABLE_APPLICATIONS_ALL | dimension | dimension |
| XLA_AE_LINES | dimension | dimension |
| GL_CODE_COMBINATIONS | dimension | dimension |
| HZ_CUST_ACCOUNTS | dimension | dimension |
| Amount | measure | measure |
Every source object behind this report. Each linked table has its own page with full column descriptions, drawn from the Oracle BICC lineage and articulated for practitioners.
| Table | Reporting columns | Subject areas |
|---|---|---|
| AR_CASH_RECEIPTS_ALL | 25 | 9 |
| AR_RECEIVABLE_APPLICATIONS_ALL | 35 | 2 |
| XLA_AE_LINES | 23 | 17 |
| GL_CODE_COMBINATIONS | 7 | 61 |
| HZ_CUST_ACCOUNTS | 14 | 43 |