【文档说明】PCBAComputingFinanceTraining_Tom_update1.pptx,共(88)页,4.907 MB,由精品优选上传
转载请保留链接:https://www.ichengzhen.cn/view-296052.html
以下为本文档部分文字说明:
PCBAComputingDoumen–BaanIVFinancialTraining17.Jan.07PresentedbyTom.Shen2FlexComputingCustomers3FinancialBaanIVTrainingWhatShouldwebeOper
atinginBaanIVNow?Let’shaveaquickoverview…….BaanIVOverview---BaanIV4Subjective&Scope•Introduction&Overview•FinancialIntegrati
onOverview&BaanStructure•IntegrationDefinition•AccountsPayable(Localvs.GSSC)•AccountsReceivable(Localvs.Labuan)•Gen
eralLedger(GLCode&Dim)•FixedAsset•Costing•FinancialStatements•MasterDataSetUp•Parameter•ChartofAccoun
t•TransactionType•IntegrationElement•TransactionTypebyTransactionOriginal•Others(IPRSystem,OutlookSoft……)5Intro
duction&Overview•LogininBaansystem6SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudget
sCostAccountsPayableAccountsReceivableGeneralLedgerCashManagementFixedAssetsFinancialIntegrationOverview&Baan
Structure(i)OriginalTransactionPosting7InventorySalesProductionServiceTransactionOriginalTableFinancialIntegrationProgram•Det
ermineLedgerAccounts•DefineDimension•DefineFinancialTransactionTypeFinancialTransactionTableGLAP/AR/FA/COST/….Purc
haseIntegrationPostingBatchFinalizationFinancialIntegrationOverview&BaanStructure(ii)8IntegrationIntroduction•Financialint
egrationoccursasaresultofanactivitywhichoccursinanylogisticmoduleswhichafinancialtransactionmustberecorded•Examplesoflogisticacti
vities:*Receivinggoods*Deliveringgoodstocustomer*Revaluingthestandardcostofanitem•Oncesuchanactivityoccurs
,informationneedstobesenttoFinance•Pre-definedmappingautomaticallyselectsappropriateledgeraccounts&dimensions9IntegrationDefinitionTran
sactionOriginFinancialTransactionPurchaseProductionSales…….ReceiptIssueInvoice……..TransactionElementDateCustomerSupplierPart…….10
TransactionTypeTransactionCategoryTypeDescriptionTransactionCategoryCurCDJCURRENCYDIFFERENCEJournalVoucher
sUSDCDPA/PCURRENCYDIFFERENCESPurchaseCorrectionsUSDCDSA/RCURRENCYDIFFERENCESSalesCorrectionsUSDDG1IND'L&COMMERCIALBANK-RMBCashRMBDJ1BANKOFCOMMUNIC
ATIONS-RMBCashRMBDJ2BANKOFCOMMUNICATIONS-HK$CashHKDDJ3BANKOFCOMMUNICATIONS-US$CashUSDDPHPETTYCASH-HK$CashHKDDPRPETTYCASH-RMBCashRMBDP
UPETTYCASH-USDCashUSDDZ1BANKOFCHINA-US$CashUSDDZ2BANKOFCHINA-RMBCashRMBDZ3BANKOFCHINA-HK$CashHKDDZ4BANKOFCHINA-US$INVESTCashUSDDZ5BANKOFCHI
NA-HK$INVESTCashHKDGARADVANCERECEIPTSETTLEMENTCashRMBGNRNOTERECEIVABLERMBCashRMBGSHGS:FLEXHKMFGCashUSDGSLGS:LABUAN4CashUSDIAPINTEG
-PURCRECEIPTJournalVouchersUSDIARINTEG-SALESINVJournalVouchersUSDIFXINTEG-FIXEDASSETJournalVouchersUSDIIRINT
EG-PROD.RECEIPT(INV)JournalVouchersUSDIPIINTEG-PRODISSUE(INV)JournalVouchersUSDIPRINTEG-PRODRESULTJournalVouchersUSDIPVINTEG
-PURCREVALUATIONJournalVouchersUSDIR2INTEG-PRODREVALUATIONJournalVouchersUSDIRRINTEG-PURCRESULTJournalVouchersUSDISRINT
EG-SALESREVALUATIONJournalVouchersUSDIWAINTEG-INVADJUSTMENTJournalVouchersUSDIWRINTEG-INVREVALUATIONJour
nalVouchersUSDIWTINTEG-INVTRANSFERJournalVouchersUSDJVMJV-MULTIPLELINESJournalVouchersUSDPAPPURCINVAPPROVALPurchase
CorrectionsPIMPURINVMATCHINGPurchaseInvoicesPINPURINV-NOMATCHPurchaseInvoicesSCNSALESCNSalesCreditNotesSISSALESINV
OICESalesInvoices11AccountsPayableIndex•FinancialSupplierGroup•BlockingCodesandBlockingReference•TermsofPayment•DueDateCalculationMethod•Misc
ellaneousPurchaseInvoice•AssignCNtoPurchaseInvoice•PurchaseInvoiceMatching•AutomaticMatching•ManualMatching•Tolerance•SSCProcessandFlowChartAP
12AccountsPayableAccountsReceivableCashManagementFixedAssetsGeneralLedgerAccountsPayable13AccountsPayableMasterDat
aAgingAnalysisFinancialSupplierGroupsAccountsPayableParametersBlockingCodesBlockingReferencesAccountsPayable14AccountsPayable•LogininBaansys
tem–APModel•We’llbelearningthefollowingmodelsbylinkingtoBaaninlive15BlockingCodes:•Canbemaintainedin2levelswithlimitedtoappropriateenduserscomplian
cewithSOXrequirement:a)Globally-ACPParameters-allregisteredinvoicesareautomaticallyblockedforpaymentprocessingb)Manually-MaintainPurchaseI
nvoices•Abletopreventtheinclusioninbothautomaticpaymentprocessingandmanualadditiontopaymentadvicelist•Reasonsforblockingi
nvoicesmaybespecifiedinthedescriptionfield•BlockingCodescanberemovedinoneofthefollowingsessions:-Maintain
PurchaseInvoices-MaintainPurchaseInvoiceDetailsAccountsPayable16AccountsPayableAblockingreferencemaybeatta
chedtoablockingcode•Identifieswhohasblockedtheinvoice•Nameswhoisresponsibleforresolvingtheconflict•Maybechangedwhenthecodeisassignedtoan
invoiceMaintainSupplierMasterFile•Vendorcode•Suppliernameandbilltoaddress•Paymenttermandcurrency•Bankmeth
od(T/T,L/C,COD…..)•Discount•ContactPerson17CustomerSupplierTermsofPaymentCalculationMethodPaymentDaysDiscountPeriodsDiscountCalculationTimeFenceTerm
sofPaymentAccountsPayable•Howtocalculatepaymenttermeg.A30,N30,A60…….18AccountsPayableDueDataCalculationMethoda)Immediate
ly-startwithinvoicedate(N30)-addnumberofdaysspecifiedinpaymentperiodeg:DocumentDate:1/17/2007PaymentPeriod:30daysDueDate:2/16/2007b)Endofmon
th-startwiththelastdayofthemonthin(A15)whichtheinvoicedatebelongs-addnumberofdaysspecifiedinpaymentperiode
g:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:15/2/2007c)PaymentPeriod-Paymentperiodisfirstaddedtotheinvoicedate,afterwhichtheresultingdateis
shiftedtomonthendeg:DocumentDate:20/1/2007PaymentPeriod:15daysDueDate:30/1/200719AccountsPayable•FenceforDueDateIfthefi
eld“DueDateCalcMethod”hasthevalue“EndofMonth”,theduedatewillbeshiftedfromthisdaytotheendofnextmonth(notthecurrentmonth).Eg:Documen
tDate:1/12/2006FenceforDueDate:15daysDueDate:30/1/2007•ToleranceforDiscPercentage/Amount•Themaxpercentage/amountbywhichthecustomer/suppl
iermayexceedthediscountstatedinthetermsofpayment•Ifacustomer/suppliersubtractsalargerdiscountfromthepaymentth
anisstatedinthetermsofpayment,thesystemwillissueawarning.20AccountsPayableInvoiceSample21ReceiptofGoodsPurchaseReceiptReceiveSupplier
InvoicePaymenttoSupplierRegisterInvoiceMatchReceiptsApproveInvoiceWorkflowofMatchingSupplierInvoicestoPurchaseOrderReceiptsAccountsPay
able22RegisteringanInvoiceInvoiceReceipt/AccruedAPSupplierControlAccount90.0090.00FromFinancialSupplierGroup(FSG)Accoun
tsPayable23ApprovalInvoiceReceipt/AccruedAPInvoicetobeRec’d/AccruedAPFromFinancialSupplierGroupReverseofPurchas
eReversalofregistertransactionReceipt90.0084.006.00PurchasePriceVariance(PPV)MaintainInventoryandWIPPurchase/ResultDe
finitionAccountsPayable24SummaryInventoryInvoicetobeRec’dInvoicesReceiptA/PControlInvoicesReceiptInvoicetobeRec’d84.0084.0090.0090.009
0.0084.00Inv&WIPFSGFSG/WIP(Receipt)(Register)(Approval)PurchasePriceVariance6.00AccountsPayable25RegisterInvoiceAutomaticMatchCompleteP
riceDiff.onFSGApproveInvoiceManualMatch$Receipt/$Invoice-ToleranceYesNoTypesofMatches-AutomaticNote:
•As“TolerancesforAutomaticMatching”fieldinAPParameterisnotset,therewillnotbeanyautomaticmatching.•Manualmatching
willbeused.AccountsPayable26AccountsPayableAutomaticMatching•Anautomaticmatchwillautomaticallymatchsupplierinvoice
tothePOreceipt•Anautomaticmatchwillmatchcompletely•Completematch–thequantityandamountininvoiceisexactlythe
sameaswhathasbeenreceived•Ifpricedifferenceoccurs,thesedifferencewillbeassignedtoaledgeraccountbeforetheau
tomaticmatchingprocedureisstarted.•PricedifferencewillbestoredinPriceDifferenceAccountdefinedinFinancialSuppli
erGroup27ReceiptofGoodsComplete(qty&invoicevalue=POreceipt)SupplierInvoiceQty$Qty$51205120Partial(qty&invoicevalue<>POreceipt)ReceiptofGoodsSup
plierInvoiceQty$Qty$512051005120496TypesofMatches-Complete/PartialAccountsPayable28PartialCompleteBoo
kingVarianceP.P.V.inIntegrationApproveInvoiceRegisterInvoiceManualMatchNoVarianceAmountQuantityLineremainsopenTolerancesTypesofMatches-M
anualAccountsPayable29PriceDifferenceTolerancesi)AutomaticMatchingTolerances(setinAPParameters)•Decideswhetherautomaticmatchingisp
ossible•Ifpricedifferenceisoutoftolerances,thenautomaticmatchingisnotpossible.Havetousemanualmatchin
g(AsthereisnotolerancesdefinedinNC/SC,manualmatchingisused)•Ifpricedifferencefallswithintolerances,thenitwillbewritt
entodefinedaccountinFinancialSupplierGroupAccountsPayableii)ToleratedPriceDifferenceperUser•Itindicatesthemaxpricedif
ferenceandmaxpercentagedifferenceforeachinvoice.Thisallowsyoutospecifytheauthorizationswithregardstotheapprov
alofpricedifferencewhenmatchingreceiptsandpurchaseinvoice•Ifpricedifferencefallswithintolerances,thenitwillbechargedtoPPVaccountdefinedinIntegr
ationTransaction•Ifpricedifferenceisoutoftolerances,auserwithhighertolerancemustapprovethepricedifferencein“ApprovePriceDifference”sessi
on30GSSC[GlobalSharedServiceCenter]ServicesGuidelinesAccountsPayable•ActivitiestobeperformedbyGSSC•Processingof•Invoiceswith
PurchaseOrder•InvoiceswithIPR•Credit/Debitnotes•Intercoinvoices•Freightinvoices•Approvalofdiscrepantinvoices•Handlingvend
orqueries•Performingreconciliation•Paymentpurgingandcoordinationwithbank•OutofScopeactivitiesforGSSC:•Local
RMBpurchases•Utilitypaymentsforelectricity,water,telephone,fax,gas,petrol&oil•Leaseandrentalpayments•ContractPayments•Insurance•Prepayment/Advance
payments•Paymentforecasting31GSSCProcessingGuidelinesAccountsPayable•Transactioncodes&blockcodes•ProcessFlows•Matchingofinvoices•Handlinginvoicedi
screpancy•Processingcreditnotes•Processingdebitnotes•ProcessingNon-POinvoice•Processingfreightinvoice•AdvanceP
ayments•PaymentProcess•Roundingofferrors•GLcodesandDimensions•Audit•VendorQueries•Reconciliations•Monthendactivities32Tr
ansactionType:AccountsPayableTransactionCodeDescriptionOIMPurchaseinvoicewithPOOINPurchaseinvoicewithoutPOOCMPurchasecreditnotew
ithPO/DebitnotewithPOissuedbysiteOCNPurchasecreditnotewithoutPO/DebitnotewithoutPOissuedbysiteOICIntercoinvoiceOIFFreightinvoiceOCYReversal
sofinvoices.OILLinkingcreditnotetoinvoice33FollowingblockcodeswillbeusedbyGSSCtohandlevariousinvoicediscrepancies:AccountsPayableBlo
ckingCodeDescriptionAOCEANCARGOBBLANKETPOREQUIRESADDITIONALDOLLARCINVOICECURRENCYDIFFERENTTHANPOCURRENCYDPOCLOSEDCOMPLETEEINVALIDP
ONUMBERFNEEDFREIGHTAUTHORIZATIONGMATERIALININSPECTION,PROVIDERECEIPTNUMBERORRMA#HQUANTITYDISCREPANCYIBURE
LEASEOFPYMTREQUIREDJPLEASEAPPROVEFORPAYMENTKNORECEIPTINSYSTEMLINVOICEU/MDIFFERSFROMPOU/MMNOPOPROVIDEDNPRICEDISCREPANCYOGOODRECEIPTON
DIFFERENTSUPPLIERCODEPCANCELLATIONCHARGESAPPROVALREQUIREDQINVOICEPOBELONGSTODIFFERENTSUPPLIERRINVOICEITEM#DIFFTOPOITEM#STOOLINGPAYMENTAUTHR
IZATIONREQUIREDTNOTREPLENISHMENTONINVOICE(VMI)UWRONG/INCOMPLETETAXINFORMATIONVUNABLETOBEMATCHEDWNOPACKING
SLIP#REFERENCEDONINVOICEXNOCDFAVAILABLECNWAITINGFORCREDITNOTEEXPEMP.EXPPENDINGAPAPPROVAL34BasicKnowledgeofAPProcessing(i)AccountsPayable•Matchingof
Invoices:InvoicesarematchedmanuallytothePOlines.PackingslipisusedasthebasisformatchingthelinesinthePO.(Deliveryo
rder#orInvoice#isalsousedtosubstitutethepackingslip#).Whereas,ifPOandInvoiceishavingasinglelineandthereferencegiveninPackingSlipfieldinBAA
Nisnotmatchingthereferencegivenoninvoice,GSSCwilldothematchingsubjecttotheinvoicequantity&PoQuantityiss
ame.IncaseofSOI/SMIvendors,replenishmentnumberisusedtodothematchingofinvoiceswithPO.•Handlinginvoicediscrepancy:Incaseofanydiscrepancywhilem
atching,theA/Pprocessorwouldassigntherelevantblockingcodebasedonthenatureofdiscrepancy,followingwhichan
e-mailistriggeredtothebuyer/requestorfromtheworkflowpackage•InvalidPONumber:IfthePOnumberreferredoninvoiceisinv
alidinBAAN,A/Pprocessorwillregistertheinvoiceandassignablockcode“E”,followingwhichane-mailistriggeredtothebuyerthr
oughworkflow.A/PprocessorwillidentifythebuyerbasedonthePart#/Itemcodegivenontheinvoice.Incase,ifA/Pprocessorisunabletoidentifythebuyer,workf
lowe-mailwillbesenttotheSinglePointofContactgivenintheKeycontactlist.•QuantityDiscrepancy:Incaseofaquantitydiscrepancyi.e.invoi
cequantitynotmatchingwithPOquantity,A/Pprocessorwillregistertheinvoiceandassigntheblockingcode“H”followingwhichanemailistriggeredtotheb
uyerbytheworkflow•Noreceiptinsystem:IncasePOlinesdoesnothavethereceiptstoperformmatching,theinvoicewillrema
ininregisteredstatusandA/Pprocessorwillblockwith“K”andbuyerisnotifiedthroughane-mailfromworkflowpackag
e35BasicKnowledgeofAPProcessing(ii)AccountsPayable•PriceDiscrepancy:Incaseofafavorableorunfavorablepricediscrepancy,A/Pprocessorwillregiste
rtheinvoiceandassigntheblockingcode“N”followingwhichanemailistriggeredtotherespectiveBuyerbyworkflow•Packingslip#notreferredont
heinvoice:Ifthereisnoreferenceofpackingslip#ontheinvoice,A/Pprocessorwillassignblockcode“W”,whichwilltriggerworkflowe-mailtothebuy
er•ProcessingCreditNotes:Creditnotesareissuedbyvendoraswellasthesite.Belowistheprocessfollowedforeachcat
egory•CreditNoteissuedforrebates:Ifacreditnoteisissueforrebates/discounts,A/Pprocessorwillassignablockcode“J”
andworkflowe-mailwilltriggertositefinanceforGL&Dimensions.Creditnoteissuedbyvendorisprocessedwithpayme
nttermsas“NetImmediate”.•ProcessingDebitNotes:Creditnotesareissuedbyvendoraswellasthesite.Belowistheprocessfollowedforea
chcategory•ProcessingNon-POinvoice:A/PprocessorwillprocessNon-POinvoicesinBAANandassignablockcode“J”ande-mailwillbetriggered
torequestorforverificationanddepartmentmanagerforapproval.SiteFinancewillbeprovidingexcelsheettoGSSCwhichwillb
ehavingthelistofIPR#issued.Onreceiptofinvoices,GSSCwillupdatetheexcelsheetagainstIPR#listedandupdatethedetailsofinvoicebeingmatched.GSSCwill
usetheGL&DimensiondetailsprovidedagainsttheIPR#intheexcelsheet.Incase,theGL&Dimensionarenotgivenintheexcelsheet,GSSCwillassignablockcodean
dSiteFinancewillprovidethedetails.36BasicKnowledgeofAPProcessing(iii)AccountsPayable•ProcessingFreightinvoice:Frei
ghtinvoiceswillbesenttositelogisticsbythevendor.Onreceiptofinvoices,freightinvoiceisverifiedbyshippingoffi
cerandapprovalistakenfromShippingManager.AfterapprovalSiteFinancewillprovideGL,CCcoding,thenscanandFTPtotheserver.ProcessoratGSSCwillaccessthe
invoicesinFreightQueueandprocessinBAAN.•AdditionalcostnotcoveredunderPO:Incaseanyadditionalcostsliketoolingchargesetcreferr
edoninvoice,butnotcoveredunderPO,A/Pprocessorwillassignablockcode“J”,andfollowingwhichane-mailistriggeredtothebuye
rthroughworkflowforapproval.•AdvancePayments:Allrequestsforprepayment/advancepaymentswillbesenttoHKTreasury.Uponreceivingth
erequest,HKTreasurywilldoapostinginBAANtoeffectthepaymentandupdateGSSC.GSSCneedstomonitorthevendoraccountandwhenthecorrespondinginvoiceismatche
dshouldnotifyHKTreasurysothattreasurycanpurgetheinvoicesinBAAN.•DebitNoteissuedforPricediscrepancy:Ifadebitnoteisissuedforpricediscrepancy,ve
ndormustreferthedetailsoforiginalinvoiceonthedebitnote.Ifthediscrepancyamountofinvoicematcheswiththe
debitnoteamount,DebitNoteisbookedtoIPVaccount127100.In,theeventoriginalinvoiceisalreadypaid,A/Pprocessorwillassignablockcode“J”ande
-mailwilltriggertobuyerforverificationandapproval.Uponconfirmationfrombuyer,workflowe-mailwillbesenttositefinanceforGL&Dimensions.37GSS
CProcessingFlowsChart–Direct&IndirectAccountsPayablePROCESSINGOFPOINVOICES(Direct&Indirect)DocumentisanAPDocument?CorrectBaaNC
ompanyAInvoiceinProcessorDataEntryQueueYesNoMiscellaneousPaper(DuplicateInvoices)NoNoNoYesRouteInvoicestoVendorMaintenan
ceQueueDiscrepancyMatchtheinvoicetoPOlinesinBaaNApproveInvoiceYesYesResolutionbyVendorMaintenanceTeamats
iteInvoiceroutedtoFinalHoldQueue&ReadyforPaymentRescanQueueinWorkflow(RescanningbyScanningTeam)ScanningProcessactivatedCorrectV
endorexists?YesRegisterInvoiceResolutionTeammonitorsNon-KeyedQueuedailyanddeletestheinvoiceonamonthlybasisNon-KeyedQueueinWorkflowYes38GSSCProc
essingFlowsChartAccountsPayable39AccountsPayableTHEEND!!40AccountsReceivableIndex•FinancialCustomerGroup•ProblemCodeandProblemReference•In
voicingfromARModule(MaintainTransactions)•AssigningCreditNotetoSalesInvoices•InvoicingfromARModule(InvoiceControl)•Correcting
SalesInvoices•OpenEntries•LabuanModel•ARClosingProcessAR41Introduction&Overview•LogininBaansystem42LabuanSalesProcessin
g➢LabuanSales&ShipmentProcess➢ProceedingSalesinvoices➢InvoiceshallbebilledtoLabuanfromDMateverymonthend➢POn
umberiscorrectlyreflectedoninvoice➢ProgramtoensuretheSOquantitiesMUSTbelessorequaltocustomerPO➢Programtoensurethesalespriceiscorrect,ifnotthencheck
backwithcustomer➢Financetodoubleverifythesalespriceiswhetherundertheproperrateforapplyingtothecustomexportdeclarati
on➢Bill&HoldShipmenttoFDICustomerPullMaterialsSalesOrderOutboundPrintPIFaxPIBilltoBilltoFlexDMMBUStoreShippingLocalFinanceLabuanFDIHubEndCustomerSh
ipmenttoendCustomerAccountsReceivable43CustomerInformationCustomerStatusCurrencyTermsofPaymentOneTimeCustome
rCreditLimitDefaultFin.CompBlockedSalesOrdersStatementMethodFin.CustomerGroupAccountsReceivable44FinancialCustomerGroups(FCG)Customer
LedgerAccountsFinancialCustomerGroupAccountsReceivable45MaintainManualSalesInvoicesSalesModuleDistrib
utionGLProcessingMaintainTransactionsPrintManualSalesInvoicesPostManualSalesInvoicesInvoiceControlAccountsReceivable46InventoryandWIPTransac
tionAccountsTransactionOrigin=SalesFinancialTransaction=IssueDr:Goodstobeinvoiced(UninvoicedShipment)Cr:FGInventoryandWIPTransactionAccoun
tsTransactionOrigin=SalesFinancialTransaction=RevaluationDr:WIPCr:PPVThistransactionisgeneratedifthegoodsissuingdate
isearlierthanthedateofthelatestcostpriceupdateinItemDataAccountsReceivableARIntegrationProcessing:47
AccountsReceivableARIntegrationProcessing(ii):TransactionTypebyTransactionOriginTransactionOrigin=SalesFinancialTransaction=SalesInvoice,
TypeofSales=MaterialCostInv.Detail,OperationCostInv.Detail,RevenuesInvoiceDetail,(InvoiceTotals),OrderDiscountInvoiceDetailAccountsMaterialCostsDr
:CostofGoodsSold(COGS)Cr:UninvoicedShipmentDr.ARCr.SalesInterimDr:SalesInterimCr:Sales48AccountsReceivableAssigningCreditNotetoInvoices•Creditn
otemaybeassignedatthetimethecreditnoteisentered(usingOriginalInvoicefield)oratalaterdate•Assigningcreditno
tewillreducetheamountoftheoriginalinvoices•Ifcreditnotesarenotassigned,theywillbeshownasnegativeamountinopenentries49Stepsinassigningsale
screditnotestoinvoice:MaintainTransactionsAssignCreditNotestoInvoiceIAssignCreditNotestoInvoiceIIMaintainDocumentNumbersSelectBatchesfor
FinalizationAccountsReceivable50InvoiceControlProcedureMaintainSalesInvoiceHeaderMaintainSalesInvoiceLinesPrintSalesInvoicesPostSalesInvoicesSelec
tBatchesforFinalizationAccountsReceivable51AccountsReceivableInvoiceControl•InvoicingfromInvoiceControlwillproducewritten
invoice•Onlyusedfornon-inventoryitems-nolinktoinventorylevel•CategoryforTransactiontype=SalesInvoice/SalesCN•InvoicescanbeprintedasProformaorFinalInv
oice•SalesinvoicecanonlybepostedtoGLafterithasbeenprintedas“FinalInvoice”•PostingofFinalInvoicewillcreateabatchwhichthenh
astobefinalized•Oncetheinvoiceisprintedas“FinalInvoice”,theinvoicecannotbedeletedormodified•Itmaybeca
nceledbychangingthestatusfieldontheInvoiceHeaderfrom“open”tocanceled”52AccountsReceivable•BaanProcessing•MaintainPriceItem•UpdateInte
rcosellingprice•ChangepriceandDiscount•Printsalesinvoice•Postsalesinvoices•PostIntegration•Finalizebatches53CorrectingSalesInvoices•Corre
ctionscanbemadetoexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberort
axamount•Correctionsmaynotbemadetoinvoiceswhichhavetransactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable54Entries•C
orrectionscanbemadetoexistingfinalizedsalesinvoices•Correctionsmaybemadetothecustomernumber,invoicenumberortaxamount•Correctionsmaynotbem
adetoinvoiceswhichhavetransactionslinkedtothemeg.alinkedsalesinvoiceorapartialpaymentAccountsReceivable55Accoun
tsReceivableARMonthEndOperating&LabuanModelInvolvementofARinLabuanModel:Steps:1.MaintainPricesbyItem2.UpdateInter-InternalcompanySellingP
rice3.PrintSalesInvoicesProcessDeliveredSO4.PrintNon-FinalizedTransactions5.SelectBatchesforFinalizationARClosingOv
erview1.LabuanSales&MCOSReportvs.LocalBook2.MCOSAnalysisReport56THEEND!!AccountsReceivable57FixedAssetSubjective&Sco
pe•FixedAssetStructure•FAMainGroup•FAGroup•FAMasterData•TransactionSchedule•RegistrationofFixedAsset•Depreciation•DepreciationMas
terData•GroupDepreciationData•FADepreciationData•DisposalFA58FixedAsset•LogininBaansystem–FAHowtoregisteraFAanddea
lwiththedepreciation&disposalinBaan…..???59FixedAssetsFixedAssetsBAANIVDTSP…AccountsReceivableAccountsPayab
leGeneralLedgerDim5Dim4Dim3Dim2Dim160HowtoRegisterFixedAssets?PurchasebyCashPayment/BankPurchaseviaGL/AccountsPaya
blePurchaseInvoice:LedgerAccount➔IntegrationIndicatorIPR/ATRFixedAssets61TransactionScheduleTransactionT
ype:•Investment•Disposal•Bookvalue•Depreciation•DepreciationCosts•Revaluation•DepreciationAdjustment•ValueReduction•……..FixedAss
etGroupFixedAssetDepr.CodeLedgerAccountsDimensionsTheTransactionscheduleisusedtoprovidemappingforledgeraccountstobeusedwhenprocessingtransac
tionsFixedAssets•IFX•SIS62InvestmentMachine:PurchaseValue:$100.00PostinginBaanFinance:DrFixedAssets100.00CrBank100.00FixedAssets63Dep
reciationSystemMethodofDepreciationBaseofDepreciationStart&EndofDepr.Fixed%BaseValueVariable%BaseValueSumoft
heYear’sYearAnnuityFixedAmountNumberofYearofUsePurchaseValueBookValueDateinUsePeriodafterDateinUsePeriodinUseSecondhalfinYearinUseFirstPeriodYeari
nUseNextYear,FirstPeriodFirst/SecondhalfofYearDisposalOutofUseFixedAssets64UseLifeFAGroupDescriptionye
arSalvageDepreciationMethod151BUILDING2510%Straightline152LEASEHOLDIMPROVEMENT1010%Straightline153MACHINE&EQUIPME
NT710%Straightline154VEHICLES510%Straightline155OFFICEEQUIPMENT610%Straightline156TOOLS&FIXTURES210%Straightline157COMPUTEREQUIPMENT-I
TEQUIP610%Straightline1532MACHINE&EQUIPMENT510%Straightline1533MACHINE&EQUIPMENT20%Straightline1534MACHINE&EQUIPMENT30%Straightli
ne1535MACHINE&EQUIPMENT40%Straightline1552FURNITURE&FITTING610%Straightline1572COMPUTEREQUIPMENT-ITEQUIP610%Straightline1542VEHICLES(3yrs)
310%Straightline1553FURNITURE&FITTING(5yrs)510%Straightline1573COMPUTEREQUIPMENT-ITEQUIP(3yrs)310%Straightline157
4COMPUTEREQUIPMENT-PROD.LINE(3yrs)310%Straightline155AOFFICEEQUIPMENT(3yrs)310%StraightlineFixedAssets65DepreciationLengthofDeprecia
tion:10year100.00/10=10.00ayearPostinginBaanFinance:DrInterimAccountDepreciation10.00CrDepreciationMachine10.0
0DrDepreciationCosts10.00CrInterimAccountDepreciation10.00FixedAssets66DisposalSalesInvoice:AccountsReceivable:EnterSalesInvo
icePostTransactionstoFinanceFinalizeTransactionsFixedAssets:FixedAssets67CaseofDisposal:PurchaseValue:100.00
Depreciation:60.00BookValue:40.00SalesPrice:50.00Profit:10.00PostinginBaanFinance:DAccountsReceivable50.000CrFixedAsset
SalesInterimAccount50.000DDepreciation60.000DGain/LossonDisposal/Bookvalue40.000CrInvestments(FA)100.000DFixed
AssetInterimAccount50.000CrFixedAssetSalesRevenues50.000FixedAssets68CaseofDisposal:FixedAssets69HowtoPreparetheFAMonthlyReport?FixedAssets70THE
END!!FixedAssets71GeneralLedgerSubjective&Scope•ChartofAccount•DimensionCode•TransactionType•TransactionProcessing•MaintainPerio
d•MonthEndClosing•YearEndClosingGL72SFCShippingPurchasingPlanningInventory……..FinancialStatementsFinancialBudgetsCostAccountsPayableAccount
sReceivableGeneralLedgerCashManagementFixedAssetsOriginalTransactionPostingGeneralLedger73GeneralLedgerMasterDataTransactionTypesGroupCompany
ParametersG/LAccountsCompanyParametersPeriodsDimensionsTransactionSchedulesProtocolCodesScheduleforAutomaticTransactionsCurrencyDifferenceG
eneralLedger74OptionalSessionMaintainChartofAccountsMaintainDimensionsMaintainTransactionTypesMaintainCurrencyDiff.LedgerAccountsMaintainRange
sbyLedgerAccountMaintainLastUsedDoc.#byTrans.TypeMaintainTransactionSchedulesMaintainTransactionScheduleDetailsMaintainCom
panyParametersMaintainGroupCompanyParametersMaintainPeriodsMaintainScheduleforAutomaticTransactionsGeneralLedgerSetUpGeneralLedger75
•LogininBaansystem–GLHowtomaintainthechartofaccount,transactiontype,dimensionandregisteravoucherinBaan…..???GeneralLedger76GeneralLedgerD
imension–Whatarethey?•Userdefinablecategoriesthataresimilartosubledgers•EachDimensiontypeismadeupofdime
nsioncodesDimensionCharacteristics•5typesofdimensions(Dim1–Dim5)•6positions-alphanumeric•Mandatory,OptionalorNotUsedperled
geraccount77GeneralLedgerConditionsofDimensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•Man
datorytoOptional•NotusedtoOptional•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistory
table)•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenotpresentinGLhistorytable)78GeneralLedgerDimensio
nTypeismadeofthefollowingcodesGLDim1CustomerDim2ProductionLineDim3CostCenterDim4IntercomDim5Project79GeneralLedgerConditionso
fDimensionsIfaledgeraccounthasabalanceinhistory,thedimensionstatuscanonlybechangedfrom:•MandatorytoOptional•NotusedtoOptional
•OptionaltoMandatory(ifdimensionshavealwaysbeenusedandarepresentinGLhistorytable)•OptionaltoNotused(ifdimensionshaveneverbeenusedandarenot
presentinGLhistorytable)80GeneralLedgerTransactionProcessingKeyPoints:•Batch•Collectionoffinancialtransactions•Abatchreferencecanbeente
redforeasyidentification•Abatchcancontainseveraltransactiontypes•Finalization•AprocessthatpostsentriestoGLOncetransactionsar
efinalized,theycanlongerbemodified81GeneralLedgerPeriodDataThereare3typesofperiodsinBaan•FiscalPeriod
–financialyear•ReportingPeriod–forreportingpurpose•TaxPeriod–fortaxreportingPeriodStatus•Open–Transactionscanbefinalizedtothisperiod•Closed–Transa
ctionscannotbefinalizedtothisperiodbuttheperiodcanbere-open•FinallyClosed-Transactionscannotbefinalizedtothisperiod
andtheperiodcannotbere-openNote:•Periodscanbeindividuallyclosedforeachmodule•PeriodsofallmodulesmustbeclosedbeforeclosingGLmodul
e•GLmodulemustbeopenedfirstbeforeothermodulescanbeopened82PostFinancialIntegrationTransactionsPrintIntegrationTransactionLogSelectBatchesforFi
nalizationMaintainPeriodStatusClosePeriodsMonthEndCloseGeneralLedger83ChartofAccountsDimensionsGeneralLedgerTransactionTypesTransactionSchedulesAu
tomaticSchedulesPeriodsTransactionProcessingParametersSummary-TheGeneralLedgermoduleGeneralLedger84GeneralLedgerRegisterVoucherinGLM
odelCreateBatchSelect“JVM”TransactiontypePutGLCodeanddimensioncodeCreateRunnumberFinalizeBatchStep3Step1Step4Step2Step5Example:Dr.Salary$100
Cr.SalaryPayable$10085GeneralLedgerCompliance•Allentitycontrollersareresponsibleforensuringthatallinter-companybalan
cesareproperlyrecordedandreconciledatmonth-end.ICVWhatisaICV?•Inter-companyChargeVoucher,whichshouldbei
ncludingthefollowing:•Inter-CompanySales(furtherdefinedbelow)•Royalty•Interestincomeand/orexpenseWhat
categoriesshouldbebilledviaaICV?•Inter-companyChargeVoucher,whichshouldbeincludingthefollowing:•TradeAP/AR…..(byusingGSHtol
inkinter-companyinvoiceandJVMtobookgeneralsettlement)•Inter-companyContractualObligations&Loans•Inter-companyloans•Transferoffun
ds/cashotherthanloans•Servicechargeswithanagreement•FixedAssetTransfer•Campusexpenseallocation…..86GeneralLedgerHowtoBoo
kaICVunderLegalEntityMEPorSegmentMEP?Herewillbetakinganexampletoindicatetheprocess:Beforewetakingtheexample,weneedtoemphasizethekeypointsasbelow•G
L181597–MobilesegmenttoreconcilewithComputingsegment•GL183060–Computingsegmenttoreconcilewithmobilesegment•GL181114–DMS131toreconcilewithmobiles
egment•GL18XXXX–ComputingsegmenttoreconcilewithHK•ComputingMEPcode:PCBA-DM-CMP-131•IfaICV($100)billedfromHKto
DMS131tochargetheexpensebothMobileandComputingDr.Expense–Mobile$60Dr.Expense–Computing$40181597$40Cr.183060$
40Cr.181114–HK$100•IfaICV($100)billedfromHKtoDMS131tochargetheexpensebothMobileandComputingDr.Expense–Computing$1
00Cr.18XXXX$10087GeneralLedgerB/SGLControlWe’llbecontrollingsomeB/Sledgersasattachedandmonitoringthehi
storybalance88THEEND!!GeneralLedger