Account Receivable
Account Receivable
Account Receivable
Accounts Receivables
NB: wherever you see “XX” as prefix, please replace it with your initials or Identification number. This will enable you to
differentiate your configurations from others.
S/N Step Status
Data Group:
Name Standard
Application Receivables
Menu AR_NAVIGATE_GUI
Request Group:
Name Receivable All
Application Receivables
Save your work and close the form.
Having defined the responsibility, we will assign it to a Superuser before we can define all the steps stated in Table 1
above.
2.2 Assign AR Responsibility to a User
If you have already created a user before, follow these steps, if you haven’t refer to General Ledger implementation Guide
on how to create a user.
Query (Search) the user you have created earlier and assign the new responsibility to the user.
To query the user, press key F11, the fields colour will change to blue, enter the user name in the “Username” field and
press Ctrl+F11 keys
Since we are using XXC General Ledger created earlier, we will set this AR profile option “GL Ledger Name” to XXC
General Ledger.
activities against transactions and receipts. You must review the default process that Receivables uses to see if it meets your
accounting requirements. You can optionally customize the Account Generator for each ledger that you have defined.
For example, if an invoice’s balancing segment that you assess administrative charges for has a value of “01” and the
balancing segment of the administrative charges is “02” when receivables accrues the charges for the invoice, the account
Additionally, you can disable balancing segment substitution for receivable activities using the AR: Disable Receivable
Activity Balancing Segment Substitution profile option. If you set this profile option
to Yes, then you must define a suspense account to ensure that the transfer to General Ledger succeeds in the event that
your activities and original transactions do not post to the same balancing segment value. This profile option does not
affect the gain, loss, and rounding accounts that you define at the system options level.
After you define your organizations and items, you must select the item validation organization in the Order Management
Parameters window. The item validation organization, which must be an item master organization, indicates the
organization that Receivables uses to validate items.
Field Value
Location XXCOUNTERHOUSE
Organization Classifications
Name Enabled
Place your cursor on the select line beneath Business Group and select
“GRE/Legal Entity” from the LOV. Check “Enabled” and save your work.
Click on the third line and select “Inventory Organization” from the LOV,
check “Enabled” box and save your work. Then click on Other (B)
Select Yes.
Enter the information as shown in the screen above. Click on OK (B)
and save your work.
Place your cursor on a line under code column and click on New (B) on the toolbar to create a new line and enter the
following:
Code Title Description View Name
XXC_STATE_LGA XXC State LGA XXC State LGA XXC_FLEX
Flexfield
Save the details you entered for State Value Set but proceed the Num Name Window Column Value Set
next step for LGA Value Set ber Prompt
10 XXC State XXC State LOCATION_ID_SEG XXC_STAT
For LGA Value Set, after selecting “Dependent” as the Validation MENT_1 E_VS
Type the “Edit Information” (B) will be enabled. Select it and enter 20 XXC LGA XXC LGA LOCATION_ID_SEG XXC_LGA_
the following: MENT_2 VS
Click on Open (B). Uncheck the Required Checkbox.
Do the same for XXC LGA.
Save your work and close the form.
Place your cursor on line 10 and click on Flexfield Qualifiers (B)
Enable the following qualifiers for XXC State segment:
Automatic Exemptions
State
Tax Account
Save your work and close the form.
Place your cursor on Line 20 and click on Flexfield Qualifier (B)
Enable Province qualifier for XXC LGA
Save your work and close the form and Segment Summary
form to return to Key Flexfield Segment window.
Check “Allow Dynamic Inserts” and “Freeze Flexfield Definition”
boxes.
Click on OK (B)
Click on Compile (B)
Select Ok (B) for the three (3) windows that will display thereafter.
7.0 Define System Options
Define your accounting, discount, tax, and invoice system options to control how Receivables works. For example, you
can determine whether to charge your customers Sales Tax or Value Added Tax (VAT). If you choose Sales Tax,
Receivables supports location based Sales Tax for your home country only. You also define your default (i.e. home)
country in the System Options window.
You can also specify a default Application Rule Set in the System Options window. An Application Rule Set determines
how Receivables reduces the balance due for debit items and their associated charges when you apply payments in the
Applications window or by using Post QuickCash. Receivables only uses this rule set if none is assigned to the debit
item's transaction type. See: Receivables Application Rule Sets. You can update the Default Country in this window at
install time, provided you have not entered any customer addresses.
NB: If you will be using flexible address formats to enter and validate your customer address information, we
recommend that you implement the seeded Sales Tax Location Flexfield structure, Country - No Validation.
Alternatively, if you use a Sales Tax Location Flexfield that contains a segment other than country and wish to set up
a flexible address format for your home Country, every component in your Sales Tax Location Flexfield structure must
also exist in your flexible address style for that country.
Path: XXC Account Receivables (N)>Setup>Systems>Systems Options
Enter the following:
Field Value
Accounting (T)
Operating Unit XXC Operating Unit
Name XXCOUNTERHOUSE PRIMARY
LEDGER
Realized Gains Account 01.04.2005
Realized Losses Account 01.04.2006
Tax Account 01.04.2003
Days per Posting Cycle 31
Field Value
Trans and Customers (T)
Show Billing Number Yes
Tax Invoice Printing Options Itemize and Sum
Document Number Generation When Saved
level
Assess Late charges Yes
Purge Interface Tables Yes
Max Memory (in bytes) 104876
Log File Message level 0
Automatic Customer Yes
Numbering
Automatic Site Numbering Yes
Grouping Rule Name DEFAULT
Field Value
Miscellaneous (T)
Split Amount 5000
Discount Basis Lines only
Days in Days Sales 365
Outstanding calculation
Allow Unearned Discount Yes
Invoice per Commit 1000
Receipt per Commit 1000
Chargeback Due Date Open Invoice Due Date
Default Territory Nigeria
Source of Territory Bill To Site
Application Rule Set Line and Tax prorate
Save your work and proceed. You can define as many payment terms as
required e.g. Immediate Payment Terms, NET 90, 2/10 Net 30 (2%
discount earned if paid in 10 days) etc.
9.0 Define Accounting Rules
If you want to recognize revenue over multiple accounting periods, you must define accounting rules. Receivables lets you define as many
accounting rules as you want. If you use an accounting rule, you must associate it with an invoicing rule. Invoicing rules determine when to
book your receivables. Receivables provides two invoicing rules: 'Bill in Advance' and 'Bill in Arrears'.
When you use accounting rules, you also need to define the appropriate periods to which your rule refers. You enter these periods in the
Calendar window and they must refer to the same period type as your accounting rule. For example, if you are using an accounting rule that
recognizes revenue monthly from Jan-93 through Jun-93, you must define periods from Jan-93 through Jun-93 where the period type is
'Month.' These periods must be defined in the same calendar as your accounting periods.
In nutshell, Accounting rules determine the number of periods and percentage of total revenue to record for each accounting period.
Fixed Schedule: prorates revenue recognition evenly over a predefined period of time.
Variable Schedule: allows to specify number of periods over which you want to recognize revenue during invoice entry
Daily Revenue Rate, All Periods: uses a daily revenue rate to calculate the precise amount of revenue for each full and partial period in the
schedule. This rule provides the most precise revenue recognition schedule possible.
Daily Revenue Rate, Partial Periods: uses a daily revenue rate to calculate the precise amount of revenue for only partial period in the schedule
Path: XXC Account Receivables (N)>Setup>Transactions>Accounting Rules
Enter the following:
Field Value
Name XXC Daily Accounting Rule
Description XXC Daily Revenue Rate, All Periods
Accounting Rule
Type Daily Revenue Rate, All Periods
Period XXCOUNTERHOUSE (the Period
Type you created in GL)
Schedule
Period 1 (automatic)
Percent 0 (automatic)
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Freight
Select Freight from the LOV and enter the segment information as shown in the screen below:
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Receivable
Select Receivable from the LOV and enter the segment information as shown in the screen below:
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Revenue
Select Revenue from the LOV and enter the segment information as shown in the screen below:
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Tax
Select Tax from the LOV and enter the segment information as shown in the screen below:
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Unbilled Receivable
Select Unbilled Receivable from the LOV and enter the segment information as shown in the screen below:
Save your work then place your cursor on the Type field and press “Arrow down Key”.
Unearned Revenue
Select Unearned Revenue from the LOV and enter the segment information as shown in the screen below:
You can associate transaction types with your invoice sources in the Transaction Sources window to speed data
entry in the Transaction and Credit Transactions windows. Active transaction types appear as list of values choices
in the Transactions, Reverse Receipts, Credit Transactions, and Transaction Sources windows.
Field Value
Name XXC Invoice Source
Type Manual
Description XXC Invoice Sources for XXC
Receivables
Active Yes
Automatic Transaction 1000
Numbering
Save your work. You can define other transaction types’ sources.
14.0 Define Collectors
Define collectors to assign to your customers through credit profile class assignments. You can use the customer account review windows and
collection reports to alert your collectors of their customer's past due items.
Receivables lets you define collectors and assign them to a profile class or to a customer's credit profile class. When you assign a collector to a
profile class, that collector becomes the collector for customers to whom you assign that profile class. You can modify collector assignments
for your customers in the Customers window and for your profile classes in the Customer Profile Classes window. You can also print collector
names and telephone numbers on dunning letters you send to your customers for past due items. Receivables displays active collectors and
their descriptions as list of values choices in the Customers, Customer Profile Classes, and Customer Calls windows. Receivables does not
display inactive collectors in the list of values for these windows. You can make an existing collector inactive by unchecking the Active check
box and then saving your work. If the collector you want to make inactive is associated with an active customer, Receivables displays a warning
message.
Path: XXC Account Receivables (N)>Collections>Collectors
Enter the following
If you use the Credit Memo Request Approval workflow, enter the collector's employee name or select it from the list of values. Receivables
uses this information to ensure that the collector is also an employee and therefore can receive workflow notifications.
Field Value
Name XXC Collector 1
Description Collection for XXC South-South Region
Correspondence Adamu Johnson
Telephone Number 08012345678
Employee Name No (if HRMS is installed, select a name)
Group No
Save your work and close the form.
15.0 Define Approval Limit
Assign adjustment approval limits to each user to control adjustments made to
invoices, debit memo, and chargebacks. Receivables lets you assign approval
limits by currency. These limits are used in the Adjustments, Approve
Adjustments, and Receipts windows.
Path: XXC Account Receivables (N)>Setup<Transactions>Approval Limit
Enter the following:
Field Value
User Name XXCOUNTERHOUSE
Document Type Adjustment
Currency NGN
From Amount 1
To Amount 5,000,000
Save your work and close the form. You can define approval
limit for other document types.
16.0 Define Remittance Banks
Proceed to the next step if you have already defined your remittance banks in Oracle Payables. Define all of the banks and bank accounts
you use to remit your payments. You can define as many banks and bank accounts as you want, but each bank account must refer to one
currency. Receivables requires that you enter a cash account for each bank account.
You can define a bank or a clearing house. Define Banks to record external banks where your customers are the account holders of
disbursement accounts. Define Clearing Houses to record banks that process a magnetic tape of your receipt information which you send
to them. These clearing institutions then create tapes of your customer receipt information which they forward to each of your remittance
banks.
Path: XXC Account Receivables (N)>Setup>Receipts>Banks
Field Value
Name XXC Receipt Classes
Creation Method Manual
Remittance Method No Remittance
Clearance method Directly
Name XXC Receipt Method
Printed Name XXC Receipt Method
Save your work and click on Bank Accounts (B) to enter the bank details.
NB: you have to define receivable activities for earned and unearned discounts
before you can enter the remittance bank details. If you haven’t, perform the task
in 17.0 above and choose earned discount and unearned discount as type for
earned and unearned discounts receivable activities respectively.
Also, you must have assigned a bank to the operating unit in Payables or Cash
Management.
19.0 Receipt Sources
Define receipt batch sources to provide default values for the receipt class, receipt method, and remittance bank account fields for receipts you add to a
receipt batch. You can accept these default values or enter new ones. Receipt batch sources can use either automatic or manual batch numbering.
Path: XXC Account Receivables (N)>Setup>Receipt>Sources
Enter the following: