Friday, November 30, 2018

Remit to Address in Inovice

Let em give you query to find this from backend -

select Address1, address2, address3 telephone, address4 email
from ra_customer_trx_all rct,
     HZ_CUST_ACCT_SITES_ALL hcta,
     HZ_PARTY_SITES hps,
     HZ_LOCATIONS hl
where rct.customer_trx_id = P_customer_trx_is
and hcta.cust_acct_site_id = rct.remit_to_address_id
and hcta.party_site_id = hps.party_site_id
and hps.location_id = hl.location_id;

Now about the setup -
1. Receivables > Setup > System > System Options

2. Ensure that “Print Remit to Address” check box checked

3. Navigate to System profile option window
(N): System Administrator > Profile > System

4. Navigate to the Remit-To Address Form
(N): Receivables > Setup > Print > Remit To Address > Create Remit-To Address



No comments:

Post a Comment