Account Receivable Setups

  • Accounts receivable is an asset account in the general ledger that documents money owed to a business by customers who have purchases goods or services on credit.
  • Accounts receivable can be contrasted with accounts payable, a liability account in the GL that documents money the business owes for the purchase of goods or services.

 

Receivables Workbenches:

Oracle Receivables Provides 4 integrated workbenches to perform most of your day–to–day Accounts Receivable operations.

  • Receipts Workbench -> You can use the Receipts Workbench to perform most of your receipt–related tasks
  • Transactions Workbench -> to process your invoices, debit memos, credit memos, on–account credits, chargebacks, and adjustments.
  • Collections Workbench -> The Collections Workbench lets you review customer accounts and perform collection activities such as recording customer calls and printing dunning letters.
  • Bills Receivable Workbench -> The Bills Receivable Workbench lets you create, update, remit, and manage your bills receivable.

Receivable Setups:

  • Define System Options
  • Define Transaction Flexfield Structure
  • Define Sales Tax Location Flexfield Structure
  • Define AutoCash Rule Sets
  • Define Receivables Lookups
  • Define Invoice Line Ordering Rules
  • Define Grouping Rules
  • Define Application Rule Sets
  • Define Payment Terms
  • Define AutoAccounting
  • Open or Close Accounting Periods
  • Define Transaction Types
  • Define Transaction Sources
  • Define Collectors
  • Define Approval Limits
  • Define Remittance Banks
  • Define Receivables Activities
  • Define Receipt Classes
  • Define Receipt Sources
  • Define Payment Methods
  •  Define Statement Cycles
  • Define System Profile Options
  • Define Salespersons
  • Define Customer Profile Classes
  • Define Customers
  • Define Remit–To Addresses

Define System Options:

Data gets stored in AR_SYSTEM_OPTIONS.

Navigation: Receivables –> Setups –> System –> System Options.

Define AutoCash Rule Sets:

Data gets stored in AR_AUTOCASH_HIERARCHIES

Navigation: Receivables –> Setups –> Receipts–> AutoCash Rule Sets.

 

Query to get Customer Bill To and Ship To Address

SELECT  hca.account_number customer_number,
hp.party_name customer_name,
hps.party_site_number site_number, hl.address1 address1,
hl.address2 address2, hl.address3 address3,
hl.address4 address4, hl.city city,
hl.postal_code postal_code, hl.state state,
ftt.territory_short_name country,
hcsua1.LOCATION bill_to_location,
hcsua2.LOCATION ship_to_location
FROM hz_parties hp,
hz_party_sites hps,
hz_cust_accounts hca,
hz_cust_acct_sites_all hcasa1,
hz_cust_site_uses_all hcsua1,
hz_locations hl,
fnd_territories_tl ftt,
hz_cust_acct_sites_all hcasa2,
hz_cust_site_uses_all hcsua2
WHERE hp.party_id = hps.party_id(+)
AND hp.party_id = hca.party_id(+)
AND hcasa1.party_site_id(+) = hps.party_site_id
AND hcasa2.party_site_id(+) = hps.party_site_id
AND hcsua1.cust_acct_site_id(+) = hcasa1.cust_acct_site_id
AND hcsua2.cust_acct_site_id(+) = hcasa2.cust_acct_site_id
AND hcsua1.site_use_code(+) = ‘bill_to’
AND hcsua2.site_use_code(+) = ‘ship_to’
AND hcasa1.org_id(+) = fnd_profile.VALUE (‘org_id’)
AND hcasa2.org_id(+) = fnd_profile.VALUE (‘org_id’)
AND hps.location_id = hl.location_id
AND hl.country = ftt.territory_code
AND ftt.LANGUAGE = USERENV (‘lang’)
ORDER BY customer_number;