ERP系统应用与实践

OracleOracleOracle2„„„„„„418418„„020020--8411118684111186„„[e-mail]@mail.sysu.edu.cnOracle3„Oracle„„„Oracle5OracleOracle„OracleOracleE-BusinessSuite150ERPOracleOracleFinancialsOracle6Oracle7Oracle8Oracle9OracleOracle„OracleOracleOracle10Oracle11Oracle13Oracle//Oracle14-Oracle15Oracle16--2211221133……2211Oracle17Oracle183410.1004.1002011002.00000.00000000.0000.000.00015,0003410.0000.1002011003.00000.00000000.0000.000.00015,000Oracle19Oracle20Oracle21Oracle221.••••••2.3.4./1.••••••2.3.4./Oracle//Oracle23OracleOracle24OracleOracleOracle…...OracleOracleOracle25GL_JE_BATCHESGL_JE_HEADERSGL_JE_LINESOracle261.GIS3.4.1.GIS3.4.Oracle//Oracle27OracleOracle281.2.3.4.1.2.3.4.Oracle//Oracle29Oracle30OracleOracle311.FSG2.3.1.FSG2.3.Oracle//Oracle32OracleGL**********Oracle33//WIP//Oracle34OracleGeneralLedger,VisionOperations(USA)Oracle36Page4631————————432AccountforTeamXXCostCenterforTeamXXCompanyforTeamXXXX-ACCOUNTXX-COSTCENTERXX-COMPANYOracle37(Page5132)————————GL-AFF-XX-VIEWXXChartofAccountsXXAccountingFlexfieldXX-ACCOUNTING-FLEXFIELDOracle38„“”„“”“OracleGeneralLedger”“”“”“”„„“”„“”Oracle39XX-COMPANYSEGMENT4ICIntercompany4XX-ACCOUNTSEGMENT3ACCTAccount3XX-COSTCENTERSEGMENT2CCCostCenter2XX-COMPANYSEGMENT1COCompany1Oracle40Oracle41Oracle421515252515151212ICICACCTACCTCCCCCOCO0000Oracle43Oracle44“”“”Oracle45„“”“”“”„“”“”“”„“”“”“”Oracle46Oracle47P5733————————OracleGeneralLedgerXX-ACCOUNTING-FLEXFIELD——…——…Oracle48„“”„“”“”„“”“”“”“”“”“OracleGeneralLedger”“”“XXACCOUNTINGFLEXFIELD”„“”“”“”„“”“”Tab„“”“”TabOracle49Oracle50Oracle51Oracle52Oracle53„“”“”TabOracle54Oracle55Oracle56“4000”“5000”“6000”“”Oracle57Oracle58„34“”“”P62„P62Oracle59P65„——————XX-CALENDARXX-MONTH„——————„——/Oracle60P68„————..DollarsDollarsFrancsFrancsYenYenPoundsPoundsOracle61„„„„Oracle62P7036„——————-----„VisionXXCorporation„XX-ACCOUNTING-FLEXFIELD„-01.110.3310.00-01.110.3510.00„“”“”01.11.9920.00Oracle63P7237„————„————XX-USCONTROLLER……„————„——Oracle64„OracleGeneralLedger„GLARAPGLOracle66„„„Oracle„„„„„Oracle67„——„——„——„——Oracle68JournalCreationMethodsManualManualEntriesEntriesCreateadjustingjournalsCreateadjustingjournalsandaccrualsandaccrualsEnterdebitsandEnterdebitsandcreditsmanuallycreditsmanuallyReversingReversingEntriesEntriesReverseanerror,revaluation,Reverseanerror,revaluation,encumbrancejournal,andencumbrancejournal,andaccrualsaccrualsReversethejournalReversethejournalamountsofaamountsofapreexistingentrypreexistingentryRecurringRecurringEntriesEntriesCreatejournalsusingfixedCreatejournalsusingfixedaccountsandamountsandaccountsandamountsandcomplexformulas.Createcomplexformulas.Createmultiplejournalswiththemultiplejournalswiththesame/similarinformation.same/similarinformation.CreatejournalsCreatejournalsusingaskeletonusingaskeletontemplate,standardtemplate,standardtemplate,orformulatemplate,orformulaMassMassAllAllocationsocationsAllocatefromoneaccounttoAllocatefromoneaccounttomanyusingasingleformulamanyusingasingleformulaCalculatejournalsusingCalculatejournalsusinganallocationformulaanallocationformulaOracle69„„„Oracle70„GL-JE-BATCHES„„Oracle71JournalComponentsJournalinformationisstoredinthreeOracleGeneralLedgertables.EnterJournalsEnterJournalsGL_JE_BATCHESGL_JE_BATCHESGL_JE_HEADERSGL_JE_HEADERSGL_JE_LINESGL_JE_LINESOracle72„.„“”“”Manual„„„„„“”Oracle73P87316„————-XX-ComputerPurchasesandSale220000„_1XX-ComputerPurchases2XX-ComputerSaleOracle74XX-ComputerPurchases80000AccountsPayable01-000-2210-21xx-0005000Cash01-000-1110-21xx-00085000ComputerandSoftware01-000-1560-21xx-000Oracle75XX-ComputerSales135000Revenue01-420-4110-21xx-000135000AccountsReceivable01-000-1210-21xx-000Oracle76„GL„——“”„——„——STAT„——GL“”Oracle77„“”N„“”“”“”“”“”OracleGeneralLedgerNB„“”NOracle78„„“”“”“”“”„“”Oracle793-17P90„Oracle80„„“”Oracle81„„„Oracle82318P91„Oracle83„————“xx%”————————„*————XX%——————“”——……Oracle84„„“”„“”“”“”“”OracleGeneralLedgerOracle85319P94„“”“”„“”“”N“”“”„“”Oracle86„“”„/Oracle87„„„“”„“”Oracle88320P98„N„Oracle89„NB„„Oracle90321P99„„T——XX%……——TOracle91322P103„Oracle92„„Oracle93N„“”“”“”“”“”“”Oracle“”„20„OracleGeneralLedgerOracle94„“”OracleGeneralLedger“”„„Oracle95„„/„„„„Oracle96(324P113)„——————…——————…“xx-%”————„Oracle97„N„„„„„„“”„OracleGeneralLedger“”Oracle98„P119,3-25Oracle99328P125„N„„„“”„Oracle100329P126„N„“”“”„„„„“”„„„Oracle101„„„„„„-„-„Oracle102„—„—“”„—„—„—„—Oracle104„OracleGeneralLedger70„Oracle105„„FSG„„„„„„„Oracle106„„„Oracle107„FSG„„„„Oracle108FSG„„„„Oracle109345P183„„“”„„Oracle110„„„10„„„Oracle111346P187„„„Oracle112350P199„„