PCBAComputingFinanceTraining_Tom_update1

PCBAComputingDoumen–BaanIVFinancialTraining17.Jan.07PresentedbyTom.Shen2FlexComputingCustomers3FinancialBaanIVTrainingWhatShouldwebeOperatinginBaanIVNow?Let’shaveaquickoverview…….BaanIVOverview---BaanIV4Subjective&Scope•Introduction&Overview•FinancialIntegrationOverview&BaanStructure•IntegrationDefinition•AccountsPayable(Localvs.GSSC)•AccountsReceivable(Localvs.Labuan)•GeneralLedger(GLCode&Dim)•FixedAsset•Costing•FinancialStatements•MasterDataSetUp•Parameter•ChartofAccount•TransactionType•IntegrationElement•TransactionTypebyTransactionOriginal•Others(IPRSystem,OutlookSoft……)5Introduction&Overview•LogininBaansystem6SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudgetsCostAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsFinancialIntegrationOverview&BaanStructure(i)OriginalTransactionPosting7InventorySalesProductionServiceTransactionOriginalTableFinancialIntegrationProgram•DetermineLedgerAccounts•DefineDimension•DefineFinancialTransactionTypeFinancialTransactionTableGLAP/AR/FA/COST/….PurchaseIntegrationPostingBatchFinalizationFinancialIntegrationOverview&BaanStructure(ii)8IntegrationIntroduction•Financialintegrationoccursasaresultofanactivitywhichoccursinanylogisticmoduleswhichafinancialtransactionmustberecorded•Examplesoflogisticactivities:*Receivinggoods*Deliveringgoodstocustomer*Revaluingthestandardcostofanitem•Oncesuchanactivityoccurs,informationneedstobesenttoFinance•Pre-definedmappingautomaticallyselectsappropriateledgeraccounts&dimensions9IntegrationDefinitionTransactionOriginFinancialTransactionPurchaseProductionSales…….ReceiptIssueInvoice……..TransactionElementDateCustomerSupplierPart…….10TransactionTypeTransactionCategoryTypeDescriptionTransactionCategoryCurCDJCURRENCYDIFFERENCEJournalVouchersUSDCDPA/PCURRENCYDIFFERENCESPurchaseCorrectionsUSDCDSA/RCURRENCYDIFFERENCESSalesCorrectionsUSDDG1IND'L&COMMERCIALBANK-RMBCashRMBDJ1BANKOFCOMMUNICATIONS-RMBCashRMBDJ2BANKOFCOMMUNICATIONS-HK$CashHKDDJ3BANKOFCOMMUNICATIONS-US$CashUSDDPHPETTYCASH-HK$CashHKDDPRPETTYCASH-RMBCashRMBDPUPETTYCASH-USDCashUSDDZ1BANKOFCHINA-US$CashUSDDZ2BANKOFCHINA-RMBCashRMBDZ3BANKOFCHINA-HK$CashHKDDZ4BANKOFCHINA-US$INVESTCashUSDDZ5BANKOFCHINA-HK$INVESTCashHKDGARADVANCERECEIPTSETTLEMENTCashRMBGNRNOTERECEIVABLERMBCashRMBGSHGS:FLEXHKMFGCashUSDGSLGS:LABUAN4CashUSDIAPINTEG-PURCRECEIPTJournalVouchersUSDIARINTEG-SALESINVJournalVouchersUSDIFXINTEG-FIXEDASSETJournalVouchersUSDIIRINTEG-PROD.RECEIPT(INV)JournalVouchersUSDIPIINTEG-PRODISSUE(INV)JournalVouchersUSDIPRINTEG-PRODRESULTJournalVouchersUSDIPVINTEG-PURCREVALUATIONJournalVouchersUSDIR2INTEG-PRODREVALUATIONJournalVouchersUSDIRRINTEG-PURCRESULTJournalVouchersUSDISRINTEG-SALESREVALUATIONJournalVouchersUSDIWAINTEG-INVADJUSTMENTJournalVouchersUSDIWRINTEG-INVREVALUATIONJournalVouchersUSDIWTINTEG-INVTRANSFERJournalVouchersUSDJVMJV-MULTIPLELINESJournalVouchersUSDPAPPURCINVAPPROVALPurchaseCorrectionsPIMPURINVMATCHINGPurchaseInvoicesPINPURINV-NOMATCHPurchaseInvoicesSCNSALESCNSalesCreditNotesSISSALESINVOICESalesInvoices11AccountsPayableIndex•FinancialSupplierGroup•BlockingCodesandBlockingReference•TermsofPayment•DueDateCalculationMethod•MiscellaneousPurchaseInvoice•AssignCNtoPurchaseInvoice•PurchaseInvoiceMatching•AutomaticMatching•ManualMatching•Tolerance•SSCProcessandFlowChartAP12AccountsPayableAccountsReceivableCashManagementFixedAssetsGeneralLedgerAccountsPayable13AccountsPayableMasterDataAgingAnalysisFinancialSupplierGroupsAccountsPayableParametersBlockingCodesBlockingReferencesAccountsPayable14AccountsPayable•LogininBaansystem–APModel•We’llbelearningthefollowingmodelsbylinkingtoBaaninlive15BlockingCodes:•Canbemaintainedin2levelswithlimitedtoappropriateenduserscompliancewithSOXrequirement:a)Globally-ACPParameters-allregisteredinvoicesareautomaticallyblockedforpaymentprocessingb)Manually-MaintainPurchaseInvoices•Abletopreventtheinclusioninbothautomaticpaymentprocessingandmanualadditiontopaymentadvicelist•Reasonsforblockinginvoicesmaybespecifiedinthedescriptionfield•BlockingCodescanberemovedinoneofthefollowingsessions:-MaintainPurchaseInvoices-MaintainPurchaseInvoiceDetailsAccountsPayable16AccountsPayableAblockingreferencemaybeattachedtoablockingcode•Identifieswhohasblockedtheinvoice•Nameswhoisresponsibleforresolvingtheconflict•MaybechangedwhenthecodeisassignedtoaninvoiceMaintainSupplierMasterFile•Vendorcode•Suppliernameandbilltoaddress•Paymenttermandcurrency•Bankmethod(T/T,L/C,COD…..)•Discount•ContactPerson17CustomerSupplierTermsofPaymentCalculationMethodPaymentDaysDiscountPeriodsDiscountCalculationTimeFenceTermsofPaymentAccountsPayable•Howtocalculatepaymenttermeg.A30,N30,A60…….18AccountsPayableDueDataCalculationMethoda)Immediately-startwithinvoicedate(N30)-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:1/17/2007PaymentPeriod:30daysDueDate:2/16/2007b)Endofmonth-startwiththelastdayofthemonthin(A15)whichtheinvoicedatebelongs-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:15/2/2007c)PaymentPeriod-Paymentpe