Calculating Gains and LossesSPD.docx

Calculating Gains and LossesSPD.docx

《Calculating Gains and LossesSPD.docx》由会员分享，可在线阅读，更多相关《Calculating Gains and LossesSPD.docx（16页珍藏版）》请在冰点文库上搜索。

CalculatingGainsandLossesSPD

Department

Responsibility/Role

FileName

CalculatingGainsandLosses_SPD.doc

Revision

DocumentGenerationDate

9/30/20109:

11:

00AM

DateModified

9/30/20109:

11:

00AM

LastChangedby

Status

CalculatingGainsandLosses

Trigger:

Concept

YoucanuseOraclePayablestotrackcurrencygainsandlossesinyourledgercurrencycausedbyexchangeratefluctuations.

Youcanusethefollowingdatestotrackcurrencygainsandlosses:

∙InvoiceGLdate

∙Paymentissuedate

∙Paymentmaturity（forfuturedatedpayments）

∙PaymentreconciliationorclearingwithOracleCashManagement

IfyouenablethePayablesoptiontoaccountforgainsandlossesatpaymentissuetime,OraclePayablesautomaticallycalculatesarealizedgainorlossifapaymenthasadifferentexchangeratethantheforeigncurrencyinvoiceitpays. 

Inthistopic,youwillcalculategainsandlosses,usingtheInvoiceWorkbenchpage. 

RequiredField（s）

Comments

Output-Result（s）

Comments

AdditionalInformation

Procedure

Step

Action

1.

BeginbynavigatingtotheInvoiceWorkbenchpage.

Clicktheverticalscrollbar.

2.

ClickthePayables,VisionOperations（USA）link.

3.

ClicktheInvoiceslink.

4.

TheInvoiceWorkbenchisagroupofpagesthatyouusetoenter,adjust,andreviewyourinvoicesandinvoicebatches.

UsetheInvoiceWorkbenchpagetocalculategainsandlosses.

Payablescantrackcurrencygainsandlossesinyourledgercurrencycausedbyexchangeratefluctuationsbetweenthefollowingdates:

•InvoiceGLdate

•Paymentissuedate

•Paymentmaturity（forfuturedatedpayments）

•PaymentreconciliationorclearingwithOracleCashManagement

5.

Youcanhaveasmanyrealizedgainorlossaccountsasyouneed.YoucandefinedefaultGainorLossAccountsforPayablesandoverridethemforeachbankaccountthatyouuse.

IfyouenablethePayablesoptiontoaccountforgainsandlossesatpaymentissuetime,thenPayablesautomaticallycalculatesarealizedgainorlossifapaymenthasadifferentexchangeratethantheforeigncurrencyinvoiceitpays.PayableschargestheamounttotheappropriateGainorLossaccountassignedtothebankaccountfromwhichyoucreatedthepayment.

IfyouenablethePayablesoptiontoaccountforgainsandlossesatpaymentclearingtime,PayablesautomaticallycalculatesarealizedgainorlosswhenyoucreateaccountingentriesforaforeigncurrencypaymentthatyoureconciledinOracleCashManagement.

6.

Forexample,tocalculategainsandlosses,youwillinstallGeneralLedgerandPayablesanddefineUSdollarsastheledgercurrencyforyourledger.

YouthenselectAccrualBasisasyouraccountingmethod.Youaccountforpaymentsandgain/lossatpaymenttimeonly.

Step

Action

7.

ClickintheTradingPartnerfield.

8.

EnterthedesiredinformationintotheTradingPartnerfield.Enter"GECapital".

9.

ClickintheSupplierSiteNamefield.

10.

EnterthedesiredinformationintotheSupplierSiteNamefield.Enter"BOSTON".

11.

ClickintheInvoiceDatefield.

12.

EnterthedesiredinformationintotheInvoiceDatefield.Enter"05-NOV-2007".

13.

ClickintheInvoiceNumfield.

14.

EnterthedesiredinformationintotheInvoiceNumfield.Enter"INVFRN30".

15.

ClickintheInvoiceCurrfield.

16.

EnterthedesiredinformationintotheInvoiceCurrfield.Enter"CAD".

17.

ClickintheInvoiceAmountfield.

18.

EnterthedesiredinformationintotheInvoiceAmountfield.Enter"1000".

19.

Clickthehorizontalscrollbar.

20.

ClickintheDistributionSetfield.

21.

EnterthedesiredinformationintotheDistributionSetfield.Enter"ADV".

22.

Clickthehorizontalscrollbar.

23.

ClickintheRateTypefield.

24.

EnterthedesiredinformationintotheRateTypefield.Enter"User".

25.

ClickintheExchangeRatefield.

26.

EnterthedesiredinformationintotheExchangeRatefield.Enter".600000".

27.

Clickthe2Linestab.

28.

Usethe2Linestabtoentertheinvoicedetails.

Tocalculategainsandlosses,youwillentertwoinvoices,forexampleforanamountof300pounds（GBP）withaCorporateexchangerate,andthenvalidatetheinvoices.

TheCorporateexchangerateonthedatethatyouentertheinvoicesis2:

1.Whenyouaccountfortheinvoices,Payablescreatesaccountingentriesinboththeforeigncurrency（300GBP）andyourledgercurrency（150USD）forbothinvoices,andJournalImportcreatesonejournalentryinyourledgercurrencyandoneinGBP.

29.

ClickintheAmountfield.

30.

EnterthedesiredinformationintotheAmountfield.Enter"1000".

31.

ClicktheActions...1button.

orPress[Alt+c].

32.

UsetheInvoiceActionspagetovalidatetheinvoices.

Step

Action

33.

ClicktheValidateoption.

34.

ClicktheOKbutton.

orPress[Alt+K].

Step

Action

35.

ClicktheActions...1button.

orPress[Alt+c].

36.

Whenyouaccountforthepayments,Payablescreatesaccountingentriesinboththeforeigncurrencyandyourledgercurrencyforbothpayments.Theaccountingentriesforthegainsandlossesareinyourledgercurrencyonly.

SelecttheCreateAccountingcheckboxtocreateaccountings.

Step

Action

37.

ClicktheCreateAccountingoption.

38.

ClicktheFinalPostoption.

39.

ClicktheOKbutton.

orPress[Alt+K].

Step

Action

40.

ClicktheOKbutton.

orPress[Alt+O].

Step

Action

41.

ClicktheActions...1button.

orPress[Alt+c].

Step

Action

42.

ClickthePayinFull...option.

43.

ClicktheOKbutton.

orPress[Alt+K].

Step

Action

44.

ClickintheTradingPartnerfield.

45.

ClickintheSupplierSitefield.

46.

Clickthehorizontalscrollbar.

47.

ClickinthePaymentDatefield.

48.

EnterthedesiredinformationintothePaymentDatefield.Enter"11-DEC-2007".

49.

ClickintheBankAccountfield.

50.

EnterthedesiredinformationintotheBankAccountfield.Enter"BofA-204".

51.

Clickthehorizontalscrollbar.

52.

ClickinthePaymentMethodfield.

53.

EnterthedesiredinformationintothePaymentMethodfield.Enter"Check".

54.

ClickinthePaymentProcessProfilefield.

55.

EnterthedesiredinformationintothePaymentProcessProfilefield.Enter"Check-GBP".

56.

Clickthehorizontalscrollbar.

57.

ClickintheRateTypefield.

58.

EnterthedesiredinformationintotheRateTypefield.Enter"User".

59.

EnterthedesiredinformationintothePaymentRatefield.Enter"1.2".

60.

ClickintheFunctionalAmountfield.

61.

Clickthehorizontalscrollbar.

62.

ClicktheActions...1button.

orPress[Alt+A].

63.

SelecttheCreateAccountingcheckboxtocreateaccountings.

Step

Action

64.

ClicktheCreateAccountingoption.

65.

ClicktheFinalPostoption.

66.

ClicktheOKbutton.

orPress[Alt+O].

Step

Action

67.

ClicktheToolsmenu.

orPress[Alt+T].

68.

ClicktheViewAccountingmenu.

orPress[A].

69.

UsetheSubledgerJournalEntryLinespagetoviewtheaccountingentries.

70.

JournalImportcreatesonejournalentryinyourledgercurrencyandoneinGBP.

Whenyouaccountforthepayments,Payablescreatesaccountingentriesinboththeforeigncurrencyandyourledgercurrencyforbothpayments.Theaccountingentriesforthegainsandlossesareinyourledgercurrencyonly.

71.

Youhavesuccessfullycalculatedgainsandlosses.

EndofProcedure.