set up earnest money deposit

8/18/2019 Set Up Earnest Money Deposit

1/24

Set Up Earnest Money Deposit

In order to integrate with Accounts Receivables and Accounts Payables, set up the following in

Oracle Financials.

Using the Syste Adinistrator responsibility set the value of the profile option AR: Deposit

Offset Account Source as !ransaction !ype at the site and responsibility level.

Flexfeld Segments

". Using the Receivables responsibility, navigate to #$% Setup &Financials & Fle'fields &

(escriptive & Segents. )lic* the Find icon to search for and display the Receivables

+ine !ransaction Fle'field. !he )onte't Field alues region will display -(

!ransactions in the )ode colun.

/. Unselect the Free0e Fle'field (efinition chec*bo'. A )aution popup appears1 Unfree0ing

this fle'field and a*ing changes to the segent definitions could affect the validity of

the data already e'isting for this fle'field. )lic* O* to continue.


2/24

Note: !hese segents ay already be seeded in your instance, please chec* for the before you

enter any user2defined segents.

3. Click Segments and enter the segments for the EMD Transactions. Enter the

following in the Segments window.

3. Save your wor* and close the Segents window. -'it fro the (escriptive Fle'fields

Segents window.


3/24

Transaction Types

". Using the Receivables responsibility, navigate to Receivables & Setup & !ransactions &

!ransaction !ypes.

/. -nter inforation to setup the following transaction types1 -( (eposit, -( )redit

eo and -( Invoice.

4. For -( (eposit setup, enter the following inforation in the !ransaction !ypes

window1

o $ae1 -( (eposit

o )lass1 (eposit

o !ransaction Status1 Open

o Invoice !ype1 -( Invoice

o Start (ate1 any start date

o (escription1 (eposit !ransaction !ype for -( fro Oracle Sourcing

o )reation Sign1 Positive Sign

o Printing Option1 Print

o )redit eo !ype1 -( )redit eo

3 Select the following chec*bo'es1

• Open Receivable

• Post to 5+

• $atural Application Only

6 )lic* the Accounts tab and enter the following account inforation1

• Receivable Account1 enter the appropriate account code

• Revenue Account1 enter the appropriate account code


4/24

7 )lic* the (eposit tab and enter the following account inforation1


• Offset Account1 enter the appropriate account code

8 Save your wor*.

!he !ransaction !ypes window appears as follows for the -( (eposit !ransaction !ype1

9 . For -( )redit eo setup, enter the following inforation in the !ransaction !ypes

window1


5/24

• $ae1 -( )redit eo

• )lass1 )redit eo

• !ransaction Status1 Open

• Start (ate1 any start date

• (escription1 )redit eo for refunding -( aount in Oracle Sourcing

• )reation Sign1 $egative Sign

• Printing Option1 Print

:. Select the following chec*bo'es1

• Open Receivable

• Post to 5+


"; .)lic* the Accounts tab and enter the following account inforation1



"". Save your wor*.

!he !ransaction !ypes window appears as follows for the -( )redit eo !ransaction !ype1


6/24

For -( Invoice setup, enter the following inforation in the !ransaction !ypes window1

• $ae1 -( Invoice

• )lass1 Invoice

• !ransaction Status1 Open

• Start (ate1 any start date

• (escription1 Regular Invoice

• )reation Sign1 Positive Sign

• Printing Option1 Print

Select the following chec*bo'es1

• Open Receivable

• Post to 5+


)lic* the Accounts tab and enter the following account inforation1


7/24



Save your wor*.

!he !ransaction !ypes window appears as follows for the -( Invoice !ransaction !ype1


8/24

AutoAccounting

$avigate to Receivables & Setup & !ransactions & AutoAccounting and select the operating unit.

Search for the !ype with a value of Revenue. In the Segent colun, the Accounts row should

have a value in the !able $ae colun.

Assigning Sequential Numbering to the ollowing EM entities

Using the Syste Adinistrator responsibility, navigate to Application & Se


9/24

-nter the following in the (ocuent tab using the table inforation below

Save your wor*. !he window appears as follows1

)lic* the Assignent tab to enter docuent se


10/24

• -(2)ash

• -(2)hec*

• -(2)redit

• -(2(eand (raft

Save your wor*. !he Assignent window appears as follows1

!atch Source

". Using the Receivables responsibility, navigate to Setup & !ransactions & Sources & #!%

>atch Source to set up a batch source. -nter the following in the >atch Source window1

o Operating Unit1 the default operating unit

o $ae1 -( !ransaction Source

o !ype1 anual

o (escription1 -( transaction sources for transactions fro Oracle Sourcing

/. Select the following chec*bo'es1

o Active


11/24

o Autoatic >atch $ubering

o Autoatic !ransaction $ubering

4. -nter the reaining inforation in the >atch Source tab1

o +ast $uber1 :::

o Reference Field (efault alue1 interface=header=attribute"

o Standard !ransaction !ype1 -( (eposit

o )redit eo >atch Source1 -( !ransaction Source

3. Save your wor*. !he window appears as follows1

-nter the following inforation for the ne't batch source 2 -( Iport Invoice >atch

Source1


12/24

• Operating Unit1 the default operating unit

• $ae1 -( Iport Invoice >atch Source

• !ype1 Iported

• (escription1 -( Iport Invoice >atch Source

Select the following chec*bo'es1

• Active

• Autoatic >atch $ubering

• Autoatic !ransaction $ubering

-nter the reaining inforation in the >atch Source tab1

• +ast $uber1 :::

• Reference Field (efault alue1 interface=header=attribute"

• Standard !ransaction !ype1 -( Invoice

• )redit eo >atch Source1 null

Save your wor* and close the >atch Sources window.

Using the sae responsibility, create eo lines by navigating to1 #$% Receivables & Setup &

!ransactions & eo +ines.

-nter the following inforation1


•

$ae1 -( eo +ine #Invoice%

• (escription1 -( eo +ine #Invoice%

• !ype1 +ine



13/24

• Account (escription1 Operations2$o (epartent2Reserve for Returns2$o Sub Account2

$o Product

• Active (ates1 "2$O2/;;9

Save your wor*, your window appears as follows1

"ayment Terms

". Using the sae responsibility, enter ? confir the Payent !ers. $avigate to #$%

Receivables & Setup & !ransactions & Payent !ers. -nter the following inforation

for creating a new payent ter1

o

$ae1 I-(IA!-

o (escription1 !er for chargebac* or debit eo

o >ase Aount1 ";;

o (iscount >asis1 Invoice Aount


14/24

o -ffective (ates1 ;"2@A$2":77

o Installent Options1 Include ta' and freight in first installent

/. In the Payent Schedule region, enter the following1

o Se


15/24

#eceipt $lass

". Using the Receivables responsibility, enter the Receipt )lass. $avigate to #$%

Receivables & Receipts & Receipts )lasses.

/. In the Receipt )lass region, enter the following1

o $ae1 -( anual

o )reation ethod1 anual

o Reittance ethod1 Standard

o )learance ethod1 >y Autoatic )learing

4. In the Receipt ethod region, enter the following1

o $ae1 -(2)ash

o Printed $ae1 -(2)ash

o -ffective (ates1 ;"2$O2/;;9

3. Save your wor*, the Receipt )lasses window appears as below1


16/24

)lic* >an* Accounts to enter the Reittance >an* inforation1

• Operating Unit1 the selected operating unit

• >an* $ae1 enter a ban*

• >ranch $ae1 enter a branch

• )urrency1 US(

• Account $ae1 enter an account nae

• iniu Receipt Aount1 ;


17/24

• -ffective (ates1 enter effective dates

Select the Priary chec* bo'.

-nter the following in the 5+ Accounts tab1

)ash1 enter the appropriate account code

• Receipt )onfiration1 enter the appropriate account code

• Reittance1 enter the appropriate account code

• >an* )harges1 enter the appropriate account code

• Unapplied Receipts1 enter the appropriate account code

• Unidentified Receipts1 enter the appropriate account code

• On Account Receipts1 enter the appropriate account code

• Unearned (iscount1 Unearned (iscounts

• -arned (iscounts1 -arned (iscounts

• )lai Investigations1 )lai Investigation

Save your wor* and close the Reittance >an* window.


18/24

EMD-Check Receipt Class

-nter the Receipt )lass details in the Receipt )lass region1

• $ae1 -( anual

• )reation ethod1 anual

• Reittance ethod1 Standard

• )learance ethod1 >y Autoatic )learing


19/24

-nter the following in the Receipt ethod region1

• $ae1 -(2)hec*

• Printed $ae1 -(2)hec*

• -ffective (ates1 a date

)lic* >an* Accounts to enter the Reittance >an* inforation1

• Operating Unit1 your selected operating unit



• )urrency1 US(






• )ash1 enter the appropriate account code









20/24



Save your wor*.

EMD-Demand Draft Receipt Class

In the Receipt )lass region, enter1

• $ae1 -( anual

• )reation ethod1 anual

• Reittance ethod1 Standard

• )learance ethod1 >y Autoatic )learing

In the Receipt ethod region, enter the following1

• $ae1 -(2(eand (raft

• Printed $ae1 -(2(eand (raft



• )urrency1 US(






• )ash1 enter the appropriate account code



21/24









Save your wor* and close the windows.

#ecei%able Acti%ity

Using the Receivables responsibility, navigate to #$% Receivables & Setup & Receipts &

Receivable Activities. -nter the Receivable Activity inforation as below.


• $ae1 Refunds

• (escription1 Refunds

• !ype1 Refund

Select the Active chec* bo'.

In the Accounting region, enter the following1

• 5+ Account Source1 Activity 5+ Account

• !a' Rate )ode Source1 $one

• Activity 5+ Account1 enter the appropriate account code

• 5+ Account (escription1 Operations $o (epartent AR?AP )learing $o sub

Account


22/24

Save your wor*, the window appears as follows1

#eceipt Sources

". Using the Receivables responsibility, enter the Receipt Sources. $avigate to Receivables

& Setup & Receipts & Receipt Sources and enter the following inforation1


o $ae1 -( Receipt Source

o (escription1 -( Receipt Source

/. In the Receipt Source !ype region, select the anual radio button.

o Receipt )lass1 -( anual

o In the >atch $ubering region, select the Autoatic radio button

o +ast $uber1 ";/

o -nter the -ffective (ates


23/24

#ecei%ables System &ptions

". $avigate to Receivables & Setup &Syste & Syste Options. -nter the following

Receivables Syste Options as below1

In the Accounting tab enter1


o $ae1 the default operating unit

o Reali0ed 5ains Account1 enter the appropriate account code

o Reali0ed +osses Account1 enter the appropriate account code

o !a' Account1 enter the appropriate account code

o )ross )urrency Rate !ype1 )orporate

o )ross )urrency Rounding Account1 enter the appropriate account code

o Beader Rounding Account1 enter the appropriate account code

o Select Autoatic @ournal Iport chec* bo'


24/24

o Select Beader +evel Rounding chec* bo'

o (ays per Posting )ycle1 3;

set up earnest money deposit

Documents