【文档说明】PCBAComputingFinanceTraining_Tom_update1.pptx，共(88)页，4.907 MB，由精品优选上传

转载请保留链接：https://www.ichengzhen.cn/view-296052.html

以下为本文档部分文字说明：

PCBAComputingDoumen–BaanIVFinancialTraining17.Jan.07PresentedbyTom.Shen2FlexComputingCustomers3FinancialBaanIVTrainingWhatShould

webeOperatinginBaanIVNow?Let’shaveaquickoverview…….BaanIVOverview---BaanIV4Subjective&Scope•Introduction&Overview•Finan

cialIntegrationOverview&BaanStructure•IntegrationDefinition•AccountsPayable(Localvs.GSSC)•AccountsReceivable(Localvs.Labuan)•GeneralLedger(GLCode&Di

m)•FixedAsset•Costing•FinancialStatements•MasterDataSetUp•Parameter•ChartofAccount•TransactionType•IntegrationElement•Tran

sactionTypebyTransactionOriginal•Others(IPRSystem,OutlookSoft……)5Introduction&Overview•LogininBaansystem6

SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudgetsCostAccountsPayableAccountsReceivableGeneralLedgerCashM

anagementFixedAssetsFinancialIntegrationOverview&BaanStructure(i)OriginalTransactionPosting7InventorySalesProductionServiceTransactionOr

iginalTableFinancialIntegrationProgram•DetermineLedgerAccounts•DefineDimension•DefineFinancialTransactionTypeFinancialTra

nsactionTableGLAP/AR/FA/COST/….PurchaseIntegrationPostingBatchFinalizationFinancialIntegrationOverview&BaanStructure(ii

)8IntegrationIntroduction•Financialintegrationoccursasaresultofanactivitywhichoccursinanylogisticmoduleswhichafinancialtransactionmustber

ecorded•Examplesoflogisticactivities:*Receivinggoods*Deliveringgoodstocustomer*Revaluingthestandardcostofanitem•Oncesuchanactivityo

ccurs,informationneedstobesenttoFinance•Pre-definedmappingautomaticallyselectsappropriateledgeraccounts&dimensions9Integration

DefinitionTransactionOriginFinancialTransactionPurchaseProductionSales…….ReceiptIssueInvoice……..TransactionElementD

ateCustomerSupplierPart…….10TransactionTypeTransactionCategoryTypeDescriptionTransactionCategoryCurCDJCURRENCYDIFFERE

NCEJournalVouchersUSDCDPA/PCURRENCYDIFFERENCESPurchaseCorrectionsUSDCDSA/RCURRENCYDIFFERENCESSalesCorrectionsUSDDG1IND'L&COMMERCIA

LBANK-RMBCashRMBDJ1BANKOFCOMMUNICATIONS-RMBCashRMBDJ2BANKOFCOMMUNICATIONS-HK$CashHKDDJ3BANKOFCOMMUNICATIONS-US$C

ashUSDDPHPETTYCASH-HK$CashHKDDPRPETTYCASH-RMBCashRMBDPUPETTYCASH-USDCashUSDDZ1BANKOFCHINA-US$CashUSDDZ2BANKOFCHINA-RMBCashRMBDZ3BANK

OFCHINA-HK$CashHKDDZ4BANKOFCHINA-US$INVESTCashUSDDZ5BANKOFCHINA-HK$INVESTCashHKDGARADVANCERECEIPTSETTLEMENTCashRMBGNRNOTERECEIVABLERMBCash

RMBGSHGS:FLEXHKMFGCashUSDGSLGS:LABUAN4CashUSDIAPINTEG-PURCRECEIPTJournalVouchersUSDIARINTEG-SALESINVJournalVouche

rsUSDIFXINTEG-FIXEDASSETJournalVouchersUSDIIRINTEG-PROD.RECEIPT(INV)JournalVouchersUSDIPIINTEG-PRODISSUE(INV)

JournalVouchersUSDIPRINTEG-PRODRESULTJournalVouchersUSDIPVINTEG-PURCREVALUATIONJournalVouchersUSDIR2INTEG-PRODREVALUATIONJournalVouc

hersUSDIRRINTEG-PURCRESULTJournalVouchersUSDISRINTEG-SALESREVALUATIONJournalVouchersUSDIWAINTEG-INVA

DJUSTMENTJournalVouchersUSDIWRINTEG-INVREVALUATIONJournalVouchersUSDIWTINTEG-INVTRANSFERJournalVouchersUSDJ

VMJV-MULTIPLELINESJournalVouchersUSDPAPPURCINVAPPROVALPurchaseCorrectionsPIMPURINVMATCHINGPurchaseInv

oicesPINPURINV-NOMATCHPurchaseInvoicesSCNSALESCNSalesCreditNotesSISSALESINVOICESalesInvoices11AccountsPayableIndex•FinancialSupplierGroup•BlockingCo

desandBlockingReference•TermsofPayment•DueDateCalculationMethod•MiscellaneousPurchaseInvoice•AssignCNtoPurchaseInvoice•PurchaseInvoiceMatching

•AutomaticMatching•ManualMatching•Tolerance•SSCProcessandFlowChartAP12AccountsPayableAccountsReceivableCas

hManagementFixedAssetsGeneralLedgerAccountsPayable13AccountsPayableMasterDataAgingAnalysisFinancialSupplierGroupsAcc

ountsPayableParametersBlockingCodesBlockingReferencesAccountsPayable14AccountsPayable•LogininBaansystem–APModel•We’llbelea

rningthefollowingmodelsbylinkingtoBaaninlive15BlockingCodes:•Canbemaintainedin2levelswithlimitedtoappropriateenduserscompliancewithSOXre

quirement:a)Globally-ACPParameters-allregisteredinvoicesareautomaticallyblockedforpaymentprocessingb)Manually-MaintainPurcha

seInvoices•Abletopreventtheinclusioninbothautomaticpaymentprocessingandmanualadditiontopaymentadvicel

ist•Reasonsforblockinginvoicesmaybespecifiedinthedescriptionfield•BlockingCodescanberemovedinoneofthefollowingsessions:-Mainta

inPurchaseInvoices-MaintainPurchaseInvoiceDetailsAccountsPayable16AccountsPayableAblockingreferencem

aybeattachedtoablockingcode•Identifieswhohasblockedtheinvoice•Nameswhoisresponsibleforresolvingtheconflict•Maybecha

ngedwhenthecodeisassignedtoaninvoiceMaintainSupplierMasterFile•Vendorcode•Suppliernameandbilltoaddress•Paymenttermandcu

rrency•Bankmethod(T/T,L/C,COD…..)•Discount•ContactPerson17CustomerSupplierTermsofPaymentCalculationMethodPaymentDaysDiscountPe

riodsDiscountCalculationTimeFenceTermsofPaymentAccountsPayable•Howtocalculatepaymenttermeg.A30,N30,A60…….18AccountsPayableDueData

CalculationMethoda)Immediately-startwithinvoicedate(N30)-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:1/17/2007PaymentPeriod:30

daysDueDate:2/16/2007b)Endofmonth-startwiththelastdayofthemonthin(A15)whichtheinvoicedatebelongs-addnum

berofdaysspecifiedinpaymentperiodeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:15/2/2007c)PaymentPeriod-Paymentperiodisfi

rstaddedtotheinvoicedate,afterwhichtheresultingdateisshiftedtomonthendeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:30/1/

200719AccountsPayable•FenceforDueDateIfthefield“DueDateCalcMethod”hasthevalue“EndofMonth”,theduedatewillbeshi

ftedfromthisdaytotheendofnextmonth(notthecurrentmonth).Eg:DocumentDate:1/12/2006FenceforDueDate:15daysDueDate:30/1/2007•ToleranceforDiscPerce

ntage/Amount•Themaxpercentage/amountbywhichthecustomer/suppliermayexceedthediscountstatedinthetermsofpayment•Ifacus

tomer/suppliersubtractsalargerdiscountfromthepaymentthanisstatedinthetermsofpayment,thesystemwillissueawarning.20AccountsPayableInvoiceSample21Receip

tofGoodsPurchaseReceiptReceiveSupplierInvoicePaymenttoSupplierRegisterInvoiceMatchReceiptsApproveInvoiceWorkflowofMatchingSuppli

erInvoicestoPurchaseOrderReceiptsAccountsPayable22RegisteringanInvoiceInvoiceReceipt/AccruedAPSupplierControlAccount90.0090.00FromFinancialSup

plierGroup(FSG)AccountsPayable23ApprovalInvoiceReceipt/AccruedAPInvoicetobeRec’d/AccruedAPFromFinancialSupplierGroupReverseo

fPurchaseReversalofregistertransactionReceipt90.0084.006.00PurchasePriceVariance(PPV)MaintainInventoryandWIPPurchase/ResultDefinitionAccountsPaya

ble24SummaryInventoryInvoicetobeRec’dInvoicesReceiptA/PControlInvoicesReceiptInvoicetobeRec’d84.0084.0090.0090.0090.0084.00Inv&WIPFSGFSG/WIP(Receip

t)(Register)(Approval)PurchasePriceVariance6.00AccountsPayable25RegisterInvoiceAutomaticMatchCompletePric

eDiff.onFSGApproveInvoiceManualMatch$Receipt/$Invoice-ToleranceYesNoTypesofMatches-AutomaticNote:•As“TolerancesforAutomaticMatching”f

ieldinAPParameterisnotset,therewillnotbeanyautomaticmatching.•Manualmatchingwillbeused.AccountsPayable2

6AccountsPayableAutomaticMatching•AnautomaticmatchwillautomaticallymatchsupplierinvoicetothePOreceipt•Anautomaticmatchwillmatchcomp

letely•Completematch–thequantityandamountininvoiceisexactlythesameaswhathasbeenreceived•Ifpricedifferenceoccurs,thesedifferencewillbeassignedtoaledge

raccountbeforetheautomaticmatchingprocedureisstarted.•PricedifferencewillbestoredinPriceDifferenceAccountdefinedinFina

ncialSupplierGroup27ReceiptofGoodsComplete(qty&invoicevalue=POreceipt)SupplierInvoiceQty$Qty$51205120Partial(qty&invoic

evalue<>POreceipt)ReceiptofGoodsSupplierInvoiceQty$Qty$512051005120496TypesofMatches-Complete/PartialAccountsPayable28PartialCompleteBooki

ngVarianceP.P.V.inIntegrationApproveInvoiceRegisterInvoiceManualMatchNoVarianceAmountQuantityLineremainsopenTolerancesTypesofMatches-Manu

alAccountsPayable29PriceDifferenceTolerancesi)AutomaticMatchingTolerances(setinAPParameters)•Decideswhether

automaticmatchingispossible•Ifpricedifferenceisoutoftolerances,thenautomaticmatchingisnotpossible.Havetousemanu

almatching(AsthereisnotolerancesdefinedinNC/SC,manualmatchingisused)•Ifpricedifferencefallswithintole

rances,thenitwillbewrittentodefinedaccountinFinancialSupplierGroupAccountsPayableii)ToleratedPriceDifferenceperUser•Itindicatesthe

maxpricedifferenceandmaxpercentagedifferenceforeachinvoice.Thisallowsyoutospecifytheauthorizationswithregardstotheapprovalofpriced

ifferencewhenmatchingreceiptsandpurchaseinvoice•Ifpricedifferencefallswithintolerances,thenitwillbechargedtoPPVaccountdefinedinIntegrationT

ransaction•Ifpricedifferenceisoutoftolerances,auserwithhighertolerancemustapprovethepricedifferencein“ApprovePriceDifference”session30GSSC[G

lobalSharedServiceCenter]ServicesGuidelinesAccountsPayable•ActivitiestobeperformedbyGSSC•Processingof•InvoiceswithPurchaseOr

der•InvoiceswithIPR•Credit/Debitnotes•Intercoinvoices•Freightinvoices•Approvalofdiscrepantinvoices•Handlingvendorqueries•

Performingreconciliation•Paymentpurgingandcoordinationwithbank•OutofScopeactivitiesforGSSC:•LocalRMBpurchases•Utilitypaymentsforelectricity,wa

ter,telephone,fax,gas,petrol&oil•Leaseandrentalpayments•ContractPayments•Insurance•Prepayment/Advancepay

ments•Paymentforecasting31GSSCProcessingGuidelinesAccountsPayable•Transactioncodes&blockcodes•ProcessFlows

•Matchingofinvoices•Handlinginvoicediscrepancy•Processingcreditnotes•Processingdebitnotes•ProcessingNon-POinv

oice•Processingfreightinvoice•AdvancePayments•PaymentProcess•Roundingofferrors•GLcodesandDimensions•Audit•Ve

ndorQueries•Reconciliations•Monthendactivities32TransactionType:AccountsPayableTransactionCodeDescriptionOIMPurchaseinvoicewithPOOINPurchaseinvoice

withoutPOOCMPurchasecreditnotewithPO/DebitnotewithPOissuedbysiteOCNPurchasecreditnotewithoutPO/DebitnotewithoutPO

issuedbysiteOICIntercoinvoiceOIFFreightinvoiceOCYReversalsofinvoices.OILLinkingcreditnotetoinvoice33FollowingblockcodeswillbeusedbyGS

SCtohandlevariousinvoicediscrepancies:AccountsPayableBlockingCodeDescriptionAOCEANCARGOBBLANKETPOREQUIRESAD

DITIONALDOLLARCINVOICECURRENCYDIFFERENTTHANPOCURRENCYDPOCLOSEDCOMPLETEEINVALIDPONUMBERFNEEDFREIGHTAUTHORIZATIONGMATERIAL

ININSPECTION,PROVIDERECEIPTNUMBERORRMA#HQUANTITYDISCREPANCYIBURELEASEOFPYMTREQUIREDJPLEASEAPPROVEFORPAYMENTKNORECEIP

TINSYSTEMLINVOICEU/MDIFFERSFROMPOU/MMNOPOPROVIDEDNPRICEDISCREPANCYOGOODRECEIPTONDIFFERENTSUPPLIERCODEPCAN

CELLATIONCHARGESAPPROVALREQUIREDQINVOICEPOBELONGSTODIFFERENTSUPPLIERRINVOICEITEM#DIFFTOPOITEM#STOOLINGPAYMENTAUTHRIZATIONR

EQUIREDTNOTREPLENISHMENTONINVOICE(VMI)UWRONG/INCOMPLETETAXINFORMATIONVUNABLETOBEMATCHEDWNOPACKINGSLIP#REFERENCEDO

NINVOICEXNOCDFAVAILABLECNWAITINGFORCREDITNOTEEXPEMP.EXPPENDINGAPAPPROVAL34BasicKnowledgeofAPProcessing(i)AccountsPayable•M

atchingofInvoices:InvoicesarematchedmanuallytothePOlines.Packingslipisusedasthebasisformatchingthelin

esinthePO.(Deliveryorder#orInvoice#isalsousedtosubstitutethepackingslip#).Whereas,ifPOandInvoiceishavingasinglelineandthereferencegiveninPackingSlip

fieldinBAANisnotmatchingthereferencegivenoninvoice,GSSCwilldothematchingsubjecttotheinvoicequantity&PoQuantityissame.Incaseo

fSOI/SMIvendors,replenishmentnumberisusedtodothematchingofinvoiceswithPO.•Handlinginvoicediscrepancy:Incaseofanydiscrepancywhilematching,theA/P

processorwouldassigntherelevantblockingcodebasedonthenatureofdiscrepancy,followingwhichane-mailistriggeredtot

hebuyer/requestorfromtheworkflowpackage•InvalidPONumber:IfthePOnumberreferredoninvoiceisinvalidinBAAN,A/Pprocessorwil

lregistertheinvoiceandassignablockcode“E”,followingwhichane-mailistriggeredtothebuyerthroughworkflow.A/Pprocessorwillide

ntifythebuyerbasedonthePart#/Itemcodegivenontheinvoice.Incase,ifA/Pprocessorisunabletoidentifythebuyer,workflowe-mailwillbesenttotheSinglePo

intofContactgivenintheKeycontactlist.•QuantityDiscrepancy:Incaseofaquantitydiscrepancyi.e.invoicequantitynotmatchingwithPOquantity

,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“H”followingwhichanemailistriggeredtothebuyerbytheworkflow•Noreceiptinsyst

em:IncasePOlinesdoesnothavethereceiptstoperformmatching,theinvoicewillremaininregisteredstatusandA/Pprocessorwillblockwith“

K”andbuyerisnotifiedthroughane-mailfromworkflowpackage35BasicKnowledgeofAPProcessing(ii)AccountsPayable•PriceDiscrepancy:Incaseofafavorableorunfa

vorablepricediscrepancy,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“N”followingwhichane

mailistriggeredtotherespectiveBuyerbyworkflow•Packingslip#notreferredontheinvoice:Ifthereisnoreferenceofpackingslip#onth

einvoice,A/Pprocessorwillassignblockcode“W”,whichwilltriggerworkflowe-mailtothebuyer•ProcessingCreditNotes:Creditnotesareissuedbyvendoraswel

lasthesite.Belowistheprocessfollowedforeachcategory•CreditNoteissuedforrebates:Ifacreditnoteisissueforrebates/discounts,A/Pprocessorwillass

ignablockcode“J”andworkflowe-mailwilltriggertositefinanceforGL&Dimensions.Creditnoteissuedbyvendorisproce

ssedwithpaymenttermsas“NetImmediate”.•ProcessingDebitNotes:Creditnotesareissuedbyvendoraswellasthesite.Belowistheprocessfollowedforeachcategor

y•ProcessingNon-POinvoice:A/PprocessorwillprocessNon-POinvoicesinBAANandassignablockcode“J”ande-mailwillbetriggeredtorequestorforverificationan

ddepartmentmanagerforapproval.SiteFinancewillbeprovidingexcelsheettoGSSCwhichwillbehavingthelistofIPR#issued.Onreceiptofinvoices,GSSCwillupda

tetheexcelsheetagainstIPR#listedandupdatethedetailsofinvoicebeingmatched.GSSCwillusetheGL&Dimensiondet

ailsprovidedagainsttheIPR#intheexcelsheet.Incase,theGL&Dimensionarenotgivenintheexcelsheet,GSSCwillassignablockcodeandSiteFinancewillpro

videthedetails.36BasicKnowledgeofAPProcessing(iii)AccountsPayable•ProcessingFreightinvoice:Freightinvoiceswillbesentt

ositelogisticsbythevendor.Onreceiptofinvoices,freightinvoiceisverifiedbyshippingofficerandapprovalistakenfromShippin

gManager.AfterapprovalSiteFinancewillprovideGL,CCcoding,thenscanandFTPtotheserver.ProcessoratGSSCwillaccesstheinvoicesinFreightQueueandp

rocessinBAAN.•AdditionalcostnotcoveredunderPO:Incaseanyadditionalcostsliketoolingchargesetcreferredoninvoice,butnotcoveredunderPO,

A/Pprocessorwillassignablockcode“J”,andfollowingwhichane-mailistriggeredtothebuyerthroughworkflowforapproval.•AdvancePay

ments:Allrequestsforprepayment/advancepaymentswillbesenttoHKTreasury.Uponreceivingtherequest,HKTreasurywill

doapostinginBAANtoeffectthepaymentandupdateGSSC.GSSCneedstomonitorthevendoraccountandwhenthecorrespondinginvoiceismatch

edshouldnotifyHKTreasurysothattreasurycanpurgetheinvoicesinBAAN.•DebitNoteissuedforPricediscrepancy:Ifade

bitnoteisissuedforpricediscrepancy,vendormustreferthedetailsoforiginalinvoiceonthedebitnote.Ifthediscrepancyamountofinvoicematche

swiththedebitnoteamount,DebitNoteisbookedtoIPVaccount127100.In,theeventoriginalinvoiceisalreadypaid,A/Pprocessorwillassignablockcode“J”

ande-mailwilltriggertobuyerforverificationandapproval.Uponconfirmationfrombuyer,workflowe-mailwillbesenttositefinanceforGL&Dimensions.3

7GSSCProcessingFlowsChart–Direct&IndirectAccountsPayablePROCESSINGOFPOINVOICES(Direct&Indirect)Documentisa

nAPDocument?CorrectBaaNCompanyAInvoiceinProcessorDataEntryQueueYesNoMiscellaneousPaper(DuplicateInvoices)NoNoNoYesRouteIn

voicestoVendorMaintenanceQueueDiscrepancyMatchtheinvoicetoPOlinesinBaaNApproveInvoiceYesYesResolutionbyVendorMaintenanceTeamatsite

InvoiceroutedtoFinalHoldQueue&ReadyforPaymentRescanQueueinWorkflow(RescanningbyScanningTeam)ScanningP

rocessactivatedCorrectVendorexists?YesRegisterInvoiceResolutionTeammonitorsNon-KeyedQueuedailyanddeletestheinvoiceonamonthlyba

sisNon-KeyedQueueinWorkflowYes38GSSCProcessingFlowsChartAccountsPayable39AccountsPayableTHEEND!!40AccountsReceivableIndex•FinancialCustomerGrou

p•ProblemCodeandProblemReference•InvoicingfromARModule(MaintainTransactions)•AssigningCreditNotetoSalesInvoices•InvoicingfromAR

Module(InvoiceControl)•CorrectingSalesInvoices•OpenEntries•LabuanModel•ARClosingProcessAR41Introduction&Overview•LogininBaansystem42LabuanSalesProc

essing➢LabuanSales&ShipmentProcess➢ProceedingSalesinvoices➢InvoiceshallbebilledtoLabuanfromDMateverymonthend➢POnumberiscor

rectlyreflectedoninvoice➢ProgramtoensuretheSOquantitiesMUSTbelessorequaltocustomerPO➢Programtoensurethesalespriceiscorrect,if

notthencheckbackwithcustomer➢Financetodoubleverifythesalespriceiswhetherundertheproperrateforapplyingtothecustomexportdeclarati

on➢Bill&HoldShipmenttoFDICustomerPullMaterialsSalesOrderOutboundPrintPIFaxPIBilltoBilltoFlexDMMBUStoreShippingLocalFinance

LabuanFDIHubEndCustomerShipmenttoendCustomerAccountsReceivable43CustomerInformationCustomerStatusCurrencyTermsofPaymentOneTimeCustomerCred

itLimitDefaultFin.CompBlockedSalesOrdersStatementMethodFin.CustomerGroupAccountsReceivable44FinancialCustome

rGroups(FCG)CustomerLedgerAccountsFinancialCustomerGroupAccountsReceivable45MaintainManualSalesInvoicesS

alesModuleDistributionGLProcessingMaintainTransactionsPrintManualSalesInvoicesPostManualSalesInvoicesInvoiceControlAccountsReceivable46

InventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=IssueDr:Goodstobeinvoiced(Uni

nvoicedShipment)Cr:FGInventoryandWIPTransactionAccountsTransactionOrigin=SalesFinancialTransaction=Rev

aluationDr:WIPCr:PPVThistransactionisgeneratedifthegoodsissuingdateisearlierthanthedateofthelatestcostpriceupdateinItemDataAccountsReceivableAR

IntegrationProcessing:47AccountsReceivableARIntegrationProcessing(ii):TransactionTypebyTransactionOriginTransactionOrigin=Sales

FinancialTransaction=SalesInvoice,TypeofSales=MaterialCostInv.Detail,OperationCostInv.Detail,RevenuesInvoiceDetail,(InvoiceTotals),Orde

rDiscountInvoiceDetailAccountsMaterialCostsDr:CostofGoodsSold(COGS)Cr:UninvoicedShipmentDr.ARCr.SalesInterimDr:SalesInterimCr:Sales48Accoun

tsReceivableAssigningCreditNotetoInvoices•Creditnotemaybeassignedatthetimethecreditnoteisentered(usingOriginalInvoicefield)oratalaterdate•

Assigningcreditnotewillreducetheamountoftheoriginalinvoices•Ifcreditnotesarenotassigned,theywillbeshownasnegativeamountinopenentries49Stepsinas

signingsalescreditnotestoinvoice:MaintainTransactionsAssignCreditNotestoInvoiceIAssignCreditNotestoInvoiceIIMaintainDocumentNumbersSelectBatchesfor

FinalizationAccountsReceivable50InvoiceControlProcedureMaintainSalesInvoiceHeaderMaintainSalesInvoiceLinesPrintSalesInvoicesPostSale

sInvoicesSelectBatchesforFinalizationAccountsReceivable51AccountsReceivableInvoiceControl•InvoicingfromInvoiceControlwillproducewritteninvoice•Only

usedfornon-inventoryitems-nolinktoinventorylevel•CategoryforTransactiontype=SalesInvoice/SalesCN•Invoicescanbeprin

tedasProformaorFinalInvoice•SalesinvoicecanonlybepostedtoGLafterithasbeenprintedas“FinalInvoice”•PostingofFina

lInvoicewillcreateabatchwhichthenhastobefinalized•Oncetheinvoiceisprintedas“FinalInvoice”,theinvoicecannotbedeletedormo

dified•ItmaybecanceledbychangingthestatusfieldontheInvoiceHeaderfrom“open”tocanceled”52AccountsReceivable•BaanProcessing•Maint

ainPriceItem•UpdateIntercosellingprice•ChangepriceandDiscount•Printsalesinvoice•Postsalesinvoices•PostIntegration•Finalizebatches53Correct

ingSalesInvoices•Correctionscanbemadetoexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoi

cenumberortaxamount•Correctionsmaynotbemadetoinvoiceswhichhavetransactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymen

tAccountsReceivable54Entries•Correctionscanbemadetoexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•C

orrectionsmaynotbemadetoinvoiceswhichhavetransactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable55Ac

countsReceivableARMonthEndOperating&LabuanModelInvolvementofARinLabuanModel:Steps:1.MaintainPricesbyItem2.UpdateInter-InternalcompanySellingPrice3.P

rintSalesInvoicesProcessDeliveredSO4.PrintNon-FinalizedTransactions5.SelectBatchesforFinalizationARClosingOverview1.LabuanSales&MCO

SReportvs.LocalBook2.MCOSAnalysisReport56THEEND!!AccountsReceivable57FixedAssetSubjective&Scope•FixedAssetStructure•FAMainGroup

•FAGroup•FAMasterData•TransactionSchedule•RegistrationofFixedAsset•Depreciation•DepreciationMasterData•GroupDepreciationData•FADeprecia

tionData•DisposalFA58FixedAsset•LogininBaansystem–FAHowtoregisteraFAanddealwiththedepreciation&disposalinBaan…..??

?59FixedAssetsFixedAssetsBAANIVDTSP…AccountsReceivableAccountsPayableGeneralLedgerDim5Dim4Dim3Dim2Dim160HowtoRegisterFix

edAssets?PurchasebyCashPayment/BankPurchaseviaGL/AccountsPayablePurchaseInvoice:LedgerAccount➔IntegrationIndicatorIPR/ATRFixedAssets61Transactio

nScheduleTransactionType:•Investment•Disposal•Bookvalue•Depreciation•DepreciationCosts•Revaluation•DepreciationAdjustment•ValueReduction•……

..FixedAssetGroupFixedAssetDepr.CodeLedgerAccountsDimensionsTheTransactionscheduleisusedtoprovidemappingforledgeraccountstobeusedwhenprocessingtrans

actionsFixedAssets•IFX•SIS62InvestmentMachine:PurchaseValue:$100.00PostinginBaanFinance:DrFixedAssets100.00CrBank100.00FixedA

ssets63DepreciationSystemMethodofDepreciationBaseofDepreciationStart&EndofDepr.Fixed%BaseValueVariable%BaseValueSumoftheYear’sYearAn

nuityFixedAmountNumberofYearofUsePurchaseValueBookValueDateinUsePeriodafterDateinUsePeriodinUseSecondhalfinYearinUseFirstPerio

dYearinUseNextYear,FirstPeriodFirst/SecondhalfofYearDisposalOutofUseFixedAssets64UseLifeFAGroupDescriptionyearSalvageDepreciationMethod151BUILD

ING2510%Straightline152LEASEHOLDIMPROVEMENT1010%Straightline153MACHINE&EQUIPMENT710%Straightline154VEHICL

ES510%Straightline155OFFICEEQUIPMENT610%Straightline156TOOLS&FIXTURES210%Straightline157COMPUTEREQUIP

MENT-ITEQUIP610%Straightline1532MACHINE&EQUIPMENT510%Straightline1533MACHINE&EQUIPMENT20%Straightline1534

MACHINE&EQUIPMENT30%Straightline1535MACHINE&EQUIPMENT40%Straightline1552FURNITURE&FITTING610%Straightline157

2COMPUTEREQUIPMENT-ITEQUIP610%Straightline1542VEHICLES(3yrs)310%Straightline1553FURNITURE&FITTING(5yrs)510

%Straightline1573COMPUTEREQUIPMENT-ITEQUIP(3yrs)310%Straightline1574COMPUTEREQUIPMENT-PROD.LINE(3yrs)310%Straightline155AOFFICEEQUIPMENT(3yr

s)310%StraightlineFixedAssets65DepreciationLengthofDepreciation:10year100.00/10=10.00ayearPostinginBaanFinance:DrInterimAccountDep

reciation10.00CrDepreciationMachine10.00DrDepreciationCosts10.00CrInterimAccountDepreciation10.00FixedAssets66Disposa

lSalesInvoice:AccountsReceivable:EnterSalesInvoicePostTransactionstoFinanceFinalizeTransactionsFixedAssets:FixedAssets6

7CaseofDisposal:PurchaseValue:100.00Depreciation:60.00BookValue:40.00SalesPrice:50.00Profit:10.00PostinginBaanFinance:DAccountsRecei

vable50.000CrFixedAssetSalesInterimAccount50.000DDepreciation60.000DGain/LossonDisposal/Bookvalue40.000CrInvestmen

ts(FA)100.000DFixedAssetInterimAccount50.000CrFixedAssetSalesRevenues50.000FixedAssets68CaseofDisposal:FixedAssets69HowtoPreparetheFAMonthlyReport?

FixedAssets70THEEND!!FixedAssets71GeneralLedgerSubjective&Scope•ChartofAccount•DimensionCode•TransactionType•TransactionP

rocessing•MaintainPeriod•MonthEndClosing•YearEndClosingGL72SFCShippingPurchasingPlanningInventory……..Financ

ialStatementsFinancialBudgetsCostAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsOriginalTransactionPostingGenera

lLedger73GeneralLedgerMasterDataTransactionTypesGroupCompanyParametersG/LAccountsCompanyParametersPeriodsDimensionsTrans

actionSchedulesProtocolCodesScheduleforAutomaticTransactionsCurrencyDifferenceGeneralLedger74OptionalSessionMaintainChartofA

ccountsMaintainDimensionsMaintainTransactionTypesMaintainCurrencyDiff.LedgerAccountsMaintainRangesbyLedgerAccountMaintainLastUsedDoc.#byTran

s.TypeMaintainTransactionSchedulesMaintainTransactionScheduleDetailsMaintainCompanyParametersMaintainGroupCompanyParametersMaintai

nPeriodsMaintainScheduleforAutomaticTransactionsGeneralLedgerSetUpGeneralLedger75•LogininBaansystem–GLHowt

omaintainthechartofaccount,transactiontype,dimensionandregisteravoucherinBaan…..???GeneralLedger76GeneralLedgerDimension–Whatarethey?•U

serdefinablecategoriesthataresimilartosubledgers•EachDimensiontypeismadeupofdimensioncodesDimensionCharacteristics•5typesofdi

mensions(Dim1–Dim5)•6positions-alphanumeric•Mandatory,OptionalorNotUsedperledgeraccount77GeneralLedgerConditionsofDim

ensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•MandatorytoOption

al•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistorytable)•OptionaltoNotused(ifdimensionshaven

everbeenusedandarenotpresentinGLhistorytable)78GeneralLedgerDimensionTypeismadeofthefollowingcodesGLDim1CustomerDim2ProductionLi

neDim3CostCenterDim4IntercomDim5Project79GeneralLedgerConditionsofDimensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechanged

from:•MandatorytoOptional•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistorytable)

•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhistorytable)80GeneralLedgerTransactionProcessingKeyPoint

s:•Batch•Collectionoffinancialtransactions•Abatchreferencecanbeenteredforeasyidentification•Abatchcancontainseveraltransac

tiontypes•Finalization•AprocessthatpostsentriestoGLOncetransactionsarefinalized,theycanlongerbemodif

ied81GeneralLedgerPeriodDataThereare3typesofperiodsinBaan•FiscalPeriod–financialyear•ReportingPeriod–forreportingpurpose•TaxPe

riod–fortaxreportingPeriodStatus•Open–Transactionscanbefinalizedtothisperiod•Closed–Transactionscannotbefinali

zedtothisperiodbuttheperiodcanbere-open•FinallyClosed-Transactionscannotbefinalizedtothisperiodandtheperiodcannotbere-openNote:•Per

iodscanbeindividuallyclosedforeachmodule•PeriodsofallmodulesmustbeclosedbeforeclosingGLmodule•GLmodul

emustbeopenedfirstbeforeothermodulescanbeopened82PostFinancialIntegrationTransactionsPrintIntegrationTransactionLogSelectBatchesforFinali

zationMaintainPeriodStatusClosePeriodsMonthEndCloseGeneralLedger83ChartofAccountsDimensionsGeneralLedgerTransactionTypesTransactionSc

hedulesAutomaticSchedulesPeriodsTransactionProcessingParametersSummary-TheGeneralLedgermoduleGeneralLedger84GeneralLedgerRe

gisterVoucherinGLModelCreateBatchSelect“JVM”TransactiontypePutGLCodeanddimensioncodeCreateRunnumberFinalizeBatchStep3Step1Step4Step2Ste

p5Example:Dr.Salary$100Cr.SalaryPayable$10085GeneralLedgerCompliance•Allentitycontrollersareresponsibleforensuringthatallinter-companyb

alancesareproperlyrecordedandreconciledatmonth-end.ICVWhatisaICV?•Inter-companyChargeVoucher,whichshouldbeincludingthefollowing:•Inter-Com

panySales(furtherdefinedbelow)•Royalty•Interestincomeand/orexpenseWhatcategoriesshouldbebilledviaaICV?•Inter-companyChargeVoucher,whi

chshouldbeincludingthefollowing:•TradeAP/AR…..(byusingGSHtolinkinter-companyinvoiceandJVMtobookgeneralsettlement)•Inter-companyC

ontractualObligations&Loans•Inter-companyloans•Transferoffunds/cashotherthanloans•Servicechargeswithanagreement•FixedAssetTransfer•Campusexp

enseallocation…..86GeneralLedgerHowtoBookaICVunderLegalEntityMEPorSegmentMEP?Herewillbetakinganexampletoindicatetheprocess:Beforewetakingtheexample

,weneedtoemphasizethekeypointsasbelow•GL181597–MobilesegmenttoreconcilewithComputingsegment•GL183060–

Computingsegmenttoreconcilewithmobilesegment•GL181114–DMS131toreconcilewithmobilesegment•GL18XXXX–Compu

tingsegmenttoreconcilewithHK•ComputingMEPcode:PCBA-DM-CMP-131•IfaICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandComputingDr.E

xpense–Mobile$60Dr.Expense–Computing$40181597$40Cr.183060$40Cr.181114–HK$100•IfaICV($100)billedfromHKtoDMS131tochargethe

expensebothMobileandComputingDr.Expense–Computing$100Cr.18XXXX$10087GeneralLedgerB/SGLControlWe’llbecontrolling

someB/Sledgersasattachedandmonitoringthehistorybalance88THEEND!!GeneralLedger