【文档说明】PCBAComputingFinanceTraining_Tom_update1.pptx,共(88)页,4.907 MB,由精品优选上传
转载请保留链接:https://www.ichengzhen.cn/view-296052.html
以下为本文档部分文字说明:
PCBAComputingDoumen–BaanIVFinancialTraining17.Jan.07PresentedbyTom.Shen2FlexComputingCustomers3FinancialBaanIVTrainingWhatShouldwebeOperatinginBaanIV
Now?Let’shaveaquickoverview…….BaanIVOverview---BaanIV4Subjective&Scope•Introduction&Overview•FinancialIntegrationOver
view&BaanStructure•IntegrationDefinition•AccountsPayable(Localvs.GSSC)•AccountsReceivable(Localvs.Labuan)•GeneralLedger(GLCode&Dim)•FixedAsset•Cos
ting•FinancialStatements•MasterDataSetUp•Parameter•ChartofAccount•TransactionType•IntegrationElement•TransactionTypebyTransactionOriginal•Others(IPR
System,OutlookSoft……)5Introduction&Overview•LogininBaansystem6SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudgets
CostAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsFinancialIntegrationOverview&BaanS
tructure(i)OriginalTransactionPosting7InventorySalesProductionServiceTransactionOriginalTableFinancialIntegrationProgram•Deter
mineLedgerAccounts•DefineDimension•DefineFinancialTransactionTypeFinancialTransactionTableGLAP/AR/FA/COST/….PurchaseIntegrationPostingBatchFinalizat
ionFinancialIntegrationOverview&BaanStructure(ii)8IntegrationIntroduction•Financialintegrationoccursasaresultofanactivitywhichoccursinanylogisticm
oduleswhichafinancialtransactionmustberecorded•Examplesoflogisticactivities:*Receivinggoods*Deliveringgoodstocustomer*Reva
luingthestandardcostofanitem•Oncesuchanactivityoccurs,informationneedstobesenttoFinance•Pre-definedmappingauto
maticallyselectsappropriateledgeraccounts&dimensions9IntegrationDefinitionTransactionOriginFinancialTransactionPurchaseProductionSales…….Re
ceiptIssueInvoice……..TransactionElementDateCustomerSupplierPart…….10TransactionTypeTransactionCategoryTypeDescriptionTra
nsactionCategoryCurCDJCURRENCYDIFFERENCEJournalVouchersUSDCDPA/PCURRENCYDIFFERENCESPurchaseCorrectionsUSDCDS
A/RCURRENCYDIFFERENCESSalesCorrectionsUSDDG1IND'L&COMMERCIALBANK-RMBCashRMBDJ1BANKOFCOMMUNICATIONS-RMBCashRMBDJ2BANKOFCOMMUNICATIONS-HK$Ca
shHKDDJ3BANKOFCOMMUNICATIONS-US$CashUSDDPHPETTYCASH-HK$CashHKDDPRPETTYCASH-RMBCashRMBDPUPETTYCASH-USDCashUSDDZ1BANKOFCHINA-US$CashUS
DDZ2BANKOFCHINA-RMBCashRMBDZ3BANKOFCHINA-HK$CashHKDDZ4BANKOFCHINA-US$INVESTCashUSDDZ5BANKOFCHINA-HK$INVESTCash
HKDGARADVANCERECEIPTSETTLEMENTCashRMBGNRNOTERECEIVABLERMBCashRMBGSHGS:FLEXHKMFGCashUSDGSLGS:LABUAN4CashUSDIAPINTEG-PURCRE
CEIPTJournalVouchersUSDIARINTEG-SALESINVJournalVouchersUSDIFXINTEG-FIXEDASSETJournalVouchersUSDIIRINTEG-PROD.RECEIPT(I
NV)JournalVouchersUSDIPIINTEG-PRODISSUE(INV)JournalVouchersUSDIPRINTEG-PRODRESULTJournalVouchersUSDIPVINTEG-PURCREVALUATIONJournalVouchersUSDIR
2INTEG-PRODREVALUATIONJournalVouchersUSDIRRINTEG-PURCRESULTJournalVouchersUSDISRINTEG-SALESREVALUATIONJournalVouchersUSDIWAINTEG-IN
VADJUSTMENTJournalVouchersUSDIWRINTEG-INVREVALUATIONJournalVouchersUSDIWTINTEG-INVTRANSFERJournalVouchersUSDJVMJV-MULTIPLELINESJourn
alVouchersUSDPAPPURCINVAPPROVALPurchaseCorrectionsPIMPURINVMATCHINGPurchaseInvoicesPINPURINV-NOMATCHPurchaseInvoicesSCNSALESCNSalesCreditNotes
SISSALESINVOICESalesInvoices11AccountsPayableIndex•FinancialSupplierGroup•BlockingCodesandBlockingReference•TermsofPay
ment•DueDateCalculationMethod•MiscellaneousPurchaseInvoice•AssignCNtoPurchaseInvoice•PurchaseInvoiceMatching•AutomaticMatching•ManualMatch
ing•Tolerance•SSCProcessandFlowChartAP12AccountsPayableAccountsReceivableCashManagementFixedAssetsGeneralLedgerAccountsPayab
le13AccountsPayableMasterDataAgingAnalysisFinancialSupplierGroupsAccountsPayableParametersBlockingCodesBlockingReferencesA
ccountsPayable14AccountsPayable•LogininBaansystem–APModel•We’llbelearningthefollowingmodelsbylinkingtoBaaninli
ve15BlockingCodes:•Canbemaintainedin2levelswithlimitedtoappropriateenduserscompliancewithSOXrequirement:a)
Globally-ACPParameters-allregisteredinvoicesareautomaticallyblockedforpaymentprocessingb)Manually-MaintainPurchaseInvoices•Ab
letopreventtheinclusioninbothautomaticpaymentprocessingandmanualadditiontopaymentadvicelist•Reasonsforblockinginvoicesm
aybespecifiedinthedescriptionfield•BlockingCodescanberemovedinoneofthefollowingsessions:-MaintainPurchaseInvoices-MaintainPurchaseInvoiceDetailsAcc
ountsPayable16AccountsPayableAblockingreferencemaybeattachedtoablockingcode•Identifieswhohasblockedtheinvoice•Nameswhoisresponsibl
eforresolvingtheconflict•MaybechangedwhenthecodeisassignedtoaninvoiceMaintainSupplierMasterFile•Vendorcode•Suppliernameand
billtoaddress•Paymenttermandcurrency•Bankmethod(T/T,L/C,COD…..)•Discount•ContactPerson17CustomerSupplierTermsofPaymentCalculationMethod
PaymentDaysDiscountPeriodsDiscountCalculationTimeFenceTermsofPaymentAccountsPayable•Howtocalculatepaymenttermeg.A30,N3
0,A60…….18AccountsPayableDueDataCalculationMethoda)Immediately-startwithinvoicedate(N30)-addnumberofdaysspecifiedi
npaymentperiodeg:DocumentDate:1/17/2007PaymentPeriod:30daysDueDate:2/16/2007b)Endofmonth-startwiththelastdayofthem
onthin(A15)whichtheinvoicedatebelongs-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:20/1/2007PaymentPeriod:15days
DueDate:15/2/2007c)PaymentPeriod-Paymentperiodisfirstaddedtotheinvoicedate,afterwhichtheresultingdateisshiftedto
monthendeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:30/1/200719AccountsPayable•FenceforDueDateIfthefie
ld“DueDateCalcMethod”hasthevalue“EndofMonth”,theduedatewillbeshiftedfromthisdaytotheendofnextmonth(notthecurrentmonth).Eg:Docum
entDate:1/12/2006FenceforDueDate:15daysDueDate:30/1/2007•ToleranceforDiscPercentage/Amount•Themaxpercentage/amountbywhicht
hecustomer/suppliermayexceedthediscountstatedinthetermsofpayment•Ifacustomer/suppliersubtractsalargerdiscountf
romthepaymentthanisstatedinthetermsofpayment,thesystemwillissueawarning.20AccountsPayableInvoiceSample21ReceiptofG
oodsPurchaseReceiptReceiveSupplierInvoicePaymenttoSupplierRegisterInvoiceMatchReceiptsApproveInvoiceWorkflowofMatchingSupplier
InvoicestoPurchaseOrderReceiptsAccountsPayable22RegisteringanInvoiceInvoiceReceipt/AccruedAPSupplierControlAccount
90.0090.00FromFinancialSupplierGroup(FSG)AccountsPayable23ApprovalInvoiceReceipt/AccruedAPInvoicetobeRec’d/AccruedAPFromFinancialSu
pplierGroupReverseofPurchaseReversalofregistertransactionReceipt90.0084.006.00PurchasePriceVariance(PPV)MaintainInventoryan
dWIPPurchase/ResultDefinitionAccountsPayable24SummaryInventoryInvoicetobeRec’dInvoicesReceiptA/PControlInvoicesReceiptInvoicetobeRec’d
84.0084.0090.0090.0090.0084.00Inv&WIPFSGFSG/WIP(Receipt)(Register)(Approval)PurchasePriceVariance6.00AccountsPayable25Regi
sterInvoiceAutomaticMatchCompletePriceDiff.onFSGApproveInvoiceManualMatch$Receipt/$Invoice-ToleranceYesNoTypesofMatches-AutomaticNo
te:•As“TolerancesforAutomaticMatching”fieldinAPParameterisnotset,therewillnotbeanyautomaticmatching.•
Manualmatchingwillbeused.AccountsPayable26AccountsPayableAutomaticMatching•AnautomaticmatchwillautomaticallymatchsupplierinvoicetothePOreceipt
•Anautomaticmatchwillmatchcompletely•Completematch–thequantityandamountininvoiceisexactlythesameaswhathasbeenreceive
d•Ifpricedifferenceoccurs,thesedifferencewillbeassignedtoaledgeraccountbeforetheautomaticmatchingprocedureisstart
ed.•PricedifferencewillbestoredinPriceDifferenceAccountdefinedinFinancialSupplierGroup27ReceiptofGoodsComplete(qty&invoicevalue=POreceipt)Su
pplierInvoiceQty$Qty$51205120Partial(qty&invoicevalue<>POreceipt)ReceiptofGoodsSupplierInvoiceQty$Qty$5120510051204
96TypesofMatches-Complete/PartialAccountsPayable28PartialCompleteBookingVarianceP.P.V.inIntegrationApproveInvoiceRegisterInvoiceMan
ualMatchNoVarianceAmountQuantityLineremainsopenTolerancesTypesofMatches-ManualAccountsPayable29PriceDifferenceTolerancesi)AutomaticMatchingTolerances
(setinAPParameters)•Decideswhetherautomaticmatchingispossible•Ifpricedifferenceisoutoftolerances,thenautomaticmatching
isnotpossible.Havetousemanualmatching(AsthereisnotolerancesdefinedinNC/SC,manualmatchingisused)•Ifpricedifferencefallswithintolerances,thenitwi
llbewrittentodefinedaccountinFinancialSupplierGroupAccountsPayableii)ToleratedPriceDifferenceperUser•Itindicatesthemaxpricediffere
nceandmaxpercentagedifferenceforeachinvoice.Thisallowsyoutospecifytheauthorizationswithregardstotheapprovalofpricedifferencewhenmat
chingreceiptsandpurchaseinvoice•Ifpricedifferencefallswithintolerances,thenitwillbechargedtoPPVaccountdefinedinIntegrationTransaction
•Ifpricedifferenceisoutoftolerances,auserwithhighertolerancemustapprovethepricedifferencein“ApprovePriceDifference”s
ession30GSSC[GlobalSharedServiceCenter]ServicesGuidelinesAccountsPayable•ActivitiestobeperformedbyGSSC•Processingof•InvoiceswithPur
chaseOrder•InvoiceswithIPR•Credit/Debitnotes•Intercoinvoices•Freightinvoices•Approvalofdiscrepantinvoices•Handlingvendorqueries•Performingreco
nciliation•Paymentpurgingandcoordinationwithbank•OutofScopeactivitiesforGSSC:•LocalRMBpurchases•Utilitypayment
sforelectricity,water,telephone,fax,gas,petrol&oil•Leaseandrentalpayments•ContractPayments•Insurance•Prepayment
/Advancepayments•Paymentforecasting31GSSCProcessingGuidelinesAccountsPayable•Transactioncodes&blockcodes•ProcessF
lows•Matchingofinvoices•Handlinginvoicediscrepancy•Processingcreditnotes•Processingdebitnotes•ProcessingNon-POinvoice•Process
ingfreightinvoice•AdvancePayments•PaymentProcess•Roundingofferrors•GLcodesandDimensions•Audit•Vendor
Queries•Reconciliations•Monthendactivities32TransactionType:AccountsPayableTransactionCodeDescriptionOIMPurchaseinvoicewithPOOINPurchaseinvoicewi
thoutPOOCMPurchasecreditnotewithPO/DebitnotewithPOissuedbysiteOCNPurchasecreditnotewithoutPO/DebitnotewithoutP
OissuedbysiteOICIntercoinvoiceOIFFreightinvoiceOCYReversalsofinvoices.OILLinkingcreditnotetoinvoice3
3FollowingblockcodeswillbeusedbyGSSCtohandlevariousinvoicediscrepancies:AccountsPayableBlockingCodeDescriptionAOCEANCARG
OBBLANKETPOREQUIRESADDITIONALDOLLARCINVOICECURRENCYDIFFERENTTHANPOCURRENCYDPOCLOSEDCOMPLETEEINVALIDPONUMBERFNEEDFREIGHTAUTHORIZATIONGMATERIA
LININSPECTION,PROVIDERECEIPTNUMBERORRMA#HQUANTITYDISCREPANCYIBURELEASEOFPYMTREQUIREDJPLEASEAPPROVEFORPAYMENTKNORECEIPTINSYSTEMLIN
VOICEU/MDIFFERSFROMPOU/MMNOPOPROVIDEDNPRICEDISCREPANCYOGOODRECEIPTONDIFFERENTSUPPLIERCODEPCANCELLATIONCHARGESAPP
ROVALREQUIREDQINVOICEPOBELONGSTODIFFERENTSUPPLIERRINVOICEITEM#DIFFTOPOITEM#STOOLINGPAYMENTAUTHRIZATIONREQUIREDTNOTREPLENISHMENTONINVOICE(VM
I)UWRONG/INCOMPLETETAXINFORMATIONVUNABLETOBEMATCHEDWNOPACKINGSLIP#REFERENCEDONINVOICEXNOCDFAVAILABLECNWAITINGFORCREDITNOTEEXPEM
P.EXPPENDINGAPAPPROVAL34BasicKnowledgeofAPProcessing(i)AccountsPayable•MatchingofInvoices:InvoicesarematchedmanuallytothePOlines.Packings
lipisusedasthebasisformatchingthelinesinthePO.(Deliveryorder#orInvoice#isalsousedtosubstitutethepackingslip#).Whereas,ifPOandInvoiceishavin
gasinglelineandthereferencegiveninPackingSlipfieldinBAANisnotmatchingthereferencegivenoninvoice,GSSCwilldothematchin
gsubjecttotheinvoicequantity&PoQuantityissame.IncaseofSOI/SMIvendors,replenishmentnumberisusedtodothemat
chingofinvoiceswithPO.•Handlinginvoicediscrepancy:Incaseofanydiscrepancywhilematching,theA/Pprocessorwouldassigntherelevantblockingcodebasedonthen
atureofdiscrepancy,followingwhichane-mailistriggeredtothebuyer/requestorfromtheworkflowpackage•InvalidPONumber:IfthePOnumberre
ferredoninvoiceisinvalidinBAAN,A/Pprocessorwillregistertheinvoiceandassignablockcode“E”,followingwhichane-maili
striggeredtothebuyerthroughworkflow.A/PprocessorwillidentifythebuyerbasedonthePart#/Itemcodegivenontheinvoice.Inca
se,ifA/Pprocessorisunabletoidentifythebuyer,workflowe-mailwillbesenttotheSinglePointofContactgivenintheKeycontact
list.•QuantityDiscrepancy:Incaseofaquantitydiscrepancyi.e.invoicequantitynotmatchingwithPOquantity,A/Pproces
sorwillregistertheinvoiceandassigntheblockingcode“H”followingwhichanemailistriggeredtothebuyerbytheworkflow•Noreceiptinsystem:IncasePOlin
esdoesnothavethereceiptstoperformmatching,theinvoicewillremaininregisteredstatusandA/Pprocessorwillblockwith“K”andbuyerisnotifiedth
roughane-mailfromworkflowpackage35BasicKnowledgeofAPProcessing(ii)AccountsPayable•PriceDiscrepancy:Incaseofafavo
rableorunfavorablepricediscrepancy,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“N”followingwhichanemailistriggeredtotherespe
ctiveBuyerbyworkflow•Packingslip#notreferredontheinvoice:Ifthereisnoreferenceofpackingslip#ontheinvoice,A/Pprocessorwillassignblockcod
e“W”,whichwilltriggerworkflowe-mailtothebuyer•ProcessingCreditNotes:Creditnotesareissuedbyvendoraswell
asthesite.Belowistheprocessfollowedforeachcategory•CreditNoteissuedforrebates:Ifacreditnoteisissueforrebates/discount
s,A/Pprocessorwillassignablockcode“J”andworkflowe-mailwilltriggertositefinanceforGL&Dimensions.Creditnoteissuedbyvendorisprocessedw
ithpaymenttermsas“NetImmediate”.•ProcessingDebitNotes:Creditnotesareissuedbyvendoraswellasthesite.Belowistheprocessfollowedforeachcategory•Processi
ngNon-POinvoice:A/PprocessorwillprocessNon-POinvoicesinBAANandassignablockcode“J”ande-mailwillbetriggeredtorequestorforverificationand
departmentmanagerforapproval.SiteFinancewillbeprovidingexcelsheettoGSSCwhichwillbehavingthelistofIPR#issued.Onrecei
ptofinvoices,GSSCwillupdatetheexcelsheetagainstIPR#listedandupdatethedetailsofinvoicebeingmatched.GSSCwillusetheGL
&DimensiondetailsprovidedagainsttheIPR#intheexcelsheet.Incase,theGL&Dimensionarenotgivenintheexcelsheet,GSSCwillassignabl
ockcodeandSiteFinancewillprovidethedetails.36BasicKnowledgeofAPProcessing(iii)AccountsPayable•ProcessingFreightinvoice:Freigh
tinvoiceswillbesenttositelogisticsbythevendor.Onreceiptofinvoices,freightinvoiceisverifiedbyshippingofficerandapprovalistakenfromShippingManager.Af
terapprovalSiteFinancewillprovideGL,CCcoding,thenscanandFTPtotheserver.ProcessoratGSSCwillaccesstheinvoicesinFr
eightQueueandprocessinBAAN.•AdditionalcostnotcoveredunderPO:Incaseanyadditionalcostsliketoolingchargesetcreferredoninvoice,butnotcover
edunderPO,A/Pprocessorwillassignablockcode“J”,andfollowingwhichane-mailistriggeredtothebuyerthroughworkflowforapproval.•AdvancePayments:Allre
questsforprepayment/advancepaymentswillbesenttoHKTreasury.Uponreceivingtherequest,HKTreasurywilldoapostingi
nBAANtoeffectthepaymentandupdateGSSC.GSSCneedstomonitorthevendoraccountandwhenthecorrespondinginvoiceismatched
shouldnotifyHKTreasurysothattreasurycanpurgetheinvoicesinBAAN.•DebitNoteissuedforPricediscrepancy:Ifadebitn
oteisissuedforpricediscrepancy,vendormustreferthedetailsoforiginalinvoiceonthedebitnote.Ifthediscrepancyamountofinvoicematcheswiththedebitnoteamount,
DebitNoteisbookedtoIPVaccount127100.In,theeventoriginalinvoiceisalreadypaid,A/Pprocessorwillassignablo
ckcode“J”ande-mailwilltriggertobuyerforverificationandapproval.Uponconfirmationfrombuyer,workflowe-mailwillbesenttositef
inanceforGL&Dimensions.37GSSCProcessingFlowsChart–Direct&IndirectAccountsPayablePROCESSINGOFPOINVOICES(Direct&Indirect)Do
cumentisanAPDocument?CorrectBaaNCompanyAInvoiceinProcessorDataEntryQueueYesNoMiscellaneousPaper(DuplicateInv
oices)NoNoNoYesRouteInvoicestoVendorMaintenanceQueueDiscrepancyMatchtheinvoicetoPOlinesinBaaNApproveInv
oiceYesYesResolutionbyVendorMaintenanceTeamatsiteInvoiceroutedtoFinalHoldQueue&ReadyforPaymentRescanQueueinW
orkflow(RescanningbyScanningTeam)ScanningProcessactivatedCorrectVendorexists?YesRegisterInvoiceResolutionTeammonitorsNon-KeyedQ
ueuedailyanddeletestheinvoiceonamonthlybasisNon-KeyedQueueinWorkflowYes38GSSCProcessingFlowsChartAccountsPayable39AccountsPayableTHEEND!!40Accoun
tsReceivableIndex•FinancialCustomerGroup•ProblemCodeandProblemReference•InvoicingfromARModule(Maintai
nTransactions)•AssigningCreditNotetoSalesInvoices•InvoicingfromARModule(InvoiceControl)•CorrectingSalesInvoices•OpenEntries•LabuanModel•ARClo
singProcessAR41Introduction&Overview•LogininBaansystem42LabuanSalesProcessing➢LabuanSales&ShipmentProcess➢ProceedingSalesinvoices➢Invoiceshallbebille
dtoLabuanfromDMateverymonthend➢POnumberiscorrectlyreflectedoninvoice➢ProgramtoensuretheSOquantitiesMUSTbelessorequaltocustomerP
O➢Programtoensurethesalespriceiscorrect,ifnotthencheckbackwithcustomer➢Financetodoubleverifythesalespriceiswhetherund
ertheproperrateforapplyingtothecustomexportdeclaration➢Bill&HoldShipmenttoFDICustomerPullMaterialsSalesOrderOutboundPrintPI
FaxPIBilltoBilltoFlexDMMBUStoreShippingLocalFinanceLabuanFDIHubEndCustomerShipmenttoendCustomerAccountsReceivable43CustomerInformatio
nCustomerStatusCurrencyTermsofPaymentOneTimeCustomerCreditLimitDefaultFin.CompBlockedSalesOrdersStatementMethodFin.CustomerGroupAccountsReceivabl
e44FinancialCustomerGroups(FCG)CustomerLedgerAccountsFinancialCustomerGroupAccountsReceivable45MaintainManualSalesInvoicesSalesModu
leDistributionGLProcessingMaintainTransactionsPrintManualSalesInvoicesPostManualSalesInvoicesInvoiceCont
rolAccountsReceivable46InventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=IssueDr:Goodstobeinvoiced(Uninvoic
edShipment)Cr:FGInventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=RevaluationDr
:WIPCr:PPVThistransactionisgeneratedifthegoodsissuingdateisearlierthanthedateofthelatestcostpriceupdateinItemDataA
ccountsReceivableARIntegrationProcessing:47AccountsReceivableARIntegrationProcessing(ii):TransactionTypebyTransact
ionOriginTransactionOrigin=SalesFinancialTransaction=SalesInvoice,TypeofSales=MaterialCostInv.Detail,OperationCostInv.De
tail,RevenuesInvoiceDetail,(InvoiceTotals),OrderDiscountInvoiceDetailAccountsMaterialCostsDr:CostofGoodsSold(COGS)Cr:Uninvoic
edShipmentDr.ARCr.SalesInterimDr:SalesInterimCr:Sales48AccountsReceivableAssigningCreditNotetoInvoices•Creditnotem
aybeassignedatthetimethecreditnoteisentered(usingOriginalInvoicefield)oratalaterdate•Assigningcreditnotewillreducetheamountoftheorigina
linvoices•Ifcreditnotesarenotassigned,theywillbeshownasnegativeamountinopenentries49Stepsinassigningsales
creditnotestoinvoice:MaintainTransactionsAssignCreditNotestoInvoiceIAssignCreditNotestoInvoiceIIMaintainDocumentNumbersSel
ectBatchesforFinalizationAccountsReceivable50InvoiceControlProcedureMaintainSalesInvoiceHeaderMaintainSalesInvoic
eLinesPrintSalesInvoicesPostSalesInvoicesSelectBatchesforFinalizationAccountsReceivable51AccountsReceivableI
nvoiceControl•InvoicingfromInvoiceControlwillproducewritteninvoice•Onlyusedfornon-inventoryitems-nolinktoinventorylevel•CategoryforTransactiontype=Sa
lesInvoice/SalesCN•InvoicescanbeprintedasProformaorFinalInvoice•SalesinvoicecanonlybepostedtoGLafterithasbeenprintedas“Fina
lInvoice”•PostingofFinalInvoicewillcreateabatchwhichthenhastobefinalized•Oncetheinvoiceisprintedas“FinalInvoi
ce”,theinvoicecannotbedeletedormodified•ItmaybecanceledbychangingthestatusfieldontheInvoiceHeaderfrom“open”tocanceled”
52AccountsReceivable•BaanProcessing•MaintainPriceItem•UpdateIntercosellingprice•ChangepriceandDiscount•Printsalesi
nvoice•Postsalesinvoices•PostIntegration•Finalizebatches53CorrectingSalesInvoices•Correctionscanbemadetoexistingfinalizedsalesinvoic
es•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•Correctionsmaynotbemadetoinvoiceswhichhavetra
nsactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable54Entries•Correctionscanbemade
toexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•Correctionsmaynotbemadetoinvoiceswhichhavetra
nsactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable55AccountsReceivableARMonthEndOperating&LabuanModelInvolvem
entofARinLabuanModel:Steps:1.MaintainPricesbyItem2.UpdateInter-InternalcompanySellingPrice3.PrintSale
sInvoicesProcessDeliveredSO4.PrintNon-FinalizedTransactions5.SelectBatchesforFinalizationARClosingOverview1.LabuanSales&MC
OSReportvs.LocalBook2.MCOSAnalysisReport56THEEND!!AccountsReceivable57FixedAssetSubjective&Scope•FixedAssetSt
ructure•FAMainGroup•FAGroup•FAMasterData•TransactionSchedule•RegistrationofFixedAsset•Depreciation•Depre
ciationMasterData•GroupDepreciationData•FADepreciationData•DisposalFA58FixedAsset•LogininBaansystem–FAHowtoregisteraFAanddealwiththedepreciat
ion&disposalinBaan…..???59FixedAssetsFixedAssetsBAANIVDTSP…AccountsReceivableAccountsPayableGeneralLedgerDim5Dim4Dim3Dim
2Dim160HowtoRegisterFixedAssets?PurchasebyCashPayment/BankPurchaseviaGL/AccountsPayablePurchaseInvoice:LedgerAccount➔IntegrationIndicator
IPR/ATRFixedAssets61TransactionScheduleTransactionType:•Investment•Disposal•Bookvalue•Depreciation•DepreciationCost
s•Revaluation•DepreciationAdjustment•ValueReduction•……..FixedAssetGroupFixedAssetDepr.CodeLedgerAccountsDimensionsThe
TransactionscheduleisusedtoprovidemappingforledgeraccountstobeusedwhenprocessingtransactionsFixedAssets•IFX•SIS62InvestmentMachine:PurchaseVal
ue:$100.00PostinginBaanFinance:DrFixedAssets100.00CrBank100.00FixedAssets63DepreciationSystemMethodofDepre
ciationBaseofDepreciationStart&EndofDepr.Fixed%BaseValueVariable%BaseValueSumoftheYear’sYearAnnuityFixedAmountNum
berofYearofUsePurchaseValueBookValueDateinUsePeriodafterDateinUsePeriodinUseSecondhalfinYearinUseFirstP
eriodYearinUseNextYear,FirstPeriodFirst/SecondhalfofYearDisposalOutofUseFixedAssets64UseLifeFAGroupDescriptionyearSalvageDepreciationMethod1
51BUILDING2510%Straightline152LEASEHOLDIMPROVEMENT1010%Straightline153MACHINE&EQUIPMENT710%Straightline154VEHICLES510%Straightline155OFFICEEQUIPMENT6
10%Straightline156TOOLS&FIXTURES210%Straightline157COMPUTEREQUIPMENT-ITEQUIP610%Straightline1532MACHINE&EQUIPMENT510%S
traightline1533MACHINE&EQUIPMENT20%Straightline1534MACHINE&EQUIPMENT30%Straightline1535MACHINE&EQUIPMENT40%Straight
line1552FURNITURE&FITTING610%Straightline1572COMPUTEREQUIPMENT-ITEQUIP610%Straightline1542VEHICLES(3yrs)310%Straightline1553F
URNITURE&FITTING(5yrs)510%Straightline1573COMPUTEREQUIPMENT-ITEQUIP(3yrs)310%Straightline1574COMPUTEREQUIPMENT-PROD.LINE(3yrs)31
0%Straightline155AOFFICEEQUIPMENT(3yrs)310%StraightlineFixedAssets65DepreciationLengthofDepreciation:10year100.00/10=10.00ayearPo
stinginBaanFinance:DrInterimAccountDepreciation10.00CrDepreciationMachine10.00DrDepreciationCosts10.00CrInterimAccountDe
preciation10.00FixedAssets66DisposalSalesInvoice:AccountsReceivable:EnterSalesInvoicePostTransactionstoFinanceFinalizeTransaction
sFixedAssets:FixedAssets67CaseofDisposal:PurchaseValue:100.00Depreciation:60.00BookValue:40.00SalesPrice:5
0.00Profit:10.00PostinginBaanFinance:DAccountsReceivable50.000CrFixedAssetSalesInterimAccount50.000DDepre
ciation60.000DGain/LossonDisposal/Bookvalue40.000CrInvestments(FA)100.000DFixedAssetInterimAccount50.000CrFixedAssetSalesRevenues50.000FixedAsset
s68CaseofDisposal:FixedAssets69HowtoPreparetheFAMonthlyReport?FixedAssets70THEEND!!FixedAssets71GeneralLedgerSubjective&Scope•ChartofAccount•D
imensionCode•TransactionType•TransactionProcessing•MaintainPeriod•MonthEndClosing•YearEndClosingGL72SFCShippi
ngPurchasingPlanningInventory……..FinancialStatementsFinancialBudgetsCostAccountsPayableAccountsReceivab
leGeneralLedgerCashManagementFixedAssetsOriginalTransactionPostingGeneralLedger73GeneralLedgerMasterDataTransactionTypes
GroupCompanyParametersG/LAccountsCompanyParametersPeriodsDimensionsTransactionSchedulesProtocolCodesSched
uleforAutomaticTransactionsCurrencyDifferenceGeneralLedger74OptionalSessionMaintainChartofAccountsMaintainDimensionsMaintainTransactionTypesM
aintainCurrencyDiff.LedgerAccountsMaintainRangesbyLedgerAccountMaintainLastUsedDoc.#byTrans.TypeMaintainTransac
tionSchedulesMaintainTransactionScheduleDetailsMaintainCompanyParametersMaintainGroupCompanyParametersMaintainPeriodsMaintai
nScheduleforAutomaticTransactionsGeneralLedgerSetUpGeneralLedger75•LogininBaansystem–GLHowtomaintainthechartofaccount,transactiontype,d
imensionandregisteravoucherinBaan…..???GeneralLedger76GeneralLedgerDimension–Whatarethey?•Userdefinablecategoriesthataresimilartosubledgers•
EachDimensiontypeismadeupofdimensioncodesDimensionCharacteristics•5typesofdimensions(Dim1–Dim5)•6positions-alphanumeric•Mandatory,OptionalorNotUse
dperledgeraccount77GeneralLedgerConditionsofDimensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•Mandato
rytoOptional•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistorytable)•Option
altoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhistorytable)78GeneralLedgerDimensionTypeismadeofthefollowingco
desGLDim1CustomerDim2ProductionLineDim3CostCenterDim4IntercomDim5Project79GeneralLedgerConditionsofDimensionsIfaledgeraccounthasabala
nceinhistory,thedimensionstatuscanonlybechangedfrom:•MandatorytoOptional•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealw
aysbeenusedandarepresentinGLhistorytable)•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhistorytable)80GeneralLedgerTransact
ionProcessingKeyPoints:•Batch•Collectionoffinancialtransactions•Abatchreferencecanbeenteredforeasyidentification•Abatchcanconta
inseveraltransactiontypes•Finalization•AprocessthatpostsentriestoGLOncetransactionsarefinalized,theycanlongerbemodifi
ed81GeneralLedgerPeriodDataThereare3typesofperiodsinBaan•FiscalPeriod–financialyear•ReportingPeriod–forr
eportingpurpose•TaxPeriod–fortaxreportingPeriodStatus•Open–Transactionscanbefinalizedtothisperiod•Closed–Tr
ansactionscannotbefinalizedtothisperiodbuttheperiodcanbere-open•FinallyClosed-Transactionscannotbefinalizedtothisperiod
andtheperiodcannotbere-openNote:•Periodscanbeindividuallyclosedforeachmodule•PeriodsofallmodulesmustbeclosedbeforeclosingGLmodule•GLmodulemustb
eopenedfirstbeforeothermodulescanbeopened82PostFinancialIntegrationTransactionsPrintIntegrationTransactionLogSelectBatchesforFinalizationMain
tainPeriodStatusClosePeriodsMonthEndCloseGeneralLedger83ChartofAccountsDimensionsGeneralLedgerTransactionTypesTransactionSchedulesAutomaticSchedu
lesPeriodsTransactionProcessingParametersSummary-TheGeneralLedgermoduleGeneralLedger84GeneralLedgerRegisterVoucherinGLModelCreateBatchSelect“JVM”Tra
nsactiontypePutGLCodeanddimensioncodeCreateRunnumberFinalizeBatchStep3Step1Step4Step2Step5Example:Dr.Salary$100Cr.SalaryPayable$10085Gene
ralLedgerCompliance•Allentitycontrollersareresponsibleforensuringthatallinter-companybalancesareproperlyrecorded
andreconciledatmonth-end.ICVWhatisaICV?•Inter-companyChargeVoucher,whichshouldbeincludingthefollowing:•Inter-CompanySales
(furtherdefinedbelow)•Royalty•Interestincomeand/orexpenseWhatcategoriesshouldbebilledviaaICV?•Inter-companyCh
argeVoucher,whichshouldbeincludingthefollowing:•TradeAP/AR…..(byusingGSHtolinkinter-companyinvoiceandJVMtobookgeneralsettlement)•Inter-co
mpanyContractualObligations&Loans•Inter-companyloans•Transferoffunds/cashotherthanloans•Servicecharge
swithanagreement•FixedAssetTransfer•Campusexpenseallocation…..86GeneralLedgerHowtoBookaICVunderLegalEntit
yMEPorSegmentMEP?Herewillbetakinganexampletoindicatetheprocess:Beforewetakingtheexample,weneedtoempha
sizethekeypointsasbelow•GL181597–MobilesegmenttoreconcilewithComputingsegment•GL183060–Computingsegmentt
oreconcilewithmobilesegment•GL181114–DMS131toreconcilewithmobilesegment•GL18XXXX–ComputingsegmenttoreconcilewithHK•ComputingMEPcode:PCB
A-DM-CMP-131•IfaICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandComputingDr.Expense–Mobile$60Dr.Expense–Computi
ng$40181597$40Cr.183060$40Cr.181114–HK$100•IfaICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandC
omputingDr.Expense–Computing$100Cr.18XXXX$10087GeneralLedgerB/SGLControlWe’llbecontrollingsomeB/Sledgersasattache
dandmonitoringthehistorybalance88THEEND!!GeneralLedger