【文档说明】PCBAComputingFinanceTraining_Tom_update1.pptx,共(88)页,4.907 MB,由精品优选上传
转载请保留链接:https://www.ichengzhen.cn/view-296052.html
以下为本文档部分文字说明:
PCBAComputingDoumen–BaanIVFinancialTraining17.Jan.07PresentedbyTom.Shen2FlexComputingCustomers3FinancialBaanIVTrainingWhatShouldwebeOpera
tinginBaanIVNow?Let’shaveaquickoverview…….BaanIVOverview---BaanIV4Subjective&Scope•Introduction&Overview•Financi
alIntegrationOverview&BaanStructure•IntegrationDefinition•AccountsPayable(Localvs.GSSC)•AccountsReceivable(Loc
alvs.Labuan)•GeneralLedger(GLCode&Dim)•FixedAsset•Costing•FinancialStatements•MasterDataSetUp•Parameter•ChartofAccoun
t•TransactionType•IntegrationElement•TransactionTypebyTransactionOriginal•Others(IPRSystem,OutlookSoft……)5Introduction&O
verview•LogininBaansystem6SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudgetsCos
tAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsFinancialIntegrationOverview&BaanStructure
(i)OriginalTransactionPosting7InventorySalesProductionServiceTransactionOriginalTableFinancialIntegrationProgram•DetermineLedgerAccoun
ts•DefineDimension•DefineFinancialTransactionTypeFinancialTransactionTableGLAP/AR/FA/COST/….PurchaseIntegrati
onPostingBatchFinalizationFinancialIntegrationOverview&BaanStructure(ii)8IntegrationIntroduction•Financi
alintegrationoccursasaresultofanactivitywhichoccursinanylogisticmoduleswhichafinancialtransactionmust
berecorded•Examplesoflogisticactivities:*Receivinggoods*Deliveringgoodstocustomer*Revaluingthestandardcostofanit
em•Oncesuchanactivityoccurs,informationneedstobesenttoFinance•Pre-definedmappingautomaticallyselectsappropriateledg
eraccounts&dimensions9IntegrationDefinitionTransactionOriginFinancialTransactionPurchaseProductionSales…….ReceiptIssueInvoice……..T
ransactionElementDateCustomerSupplierPart…….10TransactionTypeTransactionCategoryTypeDescriptionTransactionCategoryCurCDJCURRENCYDIFFERENCEJournalVouc
hersUSDCDPA/PCURRENCYDIFFERENCESPurchaseCorrectionsUSDCDSA/RCURRENCYDIFFERENCESSalesCorrectionsUSDDG1IND'L&COMMERCIALBANK-RMBC
ashRMBDJ1BANKOFCOMMUNICATIONS-RMBCashRMBDJ2BANKOFCOMMUNICATIONS-HK$CashHKDDJ3BANKOFCOMMUNICATIONS-US$CashUSDDPHPETTYCASH-HK$CashHKDDPRPETTYCASH-RMBC
ashRMBDPUPETTYCASH-USDCashUSDDZ1BANKOFCHINA-US$CashUSDDZ2BANKOFCHINA-RMBCashRMBDZ3BANKOFCHINA-HK$CashHKDDZ4BANKOFCHINA-US$INVESTCashUSDDZ5BANK
OFCHINA-HK$INVESTCashHKDGARADVANCERECEIPTSETTLEMENTCashRMBGNRNOTERECEIVABLERMBCashRMBGSHGS:FLEXHKMFGCashU
SDGSLGS:LABUAN4CashUSDIAPINTEG-PURCRECEIPTJournalVouchersUSDIARINTEG-SALESINVJournalVouchersUSDIFXINTEG-FIXEDASSETJourna
lVouchersUSDIIRINTEG-PROD.RECEIPT(INV)JournalVouchersUSDIPIINTEG-PRODISSUE(INV)JournalVouchersUSDIPRINTEG-PRODRESULTJournalVouchersUSDIPVINTEG-PURC
REVALUATIONJournalVouchersUSDIR2INTEG-PRODREVALUATIONJournalVouchersUSDIRRINTEG-PURCRESULTJournalVouchersUSDISRINTEG
-SALESREVALUATIONJournalVouchersUSDIWAINTEG-INVADJUSTMENTJournalVouchersUSDIWRINTEG-INVREVALUATIONJournalVouchersUSDIWTINT
EG-INVTRANSFERJournalVouchersUSDJVMJV-MULTIPLELINESJournalVouchersUSDPAPPURCINVAPPROVALPurchaseCorrectionsP
IMPURINVMATCHINGPurchaseInvoicesPINPURINV-NOMATCHPurchaseInvoicesSCNSALESCNSalesCreditNotesSISSALESINVOICES
alesInvoices11AccountsPayableIndex•FinancialSupplierGroup•BlockingCodesandBlockingReference•TermsofPayment•DueDateCalculatio
nMethod•MiscellaneousPurchaseInvoice•AssignCNtoPurchaseInvoice•PurchaseInvoiceMatching•AutomaticMatching•ManualMat
ching•Tolerance•SSCProcessandFlowChartAP12AccountsPayableAccountsReceivableCashManagementFixedAssetsGeneralLedgerAccountsPayab
le13AccountsPayableMasterDataAgingAnalysisFinancialSupplierGroupsAccountsPayableParametersBlockingCodesBlockingReferencesAccountsPayable1
4AccountsPayable•LogininBaansystem–APModel•We’llbelearningthefollowingmodelsbylinkingtoBaaninlive15BlockingCodes:•Canbemaintai
nedin2levelswithlimitedtoappropriateenduserscompliancewithSOXrequirement:a)Globally-ACPParameters-all
registeredinvoicesareautomaticallyblockedforpaymentprocessingb)Manually-MaintainPurchaseInvoices•Abletop
reventtheinclusioninbothautomaticpaymentprocessingandmanualadditiontopaymentadvicelist•Reasonsforblockinginvoicesmay
bespecifiedinthedescriptionfield•BlockingCodescanberemovedinoneofthefollowingsessions:-MaintainPurchaseInvoices-MaintainPurchaseInv
oiceDetailsAccountsPayable16AccountsPayableAblockingreferencemaybeattachedtoablockingcode•Identifiesw
hohasblockedtheinvoice•Nameswhoisresponsibleforresolvingtheconflict•MaybechangedwhenthecodeisassignedtoaninvoiceMa
intainSupplierMasterFile•Vendorcode•Suppliernameandbilltoaddress•Paymenttermandcurrency•Bankmethod(T/T,L/C,COD…..)•Discount•ContactPerson1
7CustomerSupplierTermsofPaymentCalculationMethodPaymentDaysDiscountPeriodsDiscountCalculationTimeFenceTer
msofPaymentAccountsPayable•Howtocalculatepaymenttermeg.A30,N30,A60…….18AccountsPayableDueDataCalculationMethoda)Imm
ediately-startwithinvoicedate(N30)-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:1/17/2007PaymentPeriod:30daysDueDate:2/1
6/2007b)Endofmonth-startwiththelastdayofthemonthin(A15)whichtheinvoicedatebelongs-addnumberofdaysspec
ifiedinpaymentperiodeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:15/2/2007c)PaymentPeriod-Paymentperiodisfi
rstaddedtotheinvoicedate,afterwhichtheresultingdateisshiftedtomonthendeg:DocumentDate:20/1/2007PaymentPerio
d:15daysDueDate:30/1/200719AccountsPayable•FenceforDueDateIfthefield“DueDateCalcMethod”hasthevalue“EndofMonth”,thed
uedatewillbeshiftedfromthisdaytotheendofnextmonth(notthecurrentmonth).Eg:DocumentDate:1/12/2006FenceforDueDate:15daysDueDate:30/1/20
07•ToleranceforDiscPercentage/Amount•Themaxpercentage/amountbywhichthecustomer/suppliermayexceedthediscoun
tstatedinthetermsofpayment•Ifacustomer/suppliersubtractsalargerdiscountfromthepaymentthanisstatedinthetermsofpayment,thesystemwillissueawarning.20A
ccountsPayableInvoiceSample21ReceiptofGoodsPurchaseReceiptReceiveSupplierInvoicePaymenttoSupplierRegisterInvoiceMatchRe
ceiptsApproveInvoiceWorkflowofMatchingSupplierInvoicestoPurchaseOrderReceiptsAccountsPayable22RegisteringanInvoiceInvoiceReceipt/AccruedAPSupplier
ControlAccount90.0090.00FromFinancialSupplierGroup(FSG)AccountsPayable23ApprovalInvoiceReceipt/AccruedAPInvoice
tobeRec’d/AccruedAPFromFinancialSupplierGroupReverseofPurchaseReversalofregistertransactionReceipt90.0084.006.00PurchasePriceVariance(PPV)Mainta
inInventoryandWIPPurchase/ResultDefinitionAccountsPayable24SummaryInventoryInvoicetobeRec’dInvoicesReceiptA/PContro
lInvoicesReceiptInvoicetobeRec’d84.0084.0090.0090.0090.0084.00Inv&WIPFSGFSG/WIP(Receipt)(Register)(Approval)Purch
asePriceVariance6.00AccountsPayable25RegisterInvoiceAutomaticMatchCompletePriceDiff.onFSGApproveInvoiceManualMatch$Re
ceipt/$Invoice-ToleranceYesNoTypesofMatches-AutomaticNote:•As“TolerancesforAutomaticMatching”fieldinAPPar
ameterisnotset,therewillnotbeanyautomaticmatching.•Manualmatchingwillbeused.AccountsPayable26AccountsPayableA
utomaticMatching•AnautomaticmatchwillautomaticallymatchsupplierinvoicetothePOreceipt•Anautomaticmatchwillmatchcompletely•Completematch–thequantityand
amountininvoiceisexactlythesameaswhathasbeenreceived•Ifpricedifferenceoccurs,thesedifferencewillbeassignedtoaledgeraccountbeforetheautomaticmatchin
gprocedureisstarted.•PricedifferencewillbestoredinPriceDifferenceAccountdefinedinFinancialSupplierGroup
27ReceiptofGoodsComplete(qty&invoicevalue=POreceipt)SupplierInvoiceQty$Qty$51205120Partial(qty&invoice
value<>POreceipt)ReceiptofGoodsSupplierInvoiceQty$Qty$512051005120496TypesofMatches-Complete/PartialAccountsPa
yable28PartialCompleteBookingVarianceP.P.V.inIntegrationApproveInvoiceRegisterInvoiceManualMatchNoVarianceAmountQuantityLineremainsopenTolerances
TypesofMatches-ManualAccountsPayable29PriceDifferenceTolerancesi)AutomaticMatchingTolerances(setinAPParameters)•Decideswhether
automaticmatchingispossible•Ifpricedifferenceisoutoftolerances,thenautomaticmatchingisnotpossible.Havetousemanualmatchin
g(AsthereisnotolerancesdefinedinNC/SC,manualmatchingisused)•Ifpricedifferencefallswithintolerances,thenitwillbewrittentodefinedaccou
ntinFinancialSupplierGroupAccountsPayableii)ToleratedPriceDifferenceperUser•Itindicatesthemaxpricedifferencean
dmaxpercentagedifferenceforeachinvoice.Thisallowsyoutospecifytheauthorizationswithregardstotheapprovalofpricediffer
encewhenmatchingreceiptsandpurchaseinvoice•Ifpricedifferencefallswithintolerances,thenitwillbechargedtoPPVaccountdefinedinIntegra
tionTransaction•Ifpricedifferenceisoutoftolerances,auserwithhighertolerancemustapprovethepricedifferencein“ApprovePriceDifference”s
ession30GSSC[GlobalSharedServiceCenter]ServicesGuidelinesAccountsPayable•ActivitiestobeperformedbyGSSC•Processingof•InvoiceswithPurchaseOrder•Invo
iceswithIPR•Credit/Debitnotes•Intercoinvoices•Freightinvoices•Approvalofdiscrepantinvoices•Handlingvendorqueries•Performingreconciliati
on•Paymentpurgingandcoordinationwithbank•OutofScopeactivitiesforGSSC:•LocalRMBpurchases•Utilitypaymentsforelectricity,water,telephone,fax,gas,pet
rol&oil•Leaseandrentalpayments•ContractPayments•Insurance•Prepayment/Advancepayments•Paymentforecasting31GSSCProcessingGuidelinesAcco
untsPayable•Transactioncodes&blockcodes•ProcessFlows•Matchingofinvoices•Handlinginvoicediscrepancy•Processingcreditn
otes•Processingdebitnotes•ProcessingNon-POinvoice•Processingfreightinvoice•AdvancePayments•PaymentProcess•Roundingofferrors
•GLcodesandDimensions•Audit•VendorQueries•Reconciliations•Monthendactivities32TransactionType:AccountsPayableTransactionCodeDescriptionOIMPurch
aseinvoicewithPOOINPurchaseinvoicewithoutPOOCMPurchasecreditnotewithPO/DebitnotewithPOissuedbysiteOCNPurchasecreditnotewithoutPO
/DebitnotewithoutPOissuedbysiteOICIntercoinvoiceOIFFreightinvoiceOCYReversalsofinvoices.OILLinkingcreditnotetoinvoice33Fo
llowingblockcodeswillbeusedbyGSSCtohandlevariousinvoicediscrepancies:AccountsPayableBlockingCodeDescriptionAOCEANCARGOBBLANKETPOREQUIRESAD
DITIONALDOLLARCINVOICECURRENCYDIFFERENTTHANPOCURRENCYDPOCLOSEDCOMPLETEEINVALIDPONUMBERFNEEDFREIGHTAUTHORIZATIONGMAT
ERIALININSPECTION,PROVIDERECEIPTNUMBERORRMA#HQUANTITYDISCREPANCYIBURELEASEOFPYMTREQUIREDJPLEASEAPPROVEFORPAYMENTKNORECEIPTINSYSTE
MLINVOICEU/MDIFFERSFROMPOU/MMNOPOPROVIDEDNPRICEDISCREPANCYOGOODRECEIPTONDIFFERENTSUPPLIERCODEPCANCELLATIONCHARGESAPPROV
ALREQUIREDQINVOICEPOBELONGSTODIFFERENTSUPPLIERRINVOICEITEM#DIFFTOPOITEM#STOOLINGPAYMENTAUTHRIZATIONREQUIR
EDTNOTREPLENISHMENTONINVOICE(VMI)UWRONG/INCOMPLETETAXINFORMATIONVUNABLETOBEMATCHEDWNOPACKINGSLIP#REFERENCEDONINVOICEXNOCDFAVAILABLECNWAI
TINGFORCREDITNOTEEXPEMP.EXPPENDINGAPAPPROVAL34BasicKnowledgeofAPProcessing(i)AccountsPayable•MatchingofInvoices
:InvoicesarematchedmanuallytothePOlines.PackingslipisusedasthebasisformatchingthelinesinthePO.(Deliveryo
rder#orInvoice#isalsousedtosubstitutethepackingslip#).Whereas,ifPOandInvoiceishavingasinglelineandthereferencegiveninPackingSlipfieldinBAANisnotma
tchingthereferencegivenoninvoice,GSSCwilldothematchingsubjecttotheinvoicequantity&PoQuantityissame.In
caseofSOI/SMIvendors,replenishmentnumberisusedtodothematchingofinvoiceswithPO.•Handlinginvoicediscrepancy:Incaseofanydiscrepancywhilematching
,theA/Pprocessorwouldassigntherelevantblockingcodebasedonthenatureofdiscrepancy,followingwhichane-mailistriggeredtothebuyer/requestorfromthe
workflowpackage•InvalidPONumber:IfthePOnumberreferredoninvoiceisinvalidinBAAN,A/Pprocessorwillregistert
heinvoiceandassignablockcode“E”,followingwhichane-mailistriggeredtothebuyerthroughworkflow.A/Pprocessorwillident
ifythebuyerbasedonthePart#/Itemcodegivenontheinvoice.Incase,ifA/Pprocessorisunabletoidentifythebuyer,workflowe-mailwillbese
nttotheSinglePointofContactgivenintheKeycontactlist.•QuantityDiscrepancy:Incaseofaquantitydiscrepancyi.e.invoicequantitynotmatchin
gwithPOquantity,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“H”followingwhichanemailistriggeredtothebuyerbytheworkflow•Nor
eceiptinsystem:IncasePOlinesdoesnothavethereceiptstoperformmatching,theinvoicewillremaininregisteredstatusandA/Pprocessorwillblockwith“
K”andbuyerisnotifiedthroughane-mailfromworkflowpackage35BasicKnowledgeofAPProcessing(ii)AccountsPayable•PriceDiscrepancy:I
ncaseofafavorableorunfavorablepricediscrepancy,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“N”followingwhichanemailistriggered
totherespectiveBuyerbyworkflow•Packingslip#notreferredontheinvoice:Ifthereisnoreferenceofpackingslip#ontheinvoice,A
/Pprocessorwillassignblockcode“W”,whichwilltriggerworkflowe-mailtothebuyer•ProcessingCreditNotes:Credit
notesareissuedbyvendoraswellasthesite.Belowistheprocessfollowedforeachcategory•CreditNoteissuedforrebates:Ifacreditnoteisissuef
orrebates/discounts,A/Pprocessorwillassignablockcode“J”andworkflowe-mailwilltriggertositefinanceforGL&Dimensions.Creditnoteissuedbyvendorispro
cessedwithpaymenttermsas“NetImmediate”.•ProcessingDebitNotes:Creditnotesareissuedbyvendoraswellasthesite.Bel
owistheprocessfollowedforeachcategory•ProcessingNon-POinvoice:A/PprocessorwillprocessNon-POinvoicesinBAANandassignablockcode“J”ande-mailwillbetrigge
redtorequestorforverificationanddepartmentmanagerforapproval.SiteFinancewillbeprovidingexcelsheettoG
SSCwhichwillbehavingthelistofIPR#issued.Onreceiptofinvoices,GSSCwillupdatetheexcelsheetagainstIPR#listedandupdatethedetailsof
invoicebeingmatched.GSSCwillusetheGL&DimensiondetailsprovidedagainsttheIPR#intheexcelsheet.Incase,theGL&Dimensionarenotgivenin
theexcelsheet,GSSCwillassignablockcodeandSiteFinancewillprovidethedetails.36BasicKnowledgeofAPProcessing(iii)AccountsPayable
•ProcessingFreightinvoice:Freightinvoiceswillbesenttositelogisticsbythevendor.Onreceiptofinvoices,freightinvoiceisverifiedbyshippingoffi
cerandapprovalistakenfromShippingManager.AfterapprovalSiteFinancewillprovideGL,CCcoding,thenscanandFTPtotheserver.Processor
atGSSCwillaccesstheinvoicesinFreightQueueandprocessinBAAN.•AdditionalcostnotcoveredunderPO:Incaseanyadditionalcostsliketoolingchargesetcrefe
rredoninvoice,butnotcoveredunderPO,A/Pprocessorwillassignablockcode“J”,andfollowingwhichane-mailistriggeredtothebuyerthroughwork
flowforapproval.•AdvancePayments:Allrequestsforprepayment/advancepaymentswillbesenttoHKTreasury.Uponrecei
vingtherequest,HKTreasurywilldoapostinginBAANtoeffectthepaymentandupdateGSSC.GSSCneedstomonitorthevendoraccountandwhenthecorrespondinginv
oiceismatchedshouldnotifyHKTreasurysothattreasurycanpurgetheinvoicesinBAAN.•DebitNoteissuedforPricediscre
pancy:Ifadebitnoteisissuedforpricediscrepancy,vendormustreferthedetailsoforiginalinvoiceonthedebitnote.Ifthediscrepancyamountofinvoicemat
cheswiththedebitnoteamount,DebitNoteisbookedtoIPVaccount127100.In,theeventoriginalinvoiceisalreadypaid
,A/Pprocessorwillassignablockcode“J”ande-mailwilltriggertobuyerforverificationandapproval.Uponconfirma
tionfrombuyer,workflowe-mailwillbesenttositefinanceforGL&Dimensions.37GSSCProcessingFlowsChart–Direct&IndirectAccountsPayabl
ePROCESSINGOFPOINVOICES(Direct&Indirect)DocumentisanAPDocument?CorrectBaaNCompanyAInvoiceinProcessorDataEntryQueueY
esNoMiscellaneousPaper(DuplicateInvoices)NoNoNoYesRouteInvoicestoVendorMaintenanceQueueDiscrepancyMatchtheinvoicetoPOlinesinBaaN
ApproveInvoiceYesYesResolutionbyVendorMaintenanceTeamatsiteInvoiceroutedtoFinalHoldQueue&ReadyforPaymentRescanQueueinWorkflow(RescanningbyScannin
gTeam)ScanningProcessactivatedCorrectVendorexists?YesRegisterInvoiceResolutionTeammonitorsNon-KeyedQueuedailyanddeletesthei
nvoiceonamonthlybasisNon-KeyedQueueinWorkflowYes38GSSCProcessingFlowsChartAccountsPayable39AccountsPayableTHEEND!!40AccountsRe
ceivableIndex•FinancialCustomerGroup•ProblemCodeandProblemReference•InvoicingfromARModule(MaintainTransactions)•AssigningCre
ditNotetoSalesInvoices•InvoicingfromARModule(InvoiceControl)•CorrectingSalesInvoices•OpenEntries•LabuanMo
del•ARClosingProcessAR41Introduction&Overview•LogininBaansystem42LabuanSalesProcessing➢LabuanSales&Ship
mentProcess➢ProceedingSalesinvoices➢InvoiceshallbebilledtoLabuanfromDMateverymonthend➢POnumberiscorrectlyreflectedoninvoice➢Program
toensuretheSOquantitiesMUSTbelessorequaltocustomerPO➢Programtoensurethesalespriceiscorrect,ifnotthencheckbackwithcusto
mer➢Financetodoubleverifythesalespriceiswhetherundertheproperrateforapplyingtothecustomexportdeclaration➢Bill&HoldShipmenttoFDIC
ustomerPullMaterialsSalesOrderOutboundPrintPIFaxPIBilltoBilltoFlexDMMBUStoreShippingLocalFinanceLabuanFDIHub
EndCustomerShipmenttoendCustomerAccountsReceivable43CustomerInformationCustomerStatusCurrencyTermsofPaymentOneTimeCustomerCreditLimitDefau
ltFin.CompBlockedSalesOrdersStatementMethodFin.CustomerGroupAccountsReceivable44FinancialCustomerGroups(FCG)CustomerLedgerAcc
ountsFinancialCustomerGroupAccountsReceivable45MaintainManualSalesInvoicesSalesModuleDistributionGLProcessingMaintainTransactionsPrintManualSalesIn
voicesPostManualSalesInvoicesInvoiceControlAccountsReceivable46InventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=IssueD
r:Goodstobeinvoiced(UninvoicedShipment)Cr:FGInventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=RevaluationDr:WIPCr:
PPVThistransactionisgeneratedifthegoodsissuingdateisearlierthanthedateofthelatestcostpriceupdateinItemDataAccountsReceivable
ARIntegrationProcessing:47AccountsReceivableARIntegrationProcessing(ii):TransactionTypebyTransactionOriginTransactionO
rigin=SalesFinancialTransaction=SalesInvoice,TypeofSales=MaterialCostInv.Detail,OperationCostInv.Detail,RevenuesInvoiceDetail,(InvoiceTotals),Orde
rDiscountInvoiceDetailAccountsMaterialCostsDr:CostofGoodsSold(COGS)Cr:UninvoicedShipmentDr.ARCr.SalesI
nterimDr:SalesInterimCr:Sales48AccountsReceivableAssigningCreditNotetoInvoices•Creditnotemaybeassign
edatthetimethecreditnoteisentered(usingOriginalInvoicefield)oratalaterdate•Assigningcreditnotewillreducetheamount
oftheoriginalinvoices•Ifcreditnotesarenotassigned,theywillbeshownasnegativeamountinopenentries49Steps
inassigningsalescreditnotestoinvoice:MaintainTransactionsAssignCreditNotestoInvoiceIAssignCreditNotestoInvoiceIIMaintainD
ocumentNumbersSelectBatchesforFinalizationAccountsReceivable50InvoiceControlProcedureMaintainSalesInvoiceHeaderMaintainSalesInvoic
eLinesPrintSalesInvoicesPostSalesInvoicesSelectBatchesforFinalizationAccountsReceivable51AccountsReceivableInvoiceContro
l•InvoicingfromInvoiceControlwillproducewritteninvoice•Onlyusedfornon-inventoryitems-nolinktoinventorylevel•CategoryforTrans
actiontype=SalesInvoice/SalesCN•InvoicescanbeprintedasProformaorFinalInvoice•SalesinvoicecanonlybepostedtoGLafterithasbeenprintedas“FinalInvoice”•P
ostingofFinalInvoicewillcreateabatchwhichthenhastobefinalized•Oncetheinvoiceisprintedas“FinalInvoice”,theinvoicecannotbedeletedor
modified•ItmaybecanceledbychangingthestatusfieldontheInvoiceHeaderfrom“open”tocanceled”52AccountsReceivable•BaanProcessing•MaintainPriceItem•UpdateI
ntercosellingprice•ChangepriceandDiscount•Printsalesinvoice•Postsalesinvoices•PostIntegration•Finalizebatches53CorrectingSalesInvoices•Corrections
canbemadetoexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•Correctionsmaynotbemadetoinvo
iceswhichhavetransactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable54Entries•Correctionscanbemadetoexistingfinali
zedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•Correctionsmaynotbemadetoinvoiceswhichhavetransactionsl
inkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable55AccountsReceivableARMonthEndOperating&LabuanModelInvolveme
ntofARinLabuanModel:Steps:1.MaintainPricesbyItem2.UpdateInter-InternalcompanySellingPrice3.PrintSalesInvoicesProcessDeliveredSO4.PrintNon-Finaliz
edTransactions5.SelectBatchesforFinalizationARClosingOverview1.LabuanSales&MCOSReportvs.LocalBook2.MC
OSAnalysisReport56THEEND!!AccountsReceivable57FixedAssetSubjective&Scope•FixedAssetStructure•FAMainGroup•FAGroup•FAMasterData•TransactionSchedule•Reg
istrationofFixedAsset•Depreciation•DepreciationMasterData•GroupDepreciationData•FADepreciationData•DisposalFA58FixedAsset•
LogininBaansystem–FAHowtoregisteraFAanddealwiththedepreciation&disposalinBaan…..???59FixedAssetsFixedAssetsBAANIVDTSP…AccountsReceivableAccou
ntsPayableGeneralLedgerDim5Dim4Dim3Dim2Dim160HowtoRegisterFixedAssets?PurchasebyCashPayment/BankPurchaseviaGL/A
ccountsPayablePurchaseInvoice:LedgerAccount➔IntegrationIndicatorIPR/ATRFixedAssets61TransactionScheduleTransactionType:•Investment•Disposal•Bookva
lue•Depreciation•DepreciationCosts•Revaluation•DepreciationAdjustment•ValueReduction•……..FixedAssetGroupFixedAssetDepr.CodeLedgerAccountsDimensionsTh
eTransactionscheduleisusedtoprovidemappingforledgeraccountstobeusedwhenprocessingtransactionsFixedAssets•IFX•SIS62I
nvestmentMachine:PurchaseValue:$100.00PostinginBaanFinance:DrFixedAssets100.00CrBank100.00FixedAssets63DepreciationSystemMet
hodofDepreciationBaseofDepreciationStart&EndofDepr.Fixed%BaseValueVariable%BaseValueSumoftheYear’sYearAnnuityFixedAmountNumberofYearofUsePurchase
ValueBookValueDateinUsePeriodafterDateinUsePeriodinUseSecondhalfinYearinUseFirstPeriodYearinUseNextYear,FirstPeriodFi
rst/SecondhalfofYearDisposalOutofUseFixedAssets64UseLifeFAGroupDescriptionyearSalvageDepreciationMethod151BUILDING2510%
Straightline152LEASEHOLDIMPROVEMENT1010%Straightline153MACHINE&EQUIPMENT710%Straightline154VEHICLES510%Strai
ghtline155OFFICEEQUIPMENT610%Straightline156TOOLS&FIXTURES210%Straightline157COMPUTEREQUIPMENT-ITEQUIP610%Straightline1532MACHINE&EQU
IPMENT510%Straightline1533MACHINE&EQUIPMENT20%Straightline1534MACHINE&EQUIPMENT30%Straightline1535MACHINE&EQUIPMENT40%Straightline1552F
URNITURE&FITTING610%Straightline1572COMPUTEREQUIPMENT-ITEQUIP610%Straightline1542VEHICLES(3yrs)310%Straightline15
53FURNITURE&FITTING(5yrs)510%Straightline1573COMPUTEREQUIPMENT-ITEQUIP(3yrs)310%Straightline1574COMPUTEREQUIPMENT
-PROD.LINE(3yrs)310%Straightline155AOFFICEEQUIPMENT(3yrs)310%StraightlineFixedAssets65DepreciationLengthofDep
reciation:10year100.00/10=10.00ayearPostinginBaanFinance:DrInterimAccountDepreciation10.00CrDepreciationMachine10.00DrDepreciationCosts10.00CrInt
erimAccountDepreciation10.00FixedAssets66DisposalSalesInvoice:AccountsReceivable:EnterSalesInvoicePostTransactionst
oFinanceFinalizeTransactionsFixedAssets:FixedAssets67CaseofDisposal:PurchaseValue:100.00Depreciation:60.00
BookValue:40.00SalesPrice:50.00Profit:10.00PostinginBaanFinance:DAccountsReceivable50.000CrFixedAssetSalesInterimAccount50.000DDepreciation60
.000DGain/LossonDisposal/Bookvalue40.000CrInvestments(FA)100.000DFixedAssetInterimAccount50.000CrFixedAssetSalesRevenues50.000FixedAssets68Ca
seofDisposal:FixedAssets69HowtoPreparetheFAMonthlyReport?FixedAssets70THEEND!!FixedAssets71GeneralLedgerSubjective&Scope•Cha
rtofAccount•DimensionCode•TransactionType•TransactionProcessing•MaintainPeriod•MonthEndClosing•YearEndClosingGL72SFCShippingPurchasingPlanningInvento
ry……..FinancialStatementsFinancialBudgetsCostAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsOriginalTransact
ionPostingGeneralLedger73GeneralLedgerMasterDataTransactionTypesGroupCompanyParametersG/LAccountsCompanyPara
metersPeriodsDimensionsTransactionSchedulesProtocolCodesScheduleforAutomaticTransactionsCurrencyDiffere
nceGeneralLedger74OptionalSessionMaintainChartofAccountsMaintainDimensionsMaintainTransactionTypesMa
intainCurrencyDiff.LedgerAccountsMaintainRangesbyLedgerAccountMaintainLastUsedDoc.#byTrans.TypeMaintainTransactionSchedulesMaintainTransactionSche
duleDetailsMaintainCompanyParametersMaintainGroupCompanyParametersMaintainPeriodsMaintainScheduleforAutomaticTransactionsGeneralLedgerSetUpGenera
lLedger75•LogininBaansystem–GLHowtomaintainthechartofaccount,transactiontype,dimensionandregisteravoucherinBaan…..?
??GeneralLedger76GeneralLedgerDimension–Whatarethey?•Userdefinablecategoriesthataresimilartosubledgers•EachDimensiontypeismadeupofdimensioncodesDim
ensionCharacteristics•5typesofdimensions(Dim1–Dim5)•6positions-alphanumeric•Mandatory,OptionalorNotUsedperledgeraccount77General
LedgerConditionsofDimensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•Manda
torytoOptional•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistor
ytable)•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhistorytable)78GeneralLedgerDimensionTypeismadeofthefo
llowingcodesGLDim1CustomerDim2ProductionLineDim3CostCenterDim4IntercomDim5Project79GeneralLedgerConditionsofDimensionsIfaledgeracc
ounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•MandatorytoOptional•NotusedtoOptional•Opti
onaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistorytable)•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhis
torytable)80GeneralLedgerTransactionProcessingKeyPoints:•Batch•Collectionoffinancialtransactions•Abatchreferencecanb
eenteredforeasyidentification•Abatchcancontainseveraltransactiontypes•Finalization•AprocessthatpostsentriestoGLOncetra
nsactionsarefinalized,theycanlongerbemodified81GeneralLedgerPeriodDataThereare3typesofperiodsinBaan•Fis
calPeriod–financialyear•ReportingPeriod–forreportingpurpose•TaxPeriod–fortaxreportingPeriodStatus•Open–Transactionscanbefinaliz
edtothisperiod•Closed–Transactionscannotbefinalizedtothisperiodbuttheperiodcanbere-open•FinallyClosed-Transactionscannot
befinalizedtothisperiodandtheperiodcannotbere-openNote:•Periodscanbeindividuallyclosedforeachmodule•Periodsofallmodulesmu
stbeclosedbeforeclosingGLmodule•GLmodulemustbeopenedfirstbeforeothermodulescanbeopened82PostFinancialIntegrationTransactionsPrintIntegra
tionTransactionLogSelectBatchesforFinalizationMaintainPeriodStatusClosePeriodsMonthEndCloseGeneralLedger83ChartofAccountsDimens
ionsGeneralLedgerTransactionTypesTransactionSchedulesAutomaticSchedulesPeriodsTransactionProcessingParametersSummary
-TheGeneralLedgermoduleGeneralLedger84GeneralLedgerRegisterVoucherinGLModelCreateBatchSelect“JVM”Tran
sactiontypePutGLCodeanddimensioncodeCreateRunnumberFinalizeBatchStep3Step1Step4Step2Step5Example:Dr.Salary$100Cr.SalaryPayable
$10085GeneralLedgerCompliance•Allentitycontrollersareresponsibleforensuringthatallinter-companybalancesareproperlyrecordedandrec
onciledatmonth-end.ICVWhatisaICV?•Inter-companyChargeVoucher,whichshouldbeincludingthefollowing:•Inter-CompanySales(furtherdefinedbelow)•Royal
ty•Interestincomeand/orexpenseWhatcategoriesshouldbebilledviaaICV?•Inter-companyChargeVoucher,whichshouldbeincludingthefollowing:•TradeAP/AR…..(byus
ingGSHtolinkinter-companyinvoiceandJVMtobookgeneralsettlement)•Inter-companyContractualObligations&Loans•Inter-companyloans•Transf
eroffunds/cashotherthanloans•Servicechargeswithanagreement•FixedAssetTransfer•Campusexpenseallocation…..86GeneralLedgerHowt
oBookaICVunderLegalEntityMEPorSegmentMEP?Herewillbetakinganexampletoindicatetheprocess:Beforewetakingthe
example,weneedtoemphasizethekeypointsasbelow•GL181597–MobilesegmenttoreconcilewithComputingsegment•GL183060–Computingsegmenttoreconcilewithmobilese
gment•GL181114–DMS131toreconcilewithmobilesegment•GL18XXXX–ComputingsegmenttoreconcilewithHK•ComputingMEPcode:PCBA-DM-CMP-131•If
aICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandComputingDr.Expense–Mobile$60Dr.Expense–Computing$40181597$40Cr.183060$40Cr.181114–HK$
100•IfaICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandComputingDr.Expense–Computing$100Cr.18XXXX$10087GeneralLedgerB/SGLControlWe’llbe
controllingsomeB/Sledgersasattachedandmonitoringthehistorybalance88THEEND!!GeneralLedger